count( DISTINCT polygon.core.fact_transactions.TX_HASH ) AS total_transaction

, date_trunc( 'day' , polygon.core.fact_transactions.BLOCK_TIMESTAMP ) AS date

, sum(polygon.core.ez_matic_transfers.AMOUNT) AS sum_matic

, sum(polygon.core.ez_matic_transfers.AMOUNT_USD) AS sum_usd

, sum_usd / sum_matic AS matic_price_$

, CASE

when

date

BETWEEN '2022-12-17'

AND '2023-01-17'

then 'before_upgraded'

when

date

BETWEEN '2023-01-18'

AND '2023-02-17'

then 'after_upgraded'

END

AS status

, count( CASE when date BETWEEN '2022-12-17' AND '2023-01-17' then 'number_before' END ) AS before_upgraded

, count( CASE when date BETWEEN '2023-01-18' AND '2023-02-17' then 'number_after' END ) AS after_upgraded

, MIN( polygon.core.fact_transactions.GAS_PRICE ) AS min_gas_price

, MAX( polygon.core.fact_transactions.GAS_PRICE ) AS max_gas_price

, sum( polygon.core.fact_transactions.GAS_PRICE ) AS sum_gas_price

, sum_gas_price / count( date ) AS avg_gas_price

, avg((polygon.core.fact_transactions.GAS_PRICE * polygon.core.fact_transactions.GAS_USED) / 1000000000) AS gas_fee_matic

, gas_fee_matic * matic_price_$ AS gas_fee_USD