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 |
|---|
| 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 |
|---|
| e7b46c43-4e74-4e45-9a47-e700f90b6098 | 2026-08-19 12:04 | 2026-08-19 12:04 | 2026-08-19 12:04 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3500 | 0.2500 | 0.3500 | 34.2900 | 35000.00 | 35000.00 | 0.00 | 1000 | 7 | 6964 | 46272 | 0.150501383125864 | 0.479604455292382 | 0.479604455292382 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 15363736512.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 442759c8-44df-454d-af5b-a82eb425e5d1 | 2026-08-19 12:02 | 2026-08-19 12:02 | 2026-08-19 12:02 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3500 | 0.2500 | 0.3500 | 34.2650 | 35000.00 | 35000.00 | 0.00 | 1000 | 40 | 5943 | 46272 | 0.128436203319502 | 0.481246995141661 | 0.481246995141661 | false | false | false | true | ||||||||||||||||
| 2627b55d-d2a6-44fc-b9db-4ccccd0958c6 | 2026-08-19 12:02 | 2026-08-19 12:02 | 2026-08-19 12:02 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3500 | 0.2500 | 0.3500 | 34.1900 | 34453.00 | 34453.00 | 0.00 | 986 | 62 | 4941 | 46272 | 0.106781639004149 | 0.486175176442171 | 0.486175176442171 | false | false | false | true | ||||||||||||||||
| 948f0caf-6c00-4175-ae5f-2559ffcb0880 | 2026-08-18 11:10 | 2026-08-18 11:10 | 2026-08-18 11:10 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.2500 | 0.2000 | 0.3000 | 33.4100 | 15266.00 | 616.00 | 13825.00 | 608 | 19 | 47993 | 5299 | 9.05699188526137 | 0.47972212403954 | 0.47972212403954 | false | false | false | true | ||||||||||||||||
| 13c77ed1-bddc-43a2-8b4f-65095d61c085 | 2026-08-18 10:25 | 2026-08-18 10:25 | 2026-08-18 10:25 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3500 | 0.3500 | 0.4000 | 34.1600 | 31053.00 | 0.00 | 31053.00 | 887 | 18 | 45551 | 5299 | 8.59615021702208 | 0.479925789628276 | 0.479925789628276 | false | false | false | true | ||||||||||||||||
| 39c96628-d610-46fb-bd59-ddb61683bfaa | 2026-08-18 10:16 | 2026-08-18 10:16 | 2026-08-18 10:16 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3000 | 0.3000 | 0.3500 | 33.9200 | 45104.00 | 0.00 | 45104.00 | 1500 | 24 | 43892 | 5299 | 8.28307227778826 | 0.480149618491346 | 0.472851874843708 | false | false | false | true | ||||||||||||||||
| eadab151-5536-40fc-976c-ee9f864332f7 | 2026-08-18 10:09 | 2026-08-18 10:09 | 2026-08-18 10:09 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3000 | 0.2500 | 0.3500 | 33.7950 | 80916.00 | 3032.00 | 77884.00 | 2693 | 8 | 41340 | 5299 | 7.8014719758445 | 0.480713061087371 | 0.480713061087371 | false | false | false | true | ||||||||||||||||
| 2cf1c08b-f818-4f72-b4e2-12e23cf6d029 | 2026-08-18 10:08 | 2026-08-18 10:08 | 2026-08-18 10:08 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3500 | 0.3000 | 0.3500 | 33.9250 | 11655.00 | 11655.00 | 0.00 | 333 | 10 | 38097 | 5299 | 7.18946971126628 | 0.495127363583488 | 0.495127363583488 | true | false | false | true | ||||||||||||||||
| 13af02f3-0dd5-43e6-8033-1469d3780044 | 2026-08-18 10:08 | 2026-08-18 10:08 | 2026-08-18 10:08 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3000 | 0.2500 | 0.3500 | 33.7200 | 19080.00 | 150.00 | 18900.00 | 636 | 6 | 37713 | 5299 | 7.11700320815248 | 0.485432364633667 | 0.485432364633667 | false | false | false | true | ||||||||||||||||
| f6361f64-9729-40c4-98e2-e903670743ca | 2026-08-18 10:08 | 2026-08-18 10:08 | 2026-08-18 10:08 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3000 | 0.2000 | 0.3000 | 33.6900 | 29760.00 | 29760.00 | 0.00 | 992 | 23 | 37077 | 5299 | 6.99698056237026 | 0.48732067674415 | 0.48732067674415 | true | false | false | true | ||||||||||||||||
| 7a8ff5dc-1bf3-4cad-a407-beafbaa24821 | 2026-08-18 10:08 | 2026-08-18 10:08 | 2026-08-18 10:08 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3000 | 0.2000 | 0.3000 | 33.6200 | 169497.00 | 169497.00 | 0.00 | 5650 | 43 | 35857 | 5299 | 6.76674844310247 | 0.491728127958133 | 0.491728127958133 | true | false | false | true | ||||||||||||||||
| 9d7ceac6-adc7-4c31-9afb-3176c9293617 | 2026-08-18 10:03 | 2026-08-18 10:03 | 2026-08-18 10:03 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.3000 | 0.2500 | 0.3500 | 33.8500 | 48927.00 | 37887.00 | 11040.00 | 1631 | 37 | 28823 | 5299 | 5.43932817512738 | 0.47915927857996 | 0.477253506312024 | false | false | false | true | ||||||||||||||||
| 340ecd2c-19f7-4032-8a65-238217acc23c | 2026-08-18 10:03 | 2026-08-18 10:03 | 2026-08-18 10:03 | AS | AS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.2500 | 0.2000 | 0.3000 | 33.8100 | 24525.00 | 16075.00 | 8450.00 | 981 | 33 | 26582 | 5299 | 5.01641819211172 | 0.459610411539531 | 0.455350170705129 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 15363736512.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |