alleria[Pool Together] Prizes Frequency
    Updated 2022-06-21
    WITH claims as (
    SELECT
    event_inputs:value / POW(10,6) as PTaUSDC_claimed,
    ROUND(event_inputs:value / POW(10,6)) as rounded_PTaUSDC_claimed,
    *
    FROM ethereum.core.fact_event_logs
    WHERE origin_to_address = '0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe'
    AND contract_address = '0xdd4d117723c257cee402285d3acf218e9a8236e1'
    AND event_name = 'Transfer'
    AND tx_status = 'SUCCESS'
    AND date(block_timestamp) > CURRENT_DATE - 61
    )

    SELECT
    rounded_PTaUSDC_claimed,
    COUNT(1) as number_of_claims
    FROM claims
    GROUP BY rounded_PTaUSDC_claimed

    Run a query to Download Data