Query editor
-- UINT256 Fixed Multi-Asset Whale Transfers (ERC20 Events, Ethereum, Last 1 Hour)-- Direkt value (UINT256) kullan, CAST to DOUBLE for division (no varbinary conversion needed)WITH transfers AS (SELECTevt_block_time AS block_time,contract_address AS token_address,"from" AS from_address,"to" AS to_address,value AS amount_raw -- Direkt UINT256 valueFROM erc20_ethereum.evt_Transfer -- ERC20 Transfer eventsWHERE evt_block_time > now() - interval '1' hour -- Son 1 saat),token_meta AS (SELECTcontract_address,symbol AS token_symbol,decimalsFROM tokens.erc20 -- Token metadata),prices AS (SELECTcontract_address,minute,priceFROM prices.usd -- USD fiyatlarWHERE minute > now() - interval '1' hour)SELECTt.block_time,tm.token_symbol,t.token_address,t.from_address,t.to_address,CAST(t.amount_raw AS DOUBLE) / POWER(10.0, COALESCE(tm.decimals, 18)) AS amount, -- UINT256 to DOUBLE division(CAST(t.amount_raw AS DOUBLE) / POWER(10.0, COALESCE(tm.decimals, 18))) * COALESCE(pr.price, 0) AS amount_usd,CASEWHEN t.to_address = 0x0000000000000000000000000000000000000000 THEN 'Mint' -- Varbinary literal for addressWHEN t.to_address = 0x000000000000000000000000000000000000dead THEN 'Burn'ELSE 'Transfer'END AS typeFROM transfers tLEFT JOIN token_meta tm ON t.token_address = tm.contract_addressLEFT JOIN prices pr ON pr.contract_address = t.token_addressAND pr.minute = date_trunc('minute', t.block_time)WHERE (CAST(t.amount_raw AS DOUBLE) / POWER(10.0, COALESCE(tm.decimals, 18))) * COALESCE(pr.price, 0) > 500000 -- 500k USD filtreAND tm.token_symbol IS NOT NULLORDER BY amount_usd DESCLIMIT 50;