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 |
| 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 | ||||||||||
| 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 | ||||||||||
| 01a0c990-3677-7e52-aa22-1d74876a5d5c | IBIT | 2026-09-22 10:41 | call_vertical_spread | 2 | 1 | 314 | 101422.00 | long | ask | 48.6700 | 0.0700 | ["46","48.5"] | ["0.5650","0.4405"] | ["48.15"] | ["C2OX"] | 46.0000 | 48.5000 | 1 | 1 | false | false | false | ||||||||||
| 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 | ||||||||||
| 01a0c98f-9a38-7d12-be72-71035b997b6e | IBIT | 2026-09-22 10:40 | call_vertical_spread | 2 | 4 | 819 | 519246.00 | long | ask | 48.5900 | 0.1300 | ["45","48.5"] | ["0.3973","0.3893"] | ["47.26"] | ["ARCO","EMLD","SPHR","XPHO"] | 45.0000 | 48.5000 | 24 | 24 | false | false | false | ||||||||||
| 01a0c98e-cf16-78b2-aec1-c12c955b568a | IBIT | 2026-09-22 10:39 | call_vertical_spread | 2 | 4 | 333 | 104919.00 | long | ask | 48.6250 | 0.0886 | ["46","48.5"] | ["0.5875","0.4261"] | ["48.15"] | ["ARCO","EMLD","SPHR","XPHO"] | 46.0000 | 48.5000 | 1 | 1 | false | false | false | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a0c573-f777-76c2-b22d-4fae2cc790e7 | IBIT | 2026-09-21 15:31 | call_vertical_spread | 2 | 3 | 120 | 231240.00 | long | ask | 48.9450 | 0.4500 | ["60","90"] | ["0.4995","0.4963"] | ["65.93"] | ["XPHO"] | 60.0000 | 90.0000 | 816 | 816 | false | true | false | ||||||||||
| 01a0c573-f777-76c2-b22d-4f973a82e331 | IBIT | 2026-09-21 15:31 | call_vertical_spread | 2 | 2 | 80 | 154160.00 | long | ask | 48.9450 | 0.4500 | ["60","90"] | ["0.4995","0.4963"] | ["65.93"] | ["XPHO"] | 60.0000 | 90.0000 | 816 | 816 | false | true | false | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a0c4cc-0b2f-7073-b733-50ef8bc6d227 | IBIT | 2026-09-21 12:28 | call_vertical_spread | 2 | 1 | 50 | 112450.00 | long | ask | 48.7100 | 0.3500 | ["40","60"] | ["0.4755","0.4519"] | ["48.55"] | ["XISX"] | 40.0000 | 60.0000 | 452 | 452 | false | false | false | ||||||||||
| 01a0c4c8-4a3e-7a31-9409-bc8d90e47b6a | IBIT | 2026-09-21 12:24 | call_vertical_spread | 2 | 1 | 6250 | 2106250.00 | long | ask | 48.6150 | 0.0400 | ["53","63"] | ["0.4252","0.4558"] | ["54.73"] | ["AMXO"] | 53.0000 | 63.0000 | 88 | 88 | false | true | false | ||||||||||
| 01a0c49d-2b2f-7330-ad92-49e61c0b0b07 | IBIT | 2026-09-21 11:37 | call_vertical_spread | 2 | 1 | 111 | 109779.00 | long | ask | 48.6750 | 0.2000 | ["45","47"] | ["0.4209","0.4217"] | ["46.21"] | ["XPHO"] | 45.0000 | 47.0000 | 60 | 60 | false | false | false | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a0c42d-0c0f-79f0-b862-1bd746c09bee | IBIT | 2026-09-21 09:34 | call_vertical_spread | 2 | 2 | 170 | 155550.00 | long | ask | 48.1550 | 0.2000 | ["47","50"] | ["0.4102","0.4034"] | ["48.45"] | ["XBOX","XCBO"] | 47.0000 | 50.0000 | 116 | 116 | false | false | false | ||||||||||
| 01a0c42b-662f-7312-b45b-e0aeeab61059 | IBIT | 2026-09-21 09:32 | call_vertical_spread | 2 | 3 | 1000 | 101664.00 | long | ask | 48.1550 | 0.0400 | ["52","58"] | ["0.4186","0.4749"] | ["52.61"] | ["AMXO","ARCO","C2OX"] | 52.0000 | 58.0000 | 25 | 25 | 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a0b4d7-085f-7423-9cf4-c02ac143c33a | IBIT | 2026-09-18 10:06 | call_vertical_spread | 2 | 3 | 1180 | 125100.00 | long | ask | 45.5300 | 0.0400 | ["46","48"] | ["0.3887","0.4228"] | ["46.50"] | ["EDGO","XCBO","XPHO"] | 46.0000 | 48.0000 | 7 | 7 | false | true | false | ||||||||||
| 01a0b4d7-085f-7423-9cf4-c01f013b7f97 | IBIT | 2026-09-18 10:06 | call_vertical_spread | 2 | 1 | 2032 | 215392.00 | long | ask | 45.5300 | 0.0400 | ["46","48"] | ["0.3887","0.4227"] | ["46.50"] | ["EDGO"] | 46.0000 | 48.0000 | 7 | 7 | false | true | false | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a06dbc-1bc5-73b2-93ff-eb0f0ab01fa3 | IBIT | 2026-09-04 14:43 | call_vertical_spread | 2 | 1 | 989 | 298678.00 | long | ask | 45.1200 | 0.0500 | ["50","55"] | ["0.4141","0.4263"] | ["50.98"] | ["XBOX"] | 50.0000 | 55.0000 | 87 | 87 | false | true | 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 |
| 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 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:41:14Z"} |
| 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:40:40Z"} |
| 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:40:40Z"} |
| 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:47Z"} |
| 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-22T13:30:12Z"} |
| 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-22T13:30:12Z"} |
| 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-21T19:32:05Z"} |
| 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-21T19:32:05Z"} |
| 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:19:42Z"} |
| 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:12: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-21T16:28:36Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:24:25Z"} |
| 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:37:24Z"} |
| 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:07:01Z"} |
| 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:06:31Z"} |
| 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:06:05Z"} |
| 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-21T13:53:58Z"} |
| 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-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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:34: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:32:58Z"} |
| 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-18T16:11:06Z"} |
| 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-18T15:37:36Z"} |
| 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-18T15:23:50Z"} |
| 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-18T14:06:30Z"} |
| 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-18T14:06:30Z"} |
| 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 |
| false |
| 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 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:44:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |