Simplify Analytics
← Data Explorer

Multi-leg option trades

core.multileg_trades

Class E accrual with a 24-hour vendor cap - the shortest window in the project.

367,592 rowsCSV — whole table, not this view

Sources in this table

executed_at (ET days)to
column equals (exact text)
sort
chart against executed_at
reset
active:code = cbmo×direction = long×
idtexttickertextexecuted_at ↓timestamp with time zonestrategytextleg_countintegertxnsintegersizebiginttotal_premiumnumericdirectiontextnet_sidetextunderlying_pricenumericbid_ask_spreadnumericstrikesjsonbivsjsonbbreakevensjsonbuniq_exchangesjsonbmin_strikenumericmax_strikenumericmin_dteintegermax_dteintegerall_opening_legsbooleanall_otmbooleandiff_expirationsbooleandiff_strikesbooleandiff_typesbooleancodetextkept_bytextsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
01a0c59b-74d6-7df3-b618-ea1a0e19bfd8SPX2026-09-21 16:14call_ratio_spread21100954600.00longask7764.70005.3000["7700","7775"]["0.1075","0.1003"]["7701","7849.00"]["XCBO"]7700.00007775.000099falsefalsefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c598-63af-77c3-9912-9e39634abdc2SPX2026-09-21 16:11synthetic2125827820.00longask7764.70002.2000["7830"]["0.1351"]["7913.53"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:11:56Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c597-429f-7650-87f1-1363fa988364SPX2026-09-21 16:10put_frontspread2155277413.00longask7764.70000.4000["7650","7750"]["0.1246","0.1116"]["7525.74","7739.31"]["XCBO"]7650.00007750.00001111falsetruefalsetruefalsecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:11:56Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c596-67df-74d3-b111-48dfcd153834SPX2026-09-21 16:09synthetic221083358800.00longask7764.70002.0000["7830"]["0.1350"]["7935.00"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:09:30Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c593-897e-7e12-b9a4-271a1696a3f4SPX2026-09-21 16:06synthetic22321323520.00longask7764.70001.7000["7830"]["0.1361"]["7832.00"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:07:21Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c592-f8f7-7242-9ac7-e4c8b0c03dfbSPX2026-09-21 16:05synthetic2110413600.00longask7764.70002.1000["7830"]["0.1361"]["7832.00"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:07:21Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c592-703f-7d20-81ab-fffaa753c845SPX2026-09-21 16:05synthetic2220826800.00longbid7764.71002.0000["7830"]["0.1360"]["7830"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:05:25Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c592-1e36-7351-8441-fce5e471cafbSPX2026-09-21 16:04synthetic211513969400.00longbid7764.70002.0000["7840"]["0.1341"]["7984.13"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:05:25Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c591-f727-73f3-9fa0-49052ca8b113SPX2026-09-21 16:04synthetic2210412000.00longbid7764.71002.0000["7840"]["0.1355"]["7832"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:05:25Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c58f-4b8f-7771-8373-bbc1674681beSPX2026-09-21 16:01ratio_risk_reversal211001280800.00longbid7764.80001.8000["7835","8250"]["0.1380","0.1191"]["7760.05"]["XCBO"]7835.00008250.00008888falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:01:45Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c58c-26df-7363-98fe-4da25c5f3b1eSPX2026-09-21 15:58straddle2210412000.00longask7767.87002.1000["7840"]["0.1354"]["7428","8252.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:58:18Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c589-504e-7e82-b9c8-a591e8f4bf04SPX2026-09-21 15:54synthetic2225210483200.00longask7766.73002.8000["7840"]["0.1368"]["7841.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:54:50Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c589-310e-7521-b2e3-a078841c182eSPX2026-09-21 15:54synthetic21502073000.00longask7767.96002.1000["7840"]["0.1363"]["7842.44"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:54:27Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c588-2f3e-7a70-8fb4-a609e969947fSPX2026-09-21 15:53synthetic2118555300.00longbid7768.33002.1000["7845"]["0.1351"]["7944.50"]["XCBO"]7845.00007845.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:54:04Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c586-9516-7f73-b61c-e67f6a2edddeSPX2026-09-21 15:52synthetic2113538980.00longask7769.98002.0000["7840"]["0.1363"]["7842.44"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:52:06Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c586-5a7e-70a0-8d27-281cf8a443a3SPX2026-09-21 15:51synthetic21441826000.00longask7768.39002.1000["7840"]["0.1364"]["7843.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:52:06Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c585-4cf7-7d72-aa4d-3de75b959035SPX2026-09-21 15:50synthetic21382800.00longbid7767.60002.0000["7840"]["0.1352"]["7978.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmotrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:50:59Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c585-125e-71d3-b3a6-1183627d6135SPX2026-09-21 15:50synthetic221654111800.00longbid7767.36002.0000["7845"]["0.1366"]["7678.20"]["XCBO"]7845.00007845.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:50:40Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c573-f776-7802-ba70-fde9f07d4bdcSPX2026-09-21 15:31straddle218332000.00longask7771.86001.6000["7840"]["0.1364"]["7425","8255.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:32:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c570-4627-7c30-b888-1bf9042112e6SPX2026-09-21 15:27synthetic2121871920.00longask7771.85001.7000["7840"]["0.1365"]["7841.00"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:27:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c56d-fc37-7b20-99eb-4f1bd585d901SPX2026-09-21 15:25risk_reversal2150031925000.00longask7771.46003.4000["7000","8000"]["0.2081","0.1546"]["8281.50"]["XCBO"]7000.00008000.0000298298falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:25:31Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c567-706e-7392-a202-2ee9999b490eSPX2026-09-21 15:18straddle2123957950.00longask7774.24001.7000["7840"]["0.1368"]["7423.50","8256.50"]["XCBO"]7840.00007840.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:18:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c554-a7d7-7bd3-9d88-dd75989f1090SPX2026-09-21 14:57strangle21500169850500.00longask7774.1900585.2000["7000","8000"]["0.1903","0.2195"]["4602.99","10397.01"]["XCBO"]7000.00008000.000019151915falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:57:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c554-a7d7-7bd3-9d88-dd65b9d7137aSPX2026-09-21 14:57strangle21500169850500.00longask7774.1900585.2000["7000","8000"]["0.1903","0.2195"]["4602.99","10397.01"]["XCBO"]7000.00008000.000019151915falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:57:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c554-a7d7-7bd3-9d88-dd59f3e2c8c4SPX2026-09-21 14:57strangle2130001019103000.00longask7774.1900585.2000["7000","8000"]["0.1903","0.2195"]["4602.99","10397.01"]["XCBO"]7000.00008000.000019151915falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:57:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51f-99ce-7cb2-bd74-f62902a25dd0SPX2026-09-21 13:59synthetic2211331480.00longbid7759.93001.7000["7830"]["0.1373"]["7715.75"]["XCBO"]7830.00007830.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:00:09Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51e-1aff-7ef2-97f2-4bc9ed5073b9SPX2026-09-21 13:57put_frontspread214489054.00longask7758.96001.1000["5000","7825"]["0.4160","0.1398"]["4801.79","7708.85"]["XCBO"]5000.00007825.00008888falsefalsefalsetruefalsecbmotrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:58:06Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51c-f607-7fc1-8808-cc3131e1d976SPX2026-09-21 13:56strangle21100155000.00longask7759.19000.4000["7735","7785"]["0.1143","0.1014"]["7719.50","7800.50"]["XCBO"]7735.00007785.000011falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:56:48Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51c-f606-7001-8e46-1927dffb4b48SPX2026-09-21 13:56strangle249001395000.00longask7759.19000.4000["7735","7785"]["0.1143","0.1014"]["7719.50","7800.50"]["XCBO"]7735.00007785.000011falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:56:48Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c51b-b99f-73d2-9077-5636eb743ec9SPX2026-09-21 13:55risk_reversal21100031383000.00longask7758.94001.9000["7000","8000"]["0.2025","0.1351"]["8131.47"]["XCBO"]7000.00008000.0000151151falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:55:42Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c50c-c57f-7b41-aba3-8dfc16cb1414SPX2026-09-21 13:39put_frontspread2110094600.00longask7754.32000.3000["7300","7700"]["0.2635","0.1215"]["6914.92","7685.08"]["XCBO"]7300.00007700.000044falsetruefalsetruefalsecbmotrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:39:25Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c50c-c57f-7b41-aba3-8d977beaf57fSPX2026-09-21 13:39straddle2112495600.00longask7754.32001.5000["7825"]["0.1360"]["7412","8238.00"]["XCBO"]7825.00007825.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:39:25Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c505-18a7-7fd2-8b61-10fc86bfc90dSPX2026-09-21 13:30synthetic2128206640.00longask7757.35000.5000["7750"]["0.1132"]["7762.40"]["XCBO"]7750.00007750.000044falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:31:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c505-18a7-7fd2-8b61-10e3cf227c8bSPX2026-09-21 13:30synthetic2342309960.00longask7757.35000.5000["7750"]["0.1132"]["7762.40"]["XCBO"]7750.00007750.000044falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:31:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c505-18a7-7fd2-8b61-1092c35dfa41SPX2026-09-21 13:30synthetic229289800.00longbid7757.35001.8000["7825"]["0.1354"]["7917.00"]["XCBO"]7825.00007825.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:31:05Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4f9-2dde-77a3-a7d1-736d2eca0f61SPX2026-09-21 13:17synthetic2226887500.00longask7757.20001.7000["7825"]["0.1366"]["7754.35"]["XCBO"]7825.00007825.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:18:00Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4f0-c587-79d3-a19b-f844e5227970SPX2026-09-21 13:08synthetic2116660160.00longask7753.66001.8000["7820"]["0.1359"]["7822.00"]["XCBO"]7820.00007820.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:08:50Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4f0-4887-74f3-aeb3-a31cee5a018cSPX2026-09-21 13:07synthetic22311072400.00longask7754.58001.9000["7815"]["0.1370"]["7754.94"]["XCBO"]7815.00007815.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:08:12Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4df-d1ae-7571-86ab-43af116e5216SPX2026-09-21 12:49ratio_risk_reversal2150199500.00longask7752.32001.4000["6500","7820"]["0.2568","0.1331"]["6484.94"]["XCBO"]6500.00007820.00008888falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:50:02Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4d6-b5a6-7200-abae-1e61917c70a6SPX2026-09-21 12:39synthetic2111459800.00longask7749.62001.7000["7810"]["0.1378"]["7822.00"]["XCBO"]7810.00007810.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:40:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4c3-d1b6-7260-9507-16e256090f14SPX2026-09-21 12:19synthetic231285288960.00longbid7746.07001.5000["7815"]["0.1362"]["7815"]["XCBO"]7815.00007815.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:19:50Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4ac-3e8e-7c33-ae6e-a3714c837e45SPX2026-09-21 11:53synthetic21251037500.00longask7738.58001.5000["7800"]["0.1370"]["7807.00"]["XCBO"]7800.00007800.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:53:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4a8-2b96-7fa1-af9d-49bee2da348aSPX2026-09-21 11:49risk_reversal212003329800.00longask7740.34001.2000["7000","8000"]["0.2066","0.1247"]["8062.49"]["XCBO"]7000.00008000.00008888falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:49:19Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4a1-97fe-76a2-b2b2-5148af6d04adSPX2026-09-21 11:41synthetic2116493600.00longask7734.77001.5000["7795"]["0.1377"]["7697.50"]["XCBO"]7795.00007795.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:42:10Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c497-a137-7e72-a820-cb9f043771e6SPX2026-09-21 11:31ratio_risk_reversal211002410240.00longbid7729.56001.4000["7800","7900"]["0.1390","0.1278"]["7963.18"]["XCBO"]7800.00007900.00008888falsefalsefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:31:18Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c490-9487-7aa1-9193-fca908d6fd78SPX2026-09-21 11:23risk_reversal2310003787000.00longask7729.60000.2000["7600","7800"]["0.1258","0.0983"]["7807.81"]["XCBO"]7600.00007800.000099falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:23:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c490-9487-7aa1-9193-fc96ae4eabe7SPX2026-09-21 11:23synthetic231305353400.00longbid7729.60001.6000["7800"]["0.1361"]["7799"]["XCBO"]7800.00007800.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:23:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c477-e04f-7140-838b-b5dbc82019f9SPX2026-09-21 10:56straddle22632583000.00longask7721.04001.7000["7780"]["0.1356"]["7370","8190.00"]["XCBO"]7780.00007780.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:56:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c472-94d6-7ee0-9359-5b77f9aaad9fSPX2026-09-21 10:50synthetic21983006150.00longbid7719.71001.6000["7790"]["0.1345"]["7892.25"]["XCBO"]7790.00007790.00008888falsefalsefalsefalsetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:50:39Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c469-5d76-7332-a52a-aba145f108edSPX2026-09-21 10:40risk_reversal21801269280.00longask7722.62001.1000["7000","8000"]["0.2050","0.1229"]["8052.60"]["XCBO"]7000.00008000.00008888falsetruefalsetruetruecbmomarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:40:50Z"}2026-09-212026-09-21 17:152026-09-21 17:15