winnie-fsWHALE Claimers copy
    -- forked from 5a15a27f-99a3-4695-a956-5d576ea3b982

    select
    date_trunc('hour', block_timestamp) as date,
    count(distinct tx_id) as claim_count,
    sum(claim_count) over (order by date) as cumulative_claims,
    sum(amount)/1000000 as amount_claimed,
    sum(amount_claimed) over (order by date) as cumulative_amount

    from
    terra.core.ez_transfers
    where
    sender = 'terra1qdg94xw7vru5x57zf0gsjak7qzq46kptfm6y0s8ypsx3aqn9h7ts4p406e'
    group by 1
    order by 1 desc


    Run a query to Download Data