bachidaily Sushi farm TVL - harmony
Updated 2022-04-10
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 * from crosschain.address_labels where project_name = 'sushiswap' and blockchain like '%mony'
--select distinct blockchain from crosschain.address_labels where project_name = 'sushiswap'
--select * from mdao_harmony.liquidity_pools where pool_address like '0x00588572cc%'
with pools as (
select pool_name, pool_address from mdao_harmony.liquidity_pools
),
tvl as (
select date(block_timestamp) as date, contract_address, sum(raw_amount/pow(10,9)) as tvl, avg(raw_amount/pow(10,9)) as avg from mdao_harmony.transfers where contract_address in (
'0x643f94fc0a804ea13adb88b9e17244bf94022a25',
'0x468dc50884962d6f81733ac0c23c04611ac219f9',
'0x4f658217f163509115b6e1fbba37cd9aefbdba12',
'0x171ff11b53674958c273bcfccbc731aa6cae96f8',
'0x0c51171b913db10ade3fd625548e69c9c63afb96',
'0x2c7862b408bb3dbff277110ffde1b4eaa45c692a',
'0x194f4a320cbda15a0910d1ae20e0049cdc50916e',
'0x3046ed650e06778c0b7eca7d066fe33b073f1877',
'0x4f3d9ac088cdf31b1831db3aaf5803ab35c200c4',
'0x281ced1a3ee6d454dda3d212235a6fe5c834e28f',
'0x30ce16f3cf4eb15b11b743d1a302dadef8ba95d2',
'0x4dabf6c57a8bea012f1eaa1259ceed2a62ac7df2',
'0x39be7c95276954a6f7070f9baa38db2123691ed0',
'0x34f21378a6fc29acc1eacb82bc5f7dec794ce537',
'0x008cebc4bbf13145dbb34b542d6f3b7b01e1e040',
'0x27f3b2df4a81382202e87ee40429e0212ecc7d3f',
'0x12f5fe3ab36ced7fb1065b260a0d244eaa6e5584',
'0x46f11f1ca47e7136f3da54358fe5ceb50f3258f8',
'0x02f4d0021e3cb8736108e11c8df02fbbd6eeedbf',
'0x58810ff10eccd69ff3045530e8ab8fa8590581bb',
'0x1c3761414888254b09c7ce3e750b3f771e611727',
'0x40112850efd90e9e17b56de35d86bdff9f4d07fd',
'0x2c4b7b6eb98b278bdd51303f12f68aa46f6c633f',
'0x1970f700091772ee229aa9640e580956383ebecd',
'0x59b1455a5f4e841225c88197b94eee92eda883a8',
'0x435df9bdaa094d8090206b92cf86ffd5fc157f93',
Run a query to Download Data