Questions tagged [dune-analytics]

How to cast uint256 to varchar in DuneSQL? Here is an example query Here is an output Error: Line 36:11: Cannot cast array(uint256) to uint256 at line 36, position 11 [Execution ID: 01H8J5X9M7BKXB59N0ZFYS4F7J] #dune

I am trying to write a query to calculate total transaction fees paid in USD. For that I am writing the below query but somehow join messes things up. SELECT date_trunc('minute',block_time), hash, (gas_used*gas_price/1e18) as…

I've been playing around with Dune Analytics but can't seem to get this to work! I've managed to filter a wallet to display the transactions showing the number of tokens sold and the corresponding BNB received (it was working before I started…

Could someone please write me an SQL script to extract the total number of transactions for the top 5 Layer 1 (L1) chains of all time, as well as for the period from January 2022 to June 2023, using either Flipside Analytics or Dune Analytics?