DB_value claimed
    Updated 2024-06-15
    WITH w_price AS (
    SELECT
    RECORDED_HOUR AS hour,
    PRICE
    FROM
    osmosis.PRICE.EZ_PRICES
    WHERE
    symbol = 'WHALE'
    AND hour > CURRENT_DATE - 30
    ORDER BY
    1 DESC
    ),
    claimed AS (
    SELECT
    date_trunc(day, block_timestamp) AS day,
    COUNT(DISTINCT tx_id) AS claim_count,
    SUM(COUNT(DISTINCT tx_id)) OVER (ORDER BY day) AS cumulative_claims,
    SUM(amount) / 1000000 AS amount_claimed,
    SUM(SUM(amount) / 1000000) OVER (ORDER BY day) AS cumulative_amount
    FROM
    terra.core.ez_transfers
    WHERE
    sender = 'terra1xm0yh8cv8rww6g87h3q0megt6ntxqzw6p6hgh5l4jrhed4fe7hnq9cvzm5'
    AND day > CURRENT_DATE - 30
    GROUP BY
    1
    ORDER BY
    1 DESC
    )

    SELECT
    c.day,
    c.claim_count,
    c.cumulative_claims,
    c.amount_claimed,
    c.cumulative_amount,
    Auto-refreshes every 6 hours
    QueryRunArchived: QueryRun has been archived