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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6694d978-ec88-4863-8f33-e0dc6ec0c5a2 | 2026-08-18 11:30 | 2026-08-18 11:30 | 2026-08-18 11:30 | LOGI | LOGI260821P00100000 | put | 100.0000 | 2026-08-21 | 1.9600 | 1.9500 | 2.2500 | 98.9050 | 53780.00 | 200.00 | 8980.00 | 275 | 12 | 275 | 805 | 0.341614906832298 | 0.390529802599341 | 0.390529802599341 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 14370381000.00 | 2026-10-27 | 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 |
| bdd66d5b-0f00-4d59-8e2e-05f1470a4ef5 | 2026-08-20 10:58 | 2026-08-20 10:57 | 2026-08-20 10:57 | LOGI | LOGI260821P00105000 | put | 105.0000 | 2026-08-21 | 9.8000 | 9.8000 | 10.4000 | 95.2000 | 24500.00 | 0.00 | 15680.00 | 25 | 18 | 72 | 1372 | 0.0524781341107872 | 0.777032260114911 | 0.777032260114911 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 14370381000.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 26cd3d1a-d4f2-49f7-976d-6e9188680153 | 2026-08-20 14:31 | 2026-08-20 14:31 | 2026-08-20 14:31 | LOGI | LOGI260821P00105000 | put | 105.0000 | 2026-08-21 | 9.0900 | 8.7000 | 9.8000 | 95.9600 | 918090.00 | 0.00 | 918090.00 | 1010 | 1 | 1082 | 1372 | 0.788629737609329 | 0.927355235133958 | 0.927355235133958 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 14370381000.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ebcd156-5072-4f3c-b5dd-013ed8cebb3e | 2026-08-20 15:17 | 2026-08-20 15:17 | 2026-08-20 15:17 | LOGI | LOGI260821P00105000 | put | 105.0000 | 2026-08-21 | 9.7100 | 8.7000 | 9.8000 | 95.5200 | 665135.00 | 665135.00 | 0.00 | 685 | 1 | 1767 | 1372 | 1.28790087463557 | 1.28092482081114 | 1.28092482081114 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 14370381000.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9fe40b86-d05c-4def-8b80-62e0b26c86a6 | 2026-08-26 14:36 | 2026-08-26 14:36 | 2026-08-26 14:36 | LOGI | LOGI270319P00090000 | put | 90.0000 | 2027-03-19 | 6.4000 | 6.4000 | 6.8000 | 99.7100 | 64000.00 | 0.00 | 64000.00 | 100 | 20 | 110 | 4 | 27.5 | 0.404948803266036 | 0.404948803266036 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 14370381000.00 | 2026-10-27 | unknown | — | 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 |
| a6cc5f19-3362-4a00-a45b-bad68f546160 | 2026-09-01 11:07 | 2026-09-01 11:07 | 2026-09-01 11:07 | LOGI | LOGI261218P00075000 | put | 75.0000 | 2026-12-18 | 1.2500 | 1.2500 | 1.6000 | 96.9800 | 21250.00 | 0.00 | 21250.00 | 170 | 8 | 170 | 8 | 21.25 | 0.43122475567392 | 0.43122475567392 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 14370381000.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 452f1491-5126-4af2-975f-460ad2f99e9e | 2026-09-01 12:06 | 2026-09-01 12:06 | 2026-09-01 12:06 | LOGI | LOGI261016P00105000 | put | 105.0000 | 2026-10-16 | 9.8000 | 9.1000 | 9.8000 | 98.1300 | 11760.00 | 11760.00 | 0.00 | 12 | 5 | 12 | 215 | 0.0558139534883721 | 0.428805771680316 | 0.428805771680316 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 14370381000.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e78a69c8-aaf6-4471-b3f0-0f865fc7a338 | 2026-09-04 14:36 | 2026-09-04 14:36 | 2026-09-04 14:36 | LOGI | LOGI261016C00110000 | call | 110.0000 | 2026-10-16 | 1.5000 | 1.3500 | 1.6500 | 102.1250 | 22500.00 | 12450.00 | 0.00 | 150 | 7 | 207 | 520 | 0.398076923076923 | 0.293416423613165 | 0.293416423613165 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 14370381000.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9aa2bcd8-273f-4162-9779-53bed942a9a6 | 2026-09-15 15:44 | 2026-09-15 15:44 | 2026-09-15 15:44 | LOGI | LOGI261120C00110000 | call | 110.0000 | 2026-11-20 | 3.1000 | 3.0000 | 3.1000 | 100.8600 | 105090.00 | 105090.00 | 0.00 | 339 | 20 | 648 | 324 | 2 | 0.361031031633194 | 0.361031031633194 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 14370381000.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 0327160a-03c2-47f2-aaa3-ab17f0850d34 | 2026-09-16 12:14 | 2026-09-16 12:14 | 2026-09-16 12:14 | LOGI | LOGI261120C00110000 | call | 110.0000 | 2026-11-20 | 2.9200 | 2.7000 | 3.0000 | 100.4500 | 16950.00 | 16950.00 | 0.00 | 58 | 7 | 81 | 835 | 0.0970059880239521 | 0.366211306946802 | 0.360273100626709 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 14251534684.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| bbff5e12-cd89-478d-84b9-2e545043a2dc | 2026-09-18 15:41 | 2026-09-18 15:41 | 2026-09-18 15:41 | LOGI | LOGI270319C00115000 | call | 115.0000 | 2027-03-19 | 5.5500 | 5.2000 | 5.8000 | 100.8850 | 277500.00 | 277500.00 | 0.00 | 500 | 2 | 500 | 26 | 19.2307692307692 | 0.345124125174124 | 0.345124125174124 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 14490659198.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| c16899c1-0c00-47ad-a709-fd3fa3a8c952 | 2026-09-21 15:59 | 2026-09-21 15:59 | 2026-09-21 15:59 | LOGI | LOGI261120C00110000 | call | 110.0000 | 2026-11-20 | 4.2000 | 4.0000 | 4.3000 | 105.0000 | 259560.00 | 259560.00 | 0.00 | 618 | 8 | 794 | 867 | 0.915801614763552 | 0.351079895396493 | 0.351079895396493 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 15051957460.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |