kaibladeTransfers to and from cex
Updated 2022-12-22
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 defi_labels AS
(
SELECT *
FROM optimism.core.dim_labels
WHERE (address_name ILIKE '%pool%'
OR label_subtype = 'pool')
AND label_type != 'dapp'
),
op_transfers AS
(SELECT *
FROM optimism.core.fact_token_transfers
WHERE contract_address = '0x4200000000000000000000000000000000000042'
-- AND origin_to_address IN (SELECT DISTINCT(address) FROM defi_labels)
-- OR event_inputs:tokenOut = '0x4200000000000000000000000000000000000042')
AND block_timestamp::date >= CURRENT_DATE() -INTERVAL '2 months'
),
defi_stakes AS
(SELECT *
FROM optimism.core.fact_event_logs
WHERE event_name = 'Staked'
AND tx_hash IN (SELECT tx_hash FROM op_transfers)),
defi_mints AS
(SELECT *
FROM optimism.core.fact_event_logs
WHERE event_name = 'Mint'
AND tx_hash IN (SELECT tx_hash FROM op_transfers)),
-- refined_swaps AS
-- (SELECT tx_hash, block_timestamp,
-- (CASE
-- WHEN event_inputs:tokenIn = '0x4200000000000000000000000000000000000042' THEN 'Token In'
-- WHEN event_inputs:tokenOut = '0x4200000000000000000000000000000000000042' THEN 'Token Out'
-- END
-- ) AS "Swap Direction",
Run a query to Download Data