avax_fees AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS dt,

SUM(tx_fee) AS avax_fees

FROM

avalanche.core.fact_transactions

WHERE

block_timestamp >= '2021-10-01'

GROUP BY

dt

),

avax_price AS (

SELECT

DATE_TRUNC('day', hour) AS dt,

AVG(price) AS avax_price

FROM

bsc.core.fact_hourly_token_prices

WHERE

token_address = '0x1ce0c2827e2ef14d5c4f29a091d735a204794041'

AND hour >= '2021-10-01'

GROUP BY

dt

),

avax_fee_paying_users AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS dt,

COUNT(DISTINCT from_address) AS avax_fee_paying_users

FROM

avalanche.core.fact_transactions

WHERE

block_timestamp >= '2021-10-01'

GROUP BY

dt

),

bsc_fees AS (