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 | 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 |
|---|
| 0d2d43be-099d-4095-987f-61b2761e0180 | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 3.2000 | 3.2000 | 3.2500 | 624.2399 | 72961.00 | 0.00 | 72961.00 | 228 | 26 | 13188 | 332 | 39.7228915662651 | 0.531359645382738 | 0.531359645382738 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1018288956948.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 52e61e97-5b1b-4abb-87dc-2c7ec715687f | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 3.1100 | 3.1000 | 3.2500 | 624.4000 | 10878.00 | 0.00 | 10878.00 | 35 | 7 | 12932 | 332 | 38.9518072289157 | 0.52651246982893 | 0.527413521103352 | false | false | false | true | ||||||||||||||||
| e6dd52e9-d1dd-4931-b195-484d90cc884e | 2026-09-22 15:41 | 2026-09-22 15:41 | 2026-09-22 15:41 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 3.9500 | 3.9000 | 3.9500 | 621.5800 | 43845.00 | 43845.00 | 0.00 | 111 | 34 | 12789 | 332 | 38.5210843373494 | 0.523627476815337 | 0.523627476815337 | true | false | false | true | ||||||||||||||||
| 4e63a345-c882-4706-be5e-76451f4fb6ee | 2026-09-22 14:14 | 2026-09-22 14:14 | 2026-09-22 14:14 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 4.4500 | 4.4500 | 4.6000 | 620.3000 | 300029.00 | 0.00 | 300029.00 | 674 | 57 | 11883 | 332 | 35.7921686746988 | 0.52720549818004 | 0.52720549818004 | false | false | false | true | ||||||||||||||||
| 3208801e-9e3b-49be-8065-1f3dfbc294c4 | 2026-09-22 14:08 | 2026-09-22 14:08 | 2026-09-22 14:08 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 4.3500 | 4.3500 | 4.5000 | 620.7050 | 38715.00 | 0.00 | 38715.00 | 89 | 6 | 11025 | 332 | 33.2078313253012 | 0.531187668424134 | 0.531187668424134 | false | false | false | true | ||||||||||||||||
| b94de18a-085b-4b2c-bc73-bbf5a2e4bcbc | 2026-09-22 14:01 | 2026-09-22 14:01 | 2026-09-22 14:01 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 5.2500 | 5.2500 | 5.4500 | 618.1300 | 97650.00 | 0.00 | 97650.00 | 186 | 8 | 10604 | 332 | 31.9397590361446 | 0.522602833063142 | 0.522602833063142 | false | false | false | true | ||||||||||||||||
| e418811a-38aa-43c5-813a-a6912a65c02f | 2026-09-22 13:43 | 2026-09-22 13:43 | 2026-09-22 13:43 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 5.2000 | 5.1000 | 5.2500 | 617.6900 | 12487.00 | 3647.00 | 8840.00 | 24 | 17 | 10022 | 332 | 30.1867469879518 | 0.504731604773497 | 0.503943272585211 | false | false | false | true | ||||||||||||||||
| 8e664e15-ab41-4375-9f9b-32cc63803afd | 2026-09-22 12:32 | 2026-09-22 12:32 | 2026-09-22 12:32 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 6.7000 | 6.7000 | 6.8500 | 615.2997 | 17420.00 | 0.00 | 17420.00 | 26 | 10 | 9342 | 332 | 28.1385542168675 | 0.535779734645089 | 0.535779734645089 | true | false | false | true | ||||||||||||||||
| aad9a7b4-aa45-4eee-a250-6106262827af | 2026-09-22 10:49 | 2026-09-22 10:48 | 2026-09-22 10:48 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 7.0500 | 7.0500 | 7.3000 | 615.7550 | 14100.00 | 0.00 | 14100.00 | 20 | 5 | 7488 | 332 | 22.5542168674699 | 0.580101733856389 | 0.580101733856389 | false | false | false | true | ||||||||||||||||
| d6d40a97-87e1-40cb-ad3d-aa533ee20fd1 | 2026-09-22 10:48 | 2026-09-22 10:48 | 2026-09-22 10:48 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 7.5000 | 7.5000 | 7.7000 | 614.8900 | 383277.00 | 0.00 | 383277.00 | 511 | 52 | 7417 | 332 | 22.3403614457831 | 0.582432593544246 | 0.582432593544246 | false | false | false | true | ||||||||||||||||
| 2d8b0427-1a61-46e5-9b1f-29503002e407 | 2026-09-22 10:09 | 2026-09-22 10:09 | 2026-09-22 10:09 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 5.8500 | 5.8500 | 5.9500 | 618.8068 | 11700.00 | 0.00 | 11700.00 | 20 | 6 | 5453 | 332 | 16.4246987951807 | 0.592424315898246 | 0.592424315898246 | false | false | false | true | ||||||||||||||||
| b746dc03-95bd-4e92-890b-374ff52e2f1f | 2026-09-22 10:06 | 2026-09-22 10:06 | 2026-09-22 10:06 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 5.7200 | 5.7000 | 6.1000 | 619.1200 | 36627.00 | 0.00 | 36037.00 | 64 | 8 | 5239 | 332 | 15.7801204819277 | 0.60921076112076 | 0.590721267068945 | true | false | false | true | ||||||||||||||||
| e0f00d09-03e2-462c-81dd-949107a25386 | 2026-09-22 09:45 | 2026-09-22 09:45 | 2026-09-22 09:45 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 8.2500 | 8.1500 | 8.2500 | 615.0000 | 80025.00 | 80025.00 | 0.00 | 97 | 21 | 3965 | 332 | 11.9427710843374 | 0.664421053504808 | 0.664421053504808 | false | false | false | true | ||||||||||||||||
| a98fbfc3-609d-4652-91c9-5c7c4373fdbc | 2026-09-22 09:43 | 2026-09-22 09:43 | 2026-09-22 09:43 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 8.0000 | 7.8000 | 8.0000 | 616.0000 | 1230400.00 | 1230400.00 | 0.00 | 1538 | 7 | 3738 | 332 | 11.2590361445783 | 0.676369717393295 | 0.676551697664852 | false | false | false | true | ||||||||||||||||
| c328c61d-ddba-41d6-a4ea-58f3c2eeb7f0 | 2026-09-22 09:43 | 2026-09-22 09:43 | 2026-09-22 09:43 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 8.0900 | 7.5000 | 8.7500 | 616.0200 | 1255438.00 | 376368.00 | 819425.00 | 1551 | 151 | 2137 | 332 | 6.43674698795181 | 0.681162076890624 | 0.66391932970333 | true | false | false | true | ||||||||||||||||
| 566361e5-1408-475a-a863-e69ef5120384 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 13.0000 | 11.7500 | 13.3500 | 608.3050 | 20800.00 | 20800.00 | 0.00 | 16 | 16 | 32 | 332 | 0.0963855421686747 | 0.729244770959423 | 0.729244770959423 | false | false | false | true | ||||||||||||||||
| 7c3c9bf2-38ed-4a53-a8c3-058e5935e758 | 2026-09-21 13:40 | 2026-09-21 13:40 | 2026-09-21 13:40 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 14.8500 | 14.6500 | 14.8500 | 607.8300 | 10394.00 | 10394.00 | 0.00 | 7 | 7 | 803 | 6 | 133.833333333333 | 0.607956808190501 | 0.607956808190501 | false | false | false | true | ||||||||||||||||
| 3e6e15e1-f698-49d9-a68e-95cd5688cc4e | 2026-09-21 11:50 | 2026-09-21 11:50 | 2026-09-21 11:50 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 14.8000 | 14.8000 | 15.0500 | 609.3660 | 39966.00 | 0.00 | 39966.00 | 27 | 7 | 629 | 6 | 104.833333333333 | 0.650020111155366 | 0.655467166124705 | false | false | false | true | ||||||||||||||||
| 824c1b95-1304-4bd0-b166-8cbc9227d710 | 2026-09-21 11:02 | 2026-09-21 11:01 | 2026-09-21 11:01 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 12.3000 | 12.3000 | 12.5000 | 614.5700 | 12300.00 | 0.00 | 12300.00 | 10 | 5 | 365 | 6 | 60.8333333333333 | 0.667965313122686 | 0.66944190426605 | false | false | false | true | ||||||||||||||||
| d2b535ac-2b90-4e0d-83fd-ab269830f81d | 2026-09-21 10:51 | 2026-09-21 10:51 | 2026-09-21 10:51 | AMD | AMD260923P00615000 | put | 615.0000 | 2026-09-23 | 13.7500 | 13.6500 | 13.9000 | 611.2500 | 13750.00 | 0.00 | 13750.00 | 10 | 6 | 319 | 6 | 53.1666666666667 | 0.654841145703504 | 0.654841145703504 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:49:14.593703Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:35:05.886735Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:10:05.607073Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:46:43.807773Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:43:51.748700Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:52:20.515056Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:55:57.762099Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |