core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_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 |
|---|
| 01a0ca29-4226-7e10-ae29-718d7dd38548 | GOOG | 2026-09-22 13:28 | call_butterfly_spread | 3 | 1 | 100 | 37650.00 | long | ask | 348.3100 | 0.2000 | ["347.5","360","370"] | ["0.3699","0.3739","0.3987"] | ["350.75","369.25"] | ["XCBO"] | 347.5000 | 370.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:28:52Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9e6-a75f-7772-b818-717d4f56073d | GOOG | 2026-09-22 12:15 | call_butterfly_spread | 3 | 1 | 28 | 35588.00 | long | ask | 348.7700 | 0.6000 | ["400","410","420"] | ["0.3421","0.3434","0.3458"] | ["400.38","419.62"] | ["XCBO"] | 400.0000 | 420.0000 | 87 | 87 | false | true | false | ||||||||||
| 01a0c988-08b6-7cd3-b85d-68c811e99752 | GOOG | 2026-09-22 10:32 | call_butterfly_spread | 3 | 1 | 14 | 29652.00 | long | ask | 357.1000 | 1.3900 | ["380","480","580"] | ["0.3447","0.3489","0.3661"] | ["396.60","563.40"] | ["XCBO"] | 380.0000 | 580.0000 | 178 | 178 | false | true | false | ||||||||||
| 01a0c96a-2077-7700-889d-794c582a9fc5 | GOOG | 2026-09-22 09:59 | call_butterfly_spread | 3 | 1 | 42 | 84182.00 | short | bid | 356.2950 | 2.2500 | ["375","400","420"] | ["0.3422","0.3424","0.3454"] | ["375.01","412.50"] | ["XCBO"] | 375.0000 | 420.0000 | 87 | 87 | false | true | false | ||||||||||
| 01a0c580-20bf-7db1-834c-e591435135f5 | GOOG | 2026-09-21 15:45 | call_butterfly_spread | 3 | 1 | 20 | 30970.00 | long | ask | 351.9250 | 0.7500 | ["335","350","365"] | ["0.3672","0.3407","0.3459"] | ["341.57","358.43"] | ["XMIO"] | 335.0000 | 365.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a0b4d2-0337-7463-ae84-fa338bde1c1f | GOOG | 2026-09-18 10:00 | call_butterfly_spread | 3 | 1 | 160 | 85920.00 | long | ask | 350.5200 | 0.8300 | ["370","400","415"] | ["0.3045","0.3205","0.3343"] | ["373.86"] | ["XCBO"] | 370.0000 | 415.0000 | 35 | 35 | false | true | false | ||||||||||
| 01a0afcb-9b2b-7971-b8e4-80179026a591 | GOOG | 2026-09-17 10:35 | call_butterfly_spread | 3 | 1 | 40 | 84740.00 | unknown | — | 344.2000 | 1.7600 | ["350","390","430"] | ["0.3299","0.3292","0.3346"] | [] | ["XPHO"] | 350.0000 | 430.0000 | 92 | 92 | false | true | false | true | false | ||||||||
| 01a0a079-bf09-7de1-870e-48ecbb4ab3c6 | GOOG | 2026-09-14 11:12 | call_butterfly_spread | 3 | 1 | 100 | 222900.00 | unknown | — | 341.8900 | 1.0000 | ["360","400","420"] | ["0.3282","0.3276","0.3304"] | [] | ["XCBO"] | 360.0000 | 420.0000 | 123 | 123 | false | true | false | true | false | ||||||||
| 01a08ba9-9b20-7c40-ae67-8af8c34d4305 | GOOG | 2026-09-10 10:12 | call_butterfly_spread | 3 | 1 | 50 | 208450.00 | short | bid | 326.6400 | 2.8000 | ["400","490","580"] | ["0.3564","0.3594","0.3654"] | ["409.02","570.98"] | ["XCBO"] | 400.0000 | 580.0000 | 498 | 498 | false | true | false |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:15:43Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:32:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:59:34Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:45:09Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:01:08Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:36:12Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:12:17Z"} |
| 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-10T14:12:26Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |