SELECT DATEADD(DAY, -1, CURRENT_DATE()) AS day

UNION ALL

SELECT DATEADD(DAY, -1, day)

FROM dates

WHERE day > '2024-03-03'

),

yes_mints as (

SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY, SUM(AMOUNT) OVER(ORDER BY BLOCK_TIMESTAMP) AS mints

FROM blast.core.ez_token_transfers

WHERE FROM_ADDRESS = lower('0x0000000000000000000000000000000000000000')

AND contract_address = '0x20fe91f17ec9080e3cac2d688b4ecb48c5ac3a9c'

),

yes_burns as (

SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY, SUM(AMOUNT) OVER(ORDER BY BLOCK_TIMESTAMP) AS burns

FROM blast.core.ez_token_transfers

WHERE TO_ADDRESS = lower('0x0000000000000000000000000000000000000000')

AND contract_address = '0x20fe91f17ec9080e3cac2d688b4ecb48c5ac3a9c'

),

yes_lp_inflows as (

SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY, SUM(AMOUNT) OVER(ORDER BY BLOCK_TIMESTAMP) AS lp_inflows

FROM blast.core.ez_token_transfers

WHERE TO_ADDRESS = '0x1d16788b97edb7d9a6ae66d5c5c16469037faa00'

AND contract_address = '0x20fe91f17ec9080e3cac2d688b4ecb48c5ac3a9c'

),

yes_lp_outflows as (

SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY, SUM(AMOUNT) OVER(ORDER BY BLOCK_TIMESTAMP) AS lp_outflows

FROM blast.core.ez_token_transfers

WHERE FROM_ADDRESS = '0x1d16788b97edb7d9a6ae66d5c5c16469037faa00'

AND contract_address = '0x20fe91f17ec9080e3cac2d688b4ecb48c5ac3a9c'

),