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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f14f0890-f46a-4981-9da4-436eeac6ce5c | 2026-08-17 10:19 | 2026-08-17 10:19 | 2026-08-17 10:19 | SII | SII270115C00130000 | call | 130.0000 | 2027-01-15 | 10.2000 | 9.0000 | 10.2000 | 119.9500 | 64260.00 | 64260.00 | 0.00 | 63 | 7 | 105 | 76 | 1.38157894736842 | 0.435861007845963 | 0.435861007845963 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c5666dfc-e2cc-4a77-a3e3-5ded65e70d5d | 2026-08-17 14:33 | 2026-08-17 14:33 | 2026-08-17 14:33 | SII | SII270115C00130000 | call | 130.0000 | 2027-01-15 | 11.1000 | 11.0000 | 11.1000 | 121.3567 | 177600.00 | 177600.00 | 0.00 | 160 | 7 | 314 | 76 | 4.13157894736842 | 0.443402611916677 | 0.443402611916677 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9b2429d0-f3aa-4f6d-9665-b2912c676bed | 2026-08-18 11:35 | 2026-08-18 11:35 | 2026-08-18 11:35 | SII | SII270115C00130000 | call | 130.0000 | 2027-01-15 | 9.3000 | 8.1000 | 10.8000 | 116.8200 | 47430.00 | 11160.00 | 36270.00 | 51 | 9 | 51 | 386 | 0.132124352331606 | 0.454332354571074 | 0.454332354571074 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0100fe3d-945b-4017-a9af-fe46373d8a7e | 2026-08-19 10:09 | 2026-08-19 10:08 | 2026-08-19 10:08 | SII | SII260918P00120000 | put | 120.0000 | 2026-09-18 | 4.9900 | 4.0000 | 6.3000 | 123.5400 | 24964.00 | 0.00 | 24964.00 | 50 | 10 | 50 | 0 | 0 | 0.481133951114633 | 0.481133951114633 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 07599879-77b0-405b-a230-ed3560eb08ca | 2026-08-19 10:29 | 2026-08-19 10:29 | 2026-08-19 10:29 | SII | SII260918P00120000 | put | 120.0000 | 2026-09-18 | 5.0600 | 4.0000 | 6.0000 | 123.0900 | 20254.00 | 20254.00 | 0.00 | 40 | 7 | 90 | 0 | 0 | 0.476423730903917 | 0.476423730903917 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3563a800-c026-4433-a637-653455b9a85c | 2026-08-26 15:02 | 2026-08-26 15:02 | 2026-08-26 15:02 | SII | SII270115C00145000 | call | 145.0000 | 2027-01-15 | 12.3000 | 10.5000 | 12.3000 | 136.7699 | 19680.00 | 19680.00 | 0.00 | 16 | 6 | 16 | 8 | 2 | 0.436095429234255 | 0.436095429234255 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:11:05.103195Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1ab8abaf-117b-444c-80e1-e1dd0d4d8ee4 | 2026-08-27 13:12 | 2026-08-27 13:12 | 2026-08-27 13:12 | SII | SII270115C00150000 | call | 150.0000 | 2027-01-15 | 10.2000 | 8.5000 | 11.3000 | 138.6900 | 51000.00 | 20400.00 | 25500.00 | 50 | 10 | 50 | 569 | 0.0878734622144113 | 0.402994079336194 | 0.402994079336194 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7eb0d308-373a-400c-bdb8-3720d44217e1 | 2026-08-31 10:34 | 2026-08-31 10:34 | 2026-08-31 10:34 | SII | SII270115P00125000 | put | 125.0000 | 2027-01-15 | 9.8000 | 8.2000 | 11.1000 | 130.8300 | 122500.00 | 24500.00 | 47040.00 | 125 | 8 | 125 | 4 | 31.25 | 0.426916930114126 | 0.426916930114126 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2b66113b-e055-410f-89ce-d9278043300b | 2026-09-01 09:40 | 2026-09-01 09:40 | 2026-09-01 09:40 | SII | SII270115P00125000 | put | 125.0000 | 2027-01-15 | 11.2000 | 9.3000 | 12.5000 | 127.3675 | 33600.00 | 16800.00 | 0.00 | 30 | 5 | 30 | 125 | 0.24 | 0.431093785882143 | 0.431093785882143 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| abebd966-b7c5-4e7d-824a-6a5e18cbbf4b | 2026-09-11 15:37 | 2026-09-11 15:37 | 2026-09-11 15:37 | SII | SII270115P00125000 | put | 125.0000 | 2027-01-15 | 9.3000 | 9.3000 | 10.6000 | 133.5900 | 45570.00 | 0.00 | 28830.00 | 49 | 8 | 49 | 182 | 0.269230769230769 | 0.461522692661016 | 0.461522692661016 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 87e21084-a911-48f5-b4fe-8c6b3366ad61 | 2026-09-14 09:46 | 2026-09-14 09:46 | 2026-09-14 09:46 | SII | SII270115P00125000 | put | 125.0000 | 2027-01-15 | 10.7000 | 9.5000 | 10.7000 | 127.0000 | 21400.00 | 14980.00 | 0.00 | 20 | 8 | 20 | 126 | 0.158730158730159 | 0.442738776381547 | 0.442738776381547 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a5ba78a4-79a6-4f9d-b075-51a4b9ad0fb7 | 2026-09-15 11:40 | 2026-09-15 11:40 | 2026-09-15 11:40 | SII | SII270115P00125000 | put | 125.0000 | 2027-01-15 | 12.1000 | 11.7000 | 12.1000 | 124.8700 | 20570.00 | 16940.00 | 0.00 | 17 | 5 | 17 | 151 | 0.112582781456954 | 0.451608580974192 | 0.451608580974192 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 3395534453.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T15:54:17.138635Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |