Pine AnalyticsLayer zero Airdrop 1 copy
Updated 2024-10-03
99
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
›
⌄
-- forked from Layer zero Airdrop 1 @ https://flipsidecrypto.xyz/edit/queries/c94a5519-630a-464b-983f-2fba2115e993
SELECT
CASE when amount < 10 then 'a/ Below 10'
when amount < 100 then 'b/ 10-100'
when amount < 1000 then 'c/ 100-1K'
when amount < 10000 then 'd/ 1K-10K'
else 'e/ 10K+' end as Airdrop_size_group,
count(*) as users,
sum(amount) as claim_volume
--from_address,
--count(DISTINCT to_address)
FROM arbitrum.core.ez_token_transfers
WHERE CONTRACT_ADDRESS LIKE lower('0x6985884C4392D348587B19cb9eAAf157F13271cd')
AND from_address LIKE lower('0xd6b6a6701303B5Ea36fa0eDf7389b562d8F894DB')
--LIMIT 1000
--GROUP BY 1
--ORDER BY 2 DESC
GROUP BY 1 --,2
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived