vivianngdoraWhich sports are receiving the most bets in total dollar volume on a daily basis?
    Updated 2022-08-24
    with main_contract as (
    select * from
    (values
    ('0xd67c96fa2d3070085c5ee32104773ccc2dbd21ac','Soccer'),
    ('0xd19a0d47f44393d238878bc49ce804bef3373647','Soccer'),
    ('0x840747e4e00c3e012bd93a3cf0bf419a7a01535a','Soccer'),
    ('0xfc2392649624f561590d76147d07bd19fe14309a','Soccer'),
    ('0x70121d2255d9f423e5d35462814657656f553110','Soccer'),
    ('0x738a2f1f823656885cb61d18373b47f0f15236ec','Soccer'),
    ('0xa2a3e2f1753ca73898a6d7ae6e511d5f36b89f38','Soccer'),
    ('0xb964b9b5c55efa0b7f52389283c4b42ba65e22c4','Soccer'),
    ('0xc7e8b40bfc2609becfab32dee7330b687b0611fd','Baseball'),
    ('0xb55a10da20ba4f2ddfdb470103143e6baba769dd','Baseball'),
    ('0x06eb14d138161508f02d517f4d3c792efde1d692','Baseball'),
    ('0xd438a559b880293808079aec4d12432221fc73a5','Baseball'),
    ('0x108267d6cd22291568e9260df5c122122de26e83','Baseball'),
    ('0x6d62cc028082fb750957375129fd3d313867fc60','Baseball'),
    ('0xedb993c2532d2dee8e80b1ce9e99bf2531f8d805','Baseball'),
    ('0xe91a8ca5ee5e6bd615039a5595b3d57fca18a488','Baseball'),
    ('0x03c2d5cc9e8791afa172b3d0a6f0f50aa110aa44','Baseball'),
    ('0xd088a349d9e29f002853cb70ec5caf5c5691b9ea','Baseball'),
    ('0x935fdc590d7e9dc1f72a1c3aff1011c7612a0a41','Baseball'),
    ('0xafc3fb03ea531cf24da1bb41fcb43b696758c1ba','Baseball'),
    ('0x074617d7ecb70562ea8f9f5f58c2ae4cba391e8c','Baseball'),
    ('0x733e2ea88cef947b0f93cb7ac9b401497a3ccf5f','Baseball'),
    ('0x781916f5a2b14cc3568b75a9198d37abc0532705','Baseball'),
    ('0x891f09b247d6ce4305a821ba7a41b09e6defa738','Baseball'),
    ('0x87b2abfbaaed7d340932832e455505df5bd1e8dc','Baseball'),
    ('0x20c291a9d4a3ecad2909195ed2abd01a3e4ed606','Baseball'),
    ('0x0e4024ba819f255c9b0431f6403ed8cead36fe5f','Baseball'),
    ('0x879fd211f4b2b8faaef7b5a06481804f6efbb673','Baseball'),
    ('0x7b0ecb93c3262e6256a3e3b50205585254b7f1d8','Baseball'),
    ('0x93f9c47021b8896f45a7586541100c96615069ab','Baseball'),
    ('0x84f663b0735ac11f491230f88c3078952951641e','Baseball'),
    ('0x6f521e183a120432b52f160ff1e14d7cf3a729e1','Baseball'),
    ('0xee0553346b7e642776135ab1f1241b13577ef32f','Baseball'),