0xHaM-dIn Total
Updated 2023-03-04
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
›
⌄
with priceTb as (
SELECT
RECORDED_HOUR::date as p_date,
symbol,
TOKEN_ADDRESS,
avg(CLOSE) as price
FROM solana.core.ez_token_prices_hourly
GROUP by 1,2,3
)
, lendingTb as (
SELECT
BLOCK_TIMESTAMP::DATE as date,
tx_id,
TX_FROM as signer,
amount,
amount * price as amount_usd
FROM solana.core.fact_transfers a JOIN priceTb c on a.mint = c.TOKEN_ADDRESS AND a.BLOCK_TIMESTAMP::DATE = c.p_date
WHERE TX_TO in ('DD3AeAssFvjqTvRTrRAtpfjkBF8FpVKnFuwnMLN9haXD', '3uxNepDbmkDNq6JhRja5Z8QwbTrfmkKP8AKZV5chYDGG',
'6YxGd65JbXzgFGWjE44jsyVeCnZp7Bb1wfL9jDia1n8w', '26kcZkdjJc94PdhqiLiEaGiLCYgAVVUfpDaZyK4cqih3')
AND date <= CURRENT_DATE - 1
)
, borrowingTb as (
SELECT
BLOCK_TIMESTAMP::DATE as date,
a.tx_id,
TX_TO as signer,
amount,
amount * price as amount_usd
FROM solana.core.fact_transfers a JOIN priceTb c on a.mint = c.TOKEN_ADDRESS AND a.BLOCK_TIMESTAMP::DATE = c.p_date
WHERE TX_FROM in ('DD3AeAssFvjqTvRTrRAtpfjkBF8FpVKnFuwnMLN9haXD', '3uxNepDbmkDNq6JhRja5Z8QwbTrfmkKP8AKZV5chYDGG',
'6YxGd65JbXzgFGWjE44jsyVeCnZp7Bb1wfL9jDia1n8w', '26kcZkdjJc94PdhqiLiEaGiLCYgAVVUfpDaZyK4cqih3')
AND date <= CURRENT_DATE - 1
)
SELECT
'Lend' as status,
COUNT(DISTINCT tx_id) as tx_cnt,
Run a query to Download Data