ngxuan885Deposit rate from L1s: chains
Updated 2022-06-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with swaps_single_sided as (
SELECT tx_id, count(*) as counts
from flipside_prod_db.thorchain.swaps
GROUP by 1 having counts = 1)
select BLOCKCHAIN, FROM_ASSET,
count(distinct FROM_ADDRESS) as swappers
-- POOL_NAME,
-- sum(TO_AMOUNT_USD) as usd_volume
-- count(distinct tx_id) as swaps, sum(TO_AMOUNT) as Rune_volume
from flipside_prod_db.thorchain.swaps
where BLOCK_TIMESTAMP::date >= '2022-03-01'
and tx_id in (SELECT tx_id from swaps_single_sided)
and TO_ASSET = 'THOR.RUNE'
and FROM_ASSET not like '%/%' -- BLOCKCHAIN not in ('THOR')
GROUP by 1,2 order by 1,2
Run a query to Download Data