core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d935-c457-7712-8533-f6d6a3dae549 | TXN | 2026-09-25 11:36 | other | 4 | 2 | 103 | 201675.00 | unknown | ask | 275.8100 | 6.5600 | ["265","272.5","285","292.5"] | ["1.5850","1.0015","0.3828","0.3992"] | [] | ["XMIO"] | 265.0000 | 292.5000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T15:36:44Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d8d3-a727-7a72-ba9e-e8b4ad833272 | TXN | 2026-09-25 09:49 | call_calendar | 2 | 1 | 8 | 218144.00 | short | ask | 275.5100 | 5.8500 | ["140"] | ["0.6875"] | [] | ["BATO"] | 140.0000 | 140.0000 | 84 | 112 | false | false | |||||||||||
| 01a0d8ce-c90e-7da2-9906-6c33393a67b9 | TXN | 2026-09-25 09:43 | call_vertical_spread | 2 | 1 | 100 | 138100.00 | unknown | ask | 275.8100 | 1.5000 | ["280","290"] | ["0.3931","0.3866"] | ["291.90"] | ["XBOX"] | 280.0000 | 290.0000 | 21 | 21 | false | true | |||||||||||
| 01a0d457-17e6-7123-8818-8d250acdc852 | TXN | 2026-09-24 12:54 | other | 4 | 1 | 1285 | 1980099.00 | unknown | ask | 271.2850 | 3.7300 | ["265","272.5","277.5","285"] | ["0.5976","0.5010","0.3977","0.3918"] | [] | ["XCBO"] | 265.0000 | 285.0000 | 1 | 8 | false | false | |||||||||||
| 01a0d3b6-3c37-73f3-a36f-84fa251aa8ae | TXN | 2026-09-24 09:58 | put_vertical_spread | 2 | 1 | 10 | 218380.00 | long | ask | 268.9900 | 5.3500 | ["375","380"] | ["3.4435","3.5360"] | ["375.02"] | ["XCBO"] | 375.0000 | 380.0000 | 1 | 1 | false | false | |||||||||||
| 01a0ceb0-6086-71b1-8453-d74cb66a351a | TXN | 2026-09-23 10:34 | put_vertical_spread | 2 | 1 | 4 | 106808.00 | long | ask | 269.7500 | 5.6500 | ["400","405"] | ["2.8648","2.9250"] | ["400.02"] | ["XMIO"] | 400.0000 | 405.0000 | 2 | 2 | false | false | |||||||||||
| 01a0ceb0-3977-7602-8b6e-e941ea19c727 | TXN | 2026-09-23 10:34 | put_vertical_spread | 2 | 1 | 10 | 267020.00 | long | ask | 269.7500 | 5.6500 | ["400","405"] | ["2.8648","2.9250"] | ["400.02"] | ["XMIO"] | 400.0000 | 405.0000 | 2 | 2 | false | false | |||||||||||
| 01a0ca9b-9b98-7f00-8b59-0286c89552db | TXN | 2026-09-22 15:33 | call_diagonal_spread | 2 | 1 | 4 | 118764.00 | short | ask | 270.1600 | 7.5500 | ["120","140"] | ["0.4984","0.2084"] | [] | ["XPHO"] | 120.0000 | 140.0000 | 486 | 850 | false | false | |||||||||||
| 01a0ca71-fb57-7fc1-9ad0-870f36402658 | TXN | 2026-09-22 14:47 | put_vertical_spread | 2 | 1 | 4 | 102596.00 | long | ask | 269.2350 | 2.2000 | ["395","400"] | ["1.7150","1.7479"] | ["395.01"] | ["AMXO"] | 395.0000 | 400.0000 | 3 | 3 | false | false | |||||||||||
| 01a0aa97-8f43-7fc3-b882-0d7fa8384924 | TXN | 2026-09-16 10:20 | call_calendar | 2 | 1 | 318 | 1144800.00 | short | ask | 264.6450 | 3.8000 | ["250"] | ["0.4755"] | [] | ["XMIO"] | 250.0000 | 250.0000 | 2 | 30 | false | false | |||||||||||
| 01a0aa93-0b03-7962-b44c-c5c48f32b589 | TXN | 2026-09-16 10:15 | put_vertical_spread | 2 | 1 | 3 | 124971.00 | long | ask | 264.2400 | 7.2500 | ["470","475"] | ["3.0384","3.0626"] | ["470.01"] | ["AMXO"] | 470.0000 | 475.0000 | 2 | 2 | false | false | |||||||||||
| 01a0a620-4aa6-7721-850b-565332a1670d | TXN | 2026-09-15 13:32 | call_vertical_spread | 2 | 1 | 4 | 108704.00 | long | ask | 263.2550 | 2.8000 | ["125","130"] | ["3.1570","3.0756"] | ["129.98"] | ["XCBO"] | 125.0000 | 130.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a617-f5d6-77a1-90d3-ffd999ae2d6e | TXN | 2026-09-15 13:23 | call_vertical_spread | 2 | 1 | 7 | 162127.00 | long | ask | 263.2200 | 2.4000 | ["145","150"] | ["2.3609","2.2864"] | ["149.99"] | ["XCBO"] | 145.0000 | 150.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a5ff-12be-7b61-90e0-c6e032b0b4d0 | TXN | 2026-09-15 12:55 | put_vertical_spread | 2 | 1 | 10 | 438390.00 | long | ask | 263.3650 | 7.4000 | ["480","485"] | ["2.7434","2.7402"] | ["480.03"] | ["XMIO"] | 480.0000 | 485.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a5fd-c2ce-7d63-90b2-7c3a9dc696d2 | TXN | 2026-09-15 12:54 | call_vertical_spread | 2 | 1 | 4 | 112544.00 | long | ask | 263.4850 | 3.9000 | ["120","125"] | ["4.3291","4.2310"] | ["124.98"] | ["XCBO"] | 120.0000 | 125.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a5f9-9866-7b03-87e9-a9102dad5128 | TXN | 2026-09-15 12:49 | call_vertical_spread | 2 | 1 | 3 | 102366.00 | long | ask | 263.3400 | 3.6000 | ["90","95"] | ["5.7765","5.6405"] | ["94.98"] | ["XCBO"] | 90.0000 | 95.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a5e7-c5e5-7ad3-8ca5-16445b5cf61e | TXN | 2026-09-15 12:30 | put_vertical_spread | 2 | 1 | 9 | 366768.00 | long | ask | 263.6600 | 7.9000 | ["465","470"] | ["2.3255","2.3032"] | ["465.02"] | ["XISX"] | 465.0000 | 470.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a5c6-c4ae-7bb1-baa2-8583c249f6c0 | TXN | 2026-09-15 11:54 | call_vertical_spread | 2 | 1 | 3 | 105972.00 | long | ask | 263.6825 | 3.1500 | ["85","90"] | ["5.7472","5.5081"] | ["89.98"] | ["XCBO"] | 85.0000 | 90.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a5c1-6995-77b1-b001-1669e71c16e5 | TXN | 2026-09-15 11:48 | call_vertical_spread | 2 | 1 | 3 | 102945.00 | long | ask | 263.9600 | 2.5000 | ["90","95"] | ["4.4431","4.3850"] | ["94.97"] | ["XPHO"] | 90.0000 | 95.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a5bc-f10e-7e23-9c00-3e3a1403a91d | TXN | 2026-09-15 11:43 | call_vertical_spread | 2 | 1 | 3 | 105885.00 | long | ask | 264.1000 | 2.7000 | ["85","90"] | ["5.8927","5.7732"] | ["89.97"] | ["XPHO"] | 85.0000 | 90.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a5a6-a21e-7653-b9eb-95acada323a9 | TXN | 2026-09-15 11:19 | call_vertical_spread | 2 | 1 | 3 | 103110.00 | long | ask | 264.1400 | 3.2000 | ["90","95"] | ["4.9045","4.7295"] | ["94.98"] | ["MCRY"] | 90.0000 | 95.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a5a3-100e-73e1-8fb7-7cce4613d230 | TXN | 2026-09-15 11:15 | call_vertical_spread | 2 | 1 | 3 | 108927.00 | long | ask | 264.1450 | 2.2000 | ["80","85"] | ["6.0007","5.9025"] | ["84.99"] | ["AMXO"] | 80.0000 | 85.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a105-e5f0-79b1-aed6-b059f15c18b9 | TXN | 2026-09-14 13:45 | call_vertical_spread | 2 | 1 | 5 | 157925.00 | long | ask | 264.8300 | 4.7000 | ["105","110"] | ["4.2977","4.1303"] | ["109.97"] | ["XCBO"] | 105.0000 | 110.0000 | 4 | 4 | false | false | |||||||||||
| 01a08154-3478-77f2-90e2-1acecb8840d6 | TXN | 2026-09-08 10:02 | risk_reversal | 2 | 2 | 78 | 459810.00 | short | ask | 257.7200 | 1.6500 | ["270","280"] | ["0.4369","0.3940"] | ["256.57"] | ["ARCO","XBOX"] | 270.0000 | 280.0000 | 192 | 192 | false | false | |||||||||||
| 01a08154-3090-7941-8f73-853f53754964 | TXN | 2026-09-08 10:02 | strangle | 2 | 3 | 48 | 284761.00 | long | ask | 257.7200 | 1.0500 | ["270","280"] | ["0.4357","0.4002"] | ["210.67","339.33"] | ["C2OX","EDGO","XISX"] | 270.0000 | 280.0000 | 192 | 192 | false | false |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:49:11Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:43:51Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:54:48Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:59:14Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:34:22Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:34:22Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:33:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:47:49Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:21:27Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:15:56Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:32:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:23:28Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:56:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:54:46Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:50:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:30:28Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:55:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:49:04Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:43:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:19:45Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:15:56Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:45:16Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:03:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:03:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |