sum(EVENT_DATA['amount_bet']) / 1e6 as amount_bet

FROM aptos.core.fact_events

WHERE EVENT_TYPE = '0x9ee4495a9a76be1993c68fce69bdd06283b52c6305497c05305bae0598aaed08::coinflip::FlipEventV2'

AND EVENT_DATA['coin_name'] = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC'

AND BLOCK_TIMESTAMP :: DATE >= '2024-08-01'