Skip to content
Dune Analytics

@rchen8 / OpenSea monthly volume

OpenSea monthly volume

Loading
 

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('month', evt_block_time) AS MONTH,
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('month', p.minute) >= '2018-06-01'
16GROUP BY 1
17ORDER BY 1

SQL query results

Loading