rajsBinance Listing BSC
Updated 2024-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
-- *
contract_address,
count(*) as n_txs
-- sum(raw_amount / 1e18) as amount
from bsc.core.fact_token_transfers
-- where contract_address = '0xdef1ca1fb7fbcdc777520aa7f396b4e015f497ab'
where to_address = '0xf977814e90da44bfa03b6295a0616a897441acec'
and block_timestamp::date = '2024-09-16'
-- and contract_address = '0xec53bf9167f50cdeb3ae105f56099aaab9061f83'
group by 1
order by 2 desc
-- limit 3
QueryRunArchived: QueryRun has been archived