Query editor
-- ETH Smart Money Flow Time Series-- Whale / Shark accumulation-distribution over time-- JST output-- Positive netflow = accumulation-- Negative netflow = distributionWITH 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_prices AS (SELECTDATE_TRUNC('day', minute) AS day_utc,AVG(price) AS eth_price_usdFROM prices.usdWHERE blockchain = 'ethereum'AND contract_address = 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2AND minute >= NOW() - INTERVAL '30' dayGROUP BY 1),eth_inflows AS (SELECT