Flipside Docs
Search…
MakerDAO Tutorials
This guide provides an introduction to exploring Dai related events by using theethereum.udm_events table over a series of simple queries that explore the data.
Note: this tutorial uses deprecated Ethereum tables. See the new Maker DAO curated tables.
Let's familiarize ourselves with the table by first looking at the types of events that can be queried for Dai
SELECT
event_type,
event_name,
count(1) as event_count
FROM ethereum.udm_events
WHERE
symbol = 'DAI' AND
block_timestamp >= GETDATE() - interval'8 months'
GROUP BY event_type, event_name
ORDER BY event_count DESC
event_type
event_name
event_count
erc20_transfer
transfer
3929409
event
Approval
630353
event
TransferEnabled
1
event
OperatorAdded
1
event
MinterAdded
1
event
OwnershipTransferred
1
From the results of this query we see the majority of events are dominated by transfer activity, with the second-highest being, calls to Approval on the Dai contract.
Note that in the above query, the event names have been decoded into English legible names.
In our next query let's take a look at the trend of DAI transfers over the prior 30 days:
SELECT
date_trunc('day', block_timestamp) as metric_date,
sum(amount) as total_amount
FROM ethereum.udm_events
WHERE
event_name = 'transfer' AND
symbol = 'DAI' AND
amount > 0 AND
block_timestamp >= GETDATE() - interval'30 days'
GROUP BY metric_date
ORDER BY metric_date ASC
We can break this query down even further by leveraging Flipside's labels. Let's calculate the amount of DAI that is flowing to centralized exchanges using the distributor_cex label sub-type.
SELECT
date_trunc('day', block_timestamp) as metric_date,
sum(amount) as total_amount
FROM ethereum.udm_events
WHERE
event_name = 'transfer' AND
symbol = 'DAI' AND
to_label_subtype = 'distributor_cex' AND
amount > 0 AND
block_timestamp >= GETDATE() - interval'30 days'
GROUP BY metric_date
ORDER BY metric_date ASC
From here, I encourage you to explore our labels even further by breaking down specifically which exchanges DAI is flowing to.
In our next tutorial, we'll explore the amount of activity of DAI that can be attributed to DeFi related activity vs. non DeFi activity and build Flipside's DeFi Activity Ratio metric.
Copy link