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.
Simplify Analyticsuw_flow_alerts375,978 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 |
|---|
| 3fc39180-793d-49af-a894-06f65d14a106 | 2026-08-19 09:51 | 2026-08-19 09:51 | 2026-08-19 09:51 | TECL | TECL260918P00188000 | put | 188.0000 | 2026-09-18 | 14.5000 | 12.5000 | 14.5000 | 195.3010 | 34800.00 | 34800.00 | 0.00 | 24 | 7 | 24 | 9 | 2.66666666666667 | 0.832310991174426 | 0.832310991174426 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 5548400000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dbcab5fe-9c38-40ad-9653-9cd75ca0721d | 2026-08-18 13:37 | 2026-08-18 13:37 | 2026-08-18 13:37 | TECL | TECL260918P00190000 | put | 190.0000 | 2026-09-18 | 13.2000 | 13.2000 | 13.6000 | 202.0000 | 26400.00 | 0.00 | 26400.00 | 20 | 12 | 30 | 22 | 1.36363636363636 | 0.830345678696935 | 0.830345678696935 | true | false | false | true | ||||||||||||||||
| e167ecc6-5e1a-4eda-8531-4e13653b9795 | 2026-08-18 13:29 | 2026-08-18 13:29 | 2026-08-18 13:29 | TECL | TECL260918C00230000 | call | 230.0000 | 2026-09-18 | 8.3000 | 7.5000 | 8.3000 | 201.3219 | 24900.00 | 24900.00 | 0.00 | 30 | 13 | 36 | 66 | 0.545454545454545 | 0.765968636691123 | 0.765968636691123 | true | false | false | true | ||||||||||||||||
| e5238017-c16f-4ab0-917d-853f74f3c7fe | 2026-08-18 12:32 | 2026-08-18 12:32 | 2026-08-18 12:32 | TECL | TECL260918P00170000 | put | 170.0000 | 2026-09-18 | 7.1000 | 7.1000 | 7.4000 | 200.9100 | 11360.00 | 0.00 | 11360.00 | 16 | 11 | 50 | 160 | 0.3125 | 0.877104860645169 | 0.877104860645169 | true | false | false | true | ||||||||||||||||
| 10900adb-104f-491b-b5fe-095d56cfb9ff | 2026-08-18 10:10 | 2026-08-18 10:10 | 2026-08-18 10:10 | TECL | TECL260918P00230000 | put | 230.0000 | 2026-09-18 | 35.9000 | 34.0000 | 35.9000 | 203.2400 | 53850.00 | 53850.00 | 0.00 | 15 | 7 | 15 | 24 | 0.625 | 0.810083436387093 | 0.810083436387093 | true | false | false | true | ||||||||||||||||
| 6535dc9f-b43c-466f-b00f-124bfbf31695 | 2026-08-17 13:12 | 2026-08-17 13:12 | 2026-08-17 13:12 | TECL | TECL260918P00215000 | put | 215.0000 | 2026-09-18 | 17.5000 | 16.0000 | 17.5000 | 220.5994 | 59500.00 | 59500.00 | 0.00 | 34 | 7 | 35 | 5 | 7 | 0.800190811263003 | 0.800190811263003 | false | false | false | true | ||||||||||||||||
| 62f64255-8813-4ab0-9cb9-bbc51467d572 | 2026-08-17 13:12 | 2026-08-17 13:12 | 2026-08-17 13:12 | TECL | TECL260918P00211960 | put | 211.9600 | 2026-09-18 | 16.0000 | 14.3000 | 16.0000 | 220.5994 | 46400.00 | 46400.00 | 0.00 | 29 | 10 | 68 | 1 | 68 | 0.799134469370603 | 0.799134469370603 | false | false | false | true | ||||||||||||||||
| 4dd77dc6-82cb-4074-8888-ff2ba043050c | 2026-08-17 13:12 | 2026-08-17 13:12 | 2026-08-17 13:12 | TECL | TECL260918P00216960 | put | 216.9600 | 2026-09-18 | 18.3000 | 16.9000 | 18.3000 | 220.5994 | 100649.00 | 100649.00 | 0.00 | 55 | 19 | 57 | 6 | 9.5 | 0.792809039692435 | 0.792809039692435 | false | false | false | true | ||||||||||||||||
| 3b93281d-d683-490f-a04f-8b41de67d789 | 2026-08-17 13:12 | 2026-08-17 13:12 | 2026-08-17 13:12 | TECL | TECL260918P00210000 | put | 210.0000 | 2026-09-18 | 15.1000 | 15.0000 | 15.3000 | 220.5994 | 61890.00 | 51340.00 | 10550.00 | 41 | 21 | 45 | 21 | 2.14285714285714 | 0.799588186519017 | 0.799588186519017 | true | false | false | true | ||||||||||||||||
| e439381e-0744-4ec1-b78f-01240b15c79b | 2026-08-17 12:41 | 2026-08-17 12:41 | 2026-08-17 12:41 | TECL | TECL261016C00235000 | call | 235.0000 | 2026-10-16 | 24.5000 | 23.1000 | 25.5000 | 221.4500 | 24500.00 | 2450.00 | 22050.00 | 10 | 5 | 10 | 47 | 0.212765957446809 | 0.823567809441961 | 0.823567809441961 | false | false | false | true | ||||||||||||||||
| 08524697-ab7e-43e7-b915-707246c26af6 | 2026-08-17 11:20 | 2026-08-17 11:20 | 2026-08-17 11:20 | TECL | TECL260918P00211960 | put | 211.9600 | 2026-09-18 | 14.9000 | 14.9000 | 15.7000 | 223.2650 | 58110.00 | 0.00 | 58110.00 | 39 | 9 | 39 | 1 | 39 | 0.794756957740327 | 0.794756957740327 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 5548400000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |