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
uw_multileg367,592 rowsexportable
active:ticker = FIG×
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_sidetext | underlying_pricenumeric | bid_ask_spreadnumeric | strikesjsonb | ivsjsonb | breakevensjsonb | uniq_exchangesjsonb | min_strikenumeric | max_strikenumeric | min_dteinteger | max_dteinteger | all_opening_legsboolean | all_otmboolean | diff_expirationsboolean | diff_strikesboolean | diff_typesboolean | codetext | kept_bytext | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ea-ce07-7610-bc0c-65d343b85f75 | FIG | 2026-09-18 15:07 | call_vertical_spread | 2 | 3 | 600 | 740800.00 | unknown | bid | 22.7690 | 0.7000 | ["20","25"] | ["0.7884","0.7801"] | ["28.67"] | ["EMLD","XCBO","XISX"] | 20.0000 | 25.0000 | 245 | 245 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:08:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ea-ce07-7610-bc0c-65cfa3a83349 | FIG | 2026-09-18 15:07 | call_vertical_spread | 2 | 2 | 400 | 493600.00 | unknown | bid | 22.7690 | 0.7000 | ["20","25"] | ["0.7878","0.7796"] | ["28.67"] | ["AMXO","XISX"] | 20.0000 | 25.0000 | 245 | 245 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:08:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b2-0773-7bb1-acc9-56781d16f181 | FIG | 2026-09-17 14:47 | put_ladder | 8 | 1 | 948 | 638928.00 | unknown | — | 23.5150 | 7.5700 | ["26","26.5","27","27.5","28","28.5","30","31"] | ["2.3029","2.4932","4.1501","2.7860","2.4342","5.2640","5.0322","7.3365"] | [] | ["XBOX"] | 26.0000 | 31.0000 | 1 | 1 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:48:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b03a-c81b-7072-8c68-ab875fda09ea | FIG | 2026-09-17 12:37 | strangle | 2 | 1 | 100 | 306000.00 | long | ask | 22.9100 | 0.8500 | ["30","45"] | ["0.8006","0.7950"] | ["14.40","60.60"] | ["SPHR"] | 30.0000 | 45.0000 | 491 | 491 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:37:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab6e-e82b-7490-8087-0e25d09b5ba8 | FIG | 2026-09-16 14:16 | call_calendar | 2 | 1 | 50 | 107950.00 | unknown | — | 22.7400 | 2.1000 | ["20"] | ["0.8066"] | [] | ["AMXO"] | 20.0000 | 20.0000 | 492 | 856 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:16:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab02-822b-7d93-8655-a86ccdcbe477 | FIG | 2026-09-16 12:17 | strangle | 2 | 1 | 50 | 153750.00 | unknown | — | 22.7950 | 0.6000 | ["30","45"] | ["0.7860","0.8644"] | [] | ["XISX"] | 30.0000 | 45.0000 | 492 | 492 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:17:49Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aacb-9b7b-77a0-af3d-14a3e9497c74 | FIG | 2026-09-16 11:17 | strangle | 2 | 1 | 50 | 153750.00 | long | ask | 22.9600 | 0.7500 | ["30","45"] | ["0.7833","0.8662"] | ["14.25","60.75"] | ["BATO"] | 30.0000 | 45.0000 | 492 | 492 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:18:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aabb-9204-7b42-86e9-bf33ed143516 | FIG | 2026-09-16 11:00 | put_ratio_spread | 2 | 4 | 1800 | 439200.00 | unknown | — | 22.9100 | 0.4700 | ["24","25"] | ["0.9722","0.9745"] | [] | ["XCBO"] | 24.0000 | 25.0000 | 2 | 2 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:00:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa9b-a623-7401-bd12-8979c4206db6 | FIG | 2026-09-16 10:25 | strangle | 2 | 1 | 150 | 462300.00 | short | bid | 22.8927 | 0.6000 | ["30","45"] | ["0.7891","0.8675"] | ["14.18","60.82"] | ["SPHR"] | 30.0000 | 45.0000 | 492 | 492 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:25:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa98-8173-73f1-ad08-bc2fa89a0225 | FIG | 2026-09-16 10:21 | strangle | 2 | 1 | 50 | 154250.00 | short | bid | 23.0200 | 0.6500 | ["30","45"] | ["0.7866","0.8721"] | ["14.15","60.85"] | ["AMXO"] | 30.0000 | 45.0000 | 492 | 492 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:22:03Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08cb2-ae80-7793-b1bb-b0948b2d43d5 | FIG | 2026-09-10 15:01 | other | 6 | 1 | 640 | 583372.00 | unknown | — | 22.1500 | 3.5500 | ["26","26.5","27","27.5","28","28.5"] | ["2.4363","2.6380","2.5702","2.7469","2.3439","3.0833"] | [] | ["XBOX"] | 26.0000 | 28.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:02:16Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086e4-3b40-7b50-9148-14974e382572 | FIG | 2026-09-09 11:58 | straddle | 2 | 1 | 500 | 1077500.00 | unknown | — | 22.2620 | 0.8000 | ["35"] | ["0.8045"] | [] | ["AMXO"] | 35.0000 | 35.0000 | 499 | 499 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:58:24Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08198-6d50-7ed1-a728-3f64b0e99c39 | FIG | 2026-09-08 11:17 | strangle | 2 | 1 | 170 | 409700.00 | unknown | — | 23.3200 | 0.7000 | ["40","45"] | ["0.8277","0.7959"] | [] | ["SPHR"] | 40.0000 | 45.0000 | 500 | 500 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:17:29Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08191-6488-7b82-a4c4-2a29d8b73dbb | FIG | 2026-09-08 11:09 | strangle | 2 | 1 | 200 | 483000.00 | unknown | — | 23.3500 | 0.6000 | ["40","45"] | ["0.8383","0.7900"] | [] | ["XMIO"] | 40.0000 | 45.0000 | 500 | 500 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:09:46Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |