nitsgoETH Buyer vs Seller
Updated 2022-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with goETHseller as
(SELECT date(block_timestamp) as day,count(DISTINCT swapper) as addr,sum(swap_from_amount) as total_amt,
sum(total_amt) over (order by day) as cumulative_amt
, sum(addr) over ( order by day) as cumulative_addr
, 'goETH seller' as type from algorand.swaps
where swap_from_asset_id = '386195940'
GROUP by 1),
goETHbuyer as
(SELECT date(block_timestamp) as day, count(DISTINCT swapper) as addr,sum(swap_to_amount) as total_amt,
sum(total_amt) over (order by day) as cumulative_amt
, sum(addr) over ( order by day) as cumulative_addr
,'goETH buyer' as type from algorand.swaps
where swap_to_asset_id = '386195940'
GROUP by 1 )
SELECT * from goETHbuyer
UNION ALL
SELECT * from goETHseller
-- limit 100
Run a query to Download Data