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_alerts566,287 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 |
|---|
| 70811a72-dbb3-4567-995e-a87c026c0659 | 2026-09-29 15:54 | 2026-09-29 15:54 | 2026-09-29 15:54 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 2.7400 | 2.7300 | 2.8000 | 186.8200 | 16166.00 | 0.00 | 14796.00 | 59 | 7 | 252 | 7706 | 0.032701790812354 | 0.466435737206255 | 0.466435737206255 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 430164371123.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T19:57:26.018295Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 4b6191a2-89dc-49f5-adc7-0bc44bea4cf2 | 2026-09-28 13:12 | 2026-09-28 13:12 | 2026-09-28 13:12 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 2.6200 | 2.5100 | 2.6300 | 189.4800 | 16244.00 | 12052.00 | 4192.00 | 62 | 10 | 541 | 7607 | 0.0711187064545813 | 0.491708842334476 | 0.492529416119491 | false | false | false | |||||||||||||||||
| c61f320d-a1bb-4051-8f0b-a057424ec158 | 2026-09-23 09:44 | 2026-09-23 09:44 | 2026-09-23 09:44 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 3.0300 | 2.9500 | 3.1500 | 192.0000 | 135915.00 | 102615.00 | 33300.00 | 449 | 19 | 562 | 6607 | 0.0850612986226729 | 0.51602795746751 | 0.515435912713751 | false | false | false | |||||||||||||||||
| 53aab6f2-670f-4e1b-955c-3845d20941b1 | 2026-09-21 14:58 | 2026-09-21 14:58 | 2026-09-21 14:58 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 5.7500 | 5.6500 | 5.8000 | 181.5350 | 20125.00 | 20125.00 | 0.00 | 35 | 6 | 586 | 6577 | 0.0890983731184431 | 0.47451216684792 | 0.474612032952144 | false | false | false | |||||||||||||||||
| 37b1a3fd-c6f5-45f6-9dfd-313843ce2a48 | 2026-09-17 09:47 | 2026-09-17 09:47 | 2026-09-17 09:47 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 8.9000 | 8.9000 | 9.1500 | 175.6978 | 108580.00 | 0.00 | 108580.00 | 122 | 8 | 146 | 6524 | 0.0223789086450031 | 0.483468488607938 | 0.483468488607938 | false | false | false | |||||||||||||||||
| 6c9a4df4-defa-44ce-95e8-9f400dff99b8 | 2026-09-11 14:07 | 2026-09-11 14:07 | 2026-09-11 14:07 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 13.7000 | 13.6500 | 13.8000 | 167.0300 | 394592.00 | 21920.00 | 372672.00 | 288 | 41 | 1483 | 7344 | 0.201933551198257 | 0.455190947906807 | 0.456370814547344 | true | false | false | |||||||||||||||||
| 78622cf4-3ef7-41d5-ac75-12d10805421f | 2026-09-11 14:07 | 2026-09-11 14:07 | 2026-09-11 14:07 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 13.7500 | 13.7000 | 13.8500 | 166.9600 | 840125.00 | 144375.00 | 690250.00 | 611 | 40 | 1102 | 7344 | 0.150054466230937 | 0.457091695654122 | 0.456796400163428 | true | false | false | |||||||||||||||||
| 532f5661-2883-47cb-99a9-902573937acb | 2026-09-11 14:07 | 2026-09-11 14:07 | 2026-09-11 14:07 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 13.7500 | 13.7000 | 13.7500 | 166.9750 | 60500.00 | 60500.00 | 0.00 | 44 | 12 | 1146 | 7344 | 0.156045751633987 | 0.456796400163428 | 0.457239271231566 | false | false | false | |||||||||||||||||
| 6f5cdb94-7c74-45ee-ad2f-760e5a58953c | 2026-09-11 14:07 | 2026-09-11 14:07 | 2026-09-11 14:07 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 13.8000 | 13.7000 | 13.8500 | 166.9600 | 63480.00 | 11040.00 | 46920.00 | 46 | 8 | 491 | 7344 | 0.0668572984749455 | 0.459287581507306 | 0.459287581507306 | false | false | false | |||||||||||||||||
| 0eaf0ece-fd50-4ad7-912f-594ab6b9b4cf | 2026-09-04 11:15 | 2026-09-04 11:15 | 2026-09-04 11:15 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 9.8000 | 9.8000 | 9.9000 | 176.5200 | 74480.00 | 0.00 | 74480.00 | 76 | 6 | 776 | 7040 | 0.110227272727273 | 0.460359350441614 | 0.460359350441614 | false | false | false | |||||||||||||||||
| fbeb5689-5d9c-44cd-82bd-24c4f22f7e3f | 2026-09-04 11:15 | 2026-09-04 11:15 | 2026-09-04 11:15 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 9.9400 | 9.7000 | 9.9500 | 176.5425 | 99448.00 | 99448.00 | 0.00 | 100 | 10 | 700 | 7040 | 0.0994318181818182 | 0.46713734536257 | 0.46713734536257 | false | false | false | |||||||||||||||||
| 73f696f2-48d4-4559-8b6a-c80e04325d65 | 2026-09-04 10:46 | 2026-09-04 10:46 | 2026-09-04 10:46 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 10.0000 | 10.0000 | 10.1000 | 176.0700 | 80000.00 | 0.00 | 80000.00 | 80 | 5 | 458 | 7040 | 0.0650568181818182 | 0.460467757322428 | 0.460467757322428 | false | false | false | |||||||||||||||||
| 414e54c1-0e1f-4182-a4d2-603320d339a6 | 2026-09-02 13:49 | 2026-09-02 13:48 | 2026-09-02 13:48 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 13.5000 | 13.4500 | 13.6500 | 169.4000 | 269990.00 | 0.00 | 269990.00 | 200 | 5 | 3074 | 4814 | 0.63855421686747 | 0.460424662915463 | 0.460424662915463 | false | false | false | |||||||||||||||||
| fb38bc3f-9244-4b61-b586-150b916523e0 | 2026-09-02 11:43 | 2026-09-02 11:43 | 2026-09-02 11:43 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 14.4800 | 14.4000 | 14.6000 | 168.0100 | 331562.00 | 0.00 | 331562.00 | 229 | 7 | 2702 | 4814 | 0.561279601163274 | 0.469483127332032 | 0.469483127332032 | false | false | false | |||||||||||||||||
| b77370b0-35fb-45c4-b421-d25bd54197b3 | 2026-09-02 11:28 | 2026-09-02 11:28 | 2026-09-02 11:28 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 13.7500 | 13.6500 | 13.8000 | 169.3000 | 199375.00 | 27500.00 | 152625.00 | 145 | 6 | 2394 | 4814 | 0.497299542999585 | 0.468828526005753 | 0.468828526005753 | false | false | false | |||||||||||||||||
| 09cfa668-fde8-4b7a-882a-50867a0b1de8 | 2026-09-02 11:28 | 2026-09-02 11:28 | 2026-09-02 11:28 | PLTR | PLTR261016P00175000 | put | 175.0000 | 2026-10-16 | 13.6500 | 13.6500 | 13.7000 | 169.4963 | 202020.00 | 0.00 | 202020.00 | 148 | 12 | 2124 | 4814 | 0.441213128375571 | 0.469049256936165 | 0.469049256936165 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 431337734921.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:15:39.910905Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| 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-21T19:00:53.952817Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 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-11T18:33:12.425630Z"} |
| 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-11T18:33:12.425630Z"} |
| 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-11T18:33:12.425630Z"} |
| 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-11T18:33:12.425630Z"} |
| 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-04T15:23:10.886670Z"} |
| 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-04T15:23:10.886670Z"} |
| 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-04T15:01:23.801406Z"} |
| 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-02T18:05:44.095975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 398736627049.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 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-02T15:49:54.253343Z"} |
| 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-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |