freemartian2024-03-13 08:31 PM
Updated 2024-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
-- select
-- date_trunc('hour',timestamp) AS hour,
-- (CASE
-- WHEN timestamp < '2024-03-13 14:00:00.000' THEN 'Before Dencun'
-- WHEN timestamp >= '2024-03-13 14:00:00.000' THEN 'After Dencun'
-- END
-- ) AS label,
-- AVG(actual_fee/pow(10,18)) avg_l2_fee,
-- SUM(actual_fee/pow(10,18)) AS layer2_fee,
-- count(DISTINCT tx_hash) AS transactions
-- FROM external.tokenflow_starknet.decoded_transactions
-- WHERE timestamp BETWEEN
-- DATEADD(hour, -timestampdiff('hour', '2024-03-13 14:00:00.000', current_timestamp), '2024-03-13 14:00:00.000')
-- AND
-- DATEADD(hour, timestampdiff('hour', '2024-03-13 14:00:00.000', current_timestamp), '2024-03-13 14:00:00.000')
-- GROUP BY 1,2
SELECT max(timestamp)
FROM external.tokenflow_starknet.decoded_transactions
QueryRunArchived: QueryRun has been archived