pandaAvalanche Fee | dApps - Total Values
Updated 2023-03-29Copy 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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH AVAX_Tx_Tab AS
(
SELECT
a.BLOCK_TIMESTAMP,
a.GAS_PRICE,
a.GAS_USED,
a.TX_FEE,
a.FROM_ADDRESS,
a.TX_HASH,
b.CONTRACT_NAME,
b.CONTRACT_ADDRESS,
b.EVENT_NAME,
c.PROJECT_NAME
FROM
avalanche.core.fact_transactions a JOIN avalanche.core.fact_event_logs b ON a.TX_HASH = b.TX_HASH
JOIN avalanche.core.dim_labels c ON b.contract_address = c.address
WHERE
c.LABEL_TYPE = 'dapp'
),
avax_Price AS
(
SELECT
HOUR,
PRICE
FROM
ethereum.core.fact_hourly_token_prices
WHERE
TOKEN_ADDRESS = lower('0x85f138bfEE4ef8e540890CFb48F620571d67Eda3')
)
SELECT
AVG(TX_FEE) * AVG(PRICE) as avg_fee,
AVG(GAS_USED) as avg_gas,
AVG(GAS_PRICE) as avg_gas_gwei
FROM
Run a query to Download Data