flipside

    $Blast Airdrop Claims Status
    rezarwz$Blast Airdrop Claims Status
    Updated 2024-12-09
    with all_claims as (
    SELECT
    tx.TX_HASH,
    tx.block_timestamp as block_timestamp,
    tr.to_Address as ua,
    RAW_AMOUNT/pow(10,18) as amount
    FROM
    blast.core.fact_transactions tx
    INNER join blast.core.fact_token_transfers tr on tx.tx_hash = tr.tx_hash
    and tr.contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')
    and tx.to_Address = '0xf7be503166828fe8565c520d66645ac6a06bbdd7'
    and tx.ORIGIN_FUNCTION_SIGNATURE != '0xca1d209d'
    WHERE
    tx.status = 'SUCCESS'
    )
    SELECT
    count(DISTINCT ua) as "# of of Addresses Claimed",
    (count(DISTINCT ua) / 10000) * 100 "% of Total Addresses Claimed",
    sum(AMOUNT) as "Total Claimed $Blast",
    (sum(amount) / 15000000000) * 100 as "% of Total Claimed $Blast"
    from
    all_claims
    QueryRunArchived: QueryRun has been archived