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_alerts326,449 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 |
|---|
| 3e6a0f5d-79ad-4754-886f-5916a019ce13 | 2026-09-21 10:07 | 2026-09-21 10:07 | 2026-09-21 10:07 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 25.7500 | 25.7500 | 26.0500 | 713.4050 | 30905.00 | 2580.00 | 28325.00 | 12 | 9 | 41 | 31 | 1.32258064516129 | 0.542255627905617 | 0.542255627905617 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-21T14:08:15.762043Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 0b881720-56a3-4957-9a62-726a1c901990 | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 24.8500 | 24.8500 | 25.1500 | 714.0000 | 52185.00 | 0.00 | 52185.00 | 21 | 11 | 88 | 31 | 2.83870967741935 | 0.542101075199377 | 0.543663643097029 | true | false | false | |||||||||||||||||
| 6312d126-ab93-4f92-b7ba-37e5c70e8cd8 | 2026-09-21 11:37 | 2026-09-21 11:37 | 2026-09-21 11:37 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 24.0000 | 24.0000 | 24.2000 | 715.0000 | 55201.00 | 0.00 | 55201.00 | 23 | 9 | 122 | 31 | 3.93548387096774 | 0.530946237817224 | 0.530946237817224 | true | false | false | |||||||||||||||||
| f10e3398-050b-4e32-86ac-a01d6a9a95d9 | 2026-09-21 12:42 | 2026-09-21 12:42 | 2026-09-21 12:42 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 17.7500 | 17.7500 | 17.9000 | 728.4600 | 24850.00 | 0.00 | 24850.00 | 14 | 5 | 547 | 31 | 17.6451612903226 | 0.562569449878632 | 0.562733687767082 | false | false | false | |||||||||||||||||
| 9cc6aff6-dd5f-47be-9969-51cafeb4aecd | 2026-09-21 12:45 | 2026-09-21 12:45 | 2026-09-21 12:45 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 17.3500 | 17.3000 | 17.5000 | 729.1200 | 27760.00 | 0.00 | 27760.00 | 16 | 7 | 649 | 31 | 20.9354838709677 | 0.560359502965867 | 0.560359502965867 | true | false | false | |||||||||||||||||
| e50e499c-7c54-41c4-9a77-abc3aa1e7bf6 | 2026-09-21 12:57 | 2026-09-21 12:57 | 2026-09-21 12:57 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 18.0000 | 18.0000 | 18.1500 | 727.3350 | 19800.00 | 0.00 | 19800.00 | 11 | 6 | 777 | 31 | 25.0645161290323 | 0.552263245833244 | 0.552263245833244 | true | false | false | |||||||||||||||||
| e08c7283-33cd-4bd1-96cf-1efd5baa3a07 | 2026-09-21 13:15 | 2026-09-21 13:14 | 2026-09-21 13:14 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 15.5500 | 15.5500 | 15.6500 | 734.1350 | 27990.00 | 0.00 | 27990.00 | 18 | 6 | 1218 | 31 | 39.2903225806452 | 0.57872855358699 | 0.57872855358699 | false | false | false | |||||||||||||||||
| ada9d00f-0ffe-4d90-b5b9-90318aeb83c1 | 2026-09-21 13:37 | 2026-09-21 13:37 | 2026-09-21 13:37 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 13.7000 | 13.5500 | 13.7500 | 740.0000 | 13700.00 | 12330.00 | 1370.00 | 10 | 5 | 1587 | 31 | 51.1935483870968 | 0.606658548100207 | 0.606658548100207 | true | false | false | |||||||||||||||||
| 2443c4bb-9131-45a1-a32c-b0e0c8f758cc | 2026-09-21 13:59 | 2026-09-21 13:59 | 2026-09-21 13:59 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 12.6500 | 12.5500 | 12.6500 | 744.0950 | 32885.00 | 31625.00 | 0.00 | 26 | 14 | 1979 | 31 | 63.8387096774194 | 0.615569566502034 | 0.617271611589173 | false | false | false | |||||||||||||||||
| 93b40830-b7f4-4633-a8b8-9c3b11cc6221 | 2026-09-21 14:58 | 2026-09-21 14:57 | 2026-09-21 14:57 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 11.9500 | 11.8000 | 12.0500 | 746.0200 | 13145.00 | 7170.00 | 5975.00 | 11 | 8 | 2461 | 31 | 79.3870967741936 | 0.616446790266854 | 0.617117087359875 | false | false | false | |||||||||||||||||
| a9e85df5-be65-4419-a3c3-f9389ab7ce7d | 2026-09-21 15:17 | 2026-09-21 15:17 | 2026-09-21 15:17 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 11.4500 | 11.3000 | 11.4500 | 745.0200 | 29770.00 | 29770.00 | 0.00 | 26 | 10 | 2565 | 31 | 82.741935483871 | 0.587690742841637 | 0.587690742841637 | false | false | false | |||||||||||||||||
| 3eb363da-f29f-455d-a7f6-b8dffbdded53 | 2026-09-21 15:22 | 2026-09-21 15:22 | 2026-09-21 15:22 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 11.5500 | 11.3000 | 11.6000 | 745.0400 | 17318.00 | 15008.00 | 2310.00 | 15 | 8 | 2637 | 31 | 85.0645161290323 | 0.593518921839284 | 0.591375110499421 | false | false | false | |||||||||||||||||
| 92e30c02-888e-4bc2-8ba0-6c3ebfdf47c6 | 2026-09-21 15:27 | 2026-09-21 15:27 | 2026-09-21 15:27 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 11.6000 | 11.5000 | 11.6000 | 745.0500 | 13920.00 | 13920.00 | 0.00 | 12 | 12 | 2656 | 31 | 85.6774193548387 | 0.593216650873707 | 0.593216650873707 | false | false | false | |||||||||||||||||
| 2474bbdd-96e8-41ff-ae08-91f3abee1773 | 2026-09-21 15:51 | 2026-09-21 15:51 | 2026-09-21 15:51 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 11.2500 | 11.2500 | 11.3500 | 747.1350 | 41625.00 | 0.00 | 41625.00 | 37 | 6 | 2917 | 31 | 94.0967741935484 | 0.606339928976127 | 0.606339928976127 | false | false | false | |||||||||||||||||
| 3a6962ba-856f-47c0-bab2-d0d192c8eb54 | 2026-09-21 15:54 | 2026-09-21 15:54 | 2026-09-21 15:54 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 11.8000 | 11.6000 | 11.8000 | 745.0000 | 48378.00 | 48378.00 | 0.00 | 41 | 14 | 3075 | 31 | 99.1935483870968 | 0.610001622854703 | 0.610001622854703 | true | false | false | |||||||||||||||||
| 1256e845-808f-4563-a7ec-24255f9a0ebf | 2026-09-21 15:55 | 2026-09-21 15:55 | 2026-09-21 15:55 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 12.4000 | 12.4000 | 12.6500 | 744.0000 | 33480.00 | 0.00 | 33480.00 | 27 | 7 | 3203 | 31 | 103.322580645161 | 0.609945840095701 | 0.609945840095701 | true | false | false | |||||||||||||||||
| 1a7ce216-f675-41e8-91d3-f86d1fa3985f | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 9.2500 | 8.7000 | 9.3000 | 749.4900 | 11105.00 | 8340.00 | 2765.00 | 12 | 5 | 492 | 936 | 0.525641025641026 | 0.647001520614895 | 0.651146368438814 | true | false | false | |||||||||||||||||
| 035ccaa1-047e-47d9-a5ce-08d8f2d0818e | 2026-09-22 09:48 | 2026-09-22 09:48 | 2026-09-22 09:48 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 10.5000 | 10.1500 | 10.7000 | 744.7600 | 525000.00 | 165900.00 | 204750.00 | 500 | 5 | 1057 | 936 | 1.1292735042735 | 0.63591307479816 | 0.63591307479816 | true | false | false | |||||||||||||||||
| 74707b44-01f3-4c3a-a58c-2d9d25121e73 | 2026-09-22 14:43 | 2026-09-22 14:43 | 2026-09-22 14:43 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 11.3600 | 11.3000 | 11.5000 | 740.6000 | 39770.00 | 11395.00 | 28375.00 | 35 | 9 | 3723 | 936 | 3.9775641025641 | 0.609153708970563 | 0.609153708970563 | true | false | false | |||||||||||||||||
| a766221a-8130-4095-afbb-c3515c5da222 | 2026-09-22 15:14 | 2026-09-22 15:14 | 2026-09-22 15:14 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 11.9000 | 11.9000 | 12.0000 | 738.3600 | 14280.00 | 0.00 | 14280.00 | 12 | 12 | 3813 | 936 | 4.07371794871795 | 0.596271497808197 | 0.596271497808197 | false | false | false | |||||||||||||||||
| 1448305d-73ad-4376-aaac-c415cba07de5 | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | META | META260925P00730000 | put | 730.0000 | 2026-09-25 | 12.1000 | 12.1000 | 12.4000 | 738.7800 | 22990.00 | 0.00 | 22990.00 | 19 | 9 | 3907 | 936 | 4.1741452991453 | 0.610515263685851 | 0.610515263685851 | false | false | false |
| 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-21T14:16:37.999315Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T15:39:42.073830Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:45:57.787225Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:45:57.787225Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-21T17:16:02.178873Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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:39:31.841992Z"} |
| 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-21T18:00:14.697100Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-21T19:00:53.952817Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-21T19:52:57.186278Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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:43:21.956551Z"} |
| 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 |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:48:39.949749Z"} |
| 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 |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"} |
| 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 |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 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 |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |