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_alerts425,429 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 | expirydate | price |
|---|
| 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 |
|---|
| 5fe404bc-7362-4df5-aef6-fe76d766f5db | 2026-09-24 13:40 | 2026-09-24 13:39 | 2026-09-24 13:39 | GKOS | GKOS261120C00180000 | call | 180.0000 | 2026-11-20 | 5.6000 | 4.8000 | 5.6000 | 155.8100 | 16800.00 | 16800.00 | 0.00 | 30 | 12 | 40 | 11 | 3.63636363636364 | 0.542284004179985 | 0.542284004179985 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 9053444490.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T17:43:31.900788Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 91d75c67-06a8-4883-9e84-88817a4d80ae | 2026-09-23 15:15 | 2026-09-23 15:14 | 2026-09-23 15:14 | GKOS | GKOS261016P00150000 | put | 150.0000 | 2026-10-16 | 5.0000 | 4.4000 | 5.0000 | 155.8600 | 60000.00 | 1500.00 | 0.00 | 120 | 74 | 137 | 465 | 0.294623655913978 | 0.505112388327494 | 0.505112388327494 | false | false | false | true | false | |||||||||||||||
| fe3c20db-2d72-45d3-842c-fab866cbc376 | 2026-09-14 10:48 | 2026-09-14 10:48 | 2026-09-14 10:48 | GKOS | GKOS261016P00170000 | put | 170.0000 | 2026-10-16 | 10.9000 | 10.9000 | 11.8000 | 167.6400 | 101370.00 | 0.00 | 101370.00 | 93 | 17 | 93 | 80 | 1.1625 | 0.502660018473291 | 0.502660018473291 | false | false | false | true | false | |||||||||||||||
| a396c79f-d28d-4281-8abf-8927b39e201e | 2026-09-10 15:47 | 2026-09-10 15:47 | 2026-09-10 15:47 | GKOS | GKOS261218C00200000 | call | 200.0000 | 2026-12-18 | 9.4300 | 8.3000 | 10.7000 | 172.2100 | 563914.00 | 0.00 | 563914.00 | 598 | 2 | 601 | 5 | 120.2 | 0.513058439263637 | 0.513058439263637 | false | true | true | false | true | |||||||||||||||
| 53cca2c2-48d7-4aad-933a-e78c2c69f9aa | 2026-09-08 14:27 | 2026-09-08 14:27 | 2026-09-08 14:27 | GKOS | GKOS261016P00175000 | put | 175.0000 | 2026-10-16 | 6.9000 | 6.9000 | 7.3000 | 184.8450 | 53820.00 | 0.00 | 53820.00 | 78 | 28 | 257 | 884 | 0.290723981900453 | 0.49424344153912 | 0.49424344153912 | false | false | false | true | false | |||||||||||||||
| c73d5da2-cebd-42b1-ac9e-bc84acc94e33 | 2026-09-08 13:25 | 2026-09-08 13:24 | 2026-09-08 13:24 | GKOS | GKOS261016P00175000 | put | 175.0000 | 2026-10-16 | 7.2100 | 7.2000 | 7.8000 | 184.1900 | 43250.00 | 0.00 | 43250.00 | 60 | 18 | 179 | 884 | 0.202488687782805 | 0.49808547756086 | 0.49808547756086 | false | false | false | true | false | |||||||||||||||
| cb8ac051-30fe-4be7-ad6f-f9f02d97fe9e | 2026-09-08 11:59 | 2026-09-08 11:59 | 2026-09-08 11:59 | GKOS | GKOS261016P00170000 | put | 170.0000 | 2026-10-16 | 5.8000 | 5.8000 | 6.5000 | 182.7750 | 34220.00 | 0.00 | 34220.00 | 59 | 17 | 64 | 4 | 16 | 0.498393097587133 | 0.498393097587133 | false | false | false | true | false | |||||||||||||||
| 01d5f9e6-9ead-44d9-868f-e67245e24455 | 2026-09-08 11:20 | 2026-09-08 11:20 | 2026-09-08 11:20 | GKOS | GKOS261016P00185000 | put | 185.0000 | 2026-10-16 | 12.4000 | 12.4000 | 13.0000 | 182.2750 | 44640.00 | 0.00 | 44640.00 | 36 | 8 | 36 | 12 | 3 | 0.483113546071648 | 0.483113546071648 | false | false | false | true | false | |||||||||||||||
| c0406334-0489-45b7-b3f0-c992e99a690e | 2026-09-08 10:50 | 2026-09-08 10:50 | 2026-09-08 10:50 | GKOS | GKOS261016P00165000 | put | 165.0000 | 2026-10-16 | 5.2000 | 5.2000 | 5.9000 | 179.0700 | 26520.00 | 0.00 | 26520.00 | 51 | 17 | 52 | 1 | 52 | 0.500330406804975 | 0.500330406804975 | false | false | false | true | false | |||||||||||||||
| 7e352837-6452-461d-bdac-e573ed1fb540 | 2026-09-03 11:53 | 2026-09-03 11:53 | 2026-09-03 11:53 | GKOS | GKOS261016P00180000 | put | 180.0000 | 2026-10-16 | 10.8000 | 10.8000 | 11.6000 | 180.5217 | 39960.00 | 0.00 | 39960.00 | 37 | 14 | 37 | 13 | 2.84615384615385 | 0.458888072382391 | 0.465837776182329 | false | false | false | true | false | |||||||||||||||
| 9b023cd5-8884-4937-bb0a-f3996bc45256 | 2026-09-01 09:35 | 2026-09-01 09:34 | 2026-09-01 09:34 | GKOS | GKOS261016P00175000 | put | 175.0000 | 2026-10-16 | 10.9000 | 8.0000 | 10.9000 | 179.0800 | 50140.00 | 50140.00 | 0.00 | 46 | 14 | 787 | 4 | 196.75 | 0.534846621644155 | 0.534846621644155 | false | false | false | true | false | |||||||||||||||
| 40647652-544b-4b02-9553-43bce49d48d9 | 2026-09-01 09:35 | 2026-09-01 09:34 | 2026-09-01 09:34 | GKOS | GKOS261016P00175000 | put | 175.0000 | 2026-10-16 | 10.3000 | 8.4000 | 10.9000 | 179.0800 | 99910.00 | 22660.00 | 13390.00 | 97 | 6 | 545 | 4 | 136.25 | 0.510208684416953 | 0.510208684416953 | false | false | false | true | false | |||||||||||||||
| a1cdb582-7647-4bca-9843-ec5b381453b1 | 2026-09-01 09:34 | 2026-09-01 09:34 | 2026-09-01 09:34 | GKOS | GKOS261016P00175000 | put | 175.0000 | 2026-10-16 | 9.8000 | 9.8000 | 11.0000 | 179.2300 | 115640.00 | 0.00 | 115640.00 | 118 | 6 | 448 | 4 | 112 | 0.492137171519264 | 0.492137171519264 | false | false | false | true | false | |||||||||||||||
| 6633bbc1-9184-47ad-99a8-44541568e4d9 | 2026-09-01 09:34 | 2026-09-01 09:34 | 2026-09-01 09:34 | GKOS | GKOS261016P00175000 | put | 175.0000 | 2026-10-16 | 9.9000 | 9.9000 | 11.1000 | 180.1400 | 68310.00 | 0.00 | 58410.00 | 69 | 5 | 197 | 4 | 49.25 | 0.511061541540343 | 0.511061541540343 | false | false | false | true | false | |||||||||||||||
| 2d8a3b33-884a-41e7-8024-f9d7b47848ac | 2026-09-01 09:34 | 2026-09-01 09:34 | 2026-09-01 09:34 | GKOS | GKOS261016P00175000 | put | 175.0000 | 2026-10-16 | 9.6000 | 9.6000 | 9.9000 | 180.1400 | 107520.00 | 0.00 | 107520.00 | 112 | 7 | 330 | 4 | 82.5 | 0.498701059818627 | 0.498701059818627 | false | false | false | true | false | |||||||||||||||
| c6598286-5beb-43a5-9123-fec5973ed167 | 2026-09-01 09:34 | 2026-09-01 09:34 | 2026-09-01 09:34 | GKOS | GKOS261016P00175000 | put | 175.0000 | 2026-10-16 | 9.5000 | 9.5000 | 11.1000 | 180.1400 | 121600.00 | 0.00 | 121600.00 | 128 | 5 | 128 | 4 | 32 | 0.494578937380461 | 0.494578937380461 | false | false | false | true | false | |||||||||||||||
| 71073cf5-6ce2-44da-a7f1-4e80fd776fb5 | 2026-08-31 15:49 | 2026-08-31 15:49 | 2026-08-31 15:49 | GKOS | GKOS261016P00160000 | put | 160.0000 | 2026-10-16 | 4.0000 | 4.0000 | 5.1000 | 178.9800 | 28000.00 | 0.00 | 28000.00 | 70 | 20 | 73 | 2 | 36.5 | 0.469481633987316 | 0.469481633987316 | false | false | false | true | false | |||||||||||||||
| b41dbcf6-d687-4f4e-96d4-d7730b4884c9 | 2026-08-25 15:33 | 2026-08-25 15:33 | 2026-08-25 15:33 | GKOS | GKOS260918P00170000 | put | 170.0000 | 2026-09-18 | 3.6000 | 3.4000 | 3.6000 | 180.2800 | 15120.00 | 15120.00 | 0.00 | 42 | 6 | 131 | 19 | 6.89473684210526 | 0.436966995882715 | 0.436966995882715 | false | false | false | true | false | |||||||||||||||
| c0536cad-99e9-426f-a2bd-2a1ce40bdcc1 | 2026-08-21 15:37 | 2026-08-21 15:37 | 2026-08-21 15:37 | GKOS | GKOS261016P00180000 | put | 180.0000 | 2026-10-16 | 9.7000 | 9.7000 | 10.7000 | 186.0000 | 11640.00 | 0.00 | 11640.00 | 12 | 9 | 12 | 1 | 12 | 0.453660148381544 | 0.453660148381544 | false | false | false | true | false | |||||||||||||||
| d562f5e6-7b3d-4d99-a006-8543e20c500d | 2026-08-20 13:45 | 2026-08-20 13:45 | 2026-08-20 13:45 | GKOS | GKOS260918P00180000 | put | 180.0000 | 2026-09-18 | 6.3000 | 6.3000 | 6.7000 | 185.2800 | 49770.00 | 0.00 | 49770.00 | 79 | 8 | 170 | 2 | 85 | 0.434704098016653 | 0.434704098016653 | false | false | false | true | false | |||||||||||||||
| a5aca8ab-19a7-47ac-9615-02a17eec9a3e | 2026-08-20 13:44 | 2026-08-20 13:44 | 2026-08-20 13:44 | GKOS | GKOS260918P00180000 | put | 180.0000 | 2026-09-18 | 6.2000 | 6.2000 | 6.7000 | 185.2700 | 46500.00 | 0.00 | 46500.00 | 75 | 5 | 91 | 2 | 45.5 | 0.429459027831033 | 0.429459027831033 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 9053444490.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10091561781.00 |
| 2026-11-04 |
| 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 |