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 |
|---|
| 01a0caa2-bbce-7213-8891-b1807c61a021 | ASML | 2026-09-22 15:40 | call_diagonal_spread | 2 | 1 | 10 | 152440.00 | short | bid | 1747.5300 | 4.9000 | ["1800","1860"] | ["0.4748","0.4598"] | [] | ["XISX"] | 1800.0000 | 1860.0000 | 24 | 59 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:41:09Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9c2-ac6f-7091-ad3e-038d49cc57e0 | ASML | 2026-09-22 11:36 | call_diagonal_spread | 2 | 4 | 4 | 473806.00 | short | ask | 1723.3900 | 18.8000 | ["1000","2000"] | ["0.4817","0.4554"] | [] | ["EMLD","XBOX","XISX","XPHO"] | 1000.0000 | 2000.0000 | 115 | 850 | false | false | true | ||||||||||
| 01a0c9c2-a887-7ea2-9d7e-9d8c10aeda3f | ASML | 2026-09-22 11:36 | call_diagonal_spread | 2 | 5 | 5 | 592666.00 | short | ask | 1723.3900 | 17.4000 | ["1000","2000"] | ["0.4935","0.4558"] | [] | ["EMLD","XBOX","XISX","XMIO","XPHO"] | 1000.0000 | 2000.0000 | 115 | 850 | false | false | true | ||||||||||
| 01a0c9c2-a887-7ea2-9d7e-9d777fa14b85 | ASML | 2026-09-22 11:36 | call_diagonal_spread | 2 | 3 | 3 | 357770.00 | short | ask | 1723.3900 | 8.2000 | ["1000","2000"] | ["0.5716","0.4594"] | [] | ["XBOX","XISX","XPHO"] | 1000.0000 | 2000.0000 | 115 | 850 | false | false | true | ||||||||||
| 01a0c9c2-a887-7ea2-9d7e-9d6e73dca937 | ASML | 2026-09-22 11:36 | call_diagonal_spread | 2 | 3 | 3 | 355380.00 | short | ask | 1723.3900 | 28.0000 | ["1000","2000"] | ["0.4782","0.4555"] | [] | ["XBOX","XISX","XPHO"] | 1000.0000 | 2000.0000 | 115 | 850 | false | false | true | ||||||||||
| 01a0c9c2-a887-7ea2-9d7e-9d510106cb83 | ASML | 2026-09-22 11:36 | call_diagonal_spread | 2 | 5 | 5 | 595582.00 | short | ask | 1723.3900 | 31.9800 | ["1000","2000"] | ["0.5425","0.4587"] | [] | ["EMLD","XBOX","XISX","XMIO","XPHO"] | 1000.0000 | 2000.0000 | 115 | 850 | false | false | true | ||||||||||
| 01a0c54f-7f87-7a11-9fdb-3c3ae474eac8 | ASML | 2026-09-21 14:51 | call_diagonal_spread | 2 | 1 | 10 | 1095020.00 | short | ask | 1714.9700 | 29.4000 | ["1660","1700"] | ["0.4587","0.4575"] | [] | ["XCBO"] | 1660.0000 | 1700.0000 | 816 | 851 | false | false | true | ||||||||||
| 01a0c521-7e2f-7f91-a5a2-1315243e9ce5 | ASML | 2026-09-21 14:01 | call_diagonal_spread | 2 | 1 | 2 | 212664.00 | short | ask | 1710.6150 | 33.3000 | ["1700","1730"] | ["0.4595","0.4583"] | [] | ["XPHO"] | 1700.0000 | 1730.0000 | 816 | 851 | false | false | true | ||||||||||
| 01a0c4a2-9db7-7c00-9c32-320507ed749b | ASML | 2026-09-21 11:43 | call_diagonal_spread | 2 | 1 | 16 | 278480.00 | short | bid | 1702.1225 | 4.5000 | ["1700","1800"] | ["0.4651","0.4489"] | [] | ["XMIO"] | 1700.0000 | 1800.0000 | 25 | 60 | false | false | true | ||||||||||
| 01a0a67d-f336-7a62-9968-eb533a5957c1 | ASML | 2026-09-15 15:14 | call_diagonal_spread | 2 | 1 | 3 | 244980.00 | short | bid | 1591.8800 | 26.2000 | ["1840","1860"] | ["0.4590","0.4587"] | [] | ["XPHO"] | 1840.0000 | 1860.0000 | 822 | 857 | false | true | true | ||||||||||
| 01a0a675-40a6-79e2-84c4-820a87f52fec | ASML | 2026-09-15 15:04 | call_diagonal_spread | 2 | 1 | 10 | 816600.00 | short | bid | 1590.9499 | 30.0000 | ["1840","1860"] | ["0.4601","0.4588"] | [] | ["XCBO"] | 1840.0000 | 1860.0000 | 822 | 857 | false | true | true | ||||||||||
| 01a0a66a-5f7d-7513-b345-75764a01a8ed | ASML | 2026-09-15 14:53 | call_diagonal_spread | 2 | 1 | 6 | 490320.00 | short | bid | 1591.3100 | 27.0000 | ["1840","1860"] | ["0.4602","0.4588"] | [] | ["XCBO"] | 1840.0000 | 1860.0000 | 822 | 857 | false | true | true | ||||||||||
| 01a0a656-ac86-7c51-9b47-e4cc22889af0 | ASML | 2026-09-15 14:31 | call_diagonal_spread | 2 | 2 | 3 | 108030.00 | short | ask | 1593.3748 | 13.1000 | ["1400","1600"] | ["0.7581","0.4309"] | [] | ["XCBO"] | 1400.0000 | 1600.0000 | 3 | 122 | false | false | true | ||||||||||
| 01a0a656-336d-7a12-ac7b-530b71b96466 | ASML | 2026-09-15 14:30 | call_diagonal_spread | 2 | 1 | 3 | 235380.00 | short | bid | 1593.4800 | 34.2000 | ["1900","1920"] | ["0.4585","0.4612"] | [] | ["XISX"] | 1900.0000 | 1920.0000 | 822 | 857 | false | true | true | ||||||||||
| 01a0a5d3-18ee-7123-b2b5-e1ca5024bda3 | ASML | 2026-09-15 12:07 | call_diagonal_spread | 2 | 1 | 3 | 170400.00 | short | bid | 1587.3200 | 27.6000 | ["2360","2380"] | ["0.4652","0.4675"] | [] | ["XMIO"] | 2360.0000 | 2380.0000 | 822 | 857 | false | true | true | ||||||||||
| 01a090b5-9d08-7d50-a35c-5dfe3a5ced49 | ASML | 2026-09-11 09:43 | call_diagonal_spread | 2 | 2 | 5 | 122339.00 | short | bid | 1718.6600 | 19.2000 | ["1500","1700"] | ["0.6062","0.5479"] | [] | ["SPHR","XCBO"] | 1500.0000 | 1700.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0868a-0968-7191-89f3-9827744f097d | ASML | 2026-09-09 10:19 | call_diagonal_spread | 2 | 1 | 16 | 133680.00 | short | bid | 1739.0958 | 6.7000 | ["1720","1750"] | ["0.5484","0.4509"] | [] | ["BATO"] | 1720.0000 | 1750.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a08292-fdd8-7ff1-9168-7dd98af44c40 | ASML | 2026-09-08 15:51 | call_diagonal_spread | 2 | 1 | 9 | 113634.00 | short | bid | 1767.5100 | 25.5000 | ["1860","2020"] | ["0.4526","0.4748"] | [] | ["EMLD"] | 1860.0000 | 2020.0000 | 31 | 73 | false | true | true | ||||||||||
| 01a08237-7c10-7281-b518-72cd46c28a5f | ASML | 2026-09-08 14:11 | call_diagonal_spread | 2 | 1 | 10 | 135420.00 | short | bid | 1768.5200 | 11.0000 | ["1800","1920"] | ["0.4598","0.4695"] | [] | ["BATO"] | 1800.0000 | 1920.0000 | 10 | 73 | false | true | true | ||||||||||
| 01a081b1-92d0-7381-9513-a18883e3f21e | ASML | 2026-09-08 11:44 | call_diagonal_spread | 2 | 1 | 20 | 315920.00 | short | ask | 1768.3950 | 11.7000 | ["1675","1760"] | ["0.5567","0.4518"] | [] | ["BATO"] | 1675.0000 | 1760.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a08169-b078-70a0-9aa0-1f7978516eb9 | ASML | 2026-09-08 10:26 | call_diagonal_spread | 2 | 2 | 30 | 297870.00 | short | bid | 1748.7800 | 20.8000 | ["1805","1830"] | ["0.4636","0.4637"] | [] | ["ARCO","EDGO"] | 1805.0000 | 1830.0000 | 17 | 24 | true | true | true | ||||||||||
| 01a08169-3760-7e53-bc54-62616fe2ab4a | ASML | 2026-09-08 10:25 | call_diagonal_spread | 2 | 1 | 20 | 197320.00 | short | bid | 1749.3600 | 12.9000 | ["1800","1835"] | ["0.4604","0.4591"] | [] | ["ARCO"] | 1800.0000 | 1835.0000 | 17 | 24 | false | true | true | ||||||||||
| 01a08169-2f90-75d2-8871-d3766527507d | ASML | 2026-09-08 10:25 | call_diagonal_spread | 2 | 1 | 20 | 197320.00 | short | bid | 1749.6300 | 12.9000 | ["1800","1835"] | ["0.4581","0.4598"] | [] | ["ARCO"] | 1800.0000 | 1835.0000 | 17 | 24 | false | true | true | ||||||||||
| 01a08169-2f90-75d2-8871-d366fef5c6a2 | ASML | 2026-09-08 10:25 | call_diagonal_spread | 2 | 1 | 40 | 394640.00 | short | bid | 1749.6300 | 12.9000 | ["1800","1835"] | ["0.4597","0.4584"] | [] | ["ARCO"] | 1800.0000 | 1835.0000 | 17 | 24 | false | true | true | ||||||||||
| 01a08169-2ba8-7421-b33b-f8967613c251 | ASML | 2026-09-08 10:25 | call_diagonal_spread | 2 | 1 | 40 | 394640.00 | short | bid | 1749.6300 | 12.9000 | ["1800","1835"] | ["0.4581","0.4598"] | [] | ["ARCO"] | 1800.0000 | 1835.0000 | 17 | 24 | false | true | true | ||||||||||
| 01a08169-2ba8-7421-b33b-f880fe24e771 | ASML | 2026-09-08 10:25 | call_diagonal_spread | 2 | 2 | 30 | 295875.00 | short | bid | 1749.6300 | 12.9000 | ["1800","1835"] | ["0.4586","0.4591"] | [] | ["ARCO","XISX"] | 1800.0000 | 1835.0000 | 17 | 24 | false | true | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:36:34Z"} |
| 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:36:34Z"} |
| 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:36:34Z"} |
| 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:36:34Z"} |
| 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:36:34Z"} |
| 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-21T18:52:00Z"} |
| 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-21T18:02:03Z"} |
| 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:43:10Z"} |
| 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-15T19:14:52Z"} |
| 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-15T19:05:38Z"} |
| 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-15T18:53:17Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:32:10Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:31:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:08:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:43:38Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:19:58Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:51:21Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:11:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:44:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:26:25Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:25:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:25:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:25:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:25:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:25:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |