alitaslimiTransactions Daily Legacy
Updated 2023-05-14
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
-------------------------------------------------- Algorand --------------------------------------------------
-- prices_algorand AS (
-- SELECT
-- block_hour::date AS day,
-- AVG(price_usd) AS price
-- FROM (
-- SELECT
-- block_hour,
-- price_usd
-- FROM
-- algorand.defi.ez_price_pool_balances
-- WHERE
-- block_hour::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)
-- AND asset_id = 0
-- AND price_usd > 0
-- UNION
-- SELECT
-- block_hour,
-- price_usd
-- FROM
-- algorand.defi.ez_price_swap
-- WHERE
-- block_hour::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)
-- AND asset_id = 0
-- AND price_usd > 0
-- UNION
-- SELECT
-- recorded_hour,
-- close
-- FROM
-- algorand.defi.ez_price_third_party_hourly
-- WHERE
-- recorded_hour::date BETWEEN (CURRENT_DATE - 30) AND (CURRENT_DATE - 1)
-- AND asset_id = 0
-- AND close > 0
Run a query to Download Data