WITH ETH_DAILY_DATA AS (

SELECT

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY,

SUM(CASE WHEN from_address = LOWER('0x0000000000000000000000000000000000000000')

THEN CAST(RAW_AMOUNT_PRECISE as NUMERIC)/1e6 ELSE 0 END) AS ETH_MINTED,

SUM(CASE WHEN to_address = LOWER('0x0000000000000000000000000000000000000000')

THEN CAST(RAW_AMOUNT_PRECISE as NUMERIC)/1e6 ELSE 0 END) AS ETH_BURNED,

SUM(CASE WHEN from_address = LOWER('0x0000000000000000000000000000000000000000')

THEN CAST(RAW_AMOUNT_PRECISE as NUMERIC)/1e6 ELSE 0 END) -

SUM(CASE WHEN to_address = LOWER('0x0000000000000000000000000000000000000000')

THEN CAST(RAW_AMOUNT_PRECISE as NUMERIC)/1e6 ELSE 0 END) AS TOTAL_ETH

FROM ethereum.core.fact_token_transfers

WHERE CONTRACT_ADDRESS = LOWER('0x6c3ea9036406852006290770bedfcaba0e23a0e8')

GROUP BY DAY

),

SOL_MINTED_DATA AS (

SELECT

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY,

SUM(CAST(MINT_AMOUNT AS NUMERIC) / 1e6) AS SOL_MINTED

FROM solana.defi.fact_token_mint_actions

WHERE MINT = '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo'

GROUP BY DAY

),

SOL_BURNED_DATA AS (

SELECT

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY,

SUM(CAST(BURN_AMOUNT AS NUMERIC) / 1e6) AS SOL_BURNED

FROM solana.defi.fact_token_burn_actions