Query editor
WITH btrfly_balance AS(SELECT SUM(btrfly_balance) over (ORDER BY day) as btrfly_balance, dayFROM(SELECT SUM(btrfly_balance) as btrfly_balance,date_trunc('day', evt_block_time) as dayFROM(SELECT (CAST(value AS DOUBLE)/1e18) as btrfly_balance,evt_block_timeFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xc55126051B22eBb829D00368f4B12Bde432de5DaAND to in (0x69145ffcd44b16677140170d399cdc9ca245ff24,0x8f544093191ceaac7a4f90bef33755dbf34be424,0x9fea6d71bed43ab13cff10d8eeb9354d47f4e42c,0xbdb849041edaf21f1b40a5b52ab4b18a8803a146,0x9aef7c447f6bc8d010b22aff52d5b67785ed942c,0xcada41bdb95227ee3f3c2f4a37a843d384fbb48d,0x119c7bc8eccabe20766544b54395ccb7d228bf0e,0x59198d89a4881265a1170073efe20188098da5ac,0x72cca842a7fb986cb81efcf168282ca78578f0da,0x87f8ab89edf94af400a636e297e758c7bd05f1cc,0xe42fc9d50eb4bcb72202c638f3d567bba9e58ab4,0x5fd0ff1925fd29c13fb4fa45869ace06e56a602a,0x06c68c8d06d17c5988eca4179213db5304e8682d,0x48520ea6ed9d1eda7abdc9e87206a0f57bf8c3f4,0x7fc05030a6fb04dd84c4e4a7540002136038b53e,0x16d2f86f30945bed4042593cbba1ec413cc11e3d,0x9c7141e5865a0e3653e6f102ed4ce8110a760874,0xd0d628acf9e985c94a4542cae88e0af7b2378c81,0x5b7dcb8ce882f3d4c953c9f9d79e08730efe4939,0x2d23b731e5f04996a2dfdbe434c7d922afdb5e00,0x0895b21d1b3abe7d4f761b5870c36887cb310a5b,0x28d60bac08c058a9f7374aa24f8a514f27aff2b2,0x74045116edd9359cbcb608f3cc026dacfb9ed8d1,0x1cf1270fbe90d656b20abadfd792232de72b710a,0xda4ad44954c137c98eb210612b0bc0f172df17c5,0x8fc6d9b4264da9595102f68329a699d6dac62aea,0xab30f11201d6d53215729d45dc05a0966c237922,0x91b0c8525e941fc5deae744d925e4cbaa695b155,0x54b226cfa51b2bbb710435212aaa2340b74d51f4,0x20eadfcaf91bd98674ff8fc341d148e1731576a4,0xf76a99b2f417c88bcb77a3bc3654d78b3eddb7c6,0xd06363c5e4674c54771b9be4532b8f147ae89fd6,0xefb708b81069d0a3a79dc5d739ad4b44ab07e159,0xb0fae6175f7e8719885fe0d02c473977c30446fa,0x7c51967dfc95a847ea79fee64811470ce794fd13,0x8efe30c78018ecffd2570a507a450c538e094258,0x470c641f13651941254ee43215a1a2afa4eb0eaa,0x32349c94082a8cfd9cac7031f4ec980f8d94cbfd,0x968ace7737532ed22dae30f378158fec3aca1d56,0xfe95b935eabda9fc47233223c057c590e95ce47b,0x9cf5dec27768855d478152128851ebde74f6a3ed,0x4b3278f510e680cdd74cc875e436acd63fc96681,0x4d1f3ab93c79abfa8922fc9142e3fc28da4aa6c2,0x3a3909e70e36a74039570ac288057366e0a48b4e,0x841b152e501cdcb4f0452e5d69e8efad407759f3,0x7e3dea3ebd7a5772c0152665bd5a2c29e18647a7,0x30cd651a7e1e2eb06f419586cc996cba1e2ea733,0x0ce6c96bf1a83fea93305259176787bd051f4df1,0x3a7249b510add84a2196fb0fad9d8b745d807286,0xc5129824aae16a57228d31763ff870bd2fb80494,0x56601b7bbcabaa5a16b553c1f9bb7689f1612a99,0x4b0d93ecdadd048ec4cb10794fa48624e23a8c2d,