mamad-5XN3k3USD Volume Earned by Top 50 Airdrop Hunters copy
Updated 2024-01-05
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
›
⌄
with pricet as (
SELECT
HOUR::date as dates,
TOKEN_ADDRESS,
avg(price) as usd
from ethereum.price.ez_hourly_token_prices
group by 1,2
),
airdropt as (
select
distinct ORIGIN_FROM_ADDRESS as user ,
RAW_AMOUNT/pow(10,DECIMALS) as volume ,
(RAW_AMOUNT*1.3)/pow(10,DECIMALS) as usd_volume ,
BLOCK_TIMESTAMP ,
'Arbitrum' as Projects
from arbitrum.core.ez_token_transfers
WHERE ORIGIN_FUNCTION_SIGNATURE IN ('0x4e71d92d', '0x78e2b594')
AND ORIGIN_TO_ADDRESS = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
AND BLOCK_NUMBER >= 70506697
UNION
select
distinct ORIGIN_FROM_ADDRESS as user ,
RAW_AMOUNT/pow(10,18) as volume ,
(RAW_AMOUNT*1.44)/pow(10,18) as USD_volume ,
BLOCK_TIMESTAMP ,
'Optimism' as Projects
from optimism.core.fact_token_transfers t
where ORIGIN_TO_ADDRESS ='0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'
and FROM_ADDRESS ='0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
and ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'
UNION
QueryRunArchived: QueryRun has been archived