Options 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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| eca27eeb-edb9-40fe-ba3d-621b9cbf853c | 2026-08-14 15:54 | 2026-08-14 15:53 | 2026-08-14 15:53 | RJF | RJF261120C00180000 | call | 180.0000 | 2026-11-20 | 9.3000 | 8.8000 | 9.3000 | 180.6400 | 25110.00 | 25110.00 | 0.00 | 27 | 8 | 27 | 335 | 0.0805970149253731 | 0.215441246765014 | 0.215441246765014 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| be8396da-4bc7-403f-a2aa-56076d13b2eb | 2026-08-24 15:09 | 2026-08-24 15:09 | 2026-08-24 15:09 | RJF | RJF261120P00180000 | put | 180.0000 | 2026-11-20 | 9.3700 | 9.0000 | 9.5000 | 176.7200 | 42150.00 | 19950.00 | 0.00 | 45 | 7 | 148 | 35 | 4.22857142857143 | 0.249606771443222 | 0.242384151436724 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 38b09808-0198-4e86-a2d4-667a6afc2801 | 2026-08-24 15:11 | 2026-08-24 15:11 | 2026-08-24 15:11 | RJF | RJF261120P00180000 | put | 180.0000 | 2026-11-20 | 9.5000 | 9.2000 | 9.5000 | 176.6800 | 42750.00 | 42750.00 | 0.00 | 45 | 5 | 193 | 35 | 5.51428571428571 | 0.249022666940924 | 0.249022666940924 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 82813be9-f06e-40e0-b88a-597c7913db56 | 2026-08-24 15:22 | 2026-08-24 15:22 | 2026-08-24 15:22 | RJF | RJF261120P00185000 | put | 185.0000 | 2026-11-20 | 12.6000 | 11.6000 | 12.6000 | 176.3600 | 23940.00 | 23940.00 | 0.00 | 19 | 7 | 63 | 0 | 0 | 0.247387463950013 | 0.247387463950013 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cd8a658a-fb07-447c-9bab-1d915c4684c9 | 2026-08-25 09:46 | 2026-08-25 09:46 | 2026-08-25 09:46 | RJF | RJF261120P00180000 | put | 180.0000 | 2026-11-20 | 8.4000 | 8.4000 | 11.0000 | 174.8100 | 10080.00 | 0.00 | 10080.00 | 12 | 5 | 12 | 456 | 0.0263157894736842 | 0.1884371158191 | 0.1884371158191 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 17288387-2a64-4da7-a7ff-9d541e38fb87 | 2026-08-26 09:34 | 2026-08-26 09:34 | 2026-08-26 09:34 | RJF | RJF261120P00180000 | put | 180.0000 | 2026-11-20 | 11.1000 | 11.1000 | 12.9000 | 171.5300 | 59942.00 | 0.00 | 59942.00 | 54 | 6 | 396 | 429 | 0.923076923076923 | 0.211652017173614 | 0.211652017173614 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b49526d5-9738-483d-aa9d-fd4f13c1e8e7 | 2026-08-26 10:02 | 2026-08-26 10:02 | 2026-08-26 10:02 | RJF | RJF261016C00170000 | call | 170.0000 | 2026-10-16 | 8.0000 | 6.7000 | 8.4000 | 173.4200 | 96810.00 | 79200.00 | 17610.00 | 121 | 9 | 122 | 2 | 61 | 0.222030748328278 | 0.22249610192605 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a1929fbc-8b6f-4c7f-aa98-287435632271 | 2026-08-27 10:03 | 2026-08-27 10:03 | 2026-08-27 10:03 | RJF | RJF270219C00175000 | call | 175.0000 | 2027-02-19 | 13.6000 | 13.6000 | 15.1000 | 176.5300 | 13600.00 | 0.00 | 13600.00 | 10 | 5 | 10 | 11 | 0.909090909090909 | 0.228734549833362 | 0.228734549833362 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 93c7e0bc-1372-4b32-8d17-d5e6d593ecbd | 2026-09-01 09:32 | 2026-09-01 09:32 | 2026-09-01 09:32 | RJF | RJF261120P00180000 | put | 180.0000 | 2026-11-20 | 8.7000 | 8.7000 | 10.6000 | 175.5801 | 45240.00 | 0.00 | 45240.00 | 52 | 11 | 97 | 230 | 0.421739130434783 | 0.216835083751774 | 0.216835083751774 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dc993b8d-7349-40dc-bc63-8e6780857d24 | 2026-09-01 09:33 | 2026-09-01 09:33 | 2026-09-01 09:33 | RJF | RJF261120P00190000 | put | 190.0000 | 2026-11-20 | 14.6000 | 14.6000 | 17.5000 | 176.6400 | 86140.00 | 0.00 | 86140.00 | 59 | 10 | 59 | 59 | 1 | 0.213524618487084 | 0.213524618487084 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 82d89a5a-77e4-4789-9431-6f09c56a7d81 | 2026-09-01 13:18 | 2026-09-01 13:17 | 2026-09-01 13:17 | RJF | RJF261120P00180000 | put | 180.0000 | 2026-11-20 | 9.7000 | 9.7000 | 12.2000 | 172.4450 | 23280.00 | 0.00 | 23280.00 | 24 | 6 | 603 | 230 | 2.62173913043478 | 0.190307020336078 | 0.190307020336078 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f00dfc77-f031-474d-879a-5eb114ee369c | 2026-09-01 13:19 | 2026-09-01 13:19 | 2026-09-01 13:19 | RJF | RJF261120P00180000 | put | 180.0000 | 2026-11-20 | 11.0300 | 11.0000 | 12.1000 | 172.4000 | 44120.00 | 0.00 | 30800.00 | 40 | 10 | 701 | 230 | 3.04782608695652 | 0.231643653591507 | 0.231643653591507 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bb4a2ff6-7615-4544-ae13-4bb9003fd8b9 | 2026-09-01 13:19 | 2026-09-01 13:19 | 2026-09-01 13:19 | RJF | RJF261120P00180000 | put | 180.0000 | 2026-11-20 | 11.1000 | 11.1000 | 12.1000 | 172.4000 | 45512.00 | 0.00 | 45512.00 | 41 | 15 | 742 | 230 | 3.22608695652174 | 0.234857742358065 | 0.234857742358065 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4b86a037-18f8-43b1-b0cb-c93d27c3f683 | 2026-09-03 09:47 | 2026-09-03 09:46 | 2026-09-03 09:46 | RJF | RJF261120P00190000 | put | 190.0000 | 2026-11-20 | 13.8000 | 13.4000 | 13.8000 | 180.1600 | 56580.00 | 56580.00 | 0.00 | 41 | 6 | 271 | 37 | 7.32432432432432 | 0.265575472884446 | 0.265575472884446 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 85d7b2fe-0456-4f7d-acea-6213f459e0f6 | 2026-09-09 14:30 | 2026-09-09 14:30 | 2026-09-09 14:30 | RJF | RJF261120P00190000 | put | 190.0000 | 2026-11-20 | 16.7000 | 16.4000 | 16.8500 | 175.2800 | 61790.00 | 30060.00 | 0.00 | 37 | 5 | 168 | 478 | 0.351464435146443 | 0.26335047238009 | 0.26335047238009 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d88117c6-6767-488f-ab1c-9f1172dafb13 | 2026-09-10 11:50 | 2026-09-10 11:50 | 2026-09-10 11:50 | RJF | RJF261120P00185000 | put | 185.0000 | 2026-11-20 | 13.4000 | 13.2000 | 13.4000 | 175.2300 | 28140.00 | 28140.00 | 0.00 | 21 | 5 | 62 | 158 | 0.392405063291139 | 0.272143914977855 | 0.272143914977855 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 82805a8a-dd4f-4ef7-8ca1-a92b5f4a6833 | 2026-09-10 11:50 | 2026-09-10 11:50 | 2026-09-10 11:50 | RJF | RJF261120P00185000 | put | 185.0000 | 2026-11-20 | 13.4000 | 13.2000 | 13.4000 | 175.2300 | 28140.00 | 28140.00 | 0.00 | 21 | 5 | 83 | 158 | 0.525316455696203 | 0.272143914977855 | 0.272143914977855 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f4721afe-5f8e-4e72-b09c-fc1577a2f527 | 2026-09-11 11:45 | 2026-09-11 11:45 | 2026-09-11 11:45 | RJF | RJF261120P00185000 | put | 185.0000 | 2026-11-20 | 14.5400 | 14.5000 | 15.0000 | 172.6700 | 36355.00 | 4455.00 | 31900.00 | 25 | 5 | 54 | 367 | 0.147138964577657 | 0.252976386694045 | 0.266012674743272 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 89879035-01da-4262-9871-a0414b06fcb3 | 2026-09-11 11:47 | 2026-09-11 11:47 | 2026-09-11 11:47 | RJF | RJF261120P00185000 | put | 185.0000 | 2026-11-20 | 14.7100 | 14.7000 | 15.0000 | 172.6700 | 51470.00 | 0.00 | 51470.00 | 35 | 6 | 159 | 367 | 0.433242506811989 | 0.260448683118941 | 0.260448683118941 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4d5b576d-7b9b-4bd1-b50b-8d25c24d4ad0 | 2026-09-11 11:52 | 2026-09-11 11:52 | 2026-09-11 11:52 | RJF | RJF261120P00180000 | put | 180.0000 | 2026-11-20 | 10.5000 | 10.5000 | 11.8000 | 173.0500 | 24150.00 | 0.00 | 24150.00 | 23 | 6 | 44 | 144 | 0.305555555555556 | 0.240371298178552 | 0.240371298178552 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 32855380239.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |