cons.created_block_number,

cons.created_block_timestamp,

cons.address as target,

cons.creator_address,

-- ins.sumin,

-- outs.sumout,

-- (sumin - sumout) as remain,

accounts.vnout,

accounts.vnin,

accounts.vremain as remain,

-- ins.ctoken as cintoken,

-- outs.ctoken as couttoken,

-- ins.cfrom,

-- outs.cto,

cons.name,

cons.decimals,

cons.symbol

-- (

-- SELECT

-- to_address as target,

-- sum(amount_usd) as sumin -- count(DISTINCT contract_address) as ctoken,

-- -- count(DISTINCT from_address) as cfrom

-- FROM

-- base.core.ez_token_transfers

-- GROUP BY

-- to_address

-- ) as ins,

-- (

-- SELECT

-- FROM_address as target,

-- sum(amount_usd) as sumout -- count(DISTINCT contract_address) as ctoken,

-- -- count(DISTINCT to_address) as cto

-- FROM

-- base.core.ez_token_transfers