mlhTop 10 addresses with highest volume of bets
    Updated 2022-12-01
    WITH mx AS (
    SELECT DATEADD('hours', -7, MAX(block_timestamp)) AS recency
    FROM solana.core.fact_transactions
    WHERE block_timestamp >= CURRENT_DATE - 1
    ), b0 AS (
    SELECT tx_id
    , ARRAY_SIZE(account_keys) AS ak_sz
    , ARRAY_SIZE(instructions[0]:accounts) AS in_ac_sz
    , instructions[0]:accounts AS in_ac
    , signers[0]::string AS address
    , date_trunc('hour', DATEADD('hours', -7, block_timestamp)) AS hour
    , DATEADD('hours', -7, block_timestamp)::date AS date
    , ARRAY_SIZE(inner_instructions[0]:instructions) AS sz
    , inner_instructions[0]:instructions AS i
    , i[0]:parsed:info AS i0
    , i[1]:parsed:info AS i1
    , i[2]:parsed:info AS i2
    , i[3]:parsed:info AS i3
    , i[4]:parsed:info AS i4
    , i[5]:parsed:info AS i5
    , i[6]:parsed:info AS i6
    , i[0]:parsed:type::string AS type0
    , i[1]:parsed:type::string AS type1
    , i[2]:parsed:type::string AS type2
    , i[3]:parsed:type::string AS type3
    , COALESCE(i0:authority, i0:source)::string AS address0
    , i0:mint::string AS mint0
    , i1:mint::string AS mint1
    , i2:mint::string AS mint2
    , i3:mint::string AS mint3
    , i4:mint::string AS mint4
    , i5:mint::string AS mint5
    , COALESCE(i0:amount, i0:lamports)::int AS amt0_raw
    , COALESCE(i1:amount, i1:lamports)::int AS amt1_raw
    , COALESCE(i2:amount, i2:lamports)::int AS amt2_raw
    , COALESCE(i3:amount, i3:lamports)::int AS amt3_raw
    Run a query to Download Data