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_alerts566,287 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 |
|---|
| 411ee5cb-7bad-4812-9907-7c3dfddb4e36 | 2026-09-18 14:37 | 2026-09-18 14:36 | 2026-09-18 14:36 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 3.1000 | 2.9200 | 3.1000 | 335.6700 | 422220.00 | 422220.00 | 0.00 | 1362 | 57 | 3230 | 1113 | 2.90206648697215 | 0.174860516049942 | 0.174860516049942 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4905541723400.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 99270ead-496a-4a38-9ffb-993b0195e723 | 2026-09-21 10:15 | 2026-09-21 10:15 | 2026-09-21 10:15 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 1.4600 | 1.4600 | 1.5200 | 336.0000 | 47304.00 | 0.00 | 47304.00 | 324 | 34 | 3752 | 1908 | 1.9664570230608 | 0.305195852269837 | 0.305195852269837 | true | false | false | true | ||||||||||||||||
| 9a55c50d-5287-4146-8d41-0e96ec9da12a | 2026-09-21 10:18 | 2026-09-21 10:18 | 2026-09-21 10:18 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 1.5500 | 1.5100 | 1.5700 | 336.6700 | 15536.00 | 9263.00 | 6273.00 | 100 | 10 | 4116 | 1908 | 2.15723270440252 | 0.324361537096817 | 0.312148237690352 | false | false | false | true | ||||||||||||||||
| 91ed164d-8f4e-473c-82c1-8964c17bffe0 | 2026-09-21 11:11 | 2026-09-21 11:11 | 2026-09-21 11:11 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 1.0800 | 1.0800 | 1.1100 | 337.0000 | 10800.00 | 0.00 | 10800.00 | 100 | 7 | 10998 | 1908 | 5.76415094339623 | 0.274043900841905 | 0.271261050388024 | false | false | false | true | ||||||||||||||||
| 37aa18fa-523d-48db-bd1c-d75f9582b454 | 2026-09-21 11:48 | 2026-09-21 11:48 | 2026-09-21 11:48 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.4500 | 0.4400 | 0.4600 | 338.3300 | 10710.00 | 0.00 | 10620.00 | 238 | 5 | 17973 | 1908 | 9.41981132075472 | 0.271030529267308 | 0.271030529267308 | false | false | false | true | ||||||||||||||||
| bfddfe0b-1da2-4bb8-a6ae-01ab24f56fdc | 2026-09-21 11:56 | 2026-09-21 11:56 | 2026-09-21 11:56 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.5200 | 0.5100 | 0.5400 | 338.0800 | 13104.00 | 52.00 | 13000.00 | 252 | 7 | 21169 | 1908 | 11.0948637316562 | 0.268197780893373 | 0.268197780893373 | false | false | false | true | ||||||||||||||||
| 25028c97-7535-46bd-b967-f36fd98b3fa8 | 2026-09-21 11:57 | 2026-09-21 11:57 | 2026-09-21 11:57 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.4900 | 0.4800 | 0.5000 | 338.2100 | 12201.00 | 10878.00 | 1323.00 | 249 | 13 | 21569 | 1908 | 11.3045073375262 | 0.273861741403297 | 0.275184047298472 | false | false | false | true | ||||||||||||||||
| b753248e-a64f-4137-980a-e300b3f4ceef | 2026-09-21 12:00 | 2026-09-21 12:00 | 2026-09-21 12:00 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.7100 | 0.6900 | 0.7100 | 337.5900 | 28400.00 | 28400.00 | 0.00 | 400 | 7 | 24480 | 1908 | 12.8301886792453 | 0.263378687241586 | 0.263378687241586 | false | false | false | true | ||||||||||||||||
| fdc8224f-e804-4591-839e-e32c2b60429e | 2026-09-21 12:02 | 2026-09-21 12:02 | 2026-09-21 12:02 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.5000 | 0.5000 | 0.5300 | 338.0600 | 11203.00 | 0.00 | 11203.00 | 224 | 22 | 25551 | 1908 | 13.3915094339623 | 0.261731824202147 | 0.261731824202147 | true | false | false | true | ||||||||||||||||
| 13f821b6-fc76-4f2b-a6e1-bb113c3e16f7 | 2026-09-21 12:04 | 2026-09-21 12:04 | 2026-09-21 12:04 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.5300 | 0.5300 | 0.5400 | 337.9800 | 17596.00 | 0.00 | 17596.00 | 332 | 25 | 26227 | 1908 | 13.7458071278826 | 0.262217652963439 | 0.262217652963439 | true | false | false | true | ||||||||||||||||
| abc56f98-7430-4d11-a64c-ea87db3b24a7 | 2026-09-21 14:10 | 2026-09-21 14:10 | 2026-09-21 14:10 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.3000 | 0.2900 | 0.3100 | 338.0101 | 13277.00 | 1187.00 | 0.00 | 442 | 9 | 59381 | 1908 | 31.1221174004193 | 0.269673106318001 | 0.271418929250105 | false | false | false | true | ||||||||||||||||
| 1c522570-47be-4fe0-a9ab-c6cb0c9b38b9 | 2026-09-21 14:35 | 2026-09-21 14:35 | 2026-09-21 14:35 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.1300 | 0.1100 | 0.1300 | 338.6600 | 13000.00 | 13000.00 | 0.00 | 1000 | 6 | 71995 | 1908 | 37.7332285115304 | 0.30462041233229 | 0.301390914806713 | false | false | false | true | ||||||||||||||||
| 0e118cd1-d8db-4c86-a3fa-c1663dd3c3e9 | 2026-09-21 14:39 | 2026-09-21 14:39 | 2026-09-21 14:39 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.1100 | 0.1000 | 0.1100 | 338.8800 | 11000.00 | 11000.00 | 0.00 | 1000 | 9 | 73976 | 1908 | 38.7714884696017 | 0.324690011015755 | 0.324690011015755 | false | false | false | true | ||||||||||||||||
| 6e46af98-c62a-4900-b5d3-4795f34a0377 | 2026-09-21 14:40 | 2026-09-21 14:40 | 2026-09-21 14:40 | AAPL | AAPL260921P00337500 | put | 337.5000 | 2026-09-21 | 0.1200 | 0.1000 | 0.1200 | 338.9350 | 41124.00 | 41124.00 | 0.00 | 3427 | 66 | 77691 | 1908 | 40.7185534591195 | 0.345926408856683 | 0.345926408856683 | false | false | false | true |
| 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-21T14:16:37.999315Z"} |
| 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-21T14:20:57.602674Z"} |
| 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-21T15:13:03.739619Z"} |
| 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-21T15:49:21.879731Z"} |
| 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-21T16:00:04.115943Z"} |
| 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-21T16:00:04.115943Z"} |
| 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-21T16:04:05.802260Z"} |
| 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-21T16:04:05.802260Z"} |
| 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-21T16:07:39.472771Z"} |
| 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:15:35.599753Z"} |
| 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:37:54.025147Z"} |
| 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:42:48.011261Z"} |
| 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:42:48.011261Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |