flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Liquidity pools over time
SocioCrypto
Liquidity pools over time
Updated 2022-03-05
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
date_trunc
(
'day'
,
block_timestamp
)
as
date
,
pool_name
,
-- platform,
count
(
tx_id
)
FROM
ethereum
.
dex_swaps
WHERE
token_address
=
'0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198'
AND
direction
=
'OUT'
group
by
pool_name
,
date
Results
Run a query to Download Data