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 |
|---|
| a8bc65a0-b99f-4e44-a82f-0afc92aade45 | 2026-09-23 11:51 | 2026-09-23 11:51 | 2026-09-23 11:51 | NOW | NOW260925C00141000 | call | 141.0000 | 2026-09-25 | 2.1700 | 2.1700 | 2.2700 | 140.0000 | 61628.00 | 0.00 | 61628.00 | 284 | 30 | 1483 | 1152 | 1.28732638888889 | 0.61483702825258 | 0.623169517023546 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 145566520000.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T15:54:47.930702Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 12969518-d232-48be-9141-ff2231582f93 | 2026-09-22 15:33 | 2026-09-22 15:33 | 2026-09-22 15:33 | NOW | NOW260925C00141000 | call | 141.0000 | 2026-09-25 | 1.7300 | 1.6600 | 1.7400 | 137.8200 | 14186.00 | 7266.00 | 6920.00 | 82 | 12 | 831 | 1046 | 0.794455066921606 | 0.605382441029932 | 0.603868595628797 | false | false | false | |||||||||||||||||
| c4d8d759-b09c-4f13-bfbb-1c0abb7d5264 | 2026-09-22 14:44 | 2026-09-22 14:44 | 2026-09-22 14:44 | NOW | NOW260925C00141000 | call | 141.0000 | 2026-09-25 | 1.5200 | 1.4700 | 1.5200 | 137.1600 | 11400.00 | 11400.00 | 0.00 | 75 | 13 | 701 | 1046 | 0.670172084130019 | 0.606319982440573 | 0.606319982440573 | false | false | false | |||||||||||||||||
| fe0cad96-ffe9-4e4e-b3f2-d2a26aa32a31 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | NOW | NOW260925C00141000 | call | 141.0000 | 2026-09-25 | 3.2500 | 3.2500 | 3.6500 | 140.6900 | 45500.00 | 0.00 | 45500.00 | 140 | 43 | 173 | 1046 | 0.165391969407266 | 0.663805414739542 | 0.663805414739542 | false | false | false | |||||||||||||||||
| 101de7e6-0cb0-4927-a7e8-2dba82a8ec8e | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | NOW | NOW260925C00141000 | call | 141.0000 | 2026-09-25 | 4.0000 | 3.5000 | 4.0000 | 141.7350 | 10800.00 | 10800.00 | 0.00 | 27 | 6 | 29 | 1046 | 0.0277246653919694 | 0.70355774596006 | 0.70355774596006 | false | false | false | |||||||||||||||||
| 787fb062-51fb-445c-8811-2197e390489f | 2026-09-21 12:03 | 2026-09-21 12:03 | 2026-09-21 12:03 | NOW | NOW260925C00141000 | call | 141.0000 | 2026-09-25 | 2.0000 | 1.9900 | 2.0600 | 137.4700 | 15400.00 | 0.00 | 8600.00 | 77 | 5 | 301 | 923 | 0.326110509209101 | 0.600818168295297 | 0.59551373754025 | false | false | false | |||||||||||||||||
| 45a00ad8-716c-4513-92cb-9dfb4b453af5 | 2026-09-14 12:54 | 2026-09-14 12:54 | 2026-09-14 12:54 | NOW | NOW260925C00141000 | call | 141.0000 | 2026-09-25 | 6.1000 | 6.1000 | 6.3000 | 142.1500 | 427620.00 | 0.00 | 427620.00 | 701 | 54 | 847 | 306 | 2.76797385620915 | 0.552923702352574 | 0.552923702352574 | false | false | false | |||||||||||||||||
| d31da555-a1ba-4203-ac37-59af39fd545b | 2026-08-27 15:09 | 2026-08-27 15:09 | 2026-08-27 15:09 | NOW | NOW260925C00141000 | call | 141.0000 | 2026-09-25 | 7.1200 | 7.1000 | 7.2000 | 138.2900 | 179410.00 | 66495.00 | 112915.00 | 252 | 27 | 265 | 22 | 12.0454545454545 | 0.526789919907944 | 0.526162113807634 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 141658000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 142361120000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:04:05.802260Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 147189900000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 147189900000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |