WHERE block_time > now() - interval '1 hour'
with poolytxns as ( SELECT "block_time" ,"value" , "price" FROM ethereum."transactions" e JOIN prices."layer1_usd" p ON p."minute" = date_trunc( 'minute', e.block_time) ) SELECT date_trunc( 'day', block_time) , SUM("value*price/1e18) FROM poolytxns WHERE "to" = '\x90B3832e2F2aDe2FE382a911805B6933C056D6ed' or "to" = '\x3545192b340F50d77403DC0A64cf2b32F03d00A9' or "to" = '\x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'
WHERE block_time > now() - interval '1 hour'
with poolytxns as ( SELECT "block_time" ,"value" , "price" FROM ethereum."transactions" e JOIN prices."layer1_usd" p ON p."minute" = date_trunc( 'minute', e.block_time) ) SELECT date_trunc( 'day', block_time) , SUM("value*price/1e18) FROM poolytxns WHERE "to" = '\x90B3832e2F2aDe2FE382a911805B6933C056D6ed' or "to" = '\x3545192b340F50d77403DC0A64cf2b32F03d00A9' or "to" = '\x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'
