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_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 |
|---|
| 02713baf-c51c-40de-9aa7-389515617364 | 2026-08-20 10:12 | 2026-08-20 10:12 | 2026-08-20 10:12 | SMTC | SMTC261120C00130000 | call | 130.0000 | 2026-11-20 | 22.1000 | 21.8000 | 22.4000 | 126.5900 | 442000.00 | 48620.00 | 393380.00 | 200 | 6 | 1124 | 6 | 187.333333333333 | 0.913604543515042 | 0.913604543515042 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 13723533303.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 812527e6-111e-498e-9793-961fa2132029 | 2026-08-20 09:40 | 2026-08-20 09:40 | 2026-08-20 09:40 | SMTC | SMTC261120C00130000 | call | 130.0000 | 2026-11-20 | 22.0000 | 22.0000 | 22.9000 | 126.9100 | 660000.00 | 0.00 | 660000.00 | 300 | 7 | 450 | 6 | 75 | 0.902181797024845 | 0.902181797024845 | false | false | false | true | ||||||||||||||||
| c38861e5-b0fc-421a-a501-7f71092aa728 | 2026-08-19 15:21 | 2026-08-19 15:21 | 2026-08-19 15:21 | SMTC | SMTC260918C00120000 | call | 120.0000 | 2026-09-18 | 16.4000 | 16.3000 | 17.2000 | 124.8200 | 11480.00 | 1640.00 | 9840.00 | 7 | 5 | 17 | 118 | 0.144067796610169 | 0.979595426836735 | 0.979595426836735 | true | false | false | true | ||||||||||||||||
| 0ee90ed7-c5c0-45e2-8824-dc993a58c6fa | 2026-08-19 14:57 | 2026-08-19 14:57 | 2026-08-19 14:57 | SMTC | SMTC260918P00110000 | put | 110.0000 | 2026-09-18 | 7.0000 | 6.5000 | 7.0000 | 125.6200 | 59500.00 | 59500.00 | 0.00 | 85 | 17 | 91 | 282 | 0.322695035460993 | 1.00891865327738 | 1.00891865327738 | false | false | false | true | ||||||||||||||||
| 4dc56c6f-4022-4e9d-8887-b7c87fc72366 | 2026-08-19 13:20 | 2026-08-19 13:20 | 2026-08-19 13:20 | SMTC | SMTC261120C00210000 | call | 210.0000 | 2026-11-20 | 5.0000 | 5.0000 | 5.6000 | 126.9400 | 139001.00 | 0.00 | 139001.00 | 278 | 28 | 371 | 36 | 10.3055555555556 | 0.893384335297663 | 0.893384335297663 | false | false | false | true | ||||||||||||||||
| 582b176e-531f-41ef-9de3-52c8bd47c17c | 2026-08-19 11:13 | 2026-08-19 11:13 | 2026-08-19 11:13 | SMTC | SMTC260918C00150000 | call | 150.0000 | 2026-09-18 | 6.9000 | 6.2000 | 6.9000 | 127.2050 | 12420.00 | 12420.00 | 0.00 | 18 | 6 | 72 | 631 | 0.114104595879556 | 0.990321283080455 | 0.990321283080455 | false | false | false | true | ||||||||||||||||
| f421056d-14fc-4513-8742-eee7448f05c5 | 2026-08-19 10:09 | 2026-08-19 10:08 | 2026-08-19 10:08 | SMTC | SMTC261120C00210000 | call | 210.0000 | 2026-11-20 | 4.9000 | 4.9000 | 6.0000 | 125.9250 | 45080.00 | 0.00 | 45080.00 | 92 | 20 | 92 | 36 | 2.55555555555556 | 0.898792056749596 | 0.898792056749596 | false | false | false | true | ||||||||||||||||
| 41c4d087-dcd1-4b79-a082-6e002d5a4869 | 2026-08-19 10:02 | 2026-08-19 10:02 | 2026-08-19 10:02 | SMTC | SMTC260821P00130000 | put | 130.0000 | 2026-08-21 | 5.5000 | 4.2000 | 5.5000 | 127.3700 | 11550.00 | 11550.00 | 0.00 | 21 | 6 | 89 | 530 | 0.167924528301887 | 1.07052460149955 | 1.07052460149955 | false | false | false | true | ||||||||||||||||
| 4e1db81d-e414-4553-b928-de24146c70ae | 2026-08-18 14:13 | 2026-08-18 14:13 | 2026-08-18 14:13 | SMTC | SMTC261016C00140000 | call | 140.0000 | 2026-10-16 | 17.2000 | 16.7000 | 17.3000 | 133.2100 | 13760.00 | 13760.00 | 0.00 | 8 | 6 | 17 | 28 | 0.607142857142857 | 0.922210832531057 | 0.922210832531057 | false | false | false | true | ||||||||||||||||
| 8202610e-77dc-4b8e-a082-125632d09e32 | 2026-08-18 10:50 | 2026-08-18 10:49 | 2026-08-18 10:49 | SMTC | SMTC260918C00140000 | call | 140.0000 | 2026-09-18 | 14.6000 | 14.2000 | 15.0000 | 137.2950 | 87600.00 | 52560.00 | 13140.00 | 60 | 6 | 184 | 3724 | 0.0494092373791622 | 0.97889531923121 | 0.97889531923121 | true | false | false | true | ||||||||||||||||
| 79caaab0-a59c-4ec9-b8b3-78a53de3c614 | 2026-08-18 10:49 | 2026-08-18 10:49 | 2026-08-18 10:49 | SMTC | SMTC260918C00140000 | call | 140.0000 | 2026-09-18 | 14.7900 | 14.4000 | 15.5000 | 137.5100 | 121280.00 | 88800.00 | 32480.00 | 82 | 6 | 104 | 3724 | 0.0279269602577873 | 0.984230004266717 | 0.984230004266717 | false | false | false | true | ||||||||||||||||
| 9967fd2e-fa64-4c80-860b-aac690219bac | 2026-08-18 10:47 | 2026-08-18 10:46 | 2026-08-18 10:46 | SMTC | SMTC261016P00120000 | put | 120.0000 | 2026-10-16 | 11.1000 | 10.6000 | 11.1000 | 138.0300 | 34410.00 | 34410.00 | 0.00 | 31 | 16 | 31 | 374 | 0.0828877005347594 | 0.92927845829182 | 0.92927845829182 | false | false | false | true | ||||||||||||||||
| 98cef73e-03a4-4d66-907f-8a7b757e3f48 | 2026-08-17 15:44 | 2026-08-17 15:44 | 2026-08-17 15:44 | SMTC | SMTC261218C00240000 | call | 240.0000 | 2026-12-18 | 11.8000 | 11.1000 | 11.8000 | 155.0600 | 154570.00 | 153400.00 | 0.00 | 131 | 27 | 131 | 315 | 0.415873015873016 | 0.907263173297274 | 0.904036611843677 | false | false | false | true | ||||||||||||||||
| 0dd75060-1a42-46db-b4bf-6b8321d6617b | 2026-08-17 11:30 | 2026-08-17 11:30 | 2026-08-17 11:30 | SMTC | SMTC260918C00200000 | call | 200.0000 | 2026-09-18 | 5.4000 | 4.7000 | 5.4000 | 153.7800 | 35630.00 | 35100.00 | 530.00 | 66 | 27 | 79 | 853 | 0.0926143024618992 | 0.999944769952662 | 0.992748543504536 | false | false | false | true | ||||||||||||||||
| 31dbadd0-eab6-4819-b5fe-8b706a2e4cdf | 2026-08-17 10:46 | 2026-08-17 10:46 | 2026-08-17 10:46 | SMTC | SMTC260821C00155000 | call | 155.0000 | 2026-08-21 | 5.6000 | 5.3000 | 5.8000 | 153.6000 | 45920.00 | 44800.00 | 1120.00 | 82 | 37 | 109 | 984 | 0.110772357723577 | 0.972023667438116 | 0.969749590033218 | false | false | false | true | ||||||||||||||||
| c1875085-f9eb-40db-b9d7-c871763e5eca | 2026-08-17 10:42 | 2026-08-17 10:41 | 2026-08-17 10:41 | SMTC | SMTC260918P00145000 | put | 145.0000 | 2026-09-18 | 13.3000 | 12.2000 | 13.3000 | 152.7400 | 13300.00 | 13300.00 | 0.00 | 10 | 6 | 10 | 74 | 0.135135135135135 | 0.977528713095354 | 0.977528713095354 | false | false | false | true | ||||||||||||||||
| 2450c3c7-f667-41c0-8dff-90c25731e5a8 | 2026-08-17 10:27 | 2026-08-17 10:27 | 2026-08-17 10:27 | SMTC | SMTC260918P00130000 | put | 130.0000 | 2026-09-18 | 7.3000 | 6.7000 | 7.3000 | 152.7600 | 11679.00 | 11679.00 | 0.00 | 16 | 12 | 49 | 140 | 0.35 | 0.985961397197838 | 0.985961397197838 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 13723533303.00 |
| 2026-11-23 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |