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.
Simplify Analyticsuw_flow_alerts523,327 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 |
|---|
| 286a3a8f-9abc-4aa9-910c-200a0e5ba995 | 2026-08-18 10:55 | 2026-08-18 10:54 | 2026-08-18 10:54 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 7.0000 | 6.3500 | 7.0000 | 93.4100 | 23800.00 | 23800.00 | 0.00 | 34 | 12 | 207 | 4476 | 0.0462466487935657 | 0.431066368851554 | 0.431066368851554 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 25249453318.00 | 2026-11-17 | 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 |
| 28e45fad-3f0b-4bc0-bcb4-668b7bf13109 | 2026-08-18 11:32 | 2026-08-18 11:32 | 2026-08-18 11:32 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 7.8000 | 7.4500 | 8.0000 | 91.8700 | 88920.00 | 78000.00 | 10920.00 | 114 | 27 | 336 | 4476 | 0.0750670241286863 | 0.432508414200806 | 0.432149301672561 | true | false | false | |||||||||||||||||
| b8a46308-33c2-4a5c-82f6-3b8776994b7d | 2026-08-18 12:13 | 2026-08-18 12:13 | 2026-08-18 12:13 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 8.4000 | 7.9500 | 8.4000 | 91.0050 | 42000.00 | 42000.00 | 0.00 | 50 | 20 | 394 | 4476 | 0.0880250223413762 | 0.441389387473032 | 0.441389387473032 | false | false | false | |||||||||||||||||
| 827fc678-ad5f-4fc9-b5c8-5968b15208e8 | 2026-08-19 10:34 | 2026-08-19 10:34 | 2026-08-19 10:34 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 8.1000 | 8.0000 | 8.4000 | 91.2760 | 72900.00 | 810.00 | 72090.00 | 90 | 21 | 128 | 5038 | 0.0254069075029774 | 0.43418776690311 | 0.43418776690311 | true | false | false | |||||||||||||||||
| 5109b64e-6c54-469d-b414-cd466c35026b | 2026-08-20 14:07 | 2026-08-20 14:06 | 2026-08-20 14:06 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 7.7000 | 7.6000 | 7.7000 | 91.4900 | 13090.00 | 13090.00 | 0.00 | 17 | 5 | 85 | 5083 | 0.0167224080267559 | 0.41768783612265 | 0.41768783612265 | true | false | false | |||||||||||||||||
| 11e7ae06-7581-46e1-88ba-b58b9735fbc4 | 2026-08-25 09:46 | 2026-08-25 09:46 | 2026-08-25 09:46 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 7.1000 | 6.8500 | 7.3500 | 92.1500 | 17750.00 | 0.00 | 0.00 | 25 | 5 | 40 | 5226 | 0.00765403750478377 | 0.417295369281647 | 0.417295369281647 | false | false | false | |||||||||||||||||
| 3ef4c3f7-3d2b-46a7-9e32-58edf76d165d | 2026-08-25 09:48 | 2026-08-25 09:48 | 2026-08-25 09:48 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 7.0000 | 6.8000 | 7.2500 | 92.3600 | 14700.00 | 4200.00 | 10500.00 | 21 | 12 | 110 | 5226 | 0.0210486031381554 | 0.42130683234303 | 0.418096143413307 | false | false | false | |||||||||||||||||
| abbe7ab5-465d-466b-ac20-bbfca6493227 | 2026-08-25 09:50 | 2026-08-25 09:49 | 2026-08-25 09:49 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 6.9000 | 6.8000 | 7.1500 | 92.4945 | 17250.00 | 13800.00 | 3450.00 | 25 | 5 | 164 | 5226 | 0.0313815537696135 | 0.415975282965709 | 0.415975282965709 | false | false | false | |||||||||||||||||
| 84c224a7-e8ce-47db-891b-71ffd7e99ebb | 2026-08-25 10:36 | 2026-08-25 10:36 | 2026-08-25 10:36 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 6.8000 | 6.6500 | 6.8500 | 92.8000 | 17000.00 | 17000.00 | 0.00 | 25 | 10 | 189 | 5226 | 0.0361653272101033 | 0.420160321670357 | 0.420160321670357 | false | false | false | |||||||||||||||||
| 3c03c4ed-b33c-4588-9229-876eab110f04 | 2026-08-25 12:07 | 2026-08-25 12:07 | 2026-08-25 12:07 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 6.8000 | 6.8000 | 7.0000 | 92.7200 | 17005.00 | 0.00 | 17005.00 | 25 | 5 | 219 | 5226 | 0.0419058553386912 | 0.417925145750032 | 0.417208299647787 | false | false | false | |||||||||||||||||
| d26c071b-3e69-4b3a-ab78-3ee169bda0c9 | 2026-08-25 14:47 | 2026-08-25 14:47 | 2026-08-25 14:47 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 6.7000 | 6.5500 | 6.7500 | 92.9600 | 16750.00 | 16750.00 | 0.00 | 25 | 5 | 255 | 5226 | 0.0487944890929966 | 0.418862837452086 | 0.418862837452086 | false | false | false | |||||||||||||||||
| 312192b8-f35a-449a-bdcc-c7b8951ebeeb | 2026-08-26 09:34 | 2026-08-26 09:34 | 2026-08-26 09:34 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 6.5500 | 5.8500 | 6.7000 | 93.1710 | 16370.00 | 16370.00 | 0.00 | 25 | 16 | 30 | 5474 | 0.00548045305078553 | 0.419447121087905 | 0.419447121087905 | true | false | false | |||||||||||||||||
| 5b1de9f9-01c3-4bdf-a8a7-213825ca585a | 2026-08-27 09:32 | 2026-08-27 09:31 | 2026-08-27 09:31 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 4.9000 | 4.4500 | 5.6500 | 96.4050 | 12250.00 | 2450.00 | 9800.00 | 25 | 5 | 30 | 5509 | 0.00544563441640951 | 0.411900652960967 | 0.411900652960967 | false | false | false | |||||||||||||||||
| 141105d6-c734-4480-aee1-1c49c54a409c | 2026-08-27 10:20 | 2026-08-27 10:20 | 2026-08-27 10:20 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 4.6000 | 4.5000 | 4.7000 | 97.0600 | 11500.00 | 0.00 | 0.00 | 25 | 5 | 71 | 5509 | 0.0128880014521692 | 0.40961115331005 | 0.40961115331005 | false | false | false | |||||||||||||||||
| 10c25169-870f-448c-9b37-1653c878d262 | 2026-08-28 12:34 | 2026-08-28 12:33 | 2026-08-28 12:33 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 4.6500 | 4.4500 | 4.8500 | 96.6000 | 11625.00 | 0.00 | 0.00 | 25 | 5 | 40 | 5581 | 0.00716717434151586 | 0.403527543424615 | 0.403527543424615 | false | false | false | |||||||||||||||||
| 5baddb45-2fb1-4196-a5c9-08e504c3c343 | 2026-09-21 14:24 | 2026-09-21 14:24 | 2026-09-21 14:24 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 5.3500 | 5.3500 | 5.5000 | 92.3000 | 20330.00 | 0.00 | 20330.00 | 38 | 15 | 567 | 7495 | 0.0756504336224149 | 0.411028188995091 | 0.411028188995091 | false | false | false | |||||||||||||||||
| d0d25bde-41fc-4413-af83-a9c154570485 | 2026-09-28 13:41 | 2026-09-28 13:41 | 2026-09-28 13:41 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 8.3000 | 8.0000 | 8.5000 | 87.0000 | 12450.00 | 9960.00 | 2490.00 | 15 | 5 | 74 | 7288 | 0.0101536772777168 | 0.397663617106336 | 0.40388052620543 | false | false | false | |||||||||||||||||
| 4e3aca14-f033-45eb-aa61-b96a777963ac | 2026-09-28 14:33 | 2026-09-28 14:32 | 2026-09-28 14:32 | BIDU | BIDU261016P00095000 | put | 95.0000 | 2026-10-16 | 8.1500 | 7.8000 | 8.2000 | 87.4900 | 20375.00 | 12225.00 | 8150.00 | 25 | 5 | 99 | 7288 | 0.0135839736553238 | 0.404461916668512 | 0.404461916668512 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:54:14.733334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| 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 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25249453318.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 25334625576.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 23894939663.00 |
| 2026-11-17 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:41:35.586557Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 23894939663.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |