andurilUntitled Query
    Updated 2022-08-15

    /*
    select date(block_timestamp) as date,
    count(distinct tx_hash) as txs
    from ethereum.core.ez_nft_sales
    where date between '2022-07-01' and '2022-07-31'
    group by 1


    select
    date(block_timestamp) as date,
    avg(gas_price) as avg_gas
    from
    ethereum.core.fact_transactions
    where
    date(block_timestamp) between '2022-07-01' and '2022-07-31'
    group by date


    */

    --26.87683574



    select
    date_trunc(month,block_timestamp) as month,
    count(distinct tx_hash) as txs
    from
    ethereum.core.fact_transactions
    where
    date(block_timestamp) >= '2022-01-01'
    --and status = 'SUCCESS'
    group by month


    Run a query to Download Data