with token_details as (

select

token_address

, name

, symbol

, iff(decimals is not null, decimals, {{token_decimals}}) as token_decimals

from solana.price.ez_asset_metadata --solana.core.dim_tokens

where token_address = '{{token_address}}'

, first_mint as (

select min(block_timestamp)::date as first_mint_date

from solana.defi.fact_token_mint_actions

where mint = '{{token_address}}'

, dates as (

SELECT

DISTINCT date

FROM (

SELECT

case

when '{{time_granularity}}' = 'day' then date_day

when '{{time_granularity}}' = 'week' then iso_week_start_date

when '{{time_granularity}}' = 'month' then month_start_date

end as date

FROM ethereum.core.dim_dates

WHERE date_day BETWEEN (select first_mint_date from first_mint) AND current_date()

)

, token_mints AS (

SELECT