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 |
|---|
| 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 |
|---|
| 01a0caa6-b757-7673-bc4c-5c31ea4fce99 | AVAV | 2026-09-22 15:45 | other | 4 | 1 | 60 | 105340.00 | unknown | — | 158.2200 | 4.5500 | ["150","190","200"] | ["0.6448","0.6229","0.6344"] | [] | ["XISX"] | 150.0000 | 200.0000 | 3 | 38 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:45:45Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0caa6-b757-7673-bc4c-5c29fbb56d55 | AVAV | 2026-09-22 15:45 | other | 4 | 1 | 60 | 105360.00 | unknown | — | 158.2100 | 4.5500 | ["150","190","200"] | ["0.6467","0.6231","0.6346"] | [] | ["XISX"] | 150.0000 | 200.0000 | 3 | 38 | false | false | true | true | |||||||||
| 01a0c491-8a9f-7b60-b81f-d5dd8b83d04b | AVAV | 2026-09-21 11:24 | risk_reversal | 2 | 1 | 33 | 245817.00 | long | bid | 164.3900 | 5.4000 | ["160","250"] | ["0.6954","0.6886"] | ["149.99"] | ["XMIO"] | 160.0000 | 250.0000 | 487 | 487 | false | true | |||||||||||
| 01a0b603-5747-7f90-8e86-0794dc6ac69a | AVAV | 2026-09-18 15:34 | call_vertical_spread | 2 | 4 | 40 | 149680.00 | short | bid | 160.8303 | 1.8250 | ["160","200"] | ["0.6532","0.6598"] | ["172.80"] | ["XCBO","XISX","XPHO"] | 160.0000 | 200.0000 | 119 | 119 | false | false | |||||||||||
| 01a0b0bb-331b-7a51-aa57-37468e25c773 | AVAV | 2026-09-17 14:57 | call_diagonal_spread | 2 | 1 | 41 | 159654.00 | long | ask | 164.2912 | 2.7000 | ["140","155"] | ["0.6151","0.6261"] | [] | ["C2OX"] | 140.0000 | 155.0000 | 8 | 29 | false | false | |||||||||||
| 01a0afb2-42e3-73a1-b479-f78caf218e8e | AVAV | 2026-09-17 10:08 | call_diagonal_spread | 2 | 1 | 102 | 113548.00 | unknown | — | 163.3350 | 1.7000 | ["160","165"] | ["1.0183","0.7006"] | [] | ["XISX"] | 160.0000 | 165.0000 | 1 | 8 | false | false | true | true | |||||||||
| 01a0af95-6443-70a0-99d3-bdda88bc9d9b | AVAV | 2026-09-17 09:36 | iron_butterfly | 4 | 1 | 10 | 176310.00 | unknown | — | 164.0900 | 25.9000 | ["145","165","200"] | ["0.6996","0.6897","0.6747"] | [] | ["XISX"] | 145.0000 | 200.0000 | 491 | 491 | false | false | false | true | |||||||||
| 01a0a64b-850d-7980-a7a2-9f1137289be1 | AVAV | 2026-09-15 14:19 | other | 4 | 2 | 10 | 118000.00 | unknown | — | 157.1900 | 19.8000 | ["180","185","190"] | ["0.6617","0.6655","0.7249"] | [] | ["ARCO"] | 180.0000 | 190.0000 | 10 | 45 | false | false | true | true | |||||||||
| 01a0a0d2-75f8-7bc3-9e31-6b8d73325572 | AVAV | 2026-09-14 12:49 | put_diagonal_spread | 2 | 4 | 136 | 973934.00 | long | ask | 155.8000 | 3.8324 | ["145","175"] | ["0.7053","0.6637"] | [] | ["ARCO","C2OX","XISX","XPHO"] | 145.0000 | 175.0000 | 123 | 494 | false | false | |||||||||||
| 01a0a0b3-8fd0-7643-bdae-f144af9cb793 | AVAV | 2026-09-14 12:15 | call_diagonal_spread | 2 | 1 | 10 | 128790.00 | long | ask | 154.9550 | 10.7000 | ["125","160"] | ["0.7044","0.6955"] | [] | ["XISX"] | 125.0000 | 160.0000 | 494 | 858 | false | false | |||||||||||
| 01a090e1-48b8-7d63-a50d-c5994507e43c | AVAV | 2026-09-11 10:31 | call_vertical_spread | 2 | 1 | 13 | 134810.00 | unknown | — | 142.8100 | 8.9000 | ["90","100"] | ["0.6319","0.6362"] | [] | ["XBOX"] | 90.0000 | 100.0000 | 126 | 126 | false | false | false | true | |||||||||
| 01a090c4-a0c8-76a3-8c32-2e9258cc0373 | AVAV | 2026-09-11 09:59 | other | 4 | 2 | 180 | 310872.00 | unknown | — | 145.7400 | 4.2500 | ["142","150"] | ["0.9790","1.0636"] | [] | ["XISX"] | 142.0000 | 150.0000 | 0 | 7 | false | false | true | true | false | ||||||||
| 01a08bd7-2748-74f0-bf61-f81824fb9d29 | AVAV | 2026-09-10 11:02 | other | 4 | 1 | 25 | 145325.00 | unknown | — | 155.7000 | 13.3000 | ["137","150"] | ["1.5189","0.9688"] | [] | ["ARCO"] | 137.0000 | 150.0000 | 1 | 8 | false | false | true | true | false | ||||||||
| 01a08bc8-cf68-7773-8020-08f8f8d82d84 | AVAV | 2026-09-10 10:46 | put_vertical_spread | 2 | 1 | 70 | 142800.00 | unknown | — | 156.9733 | 3.4000 | ["145","155"] | ["0.6471","0.6458"] | [] | ["XISX"] | 145.0000 | 155.0000 | 43 | 43 | false | true | false | true | |||||||||
| 01a08bb4-e5c1-7681-972f-bae9f1f41e4d | AVAV | 2026-09-10 10:24 | call_vertical_spread | 2 | 1 | 50 | 107000.00 | long | ask | 155.3928 | 3.0000 | ["140","160"] | ["0.6910","0.7201"] | ["152"] | ["XMIO"] | 140.0000 | 160.0000 | 8 | 8 | false | false | |||||||||||
| 01a08ba1-03e8-78e0-878c-e2722b6b7686 | AVAV | 2026-09-10 10:02 | call_vertical_spread | 2 | 5 | 24 | 106968.00 | long | ask | 151.2650 | 3.8000 | ["125","135"] | ["0.8029","0.7890"] | ["133.93"] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 125.0000 | 135.0000 | 8 | 8 | false | false | |||||||||||
| 01a08b9f-f278-7382-a798-8f79442cfb8a | AVAV | 2026-09-10 10:01 | call_vertical_spread | 2 | 5 | 50 | 223542.00 | long | ask | 151.4050 | 4.8000 | ["125","135"] | ["0.7947","0.7729"] | ["134"] | ["ARCO","BATO","C2OX","EMLD","XPHO"] | 125.0000 | 135.0000 | 8 | 8 | false | false | |||||||||||
| 01a08b9e-cd80-7171-917d-782c6a3af826 | AVAV | 2026-09-10 10:00 | call_vertical_spread | 2 | 1 | 17 | 155193.00 | long | ask | 152.2500 | 8.5000 | ["110","120"] | ["0.6717","0.6709"] | ["116.99"] | ["EDGO"] | 110.0000 | 120.0000 | 127 | 127 | false | false | |||||||||||
| 01a08b9e-cd80-7171-917d-78184edfd9ac | AVAV | 2026-09-10 10:00 | call_vertical_spread | 2 | 2 | 20 | 182560.00 | long | ask | 152.2500 | 8.5000 | ["110","120"] | ["0.6712","0.6709"] | ["116.98"] | ["BATO","C2OX"] | 110.0000 | 120.0000 | 127 | 127 | false | false | |||||||||||
| 01a08b9e-cd80-7171-917d-780a0a37b860 | AVAV | 2026-09-10 10:00 | call_vertical_spread | 2 | 5 | 52 | 470372.00 | short | bid | 152.2500 | 9.4000 | ["110","120"] | ["0.6506","0.6542"] | ["116.99"] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 110.0000 | 120.0000 | 127 | 127 | true | false | |||||||||||
| 01a08b83-c789-7d60-a2db-bb207df98347 | AVAV | 2026-09-10 09:31 | put_vertical_spread | 2 | 1 | 10 | 105500.00 | short | bid | 146.7000 | 17.0000 | ["120","200"] | ["0.7382","0.6798"] | ["152.50"] | ["ARCO"] | 120.0000 | 200.0000 | 498 | 498 | false | false | |||||||||||
| 01a087c0-1868-75b1-aad9-32b82c5c0197 | AVAV | 2026-09-09 15:58 | call_butterfly_spread | 3 | 1 | 100 | 101650.00 | long | ask | 141.0000 | 1.9500 | ["140","160","180"] | ["1.1478","1.1732","1.2321"] | ["144.05","175.95"] | ["XPHO"] | 140.0000 | 180.0000 | 9 | 9 | false | false | |||||||||||
| 01a087a4-9188-7693-bb67-6517949da9f5 | AVAV | 2026-09-09 15:28 | call_vertical_spread | 2 | 1 | 70 | 198380.00 | long | ask | 140.4336 | 2.1000 | ["140","145"] | ["0.7573","0.7652"] | ["142"] | ["XMIO"] | 140.0000 | 145.0000 | 44 | 44 | false | false | |||||||||||
| 01a087a2-cc68-7b01-ba3a-e10d9d25a5d9 | AVAV | 2026-09-09 15:26 | call_vertical_spread | 2 | 1 | 85 | 141525.00 | unknown | — | 140.6700 | 2.7000 | ["155","160"] | ["0.7311","0.7307"] | [] | ["XBOX"] | 155.0000 | 160.0000 | 44 | 44 | false | true | false | true | |||||||||
| 01a0879f-cae0-7471-a7c9-8b266a369eff | AVAV | 2026-09-09 15:23 | other | 3 | 1 | 100 | 293350.00 | unknown | — | 140.5000 | 3.1000 | ["150","175","200"] | ["0.7394","0.7415","0.7512"] | [] | ["XISX"] | 150.0000 | 200.0000 | 128 | 128 | false | true | false | true | |||||||||
| 01a0877f-eea0-7160-9058-57616184342f | AVAV | 2026-09-09 14:48 | call_vertical_spread | 2 | 1 | 30 | 134610.00 | unknown | — | 141.3100 | 4.9000 | ["119","122"] | ["2.0870","2.0950"] | [] | ["BATO"] | 119.0000 | 122.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0822a-dd98-7972-8f2d-4dc45eadd86c | AVAV | 2026-09-08 13:57 | risk_reversal | 2 | 1 | 50 | 215300.00 | short | bid | 149.6350 | 3.5000 | ["125","140"] | ["0.7182","0.7290"] | ["158.72"] | ["XMIO"] | 125.0000 | 140.0000 | 129 | 129 | false | false | |||||||||||
| 01a08206-0bd0-7440-b6c5-3b78d41fcb7a | AVAV | 2026-09-08 13:17 | put_vertical_spread | 2 | 2 | 113 | 160008.00 | unknown | — | 150.2500 | 2.5000 | ["142","150"] | ["1.6637","1.6700"] | [] | ["XCBO","XISX"] | 142.0000 | 150.0000 | 3 | 3 | false | true | false | true | |||||||||
| 01a081ba-1e50-7e23-bc65-3f6f36cf48e8 | AVAV | 2026-09-08 11:54 | put_vertical_spread | 2 | 4 | 167 | 246325.00 | long | ask | 149.8700 | 1.9000 | ["142","150"] | ["1.6879","1.7011"] | ["146.24"] | ["ARCO","XMIO"] | 142.0000 | 150.0000 | 3 | 3 | false | false | |||||||||||
| 01a081b3-f430-74b3-a6cd-16d4b5596959 | AVAV | 2026-09-08 11:47 | call_vertical_spread | 2 | 3 | 46 | 101218.00 | short | bid | 149.3800 | 1.9000 | ["150","170"] | ["0.7493","0.7645"] | ["156.73"] | ["ARCO","XCBO","XPHO"] | 150.0000 | 170.0000 | 38 | 38 | false | true | |||||||||||
| 01a081a3-46a8-77f1-9deb-a30550aef5a0 | AVAV | 2026-09-08 11:29 | put_vertical_spread | 2 | 2 | 180 | 256170.00 | long | ask | 150.2200 | 1.8528 | ["142","150"] | ["1.6650","1.6777"] | ["146.30"] | ["XISX"] | 142.0000 | 150.0000 | 3 | 3 | false | true | |||||||||||
| 01a06dd4-4745-7111-b2ab-18404e4357d4 | AVAV | 2026-09-04 15:10 | other | 3 | 1 | 18 | 131706.00 | unknown | — | 144.0900 | 6.6000 | ["90","130","160"] | ["0.7204","0.7076","0.7303"] | [] | ["EMLD"] | 90.0000 | 160.0000 | 196 | 504 | false | true | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:45:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:24:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:34:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:57:49Z"} |
| 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-17T14:08:13Z"} |
| 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-17T13:36:48Z"} |
| 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-15T18:20:03Z"} |
| 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-14T16:49:09Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:15:27Z"} |
| 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-11T14:31:23Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:00:03Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:02:15Z"} |
| 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-10T14:46:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:24:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:02:59Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:01:56Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:00:33Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:00:33Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:00:33Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:31:08Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:58:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:28:32Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:26:27Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:23:39Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:48:48Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:57:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:17:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:54:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:47:28Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:29:25Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:10:24Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |