crypto_edgarmockJUP - Generic Stats
    Updated 2024-01-25
    with airdrop_claims as (
    SELECT
    TX_ID
    from
    solana.core.fact_events
    where
    succeeded
    and block_timestamp >= '2024-01-15'
    and program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
    ),
    claims_as_transfers as (
    SELECT
    *
    from
    solana.core.fact_transfers
    where
    block_timestamp >= '2024-01-15'
    and mint = 'JxxWsvm9jHt4ah7DT9NuLyVLYZcZLUdPD93PcPQ71Ka'
    and TX_ID IN (
    SELECT
    TX_ID
    FROM
    airdrop_claims
    )
    )
    select
    COUNT(DISTINCT TX_TO) as NR_WALLETS_CLAIMED,
    SUM(AMOUNT) AS TOTAL_MOCKJUP_CLAIMED
    from
    claims_as_transfers
    where
    amount != '2e-7'
    Last run: about 1 year ago
    NR_WALLETS_CLAIMED
    TOTAL_MOCKJUP_CLAIMED
    1
    701121752462250
    1
    20B
    36s