sol_active_tokens as (

select distinct

mint,

max(mint_amount) over (partition by amounts.mint) as raw_amount,

max(decimal) over (partition by amounts.mint) as decimals

from solana.defi.fact_token_mint_actions amounts

where succeeded

and block_timestamp > current_date() - interval '{{days}} days'

qualify max(mint_amount) over (partition by amounts.mint) > 100000

),

sol_creation_dates as (

select distinct

block_timestamp,

signers[0] ::string as creator_address,

mint as contract_address,

fee / pow(10,9) * close as tx_fee_usd,

'Solana' as label_chain

from solana.core.fact_events events

inner join solana.core.fact_transactions txs

using(tx_id, block_timestamp, succeeded)

inner join sol_active_tokens

on events.instruction :parsed :info :newAccount = sol_active_tokens.mint

left join solana.price.ez_token_prices_hourly prices

on date_trunc('hour', events.block_timestamp) = prices.recorded_hour

and prices.symbol = 'sol'