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 |
|---|
| 28c24778-d363-4e9b-a075-4cdb112f04ba | 2026-09-29 10:28 | 2026-09-29 10:28 | 2026-09-29 10:28 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 2.1000 | 2.1000 | 2.1600 | 142.7100 | 21210.00 | 0.00 | 20160.00 | 101 | 10 | 689 | 1941 | 0.354971664090675 | 0.654240518341589 | 0.654240518341589 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 416640583440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T14:29:42.133638Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 6576c49b-bc31-4cce-b7c6-9e08f58350f9 | 2026-09-28 12:43 | 2026-09-28 12:43 | 2026-09-28 12:43 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 0.5100 | 0.5100 | 0.5300 | 133.0000 | 30600.00 | 0.00 | 30600.00 | 600 | 32 | 1009 | 1717 | 0.587652882935352 | 0.597081522692508 | 0.597081522692508 | false | false | false | true | ||||||||||||||||
| 26229738-4dee-4668-9da1-ec1dabde0999 | 2026-09-24 09:52 | 2026-09-24 09:52 | 2026-09-24 09:52 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 0.7300 | 0.7300 | 0.7900 | 134.4801 | 14600.00 | 0.00 | 14600.00 | 200 | 19 | 567 | 1444 | 0.392659279778393 | 0.536912260961662 | 0.536912260961662 | true | false | false | true | ||||||||||||||||
| 187a4c0f-c2b9-4dc0-96b5-2fd79681071d | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 3.1000 | 2.9500 | 3.1000 | 146.9400 | 84630.00 | 84630.00 | 0.00 | 273 | 6 | 657 | 1829 | 0.359212684527064 | 0.495338927501132 | 0.495338927501132 | false | false | false | true | ||||||||||||||||
| 8a87d88f-ae69-4a78-b1a9-b0465c1a322e | 2026-09-22 15:49 | 2026-09-22 15:49 | 2026-09-22 15:49 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.2500 | 4.2500 | 4.3000 | 149.5400 | 32300.00 | 0.00 | 32300.00 | 76 | 7 | 5996 | 639 | 9.38341158059468 | 0.49753127078442 | 0.49753127078442 | true | false | false | true | ||||||||||||||||
| f73c970d-b9ae-44cb-b65a-f1e29dd5244a | 2026-09-22 15:41 | 2026-09-22 15:41 | 2026-09-22 15:41 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.3000 | 4.3000 | 4.3500 | 149.6500 | 21930.00 | 0.00 | 21930.00 | 51 | 6 | 5792 | 639 | 9.0641627543036 | 0.498034092206529 | 0.498034092206529 | false | false | false | true | ||||||||||||||||
| 70efbc65-c578-48c1-b4bc-b15c96f47582 | 2026-09-22 15:41 | 2026-09-22 15:41 | 2026-09-22 15:41 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.3000 | 4.3000 | 4.3500 | 149.7199 | 17200.00 | 0.00 | 17200.00 | 40 | 5 | 5739 | 639 | 8.981220657277 | 0.495795689920747 | 0.495795689920747 | false | false | false | true | ||||||||||||||||
| 0e649211-f4fd-42d5-a471-81fd3275a27d | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.3500 | 4.3000 | 4.3500 | 149.6310 | 119591.00 | 119591.00 | 0.00 | 275 | 21 | 5591 | 639 | 8.74960876369327 | 0.502651557938912 | 0.502651557938912 | true | false | false | true | ||||||||||||||||
| 228e4183-ae18-4e67-9ce8-53c0e5ca104c | 2026-09-22 15:39 | 2026-09-22 15:39 | 2026-09-22 15:39 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.3500 | 4.3000 | 4.3500 | 149.6400 | 12615.00 | 3915.00 | 0.00 | 29 | 7 | 5004 | 639 | 7.83098591549296 | 0.502363054089302 | 0.502363054089302 | true | false | false | true | ||||||||||||||||
| 1185cabe-1b6d-41e4-8339-f0e31c38bdfb | 2026-09-22 14:17 | 2026-09-22 14:17 | 2026-09-22 14:17 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.3500 | 4.3500 | 4.4500 | 149.7800 | 13050.00 | 0.00 | 13050.00 | 30 | 6 | 4241 | 639 | 6.63693270735524 | 0.497868205913359 | 0.497868205913359 | false | false | false | true | ||||||||||||||||
| c80c481f-87f1-41d7-b53b-d98ff01cba73 | 2026-09-22 14:00 | 2026-09-22 14:00 | 2026-09-22 14:00 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.3000 | 4.2500 | 4.3000 | 149.5700 | 26648.00 | 26648.00 | 0.00 | 62 | 5 | 3992 | 639 | 6.24726134585289 | 0.500591909297221 | 0.500591909297221 | false | false | false | true | ||||||||||||||||
| eb7c6093-b1ef-4e39-b533-4e44f63ec444 | 2026-09-22 13:48 | 2026-09-22 13:48 | 2026-09-22 13:48 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 3.9500 | 3.9500 | 4.0000 | 148.8100 | 91640.00 | 0.00 | 91640.00 | 232 | 6 | 3712 | 639 | 5.80907668231612 | 0.496128614689697 | 0.496128614689697 | false | false | false | true | ||||||||||||||||
| 56b86319-df91-4877-a11f-b7a094d7b51f | 2026-09-22 13:20 | 2026-09-22 13:20 | 2026-09-22 13:20 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.1900 | 4.1500 | 4.2000 | 149.2950 | 125800.00 | 125800.00 | 0.00 | 300 | 23 | 2721 | 639 | 4.25821596244131 | 0.501278677196154 | 0.499662261817558 | false | false | false | true | ||||||||||||||||
| 0839e16c-512f-40e4-9674-fda518984102 | 2026-09-22 12:13 | 2026-09-22 12:13 | 2026-09-22 12:13 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.2000 | 4.2000 | 4.3000 | 149.4530 | 63000.00 | 0.00 | 63000.00 | 150 | 12 | 1573 | 639 | 2.46165884194053 | 0.496272715084701 | 0.496272715084701 | false | false | false | true | ||||||||||||||||
| dece5dc0-5c9f-4a5c-8e89-2ed01624dfef | 2026-09-22 11:44 | 2026-09-22 11:44 | 2026-09-22 11:44 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.4000 | 4.3500 | 4.4000 | 149.6500 | 10992.00 | 10992.00 | 0.00 | 25 | 5 | 1100 | 639 | 1.72143974960876 | 0.506047845892376 | 0.506047845892376 | false | false | false | true | ||||||||||||||||
| 8d3d2a75-8b49-44af-ad14-30c50c39246d | 2026-09-22 11:33 | 2026-09-22 11:33 | 2026-09-22 11:33 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.6500 | 4.6000 | 4.7000 | 150.0000 | 27900.00 | 14880.00 | 10695.00 | 60 | 8 | 778 | 639 | 1.21752738654147 | 0.506771086335707 | 0.506771086335707 | false | false | false | true | ||||||||||||||||
| 799d1140-ff5a-43ea-a722-c462a3739bc9 | 2026-09-22 11:32 | 2026-09-22 11:32 | 2026-09-22 11:32 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.6000 | 4.6000 | 4.7000 | 150.0000 | 15640.00 | 0.00 | 15640.00 | 34 | 14 | 693 | 639 | 1.08450704225352 | 0.504126606660223 | 0.506091286176358 | true | false | false | true | ||||||||||||||||
| aedc9f6b-7ee4-45f4-a312-429aaef04405 | 2026-09-22 11:32 | 2026-09-22 11:32 | 2026-09-22 11:32 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.6600 | 4.6500 | 4.7500 | 150.0000 | 11661.00 | 0.00 | 11661.00 | 25 | 6 | 642 | 639 | 1.00469483568075 | 0.503646428640867 | 0.506015434096608 | false | false | false | true | ||||||||||||||||
| 4374e3a2-d27b-4abe-a6ca-88eec42cf960 | 2026-09-22 11:32 | 2026-09-22 11:32 | 2026-09-22 11:32 | ORCL | ORCL261009C00155000 | call | 155.0000 | 2026-10-09 | 4.7000 | 4.7000 | 4.8000 | 150.0000 | 23030.00 | 0.00 | 23030.00 | 49 | 5 | 597 | 639 | 0.934272300469484 | 0.504787872910641 | 0.504787872910641 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 400947393600.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:49:03.667640Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:54:19.937301Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:54:01.895756Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:49:14.593703Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:23:35.118331Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:20:35.100506Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:49:01.734970Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |