h4wkbase total
    Updated 2024-12-25
    -- forked from base @ https://flipsidecrypto.xyz/studio/queries/903667ba-7f04-4136-99d7-a901e0c084d9

    -- forked from base_top @ https://flipsidecrypto.xyz/studio/queries/b98e0cc2-c3ac-4c18-982b-a21d66043a4f

    with sport_bet as (
    select * from ( values
    ('Track', '100m Men', 'GqD7Z4bBrk4Di1RdBZgKkTqGqATU8y4hVL9pV3MYJuax'),
    ('Basketball', 'Men', '6uaHTknofocyicAU5n3qLyouwWmN9yJttShv9wVPYA5H'),
    ('Football', 'Men', '7953rN4TEJsDcYo4cHC5podjnydfAgWUD8PS99Ji2BAd'),
    ('Golf', 'Individual (Men)', 'EfW5WwaNUU28oVWmLb85h6427ULsvWw9jSZNTTwRn8AH'),
    ('Tennis', 'Single (Men)', 'JABb6UGE4nQWbTZsBb2gB9NEynGeChE7zjgL8KSipH6c'),
    ('Table Tennis', 'Single Finals (Men)', 'C3GpPLfZ7keTE5fcadkK5nw2MXDvnTqsN58gHeBYiqf2'),
    ('Rugby', 'Men', 'D6D4mfrLRdn8ah7wHQhBY2ga3PXgu9AbxrMznpFLbF2v'),
    ('Beach Volleyball', 'Women', 'E8d37Wu61HvVhJXJphuBh3Ync3r1MgvwKpDa2UcPUyt8'),
    ('Surfing', 'Men', '2YjibQnfo3qirAFHwVhS2gWU8evrRbVX8Z5Zfvhxdgqz'),
    ('Gymnastics', 'Women All-Around Individual', 'E4eQ5Y71udGf19pionX1aQAZZsb3dqtcN2RxXSFAcgD8'),
    ('Swimming', '100m Freestyle (Men)', '5oZmAGxRvUNCj4UiqYTbjDbtsBcLk1HADPcoa8cRtcY4'),
    ('Boxing', 'Heavyweight Final (Men)', 'yi7TrnaZmvnQXWRBEWwCTqoNvgAxU5ieeV2Bo9Tzypu'),
    ('Skateboarding', 'Park (Men)', 'HTkUCSVVXTcM2jweR85HqMnmWFM3b8KyqPnaWV8jmAvZ'),
    ('Cycling', 'Road Race (Men)', 'NvjpZr4k8x9xWaPn2hj5oLDBw7SU9D8Q29aeWkqNEXk'),
    ('Judo', 'Heavyweight Final (Men)', '2srUHDDkavGSHxEvFAya4xZvMQD9XtxZxSJt1WhKr7M7'),
    ('Taekwondo', 'Heavyweight (Men)', 'FtBfb6xH6jyqiAFP6jEHheoxUJzYyhLnqhyLuY3SrDP9'),
    ('Wrestling', 'Freestyle 74kg (Men)', '3TqD1viohXpXNgu8yUAz3MxizFFpwnRiKPAPkUZj2APd'),
    ('Triathlon', 'Individual (Men)', 'HJPkqCLEkCemx11Gq9uZej2t8Ckj9JtWszEstuAY6egq'),
    ('Water Polo', 'Men', 'EqSCCgiKLfZ8pk8ryvmQTcjYABzbj4PT1hUrLDGVbDvp'),
    ('Diving', '10m Platform (Men)', '2UTCRMCYurJTT6iPgLxPK1HJzYt5tvXSqXDkcgmwga6T'),
    ('Top Medaling Countries', 'Top Medaling Countries', '3Rw5UpZVZVQPePYMyiVZFuvVVFeLvvEKa2vza6ACPVwo')

    ) as t(sport, sport_type, vault_address)
    )
    , price as (
    select hour::date as price_date, avg(price) as price
    from solana.price.ez_prices_hourly
    where token_address = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    and price_date = current_date
    group by 1
    Last run: 28 days ago
    VOLUME
    VOLUME_USD
    BETTINGS
    BETTORS
    1
    3643000000121527.44416666736433174
    1
    41B
    37s