A Query for Bridgesplit and MonkeDAO's DAOJONES bounty

amirkhannoriiA Query for Bridgesplit and MonkeDAO's DAOJONES bounty

Updated 2022-03-02

select date_trunc('day',block_timestamp) as date,

count(tx_id) as "Number of transactions",

count(distinct tx_from_address) as "Number of wallets"

from solana.transactions

where (pre_mint = 'r8nuuzXCchjtqsmQZVZDPXXq928tuk7KVH479GsKVpy' or post_mint = 'r8nuuzXCchjtqsmQZVZDPXXq928tuk7KVH479GsKVpy')

and Succeeded = 'True'

and block_timestamp >= '2021-12-06'

group by 1

Run a query to Download Data

flipside