alitaslimiDaily Awarded Prizes
    Updated 2022-06-22
    WITH
    ethereum AS (
    SELECT
    block_timestamp::date AS date,
    COUNT(DISTINCT to_address) AS winners,
    SUM(amount) AS volume,
    AVG(amount) AS average_prize
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    date > (CURRENT_DATE - 60)
    AND contract_address = '0xdd4d117723c257cee402285d3acf218e9a8236e1' AND from_address = '0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe'
    GROUP BY
    date
    ),
    polygon AS (
    SELECT
    block_timestamp::date AS date,
    COUNT(DISTINCT event_inputs:to) AS winners,
    SUM(TO_NUMBER(event_inputs:value) / POW(10, 6)) AS volume,
    AVG(TO_NUMBER(event_inputs:value) / POW(10, 6)) AS average_prize
    FROM
    flipside_prod_db.polygon.events_emitted
    WHERE
    date > (CURRENT_DATE - 60)
    AND contract_address = '0x6a304dfdb9f808741244b6bfee65ca7b3b3a6076' AND event_inputs:from = '0x8141bcfbcee654c5de17c4e2b2af26b67f9b9056'
    GROUP BY
    date
    ),
    prices AS (
    SELECT
    hour::date AS date,
    AVG(price) AS price
    FROM
    ethereum.core.fact_hourly_token_prices
    WHERE
    Run a query to Download Data