2024-02-09 03:58 PM

mmdreza2024-02-09 03:58 PM

Updated 2024-02-09

select

distinct tx_hash as tx,

sum(eth_value)

from arbitrum.core.fact_transactions

where from_address like ('0x037ac478992e23340fbd4114f218943037916300')

or to_address like ('0x037ac478992e23340fbd4114f218943037916300')

group by 1

order by 2 desc

Last run: about 1 year ago

	TX	SUM(ETH_VALUE)
1	0xd8d35fd8fcf710db8b87b2e533a1444efa7ef2fef5b56fa033734f475f9aaacf	0.1782
2	0x922eb9f7eceef9a5c2e88b379e8e25b6a27df509aeac60c0217e75548afa2924	0.17
3	0x4926768838e9198ce100f353e7680a0a2bbc37d97ebaf4c4b4d98821f71141c5	0.1093
4	0xa905a795501b7f57600231dedbcbc69c0a81fb0807815e9c6818ca67efb08f3c	0.109
5	0xb1f6673f5dc934cf577cc79f651bf522e1dca2ea79015368f741bb115a0c1855	0.0842
6	0x6f1b8dd5f1e17e2c33ce3058266e8c912f6e17dd97b616f7aa3cb888e75981ce	0.0671
7	0xb64e02aff68439791251e3d1f4af1dab5e6fc860579900346f597d33d730a35b	0.03325732295
8	0x6841fa28fbe092b9937d114c2f51e2142fe31ccf7f398c2a60bf4126057cdcbb	0.031
9	0xd09b0b7377edc2e60e8cc7ac7adb14ce64616a02f7b6f30f199f8640f95780a8	0.02219753418
10	0x91a22c05317d1c34832e99f466b25b042d18a6a7a2952a7bb234c95ad6051bbd	0.0208524086
11	0xcf15887287c19ae3ec6b6c24198b30cede043345606b53341bd8c684bcbfa9ae	0.0135
12	0xe5425b8ee5e809d3fad08f7b9966fcd7f605a9e487afb221fa9d745245a2792c	0.012
13	0xc7fd15487d636847cf32c340c8b744ea0c4a31ef8a62db677378a3d23d3337db	0.011
14	0xbc541b159698eae30e51de8f471704e93c0f5302c1f2fdbdb874bee556b4378b	0.01
15	0x9a95e2bdda4e98e2f9dc7f482aa542f1eb601d73baacb6d70080ba540d62c9e9	0.008
16	0x9619796c62d76d5fc612725b4c4d767a1831c257e6bd98d84d6c72442368b317	0.008
17	0xfa9b6e908b9c9b3ff428be6e65a9b84063bd8fbbfad330ee70f7efa2eaacd0b2	0.008
18	0xd49cc92330dbcf48d1f93f2297978f7b55c11fb16371b974296bb909b78bbce8	0.007
19	0x0e6140f8523c3b85f269775097320ab28a95323cccd901742c04b5bfd29e72fd	0.004831750408
20	0x657af543fa2e722ac89d79d6328f0c1df27154bb94edefe199231b75e90a6a30	0.0048

...

298

22KB

flipside

flipside