zero-ndoLtSto/from galgo3
Updated 2022-04-30Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
(
select
date_trunc('day',block_timestamp) as "date",
count(distinct tx_group_id) as "number of trades",
sum(swap_to_amount) as "volume of trades",
'to galgo3' as "action"
from algorand.swaps
where swap_to_asset_id ='694432641'
group by "date"
)
UNION
(
select
date_trunc('day',block_timestamp) as "date",
count(distinct tx_group_id) as "number of trades",
sum(swap_from_amount) as "volume of trades",
'from galgo3' as "action"
from algorand.swaps
where swap_from_asset_id ='694432641'
group by "date"
)
Run a query to Download Data