Kruys-Collins2024-04-29 02:28 AM
Updated 2024-04-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
ft.FOREIGN_CHAIN as chain,
DATE_TRUNC('day', ft.BLOCK_TIMESTAMP) AS date,
AVG(CAST(tx.FEE AS FLOAT) / POWER(10, ft.DECIMAL)) AS "Average Daily Gas Fee"
FROM
axelar.core.fact_transactions tx
JOIN
axelar.core.fact_transfers ft
ON
tx.TX_ID = ft.TX_ID
WHERE
tx.TX_SUCCEEDED = TRUE
AND date_part(year, ft.block_timestamp) = 2024
--AND chain in ('Polygon' ,'Avalanche','Ethereum','osmosis','binance','kujira','Fantom','Moonbeam','arbitrum','Axelarnet','neutron' ,'umee' ,'terra-2' ,'secret-snip' , 'juno' ,'crescent' ,'comdex' ,'evmos' ,'sei','cosmoshub')
GROUP BY
chain, date
ORDER BY
date,"Average Daily Gas Fee" DESC ;
QueryRunArchived: QueryRun has been archived