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_alerts523,327 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 |
|---|
| 4fe23d79-bdca-4827-8c65-e06f58265c10 | 2026-09-28 15:14 | 2026-09-28 15:14 | 2026-09-28 15:14 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 6.2500 | 6.2500 | 6.6000 | 718.2800 | 12500.00 | 0.00 | 12500.00 | 20 | 8 | 3073 | 4249 | 0.723228995057661 | 0.458264617869905 | 0.458264617869905 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-28T19:15:55.789711Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 14332eed-4549-4ea9-b8c5-8bdc594f91c1 | 2026-09-28 11:53 | 2026-09-28 11:53 | 2026-09-28 11:53 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 6.4000 | 6.4000 | 6.6000 | 717.6850 | 28800.00 | 0.00 | 28800.00 | 45 | 7 | 2380 | 4249 | 0.560131795716639 | 0.457455183714617 | 0.457455183714617 | false | false | false | true | ||||||||||||||||
| cddf17ed-2baf-46f2-bd42-dc9899226796 | 2026-09-28 11:53 | 2026-09-28 11:53 | 2026-09-28 11:53 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 6.6000 | 6.4000 | 6.6000 | 717.4950 | 131995.00 | 131995.00 | 0.00 | 200 | 35 | 2335 | 4249 | 0.549541068486703 | 0.463062078635984 | 0.463062078635984 | false | false | false | true | ||||||||||||||||
| c13d6dcd-d2e6-4a15-a274-56e94efaf42e | 2026-09-28 10:48 | 2026-09-28 10:48 | 2026-09-28 10:48 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 6.7500 | 6.7000 | 6.7500 | 718.0100 | 68850.00 | 68850.00 | 0.00 | 102 | 33 | 1836 | 4249 | 0.432101670981407 | 0.474252042997928 | 0.47470539446384 | false | false | false | true | ||||||||||||||||
| f7cde776-60f7-43dc-a483-966a2a854ab4 | 2026-09-28 10:40 | 2026-09-28 10:40 | 2026-09-28 10:40 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 6.0000 | 6.0000 | 6.2500 | 720.1300 | 72650.00 | 0.00 | 72650.00 | 121 | 20 | 1711 | 4249 | 0.402682984231584 | 0.46868755970586 | 0.46868755970586 | false | false | false | true | ||||||||||||||||
| 0de180ec-8b57-4061-bd41-4dd7ce99d12e | 2026-09-28 10:15 | 2026-09-28 10:15 | 2026-09-28 10:15 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 5.7700 | 5.7500 | 6.1500 | 721.9750 | 14995.00 | 580.00 | 14415.00 | 26 | 7 | 1306 | 4249 | 0.307366439162156 | 0.480337588280411 | 0.47828934534998 | true | false | false | true | ||||||||||||||||
| bc1cd318-a362-4d5c-86b0-07ae6f517417 | 2026-09-28 10:14 | 2026-09-28 10:14 | 2026-09-28 10:14 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 6.0000 | 6.0000 | 6.1500 | 721.4950 | 90000.00 | 0.00 | 90000.00 | 150 | 22 | 1264 | 4249 | 0.297481760414215 | 0.483379778619066 | 0.483379778619066 | true | false | false | true | ||||||||||||||||
| c530f160-cb9b-48e2-bbab-d641be8270e5 | 2026-09-28 09:53 | 2026-09-28 09:53 | 2026-09-28 09:53 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 6.0000 | 6.0000 | 6.3500 | 722.0000 | 14400.00 | 0.00 | 14400.00 | 24 | 7 | 869 | 4249 | 0.204518710284773 | 0.497833692306399 | 0.497833692306399 | false | false | false | true | ||||||||||||||||
| 43032d6f-2250-49c8-a80e-af9bc894f9c0 | 2026-09-28 09:39 | 2026-09-28 09:38 | 2026-09-28 09:38 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 7.3500 | 7.1000 | 7.3500 | 720.6900 | 58065.00 | 58065.00 | 0.00 | 79 | 11 | 638 | 4249 | 0.150152977171099 | 0.528129549659211 | 0.528129549659211 | true | false | false | true | ||||||||||||||||
| 06660288-b985-4f9e-9dbc-cfd4709cf388 | 2026-09-28 09:39 | 2026-09-28 09:38 | 2026-09-28 09:38 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 7.3000 | 7.0500 | 7.4000 | 720.8125 | 14595.00 | 13870.00 | 725.00 | 20 | 6 | 559 | 4249 | 0.131560367145211 | 0.524122066112287 | 0.527547830460611 | true | false | false | true | ||||||||||||||||
| 258e6904-32d9-4a74-8060-838899e56928 | 2026-09-24 15:39 | 2026-09-24 15:39 | 2026-09-24 15:39 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 1.9900 | 1.9800 | 2.0800 | 775.0000 | 103083.00 | 199.00 | 102684.00 | 518 | 46 | 2314 | 2675 | 0.865046728971963 | 0.498120080441433 | 0.498859130825391 | true | false | false | true | ||||||||||||||||
| b96fc03e-b4a9-4fae-a7f5-50b087cc2652 | 2026-09-23 15:15 | 2026-09-23 15:15 | 2026-09-23 15:15 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 6.3500 | 6.0500 | 6.3500 | 748.0900 | 19050.00 | 19050.00 | 0.00 | 30 | 10 | 2088 | 1157 | 1.80466724286949 | 0.506520092489113 | 0.506520092489113 | false | false | false | true | ||||||||||||||||
| 6a864b71-b651-4c52-a757-eed4f797bd4e | 2026-09-23 13:25 | 2026-09-23 13:25 | 2026-09-23 13:25 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 6.8500 | 6.6500 | 6.9000 | 747.0850 | 682260.00 | 80830.00 | 95900.00 | 996 | 5 | 1941 | 1157 | 1.67761452031115 | 0.516113471899748 | 0.516113471899748 | true | false | false | true | ||||||||||||||||
| e935a7c3-4661-4776-a59c-fccbfbb431a1 | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 5.8000 | 5.8000 | 6.2500 | 750.0000 | 19155.00 | 585.00 | 18570.00 | 33 | 5 | 101 | 1157 | 0.0872947277441659 | 0.503241978357191 | 0.502869396357742 | false | false | false | true | ||||||||||||||||
| e5aa9c35-b45c-492d-b828-ad2308092944 | 2026-09-22 09:34 | 2026-09-22 09:34 | 2026-09-22 09:34 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 7.2500 | 7.2500 | 7.7000 | 745.3400 | 23925.00 | 0.00 | 23925.00 | 33 | 9 | 138 | 1046 | 0.131931166347992 | 0.491566353189566 | 0.491566353189566 | false | false | false | true | ||||||||||||||||
| d4004aab-abc0-4f72-99ab-2c8b5f400e23 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 7.6000 | 7.6000 | 8.2500 | 743.5300 | 57000.00 | 0.00 | 57000.00 | 75 | 6 | 97 | 1046 | 0.0927342256214149 | 0.490782619936428 | 0.490782619936428 | false | false | false | true | ||||||||||||||||
| 14bec7ab-f7bc-472e-b2f1-e2c04bc235d8 | 2026-09-21 13:16 | 2026-09-21 13:16 | 2026-09-21 13:16 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 10.4000 | 10.4000 | 10.7500 | 734.0000 | 52000.00 | 0.00 | 52000.00 | 50 | 14 | 1203 | 38 | 31.6578947368421 | 0.482227590775116 | 0.482227590775116 | false | false | false | true | ||||||||||||||||
| a8e1b64e-f79c-4ed7-988c-3e631a597ac5 | 2026-09-21 11:59 | 2026-09-21 11:58 | 2026-09-21 11:58 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 13.7500 | 13.5000 | 13.9000 | 720.1366 | 137488.00 | 137488.00 | 0.00 | 100 | 7 | 680 | 38 | 17.8947368421053 | 0.461853846880149 | 0.461853846880149 | false | false | false | true | ||||||||||||||||
| e1f39f6b-2ac3-4c24-99ad-c30015a84798 | 2026-09-21 11:58 | 2026-09-21 11:57 | 2026-09-21 11:57 | META | META261002P00700000 | put | 700.0000 | 2026-10-02 | 13.6100 | 13.5000 | 14.0000 | 720.6150 | 19060.00 | 8175.00 | 10885.00 | 14 | 7 | 572 | 38 | 15.0526315789474 | 0.461473160372681 | 0.46256597652776 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-28T15:58:21.684493Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-28T15:53:41.284908Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:48:11.739629Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:42:23.543990Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:54:01.711463Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:39:03.459259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:39:03.459259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:25:27.822923Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:46:41.730175Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:35:07.797098Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:33:30.058722Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:20:55.206028Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| 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 |