Query editor
-- ETH Smart Money Flow (Recommended Version)-- 7 days-- 4-hour aggregation-- Whale/Shark focus-- JST output-- Designed for short-mid term trend analysisWITH exchange_wallets AS (SELECT address FROM (VALUES(0x28C6c06298d514Db089934071355E5743bf21d60),(0x21a31Ee1afC51d94C2eFcCAa2092aD1028285549),(0x71660c4005BA85c37ccec55d0C4493E66Fe775d3),(0x503828976D22510aad0201ac7EC88293211D23Da),(0x2910543Af39abA0Cd09dBb2D50200b3E800A63D2),(0x267be1C1D684F78cb4F6a176C4911b741E4Ffdc0),(0x6cC5F688a315f3dC28A7781717a9A798a59fDA7b),(0x1151314c646Ce4E0eFD76d1aF4760aE66a9Fe30F),(0x742d35Cc6634C0532925a3b844Bc9e7595f2bD28),(0xd24400ae8BfEBb18cA49Be86258a3C749cf46853),(0xf16E9B0D03470827A95CDfd0Cb8a8A3b46969B91),(0x0D0707963952f2fBA59dD06f2b425ace40b492Fe),(0xAb5C66752a9e8167967685F1450532fB96d5d24f),(0xf89d7b9c864f589bbF53a82105107622B35EaA40)) AS t(address)),excluded_addresses AS (SELECT address FROM (VALUES(0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2),(0x00000000219ab540356cBB839Cbe05303d7705Fa),(0x0000000000000000000000000000000000000000),(0x000000000000000000000000000000000000dEaD)) AS t(address)),-- =========================================-- ETH PRICE (4H)-- =========================================eth_prices AS (SELECTDATE_TRUNC('hour',minute)-INTERVAL '1' hour* (HOUR(minute) % 4)AS bucket_utc,