core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d413-7766-7390-908d-25f84cbb7ed0 | GLD | 2026-09-24 11:40 | call_diagonal_spread | 2 | 1 | 30 | 116460.00 | short | bid | 389.8000 | 0.6500 | ["390","414"] | ["0.2196","0.2191"] | [] | ["BATO"] | 390.0000 | 414.0000 | 98 | 188 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T15:41:14Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cf5f-2a9f-7f42-9528-4ffc301d5854 | GLD | 2026-09-23 13:45 | call_diagonal_spread | 2 | 1 | 5000 | 1065000.00 | short | bid | 393.1263 | 0.0500 | ["440","450"] | ["0.2493","0.2422"] | [] | ["XISX"] | 440.0000 | 450.0000 | 23 | 58 | false | true | true | ||||||||||
| 01a0cf5d-59c7-7702-84df-acc3eefa3b4f | GLD | 2026-09-23 13:43 | call_diagonal_spread | 2 | 4 | 990 | 206910.00 | short | bid | 393.0000 | 0.0500 | ["440","450"] | ["0.2476","0.2420"] | [] | ["XISX"] | 440.0000 | 450.0000 | 23 | 58 | false | true | true | ||||||||||
| 01a0cf4e-bb96-74e1-8c20-58fee2db8777 | GLD | 2026-09-23 13:27 | call_diagonal_spread | 2 | 1 | 36 | 224424.00 | long | bid | 392.6490 | 0.6500 | ["370","390"] | ["0.2204","0.2208"] | [] | ["XISX"] | 370.0000 | 390.0000 | 114 | 149 | false | false | true | ||||||||||
| 01a0cf4e-5606-7e50-b62e-a87b8e47babc | GLD | 2026-09-23 13:26 | call_diagonal_spread | 2 | 1 | 29 | 180844.00 | long | bid | 392.6150 | 0.4000 | ["370","390"] | ["0.2212","0.2209"] | [] | ["XPHO"] | 370.0000 | 390.0000 | 114 | 149 | false | false | true | ||||||||||
| 01a0cf12-eb17-76e2-8eb7-7d9c55026351 | GLD | 2026-09-23 12:21 | call_diagonal_spread | 2 | 2 | 820 | 177120.00 | short | bid | 392.7600 | 0.0400 | ["440","450"] | ["0.2510","0.2447"] | [] | ["ARCO"] | 440.0000 | 450.0000 | 23 | 58 | false | true | true | ||||||||||
| 01a0c98a-b066-7971-a83a-e3f14b51639a | GLD | 2026-09-22 10:35 | call_diagonal_spread | 2 | 2 | 114 | 247154.00 | short | bid | 396.5250 | 0.6000 | ["396","398"] | ["0.2081","0.2160"] | [] | ["C2OX","XPHO"] | 396.0000 | 398.0000 | 31 | 38 | true | false | true | ||||||||||
| 01a0c96c-fed7-7f32-b75d-f492cacbc21e | GLD | 2026-09-22 10:02 | call_diagonal_spread | 2 | 2 | 42 | 119280.00 | short | bid | 397.2100 | 0.4500 | ["400","410"] | ["0.2281","0.2278"] | [] | ["AMXO","ARCO"] | 400.0000 | 410.0000 | 59 | 87 | false | true | true | ||||||||||
| 01a0c95d-acf7-7042-9fc5-e304fa7e419f | GLD | 2026-09-22 09:45 | call_diagonal_spread | 2 | 1 | 98 | 286160.00 | unknown | bid | 398.1350 | 0.3500 | ["400","410"] | ["0.2277","0.2270"] | [] | ["ARCO"] | 400.0000 | 410.0000 | 59 | 87 | false | true | true | ||||||||||
| 01a0c95d-acf7-7042-9fc5-e2e157f18195 | GLD | 2026-09-22 09:45 | call_diagonal_spread | 2 | 1 | 42 | 122640.00 | unknown | bid | 398.1300 | 0.3500 | ["400","410"] | ["0.2278","0.2270"] | [] | ["ARCO"] | 400.0000 | 410.0000 | 59 | 87 | false | true | true | ||||||||||
| 01a0c95d-a527-7a12-83a8-2fcc5ac9f2ef | GLD | 2026-09-22 09:45 | call_diagonal_spread | 2 | 3 | 47 | 136925.00 | unknown | bid | 398.1800 | 0.3500 | ["400","410"] | ["0.2269","0.2262"] | [] | ["AMXO","ARCO","EDGO"] | 400.0000 | 410.0000 | 59 | 87 | false | true | true | ||||||||||
| 01a0ab7e-2e53-77c3-9199-7e04f51094a3 | GLD | 2026-09-16 14:32 | call_diagonal_spread | 2 | 2 | 19 | 100776.00 | short | bid | 394.0800 | 2.7500 | ["373","374"] | ["0.2419","0.2441"] | [] | ["XMIO"] | 373.0000 | 374.0000 | 37 | 44 | false | false | true | ||||||||||
| 01a0a577-ae96-7ac3-9178-db74e24d54f1 | GLD | 2026-09-15 10:27 | call_diagonal_spread | 2 | 1 | 50 | 126900.00 | short | bid | 392.8000 | 0.8900 | ["370","400"] | ["0.2468","0.3473"] | [] | ["SPHR"] | 370.0000 | 400.0000 | 3 | 6 | false | false | true | ||||||||||
| 01a0a087-3458-7a43-910e-86393b45e9ed | GLD | 2026-09-14 11:26 | call_diagonal_spread | 2 | 1 | 23 | 162012.00 | long | bid | 392.4200 | 1.4000 | ["400","420"] | ["0.2440","0.2450"] | [] | ["XCBO"] | 400.0000 | 420.0000 | 276 | 368 | false | true | true | ||||||||||
| 01a0a06a-a3d8-7f02-b659-d937bb723375 | GLD | 2026-09-14 10:55 | call_diagonal_spread | 2 | 1 | 99 | 248292.00 | short | bid | 392.0250 | 0.6000 | ["450","525"] | ["0.2605","0.2646"] | [] | ["XCBO"] | 450.0000 | 525.0000 | 123 | 494 | false | true | true | ||||||||||
| 01a0a06a-a3d8-7f02-b659-d926455a2b9b | GLD | 2026-09-14 10:55 | call_diagonal_spread | 2 | 1 | 99 | 248292.00 | short | bid | 392.0250 | 0.6000 | ["450","525"] | ["0.2605","0.2646"] | [] | ["XCBO"] | 450.0000 | 525.0000 | 123 | 494 | false | true | true | ||||||||||
| 01a0a06a-9ff0-7040-84e2-6c84a46e2f6d | GLD | 2026-09-14 10:55 | call_diagonal_spread | 2 | 1 | 99 | 248292.00 | short | bid | 392.0250 | 0.6000 | ["450","525"] | ["0.2605","0.2646"] | [] | ["XCBO"] | 450.0000 | 525.0000 | 123 | 494 | false | true | true | ||||||||||
| 01a0a06a-9ff0-7040-84e2-6c71b4e18d15 | GLD | 2026-09-14 10:55 | call_diagonal_spread | 2 | 1 | 99 | 248292.00 | short | bid | 392.0250 | 0.6000 | ["450","525"] | ["0.2605","0.2646"] | [] | ["XCBO"] | 450.0000 | 525.0000 | 123 | 494 | false | true | true | ||||||||||
| 01a0912e-e3e8-7002-823e-0c24d11a2f8b | GLD | 2026-09-11 11:56 | call_diagonal_spread | 2 | 2 | 53 | 138434.00 | short | bid | 400.5181 | 0.7000 | ["450","550"] | ["0.2593","0.2680"] | [] | ["ARCO","XISX"] | 450.0000 | 550.0000 | 126 | 497 | false | true | true | ||||||||||
| 01a0912e-e3e8-7002-823e-0c17e9c34437 | GLD | 2026-09-11 11:56 | call_diagonal_spread | 2 | 3 | 80 | 209390.00 | short | bid | 400.5181 | 0.7000 | ["450","550"] | ["0.2597","0.2682"] | [] | ["ARCO","XCBO","XISX"] | 450.0000 | 550.0000 | 126 | 497 | false | true | true | ||||||||||
| 01a0912e-2c50-7370-a5c4-bbce1cc459be | GLD | 2026-09-11 11:55 | call_diagonal_spread | 2 | 7 | 40 | 105102.00 | short | bid | 400.5300 | 0.8125 | ["450","550"] | ["0.2604","0.2684"] | [] | ["ARCO","C2OX","EMLD","MCRY","SPHR","XBOX","XMIO"] | 450.0000 | 550.0000 | 126 | 497 | false | true | true | ||||||||||
| 01a0910c-7b50-74f1-8ede-37b87fb4e3d5 | GLD | 2026-09-11 11:18 | call_diagonal_spread | 2 | 3 | 66 | 225366.00 | short | bid | 400.1050 | 0.6000 | ["450","500"] | ["0.2608","0.2593"] | [] | ["AMXO","XCBO","XISX"] | 450.0000 | 500.0000 | 126 | 497 | false | true | true | ||||||||||
| 01a0910c-7768-7270-aa17-eb6d84f524dc | GLD | 2026-09-11 11:18 | call_diagonal_spread | 2 | 10 | 125 | 427896.00 | short | bid | 400.1050 | 1.1524 | ["450","500"] | ["0.2616","0.2594"] | [] | ["AMXO","ARCO","C2OX","EMLD","MCRY","SPHR","XBOX","XCBO","XISX","XMIO"] | 450.0000 | 500.0000 | 126 | 497 | false | true | |||||||||||
| 01a090f3-5da0-7050-9fab-cfa62015f471 | GLD | 2026-09-11 10:51 | call_diagonal_spread | 2 | 2 | 126 | 109620.00 | short | bid | 401.6550 | 0.1900 | ["440","450"] | ["0.2655","0.2868"] | [] | ["AMXO","ARCO"] | 440.0000 | 450.0000 | 35 | 70 | false | true | true | ||||||||||
| 01a08cb6-8eb0-7d61-bac6-2c5b5758bf87 | GLD | 2026-09-10 15:06 | call_diagonal_spread | 2 | 1 | 44 | 225368.00 | short | bid | 395.8700 | 2.7300 | ["390","417"] | ["0.2489","0.5525"] | [] | ["SPHR"] | 390.0000 | 417.0000 | 1 | 372 | false | false | true | ||||||||||
| 01a08cb4-0258-7072-877d-5e53cdc2644d | GLD | 2026-09-10 15:03 | call_diagonal_spread | 2 | 1 | 5 | 187385.00 | short | bid | 395.6300 | 6.6000 | ["215","220"] | ["0.6456","0.2434"] | [] | ["EMLD"] | 215.0000 | 220.0000 | 127 | 498 | false | false | true | ||||||||||
| 01a08c4c-7e58-76f1-8fef-e362ca62ba5d | GLD | 2026-09-10 13:10 | call_diagonal_spread | 2 | 1 | 15 | 115680.00 | short | bid | 399.9600 | 1.7000 | ["405","420"] | ["0.2498","0.2445"] | [] | ["SPHR"] | 405.0000 | 420.0000 | 280 | 372 | false | true | true | ||||||||||
| 01a08788-cc28-7781-906c-ed17a236a088 | GLD | 2026-09-09 14:58 | call_diagonal_spread | 2 | 1 | 9 | 172746.00 | long | bid | 403.6800 | 1.1000 | ["300","340"] | ["0.3168","0.2596"] | [] | ["BATO"] | 300.0000 | 340.0000 | 128 | 281 | false | false | true | ||||||||||
| 01a086b5-95d8-7b33-9a7e-ee216c4f38b9 | GLD | 2026-09-09 11:07 | call_diagonal_spread | 2 | 1 | 6 | 160536.00 | short | bid | 402.3300 | 2.3000 | ["270","275"] | ["1.2220","0.3223"] | [] | ["XPHO"] | 270.0000 | 275.0000 | 9 | 191 | false | false | true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:45:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:43:27Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:27:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:27:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:22:07Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:35:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:02:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:46:06Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:46:06Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:46:06Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:32:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:28:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:26:48Z"} |
| 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-14T14:55:57Z"} |
| 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-14T14:55:57Z"} |
| 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-14T14:55:57Z"} |
| 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-14T14:55:57Z"} |
| 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-11T15:56:30Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:56:30Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:55:16Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:18:47Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:18:47Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:51:11Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:06:38Z"} |
| 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-10T19:03:29Z"} |
| 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-10T17:10:39Z"} |
| 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-09T18:58:22Z"} |
| 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-09T15:07:49Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |