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_alerts609,118 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 |
|---|
| cb7dd251-5790-456d-b3de-f45cb8a4e912 | 2026-09-23 15:58 | 2026-09-23 15:58 | 2026-09-23 15:58 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 0.1800 | 0.1800 | 0.1900 | 148.0000 | 12672.00 | 0.00 | 12672.00 | 704 | 25 | 5692 | 27575 | 0.206418857660925 | 0.57509834223886 | 0.57492755897925 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 1141822128733.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| f6985e91-8574-40cb-ac87-649c86fcc10b | 2026-09-23 15:32 | 2026-09-23 15:32 | 2026-09-23 15:32 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 0.1900 | 0.1900 | 0.2100 | 148.4264 | 40356.00 | 0.00 | 40356.00 | 2124 | 51 | 3871 | 27575 | 0.14038077969175 | 0.577600765012644 | 0.577600765012644 | false | false | false | true | ||||||||||||||||
| 2b8f1e79-350e-4e93-afb0-84bf1f6a282f | 2026-09-23 14:05 | 2026-09-23 14:05 | 2026-09-23 14:05 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 0.2200 | 0.2200 | 0.2300 | 149.5300 | 18678.00 | 0.00 | 18678.00 | 849 | 24 | 1599 | 27575 | 0.0579873073436083 | 0.578095984559057 | 0.578095984559057 | false | false | false | true | ||||||||||||||||
| 6f95162f-e268-46ae-b01e-bf9cc80f7564 | 2026-09-21 13:25 | 2026-09-21 13:25 | 2026-09-21 13:25 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 0.4000 | 0.4000 | 0.4100 | 154.1436 | 14360.00 | 0.00 | 14360.00 | 359 | 6 | 4147 | 27665 | 0.149900596421471 | 0.558398389904015 | 0.558398389904015 | false | false | false | true | ||||||||||||||||
| b9095550-2c50-4b72-853a-57455d82d0f0 | 2026-09-21 11:00 | 2026-09-21 11:00 | 2026-09-21 11:00 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 0.4800 | 0.4700 | 0.4900 | 156.3600 | 21168.00 | 21072.00 | 0.00 | 441 | 15 | 2899 | 27665 | 0.104789445147298 | 0.551361120186271 | 0.551361120186271 | false | false | false | true | ||||||||||||||||
| 55270691-15c0-40c2-be1b-805392177470 | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 0.6800 | 0.6700 | 0.7000 | 157.8103 | 34000.00 | 0.00 | 34000.00 | 500 | 41 | 2134 | 27665 | 0.0771371769383698 | 0.573930889164631 | 0.573930889164631 | true | false | false | true | ||||||||||||||||
| d6617a9b-2dc2-41de-ac36-e1299e549be1 | 2026-09-18 12:53 | 2026-09-18 12:52 | 2026-09-18 12:52 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 0.3500 | 0.3700 | 0.3800 | 151.6800 | 701009.00 | 0.00 | 701009.00 | 20000 | 22 | 31247 | 47456 | 0.658441503708699 | 0.546899584009152 | 0.541484765549606 | true | true | false | true | ||||||||||||||||
| a23301d8-6a94-464e-ae9d-4709e69f33b7 | 2026-09-18 10:54 | 2026-09-18 10:54 | 2026-09-18 10:54 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 0.4000 | 0.3900 | 0.4100 | 152.6500 | 120000.00 | 39840.00 | 39360.00 | 3000 | 37 | 7520 | 47456 | 0.158462575859744 | 0.543806821091078 | 0.543806821091078 | true | false | false | true | ||||||||||||||||
| 047a69a4-4787-48ee-8c80-6cfecd47d3d4 | 2026-09-16 11:03 | 2026-09-16 11:03 | 2026-09-16 11:03 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 0.5800 | 0.5600 | 0.5900 | 151.5300 | 121800.00 | 38454.00 | 83346.00 | 2100 | 38 | 7207 | 38355 | 0.187902489897015 | 0.576947357409932 | 0.576947357409932 | true | false | false | true | ||||||||||||||||
| 28fe56c2-c1ef-4fda-b29a-ed735836219c | 2026-09-08 13:40 | 2026-09-08 13:40 | 2026-09-08 13:40 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 1.3300 | 1.2700 | 1.3500 | 153.1700 | 196574.00 | 195776.00 | 798.00 | 1478 | 41 | 14023 | 18234 | 0.769057804102227 | 0.597223981494019 | 0.596875813720715 | true | false | false | true | ||||||||||||||||
| 03059509-2084-422f-82e8-1498f446b2e0 | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | SPCX | SPCX261016C00200000 | call | 200.0000 | 2026-10-16 | 2.8700 | 2.4800 | 2.9000 | 143.2150 | 275290.00 | 104780.00 | 0.00 | 960 | 7 | 962 | 10644 | 0.0903795565576851 | 0.709922047513079 | 0.696903069944824 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1141822128733.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:37:14.904379Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1141822128733.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:11:21.793472Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1168682193638.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:29:25.525905Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1168682193638.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1168682193638.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1175301006193.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1175301006193.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1161216788779.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |