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_alerts326,449 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 |
|---|
| 6ae00637-c969-4a34-9ffa-65a55edfcc55 | 2026-08-24 12:23 | 2026-08-24 12:23 | 2026-08-24 12:23 | CSGP | CSGP261016C00035000 | call | 35.0000 | 2026-10-16 | 1.5500 | 1.4500 | 1.6000 | 32.5000 | 16275.00 | 15965.00 | 0.00 | 105 | 20 | 137 | 510 | 0.268627450980392 | 0.497143239654562 | 0.497143239654562 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Real Estate | 12771827974.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:44:07.615841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f564b74a-ae62-4f7c-a089-3e16cfbf53d5 | 2026-08-25 09:32 | 2026-08-25 09:32 | 2026-08-25 09:32 | CSGP | CSGP270319P00035000 | put | 35.0000 | 2027-03-19 | 6.1000 | 6.0000 | 6.5000 | 32.2950 | 122000.00 | 14640.00 | 1220.00 | 200 | 7 | 200 | 917 | 0.218102508178844 | 0.513499735216888 | 0.513499735216888 | false | false | false | true | false | |||||||||||||||
| 83a907a8-8a6f-4bed-85ef-f430514777df | 2026-08-25 13:19 | 2026-08-25 13:19 | 2026-08-25 13:19 | CSGP | CSGP261218C00035000 | call | 35.0000 | 2026-12-18 | 3.1000 | 3.0000 | 3.1000 | 32.8650 | 12400.00 | 12400.00 | 0.00 | 40 | 16 | 79 | 175 | 0.451428571428571 | 0.517689550228654 | 0.517689550228654 | false | false | false | true | false | |||||||||||||||
| c31e68a0-4008-41c8-8697-f3736782918a | 2026-08-28 12:26 | 2026-08-28 12:26 | 2026-08-28 12:26 | CSGP | CSGP260918C00030000 | call | 30.0000 | 2026-09-18 | 2.9800 | 2.5500 | 3.2000 | 32.4300 | 17854.00 | 17854.00 | 0.00 | 60 | 9 | 60 | 432 | 0.138888888888889 | 0.470858354939871 | 0.470858354939871 | false | false | false | true | false | |||||||||||||||
| 5593f961-8afe-4011-9803-52fb319c7a74 | 2026-09-02 11:49 | 2026-09-02 11:49 | 2026-09-02 11:49 | CSGP | CSGP261218C00035000 | call | 35.0000 | 2026-12-18 | 2.3500 | 2.2500 | 2.4000 | 31.5500 | 425350.00 | 413365.00 | 11985.00 | 1810 | 20 | 1933 | 223 | 8.66816143497758 | 0.516264132040746 | 0.516264132040746 | false | false | false | true | false | |||||||||||||||
| 48b29cb9-6fdf-4abd-b468-92772505c031 | 2026-09-03 13:46 | 2026-09-03 13:46 | 2026-09-03 13:46 | CSGP | CSGP261218C00040000 | call | 40.0000 | 2026-12-18 | 1.4000 | 1.1000 | 1.4000 | 31.9300 | 44096.00 | 44096.00 | 0.00 | 315 | 30 | 374 | 355 | 1.05352112676056 | 0.543892243620285 | 0.543892243620285 | false | false | false | true | false | |||||||||||||||
| 1c208361-7ac7-49ec-af77-d7738e57d2d9 | 2026-09-04 10:25 | 2026-09-04 10:25 | 2026-09-04 10:25 | CSGP | CSGP261218C00040000 | call | 40.0000 | 2026-12-18 | 1.0500 | 0.9500 | 1.0500 | 30.7500 | 15435.00 | 15435.00 | 0.00 | 147 | 8 | 248 | 718 | 0.345403899721448 | 0.537626779144885 | 0.537626779144885 | false | false | false | true | false | |||||||||||||||
| a202206e-c470-47e1-a799-e2693737ed28 | 2026-09-08 10:53 | 2026-09-08 10:53 | 2026-09-08 10:53 | CSGP | CSGP260918P00030000 | put | 30.0000 | 2026-09-18 | 0.7500 | 0.7000 | 0.9500 | 30.1800 | 28950.00 | 16650.00 | 12300.00 | 386 | 25 | 592 | 5161 | 0.114706452237938 | 0.442236921450977 | 0.428812678800034 | true | false | false | true | false | |||||||||||||||
| 2bd54c2f-9f45-4d86-85b5-4eb1556d77d2 | 2026-09-08 10:53 | 2026-09-08 10:53 | 2026-09-08 10:53 | CSGP | CSGP260918P00030000 | put | 30.0000 | 2026-09-18 | 0.7500 | 0.7000 | 0.9500 | 30.1900 | 28500.00 | 20775.00 | 7575.00 | 380 | 18 | 973 | 5161 | 0.188529354776206 | 0.4321951438852 | 0.431069658141382 | false | false | false | true | false | |||||||||||||||
| 1c9f9437-9180-4bde-9459-ddb6f9225ab0 | 2026-09-08 10:54 | 2026-09-08 10:54 | 2026-09-08 10:54 | CSGP | CSGP260918P00030000 | put | 30.0000 | 2026-09-18 | 0.7500 | 0.7000 | 0.9500 | 30.1900 | 148350.00 | 450.00 | 147900.00 | 1978 | 12 | 3090 | 5161 | 0.598721178066266 | 0.431069658141382 | 0.431069658141382 | false | false | false | true | false | |||||||||||||||
| 1fa79c23-525c-4d53-ba45-0724f2d576d0 | 2026-09-08 11:37 | 2026-09-08 11:37 | 2026-09-08 11:37 | CSGP | CSGP260918P00030000 | put | 30.0000 | 2026-09-18 | 1.0000 | 0.9500 | 1.0500 | 29.8600 | 13301.00 | 1100.00 | 10701.00 | 133 | 6 | 3652 | 5161 | 0.707614803332687 | 0.483374758884145 | 0.4783030511705 | false | false | false | true | false | |||||||||||||||
| 3daf3d17-b630-4fb6-a6c5-22b3385c60fa | 2026-09-08 12:03 | 2026-09-08 12:03 | 2026-09-08 12:03 | CSGP | CSGP260918C00030000 | call | 30.0000 | 2026-09-18 | 0.8500 | 0.7500 | 0.8500 | 29.6650 | 16235.00 | 16235.00 | 0.00 | 191 | 20 | 211 | 375 | 0.562666666666667 | 0.5052799315993 | 0.5052799315993 | false | false | false | true | false | |||||||||||||||
| 6f896f00-eb3d-483e-8aac-2e4f3e362f8a | 2026-09-09 11:28 | 2026-09-09 11:28 | 2026-09-09 11:28 | CSGP | CSGP270319P00030000 | put | 30.0000 | 2027-03-19 | 4.3000 | 4.3000 | 4.5000 | 29.6800 | 38270.00 | 0.00 | 38270.00 | 89 | 17 | 283 | 313 | 0.904153354632588 | 0.52678274238487 | 0.52678274238487 | false | false | false | true | false | |||||||||||||||
| ee121f40-5a4a-43e2-a4f0-f20578d1f709 | 2026-09-09 14:42 | 2026-09-09 14:42 | 2026-09-09 14:42 | CSGP | CSGP280121C00085000 | call | 85.0000 | 2028-01-21 | 0.6000 | 0.5500 | 0.6000 | 29.6250 | 30000.00 | 30000.00 | 0.00 | 500 | 5 | 1500 | 1943 | 0.772002058672156 | 0.51785136072793 | 0.51785136072793 | false | false | false | true | false | |||||||||||||||
| da7054f7-7908-4910-a8ac-4676b722d8bd | 2026-09-10 10:29 | 2026-09-10 10:29 | 2026-09-10 10:29 | CSGP | CSGP261218C00040000 | call | 40.0000 | 2026-12-18 | 0.8500 | 0.6500 | 0.8500 | 29.5000 | 16065.00 | 16065.00 | 0.00 | 189 | 12 | 198 | 1257 | 0.157517899761337 | 0.568275761598939 | 0.568275761598939 | false | false | false | true | false | |||||||||||||||
| 5f6736c5-67ad-457f-9793-8b288d716882 | 2026-09-15 10:54 | 2026-09-15 10:54 | 2026-09-15 10:54 | CSGP | CSGP261016C00035000 | call | 35.0000 | 2026-10-16 | 0.6000 | 0.5500 | 0.6500 | 31.0000 | 41280.00 | 60.00 | 41220.00 | 688 | 18 | 689 | 921 | 0.748099891422367 | 0.508094418226188 | 0.508094418226188 | false | false | false | true | false | |||||||||||||||
| 3b105036-6ee6-45c6-bed7-40aa88ea51d8 | 2026-09-16 12:57 | 2026-09-16 12:57 | 2026-09-16 12:57 | CSGP | CSGP270115P00030000 | put | 30.0000 | 2027-01-15 | 2.9500 | 2.9500 | 3.0000 | 30.9420 | 24780.00 | 0.00 | 24780.00 | 84 | 17 | 85 | 2271 | 0.0374284456186702 | 0.517883355588088 | 0.517883355588088 | false | false | false | true | false | |||||||||||||||
| 213efefb-7357-4bdd-802b-ea6e6162ea47 | 2026-09-18 10:41 | 2026-09-18 10:41 | 2026-09-18 10:41 | CSGP | CSGP270319P00020000 | put | 20.0000 | 2027-03-19 | 0.7000 | 0.7000 | 0.7500 | 29.7700 | 10920.00 | 0.00 | 10920.00 | 156 | 8 | 664 | 24 | 27.6666666666667 | 0.560909386608104 | 0.560635368109861 | false | false | false | true | false | |||||||||||||||
| cb5908af-1b37-4530-8444-d03c682ddc69 | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | CSGP | CSGP260918P00030000 | put | 30.0000 | 2026-09-18 | 0.7500 | 0.7500 | 0.8000 | 29.2600 | 56475.00 | 0.00 | 56475.00 | 753 | 6 | 830 | 8746 | 0.0949005259547222 | 2.72986185534113 | 3.09382631815127 | false | false | false | true | false | |||||||||||||||
| 6be5017b-0282-45c1-94e8-b4c1fbfd2172 | 2026-09-21 13:02 | 2026-09-21 13:02 | 2026-09-21 13:02 | CSGP | CSGP270115P00030000 | put | 30.0000 | 2027-01-15 | 3.5000 | 3.4000 | 3.5000 | 29.5150 | 88821.00 | 88821.00 | 0.00 | 254 | 20 | 255 | 2275 | 0.112087912087912 | 0.517540144363267 | 0.522102139492999 | true | false | false | true | false | |||||||||||||||
| 4e1ae9b7-5fee-46cc-b968-a1d4834e4f49 | 2026-09-22 15:16 | 2026-09-22 15:16 | 2026-09-22 15:16 | CSGP | CSGP280121C00030000 | call | 30.0000 | 2028-01-21 | 7.0000 | 7.0000 | 7.4000 | 28.8395 | 16802.00 | 0.00 | 16802.00 | 24 | 5 | 45 | 539 | 0.0834879406307978 | 0.516242707207291 | 0.514647884411964 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:41:46.514863Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:26:05.443569Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| 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 |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| 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 |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| 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 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:43:32.720264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12771827974.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 12301798772.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 11787197835.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 11787197835.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Real Estate |
| 11766937956.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:07:15.058898Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 11657534607.00 |
| 2026-10-27 |
| 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 |