nitsLiquidity Pools Leaving MIM
Updated 2022-02-11
9
1
2
3
4
›
⌄
SELECT date(block_timestamp) as day, count(*) as total_txs_in_this_direction, sum(amount_usd) as total_amt, count(DISTINCT from_address) as unique_senders , count(DISTINCT to_address) as unique_receivers ,count(*) as total_txs, COUNT(DISTINCT pool_name) as distinct_pools from ethereum.dex_swaps
where token_address = '0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3' and date(block_timestamp)> CURRENT_DATE -60 and direction = 'OUT'
GROUP by 1
limit 1000
Run a query to Download Data