boomer77top 10 pool by first 24 hrs swap vol
Updated 2022-02-03
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
doge as (select pool_name, sum(from_amount_usd) as "24hrs Vol"
from thorchain.swaps
where pool_name = 'DOGE.DOGE' and block_timestamp <= '2022-01-18 01:25:21.951'
group by 1),
usdc as (select pool_name, sum(from_amount_usd) as "24hrs Vol"
from thorchain.swaps
where pool_name = 'ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' and block_timestamp <= '2021-05-07 06:40:55.488'
group by 1),
btc as (select pool_name, sum(from_amount_usd) as "24hrs Vol"
from thorchain.swaps
where pool_name = 'BTC.BTC' and block_timestamp <= '2021-04-12 09:46:16.317'
group by 1),
ltc as (select pool_name, sum(from_amount_usd) as "24hrs Vol"
from thorchain.swaps
where pool_name = 'LTC.LTC' and block_timestamp <= '2021-04-12 11:09:42.489'
group by 1),
eth as (select pool_name, sum(from_amount_usd) as "24hrs Vol"
from thorchain.swaps
where pool_name = 'ETH.ETH' and block_timestamp <= '2021-04-12 09:43:20.446'
group by 1),
bnbeth as (select pool_name, sum(from_amount_usd) as "24hrs Vol"
from thorchain.swaps
where pool_name = 'BNB.ETH-1C9' and block_timestamp <= '2021-04-17 20:59:38.933'
group by 1),
bnbbtc as (select pool_name, sum(from_amount_usd) as "24hrs Vol"
from thorchain.swaps
where pool_name = 'BNB.BTCB-1DE' and block_timestamp <= '2021-04-16 23:46:39.600'
group by 1),
Run a query to Download Data