SniperTotal daily volume LUNC transfer with cumulative number of transfers since 2022-05-01
    Updated 2022-10-07
    select
    date_trunc('day',block_timestamp) as day,
    count (distinct tx_id) as total_tx,
    sum (event_amount) as total_Amount,
    sum(total_tx) over (order by day) as cum_tx
    from terra.classic.ez_transfers
    where tx_status = 'SUCCEEDED'
    and event_currency = 'LUNA'
    and block_timestamp >= '2022-05-01'
    and event_amount > 0
    group by 1
    Run a query to Download Data