PredictionAvalanche Apps
Updated 2023-08-28
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 total_gas_fees_today_AVAX as (
SELECT
sum(tx_fee) as gas_fees_total_today_AVAX
FROM avalanche.core.fact_transactions
WHERE block_timestamp > current_date - 1
and status LIKE 'SUCCESS'
),
total_gas_fees_yesterday_AVAX as (
SELECT
sum(tx_fee) as gas_fees_total_yesterday_AVAX
FROM avalanche.core.fact_transactions
WHERE block_timestamp BETWEEN current_date - 2 and current_date - 1
and status LIKE 'SUCCESS'
),
total_gas_fees_week_AVAX as (
SELECT
AVG(gas_fees_total_week_AVAX) as gas_fees_total_AVG_week_AVAX
FROM (
SELECT
date_trunc('day', TIMESTAMPADD(SECOND, -(EXTRACT(HOUR FROM CURRENT_TIMESTAMP)*3600 + EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)*60 + EXTRACT(SECOND FROM CURRENT_TIMESTAMP)), block_timestamp)) as day,
SUM(tx_fee) as gas_fees_total_week_AVAX
FROM avalanche.core.fact_transactions
WHERE block_timestamp BETWEEN current_date - 7 AND current_date
and status LIKE 'SUCCESS'
GROUP BY day
)
),
total_gas_fees_month_AVAX as (
SELECT
AVG(gas_fees_total_month_AVAX) as gas_fees_total_AVG_month_AVAX
FROM (
SELECT
date_trunc('day', TIMESTAMPADD(SECOND, -(EXTRACT(HOUR FROM CURRENT_TIMESTAMP)*3600 + EXTRACT(MINUTE FROM CURRENT_TIMESTAMP)*60 + EXTRACT(SECOND FROM CURRENT_TIMESTAMP)), block_timestamp)) as day,
Run a query to Download Data