Query editor
SELECT block_time,case when project_contract_address = 0xFa5b5C3DB5945450B678c74263d75F4E65a785fB then '0.05%'when project_contract_address = 0x749e2CFf6164f2D1E7545094305B1Ef5FcBdeaB5 then '0.25%'when project_contract_address = 0xb297d74cbe67ba9a0fa92862c31e501228e8b00b then '1%'end as pool,case when token_bought_symbol = 'GMT' and token_sold_symbol = 'USDT' then token_sold_amount/token_bought_amountwhen token_bought_symbol = 'USDT' and token_sold_symbol = 'GMT' then token_bought_amount/token_sold_amountend as price,amount_usd as volumeFROM dex.tradesWHERE token_pair = 'GMT-USDT'AND blockchain = 'bnb'AND project = 'pancakeswap'and version = '3'and block_date >= TIMESTAMP '2026-01-01 00:00:00'AND block_date < TIMESTAMP '2026-12-31 00:00:00'