NavidCopy of Copy of Untitled Query
Updated 2022-11-15Copy Reference Fork
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
›
⌄
with trades as (
select
'Near' as type,
sum(deposit/1e24) as amt,
count(distinct tx_hash) as trades_cnt,
count(distinct tx_signer) as sellers_cnt,
count(distinct tx_receiver) as buyers_cnt
from
near.core.fact_transfers
where date(block_timestamp) = (select date(max(block_timestamp)) from near.core.fact_transfers)
union all
select
'Solana' as type,
sum(AMOUNT/1e24) as amt,
count(distinct tx_id) as trades_cnt,
count(distinct tx_from) as sellers_cnt,
count(distinct tx_to) as buyers_cnt
from
solana.core.fact_transfers
where date(block_timestamp) = (select date(max(block_timestamp)) from solana.core.fact_transfers)
)
select
type,
buyers_cnt/sellers_cnt as ratio
from
trades
Run a query to Download Data