select
    stat_date
    ,pay_account
    ,count(*) as Buy_NFT_Count
from 
(
    select
       account_keys[0] as pay_account
       ,post_token_balances[0]['mint'] as NFT_Token_Address
       ,pre_balances[0] /1000000000 as pre_SOL_balances
       ,post_balances[0] /1000000000 as post_SOL_balances
       ,(pre_balances[0] /1000000000)  - (post_balances[0] /1000000000) as sale_Price
       ,cast(substr(cast(log_messages[8] as string),23,11) as double)  / 1000000000 as listing_price
       ,block_time as buy_time
       ,id as sale_id
       ,block_date
       ,substr(block_time,1,10) as stat_date
    from `solana`.`transactions`
    where success is true
    and block_date >='{{start_date}}'
    and ARRAY_CONTAINS(account_keys, 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    AND ARRAY_CONTAINS(log_messages, 'Program log: Instruction: ExecuteSale')
    and  account_keys[0] = '{{wallet_address}}'
) a 
group by 
    stat_date
    ,pay_account
order by 
   stat_date