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 | 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 |
|---|
| 42054fbc-f889-40d9-99a9-0cb60b1cbd2b | 2026-08-24 09:56 | 2026-08-24 09:56 | 2026-08-24 09:56 | VZ | VZ260828C00045000 | call | 45.0000 | 2026-08-28 | 5.0000 | 4.8500 | 5.1500 | 49.9600 | 105000.00 | 52500.00 | 30000.00 | 210 | 9 | 510 | 1521 | 0.335305719921105 | 0.501927130090118 | 0.501927130090118 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 213098420111.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f9a45f64-c977-40ce-8e19-3208342432ca | 2026-08-21 14:16 | 2026-08-21 14:16 | 2026-08-21 14:16 | VZ | VZ260821C00044000 | call | 44.0000 | 2026-08-21 | 5.3500 | 5.3000 | 5.4000 | 49.0000 | 88275.00 | 34775.00 | 0.00 | 165 | 5 | 435 | 4311 | 0.100904662491301 | 3.82136241268516 | 3.61055186384297 | false | false | false | true | ||||||||||||||||
| daa01b4c-da3b-4f17-bd50-156dea28fb9b | 2026-08-21 14:16 | 2026-08-21 14:16 | 2026-08-21 14:16 | VZ | VZ260821C00044000 | call | 44.0000 | 2026-08-21 | 5.3500 | 5.3000 | 5.4000 | 49.0000 | 86670.00 | 52430.00 | 27285.00 | 162 | 27 | 747 | 4311 | 0.173277661795407 | 3.71070275495066 | 3.30163165269617 | false | false | false | true | ||||||||||||||||
| 9ac0d660-b4fd-4021-8231-8438a00f7525 | 2026-08-20 15:24 | 2026-08-20 15:23 | 2026-08-20 15:23 | VZ | VZ280121P00055000 | put | 55.0000 | 2028-01-21 | 9.5500 | 9.3500 | 9.5500 | 49.2601 | 69715.00 | 69715.00 | 0.00 | 73 | 8 | 93 | 469 | 0.198294243070362 | 0.343829282005078 | 0.343829282005078 | false | false | false | true | ||||||||||||||||
| a1726938-1feb-4419-a805-1145b7b188b4 | 2026-08-20 11:20 | 2026-08-20 11:20 | 2026-08-20 11:20 | VZ | VZ261016C00049000 | call | 49.0000 | 2026-10-16 | 2.0000 | 1.9500 | 2.0900 | 49.4800 | 242400.00 | 0.00 | 242400.00 | 1212 | 8 | 1447 | 3432 | 0.421620046620047 | 0.204834493277693 | 0.204834493277693 | false | false | false | true | ||||||||||||||||
| f1544ca7-3953-49e7-833e-83bd7fab7480 | 2026-08-19 12:13 | 2026-08-19 12:12 | 2026-08-19 12:12 | VZ | VZ261016P00049000 | put | 49.0000 | 2026-10-16 | 1.9400 | 1.9400 | 2.0000 | 49.0350 | 50828.00 | 0.00 | 50828.00 | 262 | 18 | 335 | 330 | 1.01515151515152 | 0.270551861474274 | 0.270551861474274 | false | false | false | true | ||||||||||||||||
| 79f9fd58-f25f-4b64-9c7c-4d35254cfc20 | 2026-08-18 11:29 | 2026-08-18 11:29 | 2026-08-18 11:29 | VZ | VZ271217C00042000 | call | 42.0000 | 2027-12-17 | 8.7500 | 8.7500 | 9.0500 | 48.7150 | 70875.00 | 0.00 | 70875.00 | 81 | 5 | 81 | 1711 | 0.0473407364114553 | 0.0942148626223546 | 0.0942148626223546 | false | false | false | true | ||||||||||||||||
| c35bbacc-54be-4a6e-9a88-aa458f2bb7ad | 2026-08-17 13:54 | 2026-08-17 13:54 | 2026-08-17 13:54 | VZ | VZ261218P00047000 | put | 47.0000 | 2026-12-18 | 2.1800 | 2.1600 | 2.2200 | 48.0000 | 66708.00 | 28994.00 | 22018.00 | 306 | 44 | 312 | 1084 | 0.287822878228782 | 0.269580268939807 | 0.269580268939807 | true | false | false | true | ||||||||||||||||
| effeb35b-ab0f-4eeb-b234-84fd9ff84aa3 | 2026-08-17 13:27 | 2026-08-17 13:27 | 2026-08-17 13:27 | VZ | VZ260918C00048000 | call | 48.0000 | 2026-09-18 | 1.4500 | 1.4000 | 1.6400 | 48.0950 | 147450.00 | 144420.00 | 3030.00 | 1017 | 64 | 1224 | 11806 | 0.103676096899881 | 0.232753241819257 | 0.232753241819257 | false | false | false | true | ||||||||||||||||
| 20ccd8d7-476c-42ff-817e-007764296495 | 2026-08-17 13:24 | 2026-08-17 13:24 | 2026-08-17 13:24 | VZ | VZ280121C00045000 | call | 45.0000 | 2028-01-21 | 6.7000 | 6.5500 | 6.7500 | 48.1500 | 134000.00 | 67000.00 | 67000.00 | 200 | 5 | 204 | 3925 | 0.0519745222929936 | 0.138263225420127 | 0.138263225420127 | false | false | false | true | ||||||||||||||||
| 06316b7e-94be-4443-81dc-21e3f35238e0 | 2026-08-17 13:24 | 2026-08-17 13:24 | 2026-08-17 13:24 | VZ | VZ280121P00055000 | put | 55.0000 | 2028-01-21 | 10.3000 | 9.7500 | 10.3000 | 48.1500 | 56644.00 | 55619.00 | 1025.00 | 55 | 6 | 105 | 306 | 0.343137254901961 | 0.352453022872752 | 0.352017417810499 | false | false | false | true | ||||||||||||||||
| fd87366b-be9b-4ee5-9cf0-8d5626e74042 | 2026-08-17 10:45 | 2026-08-17 10:44 | 2026-08-17 10:44 | VZ | VZ260918C00050000 | call | 50.0000 | 2026-09-18 | 0.7200 | 0.6500 | 0.7200 | 48.4650 | 189071.00 | 189071.00 | 0.00 | 2626 | 60 | 2939 | 24896 | 0.118051092544987 | 0.22231331415576 | 0.22231331415576 | false | false | false | true | ||||||||||||||||
| 50b229f7-ae5c-43c4-81eb-f5d76e6b27db | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | VZ | VZ270617P00038000 | put | 38.0000 | 2027-06-17 | 1.1300 | 1.0700 | 1.1400 | 48.1600 | 56500.00 | 55822.00 | 678.00 | 500 | 7 | 500 | 4095 | 0.122100122100122 | 0.315813547200859 | 0.315813547200859 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 213098420111.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |