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 |
|---|
| 40e24996-ba98-4cc1-96bb-a09096258975 | 2026-08-21 13:34 | 2026-08-21 13:34 | 2026-08-21 13:34 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 12.2500 | 12.1500 | 12.2500 | 179.9800 | 274400.00 | 274400.00 | 0.00 | 224 | 8 | 1743 | 7798 | 0.223518850987433 | 0.473541366591383 | 0.47256509159748 | 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-08-21T17:35:06.376767Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 783572d7-a986-44b3-b8b2-3e0ed92c4c40 | 2026-08-24 09:33 | 2026-08-24 09:33 | 2026-08-24 09:33 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 7.3500 | 7.2000 | 7.3500 | 171.8100 | 271215.00 | 271215.00 | 0.00 | 369 | 9 | 2442 | 9613 | 0.254030999687923 | 0.479187155690782 | 0.478656941779665 | true | false | false | |||||||||||||||||
| e6d5415c-af93-494e-8d21-ad75f052b34d | 2026-08-24 09:35 | 2026-08-24 09:35 | 2026-08-24 09:35 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 7.6500 | 7.5500 | 7.6500 | 172.4500 | 87975.00 | 87975.00 | 0.00 | 115 | 12 | 2887 | 9613 | 0.300322479975034 | 0.479990602358788 | 0.478234712485698 | true | false | false | |||||||||||||||||
| 37b9f678-c783-4969-afc5-3fb58aa5a117 | 2026-09-09 09:31 | 2026-09-09 09:31 | 2026-09-09 09:31 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 3.2000 | 3.2000 | 3.4000 | 169.6264 | 57600.00 | 0.00 | 57600.00 | 180 | 6 | 230 | 10579 | 0.021741185367237 | 0.501618353151617 | 0.501618353151617 | false | false | false | |||||||||||||||||
| 6abfa479-e7b3-409b-8b50-3fda7e93cfb1 | 2026-09-11 15:59 | 2026-09-11 15:59 | 2026-09-11 15:59 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 1.3300 | 1.3300 | 1.3400 | 167.2300 | 53200.00 | 0.00 | 53200.00 | 400 | 27 | 9356 | 16367 | 0.571638052178163 | 0.429406186900474 | 0.429406186900474 | true | false | false | |||||||||||||||||
| 9d089981-a90b-4834-a5c2-ecd948379394 | 2026-09-14 13:48 | 2026-09-14 13:48 | 2026-09-14 13:48 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 3.2800 | 3.2000 | 3.3000 | 173.1100 | 65691.00 | 65691.00 | 0.00 | 200 | 12 | 17350 | 18900 | 0.917989417989418 | 0.571569306086311 | 0.566139293832946 | false | false | false | |||||||||||||||||
| 3947461b-9d4e-4e31-9160-bbd4636cde93 | 2026-09-14 15:40 | 2026-09-14 15:40 | 2026-09-14 15:40 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 3.7000 | 3.6500 | 3.7500 | 174.1000 | 86210.00 | 370.00 | 85840.00 | 233 | 23 | 20175 | 18900 | 1.06746031746032 | 0.562516609897893 | 0.562516609897893 | true | false | false | |||||||||||||||||
| 978855e8-97ac-418e-b8d0-72d08b721b26 | 2026-09-15 12:31 | 2026-09-15 12:30 | 2026-09-15 12:30 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 3.5500 | 3.5000 | 3.6000 | 174.0000 | 63545.00 | 5680.00 | 57865.00 | 179 | 21 | 11854 | 20564 | 0.576444271542501 | 0.60867032959445 | 0.60867032959445 | true | false | false | |||||||||||||||||
| b48bde52-9964-4744-9e37-5323c213a09a | 2026-09-15 12:32 | 2026-09-15 12:31 | 2026-09-15 12:31 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 3.5500 | 3.5500 | 3.6000 | 174.0000 | 53605.00 | 0.00 | 53605.00 | 151 | 9 | 12114 | 20564 | 0.589087726123322 | 0.603646022998523 | 0.603646022998523 | false | false | false | |||||||||||||||||
| 6cc90b27-c61d-4b7d-9072-6c61d45c9e1e | 2026-09-15 13:01 | 2026-09-15 13:00 | 2026-09-15 13:00 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 4.0500 | 3.9500 | 4.0500 | 175.3300 | 493289.00 | 493289.00 | 0.00 | 1218 | 51 | 15479 | 20564 | 0.752723205602023 | 0.611352002522933 | 0.608441031394793 | false | false | false | |||||||||||||||||
| c997843a-c58a-418b-9c94-ff4860dfa6b0 | 2026-09-15 15:50 | 2026-09-15 15:50 | 2026-09-15 15:50 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 2.5600 | 2.5600 | 2.6000 | 172.0000 | 70656.00 | 0.00 | 70400.00 | 276 | 19 | 22864 | 20564 | 1.1118459443688 | 0.596323347563511 | 0.596323347563511 | true | false | false | |||||||||||||||||
| c1bd960c-6dcc-46f7-b168-2972e98e209a | 2026-09-16 09:46 | 2026-09-16 09:46 | 2026-09-16 09:46 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 1.8000 | 1.7600 | 1.8100 | 171.1600 | 90000.00 | 6840.00 | 81360.00 | 500 | 6 | 1813 | 19537 | 0.0927982801863132 | 0.661402985657429 | 0.658502604156561 | true | false | false | |||||||||||||||||
| b922e2cb-621d-40ec-a17d-187051ac8034 | 2026-09-16 09:51 | 2026-09-16 09:51 | 2026-09-16 09:51 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 1.6700 | 1.6300 | 1.6800 | 170.9000 | 50100.00 | 50100.00 | 0.00 | 300 | 5 | 2830 | 19537 | 0.144853355172237 | 0.648718803174519 | 0.648718803174519 | false | false | false | |||||||||||||||||
| 0fed10dc-cd1d-4cd6-834f-d343066e2583 | 2026-09-16 14:27 | 2026-09-16 14:27 | 2026-09-16 14:27 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 2.1600 | 2.1500 | 2.2100 | 173.0750 | 156169.00 | 218.00 | 155951.00 | 723 | 41 | 17017 | 19537 | 0.871013973486206 | 0.585769727093147 | 0.583761255262214 | false | false | false | |||||||||||||||||
| 8cafb837-a64a-42b0-bebe-fd58e64f0570 | 2026-09-17 12:42 | 2026-09-17 12:42 | 2026-09-17 12:42 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 2.3500 | 2.3400 | 2.4200 | 175.7000 | 169670.00 | 0.00 | 169670.00 | 722 | 55 | 13636 | 21323 | 0.639497256483609 | 0.557180940936859 | 0.537972533700193 | false | false | false | |||||||||||||||||
| ea1bf831-63d8-45b6-a624-a66738235df2 | 2026-09-17 12:56 | 2026-09-17 12:56 | 2026-09-17 12:56 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 2.1400 | 2.1400 | 2.1900 | 175.1600 | 167134.00 | 0.00 | 167134.00 | 781 | 41 | 14933 | 21323 | 0.70032359424096 | 0.560578957885713 | 0.560578957885713 | false | false | false | |||||||||||||||||
| 22531222-7995-409d-ae28-9cc513243bd8 | 2026-09-17 13:11 | 2026-09-17 13:11 | 2026-09-17 13:11 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 2.2100 | 2.1500 | 2.2100 | 175.2700 | 192933.00 | 192933.00 | 0.00 | 873 | 54 | 16364 | 21323 | 0.767434225953196 | 0.56396435796531 | 0.56396435796531 | false | false | false | |||||||||||||||||
| a075814b-2e97-410c-b1a1-c8ce0311f271 | 2026-09-17 14:35 | 2026-09-17 14:35 | 2026-09-17 14:35 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 2.0800 | 2.0800 | 2.1200 | 175.3400 | 179296.00 | 0.00 | 179296.00 | 862 | 58 | 19996 | 21323 | 0.937766730760212 | 0.518137976301272 | 0.518137976301272 | false | false | false | |||||||||||||||||
| a8dfaaa2-4b45-4229-97fd-cc263bca6668 | 2026-09-17 15:23 | 2026-09-17 15:22 | 2026-09-17 15:22 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 2.3800 | 2.3300 | 2.3900 | 175.7900 | 180881.00 | 180881.00 | 0.00 | 760 | 43 | 21665 | 21323 | 1.01603901889978 | 0.532150788126763 | 0.534919069430141 | false | false | false | |||||||||||||||||
| dfaaf2fa-672c-4367-8f2b-e564d5d1379e | 2026-09-18 09:56 | 2026-09-18 09:56 | 2026-09-18 09:56 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 1.2700 | 1.2100 | 1.2800 | 174.9100 | 50800.00 | 10922.00 | 39878.00 | 400 | 10 | 11797 | 21341 | 0.552785717632726 | 0.714656796382728 | 0.714656796382728 | true | false | false | |||||||||||||||||
| edbdd55e-c6b2-4ee0-bbbd-13406601d580 | 2026-09-18 14:20 | 2026-09-18 14:20 | 2026-09-18 14:20 | PLTR | PLTR260918C00175000 | call | 175.0000 | 2026-09-18 | 2.1000 | 2.0200 | 2.1500 | 176.9700 | 294000.00 | 294000.00 | 0.00 | 1400 | 7 | 38271 | 21341 | 1.79330865470222 | 0.750618148140756 | 0.750618148140756 | true | false | false |
| 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-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-14T18:18:53.599003Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 398736627049.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 398736627049.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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-15T17:17:02.017770Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 398736627049.00 |
| 2026-11-02 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 401106361778.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 401106361778.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 401106361778.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 405477717103.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 405477717103.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 405477717103.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 405477717103.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 405477717103.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:28:01.580099Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 408698715764.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 408698715764.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |