HosseinUntitled Query
    Updated 2022-09-17
    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