1SELECT id, symbol, name, decimals, tx_count FROM base.uniswap_token
2ORDER BY tx_count DESC
3LIMIT 20;
4
5
6
7
8
9
10
11
12
13

1SELECT *
2FROM eth.uniswap_Pool
3WHERE created_at_timestamp = '2021-05-05 19:32:40';
4
5
6
7
8
9
10
11
12
13
14

1SELECT
2  'swap' AS action,
3  pool,
4  amount_in,
5  amount_out,
6  atob,
7  fee_amount,
8  NULL AS liquidity_removed,
9  NULL AS amountA,
10  NULL AS amountB,
11  "txDigest",
12  "eventSeq",
13  "timestampMs"
14FROM
15  sui.cetus_swap
16WHERE
17  sender = '0xe28b50cef1d633ea43d3296a3f6b67ff0312a5f1a99f0af753c85b8b5de8ff06'
18
19UNION ALL
20
21SELECT
22  'remove_liquidity' AS action,
23  pool,
24  NULL AS amount_in,
25  NULL AS amount_out,
26  NULL AS atob,
27  NULL AS fee_amount,
28  liquidity AS liquidity_removed,
29  "amountA",
30  "amountB",
31  "txDigest",
32  "eventSeq",
33  "timestampMs"
34FROM
35  sui.cetus_remove_liquidity
36WHERE
37  sender = '0xe28b50cef1d633ea43d3296a3f6b67ff0312a5f1a99f0af753c85b8b5de8ff06'
38
39ORDER BY
40  "timestampMs" DESC;
41
42
43
44
45
46
47
48
49
50
51
52
53

1SELECT 
2  transaction_id,
3  sender,
4  recipient,
5  token0_id,
6  amount_usd,
7  timestamp
8FROM base.uniswap_swap
9WHERE token0_id = '0xb8D98a102b0079B69FFbc760C8d857A31653e56e'
10   OR token1_id = '0xb8D98a102b0079B69FFbc760C8d857A31653e56e'
11ORDER BY amount_usd DESC
12LIMIT 1000;
13
14
15
16
17
18
19
20
21
22
23
24