with tab1 as (

SELECT

date_trunc('day', block_timestamp) as week1,

sum(raw_amount / power(10, decimals)) as USDC_Mint_Volume

FROM ethereum.core.ez_token_transfers

WHERE contract_address LIKE lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48')

AND from_address LIKE '0x0000000000000000000000000000000000000000'

--AND raw_amount / power(10, decimals) < 1000000000

GROUP BY 1

), tab2 as (

SELECT

date_trunc('day', block_timestamp) as week2,

sum(raw_amount / power(10, decimals)) as USDC_Burn_Volume

FROM ethereum.core.ez_token_transfers

WHERE contract_address LIKE lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48')

AND to_address LIKE '0x0000000000000000000000000000000000000000'

--AND raw_amount / power(10, decimals) < 1000000000

GROUP BY 1

SELECT

*,

(Total_USDC_in_circulation / max(Total_USDC_in_circulation) over (ORDER BY week1)) * 100 as USDC_circulation_as_a_percent_of_max_USDC_circulation

FROM (

SELECT

*,

sum(Net_USDC_mint) over (ORDER BY week1) as Total_USDC_in_circulation

FROM (

SELECT

*,

USDC_Mint_volume - USDC_Burn_Volume as Net_USDC_mint

FROM tab1