mondovbase vs other
Updated 2024-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with prices_tab as (
SELECT price,
hour,
token_address
FROM base.price.ez_hourly_token_prices
WHERE price > 0 AND token_address IS NOT NULL
)
SELECT
platform,
COUNT(DISTINCT origin_from_address) as swappers,
COUNT(DISTINCT tx_hash) as swaps,
SUM(AMOUNT_OUT*price) as volume
FROM base.defi.ez_dex_swaps s
LEFT JOIN prices_tab p ON (s.token_out = p.token_address AND date_trunc('hour', s.block_timestamp) = p.hour)
GROUP BY platform
ORDER BY swappers DESC
QueryRunArchived: QueryRun has been archived