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_alerts326,449 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 |
|---|
| 5f2274b6-36c4-49f6-a5ae-d9b6a5c7e0d1 | 2026-09-22 12:36 | 2026-09-22 12:36 | 2026-09-22 12:36 | USAR | USAR261120C00016000 | call | 16.0000 | 2026-11-20 | 2.5000 | 2.5000 | 2.5800 | 16.7450 | 13759.00 | 0.00 | 13759.00 | 55 | 11 | 186 | 182 | 1.02197802197802 | 0.785285564169225 | 0.789208197937159 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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:42:20.042631Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| d5bc589a-d51d-4372-a105-678f3a7d5d6d | 2026-09-21 15:03 | 2026-09-21 15:03 | 2026-09-21 15:03 | USAR | USAR260925P00017000 | put | 17.0000 | 2026-09-25 | 0.6800 | 0.6800 | 0.6900 | 16.0000 | 49942.00 | 16146.00 | 33796.00 | 731 | 22 | 881 | 1465 | 0.601365187713311 | 0.876177170649646 | 0.890372443722493 | true | false | false | true | ||||||||||||||||
| 7c49b3ad-6838-4d94-ba73-bc30c57e96a1 | 2026-09-18 10:39 | 2026-09-18 10:39 | 2026-09-18 10:39 | USAR | USAR261016C00024000 | call | 24.0000 | 2026-10-16 | 0.0700 | 0.0400 | 0.0800 | 15.4050 | 11846.00 | 11846.00 | 0.00 | 1645 | 29 | 1718 | 4825 | 0.356062176165803 | 0.891096826611321 | 0.891096826611321 | false | false | false | true | ||||||||||||||||
| 6c2a2fb3-9c2f-408f-9856-d1a80a2eacf4 | 2026-09-17 11:48 | 2026-09-17 11:48 | 2026-09-17 11:48 | USAR | USAR261030C00015500 | call | 15.5000 | 2026-10-30 | 1.6100 | 1.5400 | 1.7700 | 15.5400 | 11586.00 | 0.00 | 11586.00 | 72 | 5 | 107 | 170 | 0.629411764705882 | 0.729357769575568 | 0.738870704836247 | false | false | false | true | ||||||||||||||||
| e10ec4c4-08fc-4257-a71a-431213d1c4f4 | 2026-09-16 15:40 | 2026-09-16 15:40 | 2026-09-16 15:40 | USAR | USAR261030C00017000 | call | 17.0000 | 2026-10-30 | 0.8600 | 0.8400 | 1.0000 | 14.9999 | 14799.00 | 0.00 | 14799.00 | 173 | 20 | 242 | 58 | 4.17241379310345 | 0.736421687013518 | 0.751701633937238 | false | false | false | true | ||||||||||||||||
| 75b0a56e-bccf-42d7-ba78-c57dcd19665e | 2026-09-15 12:07 | 2026-09-15 12:07 | 2026-09-15 12:07 | USAR | USAR280121C00030000 | call | 30.0000 | 2028-01-21 | 3.3000 | 3.2000 | 3.3000 | 15.3850 | 22420.00 | 22420.00 | 0.00 | 68 | 5 | 190 | 2315 | 0.08207343412527 | 0.86360108847948 | 0.866418695676936 | false | false | false | true | ||||||||||||||||
| 1e0ecf23-b67a-499d-8961-fff376acdd85 | 2026-09-10 12:12 | 2026-09-10 12:12 | 2026-09-10 12:12 | USAR | USAR280121C00015000 | call | 15.0000 | 2028-01-21 | 6.9500 | 6.9000 | 7.2500 | 16.2301 | 13214.00 | 700.00 | 12514.00 | 19 | 7 | 35 | 1683 | 0.0207961972667855 | 0.870622019712999 | 0.878715251791151 | false | false | false | true | ||||||||||||||||
| bbff18f1-ae7d-47c8-8848-2b5753f82c29 | 2026-09-08 09:59 | 2026-09-08 09:59 | 2026-09-08 09:59 | USAR | USAR261016C00016000 | call | 16.0000 | 2026-10-16 | 3.0200 | 2.9000 | 3.0500 | 17.9600 | 14190.00 | 14190.00 | 0.00 | 47 | 5 | 65 | 68 | 0.955882352941177 | 0.838426547859212 | 0.838426547859212 | false | false | false | true | ||||||||||||||||
| 26de8138-0494-4285-8166-324176c722f8 | 2026-09-04 09:36 | 2026-09-04 09:36 | 2026-09-04 09:36 | USAR | USAR260918C00022000 | call | 22.0000 | 2026-09-18 | 0.4000 | 0.3000 | 0.4200 | 19.2700 | 34173.00 | 33640.00 | 533.00 | 854 | 37 | 869 | 14393 | 0.0603765719446953 | 0.839685852883325 | 0.841184238983427 | false | false | false | true | ||||||||||||||||
| 3f8f022b-4bad-4c56-8299-24008f501cba | 2026-09-03 11:00 | 2026-09-03 11:00 | 2026-09-03 11:00 | USAR | USAR261002C00023000 | call | 23.0000 | 2026-10-02 | 0.3500 | 0.3400 | 0.3800 | 17.9600 | 13427.00 | 4572.00 | 910.00 | 380 | 5 | 4177 | 50 | 83.54 | 0.821090877914748 | 0.821090877914748 | true | false | false | true | ||||||||||||||||
| bce4dbf6-56ff-4cb5-a98d-a018b8b2e613 | 2026-09-01 10:31 | 2026-09-01 10:31 | 2026-09-01 10:31 | USAR | USAR260904C00018000 | call | 18.0000 | 2026-09-04 | 0.5000 | 0.4800 | 0.5000 | 17.6900 | 12093.00 | 11900.00 | 193.00 | 242 | 21 | 920 | 1242 | 0.740740740740741 | 0.968520839507135 | 0.993185340628279 | true | false | false | true | ||||||||||||||||
| b273e394-eb94-4354-970c-d1c23fa0aaaf | 2026-08-31 12:40 | 2026-08-31 12:40 | 2026-08-31 12:40 | USAR | USAR260918P00018000 | put | 18.0000 | 2026-09-18 | 1.2800 | 1.2600 | 1.2800 | 17.9900 | 11129.00 | 10240.00 | 0.00 | 87 | 7 | 244 | 5178 | 0.0471224410969486 | 0.805979330883073 | 0.81228344779262 | false | false | false | true | ||||||||||||||||
| da2e3f97-a72b-4db8-bf45-a1011bfebe49 | 2026-08-28 15:17 | 2026-08-28 15:17 | 2026-08-28 15:17 | USAR | USAR280121C00020000 | call | 20.0000 | 2028-01-21 | 6.9500 | 6.9500 | 7.1500 | 17.8300 | 27802.00 | 0.00 | 27802.00 | 40 | 7 | 139 | 2855 | 0.0486865148861646 | 0.901944559012456 | 0.901944559012456 | false | false | false | true | ||||||||||||||||
| 3c6a44d1-3b0f-4c9a-98d9-92076d1529ca | 2026-08-28 09:33 | 2026-08-28 09:33 | 2026-08-28 09:33 | USAR | USAR261016C00020000 | call | 20.0000 | 2026-10-16 | 2.5000 | 2.4500 | 2.5300 | 19.6050 | 17484.00 | 13500.00 | 0.00 | 70 | 5 | 71 | 494 | 0.143724696356275 | 0.916603167224817 | 0.916603167224817 | false | false | false | true | ||||||||||||||||
| 1539abcb-1f09-4f6d-93be-2f10f354fc78 | 2026-08-28 09:32 | 2026-08-28 09:32 | 2026-08-28 09:32 | USAR | USAR260918C00020000 | call | 20.0000 | 2026-09-18 | 1.5200 | 1.4200 | 1.5600 | 19.6100 | 19778.00 | 19778.00 | 0.00 | 130 | 7 | 242 | 13763 | 0.0175833757175035 | 0.893110500815079 | 0.893110500815079 | false | false | false | true | ||||||||||||||||
| 7fa1e301-0d1d-4798-9a14-e1b417c63377 | 2026-08-26 09:56 | 2026-08-26 09:56 | 2026-08-26 09:56 | USAR | USAR260918P00019000 | put | 19.0000 | 2026-09-18 | 1.4000 | 1.2200 | 1.4200 | 19.8150 | 13980.00 | 13980.00 | 0.00 | 100 | 6 | 605 | 3334 | 0.181463707258548 | 0.922862943736183 | 0.922862943736183 | false | false | false | true | ||||||||||||||||
| ba8a882b-abe4-404d-abcf-4cb9e258bf2e | 2026-08-26 09:55 | 2026-08-26 09:55 | 2026-08-26 09:55 | USAR | USAR260918P00019000 | put | 19.0000 | 2026-09-18 | 1.3700 | 1.2100 | 1.4100 | 19.8900 | 41026.00 | 41026.00 | 0.00 | 300 | 6 | 505 | 3334 | 0.151469706058788 | 0.916626119070446 | 0.916626119070446 | false | false | false | true | ||||||||||||||||
| cc7374a4-9dac-4c4d-bbfb-18825197f67d | 2026-08-25 11:07 | 2026-08-25 11:07 | 2026-08-25 11:07 | USAR | USAR260925C00025000 | call | 25.0000 | 2026-09-25 | 0.5700 | 0.3100 | 0.5700 | 19.1500 | 31915.00 | 30776.00 | 56.00 | 560 | 16 | 562 | 551 | 1.01996370235935 | 0.951799816584406 | 0.96291990256415 | true | false | false | true | ||||||||||||||||
| a8c1f21f-ddbd-4917-a8b2-88dea619fda8 | 2026-08-24 10:04 | 2026-08-24 10:04 | 2026-08-24 10:04 | USAR | USAR260828C00018000 | call | 18.0000 | 2026-08-28 | 0.7000 | 0.6700 | 0.7200 | 17.7765 | 20966.00 | 2346.00 | 18620.00 | 300 | 20 | 388 | 1110 | 0.34954954954955 | 1.06270084980454 | 1.07618877825615 | false | false | false | true | ||||||||||||||||
| 39147da3-1741-4336-bc1c-f4efc942eeb5 | 2026-08-21 12:38 | 2026-08-21 12:38 | 2026-08-21 12:38 | USAR | USAR260904C00020000 | call | 20.0000 | 2026-09-04 | 1.0000 | 0.9300 | 1.0200 | 19.1450 | 43169.00 | 11769.00 | 31400.00 | 432 | 8 | 718 | 437 | 1.64302059496568 | 0.894921261844035 | 0.900200768870703 | false | false | false | true | ||||||||||||||||
| 63486c40-09e4-4568-8bce-0e696e6cc9c3 | 2026-08-21 12:37 | 2026-08-21 12:37 | 2026-08-21 12:37 | USAR | USAR260828C00018500 | call | 18.5000 | 2026-08-28 | 1.2800 | 1.2700 | 1.3800 | 19.1800 | 15844.00 | 0.00 | 15844.00 | 124 | 42 | 1983 | 268 | 7.39925373134328 | 0.836629862530461 | 0.856574243140299 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 4106403261.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-18T14:47:44.869175Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 3695273495.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-10T16:13:08.333814Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:36:54.231390Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |