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_alerts474,253 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 |
|---|
| 0be8b599-9973-4d4a-9739-172e61a912de | 2026-09-10 10:55 | 2026-09-10 10:55 | 2026-09-10 10:55 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 1.6000 | 1.4600 | 1.6000 | 322.0500 | 109600.00 | 109600.00 | 0.00 | 685 | 35 | 972 | 5789 | 0.167904646743824 | 0.258371802250787 | 0.258371802250787 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4861029474400.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:57:03.898045Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5f959c7e-e27b-4c3d-89cd-92c80c2bb5c1 | 2026-09-21 12:44 | 2026-09-21 12:44 | 2026-09-21 12:44 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 3.1000 | 3.0000 | 3.1000 | 339.0300 | 310000.00 | 310000.00 | 0.00 | 1000 | 6 | 2059 | 6527 | 0.315458863183698 | 0.229506013986325 | 0.229506013986325 | false | false | false | true | ||||||||||||||||
| 58803bd8-f8ef-4de9-9db5-430f1237ffa4 | 2026-09-21 14:56 | 2026-09-21 14:56 | 2026-09-21 14:56 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.9700 | 2.9300 | 3.0500 | 338.6712 | 18414.00 | 0.00 | 18414.00 | 62 | 5 | 2883 | 6527 | 0.441703692354834 | 0.229201338533081 | 0.229201338533081 | true | false | false | true | ||||||||||||||||
| 24b16840-1161-4d4e-9bc2-343cf09f941f | 2026-09-21 15:12 | 2026-09-21 15:12 | 2026-09-21 15:12 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.9500 | 2.9500 | 3.1000 | 338.8700 | 147500.00 | 0.00 | 147500.00 | 500 | 6 | 3900 | 6527 | 0.597518002144936 | 0.225135676901903 | 0.225135676901903 | false | false | false | true | ||||||||||||||||
| e714e68e-25b6-48c4-8e29-29932fb43872 | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 3.1000 | 3.1000 | 3.2000 | 339.0000 | 101370.00 | 0.00 | 101370.00 | 327 | 10 | 4308 | 6527 | 0.660027577753945 | 0.226131361341535 | 0.226131361341535 | false | false | false | true | ||||||||||||||||
| 84504cd3-4d4e-4691-b892-c1954330961b | 2026-09-22 09:57 | 2026-09-22 09:57 | 2026-09-22 09:57 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 3.8000 | 3.8000 | 3.9000 | 341.1250 | 17860.00 | 0.00 | 17860.00 | 47 | 16 | 941 | 7374 | 0.127610523460808 | 0.237188029448784 | 0.237188029448784 | true | false | false | true | ||||||||||||||||
| 69de2884-6396-42d4-93ea-d17e739f68b8 | 2026-09-22 10:54 | 2026-09-22 10:54 | 2026-09-22 10:54 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 4.2500 | 4.1000 | 4.4000 | 342.1800 | 13174.00 | 11900.00 | 1274.00 | 31 | 5 | 2306 | 7374 | 0.312720368863575 | 0.237481773372285 | 0.237033377273328 | true | false | false | true | ||||||||||||||||
| 79d619ae-bcb9-430e-9112-9a99bd860301 | 2026-09-22 11:16 | 2026-09-22 11:16 | 2026-09-22 11:16 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 5.0000 | 4.8500 | 5.0000 | 343.7900 | 12500.00 | 12500.00 | 0.00 | 25 | 7 | 2792 | 7374 | 0.378627610523461 | 0.237932665810466 | 0.237932665810466 | false | false | false | true | ||||||||||||||||
| 95e56113-9bba-436a-a7b2-5fc6a6f5337d | 2026-09-22 11:18 | 2026-09-22 11:18 | 2026-09-22 11:18 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 4.9000 | 4.9000 | 5.0000 | 343.6900 | 67620.00 | 0.00 | 67620.00 | 138 | 12 | 2951 | 7374 | 0.400189856251695 | 0.235646463343104 | 0.235646463343104 | true | false | false | true | ||||||||||||||||
| 897c1dbf-fcdb-410f-a948-70065763b62d | 2026-09-22 15:54 | 2026-09-22 15:54 | 2026-09-22 15:54 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 3.1500 | 3.1500 | 3.2500 | 339.0000 | 17640.00 | 0.00 | 17640.00 | 56 | 8 | 4613 | 7374 | 0.625576349335503 | 0.229081985497628 | 0.229081985497628 | false | false | false | true | ||||||||||||||||
| 12a8d58d-7b6d-483e-bf1c-b3dec2e88b49 | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.3400 | 2.2900 | 2.3500 | 337.5400 | 11716.00 | 11716.00 | 0.00 | 50 | 5 | 696 | 7363 | 0.0945266874915116 | 0.240852917742229 | 0.240852917742229 | false | false | false | true | ||||||||||||||||
| 273c254f-b67d-48a4-95ab-2585edd27e1c | 2026-09-23 10:00 | 2026-09-23 09:59 | 2026-09-23 09:59 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.2500 | 2.2200 | 2.2800 | 337.4200 | 11253.00 | 11253.00 | 0.00 | 50 | 6 | 1003 | 7363 | 0.136221648784463 | 0.238956142134488 | 0.237305803028908 | false | false | false | true | ||||||||||||||||
| e2c039e7-c39c-4126-a75b-9749c1e3265c | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.3800 | 2.2800 | 2.3800 | 338.0100 | 63783.00 | 63783.00 | 0.00 | 268 | 6 | 2293 | 7363 | 0.311421974738558 | 0.234818693154609 | 0.234280627848211 | false | false | false | true | ||||||||||||||||
| 025104ea-9af9-4e2e-bd1f-322e8dd2be8b | 2026-09-23 11:05 | 2026-09-23 11:05 | 2026-09-23 11:05 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.4800 | 2.4800 | 2.5600 | 338.5143 | 11656.00 | 0.00 | 11656.00 | 47 | 6 | 2751 | 7363 | 0.37362488116257 | 0.231791746351994 | 0.231791746351994 | false | false | false | true | ||||||||||||||||
| 7ebeeeb3-fa9f-4f31-bfba-77db369ccfcb | 2026-09-25 11:33 | 2026-09-25 11:32 | 2026-09-25 11:32 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 1.8000 | 1.7800 | 1.8350 | 338.0000 | 20160.00 | 19260.00 | 900.00 | 112 | 5 | 3169 | 9018 | 0.351408294522067 | 0.217647747432681 | 0.217647747432681 | false | false | false | true | ||||||||||||||||
| 86639b49-05d4-4feb-801f-7cf6b42a1472 | 2026-09-25 12:05 | 2026-09-25 12:05 | 2026-09-25 12:05 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.1400 | 2.1000 | 2.1500 | 339.9200 | 12840.00 | 1712.00 | 11128.00 | 60 | 7 | 3750 | 9018 | 0.41583499667332 | 0.217121330208091 | 0.217121330208091 | false | false | false | true | ||||||||||||||||
| 67f4e7a8-ca84-4b40-bdac-707dfe41e352 | 2026-09-25 12:32 | 2026-09-25 12:32 | 2026-09-25 12:32 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.2000 | 2.1800 | 2.2000 | 340.1450 | 25740.00 | 25740.00 | 0.00 | 117 | 5 | 4324 | 9018 | 0.47948547349745 | 0.21629764276438 | 0.21629764276438 | false | false | false | true | ||||||||||||||||
| 043bfd02-6675-4c91-8631-511ed5b24a9e | 2026-09-25 13:33 | 2026-09-25 13:33 | 2026-09-25 13:33 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.2000 | 2.1900 | 2.2500 | 340.3800 | 17380.00 | 0.00 | 17380.00 | 79 | 6 | 5213 | 9018 | 0.578066090042138 | 0.211710583077614 | 0.211710583077614 | false | false | false | true | ||||||||||||||||
| 5e4a0b6a-9faa-4d22-9adf-b4c037caece2 | 2026-09-25 15:37 | 2026-09-25 15:36 | 2026-09-25 15:36 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.0000 | 1.9900 | 2.1000 | 340.0000 | 11400.00 | 200.00 | 7800.00 | 57 | 12 | 6692 | 9018 | 0.742071412730095 | 0.205784615586169 | 0.205784615586169 | true | false | false | true | ||||||||||||||||
| 023f85f0-91b0-42fc-8865-368fdf327b5b | 2026-09-25 15:42 | 2026-09-25 15:42 | 2026-09-25 15:42 | AAPL | AAPL261002C00345000 | call | 345.0000 | 2026-10-02 | 2.2500 | 2.2400 | 2.2800 | 340.0000 | 22500.00 | 0.00 | 22500.00 | 100 | 5 | 6868 | 9018 | 0.76158793524063 | 0.206979020658079 | 0.206979020658079 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:45:57.787225Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:56:46.399450Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:58:41.675080Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:00:44.029710Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:54:01.895756Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:34:39.698780Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:05:43.599354Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:34:19.672703Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:33:28.969909Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:39:29.889694Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |