MLDZMNl3gas
Updated 2023-10-02
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with t1 as (SELECT
TO_TIMESTAMP(d.value:timestamp) as date,
d.value:value as gas_used
from (select livequery.live.udf_api(
'https://metrics.avax.network/v1/gas_used/333000333?from=1682541000&interval=day'
) :"data" as data
)
join lateral flatten (input => data:results) d
),
t2 as (SELECT
TO_TIMESTAMP(d.value:timestamp) as date,
d.value:value as Gas_per_second
from (select livequery.live.udf_api(
'https://metrics.avax.network/v1/avg_gps/333000333?from=1682541000&interval=day'
) :"data" as data
)
join lateral flatten (input => data:results) d
),
t3 as (SELECT
TO_TIMESTAMP(d.value:timestamp) as date,
d.value:value as avg_gas_price
from (select livequery.live.udf_api(
'https://metrics.avax.network/v1/avg_gas_price/333000333?from=1682541000&interval=day'
) :"data" as data
)
join lateral flatten (input => data:results) d
)
SELECT
t1.date as date,
gas_used,
Gas_per_second,
avg_gas_price,
gas_used*avg_gas_price/1e12 as "Avg Fee in gMELD"
Run a query to Download Data