Discover

cu

nft

trus wallet

trump1

defi

run

WITH allFeePayments AS ( SELECT tx_id, 'SOL' AS feeTokenType, balance_change / 1e9 AS fee_token_amount, 'So11111111111111111111111111111111111111112' AS fee_token_mint_address FROM solana.account_activity WHERE tx_success AND address = 'BB5dnY55FXS1e1NXqZDwCzgdYJdMCj3B92PU6Q5Fb6DT' AND balance_change > 0 ), botTrades AS ( SELECT block_time, amount_usd, fee_token_amount * price AS fee_usd FROM dex_solana.trades AS trades JOIN allFeePayments AS feePayments ON trades.tx_id = feePayments.tx_id LEFT JOIN prices.usd AS feeTokenPrices ON ( feeTokenPrices.blockchain = 'solana' AND fee_token_mint_address = toBase58(feeTokenPrices.contract_address) AND date_trunc('minute', block_time) = minute ) WHERE trades.trader_id != 'BB5dnY55FXS1e1NXqZDwCzgdYJdMCj3B92PU6Q5Fb6DT' ), daily_volume_and_fees AS ( SELECT DATE_TRUNC('day', block_time) AS day, SUM(amount_usd) AS total_volume_usd, SUM(fee_usd) AS total_fees_usd FROM botTrades GROUP BY DATE_TRUNC('day', block_time) ), lifetime_volume_and_fees AS ( SELECT SUM(amount_usd) AS lifetime_volume_usd, SUM(fee_usd) AS lifetime_fees_usd FROM botTrades ), seven_day_volume_and_fees AS ( SELECT SUM(amount_usd) AS seven_day_volume_usd, SUM(fee_usd) AS seven_day_fees_usd FROM botTrades WHERE block_time >= NOW() - INTERVAL '7' DAY ) SELECT day, total_volume_usd, total_fees_usd, (SELECT lifetime_volume_usd FROM lifetime_volume_and_fees) AS lifetime_volume_usd, (SELECT lifetime_fees_usd FROM lifetime_volume_and_fees) AS lifetime_fees_usd, (SELECT seven_day_volume_usd FROM seven_day_volume_and_fees) AS seven_day_volume_usd, (SELECT seven_day_fees_usd FROM seven_day_volume_and_fees) AS seven_day_fees_usd FROM daily_volume_and_fees ORDER BY day DESC;

df

nft

12

cu

fruk

blix

query results