Skip to content
Dune Analytics

@rchen8 / OpenSea daily volume

OpenSea daily volume


About queries and results

Dune Analytics lets you explore, create, and share Ethereum analytics. You can find an endless amount of great queries and dashboards on Dune.

We have decoded Ethereum smart contract data so you can do powerful analysis with simple SQL queries and visualise the query results into beautiful graphs.

Dune Analytics is free for everyone forever. If you want extra features like private queries, export your results and more check out our Pro plan.

SQL query

1WITH token AS
2  (SELECT call_tx_hash AS tx_hash,
3          CASE
4              WHEN addrs[7] = '\x0000000000000000000000000000000000000000' THEN '\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
5              ELSE addrs[7]
6          END AS token_address
7   FROM wyvern."WyvernExchange_call_atomicMatch_" a)
8SELECT date_trunc('day', evt_block_time) AS DAY,
9       SUM((om.price/10^erc.decimals)*p.price) AS usd_volume
10FROM wyvern."WyvernExchange_evt_OrdersMatched" om
11INNER JOIN token ON token.tx_hash = om.evt_tx_hash
12INNER JOIN erc20.tokens erc ON token.token_address = erc.contract_address
13INNER JOIN prices.usd p ON p.minute = date_trunc('minute', evt_block_time)
14AND token.token_address = p.contract_address
15AND date_trunc('day', p.minute) > date_trunc('day', now()) - interval '90 days'
16WHERE date_trunc('day', evt_block_time) > date_trunc('day', now()) - interval '90 days'

SQL query results