jackguyuniswap on arb 3
Updated 2022-09-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with swap_hash as (
SELECT DISTINCT tx_hash
FROM arbitrum.core.fact_event_logs
WHERE contract_address LIKE '0x1aeedd3727a6431b8f070c0afaa81cc74f273882'
)
SELECT
count(DISTINCT tx_hash) as swaps,
COUNT(DISTINCT origin_from_address) as swappers,
count(DISTINCT contract_address) as tokens_swapped
FROM arbitrum.core.fact_token_transfers
LEFT outer JOIN arbitrum.core.dim_labels
ON contract_address = address
WHERE tx_hash in (SELECT * FROM swap_hash)
Run a query to Download Data