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 | net_side |
|---|
| 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 |
|---|
| 01a06db5-b70d-72e3-be71-421dcad820cc | ETHA | 2026-09-04 14:36 | call_vertical_spread | 2 | 1 | 1825 | 246375.00 | long | ask | 18.4800 | 0.0400 | ["22","30"] | ["0.5551","0.6150"] | ["22.83"] | ["EDGO"] | 22.0000 | 30.0000 | 105 | 105 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:37:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db5-b70d-72e3-be71-4206c804518a | ETHA | 2026-09-04 14:36 | call_vertical_spread | 2 | 1 | 1442 | 194670.00 | long | ask | 18.4800 | 0.0400 | ["22","30"] | ["0.5551","0.6150"] | ["22.83"] | ["AMXO"] | 22.0000 | 30.0000 | 105 | 105 | false | true | false | true | |||||||||
| 01a06db5-b70d-72e3-be71-41dfa8d17e13 | ETHA | 2026-09-04 14:36 | call_vertical_spread | 2 | 4 | 1620 | 218700.00 | long | ask | 18.4800 | 0.0491 | ["22","30"] | ["0.5551","0.6150"] | ["22.83"] | ["EMLD","SPHR","XBOX","XPHO"] | 22.0000 | 30.0000 | 105 | 105 | false | true | false | true | |||||||||
| 01a08bd5-0850-7c60-a2e3-c04ba4aca2dc | ETHA | 2026-09-10 10:59 | call_vertical_spread | 2 | 1 | 2000 | 136000.00 | long | ask | 18.4300 | 0.0800 | ["28","38"] | ["0.6042","0.6877"] | ["28.34"] | ["XMIO"] | 28.0000 | 38.0000 | 127 | 127 | false | true | false | true | |||||||||
| 01a090fa-7dd8-74d3-8066-c7b8e34cbba9 | ETHA | 2026-09-11 10:58 | call_diagonal_spread | 2 | 1 | 1000 | 352000.00 | long | bid | 19.6900 | 0.1300 | ["18","19"] | ["0.5580","0.5514"] | [] | ["XCBO"] | 18.0000 | 19.0000 | 7 | 35 | false | false | true | true | |||||||||
| 01a09161-5dc8-7f00-b086-0339f66e4cbe | ETHA | 2026-09-11 12:51 | call_diagonal_spread | 2 | 4 | 196 | 146348.00 | long | bid | 19.4800 | 0.3000 | ["15.5","16"] | ["7.8541","0.5929"] | [] | ["MCRY","XBOX"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a09161-9860-75c1-87c3-1eb47d721e1c | ETHA | 2026-09-11 12:51 | call_diagonal_spread | 2 | 2 | 410 | 307090.00 | long | bid | 19.4706 | 0.3000 | ["15.5","16"] | ["8.0723","0.5901"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a09161-cf11-7091-a1d0-e637aeb7b732 | ETHA | 2026-09-11 12:51 | call_diagonal_spread | 2 | 2 | 410 | 307090.00 | long | bid | 19.4799 | 0.3000 | ["15.5","16"] | ["7.8666","0.5594"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a09163-51c8-7930-8c7b-a68f85b67f3b | ETHA | 2026-09-11 12:53 | call_diagonal_spread | 2 | 4 | 165 | 123129.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.2341","0.6414"] | [] | ["MCRY","XBOX"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a09163-af88-7830-a951-43acb7d08d39 | ETHA | 2026-09-11 12:53 | call_diagonal_spread | 2 | 2 | 290 | 217210.00 | long | bid | 19.4736 | 0.3000 | ["15.5","16"] | ["8.0553","0.5808"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a09164-1131-7771-8a18-8477a34f541d | ETHA | 2026-09-11 12:54 | call_diagonal_spread | 2 | 1 | 400 | 299600.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.2518","0.6063"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a09164-3c28-7ef3-b192-55277543def6 | ETHA | 2026-09-11 12:54 | call_diagonal_spread | 2 | 2 | 410 | 307090.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.2563","0.6063"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a09164-4bc9-7220-a5f1-5b367dbee96f | ETHA | 2026-09-11 12:54 | call_diagonal_spread | 2 | 2 | 410 | 307090.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.2574","0.6063"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a09166-2089-78a0-9081-3863cdaf514c | ETHA | 2026-09-11 12:56 | call_diagonal_spread | 2 | 1 | 186 | 139314.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.3027","0.6063"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a0a565-99ae-7890-b405-5d14c21246b0 | ETHA | 2026-09-15 10:08 | call_vertical_spread | 2 | 6 | 2404 | 234784.00 | long | ask | 18.4250 | 0.1400 | ["40","50"] | ["0.6454","0.6737"] | ["40.28"] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 40.0000 | 50.0000 | 275 | 275 | false | true | false | true | |||||||||
| 01a0aac9-036b-7d91-b9f1-d30d1b0e7912 | ETHA | 2026-09-16 11:14 | call_vertical_spread | 2 | 1 | 1290 | 129000.00 | long | ask | 18.0400 | 0.0400 | ["30","35"] | ["0.6032","0.6329"] | ["30.24"] | ["BATO"] | 30.0000 | 35.0000 | 184 | 184 | false | true | false | true | |||||||||
| 01a0afd4-de43-7f72-909d-2516f14e3fc5 | ETHA | 2026-09-17 10:45 | synthetic | 2 | 1 | 279 | 126666.00 | long | bid | 18.6100 | 0.1400 | ["19"] | ["0.5334"] | ["18.92"] | ["SPHR"] | 19.0000 | 19.0000 | 120 | 120 | false | false | false | false | |||||||||
| 01a0b550-2447-7d82-ab19-b23f2ccca245 | ETHA | 2026-09-18 12:18 | synthetic | 2 | 1 | 20000 | 10160000.00 | long | ask | 19.6350 | 0.2100 | ["16"] | ["0.5686"] | ["19.80"] | ["AMXO"] | 16.0000 | 16.0000 | 91 | 91 | true | false | false | false | |||||||||
| 01a0b5d9-5948-7631-9dec-6f998a3b9a8c | ETHA | 2026-09-18 14:48 | call_diagonal_spread | 2 | 1 | 111 | 315271.00 | long | ask | 19.7204 | 0.2000 | ["1","10"] | ["2.2487","27.7987"] | [] | ["XCBO"] | 1.0000 | 10.0000 | 0 | 119 | false | false | true | true | |||||||||
| 01a0c42f-d6e7-7580-8c2f-7dd39aedf2bd | ETHA | 2026-09-21 09:37 | call_vertical_spread | 2 | 1 | 300 | 176100.00 | long | ask | 20.5650 | 0.5000 | ["20","24"] | ["0.5741","0.5619"] | ["21.55"] | ["SPHR"] | 20.0000 | 24.0000 | 179 | 179 | false | false | false | true | |||||||||
| 01a0c46b-93df-76f1-b953-5e69565e5af5 | ETHA | 2026-09-21 10:42 | call_vertical_spread | 2 | 1 | 500 | 701000.00 | long | ask | 20.6300 | 0.4000 | ["13","19"] | ["0.6464","0.5838"] | ["16.86"] | ["EDGO"] | 13.0000 | 19.0000 | 269 | 269 | false | false | false | true | |||||||||
| 01a0c49f-2ae6-7331-86b0-fbba8afeaa7a | ETHA | 2026-09-21 11:39 | call_vertical_spread | 2 | 1 | 600 | 100800.00 | long | ask | 20.6651 | 0.0900 | ["23","26"] | ["0.5776","0.6060"] | ["23.56"] | ["XPHO"] | 23.0000 | 26.0000 | 60 | 60 | false | true | false | true | |||||||||
| 01a0c4d4-217e-7d23-b9d3-2719ff3398f7 | ETHA | 2026-09-21 12:37 | synthetic | 2 | 1 | 100 | 157600.00 | long | ask | 20.8176 | 0.5000 | ["23"] | ["0.6507"] | ["23.08"] | ["XCBO"] | 23.0000 | 23.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c4d4-1d97-7fe0-a848-723ae8c42cf6 | ETHA | 2026-09-21 12:37 | straddle | 2 | 3 | 200 | 314720.00 | long | ask | 20.8176 | 0.5000 | ["23"] | ["0.6496"] | ["7.26","38.74"] | ["XBOX"] | 23.0000 | 23.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c9d1-a08e-7912-b637-4a58a9d7a611 | ETHA | 2026-09-22 11:52 | call_vertical_spread | 2 | 1 | 2500 | 625000.00 | long | ask | 20.7212 | 0.1100 | ["20","21"] | ["0.5144","0.5205"] | ["20.50"] | ["AMXO"] | 20.0000 | 21.0000 | 24 | 24 | false | false | false | true | |||||||||
| 01a0c9fc-61de-7182-9a93-0dc82bb90bc7 | ETHA | 2026-09-22 12:39 | put_diagonal_spread | 2 | 1 | 65 | 175890.00 | long | ask | 20.6450 | 0.7000 | ["31","32"] | ["0.6671","0.6836"] | [] | ["XPHO"] | 31.0000 | 32.0000 | 633 | 850 | false | false | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:37:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:37:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:00:02Z"} |
| 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-11T14:59:16Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:51:50Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:51:50Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:51:50Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:53:25Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:54:13Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:54:13Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:55:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:55:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:56:34Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:08:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:15:26Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:46:09Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:19:12Z"} |
| 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-18T18:48:34Z"} |
| 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-21T13:37:45Z"} |
| 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-21T14:43:01Z"} |
| 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:39: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-21T16:37:24Z"} |
| 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-21T16:37:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:52:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:39:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |