[Breakdown]Contract_Address

0xbi[Breakdown]Contract_Address

Updated 2025-03-26

-- forked from [Breakdown]Token @ https://flipsidecrypto.xyz/edit/queries/1b67eb49-7aad-4101-8f7e-72ca643ea115

with stable_token_dim as

(

select '0xdac17f958d2ee523a2206206994597c13d831ec7' as contract_address,'usdt' as symbol union all

select '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' as contract_address,'usdc' as symbol union all

select '0x6b175474e89094c44da98b954eedeac495271d0f' as contract_address,'dai' as symbol union all

select '0x0000000000085d4780b73119b644ae5ecd22b376' as contract_address,'tusd' as symbol union all

select '0x7b4b0b9b024109d182dcf3831222fbda81369423' as contract_address,'busd' as symbol union all

select '0x0c10bf8fcb7bf5412187a595ab97a3609160b5c6' as contract_address,'usdd' as symbol union all

select '0x853d955acef822db058eb8505911ed77f175b99e' as contract_address,'frax' as symbol union all

select '0x8e870d67f660d95d5be530380d0ec0bd388289e1' as contract_address,'usdp' as symbol union all

select '0xc5f0f7b66764f6ec8c8dff7ba683102295e16409' as contract_address,'fdusd' as symbol union all

select '0x056fd409e1d7a124bd7017459dfea2f387b6d5cd' as contract_address,'gusd' as symbol union all

select '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' as contract_address,'lusd' as symbol

contract_address_dim as

(

SELECT

address

from

(

SELECT CONTRACT_ADDRESS as address from ethereum.core.fact_event_logs group by 1

union all

SELECT CONTRACT_ADDRESS as address from ethereum.core.fact_contract_reads group by 1

) a

group by 1

pool_address_dim AS ( SELECT POOL_ADDRESS as address FROM ethereum.defi.dim_dex_liquidity_pools GROUP BY 1 ),

Last run: 3 months ago

	USER_ADDRESS	VALUE	LABEL_TYPE	SOURCE	LABEL_PRIORITY
1	0xc026395860db2d07ee33e05fe50ed7bd583189c7	469779990.91423	contract_address	contract_address	9
2	0xf6e72db5454dd049d0788e411b06cfaf16853042	386469961.483486	contract_address	contract_address	9
3	0xa1e2481a9cd0cb0447eeb1cbc26f1b3fff3bec20	333245428.45621	contract_address	contract_address	9
4	0xb80e23d02aacce6ad443adb5604252bf95378868	132587499.829147	contract_address	contract_address	9
5	0x37a807a10e3d0d9c55d089a481e9b30fb7839d64	96369876.855381	contract_address	contract_address	9
6	0x34c0bd5877a5ee7099d0f5688d65f4bb9158bde2	94503632.076184	contract_address	contract_address	9
7	0x25698c1155ca859ebfde7f318ea8ee256684e957	75000010	contract_address	contract_address	9
8	0xe61fdd2b8acd599d1a0ba0cfbeffffe46d26a222	70000020	contract_address	contract_address	9
9	0x89c5952d56ed4fae8a7c7dec37103a5036e967f7	65365687.206931	contract_address	contract_address	9
10	0xd7f9f54194c633f36ccd5f3da84ad4a1c38cb2cb	61240612.6385947	contract_address	contract_address	9
11	0x5c73e1cfdd85b7f1d608f7f7736fc8c653513b7a	54559877.002476	contract_address	contract_address	9
12	0x59708733fbbf64378d9293ec56b977c011a08fd2	53855999.902971	contract_address	contract_address	9
13	0x54a679e853281a440911f72eae0e24107e9413dc	50008738.189568	contract_address	contract_address	9
14	0xe3cbe3a636ab6a754e9e41b12b09d09ce9e53db3	48479432.671588	contract_address	contract_address	9
15	0x70213959a644baa94840bbfb4129550bceceb3c2	46517543.082207	contract_address	contract_address	9
16	0x312e67b47a2a29ae200184949093d92369f80b53	45020776.180696	contract_address	contract_address	9
17	0xe3490297a08d6fc8da46edb7b6142e4f461b62d3	40900662.068325	contract_address	contract_address	9
18	0xe292e50988ce0df8b7d7e5759498be1d1f77cd6a	34000396	contract_address	contract_address	9
19	0xb1a6ac52a21435c744b5b4129b07e6c44bcd629b	27756001.1	contract_address	contract_address	9
20	0xaa5741c1ea1e6aa82015ac63b54b8b8e247137e4	25964251.516468	contract_address	contract_address	9

...

1000

106KB

394s