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_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 |
|---|
| 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 |
|---|
| 58096c50-1aa1-4937-97dc-9c5d310ff155 | 2026-09-28 14:46 | 2026-09-28 14:46 | 2026-09-28 14:46 | B | B280121C00047000 | call | 47.0000 | 2028-01-21 | 6.6800 | 6.3500 | 6.7000 | 41.1400 | 33390.00 | 33390.00 | 0.00 | 50 | 7 | 51 | 946 | 0.0539112050739958 | 0.419640508109556 | 0.413770917791327 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | Industrials | 68840558631.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T18:52:01.773916Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 493f73d4-61ed-4154-bfaf-6d2e8050ba65 | 2026-09-25 11:23 | 2026-09-25 11:23 | 2026-09-25 11:23 | B | B261016P00042500 | put | 42.5000 | 2026-10-16 | 1.5200 | 1.4900 | 1.5200 | 42.4450 | 45597.00 | 8055.00 | 150.00 | 300 | 64 | 1300 | 103 | 12.621359223301 | 0.379820449576039 | 0.374888463049396 | false | false | false | |||||||||||||||||
| 6deb0372-dbbb-4f9b-aa2a-db668740f012 | 2026-09-25 10:01 | 2026-09-25 10:01 | 2026-09-25 10:01 | B | B261009C00042000 | call | 42.0000 | 2026-10-09 | 1.4700 | 1.4700 | 1.7300 | 42.0000 | 10003.00 | 0.00 | 10003.00 | 68 | 15 | 69 | 64 | 1.078125 | 0.38766696050531 | 0.384604009903848 | true | false | false | true | ||||||||||||||||
| 79f0c752-5487-471f-b4af-7a2876515a7e | 2026-09-22 15:35 | 2026-09-22 15:35 | 2026-09-22 15:35 | B | B261218C00055000 | call | 55.0000 | 2026-12-18 | 0.9500 | 0.9200 | 0.9600 | 43.9950 | 26560.00 | 22190.00 | 4370.00 | 280 | 16 | 570 | 2828 | 0.201555869872702 | 0.451181306297474 | 0.451181306297474 | false | false | false | |||||||||||||||||
| 53cf5108-7bd7-489c-972f-a6e9c8f3e1ca | 2026-09-22 15:35 | 2026-09-22 15:35 | 2026-09-22 15:35 | B | B270115C00055000 | call | 55.0000 | 2027-01-15 | 1.3500 | 1.3200 | 1.4200 | 44.0100 | 95955.00 | 55620.00 | 39255.00 | 713 | 24 | 937 | 12435 | 0.07535182951347 | 0.443696459457216 | 0.443230770598474 | false | false | false | |||||||||||||||||
| 2fe7f6c0-9975-4939-8436-302d7f0e90b2 | 2026-09-21 11:06 | 2026-09-21 11:06 | 2026-09-21 11:06 | B | B270319P00045000 | put | 45.0000 | 2027-03-19 | 6.3700 | 6.1000 | 6.5000 | 42.7550 | 15920.00 | 15920.00 | 0.00 | 25 | 7 | 25 | 1136 | 0.0220070422535211 | 0.471811443650252 | 0.471811443650252 | false | false | false | |||||||||||||||||
| ef5d607a-dbf5-42dc-b807-f1c07a085cf0 | 2026-08-25 10:42 | 2026-08-25 10:42 | 2026-08-25 10:42 | B | B261016C00043000 | call | 43.0000 | 2026-10-16 | 6.6500 | 6.6500 | 6.8000 | 48.3850 | 65180.00 | 0.00 | 65180.00 | 98 | 10 | 116 | 1754 | 0.0661345496009122 | 0.448057926111095 | 0.446143750121176 | false | false | false | |||||||||||||||||
| 90c05294-df18-4805-ad49-e791ccb344c6 | 2026-08-21 15:49 | 2026-08-21 15:49 | 2026-08-21 15:49 | B | B270115C00050000 | call | 50.0000 | 2027-01-15 | 4.9000 | 4.8000 | 5.0000 | 47.7650 | 245082.00 | 23602.00 | 0.00 | 500 | 8 | 700 | 9032 | 0.0775022143489814 | 0.458977898194291 | 0.458977898194291 | false | false | false | |||||||||||||||||
| 07454672-4021-4a2c-883b-992140744d42 | 2026-08-17 14:49 | 2026-08-17 14:48 | 2026-08-17 14:48 | B | B261218C00045000 | call | 45.0000 | 2026-12-18 | 3.6000 | 3.4500 | 3.6000 | 42.6099 | 411100.00 | 411100.00 | 0.00 | 1142 | 44 | 1340 | 5376 | 0.249255952380952 | 0.441921932185886 | 0.441921932185886 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| Industrials |
| 71839453738.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:25:06.221939Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| Industrials |
| 71839453738.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:01:14.001980Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| Industrials |
| 73514814133.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| Industrials |
| 73514814133.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| Industrials |
| 71521135263.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| Industrials |
| 71085541560.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| Industrials |
| 71085541560.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| Industrials |
| 71085541560.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |