zakkisyedSushiswap: User LP inflows
Updated 2021-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT DATE(block_timestamp) as date, COUNT(DISTINCT from_address) as ethereum_unique_wallets, p.unique_wallets as polygon_unique_wallets
FROM ethereum.dex_swaps
FULL JOIN (
SELECT DATE(block_timestamp) as date, COUNT(DISTINCT from_address) as unique_wallets
FROM polygon.udm_events
WHERE DATEDIFF('day', TO_DATE(block_timestamp), CURRENT_DATE()) <= 90
AND (to_label ILIKE 'sushiswap'
OR to_address ILIKE '0x1b02da8cb0d097eb8d57a175b88c7d8b47997506')
AND from_label IS NULL
AND origin_function_name IN ('swapExactETHForTokens', 'swapExactTokensForTokens', 'swapExactTokensForETH', 'swapTokensForExactTokens', 'swapETHForExactTokens',
'swapExactTokensForETHSupportingFeeOnTransferTokens', 'swapExactTokensForTokensSupportingFeeOnTransferTokens')
GROUP BY 1
) p
ON DATE(block_timestamp) = p.date
WHERE DATEDIFF('day', TO_DATE(block_timestamp), CURRENT_DATE()) <= 90
AND platform ILIKE 'sushiswap'
GROUP BY 1, p.unique_wallets
order by date desc
Run a query to Download Data