rackhaelNEAR CORE QUERIES
Updated 2023-05-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
›
⌄
⌄
SELECT *
FROM near.core.fact_receipts fr
JOIN near.core.dim_address_labels dl ON fr.receiver_id = dl.address
limit 10;
SELECT distinct platform
from near.core.ez_dex_swaps
-- where platform ilike '%orderly%'
_______________________________________________
DEFI ON near
-----------------------------------------------
RefFinance (Dex)
MetaPool (Liquidity Staking)
LiNEAR Protocol (Liquidity Staking)
Burrow (Lending)
Orderly Network (Dex)
Stader (Liquidity Staking)
PhoenixBonds (Yield Aggregator)
Pembrock Finance (Yield)
-----------------------------------------------
Run a query to Download Data