CALLER | MARKET_ID | IS_BUY | EXACT_INPUT | SWAP_ID | AMOUNT_IN | AMOUNT_OUT | FEES | END_LIMIT | END_SQRT_PRICE | MARKET_LIQUIDITY | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0x33166608a0132ae030193b7b3f6da995527c116699ae125e5e0c2deef7ff13d | 0x1ca77a20579834c033581704081bc156557e3495079a5bef6708c86164dfa13 | FALSE | TRUE | 348 | 5000000000000000000 | 1.1678227598824e+22 | 2500000000000000 | 8679038 | 4.75637441758028e+29 | 3.40282366920938e+38 |
2 | 0x4a8713ab7aff5e97fb1aa7652314a5ed6102b200da75ef42078a5a01fef4093 | 0x1ca77a20579834c033581704081bc156557e3495079a5bef6708c86164dfa13 | TRUE | TRUE | 308 | 1.11549411478935e+22 | 5469931853785550000 | 5577470573946740000 | 8669820 | 4.54213807776233e+29 | 3.40282366920938e+38 |
3 | 0x5b0d15b57812dcc801479f5bcf50eb3f07c061e36e4ce37a67604dd4e9f7508 | 0x73175976e4e17f7801bc9586dec61edd2df284143b1f56ff186528b1588db56 | TRUE | TRUE | 103 | 1059644665838380000 | 18759563427123200000 | 529822332919191 | 7622622 | 2.41718821876855e+27 | 3.40282366920938e+38 |
4 | 0x13a583d303ece834a205578bb259e1ef4410fe22f178c3ae33b1230ab6c2fb1 | 0x5d752306629db1fb505bb547e7c5a580dd8b879f8b1225e58454f88d5c04e5c | TRUE | TRUE | 275 | 100000000000000000000 | 2926579548607720 | 50000000000000000 | 8950489 | 1.84808305907561e+30 | 3.40282366920938e+38 |
5 | 0x1561a1c3e0c7dfa3a4ae77ee2d629d30764326d699effe5d2f22fd1da39d5c6 | 0x3712566252a658226542af5a8782ace70a05b11e4c34a98aa3d4541b89d2346 | TRUE | TRUE | 82 | 5.06005173802413e+21 | 122563915088809000 | 2530025869012060000 | 8969401 | 2.03136721032162e+30 | 3.40282366920938e+38 |
parkethHaiko - Event - Swap
Updated 2024-02-06
99
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 raw_data AS (
SELECT
ev.KEYS[0]:value AS caller,
ev.KEYS[1]:value AS market_id,
CASE
WHEN ev.KEYS[2]:value = '0x1' THEN TRUE
WHEN ev.KEYS[2]:value = '0x0' THEN FALSE
END AS is_buy,
CASE
WHEN ev.KEYS[3]:value = '0x1' THEN TRUE
WHEN ev.KEYS[3]:value = '0x0' THEN FALSE
END AS exact_input,
ev.KEYS[4]:value AS swap_id,
ev.PARAMETERS[0]:value[0]:value AS amount_in_low,
ev.PARAMETERS[0]:value[1]:value AS amount_in_high,
ev.PARAMETERS[1]:value[0]:value AS amount_out_low,
ev.PARAMETERS[1]:value[1]:value AS amount_out_high,
ev.PARAMETERS[2]:value[0]:value AS fees_low,
ev.PARAMETERS[2]:value[1]:value AS fees_high,
ev.PARAMETERS[3]:value AS end_limit,
ev.PARAMETERS[4]:value[0]:value AS end_sqrt_price_low,
ev.PARAMETERS[4]:value[1]:value AS end_sqrt_price_high,
ev.PARAMETERS[5]:value AS market_liquidity
-- ev.KEYS,
-- ev.PARAMETERS,
-- ev.EVENT_ID
FROM external.tokenflow_starknet.decoded_events ev
WHERE ev.CHAIN_ID = '{{network}}'
AND ev.CONTRACT = '{{address}}'
AND ev.NAME = 'Swap'
AND ev.TIMESTAMP > '2024-01-01 00:00:00'
LIMIT 5
)
SELECT
caller,
market_id,
Last run: about 1 year ago
5
1KB
1s