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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| 54c43221-7828-4d2c-a27c-a2aadb4ca554 | 2026-10-01 11:05 | 2026-10-01 11:05 | 2026-10-01 11:05 | USAR | USAR280121C00012000 | call | 12.0000 | 2028-01-21 | 5.6900 | 5.6000 | 5.8000 | 13.5700 | 11380.00 | 9670.00 | 1710.00 | 20 | 6 | 40 | 1645 | 0.0243161094224924 | 0.816828579054778 | 0.812793955294828 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3377137366.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T15:07:32.032853Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| fa12691a-c21b-4836-9c6e-a68df71fd350 | 2026-09-28 09:37 | 2026-09-28 09:37 | 2026-09-28 09:37 | USAR | USAR280121C00020000 | call | 20.0000 | 2028-01-21 | 4.3200 | 4.2500 | 4.4500 | 14.8500 | 18580.00 | 0.00 | 18580.00 | 43 | 5 | 48 | 3647 | 0.0131615026048807 | 0.825479854908887 | 0.825479854908887 | false | false | ||||||||||||||||||
| a975430a-1d94-4697-8a4c-4642910514e5 | 2026-09-24 10:55 | 2026-09-24 10:55 | 2026-09-24 10:55 | USAR | USAR280121P00010000 | put | 10.0000 | 2028-01-21 | 2.2200 | 2.0000 | 2.2300 | 15.3250 | 625666.00 | 574253.00 | 51413.00 | 2812 | 29 | 2817 | 1542 | 1.82684824902724 | 0.862813310797861 | 0.848138840493534 | true | false | ||||||||||||||||||
| d587aeb5-7156-4ce4-a462-2c46b65a07e5 | 2026-09-23 12:06 | 2026-09-23 12:06 | 2026-09-23 12:06 | USAR | USAR261218P00016000 | put | 16.0000 | 2026-12-18 | 2.3400 | 2.3400 | 2.4000 | 16.0797 | 15918.00 | 0.00 | 15918.00 | 68 | 14 | 96 | 8314 | 0.0115467885494347 | 0.806202012020511 | 0.799602616123512 | false | false | ||||||||||||||||||
| 93e6982f-227e-4177-b2f1-ada7dd90423d | 2026-09-22 12:43 | 2026-09-22 12:43 | 2026-09-22 12:43 | USAR | USAR261016C00016000 | call | 16.0000 | 2026-10-16 | 1.5900 | 1.5700 | 1.6600 | 16.7000 | 79565.00 | 0.00 | 79565.00 | 500 | 6 | 1158 | 1461 | 0.792607802874743 | 0.715114521092208 | 0.715114521092208 | false | false | ||||||||||||||||||
| faef2f16-475e-4517-82ae-a9f0cd49f9ef | 2026-09-21 15:09 | 2026-09-21 15:09 | 2026-09-21 15:09 | USAR | USAR270319C00019000 | call | 19.0000 | 2027-03-19 | 3.2000 | 3.1500 | 3.4500 | 16.8600 | 31690.00 | 0.00 | 31690.00 | 99 | 5 | 99 | 285 | 0.347368421052632 | 0.824161924723901 | 0.824161924723901 | false | false | ||||||||||||||||||
| 11d5b242-fa23-4e81-a036-b9306419eea9 | 2026-09-18 09:35 | 2026-09-18 09:35 | 2026-09-18 09:35 | USAR | USAR261016C00016000 | call | 16.0000 | 2026-10-16 | 1.1300 | 1.1100 | 1.2500 | 15.6800 | 11304.00 | 0.00 | 11304.00 | 100 | 6 | 100 | 938 | 0.106609808102345 | 0.728592900731864 | 0.728592900731864 | false | false | ||||||||||||||||||
| 0adfd4bd-c2fb-4440-bb50-428c7b201ef5 | 2026-09-17 10:32 | 2026-09-17 10:32 | 2026-09-17 10:32 | USAR | USAR261002C00018500 | call | 18.5000 | 2026-10-02 | 0.1700 | 0.1600 | 0.2000 | 15.4700 | 22073.00 | 0.00 | 21784.00 | 1300 | 94 | 1305 | 89 | 14.6629213483146 | 0.769212495638685 | 0.758168492346915 | false | false | ||||||||||||||||||
| d76f3cb8-37ba-43cd-a64c-1599da34bf80 | 2026-09-09 12:30 | 2026-09-09 12:30 | 2026-09-09 12:30 | USAR | USAR270115C00050000 | call | 50.0000 | 2027-01-15 | 0.2700 | 0.2000 | 0.2700 | 17.3850 | 16411.00 | 16388.00 | 23.00 | 608 | 40 | 608 | 11909 | 0.0510538248383575 | 1.00443645624115 | 0.974525429780852 | false | false | ||||||||||||||||||
| ee09d214-f2b6-41c3-adbe-3cdd11ee56aa | 2026-09-03 09:30 | 2026-09-03 09:30 | 2026-09-03 09:30 | USAR | USAR260918P00018000 | put | 18.0000 | 2026-09-18 | 1.0400 | 1.0000 | 1.3300 | 17.9700 | 56389.00 | 1430.00 | 45279.00 | 542 | 78 | 542 | 6292 | 0.086141131595677 | 0.756883998149674 | 0.763784928374234 | true | false | ||||||||||||||||||
| 5713123b-8133-4693-aa16-44690bc721ca | 2026-08-31 15:54 | 2026-08-31 15:54 | 2026-08-31 15:54 | USAR | USAR260918P00018000 | put | 18.0000 | 2026-09-18 | 1.3200 | 1.3000 | 1.3300 | 17.8250 | 18186.00 | 0.00 | 18186.00 | 138 | 22 | 3666 | 5178 | 0.707995365005794 | 0.788349663063832 | 0.775673897096485 | true | false | ||||||||||||||||||
| 97b9b3bf-eb20-42c9-b8c5-281746f3a8a2 | 2026-08-28 15:53 | 2026-08-28 15:53 | 2026-08-28 15:53 | USAR | USAR260925C00019000 | call | 19.0000 | 2026-09-25 | 1.3200 | 1.1200 | 1.3400 | 17.9900 | 16128.00 | 16128.00 | 0.00 | 122 | 9 | 141 | 219 | 0.643835616438356 | 0.872975525999956 | 0.85781398254719 | false | false | ||||||||||||||||||
| c1cd367b-7f8b-406f-a0d4-2af27f16ca4a | 2026-08-28 09:42 | 2026-08-28 09:42 | 2026-08-28 09:42 | USAR | USAR260918C00020000 | call | 20.0000 | 2026-09-18 | 1.1800 | 1.1500 | 1.2700 | 19.0200 | 46080.00 | 0.00 | 46080.00 | 390 | 5 | 900 | 13763 | 0.06539271961055 | 0.8678132506517 | 0.8678132506517 | false | false | ||||||||||||||||||
| 2089f998-2505-440e-9ce6-d7e175b19ac0 | 2026-08-28 09:41 | 2026-08-28 09:41 | 2026-08-28 09:41 | USAR | USAR260918C00020000 | call | 20.0000 | 2026-09-18 | 1.2300 | 1.1900 | 1.3800 | 19.1300 | 24509.00 | 0.00 | 24509.00 | 199 | 6 | 510 | 13763 | 0.0370558744459783 | 0.86778213175379 | 0.86778213175379 | false | false | ||||||||||||||||||
| edb3f35e-bbe2-4212-97fa-c5f63259cb4c | 2026-08-25 11:09 | 2026-08-25 11:09 | 2026-08-25 11:09 | USAR | USAR260904C00019500 | call | 19.5000 | 2026-09-04 | 1.1100 | 1.0900 | 1.1200 | 19.1440 | 78599.00 | 57344.00 | 21255.00 | 707 | 34 | 740 | 154 | 4.80519480519481 | 1.00561916000247 | 1.00561916000247 | false | false | ||||||||||||||||||
| b63b55e8-a724-470e-b4c1-3c7ad0d0b150 | 2026-08-25 11:07 | 2026-08-25 11:07 | 2026-08-25 11:07 | USAR | USAR260918C00021500 | call | 21.5000 | 2026-09-18 | 1.0000 | 0.9800 | 1.0100 | 19.0650 | 61130.00 | 45450.00 | 15680.00 | 610 | 33 | 642 | 9 | 71.3333333333333 | 0.957455201079672 | 0.957455201079672 | false | false | ||||||||||||||||||
| a5545f77-855b-4094-a361-a9fd43fed60e | 2026-08-25 09:49 | 2026-08-25 09:49 | 2026-08-25 09:49 | USAR | USAR260828C00019000 | call | 19.0000 | 2026-08-28 | 0.5900 | 0.5100 | 0.6100 | 18.5300 | 12485.00 | 8657.00 | 168.00 | 210 | 10 | 279 | 1040 | 0.268269230769231 | 1.1978065482637 | 1.13510496484182 | true | false | ||||||||||||||||||
| 9fafbb4b-9b70-4380-97dd-a154918e3985 | 2026-08-24 13:47 | 2026-08-24 13:47 | 2026-08-24 13:47 | USAR | USAR260904C00020000 | call | 20.0000 | 2026-09-04 | 0.5100 | 0.5000 | 0.5700 | 18.0600 | 30279.00 | 4838.00 | 25441.00 | 596 | 64 | 738 | 1818 | 0.405940594059406 | 0.956033639112701 | 0.933935054840837 | true | false | ||||||||||||||||||
| fbd6c7fb-9254-4c02-9607-60ce172a7ae1 | 2026-08-21 13:48 | 2026-08-21 13:48 | 2026-08-21 13:48 | USAR | USAR260904C00020000 | call | 20.0000 | 2026-09-04 | 1.1500 | 1.0900 | 1.1500 | 19.4550 | 57383.00 | 57383.00 | 0.00 | 499 | 10 | 1750 | 437 | 4.0045766590389 | 0.905503548961746 | 0.89891307292502 | false | false | ||||||||||||||||||
| c7a00dc1-ed95-48e3-b6e5-47ea0ff994a8 | 2026-08-21 12:37 | 2026-08-21 12:37 | 2026-08-21 12:37 | USAR | USAR260828C00018500 | call | 18.5000 | 2026-08-28 | 1.2700 | 1.2700 | 1.3700 | 19.1700 | 27433.00 | 0.00 | 27433.00 | 216 | 29 | 2199 | 268 | 8.20522388059701 | 0.856574243140299 | 0.852974125343109 | true | false | ||||||||||||||||||
| 3e5b5d83-84ec-4edf-a444-049cd6f72348 | 2026-08-18 10:01 | 2026-08-18 10:01 | 2026-08-18 10:01 | USAR | USAR280121C00027000 | call | 27.0000 | 2028-01-21 | 6.1500 | 6.1500 | 6.5000 | 18.7200 | 116866.00 | 0.00 | 116866.00 | 190 | 18 | 193 | 3928 | 0.0491344195519348 | 0.918085055610961 | 0.916923150329582 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3527640227.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:39:03.459259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3873919167.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3873919167.00 |
| 2026-11-05 |
| unknown |
| — |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 4157794482.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:48:50.097062Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 4106403261.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3761347922.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:40:42.153741Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3824975147.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:45:40.179334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:57:19.773601Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Basic Materials |
| 3844552755.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |