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_alerts658,639 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 |
|---|
| 1e252f11-4d08-43f4-9231-cd767bb9e450 | 2026-09-25 09:38 | 2026-09-25 09:38 | 2026-09-25 09:38 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 7.5000 | 7.1000 | 7.5000 | 52.0000 | 18750.00 | 3750.00 | 0.00 | 25 | 5 | 78 | 3756 | 0.0207667731629393 | 0.611696184467307 | 0.611696184467307 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1158079398.00 | 2026-12-08 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T13:39:47.971768Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| d0b78f82-2265-471b-90f1-9493b11d37c8 | 2026-09-25 09:34 | 2026-09-25 09:34 | 2026-09-25 09:34 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 7.6300 | 7.5000 | 8.8000 | 52.0000 | 11450.00 | 1540.00 | 3750.00 | 15 | 9 | 40 | 3756 | 0.0106496272630458 | 0.832558010726893 | 0.396471597681411 | false | false | false | true | ||||||||||||||||
| 1a472349-0ff1-4a56-b6eb-0d30b72dc2c9 | 2026-09-25 09:34 | 2026-09-25 09:34 | 2026-09-25 09:34 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 7.5000 | 6.6000 | 7.5000 | 52.0000 | 18750.00 | 18750.00 | 0.00 | 25 | 5 | 25 | 3756 | 0.00665601703940362 | 0.51126023239498 | 0.51126023239498 | false | false | false | true | ||||||||||||||||
| c441cfba-84d1-4821-85e3-eabab6fdde17 | 2026-09-24 15:53 | 2026-09-24 15:53 | 2026-09-24 15:53 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 7.2000 | 7.2000 | 7.6000 | 51.9499 | 21600.00 | 0.00 | 21600.00 | 30 | 9 | 594 | 4200 | 0.141428571428571 | 0.399331983937521 | 0.399331983937521 | false | false | false | true | ||||||||||||||||
| e0371870-af6d-4eb4-9d60-a751363bc25f | 2026-09-24 15:53 | 2026-09-24 15:53 | 2026-09-24 15:53 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 7.2000 | 7.2000 | 7.6000 | 51.8200 | 18000.00 | 0.00 | 18000.00 | 25 | 6 | 544 | 4200 | 0.12952380952381 | 0.463975928204594 | 0.463975928204594 | false | false | false | true | ||||||||||||||||
| 66956b66-9dc5-4076-bf6c-b4fe64501e56 | 2026-09-24 15:53 | 2026-09-24 15:53 | 2026-09-24 15:53 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 7.3000 | 7.0000 | 7.6000 | 51.8850 | 18250.00 | 3650.00 | 10950.00 | 25 | 5 | 519 | 4200 | 0.123571428571429 | 0.482872663861595 | 0.482872663861595 | false | false | false | true | ||||||||||||||||
| 8c844f67-3a06-4ad4-8b7e-b3cdcbf2955b | 2026-09-24 14:59 | 2026-09-24 14:59 | 2026-09-24 14:59 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 6.7000 | 6.5000 | 7.0000 | 51.1400 | 20100.00 | 0.00 | 20100.00 | 30 | 5 | 386 | 4200 | 0.0919047619047619 | 0.506405712977448 | 0.506405712977448 | false | false | false | true | ||||||||||||||||
| 478fa5f1-7eee-4423-8ba5-1d7ede97fab1 | 2026-09-23 12:08 | 2026-09-23 12:07 | 2026-09-23 12:07 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 4.1000 | 4.1000 | 4.3000 | 47.8805 | 159080.00 | 0.00 | 159080.00 | 388 | 34 | 821 | 4164 | 0.19716618635927 | 0.495730911109573 | 0.495730911109573 | false | false | false | true | ||||||||||||||||
| 243e4ae6-21a2-4fab-a0cc-d2201f3ae91f | 2026-09-23 11:25 | 2026-09-23 11:25 | 2026-09-23 11:25 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 3.9000 | 3.6000 | 3.9000 | 47.5275 | 17160.00 | 17160.00 | 0.00 | 44 | 5 | 362 | 4164 | 0.0869356388088377 | 0.50782240363122 | 0.50782240363122 | true | false | false | true | ||||||||||||||||
| a8066eba-4fbc-4af1-bc0c-931a1a9711b9 | 2026-09-22 14:59 | 2026-09-22 14:59 | 2026-09-22 14:59 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 3.2000 | 3.2000 | 3.3000 | 45.2500 | 269120.00 | 0.00 | 269120.00 | 841 | 19 | 2512 | 2946 | 0.852681602172437 | 0.654301637531108 | 0.654301637531108 | false | false | false | true | ||||||||||||||||
| 5d3276ad-983b-451f-bac7-d913208ae87b | 2026-09-22 14:59 | 2026-09-22 14:59 | 2026-09-22 14:59 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 3.2000 | 2.9000 | 3.8000 | 45.3000 | 67860.00 | 67540.00 | 320.00 | 212 | 5 | 1671 | 2946 | 0.567209775967413 | 0.648266540640553 | 0.648266540640553 | false | false | false | true | ||||||||||||||||
| eefd01b9-86a3-404b-b1cc-de49f6449509 | 2026-09-15 15:08 | 2026-09-15 15:08 | 2026-09-15 15:08 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 4.2000 | 3.9000 | 4.2000 | 45.7500 | 10920.00 | 4620.00 | 0.00 | 26 | 6 | 2003 | 10 | 200.3 | 0.709558417724386 | 0.709558417724386 | false | false | false | true | ||||||||||||||||
| c2b27f3e-8f43-4faf-b529-363b57560871 | 2026-09-15 12:15 | 2026-09-15 12:15 | 2026-09-15 12:15 | CBRL | CBRL261016C00045000 | call | 45.0000 | 2026-10-16 | 4.4400 | 3.9000 | 6.3000 | 46.2850 | 295260.00 | 0.00 | 295260.00 | 665 | 2 | 666 | 10 | 66.6 | 0.687321615444916 | 0.687321615444916 | false | true | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1158079398.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:34:45.543817Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1158079398.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:34:45.543817Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1062141379.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1062141379.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1062141379.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1062141379.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:02:51.984196Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1062141379.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:13:15.432740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1062141379.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1016544401.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1016544401.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1129419274.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1129419274.00 |
| 2026-09-23 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |