DATE_TRUNC('day', BLOCK_TIMESTAMP) AS dhour,

'Outflow' AS action,

-SUM(RAW_AMOUNT/POW(10, 18)) AS balance_net

FROM ethereum.core.fact_token_transfers

where FROM_ADDRESS in (LOWER('0xe31a9498a22493ab922bc0eb240313a46525ee0a'),LOWER('0x712d0f306956a6a4b4f9319ad9b9de48c5345996')

,LOWER('0x93c08a3168fc469f3fc165cd3a471d19a37ca19e'),LOWER('0xca436e14855323927d6e6264470ded36455fc8bd')

,LOWER('0x83a127952d266a6ea306c40ac62a4a70668fe3bd'),LOWER('0xc5ed2333f8a2c351fca35e5ebadb2a82f5d254c3')

,LOWER('0x89183c0a8965c0299997be9af700a801bdccc2da'),LOWER('0xe5d0ef77aed07c302634dc370537126a2cd26590')

,LOWER('0x5d13f4bf21db713e17e04d711e0bf7eaf18540d6'),LOWER('0x882a812d75aee53efb8a144f984b258b6c4807f0')

,LOWER('0xbefe4f86f189c1c817446b71eb6ac90e3cb68e60'),LOWER('0xb78e90e2ec737a2c0a24d68a0e54b410fff3bd6b')

,LOWER('0x964d9d1a532b5a5daeacbac71d46320de313ae9c'),LOWER('0xfa453aec042a837e4aebbadab9d4e25b15fad69d')

,LOWER('0x4deb3edd991cfd2fcdaa6dcfe5f1743f6e7d16a6'),LOWER('0x477573f212a7bdd5f7c12889bd1ad0aa44fb82aa')

,LOWER('0xce31190a03fc3c5f23167e88e75066824823222d'),LOWER('0x60009b78da046ac64ef789c29ca05b79cdf73c10')

,LOWER('0x73c0ae50756c7921d1f32ada71b8e50c5de7ff9c'),LOWER('0x60ae578abdfded1fb0555f54148fdd7b400a34ed')

,LOWER('0xa726c00cda1f60aaab19bc095d02a46556837f31'),LOWER('0x0c0fe4e0236480e16b679ee1fd0c5247f9cf35f0')

,LOWER('0x0f4ee9631f4be0a63756515141281a3e2b293bbe'),LOWER('0x97137466bc8018531795217f0ecc4ba24dcba5c1')

,LOWER('0x84d34f4f83a87596cd3fb6887cff8f17bf5a7b83'),LOWER('0x78835265ac857bf3420830c71987b1a55f73c2dc')

,LOWER('0x4c8cfe078a5b989cea4b330197246ced82764c63'),LOWER('0x073dca8acbc11ffb0b5ae7ef171e4c0b065ffa47')

,LOWER('0x3507e4978e0eb83315d20df86ca0b976c0e40ccb'),LOWER('0xa6e683d5dccce898f16bb48071f08f2304c8ba09')

,LOWER('0x7cc549cdef7248c11a84d718fd25eafb57d8d614'))

and BLOCK_TIMESTAMP >= CURRENT_DATE() - interval '14 day'

and CONTRACT_ADDRESS = lower('0x50D1c9771902476076eCFc8B2A83Ad6b9355a4c9')

GROUP BY 1

UNION ALL

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS dhour,

'Inflow' AS action,

SUM(RAW_AMOUNT/POW(10, 18)) AS balance_net

FROM ethereum.core.fact_token_transfers

where TO_ADDRESS in (LOWER('0xe31a9498a22493ab922bc0eb240313a46525ee0a'),LOWER('0x712d0f306956a6a4b4f9319ad9b9de48c5345996')

,LOWER('0x93c08a3168fc469f3fc165cd3a471d19a37ca19e'),LOWER('0xca436e14855323927d6e6264470ded36455fc8bd')

,LOWER('0x83a127952d266a6ea306c40ac62a4a70668fe3bd'),LOWER('0xc5ed2333f8a2c351fca35e5ebadb2a82f5d254c3')

,LOWER('0x89183c0a8965c0299997be9af700a801bdccc2da'),LOWER('0xe5d0ef77aed07c302634dc370537126a2cd26590')