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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 884c6e40-5d14-4ec9-8ef6-95aa5eb59f78 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | POET | POET261120C00011000 | call | 11.0000 | 2026-11-20 | 1.5200 | 1.4600 | 1.8800 | 9.7400 | 15165.00 | 150.00 | 8682.00 | 100 | 16 | 140 | 3706 | 0.0377765785213168 | 0.989709739924891 | 0.974570409154134 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 982920191.00 | 2026-11-12 | 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 |
| 282f3eef-c305-47c0-85e3-208d9d09e994 | 2026-08-18 10:59 | 2026-08-18 10:59 | 2026-08-18 10:59 | POET | POET270115C00017000 | call | 17.0000 | 2027-01-15 | 0.5300 | 0.5300 | 0.6000 | 8.5220 | 79536.00 | 0.00 | 79536.00 | 1500 | 33 | 1511 | 34757 | 0.0434732571856029 | 1.00697870254748 | 0.982873139043011 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 982920191.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ef1a0af5-a16b-4c23-974d-0553eaa9d7d3 | 2026-08-26 15:18 | 2026-08-26 15:17 | 2026-08-26 15:17 | POET | POET260925C00009000 | call | 9.0000 | 2026-09-25 | 0.4600 | 0.4300 | 0.4700 | 8.0350 | 17978.00 | 17978.00 | 0.00 | 390 | 15 | 416 | 1281 | 0.324746291959407 | 0.885846433604997 | 0.874425774125428 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 982920191.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9e59875b-aebc-46d4-ac37-e2253c854489 | 2026-08-28 10:06 | 2026-08-28 10:06 | 2026-08-28 10:06 | POET | POET280121C00010000 | call | 10.0000 | 2028-01-21 | 2.8600 | 2.8500 | 3.1500 | 7.8600 | 28570.00 | 0.00 | 28570.00 | 100 | 8 | 104 | 27440 | 0.00379008746355685 | 0.932053615119555 | 0.92915913192702 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 982920191.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:08:43.927668Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 74655ff5-d361-4bf5-b531-b9474e33821c | 2026-08-31 09:33 | 2026-08-31 09:33 | 2026-08-31 09:33 | POET | POET261120C00010000 | call | 10.0000 | 2026-11-20 | 0.6700 | 0.4200 | 0.6800 | 7.6300 | 33617.00 | 8358.00 | 25259.00 | 500 | 14 | 500 | 3291 | 0.151929504709815 | 0.962142388407169 | 0.954717125001411 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 982920191.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |