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 |
|---|
| 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 |
|---|
| 01dfdd68-8a68-48a7-9bf7-e9c8d4232e41 | 2026-08-24 13:14 | 2026-08-24 13:13 | 2026-08-24 13:13 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 33.0000 | 33.0000 | 33.2000 | 157.2050 | 59400.00 | 0.00 | 59400.00 | 18 | 6 | 573 | 10534 | 0.0543952914372508 | 0.345101037827927 | 0.345101037827927 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 82721740000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1780bace-15a6-4c88-9ef0-d373e6e1f823 | 2026-08-24 13:15 | 2026-08-24 13:15 | 2026-08-24 13:15 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.8000 | 31.7000 | 33.5000 | 157.1600 | 55760.00 | 3280.00 | 52480.00 | 17 | 17 | 600 | 10534 | 0.0569584203531422 | 0.342566261468199 | 0.342566261468199 | false | false | false | true | ||||||||||||||||
| 8482ae03-9288-495e-90c3-2b74bd3874b5 | 2026-08-24 13:27 | 2026-08-24 13:27 | 2026-08-24 13:27 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.7000 | 31.7000 | 33.1000 | 157.0950 | 196200.00 | 9810.00 | 186390.00 | 60 | 28 | 660 | 10534 | 0.0626542623884564 | 0.341730373613169 | 0.341730373613169 | false | false | false | true | ||||||||||||||||
| 3274a13b-d76b-412d-a5d8-ec85b4bd9353 | 2026-08-24 13:42 | 2026-08-24 13:42 | 2026-08-24 13:42 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.6000 | 32.1000 | 32.9000 | 156.8350 | 195600.00 | 9780.00 | 185820.00 | 60 | 18 | 720 | 10534 | 0.0683501044237707 | 0.342871345629016 | 0.342871345629016 | false | false | false | true | ||||||||||||||||
| dd870fda-2a12-4ff3-8b09-b4cec87d3fd3 | 2026-08-24 13:57 | 2026-08-24 13:57 | 2026-08-24 13:57 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.7000 | 32.7000 | 33.0000 | 156.9200 | 196200.00 | 0.00 | 196200.00 | 60 | 18 | 780 | 10534 | 0.0740459464590849 | 0.343505765889154 | 0.343505765889154 | false | false | false | true | ||||||||||||||||
| 16496d77-ef5d-4b10-9f06-80a8a9204b93 | 2026-08-24 14:13 | 2026-08-24 14:13 | 2026-08-24 14:13 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.7000 | 32.2000 | 32.9000 | 156.9700 | 163500.00 | 6540.00 | 13080.00 | 50 | 18 | 840 | 10534 | 0.0797417884943991 | 0.342998852024802 | 0.342998852024802 | false | false | false | true | ||||||||||||||||
| 773fb217-4595-47dc-9fed-fd2f4a47f5b8 | 2026-08-24 14:25 | 2026-08-24 14:25 | 2026-08-24 14:25 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.6000 | 32.6000 | 32.9000 | 156.9200 | 195600.00 | 0.00 | 88020.00 | 60 | 18 | 900 | 10534 | 0.0854376305297133 | 0.342010013709978 | 0.342010013709978 | false | false | false | true | ||||||||||||||||
| 169231d0-45c2-461f-a8fc-45724af120ca | 2026-08-24 14:43 | 2026-08-24 14:43 | 2026-08-24 14:43 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.9000 | 32.1000 | 33.2000 | 157.3650 | 197400.00 | 9870.00 | 187530.00 | 60 | 18 | 960 | 10534 | 0.0911334725650275 | 0.341977802213431 | 0.341977802213431 | false | false | false | true | ||||||||||||||||
| a30a0506-4056-4f76-bb19-14676eb35e1d | 2026-08-24 14:57 | 2026-08-24 14:57 | 2026-08-24 14:57 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.8000 | 32.1000 | 33.1000 | 157.2400 | 164000.00 | 6560.00 | 157440.00 | 50 | 28 | 1020 | 10534 | 0.0968293146003417 | 0.341753160447272 | 0.341753160447272 | false | false | false | true | ||||||||||||||||
| c96699e1-8f3f-40ef-b8be-a9fdc9391dec | 2026-08-24 15:12 | 2026-08-24 15:11 | 2026-08-24 15:11 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.9000 | 32.9000 | 33.3000 | 157.4700 | 128310.00 | 0.00 | 128310.00 | 39 | 11 | 1079 | 10534 | 0.102430225935067 | 0.340908332402639 | 0.340908332402639 | false | false | false | true | ||||||||||||||||
| bc79a1c2-ca55-491b-ac52-99089f8035b4 | 2026-08-24 15:13 | 2026-08-24 15:13 | 2026-08-24 15:13 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 33.0000 | 33.0000 | 33.4000 | 157.6200 | 52800.00 | 0.00 | 52800.00 | 16 | 13 | 1095 | 10534 | 0.103949117144485 | 0.340875423935521 | 0.340875423935521 | false | false | false | true | ||||||||||||||||
| 0b2dcc97-e136-45b8-9381-9b82ad9a9088 | 2026-08-24 15:27 | 2026-08-24 15:26 | 2026-08-24 15:26 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 33.0000 | 32.5000 | 33.3000 | 157.4900 | 198000.00 | 6600.00 | 49500.00 | 60 | 19 | 1170 | 10534 | 0.111068919688627 | 0.342201186516739 | 0.342201186516739 | false | false | false | true | ||||||||||||||||
| 9cd20384-284c-49cf-abf0-eacaacdce21e | 2026-08-24 15:42 | 2026-08-24 15:42 | 2026-08-24 15:42 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 32.8000 | 32.8000 | 33.3000 | 157.5200 | 124640.00 | 0.00 | 124640.00 | 38 | 11 | 1208 | 10534 | 0.114676286310993 | 0.338901621448391 | 0.338901621448391 | false | false | false | true | ||||||||||||||||
| 4037cc35-1ba1-4e41-946b-05ed5f317df7 | 2026-08-24 15:46 | 2026-08-24 15:46 | 2026-08-24 15:46 | EMR | EMR280121C00150000 | call | 150.0000 | 2028-01-21 | 33.0000 | 32.6000 | 33.3000 | 157.5350 | 66000.00 | 3300.00 | 62700.00 | 20 | 18 | 1230 | 10534 | 0.116764761723942 | 0.341742486533901 | 0.341742486533901 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82721740000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |