Pmisha-bmlMdxTotal
Updated 2022-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with t1 as (select
tx_id
from solana.fact_nft_mints
where PROGRAM_ID in ('cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ','cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ')
and block_timestamp>='2022-04-29'
)
select
count(distinct signers[0]) as bot,
count(tx_id) as bot_transaction,
sum(fee)/1e6 as fee_captured
from solana.fact_transactions
where tx_id in (select tx_id from t1)
and CAST(log_messages as string) ILIKE '%Candy Machine Botting is taxed at%'
and block_timestamp>='2022-04-29'
Run a query to Download Data