confirm mad 1

datavortexconfirm mad 1

Updated 2025-03-08

WITH SwapData AS (

SELECT

tx_hash,

origin_from_address AS trader,

block_timestamp

FROM

ink.core.ez_decoded_event_logs

WHERE

event_name = 'Swap'

AND origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'

AND block_timestamp IS NOT NULL

AND tx_succeeded = TRUE

token_transfers AS (

SELECT

tx_hash,

symbol,

amount_usd

FROM

ink.core.ez_token_transfers

transfers_with_index AS (

SELECT

tx_hash,

symbol,

amount_usd,

ROW_NUMBER() OVER (

PARTITION BY tx_hash

ORDER BY

LOWER(symbol) ASC

) AS symbol_index

FROM

token_transfers

amounts_with_index AS (

Last run: about 2 months ago

	TOKEN	CONTRACT_ADDRESS	TOTAL_VOLUME_USD	NUMBER_OF_TRADES
1	MAD	0x6a4e3d45e7931d283adcfac6821cdd2f17f80704	222411.36	5870
2	PURPLE	0xd642b49d10cc6e1bc1c6945725667c35e0875f22	1826934.54	1322
3	AK47	0x2a1bce657f919ac3f9ab50b2584cfc77563a02ec	651519.18	651
4	IAGENT	0x2e1ac42aef8dc9fb4c661d017273e93ba82d3d0e	685316.5	538
5	CYPHER	0x1b184de5952d11fe3e821fc58e6ef73d545f733e	295868	453
6	SHROOMY	0x0c5e2d1c98cd265c751e02f8f3293bc5764f9111	351510.3	333
7	PRL	0x75e7a5316e44755ff4ad724ee45337d1eef6895e	349135.2	327
8	RCN	0x78aec6f27f440eef34cd995b17f6a347f08eaab4	238393.32	304
9	PSD	0xcea0f8ed85e4eb981406e84ddca7062946093089	242387.32	288
10	MYST	0xee73d2f34d66f0f07af6ab37b42713520e33119c	227057.5	284
11	nsfi	0xb54830013cb7a524c5e7161246266c656359ab6a	356726.94	268
12	POKE	0x03792f3c7841c901916cb76882fb5a9e1902ab69	79953.58	233
13	USD₮0	0x0200c29006150606b650577bbe7b6248f58470c1	72867.9	200
14	FINK	0x3379b82e2c225788e876b415b4f27cbb66eec09b	115074.24	192
15	Arch	0xb816f5951a2e568d6eae351443c789c4f9fb55a7	84831.2	140
16	INKYME	0x1514c65c751d16bf253a9e82715771c5557e568b	62416.3	120
17	PENK	0x739ec5af87446fa8f7540cb028421139495b4e2d	69496.88	113
18	WATCH	0x53eb0098d09b8d1008f382bbd2a5d4f649111710	66375.38	107
19	BINK	0x905963ff2c1104ef175c93936fe7efa139c0edff	83355.68	107
20	VIOLET	0x487efe1c71712c45e493a9b5d60dddf852ddd48c	36271.64	96

3KB

flipside