mlhTop 10 addresses with highest volume of bets
Updated 2022-12-01
999
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
›
⌄
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