DAY | TOKEN_DEPOSITED | CNT_TX | CNT_WALLETS | TOKEN_AMOUNTS | TOTAL_WAGERED_USD | |
|---|---|---|---|---|---|---|
1 | 2024-10-29 00:00:00.000 | BONK | 177 | 131 | 377000000 | 8238.53 |
2 | 2024-10-25 00:00:00.000 | BONK | 97 | 70 | 239400002 | 5341.72504363 |
3 | 2025-01-10 00:00:00.000 | BONK | 1 | 1 | 100000 | 2.735 |
4 | 2024-10-23 00:00:00.000 | BONK | 71 | 52 | 140210345 | 3093.50500375 |
5 | 2024-11-04 00:00:00.000 | BONK | 101 | 83 | 338000001 | 6077.43001735 |
6 | 2024-11-15 00:00:00.000 | BONK | 32 | 22 | 117000000 | 4506.93 |
7 | 2024-12-15 00:00:00.000 | BONK | 196 | 109 | 574500208 | 20838.76496513 |
8 | 2024-12-10 00:00:00.000 | BONK | 271 | 173 | 607552000 | 22406.76676 |
9 | 2024-11-07 00:00:00.000 | BONK | 403 | 275 | 450002000 | 10010.10498 |
10 | 2024-11-11 00:00:00.000 | BONK | 308 | 205 | 613105377 | 15898.32906302 |
11 | 2024-11-28 00:00:00.000 | BONK | 374 | 199 | 556295000 | 23958.24665 |
12 | 2024-11-17 00:00:00.000 | BONK | 119 | 80 | 383011337 | 19626.02408224 |
13 | 2024-10-20 00:00:00.000 | BONK | 44 | 35 | 235010000 | 5523.2671 |
14 | 2024-12-10 00:00:00.000 | ACS | 1 | 1 | 1000 | 1.85687 |
15 | 2024-11-06 00:00:00.000 | BONK | 99 | 72 | 171100027 | 3758.48760881 |
16 | 2024-11-27 00:00:00.000 | BONK | 241 | 150 | 432000000 | 18535.64 |
17 | 2024-10-21 00:00:00.000 | BONK | 99 | 72 | 269040178 | 6363.50676318 |
18 | 2024-10-30 00:00:00.000 | BONK | 132 | 99 | 572000000 | 12475.75 |
19 | 2024-10-17 00:00:00.000 | BONK | 47 | 35 | 75000000 | 1725.33 |
20 | 2025-01-03 00:00:00.000 | BONK | 1 | 1 | 1 | 0.00003158 |
0xsloaneMoonwalk - Over time broken down by token
Updated 2024-12-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 moonwalk_txs AS (
SELECT fe.tx_id
, signers[0] AS signer
, DATE_TRUNC('hour', fe.block_timestamp) AS date_hour
FROM solana.core.fact_events fe
WHERE program_id = 'FitAFk15vtx2PBjfr7QTnefaHRx6HwajRiZMt1DdSSKU'
AND block_timestamp::DATE BETWEEN DATEADD(day, -{{days_to_look_back}}, current_date()) AND current_date() - 1
AND succeeded
),
get_tx_info AS (
SELECT m.tx_id
, m.date_hour
, ft.tx_from
, ft.tx_to
, ft.amount
, ft.mint
FROM moonwalk_txs m
INNER JOIN solana.core.fact_transfers ft
ON m.tx_id = ft.tx_id
AND m.signer = ft.tx_from
AND block_timestamp::DATE BETWEEN DATEADD(day, -{{days_to_look_back}}, current_date()) AND current_date() - 1
),
tx_level AS (
SELECT g.tx_id
, g.date_hour
, g.tx_from AS user_wallet
, g.tx_to
, g.mint
, pr.symbol
, g.amount AS token_amount_units
, g.amount * COALESCE(tph_cg.close, tph_cmc.close) AS token_amount_converted_usd
FROM get_tx_info g
INNER JOIN solana.price.ez_asset_metadata pr
ON g.mint = pr.token_address
INNER JOIN solana.core.dim_tokens dt
ON g.mint = dt.token_address
Last run: 3 months ago
78
5KB
907s