select

distinct pre_mint as token,

count(distinct tx_id) as transaction_count

from

solana.transactions

where program_id = '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin'

and date(block_timestamp) >= CURRENT_DATE()-14

and token not in -- ignoring add ons

('ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx',

'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK',

'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG',

'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim',

'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL' )

group by 1

order by 2 desc

,

sa_daily as (

select

date(block_timestamp) as date,

case

when token = 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s' then 'Fimbul Airbike'

when token = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' then 'Opal Jet'

when token = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' then 'Pearce X4'

when token = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' then 'Pearce X5'

when token = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' then 'Opal Jetjet'

else 'Other' end as token_name,

count(distinct t.tx_id) as transactions

from sa_tokens st

inner join solana.transactions t

on st.token = t.pre_mint

where

date(block_timestamp) between '2022-02-01' and '2022-02-14'