nsa2000General Metrics
Updated 2022-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- This code is thankfully burrowed from 0xHaM☰d: https://app.flipsidecrypto.com/dashboard/mTsqs0
select
1e9 as Total_Supply,
150000000 as Total_Dropped,
(Total_Dropped/Total_Supply) * 100 as Airdrop_Ratio,
count(distinct tx_hash) as Claim_TX_Cnt,
count(distinct origin_from_address) as Claimer_Cnt,
sum(event_inputs:value/1e18) as Claimed_Dropped_Vol,
(Claimed_Dropped_Vol / Total_Dropped)*100 as Claimed_Dropped_Ratio,
Total_Dropped - Claimed_Dropped_Vol as UnClaimed_Vol
from ethereum.core.fact_event_logs
where origin_to_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'
and event_name = 'Transfer'
and origin_function_signature = '0x48c54b9d'
and tx_status = 'SUCCESS'
limit 100
Run a query to Download Data