crypto_edgarWallet Activity (in tokens)
Updated 2025-01-21
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
full_stepn_wallet_table as (
SELECT
*
FROM
solana.core.fact_transfers
WHERE
BLOCK_TIMESTAMP >= TIMESTAMP '2022-03-04'
AND (
TX_FROM = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
OR TX_TO = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
)
AND MINT IN (
'7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx',
'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
)
)
(
SELECT
SUM(AMOUNT) AS TOTAL_AMOUNT, DATE_TRUNC('DAY', BLOCK_TIMESTAMP) as DAY, 'OUT_GMT' AS TYPE
FROM
full_stepn_wallet_table
WHERE
TX_FROM = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
AND MINT = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
GROUP BY DAY
)
UNION
(
SELECT
SUM(AMOUNT) AS TOTAL_AMOUNT, DATE_TRUNC('DAY', BLOCK_TIMESTAMP) as DAY, 'OUT_GST' AS TYPE
FROM
full_stepn_wallet_table
WHERE
TX_FROM = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
AND MINT = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
QueryRunArchived: QueryRun has been archived