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_alerts474,253 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 |
|---|
| 5ff42425-a550-485e-a018-6ac793df3332 | 2026-08-17 14:22 | 2026-08-17 14:22 | 2026-08-17 14:22 | BULL | BULL260821C00008500 | call | 8.5000 | 2026-08-21 | 0.2300 | 0.2200 | 0.2500 | 8.2000 | 35496.00 | 0.00 | 30482.00 | 1529 | 37 | 3892 | 5275 | 0.73781990521327 | 1.0543688558111 | 1.03007332246017 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 3984070552.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c7752a58-65b5-41cb-9649-e49601645fdc | 2026-08-17 14:23 | 2026-08-17 14:23 | 2026-08-17 14:23 | BULL | BULL261120C00010000 | call | 10.0000 | 2026-11-20 | 0.5300 | 0.5200 | 0.5600 | 8.1950 | 13914.00 | 0.00 | 13914.00 | 262 | 6 | 349 | 20581 | 0.0169573878820271 | 0.659654040418751 | 0.653167375389281 | true | false | false | true | ||||||||||||||||
| 8d20d9fe-8b9b-4fe8-bc22-231303d98ad4 | 2026-08-19 10:36 | 2026-08-19 10:36 | 2026-08-19 10:36 | BULL | BULL270115C00010000 | call | 10.0000 | 2027-01-15 | 0.7900 | 0.7900 | 0.8600 | 8.2650 | 30630.00 | 0.00 | 30630.00 | 387 | 11 | 826 | 74399 | 0.0111022997620936 | 0.636733808426189 | 0.631181582967001 | false | false | false | |||||||||||||||||
| 04e29c84-ca30-4862-b098-68447ee41f36 | 2026-08-19 10:36 | 2026-08-19 10:36 | 2026-08-19 10:36 | BULL | BULL270115C00010000 | call | 10.0000 | 2027-01-15 | 0.7900 | 0.7900 | 0.8600 | 8.2650 | 39677.00 | 0.00 | 39677.00 | 500 | 17 | 1326 | 74399 | 0.0178228201991962 | 0.645783013594965 | 0.631181582967001 | true | false | false | |||||||||||||||||
| 77cf71bb-8ab8-4c37-92ef-5a950520071d | 2026-08-20 09:44 | 2026-08-20 09:44 | 2026-08-20 09:44 | BULL | BULL260918C00010000 | call | 10.0000 | 2026-09-18 | 0.5300 | 0.5100 | 0.5900 | 9.7100 | 33169.00 | 53.00 | 33116.00 | 626 | 42 | 7550 | 30918 | 0.244194320460573 | 0.581119686968497 | 0.589769765645282 | true | false | false | |||||||||||||||||
| 9d10dc46-784e-4af0-ab36-2603efd10ec7 | 2026-08-20 13:22 | 2026-08-20 13:21 | 2026-08-20 13:21 | BULL | BULL280121P00005000 | put | 5.0000 | 2028-01-21 | 0.5100 | 0.5000 | 0.5600 | 8.9850 | 25639.00 | 0.00 | 25588.00 | 501 | 15 | 18307 | 8536 | 2.14468134957826 | 0.636805615985787 | 0.631809257434112 | true | false | false | true | ||||||||||||||||
| 6db1662b-4521-4dd2-b7ed-01849ea8615b | 2026-08-21 09:31 | 2026-08-21 09:31 | 2026-08-21 09:31 | BULL | BULL260821C00008000 | call | 8.0000 | 2026-08-21 | 0.6800 | 0.6500 | 0.7900 | 8.7300 | 12590.00 | 0.00 | 12590.00 | 186 | 6 | 351 | 51661 | 0.00679429356768162 | 3.19545027763838 | 3.00640188176982 | false | false | false | true | ||||||||||||||||
| ff304402-52f8-412a-b5a7-197102ec1ba8 | 2026-08-21 09:52 | 2026-08-21 09:52 | 2026-08-21 09:52 | BULL | BULL261120C00015000 | call | 15.0000 | 2026-11-20 | 0.1500 | 0.0900 | 0.1600 | 9.3750 | 14937.00 | 14937.00 | 0.00 | 1000 | 13 | 1007 | 765 | 1.31633986928105 | 0.668781706873222 | 0.668781706873222 | true | false | false | true | ||||||||||||||||
| dcd6569e-efe9-422b-b4f1-43448c47e865 | 2026-08-21 09:55 | 2026-08-21 09:55 | 2026-08-21 09:55 | BULL | BULL280121C00012500 | call | 12.5000 | 2028-01-21 | 1.8500 | 1.8200 | 1.9900 | 9.3900 | 84017.00 | 0.00 | 84017.00 | 455 | 43 | 495 | 39348 | 0.012580054894785 | 0.597470611507219 | 0.590744338110851 | true | false | false | true | ||||||||||||||||
| 407b7b2b-58e0-4caa-8f58-5177b27da1db | 2026-08-21 10:03 | 2026-08-21 10:03 | 2026-08-21 10:03 | BULL | BULL260821C00009000 | call | 9.0000 | 2026-08-21 | 0.5500 | 0.5200 | 0.5900 | 9.5400 | 14021.00 | 13805.00 | 216.00 | 255 | 6 | 11833 | 19919 | 0.594055926502334 | 1.90947968347014 | 2.31834082407196 | false | false | false | true | ||||||||||||||||
| 9551c9ae-55be-4879-a374-e408b130f62e | 2026-08-21 16:00 | 2026-08-21 15:59 | 2026-08-21 15:59 | BULL | BULL260828C00009000 | call | 9.0000 | 2026-08-28 | 0.2400 | 0.2300 | 0.2500 | 8.7750 | 16581.00 | 0.00 | 16581.00 | 699 | 18 | 9492 | 4009 | 2.36767273634323 | 0.689027436870297 | 0.667919027517451 | true | false | false | true | ||||||||||||||||
| 33bf263a-4ad4-4524-b723-67228139e699 | 2026-08-25 14:06 | 2026-08-25 14:06 | 2026-08-25 14:06 | BULL | BULL280121C00010000 | call | 10.0000 | 2028-01-21 | 2.3500 | 2.3300 | 2.4300 | 9.0000 | 33168.00 | 236.00 | 32932.00 | 141 | 16 | 530 | 46273 | 0.0114537635338102 | 0.600033622472944 | 0.598337843269453 | true | false | false | |||||||||||||||||
| 27558ee4-a7b1-4d93-a6e4-f4d371df10ee | 2026-09-01 10:25 | 2026-09-01 10:25 | 2026-09-01 10:25 | BULL | BULL270115C00010000 | call | 10.0000 | 2027-01-15 | 1.1700 | 1.1500 | 1.1700 | 9.2950 | 45728.00 | 45728.00 | 0.00 | 391 | 12 | 584 | 72289 | 0.00807868417048237 | 0.617818288768886 | 0.617818288768886 | true | false | false | |||||||||||||||||
| cb83f704-5e1a-4e69-8aa3-d8e12acaf214 | 2026-09-15 14:43 | 2026-09-15 14:42 | 2026-09-15 14:42 | BULL | BULL280121C00012500 | call | 12.5000 | 2028-01-21 | 1.5000 | 1.4900 | 1.5400 | 8.5600 | 38184.00 | 0.00 | 38184.00 | 255 | 15 | 613 | 39212 | 0.0156329694991329 | 0.623316138357803 | 0.623316138357803 | false | false | false | |||||||||||||||||
| 8a15714d-277b-4c64-99e6-11f214053ba0 | 2026-09-16 09:39 | 2026-09-16 09:39 | 2026-09-16 09:39 | BULL | BULL270115P00007500 | put | 7.5000 | 2027-01-15 | 0.6900 | 0.6900 | 0.7600 | 8.2250 | 67521.00 | 0.00 | 67521.00 | 973 | 20 | 1803 | 8588 | 0.209944108057755 | 0.597215546293705 | 0.590039475652015 | false | false | false | true | ||||||||||||||||
| f3c4f1ba-6aa0-4183-b9a6-8d3512deb899 | 2026-09-18 09:52 | 2026-09-18 09:51 | 2026-09-18 09:51 | BULL | BULL280121C00012500 | call | 12.5000 | 2028-01-21 | 1.2100 | 1.2000 | 1.2900 | 8.0200 | 121966.00 | 738.00 | 121228.00 | 1006 | 55 | 1042 | 39860 | 0.0261414952333166 | 0.611448155198212 | 0.608703719567882 | true | false | false | |||||||||||||||||
| b92b96e2-c663-4072-ae22-fbac9a0d43ea | 2026-09-18 09:58 | 2026-09-18 09:58 | 2026-09-18 09:58 | BULL | BULL260925C00008500 | call | 8.5000 | 2026-09-25 | 0.1500 | 0.0900 | 0.1500 | 8.0499 | 15028.00 | 15000.00 | 28.00 | 1002 | 29 | 4656 | 1593 | 2.92278719397363 | 0.726492007157104 | 0.685516378998766 | false | false | false | |||||||||||||||||
| 51e092b0-a1eb-4ef3-b4de-c666c0347696 | 2026-09-21 11:03 | 2026-09-21 11:03 | 2026-09-21 11:03 | BULL | BULL261030C00013000 | call | 13.0000 | 2026-10-30 | 0.0500 | 0.0200 | 0.0600 | 8.3250 | 15828.00 | 15828.00 | 0.00 | 3000 | 15 | 3001 | 1 | 3001 | 0.827061086734954 | 0.797394062915489 | true | false | false | true | ||||||||||||||||
| f0c4c86c-d2ed-409e-bbf0-7a4f9191895b | 2026-09-22 15:16 | 2026-09-22 15:16 | 2026-09-22 15:16 | BULL | BULL261016C00007500 | call | 7.5000 | 2026-10-16 | 0.8500 | 0.8500 | 1.0200 | 8.1350 | 11490.00 | 0.00 | 11490.00 | 135 | 12 | 137 | 19253 | 0.00711577416506518 | 0.606901597548123 | 0.562811638749288 | false | false | false | |||||||||||||||||
| fb735f3c-a73d-4d1c-ab9d-211c362c824b | 2026-09-23 13:10 | 2026-09-23 13:10 | 2026-09-23 13:10 | BULL | BULL270115C00007500 | call | 7.5000 | 2027-01-15 | 1.2000 | 1.2000 | 1.2700 | 7.7499 | 56161.00 | 0.00 | 56161.00 | 468 | 8 | 662 | 34662 | 0.0190987248283423 | 0.610559961653987 | 0.604496051139008 | false | false | false | true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3984070552.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3389104264.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3635905094.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3635905094.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3635905094.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3565390571.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3371475633.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:11:20.356460Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |