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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c523-04cf-7ce3-ada1-e3d457be4bcb | META | 2026-09-21 14:03 | call_ratio_spread | 2 | 1 | 150 | 1410200.00 | long | ask | 744.6300 | 1.9500 | ["675","740"] | ["0.4721","0.4674"] | ["697.31","825.38"] | ["XPHO"] | 675.0000 | 740.0000 | 25 | 25 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:03:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c521-37df-7fa2-a280-d2a819a32e7e | META | 2026-09-21 14:01 | call_ratio_spread | 2 | 1 | 15 | 415420.00 | long | ask | 744.0164 | 7.0000 | ["540","650"] | ["0.4518","0.4388"] | ["561.25","827.50"] | ["XCBO"] | 540.0000 | 650.0000 | 116 | 116 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:02:03Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c507-df97-75d1-a5cf-84d12d245af6 | META | 2026-09-21 13:33 | call_ratio_spread | 2 | 1 | 2 | 41949.00 | unknown | ask | 737.3109 | 4.5500 | ["620","650"] | ["0.4354","0.4366"] | ["769.83"] | ["XMIO"] | 620.0000 | 650.0000 | 116 | 116 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:34:13Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c463-5a67-7330-85f5-784bd6df76ff | META | 2026-09-21 10:33 | call_ratio_spread | 2 | 1 | 2 | 35713.00 | unknown | ask | 711.9201 | 7.1500 | ["620","720"] | ["0.4455","0.4417"] | ["772.38"] | ["XBOX"] | 620.0000 | 720.0000 | 151 | 151 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:34:11Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c45a-750e-7010-acec-5a4b14eaead9 | META | 2026-09-21 10:24 | call_ratio_spread | 2 | 1 | 110 | 1003720.00 | unknown | ask | 712.6500 | 1.0000 | ["650","700"] | ["0.4238","0.4157"] | ["669.81","780.51"] | ["XPHO"] | 650.0000 | 700.0000 | 25 | 25 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:24:19Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c452-a50f-7202-91a8-719406937956 | META | 2026-09-21 10:15 | call_ratio_spread | 2 | 1 | 4 | 135432.00 | unknown | ask | 714.9780 | 12.0000 | ["480","530"] | ["0.4532","0.4293"] | ["718.56"] | ["XCBO"] | 480.0000 | 530.0000 | 88 | 88 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:15:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c447-5e57-7691-a4c1-75a1733b5617 | META | 2026-09-21 10:03 | call_ratio_spread | 2 | 1 | 2 | 34870.00 | unknown | ask | 711.1100 | 8.9500 | ["550","650"] | ["0.4913","0.4552"] | ["732.90"] | ["XCBO"] | 550.0000 | 650.0000 | 60 | 60 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:03:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5c6-decf-7463-a876-4f075bcadbca | META | 2026-09-18 14:28 | call_ratio_spread | 2 | 1 | 2 | 27861.00 | long | ask | 671.1600 | 3.8000 | ["620","760"] | ["0.4274","0.4231"] | ["912.99"] | ["XCBO"] | 620.0000 | 760.0000 | 272 | 272 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:28:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab5e-a803-7a43-a398-4a50f85a7776 | META | 2026-09-16 13:58 | call_ratio_spread | 2 | 1 | 20 | 558860.00 | unknown | — | 675.2400 | 7.4500 | ["480","600"] | ["0.4350","0.4202"] | [] | ["XMIO"] | 480.0000 | 600.0000 | 184 | 184 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:58:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aac4-581b-7340-8167-5bc40b7fe2cc | META | 2026-09-16 11:09 | call_ratio_spread | 2 | 1 | 375 | 2756520.00 | long | ask | 679.1200 | 3.9000 | ["605","665"] | ["0.4048","0.4031"] | ["640.62","708.33"] | ["AMXO"] | 605.0000 | 665.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:10:24Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa70-5063-78c2-90f1-1ff17b4841e1 | META | 2026-09-16 09:37 | call_ratio_spread | 2 | 1 | 75 | 460175.00 | long | ask | 679.2300 | 4.4000 | ["630","790"] | ["0.4126","0.4104"] | ["635.27","867.36"] | ["XMIO"] | 630.0000 | 790.0000 | 121 | 121 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:38:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08693-9e89-7fa2-9240-229e48f787a4 | META | 2026-09-09 10:30 | call_ratio_spread | 2 | 1 | 10 | 48325.00 | long | ask | 643.0500 | 1.8500 | ["690","780"] | ["0.4175","0.4217"] | ["870.43"] | ["XCBO"] | 690.0000 | 780.0000 | 128 | 128 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:30:38Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08681-0ca0-79e0-821d-4d964abdb2de | META | 2026-09-09 10:09 | call_ratio_spread | 2 | 1 | 32 | 110544.00 | long | ask | 646.3350 | 0.5500 | ["620","720"] | ["0.3939","0.4065"] | ["647.01","792.99"] | ["XCBO"] | 620.0000 | 720.0000 | 37 | 37 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:10:21Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06d36-d695-7321-ad8b-94ac06888767 | META | 2026-09-04 12:18 | call_ratio_spread | 2 | 1 | 28 | 231540.00 | long | ask | 613.2950 | 2.5500 | ["580","630"] | ["0.4079","0.4066"] | ["582.94","714.70"] | ["XMIO"] | 580.0000 | 630.0000 | 77 | 77 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:18:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d34-a02d-7ad0-bbe2-2a02b491d249 | META | 2026-09-04 12:15 | call_ratio_spread | 2 | 2 | 8 | 41284.00 | long | ask | 612.5100 | 1.7500 | ["600","675"] | ["0.4073","0.4079"] | ["605.01","744.99"] | ["XMIO"] | 600.0000 | 675.0000 | 77 | 77 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:15:58Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |