Query editor
WITH token_info AS (SELECTcontract_address,max(symbol) AS symbolFROM tokens.transfersWHERE contract_address = 0x1219c409fabe2c27bd0d1a565daeed9bd9f271deGROUP BY 1),hourly_transfers AS (SELECTdate_trunc('hour', block_time) AS hour,contract_address,COUNT(*) AS transfer_events,COUNT(DISTINCT tx_hash) AS tx_count,SUM(CASEWHEN "to" IN (0x3b9345aa7765d0886384d91c422b7fb8eb276565,0x7ccc35ff53f4788133655e4434624e0b313998a1,0x6f3d3763e4dc2196bc354b1d6211d88ec8351780,0x3e549f0606555dab54b8a76dd8ca213d344608dd,0x6ee6462f65b922d5863bec36a3e6c2008be05291,0x708db14970c9079f64d552e8b3cf33525f0123d5,0xb39970b736c170d5dac8b846925f64566f8aee96,0xbd2f3b1aabdb4910829a445afcda7175c457753e,0xe1fc75e38acf1c133b09ee3e1de2710170f93ee2,0x13d8e224c3759a6e2c1f5f6c848dda2af3c489c4,0x143bb85e9314e97b55e61195bf0ed032e7291caa,0x1b5c6800daacb36a43c94378fcdc5d18e8f5e6e1,0xc38de6135c9d18ea378558a7e6c0c811dd4cb9c0,0x9c2bf15cc69740effef5717072a3d00f04afdf66,0xae07aac2b99fba6cd87b9bbbf4c5800f2d479ee0,0xb2b6164dcdd3281d356daa25c6b26344a35b4d34,0x1344f36afd7ec3b0cf4f537d06010cead06d9917,0xec6f9b5af519deb55dce5396076f28640400f66e,0x2788b4131b4c26d6b2bc2b10a4eef18b6560008c) THEN amountELSE 0END) AS amount_inflow,SUM(CASEWHEN "from" IN (0x3b9345aa7765d0886384d91c422b7fb8eb276565,0x7ccc35ff53f4788133655e4434624e0b313998a1,0x6f3d3763e4dc2196bc354b1d6211d88ec8351780,0x3e549f0606555dab54b8a76dd8ca213d344608dd,0x6ee6462f65b922d5863bec36a3e6c2008be05291,0x708db14970c9079f64d552e8b3cf33525f0123d5,0xb39970b736c170d5dac8b846925f64566f8aee96,0xbd2f3b1aabdb4910829a445afcda7175c457753e,0xe1fc75e38acf1c133b09ee3e1de2710170f93ee2,0x13d8e224c3759a6e2c1f5f6c848dda2af3c489c4,0x143bb85e9314e97b55e61195bf0ed032e7291caa,0x1b5c6800daacb36a43c94378fcdc5d18e8f5e6e1,0xc38de6135c9d18ea378558a7e6c0c811dd4cb9c0,0x9c2bf15cc69740effef5717072a3d00f04afdf66,0xae07aac2b99fba6cd87b9bbbf4c5800f2d479ee0,0xb2b6164dcdd3281d356daa25c6b26344a35b4d34,0x1344f36afd7ec3b0cf4f537d06010cead06d9917,