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 | strikenumeric |
|---|
| 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 |
|---|
| 8dbf084f-c7ba-425a-991b-d78b27899385 | 2026-09-28 10:01 | 2026-09-28 10:01 | 2026-09-28 10:01 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 4.7700 | 4.7000 | 5.0000 | 724.8400 | 10972.00 | 7125.00 | 3847.00 | 23 | 5 | 4126 | 306 | 13.483660130719 | 0.629040099870385 | 0.644966854029998 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 1578034063611.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T14:03:25.739526Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| d846dffc-382b-4699-af25-f6fd4f5a7dc1 | 2026-09-28 10:03 | 2026-09-28 10:02 | 2026-09-28 10:02 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 5.0000 | 4.8000 | 5.1000 | 725.3500 | 11505.00 | 11505.00 | 0.00 | 23 | 6 | 4716 | 306 | 15.4117647058824 | 0.620530726121501 | 0.638305048968565 | false | false | false | |||||||||||||||||
| 2f1c086d-04d0-4ff5-9385-d03e9c8b7645 | 2026-09-28 10:17 | 2026-09-28 10:17 | 2026-09-28 10:17 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 3.5400 | 3.4500 | 3.6500 | 723.1200 | 12399.00 | 7101.00 | 1393.00 | 35 | 7 | 8930 | 306 | 29.1830065359477 | 0.576189633627775 | 0.590699494394453 | false | false | false | |||||||||||||||||
| 691ea172-e528-452b-bdd7-56a28048aabf | 2026-09-28 10:59 | 2026-09-28 10:59 | 2026-09-28 10:59 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.5000 | 2.3500 | 2.5500 | 721.6318 | 29212.00 | 28965.00 | 247.00 | 117 | 23 | 14219 | 306 | 46.4673202614379 | 0.588868656552971 | 0.580229979602332 | true | false | false | |||||||||||||||||
| e5eef74f-e349-4bc4-b13d-88a760002b18 | 2026-09-28 12:24 | 2026-09-28 12:24 | 2026-09-28 12:24 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.2000 | 2.0800 | 2.2500 | 723.1100 | 10109.00 | 9889.00 | 0.00 | 46 | 7 | 22835 | 306 | 74.6241830065359 | 0.520138561562499 | 0.521178591738785 | true | false | false | |||||||||||||||||
| c57e3822-0e3b-449f-96d1-245f41af6989 | 2026-09-28 12:25 | 2026-09-28 12:25 | 2026-09-28 12:25 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.2200 | 2.0800 | 2.2300 | 723.3129 | 20420.00 | 440.00 | 19980.00 | 92 | 7 | 23102 | 306 | 75.4967320261438 | 0.507026319682038 | 0.507026319682038 | true | false | false | |||||||||||||||||
| dad72715-9b82-4c42-b96d-1ff975194434 | 2026-09-28 12:26 | 2026-09-28 12:25 | 2026-09-28 12:25 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.2900 | 2.2200 | 2.3200 | 723.5400 | 17896.00 | 13798.00 | 4098.00 | 78 | 21 | 23462 | 306 | 76.6732026143791 | 0.512945695666446 | 0.5038064381558 | true | false | false | |||||||||||||||||
| d8309fb3-e736-4a18-98dd-94d2c05e9c72 | 2026-09-28 12:26 | 2026-09-28 12:26 | 2026-09-28 12:26 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.4800 | 2.3900 | 2.5000 | 724.4599 | 20065.00 | 19825.00 | 240.00 | 81 | 13 | 23905 | 306 | 78.1209150326797 | 0.455847082145435 | 0.473063902469222 | true | false | false | |||||||||||||||||
| 2ac2f4d5-d41d-4051-b892-3be5adfc1467 | 2026-09-28 12:52 | 2026-09-28 12:52 | 2026-09-28 12:52 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 1.8000 | 1.7100 | 1.8400 | 722.8300 | 26230.00 | 21550.00 | 0.00 | 146 | 6 | 29904 | 306 | 97.7254901960784 | 0.504907649324604 | 0.503708916366013 | false | false | false | |||||||||||||||||
| eabb43bb-4da9-456e-87d3-981992cc3e91 | 2026-09-28 13:02 | 2026-09-28 13:02 | 2026-09-28 13:02 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 1.5300 | 1.4500 | 1.5300 | 722.4600 | 12057.00 | 12057.00 | 0.00 | 79 | 22 | 32030 | 306 | 104.673202614379 | 0.492731101338277 | 0.490342282310794 | true | false | false | |||||||||||||||||
| c92b4e12-123c-462f-8ebd-db53c4a05428 | 2026-09-28 13:12 | 2026-09-28 13:12 | 2026-09-28 13:12 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 1.9000 | 1.8000 | 1.9500 | 723.0000 | 19561.00 | 15200.00 | 4361.00 | 103 | 7 | 33234 | 306 | 108.607843137255 | 0.536223291685363 | 0.540268892156919 | false | false | false | |||||||||||||||||
| 87b05bd4-d8e0-466c-8ef1-0435f0258d81 | 2026-09-28 14:26 | 2026-09-28 14:26 | 2026-09-28 14:26 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 1.0100 | 0.9800 | 1.0500 | 722.3448 | 10621.00 | 10621.00 | 0.00 | 105 | 5 | 40870 | 306 | 133.562091503268 | 0.537849313064904 | 0.549651187264057 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:03:25.739526Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:18:45.811547Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:01:52.060675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:25:44.498264Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:25:44.498264Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:26:41.677786Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:26:41.677786Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:56:37.183860Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:04:44.009732Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:30:52.408628Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |