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_alerts425,429 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 |
|---|
| 1211dcd3-fb5a-433c-99f1-624a16296fd1 | 2026-08-19 12:36 | 2026-08-19 12:36 | 2026-08-19 12:36 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 2.9100 | 2.9100 | 2.9900 | 60.5100 | 14550.00 | 0.00 | 14550.00 | 50 | 5 | 148 | 2291 | 0.0646006110868616 | 0.755814472767952 | 0.755814472767952 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10911072057.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 888633a5-58ec-4543-a87b-1b4372e99594 | 2026-08-25 09:30 | 2026-08-25 09:30 | 2026-08-25 09:30 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 4.3500 | 4.1500 | 4.3500 | 66.5600 | 12180.00 | 3915.00 | 0.00 | 28 | 12 | 28 | 2456 | 0.011400651465798 | 0.728611400992061 | 0.728611400992061 | false | false | false | true | ||||||||||||||||
| 002ad0fa-fee4-412a-a2bb-16421acc1093 | 2026-08-25 12:27 | 2026-08-25 12:27 | 2026-08-25 12:27 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 5.9000 | 5.8000 | 6.2000 | 68.7100 | 12980.00 | 3540.00 | 9440.00 | 22 | 5 | 187 | 2456 | 0.0761400651465798 | 0.793165210155041 | 0.793165210155041 | true | false | false | true | ||||||||||||||||
| 42e41990-82da-4449-a87f-47f8092834c0 | 2026-08-26 13:39 | 2026-08-26 13:39 | 2026-08-26 13:39 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 5.7000 | 5.5000 | 5.7500 | 69.2785 | 26220.00 | 25650.00 | 570.00 | 46 | 32 | 158 | 2507 | 0.0630235341045074 | 0.75947766318736 | 0.75645916659903 | true | false | false | true | ||||||||||||||||
| 52d8f5a8-8fe2-4069-8994-8e43e6e89482 | 2026-08-27 10:00 | 2026-08-27 10:00 | 2026-08-27 10:00 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 5.7600 | 5.4500 | 5.9000 | 69.2000 | 57606.00 | 57606.00 | 0.00 | 100 | 13 | 369 | 2474 | 0.149151172190784 | 0.770699794172688 | 0.770699794172688 | false | false | false | true | ||||||||||||||||
| 84e2a212-abfd-429f-804f-13ccddaf4d4b | 2026-08-27 10:31 | 2026-08-27 10:30 | 2026-08-27 10:30 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 5.9000 | 5.9000 | 6.0000 | 69.6900 | 83190.00 | 0.00 | 83190.00 | 141 | 33 | 725 | 2474 | 0.293047696038804 | 0.765450974274732 | 0.765450974274732 | true | false | false | true | ||||||||||||||||
| 33fadf84-0211-4b16-816f-5bbace03fb02 | 2026-08-31 11:28 | 2026-08-31 11:28 | 2026-08-31 11:28 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 2.5200 | 2.4000 | 2.5600 | 62.5850 | 12622.00 | 12622.00 | 0.00 | 50 | 5 | 202 | 2771 | 0.0728978708047636 | 0.718496025711605 | 0.718496025711605 | false | false | false | true | ||||||||||||||||
| 56a6d3ad-19ca-4c4c-b9ad-37bafae84a8a | 2026-09-02 09:43 | 2026-09-02 09:43 | 2026-09-02 09:43 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 3.9200 | 3.7500 | 4.0000 | 66.2894 | 18807.00 | 18807.00 | 0.00 | 48 | 6 | 65 | 2771 | 0.0234572356549982 | 0.75444251280066 | 0.75444251280066 | false | false | false | true | ||||||||||||||||
| 961ab8aa-18d4-4735-948b-280aedb7cfc2 | 2026-09-15 09:54 | 2026-09-15 09:54 | 2026-09-15 09:54 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 2.4200 | 2.2700 | 2.4200 | 65.1250 | 12342.00 | 12342.00 | 0.00 | 51 | 8 | 162 | 3055 | 0.0530278232405892 | 0.746909827735223 | 0.746909827735223 | false | false | false | true | ||||||||||||||||
| 5edca210-cb98-49da-a33a-949c4bd350ae | 2026-09-15 14:59 | 2026-09-15 14:59 | 2026-09-15 14:59 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 3.5500 | 3.3500 | 3.5500 | 68.2000 | 15975.00 | 15975.00 | 0.00 | 45 | 14 | 456 | 3055 | 0.149263502454992 | 0.761676804707914 | 0.758660984778005 | true | false | false | true | ||||||||||||||||
| 6a8fe247-2bbc-463a-8ba1-cdaf30b653a8 | 2026-09-15 15:07 | 2026-09-15 15:07 | 2026-09-15 15:07 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 3.7000 | 3.5000 | 3.7000 | 68.6700 | 11100.00 | 11100.00 | 0.00 | 30 | 12 | 489 | 3055 | 0.160065466448445 | 0.756829345354555 | 0.754537761020121 | true | false | false | true | ||||||||||||||||
| 496f5865-3348-4ed8-a20a-4c0b9a175334 | 2026-09-16 12:59 | 2026-09-16 12:59 | 2026-09-16 12:59 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 4.5000 | 4.2500 | 4.5500 | 70.8250 | 10345.00 | 9900.00 | 445.00 | 23 | 14 | 360 | 3051 | 0.117994100294985 | 0.754925408800733 | 0.748689514273487 | true | false | false | true | ||||||||||||||||
| fac6d95c-afa8-4ed6-a059-c76ef39e7a37 | 2026-09-17 09:30 | 2026-09-17 09:30 | 2026-09-17 09:30 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 5.9000 | 5.1500 | 5.9000 | 73.9350 | 17110.00 | 17110.00 | 0.00 | 29 | 5 | 51 | 3218 | 0.0158483530142946 | 0.755680855801233 | 0.755680855801233 | true | false | false | true | ||||||||||||||||
| c89188b1-f792-4a21-b246-b696b5ca930a | 2026-09-17 09:38 | 2026-09-17 09:38 | 2026-09-17 09:38 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 5.9400 | 5.6500 | 6.2500 | 74.0600 | 59356.00 | 14320.00 | 40276.00 | 100 | 13 | 211 | 3218 | 0.0655686761963953 | 0.756234804015505 | 0.756234804015505 | false | false | false | true | ||||||||||||||||
| 3070560c-1284-4121-b1af-c3729325a803 | 2026-09-17 09:40 | 2026-09-17 09:40 | 2026-09-17 09:40 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 6.5000 | 6.1500 | 6.7000 | 75.0400 | 11050.00 | 11050.00 | 0.00 | 17 | 5 | 230 | 3218 | 0.0714729645742697 | 0.756672998003119 | 0.756672998003119 | false | false | false | true | ||||||||||||||||
| d01a1a93-6e8b-4890-b380-3b5ae20c3232 | 2026-09-17 09:46 | 2026-09-17 09:46 | 2026-09-17 09:46 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 7.4500 | 7.2000 | 7.7500 | 76.4000 | 74519.00 | 29282.00 | 45237.00 | 100 | 14 | 372 | 3218 | 0.115599751398384 | 0.786446643393813 | 0.786446643393813 | false | false | false | true | ||||||||||||||||
| 2884d624-35a6-4f21-91dc-025aabb02217 | 2026-09-17 10:03 | 2026-09-17 10:03 | 2026-09-17 10:03 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 8.0100 | 7.9000 | 8.3500 | 77.4000 | 80137.00 | 0.00 | 80137.00 | 100 | 5 | 638 | 3218 | 0.198259788688626 | 0.777636191879482 | 0.777636191879482 | false | false | false | true | ||||||||||||||||
| b5ebda37-e52d-42d2-b0b5-ac6ff7a16106 | 2026-09-24 09:56 | 2026-09-24 09:56 | 2026-09-24 09:56 | TEM | TEM261016C00075000 | call | 75.0000 | 2026-10-16 | 8.0000 | 7.3500 | 8.1000 | 78.8700 | 32000.00 | 32000.00 | 0.00 | 40 | 6 | 51 | 3148 | 0.0162007623888183 | 0.76518800903737 | 0.76518800903737 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:32:26.163070Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:00:28.149501Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:37:18.031558Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10911072057.00 |
| 2026-11-03 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12272105961.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 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-17T13:32:41.851557Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 14094418108.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 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-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 14094418108.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 13433194163.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |