connorhUntitled Query
Updated 2021-11-03
9
1
2
3
4
5
6
7
8
›
⌄
SELECT tx_to_address,
tx_to_address_name,
COUNT(1) AS N
FROM ethereum.events_emitted
WHERE tx_from_address IN ('0x1676055fe954ee6fc388f9096210e5ebe0a9070c') OR tx_to_address IN ('0x1676055fe954ee6fc388f9096210e5ebe0a9070c')
--AND tx_to_address IN ('0xbb241fd9a2a3742ef9e10ccfd8a6c4e0ebeb03f2','0x5796698a29f3626c9fe13c4d3d3dee987c84ebb3')
AND block_timestamp >= CURRENT_DATE - 60
GROUP BY 1,2
Run a query to Download Data