nitsTop Gas Guzzlers past month (Original)
    Updated 2022-07-24
    SELECT * from
    (SELECT *,
    row_number() over (partition by day order by cum_fees desc ) as rn
    from
    (SELECT date(block_timestamp) as day, tx_receiver, count(*) as total_txs, sum(transaction_fee)/pow(10,24) as fee, sum(fee) over (partition by tx_receiver order by day) as cum_fees
    from near.core.fact_transactions
    where day >= CURRENT_DATE - 30
    GROUP by 1 , 2 ))
    where rn < 11
    -- ORDER by 3 desc
    -- limit 10
    Run a query to Download Data