Pmisha-bmlMdxdaily.claim
Updated 2022-05-07
9
1
2
3
4
5
6
7
8
›
⌄
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