SELECT sum(EVENT_DATA['amount_bet']) / 1e8 as total_amount_bet
FROM aptos.core.fact_events
WHERE EVENT_TYPE = '0x9ee4495a9a76be1993c68fce69bdd06283b52c6305497c05305bae0598aaed08::roulette::RouletteEvent'
AND EVENT_DATA['coin_name'] = '0x1::aptos_coin::AptosCoin'
AND BLOCK_TIMESTAMP :: DATE >= '2024-05-05'