Query editor
WITH token_prices AS (SELECTblock_time,token_bought_symbol AS token_symbol,token_bought_address AS token_address,amount_usd / NULLIF(token_bought_amount, 0) AS price_usdFROM dex.tradesWHERE token_bought_amount > 0AND blockchain = 'ink'UNION ALLSELECTblock_time,token_sold_symbol AS token_symbol,token_sold_address AS token_address,amount_usd / NULLIF(token_sold_amount, 0) AS price_usdFROM dex.tradesWHERE token_sold_amount > 0AND blockchain = 'ink'),ranked AS (SELECTtoken_symbol,token_address,price_usd,block_time,ROW_NUMBER() OVER (PARTITION BY token_address ORDER BY block_time DESC) AS rnFROM token_prices),pricet AS (SELECTtoken_symbol AS psymbol,token_address,price_usd AS price,block_time AS latest_block_timeFROM rankedWHERE rn = 1ORDER BY token_symbol),baset AS (SELECT"from" AS user,tx_hash,contract_address,symbol,-1 * amount AS amFROM tokens_ink.transfersWHERE amount IS NOT NULLUNION ALLSELECT"to" AS user,tx_hash,contract_address,symbol,