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 = mlct×strategy = put_ratio_spread×
idtexttickertextexecuted_attimestamp 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
01a0b5c5-c58f-7c33-ab72-1fbd8f18f19bXLU2026-09-18 14:27put_ratio_spread2190002682000.00unknownbid41.21001.3800["30","41"]["0.2358","0.2271"]["12.80","38.60"]["XBOX"]30.000041.0000854854truetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:27:22Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b539-0e20-74c1-a470-688ee6a0345cXLV2026-09-18 11:53put_ratio_spread21150005200000.00unknownbid167.98001.8700["90","135"]["0.2687","0.2198"]["6.20","131.90"]["ARCO"]90.0000135.0000854854truetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:53:44Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b517-3227-7bd3-9b2c-6fd1bf2fd037XLP2026-09-18 11:16put_ratio_spread211875010075000.00unknownbid83.07501.5700["55","85"]["0.2317","0.2083"]["6.92","79.04"]["SPHR"]55.000085.0000854854truefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:16:56Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b502-cb80-72d0-b12f-2484f127be4bGOOGL2026-09-18 10:54put_ratio_spread2130001860000.00unknownbid351.23950.4400["320","345"]["0.3193","0.3000"]["299.08","340.92"]["ARCO"]320.0000345.00002828falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:54:27Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4f5-90c8-7e33-9775-b1c92b8612b5NVDA2026-09-18 10:39put_ratio_spread2160004296000.00unknownbid219.25000.2300["150","190"]["0.4366","0.3903"]["114.38","185.62"]["AMXO"]150.0000190.0000182182falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:40:08Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4e7-5c10-7ce0-8868-06cab06832a4NVDA2026-09-18 10:24put_ratio_spread2175002530000.00unknownbid220.35000.2500["145","195"]["0.4670","0.3751"]["121.94","191.12"]["AMXO"]145.0000195.0000119119falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:24:28Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4cb-3cd7-79b2-9490-6d03b50fccf4IWM2026-09-18 09:53put_ratio_spread2125004508000.00unknownbid283.48000.5700["260","295"]["0.2310","0.1946"]["164.36","283.91"]["ARCO"]260.0000295.0000119119falsefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:53:43Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4ca-4e8f-76d3-b775-58d72749d4e7INTC2026-09-18 09:52put_ratio_spread2150001782500.00unknownbid109.20000.1900["95","110"]["0.6342","0.6066"]["83.89","106.11"]["ARCO"]95.0000110.00001414falsefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:52:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b02f-5e3b-70b3-8466-42c57a5a30ecGDX2026-09-17 12:24put_ratio_spread214000458000.00unknown95.94000.0600["75","90"]["0.4733","0.4274"][]["ARCO"]75.000090.00002929falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:25:00Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0ab4d-e6f3-7202-884e-40e152a94d6aIWM2026-09-16 13:40put_ratio_spread2145006264000.00unknown286.58000.4200["265","290"]["0.2306","0.2023"][]["AMXO"]265.0000290.0000121121falsefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:40:36Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab4d-e6f3-7202-884e-40de745557ccIWM2026-09-16 13:40put_ratio_spread2130004176000.00unknown286.60010.4200["265","290"]["0.2307","0.2025"][]["AMXO"]265.0000290.0000121121falsefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:40:36Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab1a-8e6b-7e61-b2f0-1001dbc14f7eQQQ2026-09-16 12:43put_ratio_spread2140001092000.00unknown710.00000.0600["525","585"]["0.3974","0.3270"][]["AMXO"]525.0000585.00006565truetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:44:52Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa99-3523-7950-b7f1-6e67a4fb25beIWM2026-09-16 10:22put_ratio_spread2120001695750.00unknown285.93000.1100["260","270"]["0.2466","0.2282"][]["SPHR"]260.0000270.00009393falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:23:11Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a632-24f6-7dc1-8662-5e232c7e9457QQQ2026-09-15 13:51put_ratio_spread211250633500.00unknown704.68010.0300["690","700"]["0.2723","0.2434"][]["AMXO"]690.0000700.000033falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:52:13Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a628-1e8d-7232-9746-4b1692b28ec4LQD2026-09-15 13:40put_ratio_spread215000970000.00unknown104.22500.2000["104","105"]["0.0916","0.0953"][]["AMXO"]104.0000105.00003131falsefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:40:58Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a61e-337e-7d20-9e41-c2e7c2b76fb6QQQ2026-09-15 13:29put_ratio_spread2150005647500.00unknown704.73000.1400["600","680"]["0.3076","0.2307"][]["AMXO"]600.0000680.00006666falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:29:56Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a61c-b895-70b0-bd1f-cf668f5a41faQQQ2026-09-15 13:28put_ratio_spread212500780000.00unknown704.84000.0200["680","701"]["0.3115","0.2444"][]["AMXO"]680.0000701.000033falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:29:02Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a617-9bfe-7491-b134-7995d6895132CRCL2026-09-15 13:22put_ratio_spread2121759194450.00unknown88.57502.6500["60","90"]["0.8292","0.8356"][]["AMXO"]60.000090.0000822822falsefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:23:28Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a60b-e3fe-7191-b6af-2c1dab22fcedCRCL2026-09-15 13:09put_ratio_spread2115756633900.00unknown88.27003.4500["60","90"]["0.8253","0.8310"][]["AMXO"]60.000090.0000822822falsefalsefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:10:24Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5f0-45ae-76e1-8817-004a14840648AVGO2026-09-15 12:39put_ratio_spread2140002474000.00unknown339.09580.2500["280","320"]["0.4014","0.3807"][]["AMXO"]280.0000320.00006666falsetruefalsetruefalsemlctmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:39:48Z"}2026-09-152026-09-15 19:282026-09-15 19:28