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.
uw_flow_alerts566,287 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 | expiry |
|---|
| 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 |
|---|
| 28022632-1838-4239-9019-526f50436e7f | 2026-09-22 11:33 | 2026-09-22 11:33 | 2026-09-22 11:33 | QXO | QXO260925C00012000 | call | 12.0000 | 2026-09-25 | 0.6000 | 0.6000 | 0.6500 | 12.0000 | 10816.00 | 0.00 | 10816.00 | 180 | 20 | 1321 | 3620 | 0.364917127071823 | 0.581497984398294 | 0.605627565774433 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 13259131261.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| aca99c22-0f7c-4a56-b098-dba3556a17a5 | 2026-09-18 10:02 | 2026-09-18 10:02 | 2026-09-18 10:02 | QXO | QXO270917C00017000 | call | 17.0000 | 2027-09-17 | 1.6000 | 1.6000 | 1.7500 | 11.4350 | 16016.00 | 0.00 | 16016.00 | 100 | 16 | 100 | 181 | 0.552486187845304 | 0.651879052635316 | 0.656370179471677 | false | false | false | true | ||||||||||||||||
| cf0c2c34-ac0d-48ff-b536-8f0797ed2328 | 2026-09-16 10:13 | 2026-09-16 10:13 | 2026-09-16 10:13 | QXO | QXO261016C00012000 | call | 12.0000 | 2026-10-16 | 0.6900 | 0.6000 | 0.7000 | 11.5150 | 68999.00 | 68999.00 | 0.00 | 1000 | 5 | 2000 | 3782 | 0.528820729772607 | 0.660496445369708 | 0.660496445369708 | false | false | false | true | ||||||||||||||||
| f1abc3da-2757-49e6-add1-3e7b498617ac | 2026-09-16 10:13 | 2026-09-16 10:12 | 2026-09-16 10:12 | QXO | QXO261016C00012000 | call | 12.0000 | 2026-10-16 | 0.6900 | 0.6000 | 0.7000 | 11.5050 | 68930.00 | 68930.00 | 0.00 | 999 | 7 | 1000 | 3782 | 0.264410364886304 | 0.663989181230678 | 0.671632735596831 | false | false | false | true | ||||||||||||||||
| ba3c23fd-fb98-4463-aeb6-0607b2e0bc14 | 2026-09-11 12:17 | 2026-09-11 12:17 | 2026-09-11 12:17 | QXO | QXO261016C00013000 | call | 13.0000 | 2026-10-16 | 0.6500 | 0.6500 | 0.7000 | 12.3900 | 13050.00 | 0.00 | 13050.00 | 200 | 18 | 863 | 700 | 1.23285714285714 | 0.577479053791054 | 0.584092238136646 | false | false | false | true | ||||||||||||||||
| dd5e59aa-b027-4354-9977-71a7b9c97d97 | 2026-09-08 14:10 | 2026-09-08 14:10 | 2026-09-08 14:10 | QXO | QXO260911C00014000 | call | 14.0000 | 2026-09-11 | 0.1000 | 0.0500 | 0.1000 | 13.2250 | 28948.00 | 28948.00 | 0.00 | 2907 | 24 | 3243 | 3459 | 0.93755420641804 | 0.706367733279486 | 0.735962519120347 | false | false | false | true | ||||||||||||||||
| af09818b-6f9a-476e-b14e-ae57f4d6a30f | 2026-09-02 14:03 | 2026-09-02 14:03 | 2026-09-02 14:03 | QXO | QXO261016P00013000 | put | 13.0000 | 2026-10-16 | 0.9000 | 0.8500 | 0.9000 | 13.2750 | 18629.00 | 8999.00 | 0.00 | 207 | 10 | 217 | 2479 | 0.0875352964905204 | 0.580153277216608 | 0.584591936156519 | true | false | false | true | ||||||||||||||||
| cce00f57-b522-4c66-a78a-5aa43f10782b | 2026-08-26 15:21 | 2026-08-26 15:21 | 2026-08-26 15:21 | QXO | QXO270115C00027000 | call | 27.0000 | 2027-01-15 | 0.2300 | 0.2000 | 0.2500 | 14.0600 | 11678.00 | 11678.00 | 0.00 | 500 | 6 | 502 | 2806 | 0.178902352102637 | 0.676513055936435 | 0.689524878618049 | false | false | false | true | ||||||||||||||||
| 90cbae18-c35f-441d-993b-6011874cdf40 | 2026-08-25 09:49 | 2026-08-25 09:49 | 2026-08-25 09:49 | QXO | QXO261016C00015000 | call | 15.0000 | 2026-10-16 | 0.7600 | 0.7500 | 0.9500 | 13.7450 | 15200.00 | 0.00 | 15200.00 | 200 | 10 | 202 | 1489 | 0.135661517797179 | 0.580833443774419 | 0.600804134436562 | false | false | false | true | ||||||||||||||||
| 2528e535-9efc-46f9-b81d-8ae9bb642611 | 2026-08-20 10:01 | 2026-08-20 10:01 | 2026-08-20 10:01 | QXO | QXO270115C00025000 | call | 25.0000 | 2027-01-15 | 0.2500 | 0.2500 | 0.3000 | 13.3299 | 10289.00 | 0.00 | 10289.00 | 407 | 5 | 15976 | 24868 | 0.642432041177417 | 0.665568121950166 | 0.677982645870121 | false | false | false | true | ||||||||||||||||
| 4ba00cf9-5f86-4b5b-9193-59b241e4096f | 2026-08-20 10:01 | 2026-08-20 10:01 | 2026-08-20 10:01 | QXO | QXO270115C00025000 | call | 25.0000 | 2027-01-15 | 0.2500 | 0.2500 | 0.3000 | 13.3287 | 10186.00 | 0.00 | 10186.00 | 405 | 5 | 14531 | 24868 | 0.584325237252694 | 0.665650522697775 | 0.671915955187612 | false | false | false | true | ||||||||||||||||
| 6d3e3b6c-fbe8-4a20-a35b-1a88d3a8c52b | 2026-08-19 09:58 | 2026-08-19 09:58 | 2026-08-19 09:58 | QXO | QXO270115C00017000 | call | 17.0000 | 2027-01-15 | 1.3400 | 1.2000 | 1.3500 | 13.8700 | 14776.00 | 14776.00 | 0.00 | 110 | 12 | 110 | 3710 | 0.0296495956873315 | 0.639851534598304 | 0.654430853181932 | false | false | false | true | ||||||||||||||||
| f547c21f-99d8-4b05-9fa6-bdfbdb8d1eb7 | 2026-08-17 15:00 | 2026-08-17 15:00 | 2026-08-17 15:00 | QXO | QXO260918C00014000 | call | 14.0000 | 2026-09-18 | 0.9500 | 0.9000 | 1.0000 | 13.9000 | 23848.00 | 855.00 | 22233.00 | 251 | 60 | 489 | 1128 | 0.433510638297872 | 0.592704161469271 | 0.594311554945465 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 11806644268.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 11692520290.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 11692520290.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 12564012486.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:20:29.379987Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 12564012486.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 12564012486.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 12564012486.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 12564012486.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 12564012486.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 12564012486.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 12564012486.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 12564012486.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |