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 |
|---|
| 01a0d482-8517-7120-969f-c5748679fd5e | IBIT | 2026-09-24 13:41 | call_diagonal_spread | 2 | 3 | 200 | 183570.00 | unknown | bid | 47.6900 | 0.2000 | ["50","55"] | ["0.4100","0.4262"] | [] | ["XBOX","XCBO","XMIO"] | 50.0000 | 55.0000 | 148 | 266 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T17:42:17Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cfb6-2c0f-7501-af9b-3160e190cb05 | IBIT | 2026-09-23 15:20 | call_diagonal_spread | 2 | 1 | 20 | 150060.00 | short | bid | 47.7450 | 1.7500 | ["10","15"] | ["0.7623","0.6926"] | [] | ["XPHO"] | 10.0000 | 15.0000 | 814 | 849 | false | false | true | ||||||||||
| 01a0cf39-7260-7111-9231-a731d0badaef | IBIT | 2026-09-23 13:04 | call_diagonal_spread | 2 | 1 | 27 | 224181.00 | short | bid | 47.4800 | 2.0250 | ["5","10"] | ["1.0423","0.8440"] | [] | ["XCBO"] | 5.0000 | 10.0000 | 814 | 849 | false | false | true | ||||||||||
| 01a0cf1a-9fbf-7a62-a427-c3cb7a8191b2 | IBIT | 2026-09-23 12:30 | call_diagonal_spread | 2 | 1 | 100 | 155900.00 | long | bid | 47.7250 | 0.2000 | ["40","40.5"] | ["0.4843","0.4427"] | [] | ["XCBO"] | 40.0000 | 40.5000 | 23 | 30 | false | false | true | ||||||||||
| 01a0cf0d-3627-76a3-a22c-e571694085b5 | IBIT | 2026-09-23 12:15 | call_diagonal_spread | 2 | 1 | 18 | 148518.00 | short | bid | 47.7301 | 2.2000 | ["5","10"] | ["0.7225","0.6975"] | [] | ["XCBO"] | 5.0000 | 10.0000 | 814 | 849 | false | false | true | ||||||||||
| 01a0cec8-68de-7f20-98fc-d7e075ff6876 | IBIT | 2026-09-23 11:00 | call_diagonal_spread | 2 | 1 | 20 | 166100.00 | short | bid | 47.8305 | 2.2500 | ["5","10"] | ["0.8745","0.7504"] | [] | ["XISX"] | 5.0000 | 10.0000 | 814 | 849 | false | false | true | ||||||||||
| 01a0cec4-afbf-7fc2-ae84-2573c03f3699 | IBIT | 2026-09-23 10:56 | call_diagonal_spread | 2 | 1 | 25 | 208375.00 | short | bid | 47.8250 | 1.6500 | ["5","10"] | ["0.9672","0.7929"] | [] | ["XISX"] | 5.0000 | 10.0000 | 814 | 849 | false | false | true | ||||||||||
| 01a0cebe-f2ff-7503-add3-0afdd36b9a77 | IBIT | 2026-09-23 10:50 | call_diagonal_spread | 2 | 1 | 20 | 134620.00 | short | bid | 47.7701 | 1.5500 | ["15","20"] | ["0.6750","0.6268"] | [] | ["XISX"] | 15.0000 | 20.0000 | 814 | 849 | false | false | true | ||||||||||
| 01a0caad-8d57-7053-8195-5dc8f07c4e0a | IBIT | 2026-09-22 15:52 | call_diagonal_spread | 2 | 1 | 200 | 352200.00 | short | bid | 48.8600 | 0.3000 | ["47","54"] | ["0.4359","0.4478"] | [] | ["XMIO"] | 47.0000 | 54.0000 | 268 | 451 | false | false | true | ||||||||||
| 01a0caab-a127-7552-8d35-88656777dc71 | IBIT | 2026-09-22 15:50 | call_diagonal_spread | 2 | 1 | 12 | 102912.00 | short | bid | 48.8821 | 2.5500 | ["5","10"] | ["1.0599","0.8250"] | [] | ["XCBO"] | 5.0000 | 10.0000 | 815 | 850 | false | false | true | ||||||||||
| 01a0caa4-4e27-75a1-a38c-bd6ae9e2b4b0 | IBIT | 2026-09-22 15:42 | call_diagonal_spread | 2 | 1 | 17 | 145996.00 | short | bid | 48.9359 | 2.5500 | ["5","10"] | ["1.0491","0.8342"] | [] | ["XISX"] | 5.0000 | 10.0000 | 815 | 850 | false | false | true | ||||||||||
| 01a0c57a-3cef-7171-95d1-0a1dcddb68cf | IBIT | 2026-09-21 15:38 | call_diagonal_spread | 2 | 1 | 230 | 120060.00 | short | bid | 49.0400 | 0.0600 | ["47","48"] | ["0.4116","0.4017"] | [] | ["XISX"] | 47.0000 | 48.0000 | 9 | 25 | false | false | true | ||||||||||
| 01a0c4e9-62e7-7bd1-b3ed-dfccdf758850 | IBIT | 2026-09-21 13:00 | call_diagonal_spread | 2 | 1 | 184 | 132112.00 | short | bid | 48.6900 | 0.1000 | ["45.5","55"] | ["0.5103","0.4272"] | [] | ["XCBO"] | 45.5000 | 55.0000 | 4 | 179 | false | false | true | ||||||||||
| 01a0c4a6-d7bf-78b3-8ae0-ea1216437617 | IBIT | 2026-09-21 11:47 | call_diagonal_spread | 2 | 2 | 117 | 158067.00 | unknown | bid | 48.8200 | 0.2100 | ["40","46"] | ["0.4399","0.4846"] | [] | ["AMXO"] | 40.0000 | 46.0000 | 4 | 116 | false | false | true | ||||||||||
| 01a0c495-dc17-7760-83f9-d1ab2585bf3e | IBIT | 2026-09-21 11:29 | call_diagonal_spread | 2 | 1 | 90 | 514800.00 | long | bid | 48.6450 | 0.5500 | ["20","21"] | ["0.8916","0.7175"] | [] | ["MCRY"] | 20.0000 | 21.0000 | 70 | 179 | false | false | true | ||||||||||
| 01a0c43b-3127-7ec2-a4b7-7e0d608136a2 | IBIT | 2026-09-21 09:50 | call_diagonal_spread | 2 | 3 | 203 | 101703.00 | unknown | bid | 48.3950 | 0.1200 | ["45","50"] | ["0.5327","0.4164"] | [] | ["MCRY","XPHO"] | 45.0000 | 50.0000 | 4 | 25 | false | false | true | ||||||||||
| 01a0c43b-2d3f-7561-b3e4-97a314aee7df | IBIT | 2026-09-21 09:50 | call_diagonal_spread | 2 | 2 | 201 | 100703.00 | unknown | bid | 48.3900 | 0.1100 | ["45","50"] | ["0.5382","0.4168"] | [] | ["XPHO"] | 45.0000 | 50.0000 | 4 | 25 | false | false | true | ||||||||||
| 01a0c43a-3ef6-7840-a22e-5af0908007dc | IBIT | 2026-09-21 09:49 | call_diagonal_spread | 2 | 1 | 200 | 453200.00 | unknown | bid | 48.3701 | 0.6500 | ["55","75"] | ["0.4977","0.4911"] | [] | ["XBOX"] | 55.0000 | 75.0000 | 816 | 851 | false | true | true | ||||||||||
| 01a0b5e9-4767-7e10-b02e-e1f3c85582de | IBIT | 2026-09-18 15:05 | call_diagonal_spread | 2 | 1 | 500 | 525000.00 | short | bid | 45.9050 | 0.1500 | ["41","45"] | ["6.3557","0.4041"] | [] | ["XCBO"] | 41.0000 | 45.0000 | 0 | 154 | false | false | true | ||||||||||
| 01a0b5e5-c110-7a91-84c3-2e5b247c6eb0 | IBIT | 2026-09-18 15:02 | call_diagonal_spread | 2 | 1 | 496 | 538656.00 | short | bid | 45.8680 | 0.2000 | ["41","43"] | ["4.9194","0.4006"] | [] | ["XMIO"] | 41.0000 | 43.0000 | 0 | 119 | false | false | true | ||||||||||
| 01a0b5e1-543f-77b2-97df-d37da9d41710 | IBIT | 2026-09-18 14:57 | call_diagonal_spread | 2 | 1 | 500 | 598000.00 | short | bid | 45.8301 | 0.2000 | ["40","42"] | ["6.7352","0.4093"] | [] | ["SPHR"] | 40.0000 | 42.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b5e1-11d7-7bc1-8bd2-a39e78efcd23 | IBIT | 2026-09-18 14:56 | call_diagonal_spread | 2 | 1 | 100 | 119400.00 | short | bid | 45.8451 | 0.2000 | ["40","42"] | ["5.7616","0.4066"] | [] | ["C2OX"] | 40.0000 | 42.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b5e1-0def-73b2-912d-36ec10e0a3c1 | IBIT | 2026-09-18 14:56 | call_diagonal_spread | 2 | 1 | 100 | 119400.00 | short | bid | 45.8451 | 0.2000 | ["40","42"] | ["5.7616","0.4066"] | [] | ["C2OX"] | 40.0000 | 42.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b5e1-0def-73b2-912d-36d4e514d958 | IBIT | 2026-09-18 14:56 | call_diagonal_spread | 2 | 1 | 100 | 119400.00 | short | bid | 45.8451 | 0.2000 | ["40","42"] | ["5.7616","0.4066"] | [] | ["C2OX"] | 40.0000 | 42.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b5e1-0def-73b2-912d-36cfd4cc2468 | IBIT | 2026-09-18 14:56 | call_diagonal_spread | 2 | 1 | 100 | 119600.00 | short | bid | 45.8500 | 0.2000 | ["40","42"] | ["6.0207","0.4075"] | [] | ["XPHO"] | 40.0000 | 42.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b5e1-0def-73b2-912d-36be0751be40 | IBIT | 2026-09-18 14:56 | call_diagonal_spread | 2 | 1 | 100 | 119200.00 | short | bid | 45.8500 | 0.2000 | ["40","42"] | ["7.0167","0.4049"] | [] | ["XISX"] | 40.0000 | 42.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b54d-0f37-7f30-b138-e6e4085acdf1 | IBIT | 2026-09-18 12:15 | call_diagonal_spread | 2 | 1 | 100 | 100600.00 | short | bid | 45.8432 | 0.2000 | ["43","46"] | ["0.3966","0.4036"] | [] | ["XMIO"] | 43.0000 | 46.0000 | 73 | 154 | false | false | true | ||||||||||
| 01a0b53f-bd0f-77a3-bf45-ff0d49ea76da | IBIT | 2026-09-18 12:00 | call_diagonal_spread | 2 | 2 | 590 | 207700.00 | unknown | bid | 45.7500 | 0.0500 | ["44","46"] | ["1.1773","0.3646"] | [] | ["AMXO","MCRY"] | 44.0000 | 46.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0b0e5-dcfb-7521-b50a-c20174ff4eaf | IBIT | 2026-09-17 15:44 | call_diagonal_spread | 2 | 2 | 46 | 130180.00 | short | bid | 43.3250 | 0.4500 | ["38","40"] | ["0.4655","0.5140"] | [] | ["C2OX","EDGO"] | 38.0000 | 40.0000 | 456 | 820 | false | false | true | ||||||||||
| 01a0a57f-9dd6-7182-8814-8fbf65d37f37 | IBIT | 2026-09-15 10:36 | call_diagonal_spread | 2 | 1 | 204 | 756840.00 | short | bid | 42.9999 | 0.7500 | ["30","35"] | ["0.5544","0.5138"] | [] | ["EDGO"] | 30.0000 | 35.0000 | 640 | 822 | false | false | true | ||||||||||
| 01a090e2-bfb8-7370-8d1a-f94b1a827a3e | IBIT | 2026-09-11 10:32 | call_diagonal_spread | 2 | 1 | 1068 | 449628.00 | long | bid | 44.7300 | 0.0800 | ["42","50"] | ["1.4815","0.4145"] | [] | ["XCBO"] | 42.0000 | 50.0000 | 0 | 70 | false | false | true | ||||||||||
| 01a08ca6-17d8-7b60-81cd-61108276657a | IBIT | 2026-09-10 14:48 | call_diagonal_spread | 2 | 1 | 1000 | 314000.00 | short | bid | 43.6200 | 0.0700 | ["49","53"] | ["0.3956","0.4233"] | [] | ["XPHO"] | 49.0000 | 53.0000 | 36 | 190 | false | true | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:20:36Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:04:15Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:30:40Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:15:46Z"} |
| 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-23T15:00:52Z"} |
| 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-23T14:56:38Z"} |
| 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-23T14:50:18Z"} |
| 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-22T19:52:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:51: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-22T19:42:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:38:46Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:00:58Z"} |
| 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-21T15:47:45Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:29:43Z"} |
| 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-21T13:50:15Z"} |
| 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-21T13:50:15Z"} |
| 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-21T13:49:13Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:06:15Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:02:24Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:57:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:57:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:57:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:57:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:57:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:57:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:15:44Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:01:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:44:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:36:43Z"} |
| 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-11T14:33:01Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:48:30Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |