alitaslimiSwaps Daily
Updated 2022-10-12Copy Reference Fork
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
prices AS (
SELECT
DISTINCT day,
AVG(price) AS price
FROM (
SELECT
block_timestamp::date AS day,
AVG((to_amount / POW(10, to_decimal)) / (from_amount / POW(10, from_decimal))) AS price
FROM
osmosis.core.fact_swaps swaps
JOIN
osmosis.core.dim_labels labels
ON
swaps.from_currency = labels.address
WHERE
block_timestamp::date BETWEEN (TO_DATE('2022-09-26') - DATEDIFF(day, TO_DATE('2022-09-28'), CURRENT_DATE - 1)) AND (CURRENT_DATE - 1)
AND tx_status = 'SUCCEEDED'
AND project_name = '{{token}}'
AND to_currency = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858'
GROUP BY
day
UNION ALL
SELECT
block_timestamp::date AS day,
AVG((from_amount / POW(10, from_decimal)) / (to_amount / POW(10, to_decimal))) AS price
FROM
osmosis.core.fact_swaps swaps
JOIN
osmosis.core.dim_labels labels
ON
swaps.to_currency = labels.address
WHERE
block_timestamp::date BETWEEN (TO_DATE('2022-09-26') - DATEDIFF(day, TO_DATE('2022-09-28'), CURRENT_DATE - 1)) AND (CURRENT_DATE - 1)
AND tx_status = 'SUCCEEDED'
AND project_name = '{{token}}'
Run a query to Download Data