0xDDd48DC4b52BBE9C6a03f7e3053959Aca0f7ab7bTxns Analysis copy
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Jor-el / Txns Analysis @ https://flipsidecrypto.xyz/Jor-el/q/VFYTQUaTaPr5/txns-analysis
WITH last_30_days AS (
SELECT
COUNT(DISTINCT tx_id) AS total_transactions,
SUM(fee) AS total_fees
FROM
solana.core.fact_transactions
WHERE
block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP()) AND
block_timestamp < CURRENT_TIMESTAMP() AND
succeeded = TRUE
),
previous_30_days AS (
SELECT
COUNT(DISTINCT tx_id) AS total_transactions
FROM
solana.core.fact_transactions
WHERE
block_timestamp >= DATEADD(day, -60, CURRENT_TIMESTAMP()) AND
block_timestamp < DATEADD(day, -30, CURRENT_TIMESTAMP()) AND
succeeded = TRUE
),
weekly_transactions AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week_start,
COUNT(DISTINCT tx_id) AS weekly_transactions
FROM
solana.core.fact_transactions
WHERE
block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP()) AND
block_timestamp < CURRENT_TIMESTAMP() AND
succeeded = TRUE
GROUP BY
DATE_TRUNC('week', block_timestamp)
),
Run a query to Download Data