zakkisyed2023-06-07 10:00 PM
    Updated 2023-06-07
    SELECT
    BLOCK_TIMESTAMP,
    CASE
    WHEN BLOCK_TIMESTAMP >= '2022-10-29'
    THEN CONCAT('Generation ', 1001 + FLOOR(DATEDIFF(SECOND, '2022-10-29', BLOCK_TIMESTAMP) / 1209600))
    END AS Generation,
    tx_hash,
    contract_address,
    event_name,
    decoded_log:_numberOfRecipients as numberOfRecipients,
    decoded_log:_randomInflationReward/pow(10,18) as randomInflationReward,
    decoded_log:trusteeAddress as trusteeAddress

    FROM ethereum.core.fact_decoded_event_logs
    WHERE
    full_decoded_log iLIKE '%random%' AND full_decoded_log iLIKE '%inflation%'
    AND decoded_log:_randomInflationReward > 0
    Run a query to Download Data