flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
q1.swap.away
Pmisha-bmlMdx
q1.swap.away
Updated 2022-02-26
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
Select
s
.
swap_from_mint
,
b
.
label
,
count
(
tx_id
)
as
numberswap
From
Solana
.
swaps
s
LEFT
OUTER
JOIN
Solana
.
labels
b
ON
s
.
swap_from_mint
=
b
.
address
Where
block_timestamp
::
date
>=
'2022-02-01'
And
succeeded
=
'True'
Group
by
1
,
2
order
by
3
desc
limit
10
Results
Run a query to Download Data