Query editor
WITHparams AS (SELECTnow() - interval '30' day AS t_from,now() AS t_to,interval '6' hour AS hop_window),excluded AS (SELECT * FROM (VALUES('CCavXvmMgfW4Ky2PX3E9Nij8TMxLmSsMZuHUtxXUL1aN', 'The Vault'),('6RLKARrt6oPCyuMCdYdUHmJxd4wUa6ZeyiC8VSMcYxRv', 'The Vault'),('5tzFkiKscXHK5ZXCGbXZxdw7gTjjD1mBwuoFbhUvuAi9', 'Binance Hot Wallet'),('6LY1JzAFVZsP2a2xKrtU6znQMQ5h4i7tocWdgrkZzkzF', 'Kraken Hot Wallet'),('9obNtb5GyUegcs3a1CbBkLuc5hEWynWfJC6gjz5uWQkE', 'Coinbase Hot Wallet'),('H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS', 'Coinbase Hot Wallet'),('5g7yNHyGLJ7fiQ9SN9mf47opDnMjc585kqXWt6d7aBWs', 'Coinbase Hot Wallet'),('DPqsobysNf5iA9w7zrQM8HLzCKZEDMkZsWbiidsAt1xo', 'Coinbase Hot Wallet'),('4NyK1AdJBNbgaJ9EsKz3J4rfeHsuYdjkTPg3JaNdLeFw', 'Coinbase Hot Wallet'),('GJRs4FwHtemZ5ZE9x3FNvJ8TMwitKTh21yxdRPqn7npE', 'Coinbase Hot Wallet'),('2AQdpHJ2JpcEgPiATUXjQxA8QmafFegfQwSLWSprPicm', 'Coinbase Hot Wallet'),('FpwQQhQQoEaVu3WU2qZMfF1hx48YyfwsLoRgXG83E99Q', 'Coinbase Hot Wallet'),('D89hHJT5Aqyx1trP6EnGY9jJUB3whgnq3aUvvCqedvzf', 'Coinbase Hot Wallet'),('is6MTRHEgyFLNTfYcuV4QBWLjrZBfmhVNYR6ccgr8KV', 'OKX Hot Wallet'),('iGdFcQoyR2MwbXMHQskhmNsqddZ6rinsipHc4TNSdwu', 'Bybit Hot Wallet'),('A77HErqtfN1hLLpvZ9pCtu66FEtM8BveoaKbbMoZ4RiR', 'Bitget Hot Wallet'),('miyBB8t2TP2k1KGjaSBgtP98DPVcMuVdRqgPzTPnTv5', 'Coingate Hot Wallet'),('96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5', 'Jitotip'),('HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe', 'Jitotip'),('Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY', 'Jitotip'),('ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49', 'Jitotip'),('DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh', 'Jitotip'),('ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt', 'Jitotip'),('DttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL', 'Jitotip'),('3AVi9Tg9Uo68tJfuvoKvqKNWKkC5wPdSSdeBnizKZ6jT', 'Jitotip'),('9yj3zvLS3fDMqi1F8zhkaWfq8TZpZWHe6cz1Sgt7djXf', 'Phantom fees')) AS t(addr, reason)),validators AS (SELECT DISTINCT signer AS validatorFROM solana.vote_transactionsWHERE block_time >= now() - interval '7' day),base AS (SELECTblock_time,from_owner,to_owner,amount,token_mint_address,token_version,tx_id,CASEWHEN token_version = 'native'AND token_mint_address = 'So11111111111111111111111111111111111111111' THEN 'SOL'WHEN token_mint_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'ELSE NULLEND AS assetFROM tokens_solana.transfersWHERE block_time BETWEEN (SELECT t_from FROM params) AND (SELECT t_to FROM params)