Abbas_ra21Top 50 Hunters by Claimed Airdrops copy
Updated 2023-07-10
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from mamad-5XN3k3 / Top 50 Hunters by Claimed Airdrops @ https://flipsidecrypto.xyz/mamad-5XN3k3/q/9RAWAYJBeNpd/top-50-hunters-by-claimed-airdrops
-- forked from Lordking / Top Hunters @ https://flipsidecrypto.xyz/Lordking/q/nOIzouA2K8dH/top-hunters
with
airdropt as (
select distinct
FROM_ADDRESS as user,
TX_JSON:receipt:logs[0]:decoded:inputs:value / pow(10, 18) as volume,
TX_JSON:receipt:logs[0]:decoded:inputs:value / pow(10, 18) as USD,
BLOCK_TIMESTAMP,
'Arbitrum' as Projects
from
arbitrum.core.fact_transactions
WHERE
ORIGIN_FUNCTION_SIGNATURE IN ('0x4e71d92d', '0x78e2b594')
AND TO_ADDRESS = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
AND BLOCK_NUMBER >= 70506697
AND STATUS = 'SUCCESS'
UNION
select distinct
ORIGIN_FROM_ADDRESS as user,
RAW_AMOUNT / pow(10, 18) as volume,
RAW_AMOUNT / pow(10, 18) as USD,
BLOCK_TIMESTAMP,
'Optimism' as Projects
from
optimism.core.fact_token_transfers
where
ORIGIN_TO_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'
and FROM_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
and ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef'
UNION
select distinct
ORIGIN_FROM_ADDRESS as user,
RAW_AMOUNT / pow(10, DECIMALS) as volume,
AMOUNT_USD as USD,
Run a query to Download Data