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_alerts609,118 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 |
|---|
| ac5744ea-92b5-465f-a121-03bdad2bd121 | 2026-09-30 14:25 | 2026-09-30 14:25 | 2026-09-30 14:25 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 6.5900 | 6.3000 | 6.7500 | 237.9900 | 11196.00 | 2620.00 | 8576.00 | 17 | 10 | 1782 | 1593 | 1.11864406779661 | 0.901156132761598 | 0.894025563851038 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 52091135962.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T18:26:32.922967Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| bd59d415-9fea-4ee6-9659-9fe0bdbb25a5 | 2026-09-30 12:06 | 2026-09-30 12:06 | 2026-09-30 12:06 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 8.6600 | 8.5000 | 8.7000 | 241.0702 | 173169.00 | 113829.00 | 0.00 | 200 | 12 | 1117 | 1593 | 0.701192718141871 | 0.953306087305594 | 0.94605874500071 | true | false | false | true | ||||||||||||||||
| fa2d42c0-5f66-43fb-936a-46830beae25f | 2026-09-30 11:50 | 2026-09-30 11:50 | 2026-09-30 11:50 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 7.7000 | 7.6500 | 7.8000 | 239.0000 | 30030.00 | 5390.00 | 19250.00 | 39 | 5 | 559 | 1593 | 0.350910232266164 | 0.913826880487143 | 0.913826880487143 | true | false | false | true | ||||||||||||||||
| 0e0b26ec-ecdf-43a1-be8b-3e05954c2451 | 2026-09-30 10:13 | 2026-09-30 10:13 | 2026-09-30 10:13 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 8.2500 | 8.0500 | 8.6500 | 239.0000 | 33002.00 | 3300.00 | 13202.00 | 40 | 6 | 232 | 1593 | 0.145637162586315 | 1.00286004525969 | 0.992511032835516 | false | false | false | true | ||||||||||||||||
| 8ba20feb-f71b-44af-97f7-9d4834f691dd | 2026-09-30 09:30 | 2026-09-30 09:30 | 2026-09-30 09:30 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 12.3000 | 11.1000 | 12.4750 | 245.4100 | 25835.00 | 25835.00 | 0.00 | 21 | 6 | 81 | 1593 | 0.0508474576271186 | 1.07619541433518 | 1.0838385504078 | false | false | false | true | ||||||||||||||||
| 65f0db47-86ea-4fd4-86a5-4bdc531950cb | 2026-09-30 09:30 | 2026-09-30 09:30 | 2026-09-30 09:30 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 11.0300 | 11.0000 | 12.4000 | 244.9400 | 28690.00 | 6630.00 | 22060.00 | 26 | 5 | 46 | 1593 | 0.0288763339610797 | 0.932810313470016 | 0.94057694939666 | false | false | false | true | ||||||||||||||||
| e8b53e01-c824-413e-91dd-ea97653a6155 | 2026-09-28 15:19 | 2026-09-28 15:19 | 2026-09-28 15:19 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 6.5000 | 6.4000 | 6.5500 | 232.7894 | 21450.00 | 20150.00 | 0.00 | 33 | 8 | 2250 | 335 | 6.71641791044776 | 0.87701242487229 | 0.87701242487229 | false | false | false | true | ||||||||||||||||
| f461f353-27f6-47b2-9871-74eaa441f8b5 | 2026-09-28 13:16 | 2026-09-28 13:16 | 2026-09-28 13:16 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 7.4500 | 7.3500 | 7.5000 | 234.3850 | 836635.00 | 835890.00 | 745.00 | 1123 | 20 | 1762 | 335 | 5.25970149253731 | 0.901102951094651 | 0.901102951094651 | false | false | false | true | ||||||||||||||||
| 1cef3ffe-4317-4048-99f1-cce39030ae13 | 2026-09-28 09:40 | 2026-09-28 09:39 | 2026-09-28 09:39 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 12.6100 | 12.5000 | 13.0000 | 243.1500 | 32776.00 | 2525.00 | 30251.00 | 26 | 12 | 178 | 335 | 0.53134328358209 | 0.918058840422367 | 0.936508837384155 | true | false | false | true | ||||||||||||||||
| a770349f-7d1f-418a-9a79-8a83b2e64083 | 2026-09-28 09:38 | 2026-09-28 09:38 | 2026-09-28 09:38 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 12.6800 | 12.3500 | 12.9000 | 243.1988 | 12680.00 | 10144.00 | 2536.00 | 10 | 5 | 149 | 335 | 0.444776119402985 | 0.93400072012986 | 0.946785252959729 | false | false | false | true | ||||||||||||||||
| 5fa40b46-27ec-4b79-a24b-317a764d6b3e | 2026-09-22 15:27 | 2026-09-22 15:27 | 2026-09-22 15:27 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 12.9500 | 12.7000 | 13.2000 | 237.4460 | 19425.00 | 11655.00 | 3885.00 | 15 | 6 | 318 | 67 | 4.74626865671642 | 0.820400770007846 | 0.820400770007846 | false | false | false | true | ||||||||||||||||
| b08101c3-6ee5-47e0-b587-99414e8f76a5 | 2026-09-22 14:00 | 2026-09-22 14:00 | 2026-09-22 14:00 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 11.7000 | 11.2500 | 11.7000 | 234.8700 | 23400.00 | 23400.00 | 0.00 | 20 | 5 | 216 | 67 | 3.22388059701493 | 0.825110862451351 | 0.825110862451351 | false | false | false | true | ||||||||||||||||
| 6910061b-a16f-4baa-95a3-dac5f746048c | 2026-09-21 15:54 | 2026-09-21 15:54 | 2026-09-21 15:54 | NBIS | NBIS261002C00237500 | call | 237.5000 | 2026-10-02 | 11.2500 | 10.7000 | 11.2500 | 232.0000 | 12375.00 | 12375.00 | 0.00 | 11 | 6 | 140 | 63 | 2.22222222222222 | 0.834011247343764 | 0.834011247343764 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:13:44.335833Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T15:53:08.656115Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:14:21.800901Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:30:21.950232Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:30:21.950232Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 50889564605.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:23:02.177643Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 50889564605.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:19:28.127725Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 50889564605.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:41:17.796982Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 50889564605.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:39:03.459259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:27:59.988967Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51820096579.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 51091472486.00 |
| — |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |