zakkisyedStep 2: Which protocol have you sent the most money to?
Updated 2021-11-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- Use our labels to see who a user address is interacting with.
-- A label is a tag on an address that provides human-readable context to events and balances.
-- You can find more about labels in our docs here: https://docs.flipsidecrypto.com/our-data/data-models/labels
-- First you can see if this user address is mostly interacting with centralized exchanges, or decentralized exchanges or NFTs, or any other category sorted by main function or ownership.
-- To do so, comment out line 12 and uncomment out line 13
-- Or you can look at which particular centralized exchange, or DEX etc. this address is interacting with.
-- To do so, uncomment out line 17 and see a breakdown of all centralized exchanges or cex that this particular address has sent to in the last 30 days.
SELECT
to_label,
-- to_label_type,
sum(amount_usd) as amount_usd
FROM ethereum.udm_events
WHERE from_address = lower('0x76106b2F5369f95d881D38aA9442E8A7148BcFd6')
-- AND to_label_type = 'cex'
AND block_timestamp >= current_date - 30
GROUP BY 1
Run a query to Download Data