pine_samiTRIAS transaction volume on BSC
Updated 2022-11-25
9
1
2
3
4
5
6
7
8
9
›
⌄
select count(distinct TX_HASH) as All_transactions,
COUNT(distinct ORIGIN_FROM_ADDRESS) as users,
sum(RAW_AMOUNT/1e18) as Total_volume,
Total_volume/All_transactions as AVG_volume_per_transactions,
Total_volume/users as AVG_volume_per_users
from bsc.core.fact_token_transfers
where CONTRACT_ADDRESS='0xa4838122c683f732289805fc3c207febd55babdd'
and TX_HASH!='0xf732a4209de88a9322c075740f17dced683ff35eb7720749a4f3ceb7663281b1'
and TX_HASH!='0x253c00318e374d5c8dc83bca892d59f216700e0c7774c9d73b81ff04c8de515a'
Run a query to Download Data