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 |
|---|
| 01a0ca79-4686-72f0-b7cc-fedee0714b0c | CAT | 2026-09-22 14:55 | call_diagonal_spread | 2 | 1 | 13 | 137826.00 | long | ask | 805.7750 | 5.2500 | ["795","800"] | ["0.4084","0.3968"] | [] | ["XCBO"] | 795.0000 | 800.0000 | 38 | 59 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:56:28Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9be-0cd6-7c83-82bb-48d2d0773ddc | CAT | 2026-09-22 11:31 | call_diagonal_spread | 2 | 1 | 4 | 180000.00 | long | ask | 805.2150 | 32.0000 | ["760","780"] | ["0.3955","0.3970"] | [] | ["XMIO"] | 760.0000 | 780.0000 | 633 | 850 | false | false | true | ||||||||||
| 01a0c9ac-cadf-7863-9772-622120dd22d3 | CAT | 2026-09-22 11:12 | call_diagonal_spread | 2 | 1 | 5 | 254040.00 | long | ask | 806.8000 | 32.2000 | ["680","740"] | ["0.3936","0.3935"] | [] | ["XCBO"] | 680.0000 | 740.0000 | 633 | 850 | false | false | true | ||||||||||
| 01a0c4a8-e32f-7842-9196-f5730810a121 | CAT | 2026-09-21 11:49 | call_diagonal_spread | 2 | 1 | 3 | 106674.00 | long | ask | 818.8258 | 19.6000 | ["810","840"] | ["0.3872","0.3887"] | [] | ["XCBO"] | 810.0000 | 840.0000 | 487 | 634 | false | false | true | ||||||||||
| 01a0b549-4a60-7f11-be91-1b823a8942e5 | CAT | 2026-09-18 12:11 | call_diagonal_spread | 2 | 1 | 5 | 33075.00 | long | ask | 802.7200 | 6.6500 | ["800","810"] | ["0.3465","0.4060"] | [] | ["XISX"] | 800.0000 | 810.0000 | 14 | 42 | false | false | true | ||||||||||
| 01a0b511-4e58-7342-8585-2f31002b68e4 | CAT | 2026-09-18 11:10 | call_diagonal_spread | 2 | 1 | 16 | 49632.00 | unknown | ask | 801.2900 | 2.6500 | ["800","880"] | ["0.4878","0.4009"] | [] | ["XCBO"] | 800.0000 | 880.0000 | 0 | 63 | false | false | true | ||||||||||
| 01a0b4db-32c8-7da1-b9d8-eb6f130251de | CAT | 2026-09-18 10:10 | call_diagonal_spread | 2 | 1 | 2 | 175598.00 | long | ask | 807.2250 | 32.0000 | ["410","420"] | ["0.3633","0.3637"] | [] | ["XMIO"] | 410.0000 | 420.0000 | 637 | 854 | false | false | true | ||||||||||
| 01a0b055-c643-72a2-9f37-daddbcb2c945 | CAT | 2026-09-17 13:06 | call_diagonal_spread | 2 | 1 | 4 | 311360.00 | short | ask | 799.1000 | 19.2000 | ["440","450"] | ["0.3901","0.3971"] | [] | ["XISX"] | 440.0000 | 450.0000 | 456 | 491 | false | false | true | ||||||||||
| 01a0afc5-e63b-7710-9117-f3a7b944e13f | CAT | 2026-09-17 10:29 | call_diagonal_spread | 2 | 7 | 9 | 30018.00 | long | ask | 801.7400 | 2.0800 | ["810","820"] | ["0.3758","0.4861"] | [] | ["AMXO","EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 810.0000 | 820.0000 | 1 | 29 | false | true | true | ||||||||||
| 01a0afbf-79b4-7b23-bbb6-99007ccb9f29 | CAT | 2026-09-17 10:22 | call_diagonal_spread | 2 | 2 | 6 | 25419.00 | long | ask | 803.2400 | 4.0250 | ["800","810"] | ["0.5098","0.3771"] | [] | ["ARCO","C2OX"] | 800.0000 | 810.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0afbf-75cb-78f1-b948-6c488fb040a1 | CAT | 2026-09-17 10:22 | call_diagonal_spread | 2 | 2 | 30 | 126405.00 | long | ask | 803.2400 | 4.5500 | ["800","810"] | ["0.5032","0.3757"] | [] | ["AMXO","XPHO"] | 800.0000 | 810.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0afa7-03fb-7ce2-8f06-03b0154ef55e | CAT | 2026-09-17 09:55 | call_diagonal_spread | 2 | 1 | 14 | 312088.00 | long | ask | 803.4600 | 28.8000 | ["900","940"] | ["0.4117","0.4065"] | [] | ["XPHO"] | 900.0000 | 940.0000 | 365 | 456 | false | true | true | ||||||||||
| 01a0ab06-a4c3-7853-a6d4-909868c8d1d7 | CAT | 2026-09-16 12:22 | call_diagonal_spread | 2 | 1 | 7 | 131110.00 | long | ask | 790.6500 | 15.7000 | ["860","900"] | ["0.3946","0.3909"] | [] | ["XPHO"] | 860.0000 | 900.0000 | 274 | 366 | false | true | true | ||||||||||
| 01a0aaeb-eceb-7cd3-9780-6e5395ad08b6 | CAT | 2026-09-16 11:53 | call_diagonal_spread | 2 | 1 | 13 | 31447.00 | long | ask | 792.1000 | 4.8400 | ["825","920"] | ["0.3621","0.6464"] | [] | ["ARCO"] | 825.0000 | 920.0000 | 2 | 37 | false | true | true | ||||||||||
| 01a0aaeb-eceb-7cd3-9780-6e4bb398f7f1 | CAT | 2026-09-16 11:53 | call_diagonal_spread | 2 | 2 | 20 | 48400.00 | long | ask | 792.1000 | 3.6900 | ["825","920"] | ["0.3621","0.6626"] | [] | ["XBOX","XCBO"] | 825.0000 | 920.0000 | 2 | 37 | false | true | true | ||||||||||
| 01a0a5f8-a635-7030-bc08-d9f2610dbfee | CAT | 2026-09-15 12:48 | call_diagonal_spread | 2 | 1 | 6 | 30000.00 | long | ask | 782.0400 | 6.9000 | ["785","805"] | ["0.3561","0.3515"] | [] | ["SPHR"] | 785.0000 | 805.0000 | 17 | 38 | false | true | true | ||||||||||
| 01a0a5de-ec46-74a0-9aee-1c3d4a6c4b95 | CAT | 2026-09-15 12:20 | call_diagonal_spread | 2 | 1 | 3 | 82593.00 | long | ask | 779.6400 | 33.6000 | ["860","900"] | ["0.4087","0.3999"] | [] | ["XCBO"] | 860.0000 | 900.0000 | 493 | 640 | false | true | true | ||||||||||
| 01a0a56a-21d6-7512-8a93-c196cae311cb | CAT | 2026-09-15 10:13 | call_diagonal_spread | 2 | 1 | 2 | 75916.00 | short | ask | 783.2400 | 19.4500 | ["600","660"] | ["0.4431","0.4259"] | [] | ["XMIO"] | 600.0000 | 660.0000 | 157 | 185 | false | false | true | ||||||||||
| 01a0a169-fb08-79c1-b339-65a3f0ac1178 | CAT | 2026-09-14 15:34 | call_diagonal_spread | 2 | 1 | 2 | 70972.00 | long | ask | 785.2500 | 31.6500 | ["840","880"] | ["0.4142","0.3971"] | [] | ["XMIO"] | 840.0000 | 880.0000 | 641 | 858 | false | true | true | ||||||||||
| 01a0a124-f710-71a0-b922-88bb62850bf5 | CAT | 2026-09-14 14:19 | call_diagonal_spread | 2 | 1 | 5 | 98775.00 | long | ask | 787.2900 | 10.1000 | ["640","780"] | ["0.4120","0.4024"] | [] | ["XMIO"] | 640.0000 | 780.0000 | 4 | 158 | false | false | true | ||||||||||
| 01a08b97-c8a1-7682-8932-ac0021886d8d | CAT | 2026-09-10 09:52 | call_diagonal_spread | 2 | 1 | 4 | 32896.00 | short | ask | 801.0400 | 19.4500 | ["780","820"] | ["0.4144","0.4047"] | [] | ["MCRY"] | 780.0000 | 820.0000 | 22 | 43 | false | false | true | ||||||||||
| 01a0876d-02e0-7f32-8544-cdf8dd2dd359 | CAT | 2026-09-09 14:27 | call_diagonal_spread | 2 | 1 | 7 | 136843.00 | long | ask | 816.8350 | 9.9000 | ["900","960"] | ["0.4158","0.4143"] | [] | ["XMIO"] | 900.0000 | 960.0000 | 281 | 373 | false | true | true | ||||||||||
| 01a086a8-a940-7820-b25e-fc891e9e9d8f | CAT | 2026-09-09 10:53 | call_diagonal_spread | 2 | 1 | 7 | 31241.00 | long | ask | 819.7900 | 4.1500 | ["820","860"] | ["0.4007","0.3711"] | [] | ["MCRY"] | 820.0000 | 860.0000 | 9 | 37 | false | true | true | ||||||||||
| 01a0869e-be30-7383-8a0f-92c42a4978f5 | CAT | 2026-09-09 10:42 | call_diagonal_spread | 2 | 1 | 2 | 27800.00 | long | ask | 817.9300 | 11.7500 | ["820","860"] | ["0.4132","0.4036"] | [] | ["XCBO"] | 820.0000 | 860.0000 | 100 | 128 | false | true | true | ||||||||||
| 01a0868d-68b1-7e22-b921-7172021d1859 | CAT | 2026-09-09 10:23 | call_diagonal_spread | 2 | 1 | 7 | 28574.00 | long | ask | 814.9100 | 4.2500 | ["820","860"] | ["0.4013","0.3751"] | [] | ["ARCO"] | 820.0000 | 860.0000 | 9 | 37 | false | true | true | ||||||||||
| 01a08268-b1b9-7f72-9202-b9d5ae4943e1 | CAT | 2026-09-08 15:04 | call_diagonal_spread | 2 | 1 | 8 | 498976.00 | short | ask | 825.2950 | 25.6500 | ["410","700"] | ["0.4315","0.4211"] | [] | ["XPHO"] | 410.0000 | 700.0000 | 192 | 282 | false | false | true | ||||||||||
| 01a0822a-35a0-7ca3-bfd7-29fcc207f8a4 | CAT | 2026-09-08 13:56 | call_diagonal_spread | 2 | 1 | 2 | 28198.00 | long | ask | 827.8200 | 7.9000 | ["770","790"] | ["0.4121","0.3804"] | [] | ["AMXO"] | 770.0000 | 790.0000 | 10 | 73 | false | false | true | ||||||||||
| 01a081da-f879-71a1-99fb-db084ebd55de | CAT | 2026-09-08 12:30 | call_diagonal_spread | 2 | 1 | 6 | 37716.00 | short | ask | 826.4950 | 5.6000 | ["840","870"] | ["0.3756","0.3754"] | [] | ["XISX"] | 840.0000 | 870.0000 | 38 | 45 | false | true | true | ||||||||||
| 01a0813e-d3d0-70d2-b293-b23891a020c4 | CAT | 2026-09-08 09:39 | call_diagonal_spread | 2 | 1 | 4 | 74416.00 | short | ask | 827.7100 | 18.1500 | ["850","920"] | ["0.4011","0.4043"] | [] | ["XCBO"] | 850.0000 | 920.0000 | 192 | 282 | false | true | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:31:44Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:12:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:50:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:11:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:10:19Z"} |
| 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-18T14:11:06Z"} |
| 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-17T17:06:50Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:29:57Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:22:36Z"} |
| 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-17T14:22:36Z"} |
| 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-17T13:55:54Z"} |
| 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-16T16:22:44Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:53:12Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:53:12Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:48:59Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:21:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:13:18Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:34:48Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:19:14Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:52:54Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:27:54Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:53:52Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:42:33Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:23:34Z"} |
| 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-08T19:05:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:56:43Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:30:34Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:39:37Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |