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_alerts658,639 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 |
|---|
| f50c2d5a-1584-4652-a85a-cb223729d65f | 2026-09-21 10:08 | 2026-09-21 10:08 | 2026-09-21 10:08 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 1.4500 | 1.4000 | 1.4600 | 149.2400 | 21304.00 | 21304.00 | 0.00 | 147 | 6 | 2936 | 6677 | 0.439718436423544 | 0.566781947848849 | 0.567475762550213 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 449206220160.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:10:29.738922Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 06e2c18c-224f-424a-9705-226f27057ff1 | 2026-09-21 11:18 | 2026-09-21 11:18 | 2026-09-21 11:18 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 1.5200 | 1.5100 | 1.5300 | 149.6701 | 15489.00 | 12920.00 | 2417.00 | 102 | 17 | 6413 | 6677 | 0.960461285008237 | 0.555996676262873 | 0.557871831295008 | false | false | false | |||||||||||||||||
| 75893d8f-b7ad-46af-8a95-7b9b44564b89 | 2026-09-21 12:45 | 2026-09-21 12:45 | 2026-09-21 12:45 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 1.3100 | 1.3000 | 1.3300 | 148.7400 | 47629.00 | 46309.00 | 1320.00 | 363 | 15 | 12608 | 6677 | 1.88827317657631 | 0.567487189900703 | 0.567956079965797 | true | false | false | |||||||||||||||||
| 69377b9c-4ced-40d3-b3f8-f6cbd8da9690 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 2.4200 | 2.2900 | 2.5000 | 152.4850 | 14007.00 | 6807.00 | 0.00 | 58 | 15 | 436 | 15050 | 0.0289700996677741 | 0.628714399898991 | 0.634328705023151 | true | false | false | |||||||||||||||||
| 07d8e1f0-5903-4b1b-896d-85f604394195 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 2.0000 | 1.8200 | 2.0000 | 151.5600 | 53760.00 | 53760.00 | 0.00 | 269 | 6 | 2064 | 15050 | 0.137142857142857 | 0.636940005346821 | 0.619231586288646 | true | false | false | |||||||||||||||||
| 02516e06-7c36-4551-870c-890ce0c8634c | 2026-09-22 09:37 | 2026-09-22 09:37 | 2026-09-22 09:37 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 2.3000 | 2.2200 | 2.3800 | 152.4700 | 23451.00 | 22760.00 | 691.00 | 102 | 11 | 7373 | 15050 | 0.489900332225914 | 0.615512405592479 | 0.612964089407504 | false | false | false | |||||||||||||||||
| bb324b3a-2cf5-44b4-a82f-afa9d7603c5e | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 2.6700 | 2.6200 | 2.6700 | 153.0210 | 15199.00 | 15199.00 | 0.00 | 57 | 8 | 8185 | 15050 | 0.543853820598007 | 0.635903135186211 | 0.635903135186211 | false | false | false | |||||||||||||||||
| e8c77edf-83f0-4433-9c86-969de1399d79 | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 2.7500 | 2.7000 | 2.7500 | 153.2700 | 18136.00 | 18136.00 | 0.00 | 66 | 6 | 8899 | 15050 | 0.591295681063123 | 0.631874374109518 | 0.632746902653732 | false | false | false | |||||||||||||||||
| 03969508-2ce4-44ab-abe1-59238c1a7030 | 2026-09-22 09:52 | 2026-09-22 09:52 | 2026-09-22 09:52 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 2.0500 | 2.0100 | 2.0900 | 151.8000 | 13095.00 | 0.00 | 3870.00 | 64 | 8 | 14681 | 15050 | 0.975481727574751 | 0.610160062206539 | 0.612091780022059 | false | false | false | |||||||||||||||||
| 2629a9ee-816b-4eab-8150-e6c7fe38a403 | 2026-09-22 11:24 | 2026-09-22 11:24 | 2026-09-22 11:24 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 1.1800 | 1.1700 | 1.1800 | 149.0000 | 35517.00 | 35400.00 | 117.00 | 301 | 32 | 22350 | 15050 | 1.48504983388704 | 0.579596549831864 | 0.581893727098912 | true | false | false | |||||||||||||||||
| f6675753-32c2-45ba-ac28-b6650aed69e9 | 2026-09-22 13:29 | 2026-09-22 13:29 | 2026-09-22 13:29 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 1.0400 | 1.0200 | 1.0400 | 149.1350 | 19844.00 | 18814.00 | 0.00 | 191 | 11 | 26765 | 15050 | 1.77840531561462 | 0.565722014591172 | 0.568121875128645 | false | false | false | |||||||||||||||||
| 6342ee4d-26a3-4c2e-b91f-1268ff03f12b | 2026-09-23 10:16 | 2026-09-23 10:16 | 2026-09-23 10:16 | ORCL | ORCL260925C00155000 | call | 155.0000 | 2026-09-25 | 0.3500 | 0.3400 | 0.3500 | 146.1250 | 12703.00 | 12635.00 | 68.00 | 363 | 12 | 4121 | 15296 | 0.269416841004184 | 0.627433379619824 | 0.631087420844398 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:19:12.034191Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:45:57.787225Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:32:27.895939Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:54:31.756724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:29:11.777432Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:30:55.056187Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:18:11.787457Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |