ADDRESS | ADDRESS_NAME | |
---|---|---|
1 | 3LfHzbwohxdqFqwU4injRUQZdYMWfocMY77UwCEbwZJv | binance deposit_wallet |
2 | 2DStCx88HGLZdAcRgKuWGuhwobPmMZZkfgro8yA3NS5P | kucoin deposit_wallet |
3 | 3x4FuhKvE3PVifJ2wq7xSHYit6snmViP9vJyAV935HoP | coinbase deposit_wallet |
4 | 8DBAKNA8qnzbZKpqFKfXJcGGQzvFdVrXdpyTh8MpxBsa | swissborg deposit_wallet |
5 | Gcutfz5iEjfCoqeePkYk5JMV8z5WdTwmiWrdAMMhUSiv | kucoin deposit_wallet |
6 | UGNmLxqjF1qQ1psbtKZXRUSWkUYZw6w5pph7QxoZKFV | kucoin deposit_wallet |
7 | 4Rw9VR6CwH1YWyTvzHKkL3XryzxusW6BAX2BmbnaDo71 | gate.io deposit_wallet |
8 | 4bYFdh2mg6Mh8dduw3eZv1YgJDHAXLvqzF4ySq3tHV9F | coinbase deposit_wallet |
9 | GKkTJsZk9wTwhxPMDhGAK35WZDTRBZpcmQNW8dTWMzgK | crypto.com deposit_wallet |
10 | 6jDNe4EcdYYBDCZrb7nxaz3BwnVwnHAkvdwykYgHPE5k | coinbase deposit_wallet |
bobby_danielmodest-silver
Updated 2025-04-02
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 labels as (
Select
Address,
Address_name,
From solana.core.dim_labels
),
swap_raw as (
Select
BLOCK_TIMESTAMP::date as day,
SWAP_PROGRAM,
TX_ID,
SWAPPER,
SWAP_FROM_AMOUNT,
SWAP_FROM_MINT,
l.address_name as swap_from_mint_name,
SWAP_TO_AMOUNT,
SWAP_TO_MINT,
m.address_name as swap_to_mint_name,
case when Swap_from_mint = 'So11111111111111111111111111111111111111112' then 'Sold'
when swap_to_mint = 'So11111111111111111111111111111111111111112' then 'Bought' end as category
From solana.defi.fact_swaps s
Left Join labels l on l.address = s.SWAP_FROM_MINT
Left Join labels m on m.address = s.SWAP_TO_MINT
Where
Block_timestamp >= '2025-03-01'
AND SUCCEEDED = 'TRUE'
AND ( SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112' or SWAP_TO_MINT = 'So11111111111111111111111111111111111111112' )
Group by all
)
Select
day,
category
From swap_raw
Limit 10
Last run: 2 months ago
10
745B
2s