adriaparcerisasThe Next Big Thing lite
Updated 2021-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
date_trunc('day',BLOCK_TIMESTAMP) as date,
to_address_name as pool,
count(to_address_name) as addresses
FROM ethereum.udm_events
WHERE DATEDIFF('day', TO_DATE(block_timestamp), CURRENT_DATE()) <= 30
AND (to_label ILIKE 'sushiswap' OR to_address ILIKE '0xd9e1cE17f2641f24aE83637ab66a2cca9C378B9F')
AND from_label IS NULL
AND origin_function_name IN
(
'addLiquidity'
)
and TO_ADDRESS_NAME <> 'router'
group by 1,2
order by 1 desc
Run a query to Download Data