gross-tan

Sbhn_NPgross-tan

Updated 3 days ago

select distinct concat('0x', right(topics[2],40)) as "Trader",

count(distinct tx_hash) as "Swaps",

sum(amount_usd) as "USD Volume",

count(distinct block_timestamp::date) as "Active Days"

from ink.core.fact_event_logs

join ink.core.ez_token_transfers a using(tx_hash)

where topic_0 = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'

and concat('0x', right(topics[1],40)) = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'

and a.contract_address = '0x4200000000000000000000000000000000000006'

and concat('0x', right(topics[2],40)) != '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'

group by 1

order by 3 desc

limit 1000

Last run: 3 days ago

	Trader	Swaps	USD Volume	Active Days
1	0x842feafc4f604880419f13766488090966671555	166	113263.13	37
2	0x596384bdffc9f563b53791aeec50a42ff51c3e42	2103	87152.83	48
3	0xba7bac71a8ee550d89b827fe6d67bc3dca07b104	4394	81632.13	58
4	0xf68d2bfcecd7895bba05a7451dd09a1749026454	207	67792.52	45
5	0x692449a1a2d8f57de8a58f8f8fa30a8147e1c6e2	136	61480.25	28
6	0x4ed15a082116c89bf2a5cebb700d8925d81dfced	175	45453.16	20
7	0x86b38d97cdd7476dc08693580a7b2eb828d2ff09	76	42352.97	13
8	0x146d6422b3357dc52c2c96cfbf61a076bab586b0	134	40979.78	44
9	0x4388cb70d7e0ba4a9363f97ea08579364c60290e	36	39282.11	14
10	0x4b20f14701eb70910706f4ffc3059d9906144989	26	36796.95	12
11	0x7173ce51d1b494320229e06bbdbe0da258b9b547	10	31352.04	2
12	0x5d4d3fae4d0282fd8a558b5f42ba700974cbfd1a	106	30546.92	31
13	0xec3a167d1bb8cde7862c65c48f5335a7254c0192	21	29805.38	9
14	0x39b19a52120814e5c8ba1c26e010bd75683548a0	44	27537.01	14
15	0x1cb3a3523acc69bab0abea431ae0a457beacb9a3	92	23997.19	27
16	0x7ae206beb3c285378f9f216313516b9ca502c5db	93	22157.3	22
17	0xa48cd684ded1eee3de13e052bbdcfed59558a1ca	39	22126.46	11
18	0xbbd33948107e6c6e2bd6d5fee16f85abad3a4f07	11	21976.36	5
19	0x578fc7a5b72d62eadd1b3e97c9201d362cab63d7	30	21681.79	11
20	0x0cac9c3d7196f5bbd76fadcd771fb69b772c0f9d	7	19750.14	4

...

1000

58KB

flipside