Pmisha-bmlMdxdaily.claim
    Updated 2022-05-07
    select
    date_trunc('day',block_timestamp) as dt,
    count(distinct EVENT_INPUTS:account) as total_account,
    sum(EVENT_INPUTS:amount/1e18) as total_amount
    from ethereum_core.fact_event_logs
    where contract_address = lower('0x1026cbed7b7E851426b959BC69dcC1bf5876512d') and EVENT_NAME = 'Claimed'
    and block_timestamp >= '2021-09-24'
    group by 1
    Run a query to Download Data