mboveiriHFT 1
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with users as
(select
date_trunc('hour',block_timestamp) as date,
origin_from_address as users,
raw_amount/1e18 as amount_claimed,
tx_hash
from ethereum.core.ez_token_transfers
where origin_to_address = lower('0x1A9a4d919943340B7E855E310489e16155F4ED29')
and contract_address = lower('0xb3999F658C0391d94A37f7FF328F3feC942BcADC')
and origin_function_signature = '0xeb4d6138' )
select
date,
count(users) as users_count,
count(tx_hash) as tx_count,
sum(amount_claimed) as amount
from users
group by 1
Run a query to Download Data