Query editor
WITHparams AS (SELECTCAST('{{start_date}}' AS DATE) AS start_date,CAST('{{end_date}}' AS DATE) AS end_date),date_spine AS (SELECT snapshot_dateFROM paramsCROSS JOIN UNNEST(SEQUENCE(params.start_date, params.end_date, INTERVAL '1' DAY)) AS dates (snapshot_date)),exchange_wallets AS (SELECTblockchain,wallet,holderFROM (VALUES('solana', 'FWznbcNXWQuHTawe9RxvQ2LdCENssh12dsznf4RiouN5', 'Kraken'),('solana', '9A9dUreQvTNoqNrqQC2DN1onfZWBtCBsTiuA6oGXZwc6', 'Kraken'),('solana', '41Mjig92SfveWPKkqis78hF3a75cpe96n1uuVuMAdkJF', 'Kraken'),('solana', '6LY1JzAFVZsP2a2xKrtU6znQMQ5h4i7tocWdgrkZzkzF', 'Kraken'),('solana', 'AC5RDfQFmDS1deWZos921JfqscXdByf8BKHs5ACWjtW2', 'Bybit'),('solana', 'u6PJ8DtQuPFnfmwHbGFULQ4u4EgjDiyYKjVEsynXq2w', 'Gate.io'),('solana', 'C68a6RCGLiPskbPYtAcsCjhG8tfTWYcoB4JjCrXFdqyo', 'OKX'),('solana', '8wM44Ryv9DFCSfkgUnPEPgnsc53arT4cnmXL6LnnC4UW', 'OKX'),('xlayer', '0xe64b0f1a50ba340426861f29327e9eaa7fb404ad', 'OKX'),('xlayer', '0x3f9bf46a8bee3b0e902f6999e5de196f70255534', 'OKX')) AS wallets (blockchain, wallet, holder)),solana_asset_mappings AS (SELECTLOWER(solana_address) AS contract_address,MIN(symbol) AS symbol,COUNT(DISTINCT symbol) AS symbol_countFROM dune.xstocks.result_latest_x_stocks_assetsWHERE solana_address IS NOT NULLGROUP BY 1),solana_assets AS (SELECTcontract_address,symbolFROM solana_asset_mappingsWHERE symbol_count = 1),solana_daily_states_ranked AS (SELECTCAST(daily_balances.day AS DATE) AS state_day,daily_balances.address AS token_account,LOWER(daily_balances.token_mint_address) AS contract_address,CAST(daily_balances.token_balance_owner AS VARCHAR) AS wallet,CAST(daily_balances.token_balance AS DOUBLE) AS balance_units,