Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bd86f034-7c8b-4bad-ae27-cd636ad58cdf | 2026-08-19 11:55 | 2026-08-19 11:55 | 2026-08-19 11:55 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.3000 | 1.2500 | 1.4000 | 39.1700 | 190954.00 | 27040.00 | 163914.00 | 1468 | 65 | 1488 | 1245 | 1.19518072289157 | 0.34966742588881 | 0.348220479934189 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 096fb501-49ab-46b4-a0b3-c60ee706af89 | 2026-08-19 12:01 | 2026-08-19 12:01 | 2026-08-19 12:01 | GIS | GIS270115C00047500 | call | 47.5000 | 2027-01-15 | 0.8500 | 0.8000 | 0.9000 | 39.2100 | 58287.00 | 57097.00 | 1190.00 | 686 | 60 | 695 | 1294 | 0.5370942812983 | 0.30766001310548 | 0.307367516705149 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8605bd60-849e-4bcb-bcac-11000e9a19ba | 2026-08-20 09:54 | 2026-08-20 09:54 | 2026-08-20 09:54 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.0600 | 0.9500 | 1.3500 | 39.8250 | 21135.00 | 0.00 | 21135.00 | 200 | 6 | 200 | 5706 | 0.0350508236943568 | 0.350088147155426 | 0.350088147155426 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a3c6a662-37ab-48a0-96bc-a846f929f82d | 2026-08-20 09:55 | 2026-08-20 09:55 | 2026-08-20 09:55 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.0300 | 1.0000 | 1.3500 | 39.8800 | 341377.00 | 0.00 | 341377.00 | 3313 | 8 | 3813 | 5706 | 0.668243953732913 | 0.35119782722068 | 0.35119782722068 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b6a49111-6d70-4dcd-8dcd-cf33f8a9f17a | 2026-08-21 09:53 | 2026-08-21 09:53 | 2026-08-21 09:53 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 1.0500 | 0.9500 | 1.2500 | 39.5750 | 113155.00 | 4900.00 | 106055.00 | 1076 | 43 | 1577 | 9544 | 0.165234702430847 | 0.340912909868278 | 0.331662491168138 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3b3f57ce-dd51-4278-a830-1efb4ad224bd | 2026-08-21 13:08 | 2026-08-21 13:08 | 2026-08-21 13:08 | GIS | GIS260918C00040000 | call | 40.0000 | 2026-09-18 | 1.3000 | 1.2000 | 1.3000 | 39.8900 | 13777.00 | 13777.00 | 0.00 | 106 | 21 | 456 | 7494 | 0.0608486789431545 | 0.294316900473265 | 0.294316900473265 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dbf67f84-a333-4007-b26d-2006613ecac8 | 2026-08-25 13:56 | 2026-08-25 13:56 | 2026-08-25 13:56 | GIS | GIS261016P00040000 | put | 40.0000 | 2026-10-16 | 2.1000 | 2.0000 | 2.1000 | 39.8499 | 71397.00 | 71397.00 | 0.00 | 340 | 41 | 535 | 687 | 0.778748180494905 | 0.355989463747207 | 0.355989463747207 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7b0f7bec-3561-41ef-b77c-fda2a0063469 | 2026-08-26 14:18 | 2026-08-26 14:18 | 2026-08-26 14:18 | GIS | GIS260918C00042500 | call | 42.5000 | 2026-09-18 | 0.4500 | 0.4000 | 0.5000 | 40.2150 | 37660.00 | 32218.00 | 3822.00 | 837 | 39 | 1125 | 5123 | 0.219597891860238 | 0.302310794021532 | 0.302310794021532 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5987c009-1e69-467c-9bbf-08f758a25ca6 | 2026-09-03 11:52 | 2026-09-03 11:52 | 2026-09-03 11:52 | GIS | GIS260918P00037500 | put | 37.5000 | 2026-09-18 | 0.4500 | 0.4000 | 0.4500 | 38.7600 | 11015.00 | 11015.00 | 0.00 | 245 | 242 | 1590 | 4825 | 0.329533678756477 | 0.315476913668095 | 0.314944992739203 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84f0c096-118e-4c75-abf6-f4fa8d5a780d | 2026-09-03 14:27 | 2026-09-03 14:27 | 2026-09-03 14:27 | GIS | GIS261016C00037500 | call | 37.5000 | 2026-10-16 | 2.6500 | 2.6500 | 2.7500 | 39.1200 | 42422.00 | 0.00 | 42422.00 | 160 | 7 | 821 | 1680 | 0.488690476190476 | 0.307420410871092 | 0.307420410871092 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fa6cbbfa-2b80-4168-8d21-792fa9801683 | 2026-09-04 13:22 | 2026-09-04 13:22 | 2026-09-04 13:22 | GIS | GIS261218C00047500 | call | 47.5000 | 2026-12-18 | 0.4500 | 0.4000 | 0.5000 | 38.6000 | 27306.00 | 26766.00 | 540.00 | 610 | 50 | 612 | 2595 | 0.235838150289017 | 0.317863868503066 | 0.317863868503066 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a1bfd346-723d-4c65-9f12-ac11295262b5 | 2026-09-08 10:23 | 2026-09-08 10:23 | 2026-09-08 10:23 | GIS | GIS261016C00037500 | call | 37.5000 | 2026-10-16 | 1.5100 | 1.4500 | 1.5500 | 37.1550 | 16170.00 | 15420.00 | 0.00 | 107 | 5 | 148 | 1678 | 0.0882002383790226 | 0.343175011842601 | 0.334811301057768 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 22c56d91-e128-4b87-aa28-05a25c96ee0a | 2026-09-08 11:15 | 2026-09-08 11:15 | 2026-09-08 11:15 | GIS | GIS261016C00035000 | call | 35.0000 | 2026-10-16 | 3.0200 | 3.0000 | 3.2000 | 37.2650 | 38708.00 | 0.00 | 38708.00 | 128 | 7 | 875 | 2816 | 0.310724431818182 | 0.33114421655507 | 0.33114421655507 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19464345202.00 | 2026-09-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 93746721-2644-4d45-b48c-6ce28d5e1f74 | 2026-09-18 14:26 | 2026-09-18 14:26 | 2026-09-18 14:26 | GIS | GIS261016P00037500 | put | 37.5000 | 2026-10-16 | 2.1000 | 2.0000 | 2.1000 | 36.7650 | 45764.00 | 45764.00 | 0.00 | 218 | 34 | 13985 | 14669 | 0.953371054604949 | 0.432873197318137 | 0.432873197318137 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 19384288943.00 | 2026-09-23 | premarket | — | 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 |