Query editor
WITH filtered_trades AS (SELECTtx_id,DATE_TRUNC('month', block_time) AS trade_month,block_timeFROM solana.instruction_callsWHERE executing_account = '85iDfUvr3HJyLM2zcq5BXSiDvUWfw6cSE1FfNBo8Ap29'AND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) IN (2, 6, 9, 12)AND block_time >= DATE_TRUNC('month', DATE_ADD('month', -1, CURRENT_DATE))AND block_time < DATE_TRUNC('month', DATE_ADD('month', 1, CURRENT_DATE)))SELECTft.tx_id,ft.trade_month,ft.block_time,t.account_keys[1] AS trader_accountFROM filtered_trades ftINNER JOIN solana.transactions tON ft.tx_id = t.idAND t.success = TRUEAND t.block_time >= DATE_TRUNC('month', DATE_ADD('month', -1, CURRENT_DATE))AND t.block_time < DATE_TRUNC('month', DATE_ADD('month', 1, CURRENT_DATE))ORDER BY ft.trade_month, ft.tx_id