Query editor
/*Table(s): dex_solana.trades, tokens_solana.fungibleReason: Curated dataset recommendationsTable(s): raydium_clmm_solana.amm_v3_call_createpoolReason: Based on contract addresses or possible project names*/WITH recent_tokens AS (SELECTtoken_mint_addressFROM tokens_solana.fungibleWHEREcreated_at >= TRY_CAST('2025-05-30 13:15:00 UTC' AS TIMESTAMP)), liquidity_pools AS (SELECTaccount_tokenMint0 AS token_mint_addressFROM raydium_clmm_solana.amm_v3_call_createpoolUNIONSELECTaccount_tokenMint1 AS token_mint_addressFROM raydium_clmm_solana.amm_v3_call_createpool), filtered_tokens AS (SELECTrt.token_mint_addressFROM recent_tokens AS rtLEFT JOIN liquidity_pools AS lpON rt.token_mint_address = lp.token_mint_addressWHERElp.token_mint_address IS NULL)SELECTft.token_mint_addressFROM filtered_tokens AS ftJOIN tokens_solana.fungible AS tsfON ft.token_mint_address = tsf.token_mint_addressWHEREtsf.symbol = 'LOUD'