SELECT distinct date_trunc('day',block_timestamp) as date, sum(raw_amount/1e18) over (order by date_trunc('day',block_timestamp)asc) as klay, 'Dragonswap' as Project

FROM kaia.core.fact_token_transfers

WHERE contract_address = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'

and to_address IN (

'0xb64ba987ed3bd9808dbcc19ee3c2a3c79a977e66',

'0x310ec7e68554492a6830f030afd72a112c4d261d',

'0xab9270593dbc94b13f76c960496865dd87c06489',

'0xd79539fd47089ad468a990e5075c8e1c5d724bfa',

'0x2d30da704c03f11de0255543476acc9e1322a1f5',

'0xd8f6db387b869a03df1530b71a896f82ea9b7488',

'0x5210d209ba80ce043eb3fbf934ca8ea5ce9018f4',

'0xd7bdafe82e80374550cd4a8ad94ea867ccd16062',

'0x9f9ff6d0b47c652ab2512771fb18781e29712c45',

'0xc0098324e43a48987972cfdf5b9edd1bf04c1435',

'0x1bf999a15257a68f32e4aef39a595a214c9ba0a0',

'0xd90028cd925a310ba7471991e36f0d6499d7b864',

'0xdc49e7ef3794275927cad7328235e581071b0378',

'0x3288aa19acdaac957dae670392b9568e39b686cd',

'0x00374284dd66f75134e51fab9e522dc322431c48',

'0xcc8336d19953f687a4a0fb4d6ca1053227e69a3e',

'0xfb6b00f575693079bf43e38c61354a88e6f30d57',

'0x9552b0004e591bdde2a21991a095e6d87900e635'

)

union all

SELECT distinct date_trunc('day',block_timestamp) as date, -sum(raw_amount/1e18) over (order by date_trunc('day',block_timestamp )asc) as klay, 'Dragonswap' as Project

FROM kaia.core.fact_token_transfers

WHERE contract_address = '0x19aac5f612f524b754ca7e7c41cbfa2e981a4432'

and from_address IN (

'0xb64ba987ed3bd9808dbcc19ee3c2a3c79a977e66',

'0x310ec7e68554492a6830f030afd72a112c4d261d',

'0xab9270593dbc94b13f76c960496865dd87c06489',