core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a0f8c1-38bf-7090-9035-6bedb5677139 | GOOGL | 2026-10-01 14:36 | risk_reversal | 3 | 1 | 10 | 175060.00 | long | ask | 338.8500 | 4.3500 | ["330","540"] | ["0.3758","0.3573"] | ["339.50"] | ["XCBO"] | 330.0000 | 540.0000 | 806 | 806 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T18:37:15Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f8a8-1b0f-7a52-bd2a-f1d164e3f527 | GOOGL | 2026-10-01 14:09 | risk_reversal | 2 | 4 | 76 | 171836.00 | short | bid | 339.1800 | 0.4908 | ["300","400"] | ["0.3551","0.3471"] | ["400.33"] | ["MCRY","XPHO"] | 300.0000 | 400.0000 | 141 | 141 | false | true | false | ||||||||||
| 01a0f8a7-a9c7-75b3-8fca-1aadf2519a33 | GOOGL | 2026-10-01 14:08 | risk_reversal | 2 | 2 | 202 | 455712.00 | short | bid | 339.1584 | 0.4500 | ["300","400"] | ["0.3560","0.3456"] | ["400.16"] | ["AMXO","EMLD"] | 300.0000 | 400.0000 | 141 | 141 | false | true | false | ||||||||||
| 01a0f8a5-34df-73e0-a11e-3748ce2050b6 | GOOGL | 2026-10-01 14:06 | risk_reversal | 2 | 2 | 20 | 110418.00 | long | bid | 339.2700 | 0.7500 | ["340","470"] | ["0.3574","0.3518"] | ["315.90"] | ["ARCO","EDGO"] | 340.0000 | 470.0000 | 351 | 351 | false | false | false | ||||||||||
| 01a0f8a5-30f7-7322-91e8-da77b08c9767 | GOOGL | 2026-10-01 14:06 | risk_reversal | 2 | 6 | 20 | 110206.00 | long | bid | 339.2700 | 0.5375 | ["340","470"] | ["0.3566","0.3518"] | ["315.99"] | ["AMXO","ARCO","MCRY","XBOX","XISX","XPHO"] | 340.0000 | 470.0000 | 351 | 351 | false | false | false | ||||||||||
| 01a0f837-adce-7281-8200-71e961e4a78a | GOOGL | 2026-10-01 12:06 | risk_reversal | 2 | 1 | 197 | 117609.00 | short | ask | 340.3300 | 0.2600 | ["327.5","357.5"] | ["0.3044","0.3068"] | ["327.07"] | ["XBOX"] | 327.5000 | 357.5000 | 15 | 15 | false | true | false | ||||||||||
| 01a0edce-a7b7-77d3-b3f0-cb7f1cea9976 | GOOGL | 2026-09-29 11:35 | risk_reversal | 2 | 3 | 31 | 185907.00 | short | bid | 339.2950 | 1.0500 | ["310","430"] | ["0.3634","0.3512"] | ["430.15"] | ["ARCO","EMLD","SPHR"] | 310.0000 | 430.0000 | 444 | 444 | false | true | false | ||||||||||
| 01a0cea5-219f-7cb1-83e4-c975b7cab68a | GOOGL | 2026-09-23 10:22 | risk_reversal | 2 | 1 | 20 | 116340.00 | short | bid | 340.5200 | 1.0000 | ["290","380"] | ["0.3615","0.3578"] | ["399.43"] | ["XCBO"] | 290.0000 | 380.0000 | 359 | 359 | false | true | false | ||||||||||
| 01a0ca13-7bee-7872-bedd-f47d68b05876 | GOOGL | 2026-09-22 13:04 | risk_reversal | 2 | 1 | 15 | 125640.00 | long | bid | 351.0201 | 2.4500 | ["330","460"] | ["0.3716","0.3577"] | ["329"] | ["XCBO"] | 330.0000 | 460.0000 | 633 | 633 | false | true | false | ||||||||||
| 01a0c9f6-89c7-74b1-aa49-13d714654ccb | GOOGL | 2026-09-22 12:32 | risk_reversal | 2 | 1 | 650 | 3841500.00 | long | bid | 350.5800 | 3.5000 | ["340","450"] | ["0.3484","0.3602"] | ["329.30"] | ["XBOX"] | 340.0000 | 450.0000 | 360 | 360 | false | true | false | ||||||||||
| 01a0b4c0-9a30-7913-a959-12406aa202c3 | GOOGL | 2026-09-18 09:41 | risk_reversal | 3 | 1 | 40 | 172600.00 | short | ask | 358.6600 | 7.7500 | ["350","370","385"] | ["0.3586","0.3525","0.3541"] | ["368.05"] | ["XISX"] | 350.0000 | 385.0000 | 42 | 42 | false | false | false | ||||||||||
| 01a0aaf6-d1fb-7ca3-8603-ade566bf1af4 | GOOGL | 2026-09-16 12:04 | risk_reversal | 2 | 1 | 400 | 748000.00 | long | ask | 345.6250 | 0.3500 | ["340","350"] | ["0.2925","0.2985"] | ["351.90"] | ["XBOX"] | 340.0000 | 350.0000 | 30 | 30 | false | true | false | ||||||||||
| 01a0a608-cb06-7712-81fc-165a6f55798b | GOOGL | 2026-09-15 13:06 | risk_reversal | 3 | 1 | 30 | 267750.00 | short | bid | 343.8500 | 2.0000 | ["200","330","460"] | ["0.3802","0.3683","0.3563"] | ["460.25"] | ["ARCO"] | 200.0000 | 460.0000 | 640 | 640 | false | true | false | ||||||||||
| 01a0a563-20de-7e60-b3cc-78e7a0fb1c3c | GOOGL | 2026-09-15 10:05 | risk_reversal | 2 | 1 | 100 | 685100.00 | long | ask | 345.2750 | 2.4500 | ["330","360"] | ["0.3468","0.3505"] | ["372.31"] | ["XBOX"] | 330.0000 | 360.0000 | 275 | 275 | false | true | false | ||||||||||
| 01a0a03a-3180-7073-b4a6-6257dbc24fcf | GOOGL | 2026-09-14 10:02 | risk_reversal | 3 | 1 | 10 | 135950.00 | short | bid | 345.6250 | 7.5000 | ["340","345"] | ["0.3478","0.3592"] | ["398.85"] | ["EDGO"] | 340.0000 | 345.0000 | 368 | 368 | false | false | false | ||||||||||
| 01a08ce4-5958-7c22-9e46-17b80fb8eca3 | GOOGL | 2026-09-10 15:56 | risk_reversal | 3 | 1 | 10 | 129080.00 | short | bid | 332.8000 | 7.7000 | ["325","330"] | ["0.3579","0.3550"] | ["383.32"] | ["XCBO"] | 325.0000 | 330.0000 | 372 | 372 | false | false | false | ||||||||||
| 01a08c68-7298-77b1-95e7-5273dfcd200c | GOOGL | 2026-09-10 13:40 | risk_reversal | 2 | 1 | 22 | 175560.00 | short | bid | 331.5850 | 1.1000 | ["295","480"] | ["0.3736","0.3658"] | ["482.60"] | ["C2OX"] | 295.0000 | 480.0000 | 827 | 827 | false | true | false | ||||||||||
| 01a08c68-6eb0-7940-b708-12dd75bb6588 | GOOGL | 2026-09-10 13:40 | risk_reversal | 2 | 1 | 22 | 175560.00 | short | bid | 331.5850 | 1.1000 | ["295","480"] | ["0.3736","0.3658"] | ["482.60"] | ["C2OX"] | 295.0000 | 480.0000 | 827 | 827 | false | true | false | ||||||||||
| 01a08157-12d8-7383-906d-cd60684ed271 | GOOGL | 2026-09-08 10:06 | risk_reversal | 2 | 1 | 20 | 112740.00 | short | bid | 333.8400 | 2.8000 | ["290","380"] | ["0.3539","0.3496"] | ["394.79"] | ["XCBO"] | 290.0000 | 380.0000 | 374 | 374 | false | true | false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:09:52Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:09:16Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:06:35Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T18:06:35Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T16:06:39Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T15:36:06Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:22:03Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:04:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:33:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:41:57Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:04:56Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:06:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:05:46Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:02:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:56:24Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:41:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:41:35Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:06:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |