@Bung / Total USD stored in Monolith contracts, accumulated weekly over time
@BungAbout 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 results
SQL query
1WITH wallets AS (
2 SELECT
3 block_time as creation_time,
4 block_number as creation_block_number,
5 address
6 from ethereum.traces
7 where "from" in ('\x95BEBe7bfc6aCc186C13D055D0Aacc2DE5f81502','\xb24d47364163f909e64cf2cf7788d22c51cea851', '\x85bb8a852c29d8f100cb97ecdf4589086d1be2dd', '\xE0731c1a30E6eD0c6E9162EB87Fc85e831caF382') -- Monolith deployers
8 and type = 'create'
9),
10
11transfersERC20 AS (
12 SELECT
13 evt_block_time AS block_time,
14 tr."from" AS address,
15 -tr.value / 10^decimals AS amount,
16 erc.symbol AS symbol
17 FROM erc20."ERC20_evt_Transfer" tr
18 join erc20.tokens erc
19 on tr.contract_address = erc.contract_address
20 where "from" in (select address from wallets)
21 UNION ALL
22 SELECT
23 evt_block_time AS block_time,
24 tr."to" AS address,
25 tr.value / 10^decimals AS amount ,...