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.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 88d05151-ccda-4320-9385-08591f0029a5 | 2026-09-18 09:57 | 2026-09-18 09:57 | 2026-09-18 09:57 | TSLL | TSLL260918C00009500 | call | 9.5000 | 2026-09-18 | 0.3100 | 0.2800 | 0.3100 | 9.7600 | 12340.00 | 12340.00 | 0.00 | 400 | 15 | 910 | 6080 | 0.149671052631579 | 1.42634403893528 | 1.42733505566264 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 3833265260.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 11cf6744-499e-4a47-95e8-e5f4f465fe6f | 2026-09-16 15:24 | 2026-09-16 15:24 | 2026-09-16 15:24 | TSLL | TSLL280121C00009000 | call | 9.0000 | 2028-01-21 | 3.7400 | 3.4500 | 3.8000 | 9.1750 | 13077.00 | 13077.00 | 0.00 | 35 | 7 | 72 | 3104 | 0.0231958762886598 | 0.876065439785719 | 0.850959976803372 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 3657912509.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 9c579e70-9049-4de4-8d9e-c6fdbaa96cb3 | 2026-09-16 10:14 | 2026-09-16 10:14 | 2026-09-16 10:14 | TSLL | TSLL260918C00009500 | call | 9.5000 | 2026-09-18 | 0.3100 | 0.3100 | 0.3400 | 9.5450 | 25100.00 | 165.00 | 24935.00 | 808 | 13 | 3547 | 6586 | 0.538566656544185 | 1.08822110678528 | 1.01689437573486 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 3657912509.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| d24d57a6-2d52-4021-9eb6-de9393a3e717 | 2026-09-11 14:42 | 2026-09-11 14:42 | 2026-09-11 14:42 | TSLL | TSLL260918P00009500 | put | 9.5000 | 2026-09-18 | 0.3100 | 0.3000 | 0.3200 | 9.6701 | 10508.00 | 4619.00 | 5889.00 | 341 | 51 | 2190 | 5881 | 0.372385648699201 | 0.741356462271126 | 0.741356462271126 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 3651445510.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9bb4ec74-0501-4cfc-afc6-9ffee7092c33 | 2026-09-08 11:45 | 2026-09-08 11:44 | 2026-09-08 11:44 | TSLL | TSLL260918P00009500 | put | 9.5000 | 2026-09-18 | 0.4400 | 0.4100 | 0.4500 | 9.7501 | 23876.00 | 20479.00 | 3397.00 | 545 | 37 | 998 | 2097 | 0.475917978063901 | 0.883029569761063 | 0.86696773646998 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 3579340009.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1bfd6491-fee4-4ab2-9060-d30429d4be2d | 2026-09-03 09:42 | 2026-09-03 09:42 | 2026-09-03 09:42 | TSLL | TSLL260904C00010000 | call | 10.0000 | 2026-09-04 | 0.4100 | 0.3800 | 0.4100 | 10.1680 | 16558.00 | 16440.00 | 118.00 | 404 | 6 | 4015 | 24766 | 0.162117419042235 | 1.51243667225551 | 1.51243667225551 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 3579340009.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c53dc737-ae77-45fe-a6a7-1f35491fc95c | 2026-08-21 11:07 | 2026-08-21 11:07 | 2026-08-21 11:07 | TSLL | TSLL261120C00012000 | call | 12.0000 | 2026-11-20 | 1.1100 | 0.9400 | 1.1100 | 9.8200 | 11076.00 | 11076.00 | 0.00 | 100 | 7 | 154 | 489 | 0.314928425357873 | 0.923464796495113 | 0.907852588347393 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 3579340009.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |