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_alerts523,327 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 |
|---|
| a2da37d6-6f0a-4f0a-be93-dfc5d520d79b | 2026-09-28 14:53 | 2026-09-28 14:53 | 2026-09-28 14:53 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 7.7500 | 7.5000 | 7.7500 | 199.6400 | 15500.00 | 15500.00 | 0.00 | 20 | 7 | 1996 | 1709 | 1.16793446459918 | 0.945457902522212 | 0.945457902522212 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 78761256182.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:00:50.307488Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 55515700-5451-4ab3-9ce6-996e0d901186 | 2026-09-28 14:48 | 2026-09-28 14:48 | 2026-09-28 14:48 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 7.1000 | 7.0000 | 7.3500 | 198.7400 | 146280.00 | 144850.00 | 1430.00 | 206 | 7 | 1881 | 1709 | 1.10064365125805 | 0.921920185794148 | 0.927944725518033 | true | false | false | true | ||||||||||||||||
| 45f3608b-3943-49fe-a0b6-c54a0f640857 | 2026-09-28 13:50 | 2026-09-28 13:50 | 2026-09-28 13:50 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 6.9300 | 6.6500 | 7.0000 | 198.1200 | 10400.00 | 10400.00 | 0.00 | 15 | 6 | 1465 | 1709 | 0.857226448215331 | 0.948376093213517 | 0.946461994004597 | false | false | false | true | ||||||||||||||||
| 96cadd32-63b6-4924-9a97-6c59d2bc8cc9 | 2026-09-28 09:48 | 2026-09-28 09:47 | 2026-09-28 09:47 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 4.0500 | 4.0500 | 4.4500 | 191.1975 | 25920.00 | 0.00 | 25920.00 | 64 | 5 | 230 | 1709 | 0.13458162668227 | 0.934567542336714 | 0.934567542336714 | false | false | false | true | ||||||||||||||||
| 828786c0-4d66-4d9e-8bcc-de23546e85e3 | 2026-09-25 12:44 | 2026-09-25 12:44 | 2026-09-25 12:44 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 10.0000 | 8.5000 | 10.0500 | 201.7400 | 23000.00 | 23000.00 | 0.00 | 23 | 12 | 3912 | 1944 | 2.01234567901235 | 0.813674424335068 | 0.818204644437973 | true | false | false | true | ||||||||||||||||
| 92f01105-6b03-4bb9-b0b7-25522f845b61 | 2026-09-25 12:38 | 2026-09-25 12:38 | 2026-09-25 12:38 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 8.0000 | 8.0000 | 8.5500 | 198.8202 | 10400.00 | 0.00 | 10400.00 | 13 | 5 | 3847 | 1944 | 1.97890946502058 | 0.772496956346667 | 0.772496956346667 | false | false | false | true | ||||||||||||||||
| 08a0a6f9-3051-4276-b23d-c0c5420cef1a | 2026-09-25 12:00 | 2026-09-25 12:00 | 2026-09-25 12:00 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 8.0500 | 7.7000 | 8.2000 | 198.0000 | 11270.00 | 9660.00 | 1610.00 | 14 | 7 | 2647 | 1944 | 1.36162551440329 | 0.788680652547288 | 0.788680652547288 | true | false | false | true | ||||||||||||||||
| 8b754311-7200-4433-acab-64598b4c4b78 | 2026-09-25 11:44 | 2026-09-25 11:44 | 2026-09-25 11:44 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 7.9900 | 7.6500 | 8.0000 | 198.2200 | 73535.00 | 69560.00 | 3975.00 | 92 | 11 | 2282 | 1944 | 1.1738683127572 | 0.799714950355553 | 0.795148419258477 | false | false | false | true | ||||||||||||||||
| 7cabdacf-d589-44a0-b0e3-0bd27928afaf | 2026-09-25 11:44 | 2026-09-25 11:44 | 2026-09-25 11:44 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 8.0000 | 7.6000 | 8.0000 | 198.1600 | 122400.00 | 122400.00 | 0.00 | 153 | 9 | 2184 | 1944 | 1.12345679012346 | 0.802412582004013 | 0.802412582004013 | false | false | false | true | ||||||||||||||||
| 0be8ae3f-6134-432f-879c-c8caf082647e | 2026-09-25 09:36 | 2026-09-25 09:36 | 2026-09-25 09:36 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 7.0400 | 6.7000 | 7.3500 | 194.6000 | 32372.00 | 32372.00 | 0.00 | 46 | 7 | 115 | 1944 | 0.059156378600823 | 0.895381403924486 | 0.858648474346524 | false | false | false | true | ||||||||||||||||
| b7a47033-5d6d-487a-a3fb-1fa7bfba2e83 | 2026-09-22 11:09 | 2026-09-22 11:08 | 2026-09-22 11:08 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 6.3000 | 5.8000 | 6.3000 | 186.0000 | 13230.00 | 13230.00 | 0.00 | 21 | 5 | 485 | 885 | 0.548022598870056 | 0.922529631296305 | 0.922529631296305 | false | false | false | true | ||||||||||||||||
| 4960072e-0b79-4f1f-ad5c-c992ee039a45 | 2026-09-22 10:23 | 2026-09-22 10:23 | 2026-09-22 10:23 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 4.2000 | 3.7000 | 5.0000 | 181.0000 | 21000.00 | 14280.00 | 6720.00 | 50 | 8 | 218 | 885 | 0.246327683615819 | 0.888721238133925 | 0.888721238133925 | false | false | false | true | ||||||||||||||||
| 84e57c40-db2d-4bdb-89dc-6379a9f1b37e | 2026-09-21 10:33 | 2026-09-21 10:33 | 2026-09-21 10:33 | MRNA | MRNA261002C00200000 | call | 200.0000 | 2026-10-02 | 1.9300 | 1.6800 | 2.0000 | 169.5500 | 10422.00 | 1737.00 | 8685.00 | 54 | 17 | 343 | 502 | 0.683266932270916 | 0.865978590689543 | 0.865978590689543 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 78761256182.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:52:01.773916Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 78761256182.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:00:44.175376Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 78761256182.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:49:52.918259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 79400033604.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:45:32.616673Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 79400033604.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:45:32.616673Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 79400033604.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:00:57.770407Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 79400033604.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:46:29.692189Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 79400033604.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:46:29.692189Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 79400033604.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 72884503896.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 72884503896.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:27:42.600893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 69043854644.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |