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_alerts566,287 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 | strike |
|---|
| 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 |
|---|
| 0be3ae7c-35e4-48da-aa96-90566265451c | 2026-09-28 14:52 | 2026-09-28 14:52 | 2026-09-28 14:52 | CLF | CLF261016C00011500 | call | 11.5000 | 2026-10-16 | 0.4800 | 0.4600 | 0.4900 | 11.0500 | 16894.00 | 10126.00 | 0.00 | 352 | 21 | 1426 | 6 | 237.666666666667 | 0.670475848088727 | 0.674212594876116 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 6401459327.00 | 2026-10-19 | 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 |
| 72d28218-213e-41b2-9ed9-33d9917c46cd | 2026-09-28 13:55 | 2026-09-28 13:55 | 2026-09-28 13:55 | CLF | CLF261120C00013000 | call | 13.0000 | 2026-11-20 | 0.5500 | 0.5200 | 0.5600 | 11.1050 | 18394.00 | 10024.00 | 0.00 | 334 | 13 | 890 | 2818 | 0.31582682753726 | 0.682566403580245 | 0.696711845219657 | false | false | ||||||||||||||||||
| e32aa958-febd-4074-a57f-8b199f53ea6c | 2026-09-28 13:15 | 2026-09-28 13:14 | 2026-09-28 13:14 | CLF | CLF261016P00012000 | put | 12.0000 | 2026-10-16 | 1.0900 | 1.0500 | 1.1000 | 11.2600 | 32622.00 | 32622.00 | 0.00 | 300 | 7 | 1880 | 4340 | 0.433179723502304 | 0.643103139874048 | 0.643103139874048 | false | false | ||||||||||||||||||
| 12da9811-1d9b-4881-a058-e50042bd5d3b | 2026-09-23 13:54 | 2026-09-23 13:53 | 2026-09-23 13:53 | CLF | CLF261016P00011500 | put | 11.5000 | 2026-10-16 | 0.2600 | 0.2200 | 0.2800 | 12.9100 | 10344.00 | 8944.00 | 0.00 | 400 | 8 | 413 | 532 | 0.776315789473684 | 0.626480510511686 | 0.626480510511686 | false | false | ||||||||||||||||||
| c64d3988-3ed9-4b9b-9ec4-2aedeb7ea431 | 2026-09-09 15:13 | 2026-09-09 15:12 | 2026-09-09 15:12 | CLF | CLF261120C00014000 | call | 14.0000 | 2026-11-20 | 0.7500 | 0.7400 | 0.7600 | 12.1150 | 14720.00 | 14720.00 | 0.00 | 195 | 10 | 274 | 544 | 0.503676470588235 | 0.641506442844562 | 0.64643455176439 | false | false | ||||||||||||||||||
| f61d0217-3966-4dec-b3c2-8a0032afc3b1 | 2026-09-02 10:35 | 2026-09-02 10:35 | 2026-09-02 10:35 | CLF | CLF261120C00015000 | call | 15.0000 | 2026-11-20 | 0.6400 | 0.6100 | 0.6500 | 12.3450 | 15364.00 | 1512.00 | 63.00 | 241 | 5 | 241 | 899 | 0.268075639599555 | 0.630908552414671 | 0.635817703182098 | false | false | ||||||||||||||||||
| 4caa9fa4-5f16-4bc0-8a92-41842853f116 | 2026-08-27 09:58 | 2026-08-27 09:58 | 2026-08-27 09:58 | CLF | CLF270115P00013000 | put | 13.0000 | 2027-01-15 | 2.5500 | 2.3500 | 2.5900 | 11.6200 | 11491.00 | 10980.00 | 511.00 | 45 | 8 | 45 | 1727 | 0.0260567458019687 | 0.631944302075323 | 0.635419262741327 | false | false | ||||||||||||||||||
| 374690fe-915a-4bc9-85b1-0a50291da1f4 | 2026-08-24 10:13 | 2026-08-24 10:12 | 2026-08-24 10:12 | CLF | CLF260828C00012500 | call | 12.5000 | 2026-08-28 | 0.2300 | 0.2000 | 0.2400 | 12.0550 | 18139.00 | 15498.00 | 2421.00 | 791 | 99 | 3108 | 2282 | 1.36196319018405 | 0.817500806992742 | 0.827664410465649 | true | false | ||||||||||||||||||
| 67650ac1-2d1a-4948-8c2e-c711e386cee0 | 2026-08-21 14:44 | 2026-08-21 14:44 | 2026-08-21 14:44 | CLF | CLF270319C00015000 | call | 15.0000 | 2027-03-19 | 1.2000 | 1.1600 | 1.2000 | 11.2600 | 42358.00 | 42358.00 | 0.00 | 354 | 27 | 609 | 4686 | 0.129961587708067 | 0.657005398050283 | 0.660056274188905 | false | false | ||||||||||||||||||
| 7abeb3ac-f4db-471c-81fc-8aea25f2af2d | 2026-08-21 11:33 | 2026-08-21 11:33 | 2026-08-21 11:33 | CLF | CLF260918C00013000 | call | 13.0000 | 2026-09-18 | 0.3900 | 0.3600 | 0.4000 | 11.6300 | 117359.00 | 96572.00 | 20787.00 | 3000 | 86 | 4615 | 12912 | 0.357419454770756 | 0.679423662931601 | 0.675921255054525 | true | false | ||||||||||||||||||
| 90627f75-bf62-44f4-85db-d0c9feece2fe | 2026-08-20 15:21 | 2026-08-20 15:21 | 2026-08-20 15:21 | CLF | CLF260918C00010000 | call | 10.0000 | 2026-09-18 | 1.1400 | 1.0900 | 1.1500 | 10.6800 | 113998.00 | 113998.00 | 0.00 | 1000 | 6 | 2567 | 8881 | 0.289044026573584 | 0.621208592418561 | 0.621208592418561 | false | false |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 6401459327.00 |
| 2026-10-19 |
| 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 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 6401459327.00 |
| 2026-10-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:15:39.910905Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 7342850405.00 |
| 2026-10-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:55:17.981841Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 6646791548.00 |
| 2026-10-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 6646791548.00 |
| 2026-10-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 6646791548.00 |
| 2026-10-19 |
| 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 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 6646791548.00 |
| 2026-10-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 6646791548.00 |
| 2026-10-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 6646791548.00 |
| 2026-10-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 6646791548.00 |
| 2026-10-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |