rajsUntitled Query
Updated 2023-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
-- *
min(block_timestamp) as min_time,
sum(to_amount) / pow(10,18) as amount,
count(distinct from_currency) as count
-- count(*)
from osmosis.core.fact_swaps
-- where pool_ids[1] = '899'
where to_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373'
union all
SELECT
-- *
min(block_timestamp) as min_time,
sum(from_amount) / pow(10,18) as amount,
count(distinct to_currency) as count
-- count(*)
from osmosis.core.fact_swaps
-- where pool_ids[1] = '899'
where from_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373'
Run a query to Download Data