phu[Sushiswap] correlation between profitability and type of Farm
Updated 2022-08-24
999
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
slp_deposit_cte as (
select
origin_from_address,
contract_address farm,
tx_hash,
block_timestamp,
amount
from ethereum.core.ez_token_transfers
where 1=1
and (
(
origin_to_address = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd' -- masterchef v1
and origin_function_signature = '0xe2bbb158' -- deposit
)
or (
origin_to_address = '0xef0881ec094552b2e128cf945ef17a6752b4ec5d' -- masterchef v2
and origin_function_signature = '0x8dbdbe6d' -- deposit
)
)
and symbol = 'SLP'
and amount > 0
)
,slp_withdraw_cte as (
select
origin_from_address,
contract_address farm,
tx_hash,
block_timestamp,
amount
from ethereum.core.ez_token_transfers
where 1=1
and (
(
origin_to_address = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd' -- masterchef v1
and origin_function_signature = '0x441a3e70' -- withdraw
Run a query to Download Data