dune.xyz
Open in
urlscan Pro
76.76.21.21
Public Scan
URL:
https://dune.xyz/queries/37674/74643
Submission: On November 03 via manual from US — Scanned from DE
Submission: On November 03 via manual from US — Scanned from DE
Form analysis 1 forms found in the DOM
<form role="search" aria-label="Site" class="global-search_wrapper__1ByhR">
<div class="input_input__2HTtZ input_icon__Ah8n8 input_xs__CA-0o"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="search" aria-hidden="true" alt="" height="1em" width="1em"
xmlns="http://www.w3.org/2000/svg">
<path fill-rule="evenodd" d="M10.442 10.442a1 1 0 011.415 0l3.85 3.85a1 1 0 01-1.414 1.415l-3.85-3.85a1 1 0 010-1.415z" clip-rule="evenodd"></path>
<path fill-rule="evenodd" d="M6.5 12a5.5 5.5 0 100-11 5.5 5.5 0 000 11zM13 6.5a6.5 6.5 0 11-13 0 6.5 6.5 0 0113 0z" clip-rule="evenodd"></path>
</svg><input type="search" placeholder="Search..." autocomplete="off" value=""></div>
<div aria-label="Shortcut" class="global-search_shortcutHint__3e32J">ctrl+p</div>
<ul class="global-search_results__1ODiZ menu-panel_menu__VRIxb" role="listbox">
<li class="menu-panel_active__3Q6eG menu-panel_categoryHeader__1zW3N" role="option" aria-selected="true">
<a tabindex="-1" href="/browse/dashboards?q="><span>Dashboards</span><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="arrow-right" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M10.146 4.646a.5.5 0 01.708 0l3 3a.5.5 0 010 .708l-3 3a.5.5 0 01-.708-.708L12.793 8l-2.647-2.646a.5.5 0 010-.708z" clip-rule="evenodd"></path><path fill-rule="evenodd" d="M2 8a.5.5 0 01.5-.5H13a.5.5 0 010 1H2.5A.5.5 0 012 8z" clip-rule="evenodd"></path></svg></a>
</li>
<li class="" role="option" aria-selected="false">
<a tabindex="-1" href="/hagaetc/dex-metrics"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="dashboard" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M1 2.5A1.5 1.5 0 012.5 1h3A1.5 1.5 0 017 2.5v3A1.5 1.5 0 015.5 7h-3A1.5 1.5 0 011 5.5v-3zM2.5 2a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3zm6.5.5A1.5 1.5 0 0110.5 1h3A1.5 1.5 0 0115 2.5v3A1.5 1.5 0 0113.5 7h-3A1.5 1.5 0 019 5.5v-3zm1.5-.5a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3zM1 10.5A1.5 1.5 0 012.5 9h3A1.5 1.5 0 017 10.5v3A1.5 1.5 0 015.5 15h-3A1.5 1.5 0 011 13.5v-3zm1.5-.5a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3zm6.5.5A1.5 1.5 0 0110.5 9h3a1.5 1.5 0 011.5 1.5v3a1.5 1.5 0 01-1.5 1.5h-3A1.5 1.5 0 019 13.5v-3zm1.5-.5a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3z" clip-rule="evenodd"></path></svg><span>DEX metrics 📊</span></a>
</li>
<li class="" role="option" aria-selected="false">
<a tabindex="-1" href="/rchen8/defi-users-over-time"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="dashboard" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M1 2.5A1.5 1.5 0 012.5 1h3A1.5 1.5 0 017 2.5v3A1.5 1.5 0 015.5 7h-3A1.5 1.5 0 011 5.5v-3zM2.5 2a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3zm6.5.5A1.5 1.5 0 0110.5 1h3A1.5 1.5 0 0115 2.5v3A1.5 1.5 0 0113.5 7h-3A1.5 1.5 0 019 5.5v-3zm1.5-.5a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3zM1 10.5A1.5 1.5 0 012.5 9h3A1.5 1.5 0 017 10.5v3A1.5 1.5 0 015.5 15h-3A1.5 1.5 0 011 13.5v-3zm1.5-.5a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3zm6.5.5A1.5 1.5 0 0110.5 9h3a1.5 1.5 0 011.5 1.5v3a1.5 1.5 0 01-1.5 1.5h-3A1.5 1.5 0 019 13.5v-3zm1.5-.5a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3z" clip-rule="evenodd"></path></svg><span>DeFi users over time</span></a>
</li>
<li class="" role="option" aria-selected="false">
<a tabindex="-1" href="/rchen8/opensea"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="dashboard" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M1 2.5A1.5 1.5 0 012.5 1h3A1.5 1.5 0 017 2.5v3A1.5 1.5 0 015.5 7h-3A1.5 1.5 0 011 5.5v-3zM2.5 2a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3zm6.5.5A1.5 1.5 0 0110.5 1h3A1.5 1.5 0 0115 2.5v3A1.5 1.5 0 0113.5 7h-3A1.5 1.5 0 019 5.5v-3zm1.5-.5a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3zM1 10.5A1.5 1.5 0 012.5 9h3A1.5 1.5 0 017 10.5v3A1.5 1.5 0 015.5 15h-3A1.5 1.5 0 011 13.5v-3zm1.5-.5a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3zm6.5.5A1.5 1.5 0 0110.5 9h3a1.5 1.5 0 011.5 1.5v3a1.5 1.5 0 01-1.5 1.5h-3A1.5 1.5 0 019 13.5v-3zm1.5-.5a.5.5 0 00-.5.5v3a.5.5 0 00.5.5h3a.5.5 0 00.5-.5v-3a.5.5 0 00-.5-.5h-3z" clip-rule="evenodd"></path></svg><span>OpenSea</span></a>
</li>
<li class="menu-panel_categoryHeader__1zW3N" role="option" aria-selected="false">
<a tabindex="-1" href="/browse/queries?q="><span>Queries</span><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="arrow-right" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M10.146 4.646a.5.5 0 01.708 0l3 3a.5.5 0 010 .708l-3 3a.5.5 0 01-.708-.708L12.793 8l-2.647-2.646a.5.5 0 010-.708z" clip-rule="evenodd"></path><path fill-rule="evenodd" d="M2 8a.5.5 0 01.5-.5H13a.5.5 0 010 1H2.5A.5.5 0 012 8z" clip-rule="evenodd"></path></svg></a>
</li>
<li class="" role="option" aria-selected="false">
<a tabindex="-1" href="/queries/83579"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="query" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M14 2H2a1 1 0 00-1 1v10a1 1 0 001 1h12a1 1 0 001-1V3a1 1 0 00-1-1zM2 1a2 2 0 00-2 2v10a2 2 0 002 2h12a2 2 0 002-2V3a2 2 0 00-2-2H2z" clip-rule="evenodd"></path><path fill-rule="evenodd" d="M6 9a.5.5 0 01.5-.5h3a.5.5 0 010 1h-3A.5.5 0 016 9zM3.146 4.146a.5.5 0 01.708 0l2 2a.5.5 0 010 .708l-2 2a.5.5 0 11-.708-.708L4.793 6.5 3.146 4.854a.5.5 0 010-.708z" clip-rule="evenodd"></path></svg><span>Custom NFT Floor Tracker</span></a>
</li>
<li class="" role="option" aria-selected="false">
<a tabindex="-1" href="/queries/1847"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="query" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M14 2H2a1 1 0 00-1 1v10a1 1 0 001 1h12a1 1 0 001-1V3a1 1 0 00-1-1zM2 1a2 2 0 00-2 2v10a2 2 0 002 2h12a2 2 0 002-2V3a2 2 0 00-2-2H2z" clip-rule="evenodd"></path><path fill-rule="evenodd" d="M6 9a.5.5 0 01.5-.5h3a.5.5 0 010 1h-3A.5.5 0 016 9zM3.146 4.146a.5.5 0 01.708 0l2 2a.5.5 0 010 .708l-2 2a.5.5 0 11-.708-.708L4.793 6.5 3.146 4.854a.5.5 0 010-.708z" clip-rule="evenodd"></path></svg><span>Monthly DEX Volume By Project</span></a>
</li>
<li class="" role="option" aria-selected="false">
<a tabindex="-1" href="/queries/4319"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="query" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M14 2H2a1 1 0 00-1 1v10a1 1 0 001 1h12a1 1 0 001-1V3a1 1 0 00-1-1zM2 1a2 2 0 00-2 2v10a2 2 0 002 2h12a2 2 0 002-2V3a2 2 0 00-2-2H2z" clip-rule="evenodd"></path><path fill-rule="evenodd" d="M6 9a.5.5 0 01.5-.5h3a.5.5 0 010 1h-3A.5.5 0 016 9zM3.146 4.146a.5.5 0 01.708 0l2 2a.5.5 0 010 .708l-2 2a.5.5 0 11-.708-.708L4.793 6.5 3.146 4.854a.5.5 0 010-.708z" clip-rule="evenodd"></path></svg><span>DEX by volume 🏦</span></a>
</li>
<li class="menu-panel_categoryHeader__1zW3N" role="option" aria-selected="false">
<a tabindex="-1" href="/browse/users?q="><span>Users</span><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="arrow-right" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M10.146 4.646a.5.5 0 01.708 0l3 3a.5.5 0 010 .708l-3 3a.5.5 0 01-.708-.708L12.793 8l-2.647-2.646a.5.5 0 010-.708z" clip-rule="evenodd"></path><path fill-rule="evenodd" d="M2 8a.5.5 0 01.5-.5H13a.5.5 0 010 1H2.5A.5.5 0 012 8z" clip-rule="evenodd"></path></svg></a>
</li>
<li class="" role="option" aria-selected="false">
<a tabindex="-1" href="/hagaetc"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="person" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M13 14s1 0 1-1-1-4-6-4-6 3-6 4 1 1 1 1h10zm-9.995-.944v-.002.002zM3.022 13h9.956a.274.274 0 00.014-.002l.008-.002c-.001-.246-.154-.986-.832-1.664C11.516 10.68 10.289 10 8 10c-2.29 0-3.516.68-4.168 1.332-.678.678-.83 1.418-.832 1.664a1.05 1.05 0 00.022.004zm9.974.056v-.002.002zM8 7a2 2 0 100-4 2 2 0 000 4zm3-2a3 3 0 11-6 0 3 3 0 016 0z" clip-rule="evenodd"></path></svg><span>hagaetc</span></a>
</li>
<li class="" role="option" aria-selected="false">
<a tabindex="-1" href="/rchen8"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="person" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M13 14s1 0 1-1-1-4-6-4-6 3-6 4 1 1 1 1h10zm-9.995-.944v-.002.002zM3.022 13h9.956a.274.274 0 00.014-.002l.008-.002c-.001-.246-.154-.986-.832-1.664C11.516 10.68 10.289 10 8 10c-2.29 0-3.516.68-4.168 1.332-.678.678-.83 1.418-.832 1.664a1.05 1.05 0 00.022.004zm9.974.056v-.002.002zM8 7a2 2 0 100-4 2 2 0 000 4zm3-2a3 3 0 11-6 0 3 3 0 016 0z" clip-rule="evenodd"></path></svg><span>rchen8</span></a>
</li>
<li class="" role="option" aria-selected="false">
<a tabindex="-1" href="/eliasimos"><svg stroke="currentColor" fill="currentColor" stroke-width="0" viewBox="0 0 16 16" icon="person" aria-hidden="true" alt="" height="1em" width="1em" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M13 14s1 0 1-1-1-4-6-4-6 3-6 4 1 1 1 1h10zm-9.995-.944v-.002.002zM3.022 13h9.956a.274.274 0 00.014-.002l.008-.002c-.001-.246-.154-.986-.832-1.664C11.516 10.68 10.289 10 8 10c-2.29 0-3.516.68-4.168 1.332-.678.678-.83 1.418-.832 1.664a1.05 1.05 0 00.022.004zm9.974.056v-.002.002zM8 7a2 2 0 100-4 2 2 0 000 4zm3-2a3 3 0 11-6 0 3 3 0 016 0z" clip-rule="evenodd"></path></svg><span>eliasimos</span></a>
</li>
</ul>
</form>Text Content
Skip to content
DuneAnalytics
ctrl+p
* Dashboards
* DEX metrics 📊
* DeFi users over time
* OpenSea
* Queries
* Custom NFT Floor Tracker
* Monthly DEX Volume By Project
* DEX by volume 🏦
* Users
* hagaetc
* rchen8
* eliasimos
Menu
* Discover
* Favorites
* My Creations
*
Sign in
* We're hiring!
* Docs
* Discord
* Labels
* New Query
* Sign in
@RCHEN8 / OPENSEA MONTHLY ACTIVE TRADERS (ETHEREUM)
3
1
2
3
4
5
6
7
8
9
10
SELECT date, count(account) AS users
FROM
(SELECT date_trunc('month', evt_block_time) AS date,
maker AS account
FROM opensea."WyvernExchange_evt_OrdersMatched"
UNION SELECT date_trunc('month', evt_block_time) AS date,
taker AS account
FROM opensea."WyvernExchange_evt_OrdersMatched") a
GROUP BY 1
ORDER BY 1
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Last run 28 minutes agoLast run took 20 seconds
Table
Bar chart
OPENSEA MONTHLY ACTIVE TRADERS (ETHEREUM)
Registered users who have made at least one transaction
@rchen8
Column chart
* users
Jun 2018Sep 2018Dec 2018Mar 2019Jun 2019Sep 2019Dec 2019Mar 2020Jun 2020Sep
2020Dec 2020Mar 2021Jun 2021Sep 2021050k100k150k200k250k
New queryDiscoverFavoritesMy
CreationsProjectsLabelsDocsBlogDiscordPricingCareers
ProjectsBlogPricingCareers