core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0c544-11bf-7471-8916-3372e18cea62 | ASST | 2026-09-21 14:39 | call_diagonal_spread | 2 | 1 | 65 | 258245.00 | long | ask | 30.0700 | 4.2500 | ["15","20"] | ["1.0427","1.0131"] | [] | ["XPHO"] | 15.0000 | 20.0000 | 487 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:39:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4b2-8bd6-7282-a312-682fa46881cc | ASST | 2026-09-21 12:00 | call_diagonal_spread | 2 | 1 | 18500 | 4671250.00 | unknown | ask | 29.1450 | 0.5100 | ["29","30"] | ["0.9638","0.8080"] | [] | ["XPHO"] | 29.0000 | 30.0000 | 4 | 11 | false | false | true | ||||||||||
| 01a0c440-8856-7333-88dc-e5011559f4e1 | ASST | 2026-09-21 09:55 | call_condor | 4 | 1 | 20 | 117260.00 | long | ask | 30.1000 | 2.0500 | ["20","25","30","35"] | ["1.0179","1.0081","1.0023","0.9937"] | ["20.51","34.49"] | ["XMIO"] | 20.0000 | 35.0000 | 487 | 487 | false | false | false | ||||||||||
| 01a0b614-df8f-7650-a840-7162d0a6d1f9 | ASST | 2026-09-18 15:53 | iron_butterfly | 4 | 1 | 310 | 101060.00 | short | ask | 30.1400 | 0.8900 | ["28","30.5","33"] | ["0.7590","0.7455","0.7247"] | ["28.74","32.26"] | ["XCBO"] | 28.0000 | 33.0000 | 7 | 7 | false | false | false | ||||||||||
| 01a0b609-9cbf-7862-9a82-7da69bf634b6 | ASST | 2026-09-18 15:41 | call_diagonal_spread | 2 | 1 | 100 | 241200.00 | long | ask | 30.1200 | 1.3500 | ["17","38"] | ["0.9924","0.9530"] | [] | ["XMIO"] | 17.0000 | 38.0000 | 182 | 490 | false | false | true | ||||||||||
| 01a0b07b-5f43-77e0-b590-267ddc6577ec | ASST | 2026-09-17 13:47 | call_calendar | 2 | 1 | 2500 | 1677500.00 | long | ask | 28.9700 | 0.6000 | ["27"] | ["0.7421"] | [] | ["EDGO"] | 27.0000 | 27.0000 | 22 | 29 | false | false | true | false | |||||||||
| 01a0ab04-762b-7223-a78f-283d59b04231 | ASST | 2026-09-16 12:19 | call_diagonal_spread | 2 | 1 | 50 | 119500.00 | long | ask | 27.2000 | 0.6500 | ["35","40"] | ["0.9879","1.0080"] | [] | ["XISX"] | 35.0000 | 40.0000 | 492 | 856 | false | true | true | ||||||||||
| 01a0a58e-c4be-7a30-9be1-2d7d4d46a404 | ASST | 2026-09-15 10:53 | call_diagonal_spread | 2 | 1 | 50 | 121400.00 | long | ask | 27.1500 | 1.0000 | ["35","40"] | ["1.0089","1.0217"] | [] | ["XISX"] | 35.0000 | 40.0000 | 493 | 857 | false | true | true | ||||||||||
| 01a09207-59f9-7e63-a5b7-bce683b26b81 | ASST | 2026-09-11 15:52 | iron_butterfly | 4 | 1 | 339 | 106107.00 | short | ask | 27.4000 | 0.5100 | ["26","28","30"] | ["0.7518","0.7299","0.7427"] | ["26.57","29.43"] | ["XCBO"] | 26.0000 | 30.0000 | 7 | 7 | false | false | false | ||||||||||
| 01a09105-b108-7351-bdec-8b4244097c06 | ASST | 2026-09-11 11:11 | call_diagonal_spread | 2 | 1 | 90 | 238590.00 | short | ask | 28.0900 | 2.0500 | ["14","18"] | ["1.0099","0.9890"] | [] | ["XISX"] | 14.0000 | 18.0000 | 98 | 126 | false | false | true | ||||||||||
| 01a09105-b108-7351-bdec-8b3f8ef08910 | ASST | 2026-09-11 11:11 | call_diagonal_spread | 2 | 1 | 94 | 249194.00 | short | ask | 28.0900 | 2.4500 | ["14","18"] | ["1.0099","0.9890"] | [] | ["XPHO"] | 14.0000 | 18.0000 | 98 | 126 | false | false | true | ||||||||||
| 01a09105-b108-7351-bdec-8b27702d5309 | ASST | 2026-09-11 11:11 | call_diagonal_spread | 2 | 1 | 76 | 201932.00 | short | ask | 28.0900 | 2.4500 | ["14","18"] | ["1.0285","0.9971"] | [] | ["AMXO"] | 14.0000 | 18.0000 | 98 | 126 | false | false | true | ||||||||||
| 01a08cc9-b121-7131-aecf-80480f0835bc | ASST | 2026-09-10 15:27 | call_vertical_spread | 2 | 1 | 141 | 138550.00 | long | ask | 27.3500 | 1.1000 | ["34","40"] | ["0.9585","0.9729"] | ["35.22"] | ["XCBO"] | 34.0000 | 40.0000 | 190 | 190 | false | true | false | ||||||||||
| 01a0879d-fdf0-7252-b9b7-dc7f5ab3a3f6 | ASST | 2026-09-09 15:21 | call_diagonal_spread | 2 | 1 | 7600 | 972800.00 | long | ask | 26.4900 | 0.2600 | ["27","28"] | ["0.8382","0.8589"] | [] | ["AMXO"] | 27.0000 | 28.0000 | 2 | 9 | false | true | true | ||||||||||
| 01a08661-3c19-77f1-b14b-9e1c1b5c1c89 | ASST | 2026-09-09 09:35 | call_diagonal_spread | 2 | 1 | 466 | 1257245.00 | short | ask | 27.8750 | 2.8000 | ["13","18"] | ["6.8976","1.0163"] | [] | ["XPHO"] | 13.0000 | 18.0000 | 2 | 128 | false | false | true | ||||||||||
| 01a06dfb-1cad-7471-8df2-9cfa24809d66 | ASST | 2026-09-04 15:52 | iron_butterfly | 4 | 1 | 361 | 110867.00 | short | ask | 26.9600 | 1.4500 | ["25.5","27.5","29.5"] | ["0.7478","0.7324","0.7628"] | ["26.09","28.91"] | ["XCBO"] | 25.5000 | 29.5000 | 7 | 7 | false | false | false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:00:55Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:56:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:53:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:41:32Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:48:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:19:54Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:53:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:52:34Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:11:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:11:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:11:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:27:21Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:21:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:35:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:53:04Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |