nitsDeposit from L1
Updated 2022-06-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH t AS (
SELECT tx_id, COUNT(1) AS n
FROM thorchain.swaps
GROUP BY 1
)
SELECT date(block_timestamp) as day , blockchain, sum(from_amount_usd) as total_amt,
sum(total_amt) over (partition by blockchain order by day ) as cumulative_amt
from
(SELECT * from
(SELECT s.*, CASE WHEN t.n = 1 THEN 0 ELSE 1 END AS two_sided_swap_via_rune
FROM thorchain.swaps s
JOIN t ON t.tx_id = s.tx_id)
where two_sided_swap_via_rune = 0)
where to_asset = 'THOR.RUNE' and blockchain != 'THOR'
GROUP by 1,2
-- limit 100
Run a query to Download Data