Query editor
with weekly_transfers as (selectdate_trunc('week', block_date) as week_start, *from tokens.transferswhere tx_from in (0xDbDf3D8ED80f84c35d01c6C9F9271761BAd90Ba6, 0xD8Dfc729cBd05381647EB5540D756f4f8Ad63eec, 0x9aAE2B0d1b9dC55Ac9Bab9556F9a26Cb64995Fb9, 0x3A70788150c7645a21b95b7062ab1784D3cc2104, 0x708E57B6650a9a741Ab39CAE1969Ea1D2D10ECA1, 0xCE82Eeec8e98e443EC34Fda3c3E999Cbe4Cb6aC2, 0x7f6D822467Df2A85F792d4508c5722ade96Be056, 0x001dDaBbA5782eE48842318BD9FF4008647c8D9C, 0x9C09FAa49C4235A09677159fF14f17498ac48738, 0xcbB10C30a9a72fae9232F41CBbd566a097B4E03a, 0x9fb2714AF0A84816F5C6322884F2907E33946b88, 0x47d8b3c9717e976f31025089384f23900750a5f4, 0x94701e1df9ae06642bf6027589b8e05dc7004813, 0x552300992857834c0ad41c8e1a6934a5e4a2e4ca, 0xd7469bf02d221968ab9f0c8b9351f55f8668ac4f, 0x88800e08e20b45c9b1f0480cf759b5bf2f05180c, 0x6831508455a716f987782a1ab41e204856055cc2, 0xdc8fbad54bf5151405de488f45acd555517e0958, 0x91d313853ad458addda56b35a7686e2f38ff3952, 0xadd5585c776b9b0ea77e9309c1299a40442d820f, 0x4ffeffa616a1460570d1eb0390e264d45a199e91, 0x8f5cb67b49555e614892b7233cfddebfb746e531, 0x67b9ce703d9ce658d7c4ac3c289cea112fe662af, 0x68a96f41ff1e9f2e7b591a931a4ad224e7c07863, 0x97acce27d5069544480bde0f04d9f47d7422a016, 0xa32ccda98ba7529705a059bd2d213da8de10d101)and blockchain = 'base'and block_number > 21144091)selectweek_start, count(distinct "from") as unique_buyers, count(distinct "to") as unique_sellers, count("from") as buys, count("to") as sells, COUNT(*) as transfer_count, sum(amount) as total_value_raw_moved, sum(amount_usd) as total_value_movedfrom weekly_transfersgroup byweek_startorder byweek_start desc