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 |
|---|
| 6cdfaf8e-cf53-45fc-8674-3552a1e46a33 | 2026-08-17 10:07 | 2026-08-17 10:07 | 2026-08-17 10:07 | DNN | DNN280121C00004000 | call | 4.0000 | 2028-01-21 | 0.7500 | 0.7500 | 0.9000 | 3.1350 | 10050.00 | 0.00 | 10050.00 | 134 | 10 | 756 | 16585 | 0.0455833584564365 | 0.646667517566594 | 0.646667517566594 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 2605655646.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d25a0b51-7a07-43b9-95ee-a9e0420fcdde | 2026-08-17 10:48 | 2026-08-17 10:48 | 2026-08-17 10:48 | DNN | DNN270115C00004500 | call | 4.5000 | 2027-01-15 | 0.3500 | 0.1500 | 0.3500 | 3.2350 | 34600.00 | 33940.00 | 660.00 | 1000 | 27 | 1000 | 9079 | 0.110144289018614 | 0.711653129457452 | 0.841237083709786 | false | false | false | true | ||||||||||||||||
| 007a6f73-f952-4ba8-9ab8-7a5206287920 | 2026-08-19 12:04 | 2026-08-19 12:04 | 2026-08-19 12:04 | DNN | DNN270115C00004500 | call | 4.5000 | 2027-01-15 | 0.3500 | 0.2000 | 0.3500 | 3.2088 | 104768.00 | 104768.00 | 0.00 | 3000 | 5 | 3013 | 10036 | 0.300219210840972 | 0.834030422027669 | 0.859807921472331 | false | false | false | true | ||||||||||||||||
| d75a8e6b-dfb6-4908-b15b-08d246d6cc6e | 2026-08-21 10:31 | 2026-08-21 10:31 | 2026-08-21 10:31 | DNN | DNN280121C00004500 | call | 4.5000 | 2028-01-21 | 0.7500 | 0.7500 | 0.8000 | 3.3800 | 14925.00 | 0.00 | 14925.00 | 199 | 10 | 2830 | 8315 | 0.340348767288034 | 0.641012351015581 | 0.641012351015581 | true | false | false | true | ||||||||||||||||
| ae8ce4e9-c1bc-4932-92b6-5794ce0ce8e1 | 2026-08-21 10:31 | 2026-08-21 10:31 | 2026-08-21 10:31 | DNN | DNN280121C00004500 | call | 4.5000 | 2028-01-21 | 0.7500 | 0.7500 | 0.8000 | 3.3800 | 14925.00 | 0.00 | 14925.00 | 199 | 14 | 2433 | 8315 | 0.292603728202044 | 0.641012351015581 | 0.641012351015581 | true | false | false | true | ||||||||||||||||
| 5ae2c9af-a949-4714-9e2f-6daffa6ca0b3 | 2026-08-21 10:41 | 2026-08-21 10:41 | 2026-08-21 10:41 | DNN | DNN280121C00004500 | call | 4.5000 | 2028-01-21 | 0.7500 | 0.7500 | 0.8000 | 3.3750 | 14850.00 | 0.00 | 14850.00 | 198 | 8 | 7128 | 8315 | 0.857245941070355 | 0.64268106612435 | 0.64268106612435 | true | false | false | true | ||||||||||||||||
| 228d6b7d-a72a-4d94-acde-37f099c399ca | 2026-08-21 10:52 | 2026-08-21 10:52 | 2026-08-21 10:52 | DNN | DNN280121P00003000 | put | 3.0000 | 2028-01-21 | 0.7500 | 0.6500 | 0.7500 | 3.3850 | 15225.00 | 15225.00 | 0.00 | 203 | 10 | 233 | 1762 | 0.132236095346198 | 0.702309156011004 | 0.702309156011004 | false | false | false | true | ||||||||||||||||
| b4b0f3d7-3c99-4baa-9e90-17ac054d1cd6 | 2026-08-21 12:25 | 2026-08-21 12:25 | 2026-08-21 12:25 | DNN | DNN280121C00004500 | call | 4.5000 | 2028-01-21 | 0.8000 | 0.7500 | 0.8000 | 3.4999 | 56160.00 | 56160.00 | 0.00 | 702 | 6 | 9228 | 8315 | 1.10980156343957 | 0.631862792731188 | 0.631862792731188 | false | false | false | true | ||||||||||||||||
| 91d471a6-4ec0-4e65-a513-8c67c40c0b95 | 2026-08-24 11:24 | 2026-08-24 11:24 | 2026-08-24 11:24 | DNN | DNN261016C00004000 | call | 4.0000 | 2026-10-16 | 0.2000 | 0.1500 | 0.2000 | 3.5401 | 200000.00 | 200000.00 | 0.00 | 10000 | 5 | 10100 | 2612 | 3.86676875957121 | 0.666506621837877 | 0.666506621837877 | false | true | false | true | ||||||||||||||||
| 07fee628-3277-4467-92b7-2d49dda9b4f0 | 2026-08-24 13:42 | 2026-08-24 13:41 | 2026-08-24 13:41 | DNN | DNN270115C00004500 | call | 4.5000 | 2027-01-15 | 0.3500 | 0.2500 | 0.3500 | 3.5600 | 104781.00 | 104781.00 | 0.00 | 3000 | 7 | 3011 | 13095 | 0.229935089728904 | 0.673678937134807 | 0.708723167765905 | false | false | false | true | ||||||||||||||||
| d89034e0-0721-4884-bb74-9171667870e8 | 2026-08-25 11:21 | 2026-08-25 11:21 | 2026-08-25 11:21 | DNN | DNN261016C00004000 | call | 4.0000 | 2026-10-16 | 0.3000 | 0.2500 | 0.3000 | 3.7734 | 15000.00 | 15000.00 | 0.00 | 500 | 6 | 2676 | 13520 | 0.19792899408284 | 0.677157592466222 | 0.677157592466222 | false | false | false | true | ||||||||||||||||
| a58e7c19-21a6-4fc3-9a98-0ad2db5f51f2 | 2026-09-01 10:05 | 2026-09-01 10:05 | 2026-09-01 10:05 | DNN | DNN270115C00004000 | call | 4.0000 | 2027-01-15 | 0.3400 | 0.3000 | 0.3500 | 3.2950 | 10417.00 | 10417.00 | 0.00 | 307 | 12 | 391 | 36211 | 0.0107978238656762 | 0.711363742483248 | 0.711363742483248 | false | false | false | true | ||||||||||||||||
| 40312ea7-3f59-4f54-92a0-b9fc17e25235 | 2026-09-02 11:09 | 2026-09-02 11:09 | 2026-09-02 11:09 | DNN | DNN270115C00004500 | call | 4.5000 | 2027-01-15 | 0.3000 | 0.2000 | 0.3000 | 3.2550 | 22500.00 | 22500.00 | 0.00 | 750 | 8 | 753 | 15977 | 0.0471302497339926 | 0.814277869299866 | 0.814277869299866 | false | false | false | true | ||||||||||||||||
| 0eb067b5-aa82-4f1f-9cb0-661f22cdeaa2 | 2026-09-09 09:32 | 2026-09-09 09:31 | 2026-09-09 09:31 | DNN | DNN280121C00005000 | call | 5.0000 | 2028-01-21 | 0.7000 | 0.6500 | 0.7500 | 3.3391 | 10387.00 | 0.00 | 9127.00 | 148 | 7 | 148 | 24896 | 0.00594473007712082 | 0.708317219126667 | 0.708317219126667 | false | false | false | true | ||||||||||||||||
| 537a0c3c-d144-4b8d-89a6-210e6169d8ba | 2026-09-15 14:21 | 2026-09-15 14:21 | 2026-09-15 14:21 | DNN | DNN280121C00005500 | call | 5.5000 | 2028-01-21 | 0.4000 | 0.3500 | 0.4500 | 2.8168 | 11681.00 | 0.00 | 1761.00 | 292 | 10 | 292 | 10479 | 0.0278652543181601 | 0.722509687947485 | 0.714435719493592 | false | false | false | true | ||||||||||||||||
| a7ffa1a2-a300-4311-bf45-6ad2974e59fe | 2026-09-17 12:55 | 2026-09-17 12:55 | 2026-09-17 12:55 | DNN | DNN270115C00004500 | call | 4.5000 | 2027-01-15 | 0.1500 | 0.1000 | 0.1500 | 2.8950 | 45000.00 | 45000.00 | 0.00 | 3000 | 15 | 3007 | 16720 | 0.179844497607656 | 0.793469453048591 | 0.793469453048591 | false | false | false | true | ||||||||||||||||
| a4b19642-4704-4228-8278-3e619959b8f0 | 2026-09-21 11:33 | 2026-09-21 11:33 | 2026-09-21 11:33 | DNN | DNN280121C00004000 | call | 4.0000 | 2028-01-21 | 0.6500 | 0.6000 | 0.7000 | 2.0000 | 13000.00 | 9750.00 | 130.00 | 200 | 30 | 202 | 20103 | 0.0100482515047505 | 0.705703336012683 | 0.704978463192413 | false | false | false | true | ||||||||||||||||
| d6f6fd3f-386d-4a9c-bf69-c4834302f81b | 2026-09-21 11:42 | 2026-09-21 11:42 | 2026-09-21 11:42 | DNN | DNN270115C00003500 | call | 3.5000 | 2027-01-15 | 0.3000 | 0.2000 | 0.3000 | 2.8550 | 10830.00 | 10830.00 | 0.00 | 361 | 22 | 602 | 9073 | 0.0663507109004739 | 0.781005187207156 | 0.781005187207156 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| 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 |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:36:47.844885Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 2605655646.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:43:39.846801Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |