Query editor
WITH token_dataset AS (SELECT address, name, currency, decimals, region, clusterFROM (VALUES(0x269caE7Dc59803e5C596c95756faEeBb6030E0aF,'MXNE','MXN',6,'Mexico','North America'),(0x18Bc5bcC660cf2B9cE3cd51a404aFe1a0cBD3C22,'IDRX','IDR',2,'Indonesia','Southeast Asia'),(0x46C85152bFe9f96829aA94755D9f915F9B10EF5F,'CNGN','NGN',6,'Nigeria','Africa'),(0xe743f13623e000261b634f0e5676f294475ec24d,'NGNC','NGN',18,'Nigeria','Africa'),(0xb755506531786C8aC63B756BaB1ac387bACB0C04,'ZARP','ZAR',18,'South Africa','Africa'),(0x2dD087589ce9C5b2D1b42e20d2519B3c8cF022b7,'NZDD','NZD',6,'New Zealand','Oceania'),(0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42,'EURC','EUR',6,'EU','Europe'),(0x4933a85b5b5466fbaf179f72d3de273c287ec2c2,'EURAU','EUR',6,'EU','Europe'),(0x043eB4B75d0805c43D7C834902E335621983Cf03,'CADC','CAD',18,'Canada','North America'),(0xE9185Ee218cae427aF7B9764A011bb89FeA761B4,'BRZ','BRL',18,'Brazil','Latin America'),(0x1a9be8a692de04bcb7ce5cddd03afca97d732c62,'TRYB','TRY',8,'Turkey','Europe'),(0xFb8718a69aed7726AFb3f04D2Bd4bfDE1BdCb294,'TRYB','TRY',6,'Turkey','Europe'),(0x4ed9df25d38795a47f52614126e47f564d37f347,'VEUR','EUR',18,'EU','Europe'),(0x1fca74d9ef54a6ac80ffe7d3b14e76c4330fd5d8,'VCHF','CHF',18,'Switzerland','Europe'),(0xaeb4bb7debd1e5e82266f7c3b5cff56b3a7bf411,'VGBP','GBP',18,'UK','Europe'),(0x27f6c8289550fce67f6b50bed1f519966afe5287,'TGBP','GBP',18,'UK','Europe'),(0xe29410178928ecbf0f20203ede333aa6058c8767,'ARST','ARS',18,'Argentina','Latin America'),(0xf016413834E6D1A14F3D628B11D6Ef725a6bdbDD,'ARGT','ARS',18,'Argentina','Latin America'),(0x449b3317a6d1efb1bc3ba0700c9eaa4ffff4ae65,'AUDD','AUD',6,'Australia','Oceania'),(0xdC200537D99d8b4f0C89D59A68e29b67057d2c5F,'THBT','THB',6,'Thailand','Southeast Asia'),(0xfCB34c47f850f452C15EA1B84d51231C38A61783,'BRLA','BRL',18,'Brazil','Latin America'),(0xd2047ebdb205Ee6862b69ae9fB3501652cC97d36,'BRLV','BRL',18,'Brazil','Latin America'),(0xd2a530170D71a9Cfe1651Fb468E2B98F7Ed7456b,'AUDF','AUD',6,'Australia','Oceania'),(0x0DC4F92879B7670e5f4e4e6e3c801D229129D90D,'wARS','ARS',18,'Argentina','Latin America'),(0x3eD03E95DD894235090B3d4A49E0C3239EDcE59e,'MYRC','MYR',18,'Malaysia','Southeast Asia'),(0x2A2f398d4DCeEB02d66a1BfFd6FaF1EAFa2318C9,'UGXC','UGX',6,'Uganda','Africa'),(0x0A4C9cb2778aB3302996A34BeFCF9a8Bc288C33b,'XSGD','SGD',6,'Singapore','Southeast Asia'),(0xF476BA983DE2F1AD532380630e2CF1D1b8b10688,'nTZS','TZS',18,'Tanzania','Africa'),(0xCf3783ABaF4A11da1382F0c49748Fa87a1b6b739,'MXNB','MXN',18,'Mexico','North America'),(0x8a1d45e102e886510e891d2ec656a708991e2d76,'WCOP','COP',18,'Colombia','Latin America'),(0x4F34c8b3b5FB6D98Da888F0feA543d4d9C9F2eBE,'WPEN','PEN',18,'Peru','Latin America'),(0x61D450a098b6a7f69fC4b98CE68198fe59768651,'WCLP','CLP',18,'Chile','Latin America'),(0x6d7432114c148a8975906716b9d3ddac6bb83cf1,'ARSX','ARS',6,'Argentina','Latin America')) AS t(address, name, currency, decimals, region, cluster)),mints_burns AS (SELECTdate_trunc('day', evt_block_time) AS block_date,l.name AS symbol,l.currency,l.region,l.cluster,SUM(CASEWHEN "from" = 0x0000000000000000000000000000000000000000THEN value / POWER(10, l.decimals)WHEN "to" = 0x0000000000000000000000000000000000000000THEN -value / POWER(10, l.decimals)END) AS daily_amountFROM erc20_base.evt_transfer tINNER JOIN token_dataset lON l.address = t.contract_addressWHERE"from" = 0x0000000000000000000000000000000000000000