Query editor
/*Table(s): dex.tradesReason: Based on general keywordsTable(s): tokens_solana.fungible, dex_solana.tradesReason: Curated dataset recommendations*/WITH recent_tokens AS (SELECTtoken_mint_address,created_at,decimals,symbolFROM tokens_solana.fungibleWHEREcreated_at >= CURRENT_TIMESTAMP - INTERVAL '1' DAY), tokens_with_liquidity AS (SELECT DISTINCTtoken_bought_mint_address AS token_mint_addressFROM dex_solana.tradesWHEREblock_time >= CURRENT_TIMESTAMP - INTERVAL '1' DAYUNIONSELECT DISTINCTtoken_sold_mint_address AS token_mint_addressFROM dex_solana.tradesWHEREblock_time >= CURRENT_TIMESTAMP - INTERVAL '1' DAY)SELECTrt.token_mint_address,rt.created_at,rt.decimals,rt.symbolFROM recent_tokens AS rtLEFT JOIN tokens_with_liquidity AS twlON rt.token_mint_address = twl.token_mint_addressWHEREtwl.token_mint_address IS NULLORDER BYrt.decimals DESC