Updated 2023-02-12
    -- terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr mdao
    --terra1sjgx7q6mx9e5jjg8dcm498w7reuzufghqvucc8d7d3ad4z2fra4q9l574a terra finder
    select
    count(*) as number , sum (AMOUNT/ 1e6) as volume, date_trunc('day', block_timestamp) as date ,
    sum(volume) over (order by date) as cvolume ,
    sum(number) over (order by date) as cnumber
    from
    terra.core.ez_transfers

    where
    SENDER='terra1sjgx7q6mx9e5jjg8dcm498w7reuzufghqvucc8d7d3ad4z2fra4q9l574a'
    group by date

    Run a query to Download Data