core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0d98c-353f-7ac1-8994-166ccc215e48 | COIN | 2026-09-25 13:10 | call_diagonal_spread | 2 | 1 | 80 | 152000.00 | short | ask | 194.9950 | 1.2000 | ["182.5","195"] | ["1.2869","0.5970"] | [] | ["XISX"] | 182.5000 | 195.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T17:11:18Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d49a-6e2f-7e53-916c-517fe91aedc6 | COIN | 2026-09-24 14:08 | call_calendar | 2 | 1 | 40 | 150400.00 | short | ask | 197.5850 | 3.4000 | ["180"] | ["0.9729"] | [] | ["XMIO"] | 180.0000 | 180.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0d49a-6e2f-7e53-916c-516bb6a0df8b | COIN | 2026-09-24 14:08 | call_calendar | 2 | 3 | 31 | 117060.00 | short | ask | 197.6700 | 3.4000 | ["180"] | ["0.9691"] | [] | ["XISX"] | 180.0000 | 180.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0d498-9587-7382-b20c-db35a1ef7a5d | COIN | 2026-09-24 14:06 | call_calendar | 2 | 1 | 40 | 150000.00 | short | ask | 197.6250 | 5.4000 | ["180"] | ["0.9354"] | [] | ["XISX"] | 180.0000 | 180.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0d498-9587-7382-b20c-db21695ddddb | COIN | 2026-09-24 14:06 | call_calendar | 2 | 1 | 40 | 150000.00 | short | ask | 197.6250 | 5.4000 | ["180"] | ["0.9354"] | [] | ["XISX"] | 180.0000 | 180.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0d498-9587-7382-b20c-db1d5d90e7b2 | COIN | 2026-09-24 14:06 | call_calendar | 2 | 1 | 40 | 150000.00 | short | ask | 197.6250 | 5.4000 | ["180"] | ["0.9354"] | [] | ["XISX"] | 180.0000 | 180.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0c98c-90df-7923-b59e-1643b4a6b3d7 | COIN | 2026-09-22 10:37 | put_diagonal_spread | 2 | 1 | 5 | 349580.00 | short | ask | 198.0300 | 12.4000 | ["520","570"] | ["0.9230","0.9856"] | [] | ["XPHO"] | 520.0000 | 570.0000 | 486 | 633 | false | false | true | true | |||||||||
| 01a0c507-2417-7a31-b125-d68fc1b597dd | COIN | 2026-09-21 13:32 | call_diagonal_spread | 2 | 1 | 25 | 139725.00 | short | ask | 202.4400 | 2.9000 | ["175","177.5"] | ["0.8965","0.6511"] | [] | ["ARCO"] | 175.0000 | 177.5000 | 4 | 18 | false | false | true | true | |||||||||
| 01a0c42c-d55f-72b2-ade7-86916057caa4 | COIN | 2026-09-21 09:34 | call_diagonal_spread | 2 | 1 | 33 | 121638.00 | short | ask | 204.2200 | 2.2000 | ["220","250"] | ["0.7352","0.7088"] | [] | ["XISX"] | 220.0000 | 250.0000 | 60 | 116 | false | true | true | true | |||||||||
| 01a0c42a-aaaf-7820-b955-695fed18172e | COIN | 2026-09-21 09:32 | call_diagonal_spread | 2 | 1 | 30 | 140910.00 | short | ask | 207.3400 | 6.5500 | ["200","250"] | ["0.7245","0.6900"] | [] | ["XMIO"] | 200.0000 | 250.0000 | 39 | 151 | false | false | true | true | |||||||||
| 01a0b615-02b7-7771-887a-f15164ad4703 | COIN | 2026-09-18 15:53 | call_diagonal_spread | 2 | 3 | 7 | 101596.00 | short | ask | 193.7150 | 14.5500 | ["115","140"] | ["0.7676","0.7154"] | [] | ["ARCO","EMLD","SPHR"] | 115.0000 | 140.0000 | 91 | 119 | false | false | true | true | |||||||||
| 01a0b608-e13f-7910-8447-bf1b042e811d | COIN | 2026-09-18 15:40 | call_diagonal_spread | 2 | 1 | 10 | 141510.00 | short | ask | 194.5000 | 3.2500 | ["210","260"] | ["0.7285","0.7236"] | [] | ["XPHO"] | 210.0000 | 260.0000 | 637 | 819 | false | true | true | true | |||||||||
| 01a0b052-6ecb-7a63-bd56-d6eaa076099e | COIN | 2026-09-17 13:03 | put_calendar | 2 | 1 | 70 | 136500.00 | short | ask | 172.2300 | 0.7000 | ["180"] | ["0.7426"] | [] | ["XCBO"] | 180.0000 | 180.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0abb5-670b-7ba0-a85e-271a7448f39d | COIN | 2026-09-16 15:33 | put_calendar | 2 | 1 | 44 | 191400.00 | short | ask | 163.0600 | 5.3000 | ["180"] | ["0.7278"] | [] | ["XISX"] | 180.0000 | 180.0000 | 9 | 37 | false | false | true | false | |||||||||
| 01a0a6a5-b6e5-79c1-9e61-02e389b8bc5e | COIN | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 68 | 150824.00 | short | ask | 172.4200 | 0.9500 | ["160","185"] | ["0.8281","0.6681"] | [] | ["EDGO"] | 160.0000 | 185.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a6a4-ff4e-75d2-9ad9-288d622c42a8 | COIN | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 68 | 151300.00 | short | ask | 172.5300 | 0.8000 | ["160","185"] | ["0.8216","0.6658"] | [] | ["EDGO"] | 160.0000 | 185.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a56e-4086-7c40-a5df-82ead0484a87 | COIN | 2026-09-15 10:17 | put_calendar | 2 | 5 | 520 | 357890.00 | short | ask | 178.8800 | 0.5500 | ["150"] | ["0.6635"] | [] | ["ARCO","C2OX","EMLD","XISX","XPHO"] | 150.0000 | 150.0000 | 31 | 38 | false | true | true | false | |||||||||
| 01a091de-f238-77f0-919f-2a71ea5059d7 | COIN | 2026-09-11 15:08 | put_calendar | 2 | 1 | 2 | 138268.00 | short | ask | 174.6250 | 11.8000 | ["520"] | ["0.9408"] | [] | ["ARCO"] | 520.0000 | 520.0000 | 497 | 644 | false | false | true | false | |||||||||
| 01a08ce6-7850-7e81-9e2f-b522cc8afc3b | COIN | 2026-09-10 15:58 | put_calendar | 2 | 1 | 9 | 102474.00 | short | ask | 172.4300 | 7.9000 | ["230"] | ["0.9541"] | [] | ["XCBO"] | 230.0000 | 230.0000 | 8 | 22 | false | false | true | false | |||||||||
| 01a086f0-e189-7230-93b4-0cc664bcdbca | COIN | 2026-09-09 12:12 | risk_reversal | 2 | 1 | 400 | 490000.00 | short | ask | 178.0600 | 0.8500 | ["175","182.5"] | ["0.6947","0.7122"] | ["174.91"] | ["AMXO"] | 175.0000 | 182.5000 | 9 | 9 | false | true | false | true | |||||||||
| 01a06dd4-6a6d-7443-ad79-41b49b5763bc | COIN | 2026-09-04 15:10 | call_calendar | 2 | 1 | 25 | 175550.00 | short | ask | 185.0900 | 4.6500 | ["150"] | ["8.3909"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a06d3d-3765-7a80-9cf0-1cafadcac8f5 | COIN | 2026-09-04 12:25 | call_calendar | 2 | 1 | 34 | 245412.00 | short | ask | 185.5400 | 5.7500 | ["150"] | ["3.7419"] | [] | ["BATO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a06d3d-3765-7a80-9cf0-1c9b75aeef47 | COIN | 2026-09-04 12:25 | call_calendar | 2 | 1 | 16 | 115472.00 | short | ask | 185.5400 | 5.7500 | ["150"] | ["3.6796"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:08:34Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:08:34Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:06:30Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:06:30Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:06:30Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:37:19Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:32:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:34:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:32:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:53:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:40:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:03:45Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:33:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:57:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:57:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:18:04Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:08:38Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:58:34Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:12:37Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:11:00Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:25:47Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:25:47Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |