t1 AS (

SELECT

trunc(block_timestamp, 'week') AS date,

COUNT(DISTINCT tx_hash) AS txs,

SUM(txs) OVER (ORDER BY trunc(block_timestamp, 'week')) AS cum_txs,

SUM(amount) AS volume,

AVG(amount) AS avg_volume,

AVG(SUM(amount)) OVER (ORDER BY trunc(block_timestamp, 'week') ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS avg_volume_ma_7hour,

SUM(SUM(amount)) OVER (ORDER BY trunc(block_timestamp, 'week')) AS cum_volume

FROM avalanche.core.ez_token_transfers

WHERE

contract_address = LOWER('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')

AND from_address = '0x0000000000000000000000000000000000000000'

AND block_timestamp >= '2023-05-25'

GROUP BY 1

),

t2 AS (

SELECT

trunc(block_timestamp, 'week') AS date,

COUNT(DISTINCT tx_hash) AS txs,

SUM(txs) OVER (ORDER BY trunc(block_timestamp, 'week')) AS cum_txs,

SUM(amount) AS volume,

AVG(amount) AS avg_volume,

AVG(SUM(amount)) OVER (ORDER BY trunc(block_timestamp, 'week') ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS avg_volume_ma_7hour,

SUM(SUM(amount)) OVER (ORDER BY trunc(block_timestamp, 'week')) AS cum_volume

FROM avalanche.core.ez_token_transfers

WHERE

contract_address = LOWER('0xC891EB4cbdEFf6e073e859e987815Ed1505c2ACD')

AND to_address = '0x0000000000000000000000000000000000000000'

AND block_timestamp >= '2023-05-25'

GROUP BY 1

),

combined AS (

SELECT

COALESCE(x.date, y.date) AS date,