zakkisyed2023-06-07 10:00 PM
Updated 2023-06-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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