yasminAVG_GAS_PRICE_GWEI
Updated 2025-04-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
PARSE_JSON(
livequery.live.udf_api(
'GET',
'https://api.routescan.io/v2/network/mainnet/evm/43419/aggregations/avg-gas-price/tot',
{'accept': 'application/json'},
NULL
):data
):value::number AS avg_gas_price_wei,
ROUND(
PARSE_JSON(
livequery.live.udf_api(
'GET',
'https://api.routescan.io/v2/network/mainnet/evm/43419/aggregations/avg-gas-price/tot',
{'accept': 'application/json'},
NULL
):data
):value::number / 1e9,
2
) AS avg_gas_price_gwei
QueryRunArchived: QueryRun has been archived