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 |
|---|
| expirydate |
|---|
| 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 |
|---|
| 0902fec7-9594-4f48-8d24-70e49db1865b | 2026-09-28 14:30 | 2026-09-28 14:30 | 2026-09-28 14:30 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 0.9800 | 0.9700 | 1.0500 | 722.3900 | 11297.00 | 1505.00 | 9792.00 | 115 | 11 | 37347 | 1717 | 21.7513104251602 | 0.534195856533705 | 0.519213535024305 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 1578034063611.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T18:30:52.408628Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 948844a7-870a-4741-9729-c8df9a799ca2 | 2026-09-28 12:41 | 2026-09-28 12:40 | 2026-09-28 12:40 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 1.7000 | 1.6400 | 1.8000 | 722.0000 | 41700.00 | 171.00 | 41529.00 | 245 | 5 | 27161 | 1717 | 15.8188701223063 | 0.487901824024707 | 0.504383564157719 | false | false | false | |||||||||||||||||
| 25a83b96-b5f8-4da0-b1e2-5eff83c76c4e | 2026-09-28 12:40 | 2026-09-28 12:40 | 2026-09-28 12:40 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 1.6500 | 1.6100 | 1.7000 | 722.0000 | 16506.00 | 996.00 | 15510.00 | 100 | 6 | 26775 | 1717 | 15.5940594059406 | 0.501859820965716 | 0.501859820965716 | false | false | false | |||||||||||||||||
| 17e4c69a-5f90-4fc6-8a22-c07f2a4cf7fc | 2026-09-28 12:35 | 2026-09-28 12:35 | 2026-09-28 12:35 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 1.3200 | 1.3100 | 1.4100 | 723.9500 | 17031.00 | 540.00 | 16491.00 | 129 | 6 | 25601 | 1717 | 14.9103086779266 | 0.514048540581213 | 0.512012529286627 | true | false | false | |||||||||||||||||
| b940bb0a-9911-4d17-96bf-67d99e0d757a | 2026-09-28 10:48 | 2026-09-28 10:48 | 2026-09-28 10:48 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 4.8500 | 4.6000 | 5.1500 | 720.0000 | 73736.00 | 465.00 | 73271.00 | 152 | 25 | 17928 | 1717 | 10.4414676761794 | 0.566866734871677 | 0.672068075505301 | true | false | false | |||||||||||||||||
| 53347f32-8bc9-4209-8bb8-32a35d68908e | 2026-09-28 10:48 | 2026-09-28 10:48 | 2026-09-28 10:48 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 3.8700 | 3.6000 | 4.5000 | 720.0000 | 12776.00 | 771.00 | 12005.00 | 33 | 11 | 17962 | 1717 | 10.4612696563774 | 0.662355220782405 | 0.567393487892611 | false | false | false | |||||||||||||||||
| 10de462a-56bd-4ae7-931b-9d4351e56daa | 2026-09-28 10:33 | 2026-09-28 10:32 | 2026-09-28 10:32 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 3.7400 | 3.5500 | 3.7500 | 720.5050 | 20548.00 | 20548.00 | 0.00 | 55 | 8 | 15208 | 1717 | 8.8573092603378 | 0.558888502447883 | 0.558888502447883 | true | false | false | |||||||||||||||||
| 3da138b8-5256-4d24-9965-fb32682a7c9b | 2026-09-28 10:13 | 2026-09-28 10:13 | 2026-09-28 10:13 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 4.2000 | 4.2000 | 4.5500 | 720.2250 | 15136.00 | 0.00 | 15136.00 | 36 | 5 | 12879 | 1717 | 7.50087361677344 | 0.603716736730553 | 0.586079396396879 | false | false | false | |||||||||||||||||
| dd214061-6dad-4515-af92-47950f8332f5 | 2026-09-28 10:11 | 2026-09-28 10:11 | 2026-09-28 10:11 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 4.9800 | 4.8000 | 5.0000 | 719.1500 | 16449.00 | 16449.00 | 0.00 | 33 | 11 | 11884 | 1717 | 6.92137449039022 | 0.616816530734817 | 0.611464699210104 | true | false | false | |||||||||||||||||
| 7928f36b-6a73-4a34-a410-1c3e38fad132 | 2026-09-28 10:01 | 2026-09-28 10:01 | 2026-09-28 10:01 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 3.1200 | 3.0500 | 3.2500 | 723.9600 | 17463.00 | 7236.00 | 10227.00 | 56 | 17 | 9153 | 1717 | 5.33080955154339 | 0.641843435485146 | 0.635001900616657 | true | false | false | |||||||||||||||||
| 0a99ac0b-f538-4bd7-b329-83320f142195 | 2026-09-28 09:57 | 2026-09-28 09:57 | 2026-09-28 09:57 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 4.3400 | 4.2500 | 4.5000 | 721.0000 | 10415.00 | 4335.00 | 6080.00 | 24 | 5 | 8110 | 1717 | 4.72335468841002 | 0.656727580152204 | 0.649456814806362 | false | false | false | |||||||||||||||||
| e7cefc2f-c0bd-40a5-93ba-23a48ce6ad73 | 2026-09-28 09:44 | 2026-09-28 09:44 | 2026-09-28 09:44 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 4.9200 | 4.8000 | 5.1000 | 721.3700 | 14769.00 | 495.00 | 11799.00 | 30 | 7 | 5432 | 1717 | 3.16365754222481 | 0.729366431883891 | 0.72283109325548 | true | false | false | |||||||||||||||||
| 62d5f171-f041-490c-a08d-1e05a946ca76 | 2026-09-28 09:43 | 2026-09-28 09:43 | 2026-09-28 09:43 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 5.4500 | 5.3500 | 5.5500 | 720.5250 | 19069.00 | 0.00 | 1629.00 | 35 | 5 | 5184 | 1717 | 3.01921956901573 | 0.743931767899083 | 0.74262991908128 | false | false | false | |||||||||||||||||
| 0119879d-8b48-4f79-aa73-feef132de30e | 2026-09-28 09:43 | 2026-09-28 09:43 | 2026-09-28 09:43 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 5.2100 | 5.0500 | 5.3500 | 721.0100 | 11980.00 | 11463.00 | 517.00 | 23 | 7 | 4750 | 1717 | 2.76645311589983 | 0.740959785086345 | 0.760638468721599 | false | false | false | |||||||||||||||||
| 3c86b1d6-6178-4f9a-b86e-b784f2ea15b9 | 2026-09-28 09:39 | 2026-09-28 09:39 | 2026-09-28 09:39 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 4.9500 | 4.7000 | 5.3500 | 722.1700 | 11382.00 | 2515.00 | 8867.00 | 23 | 14 | 3522 | 1717 | 2.05125218404193 | 0.759317220028864 | 0.739740232156009 | false | false | false | |||||||||||||||||
| 2287d602-6573-4dbc-ae69-0e32b2ee8745 | 2026-09-28 09:35 | 2026-09-28 09:35 | 2026-09-28 09:35 | META | META260928P00720000 | put | 720.0000 | 2026-09-28 | 3.2300 | 3.2000 | 3.4500 | 726.8100 | 38772.00 | 0.00 | 38772.00 | 120 | 8 | 2208 | 1717 | 1.2859638905067 | 0.778357920697405 | 0.778357920697405 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:43:39.735275Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:43:39.735275Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:39:53.834597Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:50:19.857671Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:50:19.857671Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:35:37.335936Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:15:56.070001Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:11:27.545413Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:03:25.739526Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:59:44.308303Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:45:28.249714Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:45:28.249714Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:45:28.249714Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:41:17.796982Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:35:57.715033Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |