flipside

    gh -chs
    Hessishgh -chs
    Updated 2025-03-26
    with eclipse_txs_buy as

    (select AMOUNT/1e6 as usd,
    a.TX_FROM as user,
    a.TX_ID,
    a.BLOCK_TIMESTAMP,
    SUBSTRING (ARRAY_TO_STRING(LOG_MESSAGES, '\n'),
    POSITION('token_id: ' IN ARRAY_TO_STRING(LOG_MESSAGES, '\n')) + 10, 78 ) AS token_id
    from eclipse.core.fact_transfers a
    join eclipse.core.fact_transactions b
    on a.TX_ID = b.TX_ID
    where a.BLOCK_TIMESTAMP::date >= '2024-12-04' and
    a.TX_FROM != 'AF2sa2kFHgZF8oMDzP8aUCveM5T1LpRBDC3eP4zW7w5R' and
    a.MINT = 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' and
    a.SUCCEEDED = 'TRUE'
    and
    a.tx_id in
    (select DISTINCT tx_id
    from eclipse.core.fact_events_inner
    where a.BLOCK_TIMESTAMP::date >= '2024-12-04' and
    EVENT_TYPE = 'transferChecked'
    and INSTRUCTION_PROGRAM_ID = 'E98KDQN4NuhPcj4KD82pZj122KxYZ9dNhsNaAbPXLkeY')),

    bet_data_buy as

    (select QUESTION,
    TOKEN_1_OUTCOME as choice,
    user,
    usd,
    TX_ID ,
    BLOCK_TIMESTAMP,
    CONDITION_ID
    from external.polymarket.dim_markets
    join eclipse_txs_buy on 0||TOKEN_1_TOKEN_ID::string=token_id::string

    union
    Last run: about 1 month ago
    TIME
    MARKET
    BET volume (USDC)
    Total placed bets
    1
    		2025-01-18 00:00:00.000🦁 PL Winner211854.288536114
    2
    		2025-02-02 00:00:00.000BTC price/March14744.22673492
    3
    		2025-01-04 00:00:00.000🏆 CL Winner25575.587078120
    4
    		2025-01-18 00:00:00.000🏅 NFL MVP306192.84014112
    5
    		2025-01-03 00:00:00.000Trump pardon2212.71033664
    6
    		2025-01-14 00:00:00.000Fed desicion Jan.7197.888104222
    7
    		2025-01-16 00:00:00.000East Conference Champion870.29739426
    8
    		2025-01-25 00:00:00.000🏀 NBA Finals530.00084410
    9
    		2024-12-31 00:00:00.000119th congress speaker806.87400828
    10
    		2024-12-28 00:00:00.000Trump Defense Secretary1184
    11
    		2024-12-21 00:00:00.000🏆 CL Winner81.1827622
    12
    		2025-02-05 00:00:00.000Ethereum price/March3602.65647847
    13
    		2024-12-25 00:00:00.000🎈 2024 airdrops1248.357294119
    14
    		2024-12-13 00:00:00.000🏅 NFL MVP220.71436838
    15
    		2025-01-19 00:00:00.000🦁 PL Winner43165.734744107
    16
    		2025-01-22 00:00:00.000🏅 NFL MVP1216.0923528
    17
    		2025-01-06 00:00:00.000La Liga winner13980.69171238
    18
    		2025-02-02 00:00:00.000🏆 CL Winner18033.74905836
    19
    		2024-12-11 00:00:00.000🏆 CL Winner407.00065674
    20
    		2025-01-25 00:00:00.000🏅 NFL MVP613.91861820
    ...
    720
    44KB
    414s