nsa2000General Metrics
    Updated 2022-12-08
    -- 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