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 |
|---|
| 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 |
|---|
| 27bbcd4e-5a4e-4950-8e27-cccc6b95d5c2 | 2026-09-29 13:04 | 2026-09-29 13:04 | 2026-09-29 13:04 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 13.6200 | 13.3500 | 13.6500 | 716.4201 | 34045.00 | 21835.00 | 12210.00 | 25 | 7 | 260 | 883 | 0.29445073612684 | 0.383107124726902 | 0.382575619746422 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 1629126891164.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T17:09:02.591360Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 24f247fc-3526-4444-98f7-5db91f7c6ddf | 2026-09-29 09:54 | 2026-09-29 09:54 | 2026-09-29 09:54 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 11.8500 | 11.8500 | 12.0000 | 721.8825 | 21330.00 | 0.00 | 21330.00 | 18 | 5 | 61 | 883 | 0.0690826727066818 | 0.380365189349728 | 0.382181644604726 | false | false | false | true | ||||||||||||||||
| 00964fec-384a-477b-ad10-c6a64e9f5d20 | 2026-09-29 09:49 | 2026-09-29 09:49 | 2026-09-29 09:49 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 12.0600 | 12.0000 | 12.1000 | 720.8350 | 10850.00 | 7235.00 | 1205.00 | 9 | 7 | 34 | 883 | 0.0385050962627407 | 0.381397890228611 | 0.380943799488096 | true | false | false | true | ||||||||||||||||
| 8ad3dbcd-37b2-4b68-b27f-562698f8362b | 2026-09-28 10:02 | 2026-09-28 10:02 | 2026-09-28 10:02 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 12.3500 | 12.3000 | 12.7500 | 725.8300 | 11115.00 | 8645.00 | 2470.00 | 9 | 6 | 116 | 815 | 0.142331288343558 | 0.401874369557408 | 0.401874369557408 | true | false | false | true | ||||||||||||||||
| ab785da6-b770-4c4a-b4af-a26c9d5eeeb9 | 2026-09-25 13:57 | 2026-09-25 13:57 | 2026-09-25 13:57 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 7.5500 | 7.5250 | 7.6000 | 750.6700 | 15855.00 | 0.00 | 15855.00 | 21 | 5 | 317 | 725 | 0.437241379310345 | 0.391972765230751 | 0.392301090771827 | false | false | false | true | ||||||||||||||||
| 62234589-77f5-4bab-a00a-efaca6784870 | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 8.1500 | 8.0000 | 8.1500 | 753.5250 | 17930.00 | 17930.00 | 0.00 | 22 | 6 | 71 | 725 | 0.0979310344827586 | 0.415682067588022 | 0.415682067588022 | true | false | false | true | ||||||||||||||||
| 602bd8b7-aa02-4dbd-91a3-b9e6dfcfcbe5 | 2026-09-23 10:16 | 2026-09-23 10:16 | 2026-09-23 10:16 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 13.2000 | 13.1500 | 13.2000 | 745.3200 | 36960.00 | 36960.00 | 0.00 | 28 | 7 | 146 | 539 | 0.270871985157699 | 0.45689451349999 | 0.45689451349999 | false | false | false | true | ||||||||||||||||
| 441b9929-40d8-486e-a196-2ef50fcff527 | 2026-09-21 15:27 | 2026-09-21 15:27 | 2026-09-21 15:27 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 14.1500 | 14.1000 | 14.1500 | 745.1200 | 52355.00 | 52355.00 | 0.00 | 37 | 9 | 734 | 102 | 7.19607843137255 | 0.453505296223898 | 0.453505296223898 | false | false | false | true | ||||||||||||||||
| e8b7874a-d340-491e-915a-a2371b41a000 | 2026-09-21 15:11 | 2026-09-21 15:11 | 2026-09-21 15:11 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 14.5000 | 14.4000 | 14.5000 | 743.0600 | 31900.00 | 31900.00 | 0.00 | 22 | 8 | 668 | 102 | 6.54901960784314 | 0.450702769320967 | 0.450702769320967 | true | false | false | true | ||||||||||||||||
| 0083cbc1-a154-4b57-a0eb-73d0fba27b09 | 2026-09-21 14:52 | 2026-09-21 14:52 | 2026-09-21 14:52 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 14.5000 | 14.4500 | 14.6500 | 745.7600 | 26105.00 | 0.00 | 24650.00 | 18 | 11 | 629 | 102 | 6.16666666666667 | 0.461837868945444 | 0.461716358863462 | false | false | false | true | ||||||||||||||||
| 15213f7e-a0d9-424e-9297-5d50812eee15 | 2026-09-21 14:52 | 2026-09-21 14:52 | 2026-09-21 14:52 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 14.5500 | 14.4500 | 14.6000 | 746.1900 | 11640.00 | 10185.00 | 1455.00 | 8 | 7 | 611 | 102 | 5.99019607843137 | 0.464258704420861 | 0.464258704420861 | false | false | false | |||||||||||||||||
| 7764d9f1-88b4-4ebc-826a-fb5826bc4f14 | 2026-09-21 14:21 | 2026-09-21 14:21 | 2026-09-21 14:21 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 14.8000 | 14.6500 | 14.9500 | 744.1700 | 11840.00 | 10360.00 | 0.00 | 8 | 6 | 594 | 102 | 5.82352941176471 | 0.460397826148656 | 0.460029109050167 | false | false | false | true | ||||||||||||||||
| d844c1a2-915c-4dec-82a6-39bf52b3632b | 2026-09-21 12:37 | 2026-09-21 12:37 | 2026-09-21 12:37 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 18.0000 | 17.8500 | 18.0000 | 728.0100 | 43199.00 | 43199.00 | 0.00 | 24 | 14 | 478 | 102 | 4.68627450980392 | 0.439316263759604 | 0.438573748662726 | true | false | false | true | ||||||||||||||||
| d5c21aa6-29e1-4d17-b420-0c7d2a0c7808 | 2026-09-21 12:11 | 2026-09-21 12:11 | 2026-09-21 12:11 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 18.6000 | 18.4500 | 18.6500 | 724.3500 | 24178.00 | 22318.00 | 0.00 | 13 | 7 | 432 | 102 | 4.23529411764706 | 0.430153720412285 | 0.430153720412285 | false | false | false | true | ||||||||||||||||
| a40db5b9-3b1e-4c63-b2fb-afb13e27d6e7 | 2026-09-21 12:10 | 2026-09-21 12:10 | 2026-09-21 12:10 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 18.6500 | 18.5000 | 18.6500 | 723.6050 | 42895.00 | 42895.00 | 0.00 | 23 | 13 | 416 | 102 | 4.07843137254902 | 0.42711714609039 | 0.427311442747151 | true | false | false | true | ||||||||||||||||
| c639be58-5bfa-4208-9f39-ffca2bc35e68 | 2026-09-21 11:17 | 2026-09-21 11:17 | 2026-09-21 11:17 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 22.0000 | 22.0000 | 22.1500 | 711.6200 | 116602.00 | 0.00 | 116602.00 | 53 | 13 | 353 | 102 | 3.46078431372549 | 0.414234029912025 | 0.414234029912025 | false | false | false | |||||||||||||||||
| 87a34f46-e643-47c1-af11-5138773f3349 | 2026-09-21 10:29 | 2026-09-21 10:29 | 2026-09-21 10:29 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 21.7500 | 21.6000 | 21.7500 | 711.9700 | 26095.00 | 23925.00 | 2170.00 | 12 | 5 | 241 | 102 | 2.36274509803922 | 0.413884429459064 | 0.412597696792005 | false | false | false | |||||||||||||||||
| 1890cb2d-d4bb-4b42-a22a-8b0ed8e07818 | 2026-09-21 10:21 | 2026-09-21 10:21 | 2026-09-21 10:21 | META | META261016P00695000 | put | 695.0000 | 2026-10-16 | 21.8900 | 21.7000 | 21.9500 | 711.6800 | 19705.00 | 15330.00 | 4375.00 | 9 | 7 | 219 | 102 | 2.14705882352941 | 0.413769197004126 | 0.413150315348876 | true | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:56:35.860979Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:51:17.735284Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:03:25.739526Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:00:15.336636Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:16:29.786516Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:53:27.633876Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:53:27.633876Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:23:56.707397Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:13:06.153982Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:13:06.153982Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:19:12.034191Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:29:33.809340Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:22:41.713421Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |