Trader JoeLB Users First Tx Part 2
Updated 2024-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from LB Users Part 2 @ https://flipsidecrypto.xyz/edit/queries/0d731ca2-ef21-4b99-9b31-4a14d20b671b
-- part 2 of list of LB users
select * from
(
SELECT
origin_from_address,
min(block_timestamp) as first_tx,
count(distinct tx_hash) as tx_count,
sum(coalesce(amount_in_usd,0)) as total_swapped
from
arbitrum.defi.ez_dex_swaps
WHERE
platform like ('trader-joe-v2')
group by origin_from_address
order by first_tx
)
where first_tx>'2023-03-28 11:17:57.000'
order by first_tx asc
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived