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_alerts658,639 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 |
|---|
| 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 |
|---|
| e9053d3d-54ff-440c-86f4-cd73304b9257 | 2026-09-22 15:50 | 2026-09-22 15:50 | 2026-09-22 15:50 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 7.5900 | 7.3000 | 7.6500 | 621.4100 | 13670.00 | 8355.00 | 5315.00 | 18 | 8 | 20496 | 1649 | 12.4293511218921 | 0.530797905072646 | 0.527459925924361 | true | false | false | true | false | 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-22T19:52:58.637042Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| d9e59d32-8ff6-4608-b366-12fd94738d6d | 2026-09-22 14:34 | 2026-09-22 14:34 | 2026-09-22 14:34 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 6.5000 | 6.3000 | 6.5000 | 619.4300 | 451625.00 | 451625.00 | 0.00 | 695 | 61 | 18201 | 1649 | 11.0375985445725 | 0.521532683652504 | 0.521532683652504 | false | false | false | |||||||||||||||||
| acaf9c38-64e5-42b1-b5e1-17f3318598aa | 2026-09-22 14:17 | 2026-09-22 14:17 | 2026-09-22 14:17 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 6.9000 | 6.8500 | 7.1500 | 620.4500 | 20698.00 | 4928.00 | 15070.00 | 30 | 8 | 16550 | 1649 | 10.0363856882959 | 0.523408086445265 | 0.508728596760056 | false | false | false | |||||||||||||||||
| c8c77c79-28ba-46ec-9824-12ecf43eb6c2 | 2026-09-22 14:11 | 2026-09-22 14:11 | 2026-09-22 14:11 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 7.2800 | 7.1500 | 7.3500 | 620.8150 | 16733.00 | 15297.00 | 1436.00 | 23 | 6 | 16034 | 1649 | 9.72346876895088 | 0.532646902194245 | 0.519505177372655 | false | false | false | |||||||||||||||||
| 77619717-545c-4c9a-99f8-adaa6465d63b | 2026-09-22 14:00 | 2026-09-22 14:00 | 2026-09-22 14:00 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 6.0400 | 5.5000 | 6.2000 | 618.0000 | 13900.00 | 7860.00 | 6040.00 | 23 | 5 | 15204 | 1649 | 9.22013341419042 | 0.518876127558893 | 0.535683444690749 | true | false | false | |||||||||||||||||
| a09b5151-2357-456b-a017-091077518580 | 2026-09-22 12:39 | 2026-09-22 12:39 | 2026-09-22 12:39 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 4.9400 | 4.8000 | 4.9500 | 615.5000 | 44463.00 | 44463.00 | 0.00 | 90 | 13 | 13535 | 1649 | 8.20800485142511 | 0.538232439221182 | 0.535829369983341 | true | false | false | |||||||||||||||||
| a7cdcd9a-4f11-4170-9333-b6f20a58472a | 2026-09-22 12:12 | 2026-09-22 12:12 | 2026-09-22 12:12 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 6.0000 | 6.0000 | 6.2000 | 617.8100 | 13204.00 | 0.00 | 13204.00 | 22 | 15 | 12824 | 1649 | 7.77683444511825 | 0.545601450650592 | 0.542483342915286 | false | false | false | |||||||||||||||||
| f52e2f4c-dda8-41ad-8b8e-a203f378c7d5 | 2026-09-22 11:36 | 2026-09-22 11:36 | 2026-09-22 11:36 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 6.8100 | 6.8000 | 7.1000 | 619.7900 | 10212.00 | 0.00 | 10212.00 | 15 | 5 | 11759 | 1649 | 7.13098847786537 | 0.533183071464203 | 0.530865036408415 | false | false | false | |||||||||||||||||
| a7e73fff-20a5-4e62-a212-28c046515a45 | 2026-09-22 10:11 | 2026-09-22 10:11 | 2026-09-22 10:11 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 8.4500 | 8.2500 | 8.8500 | 620.9500 | 29566.00 | 4250.00 | 25316.00 | 35 | 20 | 6781 | 1649 | 4.11218920557914 | 0.601728657703518 | 0.60136171617809 | true | false | false | |||||||||||||||||
| 94054b33-c54d-4402-ad7e-ad87a6e437cf | 2026-09-22 10:06 | 2026-09-22 10:06 | 2026-09-22 10:06 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 7.3700 | 7.3000 | 7.5000 | 619.1700 | 17680.00 | 5960.00 | 11720.00 | 24 | 5 | 4861 | 1649 | 2.94784718010916 | 0.604904428849038 | 0.594846933226319 | false | false | false | |||||||||||||||||
| d296449a-5896-4322-b05f-df8b339dbed6 | 2026-09-22 10:00 | 2026-09-22 10:00 | 2026-09-22 10:00 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 6.4300 | 6.4000 | 6.6000 | 616.0000 | 14149.00 | 0.00 | 14149.00 | 22 | 7 | 3790 | 1649 | 2.29836264402668 | 0.613664602468058 | 0.605386521518087 | false | false | false | |||||||||||||||||
| 21ab7748-229c-48ab-a514-22db2c9a3a75 | 2026-09-22 10:00 | 2026-09-22 10:00 | 2026-09-22 10:00 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 6.8400 | 6.7000 | 7.2000 | 617.0000 | 22556.00 | 0.00 | 22556.00 | 33 | 8 | 3728 | 1649 | 2.26076409945421 | 0.622535448770371 | 0.621515687213382 | false | false | false | |||||||||||||||||
| 6b59e650-63e2-4638-aa36-0f0babe8fb60 | 2026-09-22 09:51 | 2026-09-22 09:51 | 2026-09-22 09:51 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 6.7600 | 6.7500 | 6.9000 | 616.5700 | 14870.00 | 0.00 | 14870.00 | 22 | 6 | 2333 | 1649 | 1.41479684657368 | 0.648684430685374 | 0.644760590085737 | false | false | false | |||||||||||||||||
| 19dd1c3c-c0f0-42eb-be21-52bdfdf92ae4 | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 7.1800 | 7.0000 | 7.5000 | 615.5220 | 17230.00 | 720.00 | 15790.00 | 24 | 6 | 805 | 1649 | 0.48817465130382 | 0.686072006212412 | 0.716240034343106 | true | false | false | |||||||||||||||||
| 1d70c621-baf2-4dd1-b7c4-4538491b625b | 2026-09-21 14:58 | 2026-09-21 14:58 | 2026-09-21 14:58 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 6.7700 | 6.6500 | 6.9000 | 609.7145 | 67743.00 | 29154.00 | 38589.00 | 100 | 6 | 4574 | 23 | 198.869565217391 | 0.612911214149703 | 0.612322495347401 | false | false | false | |||||||||||||||||
| b0f9dad0-6edf-4a20-b53f-dada613c0243 | 2026-09-21 10:17 | 2026-09-21 10:17 | 2026-09-21 10:17 | AMD | AMD260923C00620000 | call | 620.0000 | 2026-09-23 | 9.5500 | 9.5500 | 9.7000 | 612.9925 | 39161.00 | 0.00 | 39161.00 | 41 | 5 | 2347 | 23 | 102.04347826087 | 0.697826755098663 | 0.697826755098663 | false | false | false |
| false |
| 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-22T18:36:42.386317Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T16:42:20.042631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T15:38:41.762966Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:13:22.184869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-22T14:01:27.900775Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:52:22.219586Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:00:53.952817Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:18:27.541285Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |