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 | 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 |
|---|
| 01a0ca6f-a996-7b83-bde1-2df0a81c6621 | IBIT | 2026-09-22 14:45 | call_vertical_spread | 2 | 1 | 9297 | 1199313.00 | unknown | ask | 48.9400 | 0.0200 | ["50","52"] | ["0.4084","0.4283"] | ["51.29"] | ["AMXO"] | 50.0000 | 52.0000 | 10 | 10 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:45:12Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9d5-f207-7491-a4f6-d2a5612d31f9 | IBIT | 2026-09-22 11:57 | call_vertical_spread | 2 | 4 | 546 | 155932.00 | unknown | ask | 48.9650 | 0.0754 | ["75","90"] | ["0.4525","0.4847"] | ["77.86"] | ["ARCO","EMLD","SPHR","XPHO"] | 75.0000 | 90.0000 | 268 | 268 | false | true | false | ||||||||||
| 01a0c996-c23f-7b13-a7fa-73ed23a04e65 | IBIT | 2026-09-22 10:48 | call_vertical_spread | 2 | 3 | 248 | 160244.00 | unknown | ask | 48.6800 | 0.0700 | ["45","48.5"] | ["0.3984","0.3887"] | ["49.98"] | ["ARCO","EMLD","XPHO"] | 45.0000 | 48.5000 | 24 | 24 | false | false | false | ||||||||||
| 01a0c98e-80f9-79a3-ad41-200d780d033a | IBIT | 2026-09-22 10:39 | other | 4 | 8 | 173 | 111991.00 | unknown | ask | 48.6050 | 0.1806 | ["45","48.5","55","80"] | ["0.4051","0.3936","0.4151","0.5110"] | [] | ["AMXO","ARCO","EMLD","MCRY","XISX","XMIO","XPHO"] | 45.0000 | 80.0000 | 24 | 115 | false | false | true | ||||||||||
| 01a0c983-6d07-7411-a056-1fa9021e95f6 | IBIT | 2026-09-22 10:27 | call_ratio_spread | 2 | 1 | 1716 | 436020.00 | unknown | ask | 48.7150 | 0.0400 | ["59","64"] | ["0.4262","0.4376"] | ["59.56","108.35"] | ["XBOX"] | 59.0000 | 64.0000 | 115 | 115 | false | true | false | ||||||||||
| 01a0c4e9-b107-7ce1-b7ce-b9f63ab48ed6 | IBIT | 2026-09-21 13:00 | call_diagonal_spread | 2 | 1 | 150 | 168900.00 | unknown | ask | 48.7150 | 0.1600 | ["50","57"] | ["0.4619","0.4519"] | [] | ["XMIO"] | 50.0000 | 57.0000 | 25 | 487 | false | true | true | true | |||||||||
| 01a0c4b2-39cf-7082-a816-95ecf861e80c | IBIT | 2026-09-21 12:00 | other | 4 | 1 | 9297 | 1199313.00 | unknown | ask | 48.6950 | 0.0400 | ["41.5","43","45.5","47.5"] | ["0.7184","0.6479","0.4363","0.4263"] | [] | ["XPHO"] | 41.5000 | 47.5000 | 4 | 11 | false | true | true | true | |||||||||
| 01a0c483-7527-7882-ab8a-1e99f828289f | IBIT | 2026-09-21 11:09 | other | 4 | 2 | 103 | 152911.00 | unknown | ask | 48.8700 | 0.3100 | ["45","46","51","61"] | ["0.4330","0.4253","0.5388","0.4580"] | [] | ["XMIO"] | 45.0000 | 61.0000 | 4 | 487 | false | false | true | true | |||||||||
| 01a0c45a-7127-70b0-9523-1c645571ca9e | IBIT | 2026-09-21 10:24 | other | 2 | 1 | 72 | 133992.00 | unknown | ask | 48.5450 | 0.4000 | ["44","46"] | ["0.5201","0.4411"] | [] | ["XISX"] | 44.0000 | 46.0000 | 269 | 851 | false | false | true | true | |||||||||
| 01a0c44a-0dd7-7053-b7b3-ee36431ea774 | IBIT | 2026-09-21 10:06 | call_diagonal_spread | 2 | 2 | 271 | 176692.00 | unknown | ask | 48.1800 | 0.1380 | ["45","48.5"] | ["0.4095","0.3999"] | [] | ["XISX","XMIO"] | 45.0000 | 48.5000 | 25 | 39 | false | false | true | ||||||||||
| 01a0c442-39ef-7541-a96c-b0e20f70cccb | IBIT | 2026-09-21 09:57 | call_calendar | 2 | 1 | 179 | 495114.00 | unknown | ask | 48.4650 | 0.3000 | ["35"] | ["0.6324"] | [] | ["XMIO"] | 35.0000 | 35.0000 | 25 | 60 | false | false | true | false | |||||||||
| 01a0c43a-df20-70e3-8477-8598cf8e2f03 | IBIT | 2026-09-21 09:49 | other | 4 | 2 | 150 | 127680.00 | unknown | ask | 48.3700 | 0.2700 | ["40","50","55","65"] | ["0.4370","0.4182","0.4205","0.4436"] | ["43.45","61.55"] | ["AMXO","ARCO"] | 40.0000 | 65.0000 | 116 | 116 | false | false | false | ||||||||||
| 01a0c438-9cff-7802-a4fd-3c3414f6391e | IBIT | 2026-09-21 09:47 | call_vertical_spread | 2 | 1 | 175 | 175525.00 | unknown | ask | 48.3600 | 0.2100 | ["41","48"] | ["0.4712","0.4154"] | ["49.52"] | ["XISX"] | 41.0000 | 48.0000 | 25 | 25 | false | false | false | ||||||||||
| 01a0b615-ba4f-7b32-8c37-4b16bc743ec3 | IBIT | 2026-09-18 15:54 | iron_condor | 4 | 1 | 170 | 168300.00 | unknown | ask | 45.9950 | 0.2500 | ["40","50","55","65"] | ["0.4139","0.4017","0.4031","0.4301"] | ["47.48"] | ["MCRY"] | 40.0000 | 65.0000 | 119 | 119 | false | false | false | ||||||||||
| 01a0b60d-e27f-72b3-af01-bab1f1c7289a | IBIT | 2026-09-18 15:45 | call_diagonal_spread | 2 | 2 | 1703 | 127725.00 | unknown | ask | 45.9901 | 0.0300 | ["46","50"] | ["1.1039","0.3815"] | [] | ["AMXO"] | 46.0000 | 50.0000 | 0 | 28 | false | true | true | true | |||||||||
| 01a0b5ab-7b17-7f80-af9b-ec1a3c5069aa | IBIT | 2026-09-18 13:58 | iron_condor | 4 | 1 | 500 | 109500.00 | unknown | ask | 45.8750 | 0.0500 | ["43","44.5","46.5","48"] | ["0.3722","0.3512","0.3507","0.3574"] | ["46.65"] | ["EDGO"] | 43.0000 | 48.0000 | 12 | 12 | false | true | false | ||||||||||
| 01a0b548-f857-7ac1-b17f-73e659f82054 | IBIT | 2026-09-18 12:10 | call_vertical_spread | 2 | 1 | 2000 | 228000.00 | unknown | ask | 45.7700 | 0.0300 | ["46","47.5"] | ["0.3529","0.3721"] | ["47.14"] | ["XPHO"] | 46.0000 | 47.5000 | 7 | 7 | false | true | false | ||||||||||
| 01a0b4f7-e287-7cd0-a829-ed74a24f4bda | IBIT | 2026-09-18 10:42 | other | 4 | 1 | 226 | 106220.00 | unknown | ask | 45.7599 | 0.1300 | ["43.5","44.5","46","48"] | ["1.0212","0.7870","0.3786","0.4132"] | [] | ["XPHO"] | 43.5000 | 48.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a0b4c1-d2af-71d2-b889-d0cdc36c9652 | IBIT | 2026-09-18 09:43 | call_vertical_spread | 2 | 1 | 3900 | 362700.00 | unknown | ask | 44.8050 | 0.0300 | ["45.5","46.5"] | ["0.3534","0.3759"] | ["46.43"] | ["MCRY"] | 45.5000 | 46.5000 | 7 | 7 | false | true | false | ||||||||||
| 01a0b4b6-16c9-7943-94f3-c00492409aa1 | IBIT | 2026-09-18 09:30 | other | 3 | 1 | 140 | 214280.00 | unknown | ask | 44.2350 | 1.6500 | ["70","75"] | ["0.4910","0.4906"] | [] | ["XMIO"] | 70.0000 | 75.0000 | 819 | 854 | false | true | true | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:57:33Z"} |
| 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-22T14:48:50Z"} |
| 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-22T14:39:15Z"} |
| 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-22T14:27:31Z"} |
| 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:00: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-21T16:00:20Z"} |
| 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-21T15:09:25Z"} |
| 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-21T14:24:19Z"} |
| 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-21T14:06:29Z"} |
| 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:57:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlet |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:47:21Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:54:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:46:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:58:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:11:06Z"} |
| 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-18T14:42:38Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:43:19Z"} |
| 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-18T13:30:31Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |