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 |
|---|
| 01a0ca64-9d77-7fe3-b42e-3fd012f8a590 | IBIT | 2026-09-22 14:33 | call_diagonal_spread | 2 | 1 | 15 | 115650.00 | long | ask | 48.8700 | 2.0000 | ["10","15"] | ["0.7451","0.6802"] | [] | ["XCBO"] | 10.0000 | 15.0000 | 815 | 850 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:33:49Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca33-8af7-7a73-9b2f-42bf4f67d9ac | IBIT | 2026-09-22 13:39 | call_vertical_spread | 2 | 1 | 450 | 179550.00 | long | ask | 49.0100 | 0.0400 | ["46.5","48"] | ["0.4825","0.4132"] | ["47.79"] | ["XPHO"] | 46.5000 | 48.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9e5-d857-74f1-a212-accc141e7a92 | IBIT | 2026-09-22 12:14 | put_vertical_spread | 2 | 1 | 81 | 146043.00 | long | ask | 48.7950 | 0.3500 | ["45","55"] | ["0.4581","0.4578"] | ["49.61"] | ["XCBO"] | 45.0000 | 55.0000 | 451 | 451 | false | false | false | true | |||||||||
| 01a0c98f-9a38-7d12-be72-71151fa2d299 | IBIT | 2026-09-22 10:40 | call_vertical_spread | 2 | 1 | 681 | 431754.00 | long | ask | 48.5950 | 0.1300 | ["45","48.5"] | ["0.3962","0.3888"] | ["47.26"] | ["XCBO"] | 45.0000 | 48.5000 | 24 | 24 | false | false | false | true | |||||||||
| 01a0c94f-5c57-7c30-a316-397665c2cfd8 | IBIT | 2026-09-22 09:30 | call_vertical_spread | 2 | 1 | 426 | 355710.00 | long | ask | 48.5500 | 0.2800 | ["46","52"] | ["0.4236","0.4208"] | ["48.77"] | ["XCBO"] | 46.0000 | 52.0000 | 87 | 87 | false | false | false | true | |||||||||
| 01a0c94f-5c57-7c30-a316-395d46b3351e | IBIT | 2026-09-22 09:30 | call_vertical_spread | 2 | 1 | 120 | 189600.00 | long | ask | 48.5400 | 1.1000 | ["80","85"] | ["0.4953","0.4942"] | ["80.82"] | ["XCBO"] | 80.0000 | 85.0000 | 850 | 850 | false | true | false | true | |||||||||
| 01a0c4fa-e35f-7f42-b977-dd489ef4667c | IBIT | 2026-09-21 13:19 | call_vertical_spread | 2 | 1 | 1450 | 356700.00 | long | ask | 48.6100 | 0.0300 | ["54","58"] | ["0.4290","0.4439"] | ["54.70"] | ["XBOX"] | 54.0000 | 58.0000 | 60 | 60 | false | true | false | true | |||||||||
| 01a0c4f4-47f7-7760-bad6-cb048c54511d | IBIT | 2026-09-21 13:12 | call_vertical_spread | 2 | 1 | 15000 | 4635000.00 | long | ask | 48.7500 | 0.0300 | ["48","54"] | ["0.4046","0.4258"] | ["49.93"] | ["XPHO"] | 48.0000 | 54.0000 | 25 | 25 | false | 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 | true | |||||||||
| 01a0c481-2f1f-7f02-ad36-3221757c7142 | IBIT | 2026-09-21 11:06 | call_vertical_spread | 2 | 1 | 73 | 212211.00 | long | ask | 48.7400 | 0.9500 | ["54","55"] | ["0.5023","0.5017"] | ["54.33"] | ["XCBO"] | 54.0000 | 55.0000 | 851 | 851 | false | true | false | true | |||||||||
| 01a0c480-d92f-7140-856d-798c27a190a2 | IBIT | 2026-09-21 11:06 | call_vertical_spread | 2 | 1 | 100 | 290700.00 | long | ask | 48.7400 | 0.9500 | ["54","55"] | ["0.5023","0.5017"] | ["54.33"] | ["XCBO"] | 54.0000 | 55.0000 | 851 | 851 | false | true | false | true | |||||||||
| 01a0c480-ae37-78c1-8d7b-c81d0f622443 | IBIT | 2026-09-21 11:05 | call_vertical_spread | 2 | 1 | 100 | 290700.00 | long | ask | 48.7450 | 0.9500 | ["54","55"] | ["0.5021","0.5015"] | ["54.33"] | ["XCBO"] | 54.0000 | 55.0000 | 851 | 851 | true | true | false | true | |||||||||
| 01a0c43e-78ff-7890-bc37-e1ca349ac7a3 | IBIT | 2026-09-21 09:53 | call_vertical_spread | 2 | 1 | 4974 | 1422564.00 | long | ask | 48.4601 | 0.0200 | ["49","52"] | ["0.4169","0.4284"] | ["49.98"] | ["XPHO"] | 49.0000 | 52.0000 | 25 | 25 | false | true | false | true | |||||||||
| 01a0c43a-db37-79d1-b894-adc54eb6e1f3 | IBIT | 2026-09-21 09:49 | call_vertical_spread | 2 | 1 | 197 | 128444.00 | long | ask | 48.3400 | 0.1900 | ["47","64"] | ["0.4214","0.4416"] | ["51.54"] | ["EDGO"] | 47.0000 | 64.0000 | 116 | 116 | false | false | false | true | |||||||||
| 01a0b609-854f-7650-8cbd-f904ecd13ec2 | IBIT | 2026-09-18 15:41 | call_calendar | 2 | 1 | 80 | 120240.00 | long | ask | 45.9970 | 0.3500 | ["38.5"] | ["5.7501"] | [] | ["XCBO"] | 38.5000 | 38.5000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0b5c0-a50f-7a62-a6a4-105fd67eb6dc | IBIT | 2026-09-18 14:21 | call_calendar | 2 | 1 | 60 | 197040.00 | long | ask | 45.8200 | 0.3000 | ["30"] | ["0.5778"] | [] | ["MCRY"] | 30.0000 | 30.0000 | 63 | 119 | false | false | true | false | |||||||||
| 01a0b52a-21cf-7aa1-bef0-7fdba0d572f8 | IBIT | 2026-09-18 11:37 | call_vertical_spread | 2 | 1 | 50 | 105650.00 | long | ask | 45.7750 | 0.2500 | ["34","38"] | ["0.4930","0.4330"] | ["37.63"] | ["XMIO"] | 34.0000 | 38.0000 | 73 | 73 | false | false | false | true | |||||||||
| 01a0b51d-d560-7cc1-b81e-dacd8f8b826a | IBIT | 2026-09-18 11:23 | call_vertical_spread | 2 | 1 | 4000 | 400000.00 | long | ask | 45.8950 | 0.0300 | ["46.5","48"] | ["0.3715","0.3975"] | ["46.88"] | ["XPHO"] | 46.5000 | 48.0000 | 7 | 7 | false | true | false | true | |||||||||
| 01a0b040-c35b-7883-a4c2-8c5b0183b08b | IBIT | 2026-09-17 12:43 | risk_reversal | 2 | 1 | 1791 | 111042.00 | long | bid | 43.3695 | 0.0200 | ["42","45"] | ["0.3346","0.3355"] | ["41.98"] | ["XCBO"] | 42.0000 | 45.0000 | 8 | 8 | false | true | false | true | |||||||||
| 01a0afd5-7e6b-7113-8931-79d1d854dd1e | IBIT | 2026-09-17 10:46 | call_calendar | 2 | 1 | 120 | 108720.00 | long | ask | 43.3800 | 0.2000 | ["40"] | ["0.4403"] | [] | ["XCBO"] | 40.0000 | 40.0000 | 4 | 92 | false | false | true | false | |||||||||
| 01a0a105-8448-7d02-a433-c86039f853d4 | IBIT | 2026-09-14 13:44 | call_diagonal_spread | 2 | 1 | 365 | 326310.00 | long | ask | 44.6401 | 0.2200 | ["42","43"] | ["0.4148","0.3863"] | [] | ["XMIO"] | 42.0000 | 43.0000 | 32 | 123 | false | false | true | true | |||||||||
| 01a0a085-1d30-76c3-82d1-040fc4f69700 | IBIT | 2026-09-14 11:24 | call_vertical_spread | 2 | 1 | 1400 | 417200.00 | long | ask | 44.4200 | 0.1800 | ["90","140"] | ["0.4890","0.5399"] | ["91.40"] | ["XCBO"] | 90.0000 | 140.0000 | 494 | 494 | false | true | 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 | true | |||||||||
| 01a08bff-0268-73c2-907c-c36a41625d2c | IBIT | 2026-09-10 11:45 | call_diagonal_spread | 2 | 1 | 1000 | 258610.00 | long | ask | 43.7100 | 0.0400 | ["44","45"] | ["0.3970","0.3957"] | [] | ["XCBO"] | 44.0000 | 45.0000 | 8 | 36 | false | true | true | true | |||||||||
| 01a08677-8b08-7b62-bb68-be7cd3669dae | IBIT | 2026-09-09 09:59 | put_vertical_spread | 2 | 1 | 828 | 105156.00 | long | ask | 44.7700 | 0.0200 | ["35","42"] | ["0.5283","0.4074"] | ["41.13"] | ["EDGO"] | 35.0000 | 42.0000 | 37 | 37 | false | true | false | true | |||||||||
| 01a0816a-4100-7a83-9057-e5031876fff2 | IBIT | 2026-09-08 10:26 | synthetic | 2 | 1 | 1500 | 1327500.00 | long | ask | 44.2920 | 0.2000 | ["45"] | ["0.4217"] | ["45.01"] | ["XMIO"] | 45.0000 | 45.0000 | 129 | 129 | false | false | false | false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:39:53Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:14:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:40:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:30:12Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:30:12Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:19:42Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:12:43Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:07:01Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:06:31Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:06:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:53:58Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:49:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:41:32Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:21:39Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:37:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:23:50Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:44:00Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:46:53Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:45:16Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:24:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:46:14Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:59:36Z"} |
| 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-08T14:27:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |