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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 985fe908-7c6b-440f-841c-de43adb8a5e3 | 2026-08-19 15:25 | 2026-08-19 15:25 | 2026-08-19 15:25 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.4600 | 0.4500 | 0.4600 | 82.8900 | 92000.00 | 92000.00 | 0.00 | 2000 | 40 | 2164 | 16009 | 0.135173964644887 | 0.122141304091678 | 0.122141304091678 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47711923102.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9de93866-ff4b-4cb6-aa81-ae9b58c706ad | 2026-08-19 15:25 | 2026-08-19 15:25 | 2026-08-19 15:25 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.4600 | 0.4500 | 0.4600 | 82.8900 | 92000.00 | 92000.00 | 0.00 | 2000 | 31 | 4164 | 16009 | 0.260103691673434 | 0.122176285349703 | 0.122141304091678 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47711923102.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6fff91ee-f2c3-4286-9fc6-9cad24acbb7d | 2026-08-19 15:45 | 2026-08-19 15:45 | 2026-08-19 15:45 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.4600 | 0.4500 | 0.4600 | 82.9100 | 46000.00 | 46000.00 | 0.00 | 1000 | 32 | 26164 | 16009 | 1.63433068898744 | 0.122723779226901 | 0.122723779226901 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47711923102.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6412344a-0656-44f0-920c-ef5fa1f09dce | 2026-09-08 10:18 | 2026-09-08 10:18 | 2026-09-08 10:18 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.2500 | 0.2400 | 0.2500 | 82.2101 | 12500.00 | 12500.00 | 0.00 | 500 | 5 | 775 | 36604 | 0.0211725494481477 | 0.105033059766749 | 0.105033059766749 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47711923102.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d25df36f-3ee3-42c9-8a5b-76e45c2378cf | 2026-09-10 11:21 | 2026-09-10 11:21 | 2026-09-10 11:21 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.7200 | 0.7100 | 0.7300 | 80.9800 | 18072.00 | 15912.00 | 0.00 | 251 | 9 | 334 | 37315 | 0.00895082406538925 | 0.117986887611383 | 0.117986887611383 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47432867617.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1f9dd5ee-99b4-4eae-9dea-33977d5d5a39 | 2026-09-11 09:47 | 2026-09-11 09:47 | 2026-09-11 09:47 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.4600 | 0.4400 | 0.4600 | 81.0000 | 15594.00 | 15594.00 | 0.00 | 339 | 5 | 421 | 37635 | 0.0111863956423542 | 0.110324966424966 | 0.110324966424966 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47432867617.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 69fc4e92-2dfd-4fd3-8ea9-dc524e0f9b04 | 2026-09-14 13:54 | 2026-09-14 13:54 | 2026-09-14 13:54 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.5600 | 0.5600 | 0.5700 | 81.1900 | 15792.00 | 0.00 | 15792.00 | 282 | 16 | 817 | 37954 | 0.0215260578595141 | 0.123279118410827 | 0.123279118410827 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47432867617.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c5712ebf-990c-4aa6-9004-4906ffd8166d | 2026-09-15 15:23 | 2026-09-15 15:23 | 2026-09-15 15:23 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.8100 | 0.7900 | 0.8100 | 80.7350 | 13284.00 | 13284.00 | 0.00 | 164 | 8 | 658 | 37315 | 0.0176336593863058 | 0.13447722303958 | 0.13447722303958 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47711923102.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 2800301e-2014-49ad-8408-a109b160950a | 2026-09-16 09:35 | 2026-09-16 09:35 | 2026-09-16 09:35 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.6300 | 0.6100 | 0.6400 | 81.0300 | 19404.00 | 19341.00 | 0.00 | 308 | 14 | 329 | 37453 | 0.00878434304328091 | 0.134616361446619 | 0.134616361446619 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47037961165.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 55d8e6dd-cf06-4137-bd62-0cbfbfd71146 | 2026-09-18 11:02 | 2026-09-18 11:02 | 2026-09-18 11:02 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.4200 | 0.4100 | 0.4200 | 81.1050 | 23016.00 | 23016.00 | 0.00 | 548 | 13 | 1937 | 37559 | 0.0515721930828829 | 0.111456296371828 | 0.111456296371828 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47736791502.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 2c383352-6848-4914-ad9b-0755f338d469 | 2026-09-18 11:38 | 2026-09-18 11:38 | 2026-09-18 11:38 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.3500 | 0.3400 | 0.3600 | 81.2350 | 104650.00 | 0.00 | 102025.00 | 2990 | 20 | 5162 | 37559 | 0.137437098964296 | 0.108023955418224 | 0.108023955418224 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47736791502.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| ed0b441d-d1fc-4cb6-a0f7-51f7c693b663 | 2026-09-18 15:59 | 2026-09-18 15:59 | 2026-09-18 15:59 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.3300 | 0.3300 | 0.3400 | 81.0000 | 27060.00 | 0.00 | 27060.00 | 820 | 15 | 8108 | 37559 | 0.215873692057829 | 0.101118420923889 | 0.101118420923889 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47736791502.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 45e1dad6-640e-45f8-98fd-046dae4a4fbe | 2026-09-21 15:56 | 2026-09-21 15:55 | 2026-09-21 15:55 | TLT | TLT260925P00081000 | put | 81.0000 | 2026-09-25 | 0.1300 | 0.1200 | 0.1300 | 81.0000 | 13000.00 | 13000.00 | 0.00 | 1000 | 14 | 3305 | 40192 | 0.0822302945859873 | 0.122215716544116 | 0.122215716544116 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 47736791502.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |