SniperTotal amount of users are swapping via MetaMask vs Sushi swap and Uniswap
Updated 2022-06-25Copy Reference Fork
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
-- wITH logs AS(
-- SELECT logs.BLOCK_TIMESTAMP,
-- logs.TX_HASH,
-- logs.CONTRACT_ADDRESS,
-- logs.ORIGIN_FROM_ADDRESS,
-- logs.ORIGIN_TO_ADDRESS,
-- logs.EVENT_INPUTS:from::string as from_address,
-- logs.EVENT_INPUTS:to::string as to_address,
-- logs.EVENT_INPUTS:value::string as value,
-- lb.LABEL AS platform,
-- CASE WHEN lb.ADDRESS = lower('0x881d40237659c251811cec9c364ef91dc08d300c') THEN 1 ELSE 2 END AS type
-- FROM ethereum.core.fact_event_logs logs
-- JOIN ethereum.core.dim_labels lb on lb.ADDRESS = ORIGIN_TO_ADDRESS AND lb.LABEL_TYPE = 'dex' AND lb.LABEL_SUBTYPE = 'swap_contract'
-- WHERE TX_STATUS = 'SUCCESS'
-- AND EVENT_REMOVED = 'false'
-- -- AND ORIGIN_TO_ADDRESS = lower('0x881d40237659c251811cec9c364ef91dc08d300c')
-- )
-- SELECT platform, COUNT(DISTINCT from_address) swaps_count
-- FROM logs
-- WHERE from_address = ORIGIN_FROM_ADDRESS
-- GROUP BY type, platform
-- ORDER BY type ASC, 2 DESC
-- LIMIT 20
-- WITH logs AS(
-- SELECT logs.BLOCK_TIMESTAMP,
-- logs.TX_HASH,
-- logs.CONTRACT_ADDRESS,
-- logs.ORIGIN_FROM_ADDRESS,
-- logs.ORIGIN_TO_ADDRESS,
-- logs.EVENT_INPUTS:from::string as from_address,
-- logs.EVENT_INPUTS:to::string as to_address,
-- (logs.EVENT_INPUTS:value) / pow(10, 18) as value,
-- lb.LABEL AS platform,
Run a query to Download Data