1e9y · March 10, 2025 00:26
diff --git a/query.sql b/query.sql
 SELECT 
    toStartOfHour(block_timestamp) as hour,
    SUM(arraySum(
        arrayMap(
            x -> max2(toDecimal128(x.after, 9) - toDecimal128(x.before, 9), 0), 
            arrayFilter(x -> x.account IN [
                '96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5',
                'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe',
                'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY',
                'ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49',
                'DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh',
                'ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt',
                'DttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL',
                '3AVi9Tg9Uo68tJfuvoKvqKNWKkC5wPdSSdeBnizKZ6jT'
            ], balance_changes)
        )
    ))/1e9 as jito_tips,
    SUM(fee)/1e9 as total_fees
 FROM solana.transactions_non_voting
 WHERE DATE(block_timestamp) = DATE(NOW()) - INTERVAL 1 DAY
 GROUP BY hour
 ORDER BY hour ASC;
diff --git a/result.csv b/result.csv
	SELECT
	toStartOfHour(block_timestamp) as hour,
	SUM(arraySum(
	arrayMap(
	x -> max2(toDecimal128(x.after, 9) - toDecimal128(x.before, 9), 0),
	arrayFilter(x -> x.account IN [
	'96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5',
	'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe',
	'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY',
	'ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49',
	'DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh',
	'ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt',
	'DttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL',
	'3AVi9Tg9Uo68tJfuvoKvqKNWKkC5wPdSSdeBnizKZ6jT'
	], balance_changes)
	)
	))/1e9 as jito_tips,
	SUM(fee)/1e9 as total_fees
	FROM solana.transactions_non_voting
	WHERE DATE(block_timestamp) = DATE(NOW()) - INTERVAL 1 DAY
	GROUP BY hour
	ORDER BY hour ASC;