VOLUME | VOLUME_USD | BETTINGS | BETTORS | |
---|---|---|---|---|
1 | 3643000000 | 121527.444166667 | 3643 | 3174 |
h4wkbase total
Updated 2024-12-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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
1
41B
37s