pine_samiTRIAS transaction volume on BSC
    Updated 2022-11-25
    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