*/

with dates as (

SELECT date_day

-- date_day AS date

-- DISTINCT(iso_week_start_date) AS date

FROM ethereum.core.dim_dates

WHERE date_day BETWEEN '2023-07-18' AND current_date()

, jlp_mints AS (

SELECT

date_trunc(day, block_timestamp) AS date

, sum(mint_amount) / pow(10, 6) AS jlp_mints

FROM solana.defi.fact_token_mint_actions

WHERE 1 = 1

AND block_timestamp::date >= '2023-07-18'

AND mint = '27G8MtK7VtTcCHkpASjSDdkWWYfoqT6ggEuKidVJidD4'

AND succeeded

GROUP BY 1

ORDER BY 1

, jlp_burns AS (

SELECT

date_trunc(day, block_timestamp) AS date

, - sum(burn_amount) / pow(10, 6) AS jlp_burns

FROM solana.defi.fact_token_burn_actions

WHERE 1 = 1

AND block_timestamp::date >= '2023-07-18'

AND mint = '27G8MtK7VtTcCHkpASjSDdkWWYfoqT6ggEuKidVJidD4'

AND succeeded

GROUP BY 1