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 |
|---|
| 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 |
|---|
| 6a5e5178-9649-4aa4-b92f-fc5df6be3e22 | 2026-09-30 10:12 | 2026-09-30 10:12 | 2026-09-30 10:12 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 2.4600 | 2.4500 | 2.5100 | 188.0000 | 10844.00 | 0.00 | 10844.00 | 44 | 8 | 10312 | 6123 | 1.68414176057488 | 0.530783881919096 | 0.527171385271969 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 430164371123.00 | 2026-11-02 | 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 |
| 5e36988c-5f2b-4e5d-ba1c-1d986f6b2811 | 2026-09-30 09:50 | 2026-09-30 09:50 | 2026-09-30 09:50 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 2.5100 | 2.4400 | 2.5100 | 188.0000 | 50196.00 | 49196.00 | 1000.00 | 200 | 5 | 5561 | 6123 | 0.908214927323208 | 0.54856808050446 | 0.546757927721294 | true | false | false | |||||||||||||||||
| ffbff9f7-51ec-41ad-8cad-10079b565aba | 2026-09-30 09:37 | 2026-09-30 09:37 | 2026-09-30 09:37 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 2.5700 | 2.5500 | 2.6000 | 188.7650 | 11053.00 | 773.00 | 10280.00 | 43 | 5 | 3177 | 6123 | 0.518863302302793 | 0.561640653386211 | 0.559831282339906 | false | false | false | |||||||||||||||||
| 18676789-2a3e-4cf3-94d9-2e873b09bbbf | 2026-09-28 15:48 | 2026-09-28 15:47 | 2026-09-28 15:47 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.0000 | 2.9700 | 3.0500 | 187.6900 | 31794.00 | 300.00 | 31494.00 | 106 | 6 | 9196 | 4336 | 2.12084870848709 | 0.509279101666964 | 0.505378062038909 | false | false | false | |||||||||||||||||
| dc6d55f1-22a5-4241-8720-3a5528bb0ffa | 2026-09-28 09:32 | 2026-09-28 09:32 | 2026-09-28 09:32 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 2.8400 | 2.8400 | 2.9800 | 186.0600 | 26700.00 | 0.00 | 26700.00 | 94 | 8 | 220 | 4336 | 0.0507380073800738 | 0.575654649607575 | 0.574304090664201 | false | false | false | |||||||||||||||||
| 8dadd3bc-1ce7-4b52-9cbd-ed93dbf11929 | 2026-09-23 13:38 | 2026-09-23 13:38 | 2026-09-23 13:38 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 6.6100 | 6.5000 | 6.6500 | 191.2800 | 12565.00 | 12565.00 | 0.00 | 19 | 5 | 5404 | 3728 | 1.44957081545064 | 0.493393862774358 | 0.489181083827392 | false | false | false | |||||||||||||||||
| c8ff2636-df4e-451c-874b-abdef362c53e | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 7.2900 | 7.1500 | 7.4500 | 191.0000 | 10929.00 | 10204.00 | 725.00 | 15 | 5 | 2498 | 3728 | 0.670064377682403 | 0.526749775342257 | 0.514931697977777 | false | false | false | |||||||||||||||||
| 6fcd0e22-9c42-4781-aa09-b4d327da6468 | 2026-09-22 15:42 | 2026-09-22 15:42 | 2026-09-22 15:42 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.4500 | 3.4000 | 3.5500 | 184.3000 | 16896.00 | 13800.00 | 3096.00 | 49 | 5 | 3859 | 2388 | 1.61599664991625 | 0.468667338530965 | 0.467796672199821 | false | false | false | |||||||||||||||||
| ed6b041d-64cc-4640-b460-54b270b2740e | 2026-09-22 15:16 | 2026-09-22 15:16 | 2026-09-22 15:16 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.5100 | 3.4500 | 3.5500 | 184.3550 | 35142.00 | 35142.00 | 0.00 | 100 | 6 | 3477 | 2388 | 1.45603015075377 | 0.472990967026875 | 0.472990967026875 | false | false | false | |||||||||||||||||
| f00b54ba-4a0f-46e7-93f5-fb00ff79d356 | 2026-09-22 14:22 | 2026-09-22 14:22 | 2026-09-22 14:22 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.3500 | 3.3500 | 3.4000 | 183.8401 | 122282.00 | 0.00 | 122282.00 | 365 | 27 | 3272 | 2388 | 1.37018425460637 | 0.475368226775543 | 0.474487365427643 | false | false | false | |||||||||||||||||
| 21e90687-c8a7-4e9d-bae7-ff769bbde2ba | 2026-09-22 10:09 | 2026-09-22 10:09 | 2026-09-22 10:09 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.1900 | 3.1000 | 3.2000 | 183.2150 | 12774.00 | 12774.00 | 0.00 | 40 | 6 | 1385 | 2388 | 0.579983249581239 | 0.48060350143118 | 0.479706600233546 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 430164371123.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:50:15.846728Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 430164371123.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:38:56.066049Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 431337734921.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:53:15.788869Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 431337734921.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:33:12.079590Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 441253809369.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:39:01.188751Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 441253809369.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:46:41.730175Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 425608958732.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:23:27.944500Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:10:05.607073Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |