ArkanAlgorand 1
Updated 2022-11-15Copy 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
23
24
25
›
⌄
SELECT
date_trunc('hour', block_timestamp) as day,
'algorand' as chain,
sum(algo_price * FEE) as fee_volume,
avg(algo_price * FEE) as avg_fee,
sum(algo_price * AMOUNT) as trasfer_volume,
avg(algo_price * AMOUNT) as avg_trasfer,
(sum(algo_price * FEE) / sum(algo_price * AMOUNT) ) * 1000000 as gas_per_million_transfered,
avg(algo_price) as ALGO_price
FROM
algorand.core.ez_transaction_payment
left outer JOIN (
SELECT
date_trunc('hour', RECORDED_HOUR) as day1,
avg(CLOSE) as algo_price
FROM crosschain.core.fact_hourly_prices
WHERE id LIKE 'wrapped-algo'
GROUP BY 1
)
ON date_trunc('day', block_timestamp) = day1
WHERE block_timestamp > CURRENT_DATE - 30
AND asset_id = 0
GROUP BY 1
Run a query to Download Data