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.
uw_flow_alerts609,118 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 | expiry |
|---|
| 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 |
|---|
| f60630fa-24ca-4ed3-84f1-98ca6d708ae7 | 2026-09-29 11:28 | 2026-09-29 11:28 | 2026-09-29 11:28 | TEM | TEM261120C00090000 | call | 90.0000 | 2026-11-20 | 7.4500 | 7.4500 | 8.0000 | 83.3650 | 11920.00 | 0.00 | 11920.00 | 16 | 6 | 80 | 1491 | 0.0536552649228706 | 0.787915196418536 | 0.787915196418536 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 14483786055.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T15:29:51.337369Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| d412b600-5059-4f94-9bd9-850a3efe13a8 | 2026-09-25 13:36 | 2026-09-25 13:36 | 2026-09-25 13:36 | TEM | TEM261120C00090000 | call | 90.0000 | 2026-11-20 | 9.2000 | 9.2000 | 9.2500 | 84.0000 | 18400.00 | 0.00 | 18400.00 | 20 | 11 | 300 | 1535 | 0.195439739413681 | 0.836422701470913 | 0.836422701470913 | false | false | false | true | ||||||||||||||||
| 11a31d0e-6cf4-4591-91c2-f28a2365ec24 | 2026-09-25 13:36 | 2026-09-25 13:36 | 2026-09-25 13:36 | TEM | TEM261120C00090000 | call | 90.0000 | 2026-11-20 | 9.2000 | 9.2000 | 9.2500 | 84.0000 | 18400.00 | 0.00 | 18400.00 | 20 | 7 | 340 | 1535 | 0.221498371335505 | 0.836422701470913 | 0.836422701470913 | false | false | false | true | ||||||||||||||||
| cb6d7a37-35b6-4cf4-a347-dda60bfe4c21 | 2026-09-24 10:06 | 2026-09-24 10:06 | 2026-09-24 10:06 | TEM | TEM261120C00090000 | call | 90.0000 | 2026-11-20 | 6.2700 | 5.9500 | 6.3000 | 79.1350 | 64605.00 | 49605.00 | 15000.00 | 103 | 18 | 174 | 1427 | 0.121934127540294 | 0.802940111718067 | 0.807050826346179 | true | false | false | true | ||||||||||||||||
| 7e17f33c-a7aa-4122-9539-1ade6a3bc743 | 2026-09-21 13:49 | 2026-09-21 13:49 | 2026-09-21 13:49 | TEM | TEM261120C00090000 | call | 90.0000 | 2026-11-20 | 6.0500 | 5.8000 | 6.3000 | 78.1300 | 22990.00 | 4235.00 | 18755.00 | 38 | 13 | 188 | 1421 | 0.132301196340605 | 0.798664013421426 | 0.798664013421426 | true | false | false | true | ||||||||||||||||
| 26687055-c2c8-4742-a434-eaba51341585 | 2026-09-17 10:04 | 2026-09-17 10:04 | 2026-09-17 10:04 | TEM | TEM261120C00090000 | call | 90.0000 | 2026-11-20 | 6.4000 | 6.1000 | 6.4000 | 77.7700 | 10880.00 | 10880.00 | 0.00 | 17 | 6 | 91 | 1555 | 0.0585209003215434 | 0.811451166847126 | 0.811451166847126 | true | false | false | true | ||||||||||||||||
| d51ef08f-9297-4031-8eba-9868b6ba31d2 | 2026-08-20 10:17 | 2026-08-20 10:17 | 2026-08-20 10:17 | TEM | TEM261120C00090000 | call | 90.0000 | 2026-11-20 | 4.0000 | 3.4500 | 4.0000 | 65.3350 | 355916.00 | 355916.00 | 0.00 | 890 | 51 | 914 | 256 | 3.5703125 | 0.816377563511772 | 0.816377563511772 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 14909986105.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 14909986105.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 13433194163.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:06:35.686187Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 13685757155.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:50:05.863152Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 14094418108.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |