LTirrellgenesis_airdrop_claims_pylon
    Updated 2021-10-04
    WITH L_Airdrops AS (
    select
    distinct date_trunc('week', m.block_timestamp) as date,
    m.tx_id,
    m.msg_value : contract :: string AS contract,
    m.msg_value : sender :: string AS sender,
    m.msg_value : execute_msg : claim : amount / POW(10, 6) AS token_amount,
    m.msg_value : execute_msg : claim : stage AS stage
    from
    terra.msgs m
    where
    m.msg_value : execute_msg : claim is not null
    and m.tx_status = 'SUCCEEDED'
    and stage = 1
    and m.msg_value : contract :: string = 'terra1ud39n6c42hmtp2z0qmy8svsk7z3zmdkxzfwcf2'
    )
    select
    date,
    count(tx_id),
    sum(token_amount)
    from
    L_airdrops
    group by
    date
    order by
    date
    Run a query to Download Data