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_alerts474,253 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 |
|---|
| db7f1eb8-f502-4246-83e7-a856955209e0 | 2026-09-25 11:45 | 2026-09-25 11:45 | 2026-09-25 11:45 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 5.2000 | 5.2000 | 5.4000 | 190.8800 | 10400.00 | 0.00 | 10400.00 | 20 | 5 | 1627 | 3686 | 0.441399891481281 | 0.444009779658728 | 0.444009779658728 | false | false | false | true | false | 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-25T15:46:29.692189Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 2620c64a-53b8-4088-b441-f9d7309a48c1 | 2026-09-25 11:25 | 2026-09-25 11:25 | 2026-09-25 11:25 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 5.7300 | 5.7000 | 5.9000 | 191.0000 | 11456.00 | 0.00 | 11456.00 | 20 | 5 | 1415 | 3686 | 0.383884970157352 | 0.444541126043932 | 0.449348777658055 | false | false | false | |||||||||||||||||
| 66e4af1e-719b-4c55-b218-41bdf04e7434 | 2026-09-24 12:23 | 2026-09-24 12:23 | 2026-09-24 12:23 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 8.0000 | 7.8500 | 8.0500 | 193.9750 | 13600.00 | 13600.00 | 0.00 | 17 | 5 | 1654 | 3634 | 0.455145844799119 | 0.502271619430038 | 0.502271619430038 | false | false | false | |||||||||||||||||
| 474cf98b-daca-4132-89f7-a8a716c8717f | 2026-09-24 11:07 | 2026-09-24 11:07 | 2026-09-24 11:07 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 6.4100 | 6.4000 | 6.5500 | 191.7156 | 14100.00 | 1300.00 | 12800.00 | 22 | 5 | 1283 | 3634 | 0.35305448541552 | 0.479990044698015 | 0.488955285068173 | false | false | false | |||||||||||||||||
| fdf6f3c0-7724-4215-994a-a5cb430df1d8 | 2026-09-24 10:47 | 2026-09-24 10:47 | 2026-09-24 10:47 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 7.0000 | 6.8500 | 7.1000 | 192.0000 | 17500.00 | 13300.00 | 0.00 | 25 | 10 | 1142 | 3634 | 0.314254265272427 | 0.493056496657722 | 0.490388872335307 | false | false | false | |||||||||||||||||
| 2c4b96b8-d8c5-4ad8-97dd-98138e973740 | 2026-09-24 10:13 | 2026-09-24 10:13 | 2026-09-24 10:13 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 6.2000 | 6.0000 | 6.2500 | 191.0000 | 25425.00 | 25425.00 | 0.00 | 41 | 5 | 865 | 3634 | 0.238029719317556 | 0.497840422700182 | 0.502304596733121 | 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 | |||||||||||||||||
| 9de660a8-e620-4d2c-a34c-aadaefe3a4ea | 2026-09-23 09:44 | 2026-09-23 09:44 | 2026-09-23 09:44 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 8.1000 | 8.1000 | 8.3500 | 193.0000 | 18630.00 | 0.00 | 18630.00 | 23 | 6 | 2292 | 3728 | 0.61480686695279 | 0.532322075062518 | 0.532322075062518 | 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 | |||||||||||||||||
| 8f3353f8-9473-4d3d-b65a-ca3391aa456f | 2026-09-22 15:16 | 2026-09-22 15:16 | 2026-09-22 15:16 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.5000 | 3.5000 | 3.6000 | 184.3800 | 21350.00 | 0.00 | 21350.00 | 61 | 5 | 3572 | 2388 | 1.49581239530988 | 0.470452367832516 | 0.470452367832516 | 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 | |||||||||||||||||
| 2966431b-1824-4c4a-9938-3f54a6477e1b | 2026-09-22 11:15 | 2026-09-22 11:15 | 2026-09-22 11:15 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.6000 | 3.5000 | 3.6000 | 184.3001 | 70200.00 | 70200.00 | 0.00 | 195 | 14 | 2071 | 2388 | 0.867252931323283 | 0.481697351880162 | 0.481697351880162 | 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 | |||||||||||||||||
| 87d21452-fd10-4644-a4c7-41b885827827 | 2026-09-22 09:57 | 2026-09-22 09:57 | 2026-09-22 09:57 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.3500 | 3.2500 | 3.3500 | 183.6200 | 10720.00 | 10720.00 | 0.00 | 32 | 11 | 1124 | 2388 | 0.470686767169179 | 0.48327018739081 | 0.481393159765802 | false | false | false | |||||||||||||||||
| ffb66939-434a-4ef9-a653-1248969a3dcb | 2026-09-21 12:24 | 2026-09-21 12:24 | 2026-09-21 12:24 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.4500 | 3.4500 | 3.5500 | 183.1700 | 49338.00 | 0.00 | 49338.00 | 143 | 5 | 2858 | 1738 | 1.64441887226697 | 0.480284324923627 | 0.482828006047898 | false | false | false | |||||||||||||||||
| ea7a621f-cee4-4644-a038-651c2e2b84db | 2026-09-21 12:22 | 2026-09-21 12:22 | 2026-09-21 12:22 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.4000 | 3.4000 | 3.5500 | 183.2900 | 68000.00 | 0.00 | 68000.00 | 200 | 27 | 2705 | 1738 | 1.55638665132336 | 0.472473885241054 | 0.472473885241054 | false | false | false | |||||||||||||||||
| e0e91503-bc2f-418c-8143-acb57cba5fd0 | 2026-09-21 11:41 | 2026-09-21 11:41 | 2026-09-21 11:41 | PLTR | PLTR261002C00190000 | call | 190.0000 | 2026-10-02 | 3.0500 | 2.9900 | 3.0500 | 182.1000 | 10065.00 | 10065.00 | 0.00 | 33 | 9 | 2327 | 1738 | 1.33889528193326 | 0.47690800737798 | 0.47690800737798 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 436376297111.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:30:17.746556Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 441253809369.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:24:07.570312Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 441253809369.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:08:24.285262Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-24T14:50:12.704684Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 441253809369.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:14:26.159357Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:45:53.710169Z"} |
| 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 |
| 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-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-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 |
| 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-22T15:15:45.651673Z"} |
| 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 |
| false |
| 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-22T13:58:41.675080Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-21T15:43:39.846801Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |