HosseinUntitled Query
Updated 2022-09-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select day, tx_receiver as receiver, total_received_amount, txns_count from (
select block_timestamp::date as day, tx_receiver,
sum(deposit) / pow(10, 24) as total_received_amount,
count(distinct (tx_hash)) as txns_count,
row_number() over (partition by day order by total_received_amount desc) as n
from near.core.fact_transfers
where status = 1
and tx_signer = 'sweat_welcome.near'
group by day, tx_receiver
qualify n = 1
order by day, total_received_amount desc
)
Run a query to Download Data