maybeyonasalgo_pump_claim_daily
    Updated 2022-05-25
    select
    date(block_timestamp) as date,
    count(tx_id) as claims,
    sum(asset_amount) as total_claimed
    from algorand.asset_transfer_transaction
    where asset_id = '725937713'
    and sender = 'ISSY3W2SLS3S5NHLUH3G77PH6SCBQ5ZTZ22ZCIPXGB26ESHYP32MELSMU4'
    and asset_sender = 'TBEADZIRZILX3NSCJJ7KMM3J6WG7OURERY45B2SCEKOGKSA4OZBD2NKIN4'
    group by 1
    -- where tx_id = 'X2PCSR7YNSKTEDBVNL6GBDWX2TL7HWWFJEJZEHOYPVC3ARY4XNMQ'
    Run a query to Download Data