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 | directiontext | net_side |
|---|
| 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 |
|---|
| 01a0c472-bfce-7be2-ab94-bc0dc8f0a311 | SILJ | 2026-09-21 10:50 | call_vertical_spread | 2 | 1 | 200 | 157800.00 | long | ask | 29.5267 | 1.0500 | ["40","60"] | ["0.5766","0.6026"] | ["42.67"] | ["XPHO"] | 40.0000 | 60.0000 | 487 | 487 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:51:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b588-a51f-7262-bf53-7b4150a21d2c | SILJ | 2026-09-18 13:20 | call_calendar | 2 | 1 | 120 | 104520.00 | short | bid | 30.0700 | 1.7000 | ["26"] | ["0.8053"] | [] | ["AMXO"] | 26.0000 | 26.0000 | 7 | 35 | false | false | true | false | false | mlet | |||||||
| 01a0b4f5-5dff-7eb1-99b8-6ea4500ae70a | SILJ | 2026-09-18 10:39 | other | 3 | 1 | 3000 | 342000.00 | unknown | ask | 29.7700 | 0.9000 | ["29","29.5","31"] | ["0.5292","0.7512","1.6841"] | [] | ["XISX"] | 29.0000 | 31.0000 | 0 | 7 | false | false | true | true | false | mlct | |||||||
| 01a0b4e8-7d20-7830-b6e6-a268e198329e | SILJ | 2026-09-18 10:25 | other | 6 | 1 | 9222 | 687039.00 | unknown | ask | 29.8150 | 0.8400 | ["28","28.5","29","29.5","31","31.5"] | ["0.4764","1.1289","0.5060","0.6264","0.5184","2.2813"] | [] | ["XISX"] | 28.0000 | 31.5000 | 0 | 7 | false | true | true | true | true | ||||||||
| 01a0ab7e-68eb-7871-8212-7ce6c7ace05a | SILJ | 2026-09-16 14:33 | call_frontspread | 2 | 2 | 200 | 140100.00 | long | bid | 28.5650 | 0.7100 | ["25","30"] | ["0.5196","0.5288"] | ["28.98"] | ["XMIO","XPHO"] | 25.0000 | 30.0000 | 121 | 121 | false | false | false | true | false | ||||||||
| 01a0ab7e-5d33-7741-85a2-2a1859c245dd | SILJ | 2026-09-16 14:32 | call_frontspread | 2 | 1 | 200 | 142700.00 | long | bid | 28.5900 | 0.9100 | ["25","30"] | ["0.5330","0.5390"] | ["29.02"] | ["XISX"] | 25.0000 | 30.0000 | 121 | 121 | false | false | false | true | false | ||||||||
| 01a0a09d-5850-7cc2-9315-3ac0b342bc35 | SILJ | 2026-09-14 11:50 | other | 4 | 1 | 6092 | 1163572.00 | unknown | — | 29.2100 | 0.4200 | ["31","33","35"] | ["0.5343","0.6002","0.7578"] | [] | ["XPHO"] | 31.0000 | 35.0000 | 4 | 32 | false | true | true | true | false | mlat | |||||||
| 01a091f2-6e80-7d32-b22d-b9ec0fb93350 | SILJ | 2026-09-11 15:29 | other | 6 | 1 | 9222 | 613263.00 | unknown | — | 30.4100 | 0.4400 | ["28.5","29.5","30.5","31.5","33"] | ["0.4830","2.3405","1.0671","0.4427","5.2966"] | [] | ["AMXO"] | 28.5000 | 33.0000 | 0 | 7 | false | false | true | true | true | mlat | |||||||
| 01a091cf-1f70-7503-90e1-f85f0f9db1b9 | SILJ | 2026-09-11 14:51 | put_vertical_spread | 2 | 1 | 296 | 167240.00 | long | ask | 30.3100 | 0.6800 | ["25","34"] | ["0.5111","0.5396"] | ["29.59"] | ["XCBO"] | 25.0000 | 34.0000 | 70 | 70 | false | false | false | true | false | ||||||||
| 01a08bc1-97c0-7662-a133-abe9e168b912 | SILJ | 2026-09-10 10:38 | other | 2 | 1 | 143 | 144716.00 | unknown | — | 31.0500 | 0.7500 | ["31","40"] | ["0.5410","0.5669"] | [] | ["AMXO"] | 31.0000 | 40.0000 | 127 | 498 | false | false | true | true | false | mlet | |||||||
| 01a08bbf-49e8-7761-b887-2fc8a748a6d9 | SILJ | 2026-09-10 10:36 | call_diagonal_spread | 2 | 1 | 100 | 101800.00 | short | bid | 31.1000 | 0.8500 | ["31","40"] | ["0.5425","0.5665"] | [] | ["AMXO"] | 31.0000 | 40.0000 | 127 | 498 | false | false | true | true | false | ||||||||
| 01a08bbe-3490-7c23-a6a8-658e9655cf5d | SILJ | 2026-09-10 10:34 | other | 2 | 1 | 100 | 100400.00 | unknown | — | 31.0287 | 0.6000 | ["31","40"] | ["0.5385","0.5642"] | [] | ["AMXO"] | 31.0000 | 40.0000 | 127 | 498 | false | false | true | true | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:20:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:39:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:25:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:33:18Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:33:18Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:51:28Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:29:57Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:51:21Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:38:39Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:36:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:35:06Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |