Abbas_ra21USDC Swap 2
Updated 2025-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from USDC Transfers copy @ https://flipsidecrypto.xyz/edit/queries/b1cb30b0-38f2-4e68-b43a-915c02a5aea5
select
count(DISTINCT Trader) AS Traders,
count(*) AS Trades,
sum(
case
when TOKEN_IN_CONTRACT in (
'17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1',
'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near'
) then AMOUNT_IN_RAW / 1e6
else AMOUNT_OUT_RAW / 1e6
end
) AS Volume,
avg(
case
when TOKEN_IN_CONTRACT in (
'17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1',
'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near'
) then AMOUNT_IN_RAW / 1e6
else AMOUNT_OUT_RAW / 1e6
end
) AS "Avg Swap Size"
from
near.defi.ez_dex_swaps
inner join near.core.fact_transactions using(TX_HASH)
where
(
TOKEN_IN_CONTRACT in (
'17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1',
'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near'
)
or TOKEN_out_CONTRACT in (
'17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1',
'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near'
)
QueryRunArchived: QueryRun has been archived