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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dd5baff2-69ff-41b1-b04f-8d59ed7c77da | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0200 | 20174.00 | 0.00 | 20174.00 | 917 | 9 | 21102 | 10489 | 2.01182190866622 | 0.0869487026600813 | 0.0869487026600813 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 400da1ee-c9f2-4c1d-8c32-2da057d90b8d | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0200 | 20196.00 | 0.00 | 20196.00 | 918 | 6 | 22020 | 10489 | 2.09934216798551 | 0.0869487026600813 | 0.0869487026600813 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| df53e977-5e79-49d4-bcaa-573b84e42ff8 | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0200 | 20196.00 | 0.00 | 20196.00 | 918 | 17 | 22938 | 10489 | 2.1868624273048 | 0.0869487026600813 | 0.0869487026600813 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5756b341-7855-42c1-aa0b-764b66d7c091 | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0250 | 20196.00 | 0.00 | 20196.00 | 918 | 7 | 23856 | 10489 | 2.27438268662408 | 0.0865413925812124 | 0.0865413925812124 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fe7edc5f-3d01-4536-9eb1-081330413e5e | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0200 | 20196.00 | 0.00 | 20196.00 | 918 | 9 | 24774 | 10489 | 2.36190294594337 | 0.0869487026600813 | 0.0869487026600813 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 63788ecf-da43-4d7a-8952-3ff510424713 | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0250 | 20196.00 | 0.00 | 20196.00 | 918 | 12 | 25692 | 10489 | 2.44942320526266 | 0.0865413925812124 | 0.0865413925812124 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cdbc4c5a-5584-4dba-b6e7-5e5ea4d791fa | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0150 | 20196.00 | 0.00 | 20196.00 | 918 | 10 | 26610 | 10489 | 2.53694346458194 | 0.0873552141971651 | 0.0873552141971651 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b17fa4ac-838b-44d6-a237-fc8d58883852 | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0150 | 20196.00 | 0.00 | 20196.00 | 918 | 15 | 27528 | 10489 | 2.62446372390123 | 0.0873552141971651 | 0.0873552141971651 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4f43eb09-140e-4e7b-b1e6-525993e6a847 | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0250 | 20174.00 | 0.00 | 20174.00 | 917 | 10 | 29363 | 10489 | 2.79940890456669 | 0.0865413925812124 | 0.0865413925812124 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 161ff315-0442-4483-a1ff-6de775fac956 | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0150 | 20196.00 | 0.00 | 20196.00 | 918 | 13 | 28446 | 10489 | 2.71198398322052 | 0.0873552141971651 | 0.0873552141971651 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d3d21a98-df74-4915-81a2-1016737947fe | 2026-08-14 15:59 | 2026-08-14 15:59 | 2026-08-14 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2200 | 0.2200 | 0.2400 | 82.0200 | 141372.00 | 0.00 | 141372.00 | 6426 | 5 | 38543 | 10489 | 3.67461149775956 | 0.0869487026600813 | 0.0869487026600813 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f75adbb0-0ab4-4145-be91-7c74fe2140c0 | 2026-08-14 16:02 | 2026-08-14 16:01 | 2026-08-14 16:01 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2300 | 0.2300 | 0.2400 | 82.0500 | 11615.00 | 0.00 | 11615.00 | 505 | 21 | 39048 | 10489 | 3.72275717418248 | 0.0868763925667282 | 0.0868763925667282 | 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-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c0395bd4-c08f-470a-8c05-faaf7b8890f4 | 2026-08-19 09:34 | 2026-08-19 09:34 | 2026-08-19 09:34 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.5000 | 0.4900 | 0.5100 | 82.7700 | 17950.00 | 0.00 | 17900.00 | 359 | 21 | 1120 | 49164 | 0.0227808965910015 | 0.13819129149196 | 0.13819129149196 | 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-19T13:40:44.275238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c2cbdc3b-e376-4128-80f0-d0d11dfd565a | 2026-08-19 09:36 | 2026-08-19 09:36 | 2026-08-19 09:36 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.4500 | 0.4500 | 0.4600 | 82.6937 | 67500.00 | 0.00 | 67500.00 | 1500 | 43 | 2863 | 49164 | 0.0582336669107477 | 0.136647954812458 | 0.136979113484503 | 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-19T13:40:44.275238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 29d95fa7-5cce-417a-8ad3-3f89627bf38f | 2026-08-19 09:38 | 2026-08-19 09:38 | 2026-08-19 09:38 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.5000 | 0.5000 | 0.5200 | 82.7900 | 10000.00 | 0.00 | 10000.00 | 200 | 12 | 3093 | 49164 | 0.0629118867463998 | 0.132578781453108 | 0.132578781453108 | 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-19T13:40:44.275238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b88e8979-6541-49f1-a4f0-92495bc2c8d6 | 2026-08-19 09:39 | 2026-08-19 09:39 | 2026-08-19 09:39 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.4900 | 0.4900 | 0.5050 | 82.7700 | 12250.00 | 0.00 | 12250.00 | 250 | 14 | 3373 | 49164 | 0.0686071108941502 | 0.133841441189842 | 0.133841441189842 | 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-08-19T13:40:44.275238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 76cb94f6-6127-4d26-ae31-076a9d60ee88 | 2026-08-19 09:42 | 2026-08-19 09:42 | 2026-08-19 09:42 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.5100 | 0.5100 | 0.5200 | 82.7950 | 20400.00 | 0.00 | 6324.00 | 400 | 22 | 3791 | 49164 | 0.0771092669432918 | 0.135551397770759 | 0.135551397770759 | 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-08-19T13:50:14.094967Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cc1bc413-80a0-45bd-bc8c-e40902dffb90 | 2026-08-19 09:43 | 2026-08-19 09:43 | 2026-08-19 09:43 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.5000 | 0.5000 | 0.5200 | 82.7812 | 57000.00 | 0.00 | 8200.00 | 1140 | 27 | 5787 | 49164 | 0.117708079082255 | 0.135073547056079 | 0.135073547056079 | 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-08-19T13:50:14.094967Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7967175f-4054-4651-8cb1-cb216ccff5f8 | 2026-08-19 09:43 | 2026-08-19 09:43 | 2026-08-19 09:43 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.5000 | 0.5000 | 0.5200 | 82.7812 | 41550.00 | 0.00 | 41550.00 | 831 | 21 | 4622 | 49164 | 0.0940118786103653 | 0.135073547056079 | 0.135073547056079 | 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-19T13:50:14.094967Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c498158e-f52f-49fd-917c-63dd3e184188 | 2026-08-19 10:03 | 2026-08-19 10:03 | 2026-08-19 10:03 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.6400 | 0.6400 | 0.6600 | 82.9711 | 32000.00 | 0.00 | 32000.00 | 500 | 15 | 10472 | 49164 | 0.213001383125864 | 0.139945944910918 | 0.139945944910918 | 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-08-19T14:11:54.267551Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| edaf080f-caee-4366-b1eb-79e887361e08 | 2026-08-19 12:01 | 2026-08-19 12:01 | 2026-08-19 12:01 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.5300 | 0.5300 | 0.5400 | 82.8450 | 26500.00 | 0.00 | 26500.00 | 500 | 9 | 11874 | 49164 | 0.2415181840371 | 0.129676962698812 | 0.129676962698812 | 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-19T16:07:57.422777Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1c49bd97-a71f-4ca0-b608-469b6dbb7f16 | 2026-08-20 10:24 | 2026-08-20 10:24 | 2026-08-20 10:24 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2700 | 0.2600 | 0.2700 | 82.5150 | 13500.00 | 13500.00 | 0.00 | 500 | 13 | 7135 | 49545 | 0.144010495509133 | 0.149796742820347 | 0.149796742820347 | 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-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e4a34e5-8349-4fc4-a874-c9a67a54a593 | 2026-08-20 10:25 | 2026-08-20 10:25 | 2026-08-20 10:25 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2700 | 0.2600 | 0.2700 | 82.5100 | 13500.00 | 13500.00 | 0.00 | 500 | 6 | 7637 | 49545 | 0.154142698556867 | 0.151290687149093 | 0.151290687149093 | 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-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8707d58f-680b-461d-bc39-ed716b2adbc7 | 2026-08-20 10:39 | 2026-08-20 10:38 | 2026-08-20 10:38 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.2800 | 0.2700 | 0.2800 | 82.5150 | 28000.00 | 28000.00 | 0.00 | 1000 | 33 | 8679 | 49545 | 0.17517408416591 | 0.155604991498845 | 0.155604991498845 | 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-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ce564ced-0501-4df3-959f-51a2f0b217ff | 2026-08-20 16:00 | 2026-08-20 15:59 | 2026-08-20 15:59 | TLT | TLT260821C00082500 | call | 82.5000 | 2026-08-21 | 0.1700 | 0.1600 | 0.1700 | 82.3569 | 17000.00 | 17000.00 | 0.00 | 1000 | 32 | 22728 | 49545 | 0.458734483802604 | 0.133500901253624 | 0.134259737812855 | 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-21T13:35:10.222979Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |