market_data as (

select

date(block_timestamp) as date,

count(distinct tx_id) as txs,

count(distinct signers[0]) as wallet,

'NFT Marketplaces' as

type

from

solana.core.fact_events

where

date >= '2023-01-01'

and program_id in (

'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8', -- 'Magic Eden Secondary'

'CJsLwbP1iu5DuUikHEJnLfANgKy6stB2uFgvBBHoyxwz', --'Solanart'

'617jbWo616ggkDxvW1Le8pV38XLbVSyWY8ae6QUmGBAU', -- 'Sol Sea'

'A7p8451ktDCHq5yYaHczeLMYsjRsAkzc3hCXcSrwYHU7', --'Digital Eyes'

'Guard1JwRhJkVH6XZhzoYxeBVQe872VH6QggF4BWmS9g', --'Metaplex Candy Guard'

'ArAA6CZC123yMJLUe4uisBEgvfuw2WEvex9iFmFCYiXv', --'LaunchMyNFT'

'CMZYPASGWeTz7RNGHaRJfCq2XQ5pYK6nDvVQxzkH51zb', --'Magic Eden Launchpad'

'6U2LkBQ6Bqd1VFt7H76343vpSwS5Tb1rNyXSNnjkf9VL', --coralcube

'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K', --magic eden v2

'exAuvFHqXXbiLrM4ce9m1icwuSyXytRnfBkajukDFuB',

'EXBuYPNgBUXMTsjCbezENRUtFQzjUNZxvPGTd11Pznk5', --exchange art

'hadeK9DLv9eA7ya5KCTqSvSvRZeJC3JgD5a9Y3CNbvu', --hadeswap

'5SKmrbAxnHV2sgqyDXkGrLrokZYtWWVEEk5Soed7VLVN', --yawww

'HYPERfwdTjyJ2SCaKHmpF2MtrXqWxrsotYDsTrshHWq8', --hyperspace

'TSWAPaqyCSx2KABk68Shruf4rp7CxcNi8hAsbdwmHbN' --tensor

)

group by

1

),

social_data as (

select

date(block_timestamp) as date,

count(distinct tx_id) as txs,