mboveiriCopy of Untitled Query
Updated 2022-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
⌄
select
--tx_hash,
origin_function_signature
--text_signature,
--sum(amount) as amount
--row_number() over (partition by origin_function_signature order by tx_hash) row_num
from ethereum.core.ez_token_transfers --join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
where to_address = '0x38b7bf4eecf3eb530b1529c9401fc37d2a71a912'
and contract_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
--group by 1
--qualify row_num = 1
limit 100
/*
0xea99c2a6 submit
0x46e04a2f claimTokens
0x6f4a2cd0 distributeRewards
*/
Run a query to Download Data