jackguyUnigrants - 2 - 2
Updated 2023-06-23
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
›
⌄
SELECT
* --
-- sum(net_deposit_usd) over (ORDER by day) as cume_deposit_usd
FROM (
SELECT
date_trunc('day', block_timestamp) as day,
--sum(
--CASE when action LIKE 'INCREASE_LIQUIDITY' then amount0_usd + amount1_usd else -1 * (amount0_usd + amount1_usd) end
--) as net_deposit_usd
count(
case when action LIKE 'INCREASE_LIQUIDITY' then 1 end
) as LP_Providers,
count(
case when action NOT LIKE 'INCREASE_LIQUIDITY' then 1 end
) as LP_Withdrawlers
FROM ethereum.uniswapv3.ez_lp_actions
WHERE TOKEN0_ADDRESS in (
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',
'0xdac17f958d2ee523a2206206994597c13d831ec7',
'0x1f9840a85d5af5bf1d1762f925bdaddc4201f984',
'0x6b175474e89094c44da98b954eedeac495271d0f',
'0x045e507925d2e05d114534d0810a1ab56839f984',
'0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9',
'0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2',
lower('0x514910771AF9Ca656af840dff83E8264EcF986CA'),
lower('0x5A98FcBEA516Cf06857215779Fd812CA3beF1B32'),
lower('0xc944E90C64B2c07662A292be6244BDf05Cda44a7'),
lower('0xD533a949740bb3306d119CC777fa900bA034cd52')
) OR TOKEN1_ADDRESS in (
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',
'0xdac17f958d2ee523a2206206994597c13d831ec7',
Run a query to Download Data