ElBALCX Claims by Wallet
    Updated 2021-10-04
    WITH claims as (
    SELECT
    to_address as user_address,
    min(block_timestamp) as claim_first,
    max(block_timestamp) as claim_last,
    count(tx_id) as claim_num,
    sum(amount_usd) as claim_amt_usd,
    sum(amount) as claim_amt_alcx
    from ethereum.udm_events
    where from_address = '0x0000000000000000000000000000000000000000' -- mint
    and contract_address = '0xdbdb4d16eda451d0503b854cf79d55697f90c8df' -- alcx
    and origin_function_name = 'claim'
    and block_timestamp > '2021-02-21'
    group by 1
    )

    SELECT *
    from claims
    order by claim_amt_alcx desc

    /*
    date_trunc('hour',etx.block_timestamp) as block_hour,
    count(distinct user_address) as n_claimers,
    count(distinct etx.tx_id) as n_claims,
    sum(amount_usd) as total_amount_claimed_usd,
    median(amount_usd) as median_amount_claimed,
    median(gas_price) / 1e9 as median_gwei,
    median(fee_usd) as median_fee_usd,
    median_amount_claimed / median_fee_usd as claim_to_fee_ratio
    FROM ethereum.transactions etx
    JOIN claims
    ON claims.tx_id = etx.tx_id
    WHERE etx.block_timestamp > '2021-02-21'
    AND fee_usd > 0
    GROUP BY 1
    ORDER BY 1 DESC
    Run a query to Download Data