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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0cb2e187-9d22-437a-9a6c-35c74ed1d866 | 2026-08-17 09:36 | 2026-08-17 09:36 | 2026-08-17 09:36 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.6300 | 0.6300 | 0.6500 | 18.8550 | 22777.00 | 6016.00 | 16569.00 | 360 | 50 | 2122 | 18211 | 0.116522980616111 | 0.544052905783395 | 0.557630307901529 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0708666a-b7f6-42e3-b3e8-6e8c88022398 | 2026-08-17 09:37 | 2026-08-17 09:37 | 2026-08-17 09:37 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.7000 | 0.6800 | 0.7100 | 18.9400 | 13370.00 | 13370.00 | 0.00 | 191 | 5 | 2876 | 18211 | 0.157926527922684 | 0.563580048663522 | 0.563580048663522 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 798b423f-4868-43d6-bed8-64f9f9689c5e | 2026-08-17 10:10 | 2026-08-17 10:10 | 2026-08-17 10:10 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.4400 | 0.4400 | 0.4500 | 18.5699 | 18436.00 | 0.00 | 18436.00 | 419 | 12 | 7514 | 18211 | 0.412607764537917 | 0.516929934592409 | 0.516929934592409 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | 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 |
| 32aa3295-97f5-497f-88d1-8ad6c6a606b3 | 2026-08-19 10:51 | 2026-08-19 10:51 | 2026-08-19 10:51 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.2300 | 0.2200 | 0.2300 | 18.3250 | 12489.00 | 12489.00 | 0.00 | 543 | 7 | 7861 | 22573 | 0.348247906791299 | 0.566637021023451 | 0.566637021023451 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5c7f5f37-0598-43a7-9a2b-689717abed6c | 2026-08-19 10:54 | 2026-08-19 10:53 | 2026-08-19 10:53 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.2600 | 0.2500 | 0.2700 | 18.4050 | 10140.00 | 8216.00 | 0.00 | 390 | 6 | 8647 | 22573 | 0.383068267399105 | 0.556888640978472 | 0.556888640978472 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 22f2e423-82ce-4ab2-817c-e62614b3b589 | 2026-08-21 09:42 | 2026-08-21 09:41 | 2026-08-21 09:41 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.1700 | 0.1600 | 0.1800 | 18.4701 | 10047.00 | 119.00 | 9928.00 | 591 | 23 | 5372 | 26056 | 0.206171323303654 | 0.932034197236465 | 0.932034197236465 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7e10d362-42cc-4a39-91a9-5bf2a13f02a3 | 2026-08-21 09:43 | 2026-08-21 09:43 | 2026-08-21 09:43 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.2200 | 0.2100 | 0.2300 | 18.5900 | 16637.00 | 16637.00 | 0.00 | 756 | 18 | 7054 | 26056 | 0.270724593183912 | 0.893589830008191 | 0.915185400285276 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ffaaaace-a8b6-4412-81ea-c6ec094ef196 | 2026-08-21 09:57 | 2026-08-21 09:56 | 2026-08-21 09:56 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.5200 | 0.5000 | 0.5400 | 19.0000 | 13732.00 | 13732.00 | 0.00 | 264 | 5 | 11396 | 26056 | 0.437365673933067 | 1.12905502118565 | 0.997175279064697 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | unknown | — | 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 |
| 4f26053a-b4c3-48cf-91b7-aa2b019623c9 | 2026-08-21 11:00 | 2026-08-21 11:00 | 2026-08-21 11:00 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.4500 | 0.4200 | 0.4500 | 18.9150 | 94588.00 | 94588.00 | 0.00 | 2102 | 5 | 17227 | 26056 | 0.661152901443046 | 0.831362344609623 | 0.929404368206036 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7d7079b9-807f-4743-9c9a-83434e01b7b4 | 2026-08-21 11:21 | 2026-08-21 11:20 | 2026-08-21 11:20 | SOFI | SOFI260821C00018500 | call | 18.5000 | 2026-08-21 | 0.4300 | 0.4300 | 0.4500 | 18.9000 | 30874.00 | 0.00 | 30874.00 | 718 | 6 | 18412 | 26056 | 0.706631869818852 | 0.892689338932874 | 0.892689338932874 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22796216219.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |