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.

312,778 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 = mfsl×direction = long×strategy = call_ratio_spread×
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
01a0b61b-1d37-77a0-a57f-fc4064ad7ecdSPX2026-09-18 16:00call_ratio_spread2247001085000.00longask7650.12000.4000["8500","8900"]["0.1150","0.1342"]["8501.58","9437.86"]["XCBO"]8500.00008900.00006363falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T20:01:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5a8-3728-7bf3-adf6-02320689f4c3SPX2026-09-18 13:54call_ratio_spread22120246720.00longask7628.43000.5000["8000","8050"]["0.1062","0.1055"]["8128.10"]["XCBO"]8000.00008050.00004242falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:55:22Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59f-4617-7e60-bb71-3a17c014792cSPX2026-09-18 13:45call_ratio_spread231000572500.00longask7627.86000.2000["7650","7700"]["0.0635","0.0625"]["7657.45","7742.55"]["XCBO"]7650.00007700.000033falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:45:17Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0f6-a5db-7ab1-a453-e77010691151SPX2026-09-17 16:02call_ratio_spread2444001036400.00longask7637.74000.5000["8500","8900"]["0.1167","0.1350"]["8501.64","9378.03"]["XCBO"]8500.00008900.00006464falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T20:02:50Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b09a-ba9b-7833-a7a1-5ab6d784ef75VIX2026-09-17 14:22call_ratio_spread221300128830.00longask15.54000.0900["18.5","40"]["1.2864","1.6354"]["44.66"]["XCBO"]18.500040.00006262falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:22:16Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0abcf-674b-7b40-a34d-2e29da0a9ed1VIX2026-09-16 16:01call_ratio_spread215000293300.00longask17.58000.0900["18.5","50"]["1.0752","1.8871"]["19.01","56.35"]["XCBO"]18.500050.00003535falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T20:01:40Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abc1-2eab-7c51-9e59-f896e24cc4c3CLSK2026-09-16 15:45call_ratio_spread222000162000.00longask12.68500.2500["15","20"]["0.8257","0.8700"]["15.38","24.62"]["XCBO"]15.000020.00006565falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:46:10Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abbc-b23b-7f92-a174-b68625d15583SPX2026-09-16 15:41call_ratio_spread21400757200.00longask7534.19001.0000["8250","8400"]["0.1179","0.1168"]["8250.70","8549.30"]["XCBO"]8250.00008400.00009393falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:41:14Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab56-fb2b-7083-9457-8f04336a50d4SPX2026-09-16 13:49call_ratio_spread23130042900.00longask7606.39000.1000["7740","7765"]["0.5037","0.5347"]["7740.05","7802.42"]["XCBO"]7740.00007765.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:50:04Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab28-07a3-78d0-80e6-7a0e388efd9cVIX2026-09-16 12:58call_ratio_spread223500740600.00longask16.78000.1100["24","27"]["1.2470","1.3069"]["32.26"]["XCBO"]24.000027.00006363falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:59:37Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab17-bfab-7c91-bf8f-26de86ebdcc0VIX2026-09-16 12:40call_ratio_spread2110000930000.00longask16.79000.0700["24","27"]["1.3695","1.4692"]["28.44"]["XCBO"]24.000027.00003535falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:41:30Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aafc-f44b-79b2-933d-42c37154bb0dSPX2026-09-16 12:11call_ratio_spread2250032000.00longask7614.24000.1000["7725","7750"]["0.3648","0.3754"]["7725.23","7787.15"]["XCBO"]7725.00007750.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:12:19Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a5cc-1bde-7cb0-b993-8a3a408249d5SPX2026-09-15 12:00call_ratio_spread2150082500.00longask7582.19000.1000["7610","7620"]["0.1485","0.1553"]["7610.25","7634.62"]["XCBO"]7610.00007620.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:00:25Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5c3-1f16-7e91-8d2b-986fc8416272VIX2026-09-15 11:50call_ratio_spread213000424080.00longask17.62000.1100["19","42.5"]["1.0126","1.5002"]["19.54","53.30"]["XCBO"]19.000042.50006464falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:50:43Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5b0-46dd-7892-a41c-3df75e1d60e4SPX2026-09-15 11:29call_ratio_spread232200555000.00longask7585.12000.5000["8450","8800"]["0.1159","0.1297"]["8451.73","9303.06"]["XCBO"]8450.00008800.00006666falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:30:06Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a097-f568-7ef1-a950-f8286e3d84a7MU2026-09-14 11:45call_ratio_spread221702196320.00longask923.30004.9672["1000","1100"]["0.6103","0.6053"]["1250.63"]["XCBO"]1000.00001100.0000123123falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:45:15Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a070-2600-7ad3-b86d-32182b87c1cfVIX2026-09-14 11:01call_ratio_spread215500260100.00longask17.55000.0800["25","65"]["1.3182","2.0333"]["25.43","82.70"]["XCBO"]25.000065.00003737falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:01:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0920a-9de9-7451-b178-39bd645450e1SPX2026-09-11 15:56call_ratio_spread2437001001100.00longask7659.18000.5500["8400","8800"]["0.1126","0.1320"]["8402.23","9383.40"]["XCBO"]8400.00008800.00005656falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:56:17Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a091fc-1340-7eb0-ab6c-ac28207c974eBA2026-09-11 15:40call_ratio_spread221000717600.00longask210.41000.6400["225","245"]["0.3377","0.3317"]["227.76","270.86"]["XCBO"]225.0000245.00007070falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:40:21Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a091ea-aa38-7660-bafe-ee50cde49ed1HONA2026-09-11 15:21call_ratio_spread221000868900.00longask157.90005.8000["170","240"]["0.4336","0.4272"]["255.14"]["XCBO"]170.0000240.0000279279truetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:21:18Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0910a-be01-79a1-a975-44f8dc42f1b5WULF2026-09-11 11:16call_ratio_spread231500271800.00longask17.25500.3400["18","28"]["0.8616","0.8482"]["19.13","33.91"]["XCBO"]18.000028.00009898falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:16:49Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090c1-f918-7702-854b-e4c0b62fe195SLV2026-09-11 09:57call_ratio_spread221700510000.00longask58.67000.1200["68","80"]["0.4801","0.5282"]["68.70","96.95"]["XCBO"]68.000080.00009898falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T13:57:20Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090bc-e838-7233-bb94-8eaea6094c60VIX2026-09-11 09:51call_ratio_spread22200001863400.00longask16.15000.1100["21","29"]["1.3515","1.5788"]["30.88"]["XCBO"]21.000029.00004040falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T13:51:46Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08c8f-5b89-7443-aa31-c53c199f84ffONDS2026-09-10 14:23call_ratio_spread223000276000.00longask7.32500.0700["7.5","11"]["0.8371","0.8677"]["12.46"]["XCBO"]7.500011.0000127127falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:23:24Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c89-be08-7523-9f71-452b1116e1faSPX2026-09-10 14:17call_ratio_spread2150030500.00longask7588.39000.1000["7615","7625"]["0.1722","0.1859"]["7615.18","7639.72"]["XCBO"]7615.00007625.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:17:47Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c63-88c8-7da0-9ff1-fbb8d580f481VIX2026-09-10 13:35call_ratio_spread223750729000.00longask17.43000.1000["22","25"]["1.2270","1.3192"]["30.04"]["XCBO"]22.000025.00004141falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:35:32Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c51-9708-7091-a6c2-22379c4d85a6VIX2026-09-10 13:15call_ratio_spread231300340860.00longask17.28000.1100["19","22"]["1.1490","1.2381"]["27.00"]["XCBO"]19.000022.00004141falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:16:43Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bdb-8090-7772-81b0-9dc104869e26NVDA2026-09-10 11:06call_ratio_spread22900046800.00longask218.42500.0200["230","237.5"]["0.5218","0.6099"]["230.05","248.67"]["XCBO"]230.0000237.500011falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:07:17Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08797-cc00-7370-acb4-75ccd0db1f51COPX2026-09-09 15:14call_ratio_spread2356982454304.00longask95.33000.6000["105","125"]["0.4905","0.4957"]["107.68","150.97"]["XCBO"]105.0000125.00007272falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:15:02Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08755-bdd8-7780-a4f2-4e70919940faCOPX2026-09-09 14:02call_ratio_spread2350002270000.00longask95.59000.4928["105","125"]["0.4948","0.5054"]["107.63","151.05"]["XCBO"]105.0000125.00007272falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:03:12Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08712-2140-7463-9946-c8ddd60eb040COPX2026-09-09 12:48call_ratio_spread2260002575200.00longask95.31000.8000["105","125"]["0.4903","0.4949"]["107.69","150.97"]["XCBO"]105.0000125.00007272falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:49:01Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086fe-9558-7531-992f-26edd6066477VIX2026-09-09 12:27call_ratio_spread222127352763.00longask16.52000.0900["22","27"]["1.3108","1.4480"]["34.67"]["XCBO"]22.000027.00004242falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:27:33Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086c2-1510-77b1-9c4c-19f427beb3f9SPX2026-09-09 11:20call_ratio_spread23760300200.00longask7634.23000.1500["7750","7755"]["0.1403","0.1391"]["7764.12"]["XCBO"]7750.00007755.000022falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:21:12Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086bf-1f40-73b1-95dc-19194ec004ebSPX2026-09-09 11:17call_ratio_spread23950379810.00longask7633.41000.1500["7750","7755"]["0.1415","0.1403"]["7764.16"]["XCBO"]7750.00007755.000022falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:18:18Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08679-7738-77a1-9703-ee6556c2eb7cCIFR2026-09-09 10:01call_ratio_spread223750596500.00longask18.12000.7300["20","30"]["1.0617","1.0833"]["33.81"]["XCBO"]20.000030.00007272falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:01:41Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08178-bff0-7611-8110-a40ab0ffc342EWZ2026-09-08 10:42call_ratio_spread22170001421200.00longask38.87000.1000["45","55"]["0.3604","0.3635"]["45.79","61.14"]["XCBO"]45.000055.0000129129falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:43:19Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08161-8e70-75a3-a25a-899fc06e04bdVIX2026-09-08 10:17call_ratio_spread2219800447200.00longask15.64000.0500["20","25"]["1.6244","1.9970"]["26.76"]["XCBO"]20.000025.000088falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:17:38Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06de1-149e-7293-a187-6dd527a81ce0VIX2026-09-04 15:24call_ratio_spread226500731500.00longask14.32000.0600["25","60"]["1.4703","1.7853"]["25.77","102.49"]["XCBO"]25.000060.00007575falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:24:53Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d97-6555-7620-b2a0-0415a7a44157VIX2026-09-04 14:03call_ratio_spread222500245000.00longask14.21000.0900["22","45"]["1.5216","1.8708"]["22.67","78.50"]["XCBO"]22.000045.00004747falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:04:12Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d24-8716-7e52-97c3-fcc4a7da2b70VIX2026-09-04 11:58call_ratio_spread22200091200.00longask14.09000.0600["17","24"]["1.3806","1.8573"]["17.26","34.11"]["XCBO"]17.000024.00001212falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T15:58:25Z"}2026-09-042026-09-07 00:532026-09-07 00:53