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 |
|---|
| 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 |
|---|
| 01a0ca82-1857-78f0-a3d3-8b20cdf4536e | AMZN | 2026-09-22 15:05 | put_vertical_spread | 2 | 1 | 22 | 72380.00 | unknown | ask | 255.1000 | 0.9500 | ["270","272.5"] | ["0.7428","0.8336"] | ["254.80"] | ["XBOX"] | 270.0000 | 272.5000 | 1 | 1 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:05:28Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c976-6517-7783-a144-87779565449d | AMZN | 2026-09-22 10:12 | put_vertical_spread | 2 | 1 | 109 | 51666.00 | short | bid | 257.0910 | 0.3100 | ["210","220"] | ["0.4078","0.3916"] | ["218.90"] | ["SPHR"] | 210.0000 | 220.0000 | 59 | 59 | false | true | false | ||||||||||
| 01a0c465-8130-79c1-b471-10561bf0a354 | AMZN | 2026-09-21 10:36 | call_vertical_spread | 2 | 1 | 100 | 77400.00 | short | bid | 255.7450 | 0.3800 | ["300","320"] | ["0.3517","0.3570"] | ["302.40"] | ["SPHR"] | 300.0000 | 320.0000 | 88 | 88 | false | true | false | ||||||||||
| 01a0c44a-dcdf-7661-a87f-c885154df490 | AMZN | 2026-09-21 10:07 | call_diagonal_spread | 2 | 1 | 124 | 61628.00 | long | ask | 256.1350 | 0.3400 | ["257.5","260"] | ["0.3324","0.2868"] | [] | ["SPHR"] | 257.5000 | 260.0000 | 2 | 9 | false | true | true | true | |||||||||
| 01a0c43c-69a7-7c72-b9c3-8b6eea28291f | AMZN | 2026-09-21 09:51 | call_diagonal_spread | 2 | 1 | 111 | 91686.00 | short | bid | 253.7500 | 0.6000 | ["250","252.5"] | ["0.5444","0.3310"] | [] | ["SPHR"] | 250.0000 | 252.5000 | 0 | 4 | false | false | true | true | |||||||||
| 01a0b4b8-9b4f-71d2-ac3b-ddd0252dcf6d | AMZN | 2026-09-18 09:33 | put_vertical_spread | 2 | 1 | 250 | 91500.00 | long | ask | 253.6150 | 0.2500 | ["245","250"] | ["0.3013","0.2975"] | ["248.64"] | ["SPHR"] | 245.0000 | 250.0000 | 7 | 7 | false | true | false | true | |||||||||
| 01a0afa3-3b3b-7ec3-a8fc-bc240d883a60 | AMZN | 2026-09-17 09:51 | put_diagonal_spread | 2 | 2 | 100 | 84000.00 | short | bid | 249.5800 | 0.4800 | ["205","210"] | ["0.3764","0.3952"] | [] | ["AMXO"] | 205.0000 | 210.0000 | 64 | 155 | false | true | true | true | |||||||||
| 01a0a05c-9a18-7fb3-86fb-2e0a66b7ec33 | AMZN | 2026-09-14 10:40 | other | 2 | 1 | 225 | 55500.00 | unknown | — | 251.7650 | 0.7500 | ["285","310"] | ["0.3885","0.3851"] | [] | ["XBOX"] | 285.0000 | 310.0000 | 46 | 46 | false | true | false | true | false | mlft | |||||||
| 01a0a02e-0068-7c30-afaa-168b3ece5c29 | AMZN | 2026-09-14 09:49 | call_diagonal_spread | 2 | 1 | 50 | 78150.00 | long | ask | 253.7850 | 0.3400 | ["255","265"] | ["0.4285","0.3609"] | [] | ["SPHR"] | 255.0000 | 265.0000 | 0 | 95 | false | true | true | true | |||||||||
| 01a09206-63e0-7651-88f7-75e7096478f6 | AMZN | 2026-09-11 15:51 | call_vertical_spread | 2 | 1 | 984 | 91512.00 | unknown | — | 257.0100 | 0.0700 | ["300","310"] | ["0.3068","0.3120"] | [] | ["XBOX"] | 300.0000 | 310.0000 | 35 | 35 | false | true | false | true | false | ||||||||
| 01a08ca0-c490-78b1-af21-1985f5a751bf | AMZN | 2026-09-10 14:42 | other | 2 | 1 | 5 | 37500.00 | unknown | — | 252.0150 | 2.6000 | ["290"] | ["1.2595"] | [] | ["XBOX"] | 290.0000 | 290.0000 | 1 | 8 | false | false | true | false | false | mlft | |||||||
| 01a086d4-54f1-7402-8f58-ef7e20d7947f | AMZN | 2026-09-09 11:40 | call_vertical_spread | 2 | 1 | 124 | 35712.00 | short | bid | 251.3850 | 0.0600 | ["252.5","257.5"] | ["0.3599","0.3623"] | ["253.98"] | ["SPHR"] | 252.5000 | 257.5000 | 2 | 2 | false | true | false | ||||||||||
| 01a08261-d3e8-78b3-a067-1f88d83fe92d | AMZN | 2026-09-08 14:57 | other | 2 | 1 | 330 | 96800.00 | unknown | — | 256.9700 | 0.1600 | ["265","295"] | ["0.3159","0.3215"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a0825c-3280-7052-856a-d72292e77da3 | AMZN | 2026-09-08 14:51 | other | 2 | 1 | 330 | 95260.00 | unknown | — | 256.7400 | 0.2000 | ["265","295"] | ["0.3178","0.3218"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a08257-e8d8-7790-a082-7c5ea104dc29 | AMZN | 2026-09-08 14:46 | other | 2 | 1 | 330 | 99220.00 | unknown | — | 257.1650 | 0.1600 | ["265","295"] | ["0.3154","0.3227"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a08250-cc88-7e60-9857-6dd579caee0a | AMZN | 2026-09-08 14:38 | other | 2 | 1 | 330 | 97460.00 | unknown | — | 257.0700 | 0.1100 | ["265","295"] | ["0.3132","0.3225"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a0824c-e870-7cb0-a37b-4d30c8246645 | AMZN | 2026-09-08 14:34 | other | 2 | 1 | 330 | 97680.00 | unknown | — | 257.1067 | 0.1600 | ["265","295"] | ["0.3139","0.3218"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a08242-2e58-7320-bdd5-5bdf80dd1dd2 | AMZN | 2026-09-08 14:22 | other | 2 | 1 | 330 | 96800.00 | unknown | — | 256.8250 | 0.1200 | ["265","295"] | ["0.3175","0.3233"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a0822d-f2a8-7d12-92e9-75f4a2c6f57f | AMZN | 2026-09-08 14:00 | other | 2 | 1 | 330 | 97900.00 | unknown | — | 257.0200 | 0.1100 | ["265","295"] | ["0.3163","0.3224"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a08220-8528-7853-8d0f-758c7bb36b5d | AMZN | 2026-09-08 13:46 | other | 2 | 1 | 330 | 95480.00 | unknown | — | 256.7550 | 0.1400 | ["265","295"] | ["0.3161","0.3230"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a08212-8720-7d62-a38d-eb883838cc36 | AMZN | 2026-09-08 13:30 | other | 2 | 1 | 330 | 96140.00 | unknown | — | 256.9700 | 0.1600 | ["265","295"] | ["0.3139","0.3215"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a08205-0619-7113-a55e-f0bd0958ac3c | AMZN | 2026-09-08 13:16 | other | 2 | 1 | 330 | 97680.00 | unknown | — | 257.2250 | 0.1800 | ["265","295"] | ["0.3135","0.3197"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | |||||||
| 01a081de-d0d8-7a01-9abe-293063c7e7f3 | AMZN | 2026-09-08 12:34 | put_vertical_spread | 2 | 1 | 50 | 30700.00 | short | bid | 257.0500 | 0.2300 | ["235","240"] | ["0.3245","0.3164"] | ["239.06"] | ["SPHR"] | 235.0000 | 240.0000 | 38 | 38 | false | true | false | ||||||||||
| 01a08199-24e9-7f90-8df6-a72309da5021 | AMZN | 2026-09-08 11:18 | other | 3 | 1 | 279 | 88449.00 | unknown | — | 256.8450 | 0.2400 | ["295","300","310"] | ["0.3811","0.3987","0.3736"] | [] | ["SPHR"] | 295.0000 | 310.0000 | 10 | 73 | false | true | true | true | false | mlft | |||||||
| 01a08136-a618-7693-b516-418bd84300dd | AMZN | 2026-09-08 09:30 | call_diagonal_spread | 2 | 1 | 50 | 53750.00 | long | ask | 255.5400 | 3.5000 | ["270","275"] | ["0.3331","0.3166"] | [] | ["SPHR"] | 270.0000 | 275.0000 | 38 | 45 | false | true | true | true |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:13:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:36:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:07:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:51:38Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:33:16Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:52:03Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:40:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:49:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:51:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:43:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:41:34Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:57:35Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:51:45Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:46:42Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:38:50Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:35:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:23:04Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:01:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:46:42Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:30:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:16:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:34:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:18:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:30:19Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |