dan-smith2023-11-10 10:30 AM
    Updated 2023-11-22
    WITH dates AS (
    SELECT
    DATEADD(DAY, ROW_NUMBER() OVER (ORDER BY CURRENT_DATE()), TIMESTAMP '2018-09-10') AS dt
    FROM
    TABLE(GENERATOR(ROWCOUNT => 1 + DATEDIFF(DAY, TIMESTAMP '2018-09-10', CURRENT_DATE())));
    )

    SELECT
    blocktimestamp, DECODED_LOG:newRatio / 1e6 AS value
    FROM ethereum.core.fact_decoded_event_logs
    WHERE CONTRACT_ADDRESS = lower('0xbAFA44EFE7901E04E39Dad13167D089C559c1138')
    AND event_name = 'WithholdRatioSet'
    Run a query to Download Data