dan-smith2023-11-10 10:30 AM
Updated 2023-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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