FROM ethereum.udm_events

WHERE from_address ilike '0x0000000000000000000000000000000000000000'

and contract_address ilike '0x6b175474e89094c44da98b954eedeac495271d0f'

GROUP BY 1),

burn AS (SELECT DATE(block_timestamp) as day, ifnull(SUM(amount),0) as burn_amount

FROM ethereum.udm_events

WHERE to_address ilike '0x0000000000000000000000000000000000000000'

and contract_address ilike '0x6b175474e89094c44da98b954eedeac495271d0f'

GROUP BY 1)

SELECT mint.day, mint_amount, burn_amount, mint_amount - burn_amount as daily_fluctuation

FROM mint, burn

WHERE mint.day = burn.day and mint.day >= '2021-01-01'