core.flow_alerts
Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.
Simplify Analyticsuw_flow_alerts523,327 rowsrestricted — hover for the licence| iduuid | created_at ↑timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric |
|---|
| pricenumeric |
|---|
| bidnumeric |
|---|
| asknumeric |
|---|
| underlying_pricenumeric |
|---|
| total_premiumnumeric |
|---|
| total_ask_side_premnumeric |
|---|
| total_bid_side_premnumeric |
|---|
| total_sizebigint |
|---|
| trade_countinteger |
|---|
| volumebigint |
|---|
| open_interestbigint |
|---|
| volume_oi_rationumeric |
|---|
| iv_startnumeric |
|---|
| iv_endnumeric |
|---|
| has_sweepboolean |
|---|
| has_floorboolean |
|---|
| has_multilegboolean |
|---|
| has_singlelegboolean |
|---|
| all_opening_tradesboolean |
|---|
| alert_ruletext |
|---|
| rule_iduuid |
|---|
| expiry_countinteger |
|---|
| issue_typetext |
|---|
| sectortext |
|---|
| marketcapnumeric |
|---|
| next_earnings_datedate |
|---|
| er_timetext |
|---|
| missing_periscopeboolean |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| e5d53cbd-3a6c-4b71-9b0a-e9b4062f7771 | 2026-08-31 15:59 | 2026-08-31 15:59 | 2026-08-31 15:59 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 8.0000 | 7.8500 | 8.0500 | 958.7600 | 250336.00 | 15936.00 | 230400.00 | 313 | 8 | 9411 | 3749 | 2.51026940517471 | 0.559053993966434 | 0.558681999291341 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c385795c-dbf9-487f-8cac-339c130bf73c | 2026-09-01 11:04 | 2026-09-01 11:03 | 2026-09-01 11:03 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 5.9000 | 5.7500 | 5.9000 | 956.5301 | 141595.00 | 141010.00 | 585.00 | 240 | 15 | 5259 | 5381 | 0.977327634268723 | 0.583444674270853 | 0.585445102103037 | false | false | false | |||||||||||||||||
| 3c113780-a77b-4e0f-97b3-50cec3807117 | 2026-09-04 09:31 | 2026-09-04 09:31 | 2026-09-04 09:31 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 3.8200 | 3.5000 | 4.1000 | 980.6200 | 123630.00 | 99356.00 | 23169.00 | 324 | 91 | 6889 | 20793 | 0.331313422786515 | 1.01774059944212 | 1.0033992934691 | false | false | false | |||||||||||||||||
| 47b05385-3349-400b-b55a-b6871bcd9a7f | 2026-09-04 09:32 | 2026-09-04 09:32 | 2026-09-04 09:32 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 5.0000 | 4.8000 | 5.0500 | 984.4750 | 112415.00 | 108490.00 | 3425.00 | 225 | 87 | 10085 | 20793 | 0.485018996777762 | 1.02281640348874 | 1.02990746259861 | true | false | false | |||||||||||||||||
| d245c744-d2f3-4e2a-abfc-34bedcecb174 | 2026-09-04 09:34 | 2026-09-04 09:34 | 2026-09-04 09:34 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 6.0100 | 5.8000 | 6.2000 | 989.3000 | 118356.00 | 114799.00 | 2962.00 | 197 | 64 | 13809 | 20793 | 0.664117731929015 | 0.994558021097529 | 0.974997729317771 | false | false | false | |||||||||||||||||
| bb31f3c7-9706-421b-a0bd-3be231e34663 | 2026-09-04 09:34 | 2026-09-04 09:34 | 2026-09-04 09:34 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 7.8800 | 7.6500 | 8.2000 | 994.2800 | 103951.00 | 60955.00 | 42996.00 | 132 | 42 | 14470 | 20793 | 0.695907276487279 | 0.965747921687965 | 0.989679540144273 | true | false | false | |||||||||||||||||
| cf7486cb-0394-4c0e-968d-4778ec5353e7 | 2026-09-04 09:34 | 2026-09-04 09:34 | 2026-09-04 09:34 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 8.0000 | 7.7500 | 8.1000 | 993.4200 | 151214.00 | 151214.00 | 0.00 | 189 | 55 | 16167 | 20793 | 0.777521281200404 | 1.02669500369818 | 1.01884844055306 | false | false | false | |||||||||||||||||
| 84d7143e-d6d2-405e-bbf7-d7524c64d150 | 2026-09-04 09:37 | 2026-09-04 09:37 | 2026-09-04 09:37 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 9.0000 | 8.6500 | 9.0500 | 996.6700 | 124190.00 | 107110.00 | 17080.00 | 138 | 64 | 21079 | 20793 | 1.01375462896167 | 0.99408461394029 | 0.988195777762409 | true | false | false | |||||||||||||||||
| 287e5c9b-09c5-4353-a39b-184392e99004 | 2026-09-04 09:37 | 2026-09-04 09:37 | 2026-09-04 09:37 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 9.2900 | 9.1000 | 9.5000 | 997.1591 | 128186.00 | 40786.00 | 87400.00 | 138 | 22 | 21313 | 20793 | 1.02500841629395 | 1.00985509839803 | 1.00935310160886 | true | false | false | |||||||||||||||||
| 07b6f715-65fd-4a70-be46-5d001ee080e1 | 2026-09-04 09:37 | 2026-09-04 09:37 | 2026-09-04 09:37 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 9.7000 | 9.3500 | 10.0000 | 997.8900 | 123243.00 | 100970.00 | 21308.00 | 127 | 51 | 21466 | 20793 | 1.03236666185736 | 1.00615136408872 | 1.01189700180576 | true | false | false | |||||||||||||||||
| 3633c8e0-95b0-446a-b83e-0f311325ebfb | 2026-09-04 09:37 | 2026-09-04 09:37 | 2026-09-04 09:37 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 10.0000 | 9.7500 | 10.0000 | 998.4500 | 295893.00 | 287981.00 | 7912.00 | 296 | 83 | 22177 | 20793 | 1.0665608618285 | 0.995589444105467 | 0.992735401347133 | false | false | false | |||||||||||||||||
| 1d5c6e87-a068-487e-9b71-d8b6768312e6 | 2026-09-04 09:38 | 2026-09-04 09:37 | 2026-09-04 09:37 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 10.0300 | 9.6000 | 10.3000 | 998.4350 | 151515.00 | 145515.00 | 6000.00 | 151 | 56 | 22922 | 20793 | 1.1023902274804 | 1.02597044042889 | 1.00039037492381 | true | false | false | |||||||||||||||||
| ac4561be-bf1e-407b-bef7-76283ecd6419 | 2026-09-04 09:51 | 2026-09-04 09:51 | 2026-09-04 09:51 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 8.5100 | 8.4000 | 8.7500 | 997.0193 | 137844.00 | 125088.00 | 12756.00 | 162 | 45 | 37513 | 20793 | 1.80411677006685 | 0.962645616088769 | 0.963164801707663 | true | false | false | |||||||||||||||||
| ac08733c-1484-419c-87ae-1515eb87ce61 | 2026-09-04 09:58 | 2026-09-04 09:58 | 2026-09-04 09:58 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 9.4700 | 9.0500 | 9.7500 | 999.3879 | 146797.00 | 108492.00 | 23465.00 | 155 | 72 | 43875 | 20793 | 2.11008512480162 | 0.940500016387458 | 0.917389165477707 | true | false | false | |||||||||||||||||
| 3a3eaace-2354-485b-b7d6-f5227d673534 | 2026-09-04 10:00 | 2026-09-04 10:00 | 2026-09-04 10:00 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 10.1300 | 9.8500 | 10.6750 | 1002.2000 | 229891.00 | 195872.00 | 34019.00 | 227 | 113 | 46240 | 20793 | 2.22382532583081 | 0.848575582414597 | 0.903410236610364 | true | false | false | |||||||||||||||||
| a61d4500-2df7-4ee8-96f9-f4f97ee725cd | 2026-09-04 10:26 | 2026-09-04 10:26 | 2026-09-04 10:26 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 7.4700 | 7.2000 | 7.5500 | 997.3000 | 149307.00 | 42267.00 | 107040.00 | 200 | 9 | 59685 | 20793 | 2.87043716635406 | 0.850228474083952 | 0.873711784593541 | true | false | false | |||||||||||||||||
| e9800e44-cc02-4c0e-bd2b-f2c89cfe8ee5 | 2026-09-04 11:49 | 2026-09-04 11:49 | 2026-09-04 11:49 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 5.2000 | 5.1500 | 5.2000 | 997.9500 | 104445.00 | 96720.00 | 7725.00 | 201 | 10 | 80769 | 20793 | 3.88443226085702 | 0.701922701146041 | 0.707715096268013 | false | false | false | |||||||||||||||||
| 02513e59-0b4c-4d1f-a6e9-723ed284122f | 2026-09-04 12:08 | 2026-09-04 12:08 | 2026-09-04 12:08 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 5.6500 | 5.5000 | 5.8500 | 1000.1650 | 169506.00 | 0.00 | 169506.00 | 300 | 29 | 85673 | 20793 | 4.12028086375222 | 0.662249083134187 | 0.663766825361994 | true | false | false | |||||||||||||||||
| 72f2eaa3-d9b0-46b5-8ec5-29126965b388 | 2026-09-04 12:28 | 2026-09-04 12:28 | 2026-09-04 12:28 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 9.5000 | 9.3500 | 9.6000 | 1006.1400 | 107315.00 | 102565.00 | 4750.00 | 113 | 11 | 91461 | 20793 | 4.39864377434714 | 0.730688588883615 | 0.73807609972659 | false | false | false | |||||||||||||||||
| e8a15882-2619-4f6f-a2ae-679c0cfe4358 | 2026-09-04 13:05 | 2026-09-04 13:05 | 2026-09-04 13:05 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 6.1500 | 6.0500 | 6.2500 | 1002.3900 | 161134.00 | 4295.00 | 154359.00 | 262 | 6 | 97022 | 20793 | 4.66608954936758 | 0.674515195386339 | 0.666821503340062 | false | false | false | |||||||||||||||||
| 081f20d6-b092-4ea1-bc71-c62ddfa11c05 | 2026-09-04 13:11 | 2026-09-04 13:11 | 2026-09-04 13:11 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 5.2000 | 5.0000 | 5.2500 | 1000.5230 | 207985.00 | 10915.00 | 196555.00 | 400 | 6 | 98544 | 20793 | 4.73928726013562 | 0.68201379626439 | 0.689011698294765 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:45:37.268469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:45:37.268469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:45:37.268469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:45:37.268469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:45:37.268469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:56:18.493427Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |