Tobi_12024-06-07 07:56 PM
Updated 2024-06-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,
FEE AS transaction_fee,
COUNT(*) AS transaction_count
FROM
solana.core.fact_transactions;
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP())
GROUP BY
transaction_date,
transaction_fee
ORDER BY
transaction_date,
transaction_fee;
QueryRunArchived: QueryRun has been archived