date_trunc('day', BLOCK_TIMESTAMP) as day,

sum(event_data ['size_delta']) / 1000000 as volume -- 6 decimals

aptos.core.fact_events

account_address = '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06'

AND event_type = '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PositionEvent'

AND BLOCK_TIMESTAMP :: DATE >= '2023-10-01'

GROUP BY

1