clayop2023-11-23 08:05 PM
Updated 2023-12-05
99
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 MAIN AS (
SELECT BLOCK_TIMESTAMP, TX_HASH, FROM_ADDRESS, TO_ADDRESS, SYMBOL, AMOUNT, AMOUNT_USD
FROM ethereum.core.ez_token_transfers
WHERE BLOCK_TIMESTAMP BETWEEN '2023-11-20 06:24' AND '2023-11-20 06:48'
AND AMOUNT_USD BETWEEN 9500 AND 10500
AND SYMBOL = 'WETH'
ORDER BY TO_ADDRESS, BLOCK_TIMESTAMP
),
COUNTING AS (
SELECT TO_ADDRESS, COUNT(*) AS CNT
FROM MAIN
GROUP BY 1
HAVING CNT = 7
)
SELECT m.BLOCK_TIMESTAMP, m.TO_ADDRESS, m.AMOUNT_USD, m.SYMBOL, m.AMOUNT, m.TX_HASH
FROM COUNTING AS c LEFT JOIN MAIN AS m ON m.TO_ADDRESS = c.TO_ADDRESS
ORDER BY 2, 1
/*
WITH MAIN AS (
SELECT BLOCK_TIMESTAMP, PUBKEY_SCRIPT_ADDRESS, VALUE
FROM bitcoin.core.fact_outputs
WHERE BLOCK_TIMESTAMP BETWEEN '2023-11-20 3:46' AND '2023-11-20 9:00'
AND VALUE BETWEEN 0.13 AND 0.4
),
COUNTING AS (
SELECT PUBKEY_SCRIPT_ADDRESS, COUNT(*) AS CNT
FROM MAIN
GROUP BY 1
HAVING CNT = 7
)
SELECT m.BLOCK_TIMESTAMP, m.PUBKEY_SCRIPT_ADDRESS, m.VALUE
FROM COUNTING AS c LEFT JOIN MAIN AS m ON m.PUBKEY_SCRIPT_ADDRESS = c.PUBKEY_SCRIPT_ADDRESS
Run a query to Download Data