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 |
|---|
| bb38117b-8db4-4386-8390-e3ed90c1be93 | 2026-09-08 15:11 | 2026-09-08 15:11 | 2026-09-08 15:11 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 14.1000 | 14.1000 | 14.3500 | 170.5802 | 128310.00 | 0.00 | 128310.00 | 91 | 7 | 491 | 6821 | 0.071983580120217 | 0.573846220904051 | 0.573846220904051 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 398736627049.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f62ac639-89a0-4dd7-81f7-91158a0c721c | 2026-09-09 14:32 | 2026-09-09 14:32 | 2026-09-09 14:32 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 13.7500 | 13.7500 | 13.9000 | 170.3500 | 94875.00 | 0.00 | 94875.00 | 69 | 11 | 201 | 7186 | 0.0279710548288338 | 0.569966820409284 | 0.569966820409284 | false | false | false | true | ||||||||||||||||
| baba874d-6df3-42a5-9c71-d10c838d3820 | 2026-09-21 10:03 | 2026-09-21 10:03 | 2026-09-21 10:03 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.3000 | 18.2500 | 18.4500 | 181.6050 | 20130.00 | 1830.00 | 18300.00 | 11 | 7 | 109 | 7960 | 0.0136934673366834 | 0.580932128437663 | 0.577913945295683 | false | false | false | true | ||||||||||||||||
| 942b6724-3296-478c-a584-dee6a6bd4ffe | 2026-09-21 10:10 | 2026-09-21 10:10 | 2026-09-21 10:10 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.0000 | 17.9000 | 18.2000 | 181.0000 | 18000.00 | 0.00 | 18000.00 | 10 | 5 | 124 | 7960 | 0.0155778894472362 | 0.578447761602722 | 0.578447761602722 | false | false | false | true | ||||||||||||||||
| 208d556f-c25c-4989-9dc4-48ee549da687 | 2026-09-21 11:44 | 2026-09-21 11:44 | 2026-09-21 11:44 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.5900 | 18.3000 | 18.6000 | 182.4000 | 22310.00 | 22310.00 | 0.00 | 12 | 10 | 263 | 7960 | 0.0330402010050251 | 0.572710393510338 | 0.5741646130784 | true | false | false | true | ||||||||||||||||
| 8ba6153b-9745-4a8d-b1ff-fc8c1485bb29 | 2026-09-22 09:44 | 2026-09-22 09:44 | 2026-09-22 09:44 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 19.5500 | 19.5500 | 19.6500 | 184.0000 | 52785.00 | 0.00 | 52785.00 | 27 | 6 | 76 | 7908 | 0.00961052099140111 | 0.572437048229201 | 0.572437048229201 | false | false | false | true | ||||||||||||||||
| 37a89b05-8e38-4f50-b7b4-c9820d894723 | 2026-09-22 10:03 | 2026-09-22 10:03 | 2026-09-22 10:03 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.6000 | 18.5000 | 18.6000 | 182.7750 | 26040.00 | 26040.00 | 0.00 | 14 | 5 | 136 | 7908 | 0.0171977744056651 | 0.571744459512717 | 0.571744459512717 | false | false | false | true | ||||||||||||||||
| 6f134f16-98a9-4046-bb09-c946b23b9f55 | 2026-09-22 10:34 | 2026-09-22 10:34 | 2026-09-22 10:34 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.4500 | 18.3500 | 18.4500 | 182.6350 | 11070.00 | 11070.00 | 0.00 | 6 | 6 | 422 | 7908 | 0.0533636823469904 | 0.569357892187965 | 0.569357892187965 | true | false | false | true | ||||||||||||||||
| e87668c7-50f3-49ef-ac8f-5fc824bb07df | 2026-09-22 10:35 | 2026-09-22 10:35 | 2026-09-22 10:35 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.3500 | 18.3000 | 18.3500 | 182.4450 | 23855.00 | 23855.00 | 0.00 | 13 | 7 | 467 | 7908 | 0.0590541224076884 | 0.56941511968346 | 0.569720725373007 | true | false | false | true | ||||||||||||||||
| 168ca7f6-3920-40b6-86c7-f1583066810d | 2026-09-22 10:35 | 2026-09-22 10:35 | 2026-09-22 10:35 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.3000 | 18.2500 | 18.3000 | 182.3700 | 16470.00 | 16470.00 | 0.00 | 9 | 6 | 498 | 7908 | 0.0629742033383915 | 0.56949356044857 | 0.56949356044857 | true | false | false | true | ||||||||||||||||
| 1d66c89a-ecd7-4e87-ba5d-4912777b9bbb | 2026-09-22 10:35 | 2026-09-22 10:35 | 2026-09-22 10:35 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.3000 | 18.2500 | 18.4000 | 182.3850 | 21960.00 | 10980.00 | 10980.00 | 12 | 6 | 513 | 7908 | 0.0648710166919575 | 0.568684809131274 | 0.56919033416299 | false | false | false | true | ||||||||||||||||
| f0302494-7256-479b-95ce-0a0413a695ea | 2026-09-22 10:35 | 2026-09-22 10:35 | 2026-09-22 10:35 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.3000 | 18.2500 | 18.3000 | 182.4000 | 23790.00 | 23790.00 | 0.00 | 13 | 5 | 571 | 7908 | 0.0722053616590794 | 0.568887041357882 | 0.568887041357882 | false | false | false | true | ||||||||||||||||
| 389ac9d3-f5d9-4290-89d5-e81e4d83f236 | 2026-09-22 10:36 | 2026-09-22 10:36 | 2026-09-22 10:36 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.3500 | 18.2000 | 18.3500 | 182.4900 | 45875.00 | 45875.00 | 0.00 | 25 | 5 | 635 | 7908 | 0.0802984319676277 | 0.568809779925839 | 0.568809779925839 | false | false | false | true | ||||||||||||||||
| 75964d40-9cb3-46e6-bcd3-fc28c82cb9f2 | 2026-09-22 10:37 | 2026-09-22 10:37 | 2026-09-22 10:37 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 18.5000 | 18.4500 | 18.5000 | 182.7300 | 55500.00 | 55500.00 | 0.00 | 30 | 5 | 696 | 7908 | 0.0880121396054628 | 0.569578549288799 | 0.569172093557647 | false | false | false | true | ||||||||||||||||
| 1366b8ed-f2d1-400b-9cb4-e157a1844d92 | 2026-09-22 12:25 | 2026-09-22 12:25 | 2026-09-22 12:25 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 19.0000 | 18.8500 | 19.0000 | 183.4800 | 152000.00 | 152000.00 | 0.00 | 80 | 10 | 874 | 7908 | 0.110520991401113 | 0.571272953514095 | 0.571272953514095 | true | false | false | true | ||||||||||||||||
| bff8bcca-6e4c-4887-9fd2-4d88a9e8fc8f | 2026-09-25 10:35 | 2026-09-25 10:35 | 2026-09-25 10:35 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 23.9000 | 23.8000 | 24.1000 | 191.5300 | 11950.00 | 0.00 | 11950.00 | 5 | 5 | 24 | 8162 | 0.00294045577064445 | 0.582163265625264 | 0.582163265625264 | false | false | false | true | ||||||||||||||||
| bf98aa5f-d6f3-4dfd-b606-ac809d83bd37 | 2026-09-28 12:26 | 2026-09-28 12:26 | 2026-09-28 12:26 | PLTR | PLTR261120C00180000 | call | 180.0000 | 2026-11-20 | 21.9900 | 21.7000 | 22.0000 | 188.7800 | 164908.00 | 164908.00 | 0.00 | 75 | 6 | 180 | 8159 | 0.0220615271479348 | 0.594549476354407 | 0.595290485767551 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 398736627049.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 421237603407.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 421237603407.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:12:42.136586Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 421237603407.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:46:21.763749Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:35:47.926453Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:35:47.926453Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:35:47.926453Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:35:47.926453Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:38:45.745623Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:38:45.745623Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:38:45.745623Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:27:20.551854Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 436376297111.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:37:32.022295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 431337734921.00 |
| 2026-11-02 |
| 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 |