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 |
|---|
| 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 | false | 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 |
| 01a0b4cf-2ca8-7030-a8d5-4d9984699b2d | AVAV | 2026-09-18 09:57 | call_vertical_spread | 2 | 1 | 54 | 101088.00 | long | ask | 163.6300 | 2.6000 | ["160","180"] | ["0.6141","0.6269"] | ["167.54"] | ["XCBO"] | 160.0000 | 180.0000 | 28 | 28 | false | 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 | true | ||||||||||
| 01a0b079-481b-77b3-8dfa-a608e61293e8 | AVAV | 2026-09-17 13:45 | call_diagonal_spread | 2 | 1 | 90 | 105660.00 | long | ask | 162.9000 | 2.5000 | ["165","190"] | ["0.6928","0.6547"] | [] | ["XCBO"] | 165.0000 | 190.0000 | 8 | 43 | 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 | true | ||||||||||
| 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 | true | ||||||||||
| 01a09136-9890-77a1-9b22-c67a68af640d | AVAV | 2026-09-11 12:04 | call_diagonal_spread | 2 | 1 | 145 | 150655.00 | long | bid | 141.7500 | 1.2000 | ["155","210"] | ["0.6014","0.7003"] | [] | ["XMIO"] | 155.0000 | 210.0000 | 35 | 98 | false | true | true | ||||||||||
| 01a08ca5-5488-74c0-9a40-a41f2397a06d | AVAV | 2026-09-10 14:47 | call_butterfly_spread | 3 | 1 | 40 | 120840.00 | long | ask | 149.9900 | 8.7000 | ["150","190","220"] | ["0.7195","0.7165","0.7194"] | ["157.50"] | ["XMIO"] | 150.0000 | 220.0000 | 127 | 127 | false | true | false | ||||||||||
| 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 | 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 | 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 | 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 | 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 | 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 | false | ||||||||||
| 01a087bf-4960-7791-a954-bd5626ac3316 | AVAV | 2026-09-09 15:57 | call_butterfly_spread | 3 | 1 | 100 | 102650.00 | long | ask | 141.4700 | 1.5500 | ["140","160","180"] | ["1.1282","1.1596","1.2303"] | ["144.13","175.87"] | ["XMIO"] | 140.0000 | 180.0000 | 9 | 9 | false | 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 | false | ||||||||||
| 01a081f2-1670-7731-9e5e-4132dc60703e | AVAV | 2026-09-08 12:55 | put_vertical_spread | 2 | 1 | 10 | 104300.00 | long | ask | 150.3000 | 4.8000 | ["120","200"] | ["0.7235","0.7389"] | ["149.32"] | ["XMIO"] | 120.0000 | 200.0000 | 500 | 500 | false | false | false | ||||||||||
| 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 | false | ||||||||||
| 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 | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:57:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| 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 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:45:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| 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 |
| 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 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:04:51Z"} |
| 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-10T18:47:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:57:55Z"} |
| 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-09T19:28:32Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:55:25Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |
| 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 |