flipside

CartanGrouptransfers copy

Updated 2024-02-09

-- forked from AMLBot / transfers @ https://flipsidecrypto.xyz/AMLBot/q/4bd8IVbMu3XF/transfers

select

sender,

b.address_name,

count(distinct tx_hash) transfers

from ethereum.defi.ez_dex_swaps a

LEFT JOIN ethereum.core.dim_labels b on a.sender = b.address

LEFT JOIN ethereum.core.dim_contracts c on a.sender = c.address

where

token_in = lower('0x6c3ea9036406852006290770bedfcaba0e23a0e8')

or token_out = lower('0x6c3ea9036406852006290770bedfcaba0e23a0e8')

AND tx_to != lower('0x0000000000000000000000000000000000000000')

and

block_timestamp::date >= '2023-08-01'

group by 1,2

order by 3 desc

Last run: about 1 year ago

	SENDER	ADDRESS_NAME	TRANSFERS
1	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	uniswap: universal router	861
2	0x1111111254eeb25477b68fb85ed929f73a960582	1inch: aggregator	837
3	0xdef1c0ded9bec7f1a1670819833240f027b25eff	0x: aggregator	472
4	0xe592427a0aece92de3edee1f18e0157c05861564	uniswap: router	429
5	0xe37e799d5077682fa0a244d46e5649f71457bd09		168
6	0x6719c6ebf80d6499ca9ce170cda72beb3f1d1a54		107
7	0x00000000009e50a7ddb7a7b0e2ee6604fd120e49		81
8	0x24902aa0cf0000a08c0ea0b003b0c0bf600000e0		60
9	0x6b75d8af000000e20b7a7ddf000ba900b4009a80		56
10	0x7174b67526dafb2dd1d6daabf3b5783c7090d15c		46
11	0x53facee52e897740b140f5304e9cd9dc6238d735		46
12	0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45	uniswap: router	29
13	0x5550d13389bb70f45fcef58f19f6b6e87f6e747d		29
14	0xf0d4c12a5768d806021f80a262b4d39d26c58b8d		28
15	0x493f461aead031cee2027f1b95370a692611acb9		25
16	0xf3de3c0d654fda23dad170f0f320a92172509127		22
17	0xad3b67bca8935cb510c8d18bd45f0b94f54a968f		21
18	0x3208684f96458c540eb08f6f01b9e9afb2b7d4f0	1inch: usdc router	17
19	0x0000000000a84d1a9b0063a910315c7ffa9cd248		16
20	0x7f137d1d8d20ba54004ba358e9c229da26fa3fa9		16

...

104

6KB

17s