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 | 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 |
|---|
| fbbeb987-00d3-4425-8245-0557556d8ee3 | 2026-08-24 11:20 | 2026-08-24 11:20 | 2026-08-24 11:20 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 3.1000 | 2.9100 | 3.1000 | 176.7750 | 62000.00 | 62000.00 | 0.00 | 200 | 8 | 504 | 1732 | 0.290993071593533 | 0.504563087185169 | 0.504563087185169 | 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-24T15:29:12.492303Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7051cad0-b6dc-42b0-9a12-b02af1ab637f | 2026-08-24 15:58 | 2026-08-24 15:57 | 2026-08-24 15:57 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 2.6200 | 2.6100 | 2.7200 | 176.1150 | 52305.00 | 0.00 | 52305.00 | 200 | 9 | 1095 | 1732 | 0.632217090069284 | 0.478027769578427 | 0.478027769578427 | false | false | false | |||||||||||||||||
| 3edc0cc8-1769-4d19-b114-67dcba26cb3b | 2026-08-27 09:38 | 2026-08-27 09:38 | 2026-08-27 09:38 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 4.0000 | 3.9500 | 4.1500 | 181.1550 | 63200.00 | 0.00 | 63200.00 | 158 | 7 | 607 | 2687 | 0.22590249348716 | 0.523339858570292 | 0.523339858570292 | false | false | false | |||||||||||||||||
| 1e8d4e3f-c1a0-499f-9c71-b3d5d44296e8 | 2026-08-27 09:55 | 2026-08-27 09:54 | 2026-08-27 09:54 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 5.4600 | 5.4500 | 5.6000 | 184.3550 | 109100.00 | 0.00 | 109100.00 | 200 | 16 | 2122 | 2687 | 0.789728321548195 | 0.522205040947578 | 0.523123459184422 | false | false | false | |||||||||||||||||
| f5909d20-aef3-4827-856e-3572b033c315 | 2026-08-28 09:31 | 2026-08-28 09:31 | 2026-08-28 09:31 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 5.9000 | 5.9000 | 6.1500 | 186.5500 | 66670.00 | 0.00 | 66670.00 | 113 | 11 | 184 | 3113 | 0.0591069707677482 | 0.488642743884621 | 0.488642743884621 | true | false | false | |||||||||||||||||
| 60910788-d49a-4b63-9c1d-cccc2d13ed13 | 2026-08-31 10:37 | 2026-08-31 10:36 | 2026-08-31 10:36 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 4.3000 | 4.2000 | 4.3000 | 185.4350 | 64500.00 | 64500.00 | 0.00 | 150 | 17 | 2746 | 3656 | 0.75109409190372 | 0.522251141139895 | 0.522251141139895 | false | false | false | |||||||||||||||||
| 76d7be82-a049-4574-bd0b-bcce6c9c3ac3 | 2026-08-31 14:39 | 2026-08-31 14:39 | 2026-08-31 14:39 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 4.8700 | 4.8500 | 5.0500 | 186.6590 | 97406.00 | 0.00 | 97406.00 | 200 | 6 | 6773 | 3656 | 1.85257111597374 | 0.507953615291871 | 0.510572092055794 | false | false | false | |||||||||||||||||
| 3759f50d-a842-4c3b-9948-3d07b3c3b200 | 2026-08-31 15:39 | 2026-08-31 15:39 | 2026-08-31 15:39 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 5.1500 | 5.1500 | 5.2000 | 187.1900 | 50985.00 | 0.00 | 50985.00 | 99 | 10 | 7984 | 3656 | 2.18380743982495 | 0.503510537596643 | 0.503510537596643 | false | false | false | |||||||||||||||||
| e59962fd-4ef1-40a3-9bf3-c68feda49598 | 2026-09-03 09:38 | 2026-09-03 09:38 | 2026-09-03 09:38 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 1.0000 | 0.9900 | 1.0000 | 179.2650 | 58000.00 | 58000.00 | 0.00 | 580 | 16 | 4166 | 7168 | 0.581194196428571 | 0.799697691053771 | 0.799697691053771 | false | false | false | |||||||||||||||||
| f2def632-ed34-45f2-8030-a857e87d5aef | 2026-09-03 12:02 | 2026-09-03 12:02 | 2026-09-03 12:02 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 2.0000 | 1.9800 | 2.0500 | 183.6150 | 97800.00 | 5600.00 | 92200.00 | 489 | 14 | 52130 | 7168 | 7.27260044642857 | 0.682524047061662 | 0.682524047061662 | true | false | false | |||||||||||||||||
| 0e6f9250-763a-4552-ba76-b92a2e3bb479 | 2026-09-03 13:52 | 2026-09-03 13:52 | 2026-09-03 13:52 | PLTR | PLTR260904C00185000 | call | 185.0000 | 2026-09-04 | 1.6200 | 1.6200 | 1.6500 | 183.2150 | 65448.00 | 0.00 | 65448.00 | 404 | 23 | 55642 | 7168 | 7.76255580357143 | 0.624386540571928 | 0.624386540571928 | false | 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-25T13:32:26.163070Z"} |
| 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-27T13:38:22.111482Z"} |
| 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-27T14:00:28.149501Z"} |
| 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-28T13:32:48.312014Z"} |
| 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-31T14:41:39.850499Z"} |
| 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-31T19:01:22.528333Z"} |
| 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-31T19:54:15.623665Z"} |
| 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-03T13:45:03.310585Z"} |
| 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-03T16:03:37.205690Z"} |
| 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-03T17:55:09.170571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |