gigiokobaweekly transfer rate tremp and horris
Updated 2024-08-08
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
›
⌄
⌄
WITH weekly_transfers AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS transfer_week,
COUNT(*) AS total_transfers
FROM
solana.core.fact_transfers
WHERE
mint = 'FU1q8vJpZNUrmqsciSjp8bAKKidGsLmouB8CBdf8TKQv'
AND amount > 0
GROUP BY
DATE_TRUNC('week', block_timestamp)
)
SELECT
'weekly' AS interval_type,
transfer_week AS interval,
total_transfers
FROM
weekly_transfers
ORDER BY
interval ASC;
WITH weekly_transfers AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS transfer_week,
COUNT(*) AS total_transfers
FROM
solana.core.fact_transfers
WHERE
mint = 'HnKkzR1YtFbUUxM6g3iVRS2RY68KHhGV7bNdfF1GCsJB'
AND amount > 0
GROUP BY
DATE_TRUNC('week', block_timestamp)
)
SELECT
QueryRunArchived: QueryRun has been archived