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 |
|---|
| 01a08296-41c8-7f43-a643-ff4d6b2a1458 | XBI | 2026-09-08 15:54 | put_vertical_spread | 2 | 5 | 356 | 133596.00 | short | bid | 161.9250 | 0.3693 | ["161","162"] | ["0.3619","0.3550"] | ["161.57"] | ["EMLD","MCRY","XBOX","XMIO","XPHO"] | 161.0000 | 162.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:54:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08699-3c08-7ff3-a479-1e5697f2e7c6 | XBI | 2026-09-09 10:36 | put_vertical_spread | 2 | 5 | 516 | 171828.00 | short | bid | 160.4700 | 0.3100 | ["159","161"] | ["0.4045","0.3837"] | ["160.17"] | ["ARCO","BATO","EMLD","XBOX","XISX"] | 159.0000 | 161.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a08b8d-9b28-7eb1-80fc-9bb9f6ad077b | XBI | 2026-09-10 09:41 | put_vertical_spread | 2 | 1 | 250 | 187000.00 | short | bid | 156.9600 | 1.2500 | ["157","159"] | ["0.3513","0.3460"] | ["157.94"] | ["XMIO"] | 157.0000 | 159.0000 | 8 | 8 | false | false | false | true | |||||||||
| 01a08c13-0380-72c3-aea4-c80c520ba2ed | XBI | 2026-09-10 12:07 | put_diagonal_spread | 2 | 2 | 500 | 421000.00 | long | bid | 156.9500 | 0.4500 | ["156","163"] | ["0.3214","0.4796"] | [] | ["XMIO"] | 156.0000 | 163.0000 | 1 | 8 | false | false | true | true | |||||||||
| 01a0a157-78c1-74c3-9689-23d569abf996 | XBI | 2026-09-14 15:14 | call_vertical_spread | 2 | 1 | 81 | 218457.00 | short | bid | 157.5300 | 1.9000 | ["143","150"] | ["0.3352","0.3213"] | ["148.53"] | ["XCBO"] | 143.0000 | 150.0000 | 32 | 32 | false | false | false | true | |||||||||
| 01a0a598-cb26-73e3-8693-725e5062a321 | XBI | 2026-09-15 11:04 | put_vertical_spread | 2 | 4 | 289 | 131296.00 | short | bid | 152.9600 | 0.1459 | ["151","155"] | ["0.3948","0.3749"] | ["153.08"] | ["ARCO","C2OX","EDGO","XBOX"] | 151.0000 | 155.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a5c7-497e-7cb3-8da3-c8aa03b30d4f | XBI | 2026-09-15 11:54 | call_vertical_spread | 2 | 1 | 100 | 111500.00 | short | bid | 153.3600 | 1.4500 | ["148","149"] | ["0.4369","0.4219"] | ["148.85"] | ["XPHO"] | 148.0000 | 149.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a658-94ce-7332-b835-46522b4b52ca | XBI | 2026-09-15 14:33 | call_calendar | 2 | 1 | 38 | 415986.00 | short | bid | 153.6500 | 4.4000 | ["100"] | ["1.2981"] | [] | ["BATO"] | 100.0000 | 100.0000 | 3 | 185 | false | false | true | false | false | ||||||||
| 01a0a65a-1f56-7090-bf35-89a17340eab1 | XBI | 2026-09-15 14:35 | call_calendar | 2 | 1 | 405 | 4433535.00 | short | bid | 153.6050 | 4.4000 | ["100"] | ["1.3480"] | [] | ["BATO"] | 100.0000 | 100.0000 | 3 | 185 | false | false | true | false | |||||||||
| 01a0b086-6393-7870-999e-b0c61cb378b8 | XBI | 2026-09-17 13:59 | put_vertical_spread | 2 | 2 | 597 | 125370.00 | short | bid | 157.7600 | 0.3599 | ["156","158"] | ["0.4214","0.3991"] | ["157.24"] | ["ARCO","XBOX"] | 156.0000 | 158.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0b5d6-a5df-75d0-8a04-2cc07e6f9466 | XBI | 2026-09-18 14:45 | other | 3 | 10 | 85 | 122137.00 | unknown | bid | 156.3500 | 0.7000 | ["160"] | ["0.5142"] | [] | ["AMXO","ARCO","C2OX","EDGO","EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 160.0000 | 160.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0b5fc-9ca0-71d2-9bf1-e97610736134 | XBI | 2026-09-18 15:27 | call_calendar | 2 | 1 | 26 | 105820.00 | long | bid | 156.8900 | 1.1000 | ["140"] | ["0.3164"] | [] | ["XISX"] | 140.0000 | 140.0000 | 35 | 119 | false | false | true | false | false | ||||||||
| 01a0b611-e5d8-7242-baf3-47c8d2eba54a | XBI | 2026-09-18 15:50 | call_diagonal_spread | 2 | 1 | 1000 | 1160000.00 | short | bid | 156.4900 | 2.5000 | ["150","152"] | ["0.2771","4.1612"] | [] | ["AMXO"] | 150.0000 | 152.0000 | 0 | 7 | false | false | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:36:25Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:42:01Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:07:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:14:49Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:04:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:34:19Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:35:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:00:20Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:45:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:27:30Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:50:30Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |