zakkisyedENS airdrop claimed vs ENS price daily
    Updated 2021-12-13
    WITH claim_tx AS (
    SELECT DISTINCT tx_id,
    block_timestamp,
    tx_id,
    contract_address,
    to_address,
    amount/1e18 as amount1,
    amount_usd/1e18 as amount2
    FROM ethereum.udm_events
    WHERE contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
    AND event_name = 'transfer'
    AND block_timestamp > current_date - 45
    AND tx_id IN (SELECT DISTINCT
    tx_id
    FROM ethereum.udm_events
    WHERE contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
    AND event_name = 'Claim')
    )

    SELECT SUM(amount1) AS ens_claimed, sum(amount2) as claim_amt_usd, date_trunc('day', block_timestamp), claim_amt_usd/ens_claimed as ENS_price
    --SUM (amount) / 1e18 / 25000000 * 100 AS ens_claimed_percent
    FROM claim_tx

    group by block_timestamp
    order by 3 ASC

    Run a query to Download Data