jackguyuniswap on arb 8
Updated 2022-09-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with swap_hash as (
SELECT DISTINCT tx_hash
FROM arbitrum.core.fact_event_logs
WHERE contract_address LIKE '0x1aeedd3727a6431b8f070c0afaa81cc74f273882'
)
SELECT
date_trunc('day', block_timestamp) as day,
count(DISTINCT tx_hash) as swaps
-- COUNT(DISTINCT origin_from_address) as swappers
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)
AND address_name LIKE '{{token}}'
GROUP BY 1
Run a query to Download Data