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_alerts425,429 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 | price |
|---|
| 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 |
|---|
| 95aa8cd2-5394-4fca-a77d-82dead2ffc8e | 2026-08-19 13:30 | 2026-08-19 13:30 | 2026-08-19 13:30 | ONON | ONON270617P00030000 | put | 30.0000 | 2027-06-17 | 4.0500 | 4.0000 | 4.1000 | 31.2500 | 43740.00 | 33210.00 | 10530.00 | 108 | 5 | 112 | 224 | 0.5 | 0.468680928021928 | 0.468680928021928 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8155111007.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 643ee90e-0d4c-4bfb-8942-ce473f862641 | 2026-08-19 10:12 | 2026-08-19 10:12 | 2026-08-19 10:12 | ONON | ONON261218P00027500 | put | 27.5000 | 2026-12-18 | 1.3600 | 1.3500 | 1.3800 | 31.2900 | 19228.00 | 9300.00 | 544.00 | 141 | 32 | 241 | 2241 | 0.107541276215975 | 0.447011626729297 | 0.448765200095727 | false | false | false | true | false | |||||||||||||||
| 280a9f20-683e-4a66-9f79-6d1335befead | 2026-08-18 13:40 | 2026-08-18 13:40 | 2026-08-18 13:40 | ONON | ONON261218C00030000 | call | 30.0000 | 2026-12-18 | 4.0000 | 4.0000 | 4.0500 | 31.1700 | 24400.00 | 0.00 | 24400.00 | 61 | 11 | 149 | 307 | 0.485342019543974 | 0.451785352798858 | 0.451785352798858 | false | false | false | true | false | |||||||||||||||
| 2f2e5d39-019a-4693-b5e5-a663fb192265 | 2026-08-18 12:50 | 2026-08-18 12:50 | 2026-08-18 12:50 | ONON | ONON270617P00025000 | put | 25.0000 | 2027-06-17 | 2.0100 | 2.0100 | 2.0800 | 31.4300 | 14472.00 | 0.00 | 14472.00 | 72 | 8 | 1308 | 1869 | 0.69983948635634 | 0.479611989624042 | 0.479991360776235 | false | false | false | true | false | |||||||||||||||
| 20042f14-3fd7-428f-8c44-91ecf417b1bf | 2026-08-18 12:50 | 2026-08-18 12:50 | 2026-08-18 12:50 | ONON | ONON270617P00025000 | put | 25.0000 | 2027-06-17 | 2.0100 | 2.0100 | 2.0800 | 31.4100 | 14271.00 | 0.00 | 14271.00 | 71 | 17 | 1229 | 1869 | 0.65757089352595 | 0.479485454699521 | 0.479485454699521 | false | false | false | true | false | |||||||||||||||
| 2bd252c7-159d-48af-9017-1d7f90da370f | 2026-08-18 12:50 | 2026-08-18 12:50 | 2026-08-18 12:50 | ONON | ONON270617P00025000 | put | 25.0000 | 2027-06-17 | 2.0200 | 2.0200 | 2.0900 | 31.4150 | 14342.00 | 0.00 | 14342.00 | 71 | 6 | 1122 | 1869 | 0.600321027287319 | 0.480834387103328 | 0.480834387103328 | false | false | false | true | false | |||||||||||||||
| 8f65e292-c5bf-4a7a-bffa-e634a09bfaed | 2026-08-18 12:45 | 2026-08-18 12:45 | 2026-08-18 12:45 | ONON | ONON270617P00025000 | put | 25.0000 | 2027-06-17 | 2.0300 | 2.0300 | 2.0900 | 31.4050 | 12992.00 | 0.00 | 12992.00 | 64 | 14 | 282 | 1869 | 0.150882825040128 | 0.481802443052553 | 0.481802443052553 | false | false | false | true | false | |||||||||||||||
| 84a27b17-a00d-4c01-829f-ac57eda3f6db | 2026-08-18 12:45 | 2026-08-18 12:45 | 2026-08-18 12:45 | ONON | ONON270617P00025000 | put | 25.0000 | 2027-06-17 | 2.0300 | 2.0300 | 2.0900 | 31.3995 | 12586.00 | 0.00 | 12586.00 | 62 | 16 | 212 | 1869 | 0.113429641519529 | 0.481663015747178 | 0.481663015747178 | false | false | false | true | false | |||||||||||||||
| fe3f3a53-20b0-4fe5-a41c-032d9d8008a7 | 2026-08-18 12:40 | 2026-08-18 12:40 | 2026-08-18 12:40 | ONON | ONON270617P00025000 | put | 25.0000 | 2027-06-17 | 2.0500 | 2.0500 | 2.0600 | 31.3750 | 13735.00 | 0.00 | 13735.00 | 67 | 9 | 143 | 1869 | 0.0765115034777956 | 0.483480318830839 | 0.483480318830839 | false | false | false | true | false | |||||||||||||||
| 4b3032a5-57d1-491e-bf6e-0710cebbbb2f | 2026-08-18 12:40 | 2026-08-18 12:40 | 2026-08-18 12:40 | ONON | ONON270617P00025000 | put | 25.0000 | 2027-06-17 | 2.0600 | 2.0600 | 2.1000 | 31.3850 | 13802.00 | 0.00 | 13802.00 | 67 | 7 | 76 | 1869 | 0.0406634563937935 | 0.484952666192684 | 0.484952666192684 | false | false | false | true | false | |||||||||||||||
| 615d1c02-8799-4b86-88f0-4eb7ab709f9b | 2026-08-18 12:12 | 2026-08-18 12:11 | 2026-08-18 12:11 | ONON | ONON270319P00030000 | put | 30.0000 | 2027-03-19 | 3.2500 | 3.2000 | 3.3000 | 31.4650 | 89239.00 | 67139.00 | 1950.00 | 275 | 26 | 275 | 2303 | 0.119409465914025 | 0.460587787940045 | 0.460587787940045 | false | false | false | true | false | |||||||||||||||
| 7ffadcb1-1f0a-4b09-a9a8-0c10d6061453 | 2026-08-18 10:53 | 2026-08-18 10:53 | 2026-08-18 10:53 | ONON | ONON260904C00032000 | call | 32.0000 | 2026-09-04 | 0.8000 | 0.7900 | 0.8200 | 31.3200 | 27283.00 | 5084.00 | 22199.00 | 343 | 10 | 354 | 655 | 0.540458015267176 | 0.405469684609727 | 0.405469684609727 | false | false | false | true | false | |||||||||||||||
| b97f372d-05e6-4317-85ad-5146b970b939 | 2026-08-18 09:56 | 2026-08-18 09:56 | 2026-08-18 09:56 | ONON | ONON261218C00032500 | call | 32.5000 | 2026-12-18 | 2.8500 | 2.7200 | 2.9000 | 31.2100 | 14250.00 | 6270.00 | 7980.00 | 50 | 5 | 50 | 710 | 0.0704225352112676 | 0.448482724261956 | 0.448482724261956 | false | false | false | true | false | |||||||||||||||
| d1f84ec7-e64c-47b5-96de-04dfc5def3fb | 2026-08-17 14:43 | 2026-08-17 14:42 | 2026-08-17 14:42 | ONON | ONON260911P00031000 | put | 31.0000 | 2026-09-11 | 1.0800 | 1.0100 | 1.0800 | 31.1500 | 39528.00 | 39528.00 | 0.00 | 366 | 31 | 374 | 84 | 4.45238095238095 | 0.367902454540019 | 0.367902454540019 | false | false | false | true | false | |||||||||||||||
| 3ff5b99f-03a5-461d-87b0-9feeed2b2eb5 | 2026-08-17 13:03 | 2026-08-17 13:03 | 2026-08-17 13:03 | ONON | ONON260828C00033000 | call | 33.0000 | 2026-08-28 | 0.3500 | 0.3000 | 0.3500 | 31.4280 | 22680.00 | 22680.00 | 0.00 | 648 | 6 | 686 | 121 | 5.66942148760331 | 0.413181408965033 | 0.413181408965033 | false | false | false | true | false | |||||||||||||||
| e1733153-f43c-4763-813f-c7a2a5993eaa | 2026-08-17 12:57 | 2026-08-17 12:57 | 2026-08-17 12:57 | ONON | ONON261016P00032500 | put | 32.5000 | 2026-10-16 | 2.5100 | 2.5100 | 2.5600 | 31.4400 | 13806.00 | 0.00 | 13806.00 | 55 | 10 | 207 | 7049 | 0.029365867498936 | 0.398746193575102 | 0.400719725713758 | false | false | false | true | false | |||||||||||||||
| 72b3a76d-14e0-4e74-9347-5b18fa110bd5 | 2026-08-17 11:51 | 2026-08-17 11:51 | 2026-08-17 11:51 | ONON | ONON260904P00031000 | put | 31.0000 | 2026-09-04 | 0.8200 | 0.7500 | 0.8200 | 31.4300 | 19516.00 | 19516.00 | 0.00 | 238 | 17 | 258 | 257 | 1.00389105058366 | 0.378669232108691 | 0.378669232108691 | false | false | false | true | false | |||||||||||||||
| 33f8372b-bec0-4f74-9e83-2d87a5e52adf | 2026-08-17 10:31 | 2026-08-17 10:31 | 2026-08-17 10:31 | ONON | ONON261016P00032500 | put | 32.5000 | 2026-10-16 | 2.3900 | 2.3900 | 2.4300 | 31.7099 | 13384.00 | 0.00 | 13384.00 | 56 | 12 | 64 | 7049 | 0.00907930202865655 | 0.402901995095352 | 0.402901995095352 | false | false | false | true | false | |||||||||||||||
| 0f604c0b-1e92-4edb-8c53-ca5e2969a7aa | 2026-08-17 10:16 | 2026-08-17 10:16 | 2026-08-17 10:16 | ONON | ONON260918P00032500 | put | 32.5000 | 2026-09-18 | 1.8100 | 1.7200 | 1.8100 | 31.7350 | 50499.00 | 50499.00 | 0.00 | 279 | 33 | 293 | 5073 | 0.0577567514291346 | 0.385236663900189 | 0.385236663900189 | false | false | false | true | false | |||||||||||||||
| e8dcd675-77b2-4d81-8698-5574f0de00b2 | 2026-08-17 10:07 | 2026-08-17 10:06 | 2026-08-17 10:06 | ONON | ONON261016C00032500 | call | 32.5000 | 2026-10-16 | 1.9600 | 1.9600 | 2.0500 | 31.9600 | 13135.00 | 197.00 | 12938.00 | 67 | 10 | 68 | 569 | 0.119507908611599 | 0.409246736543468 | 0.409246736543468 | false | false | false | true | false | |||||||||||||||
| caf8f234-7ac7-42ed-8308-a49c8ce0fbe6 | 2026-08-17 10:01 | 2026-08-17 10:01 | 2026-08-17 10:01 | ONON | ONON260821C00032000 | call | 32.0000 | 2026-08-21 | 0.7600 | 0.6000 | 0.7600 | 31.9000 | 15200.00 | 15200.00 | 0.00 | 200 | 12 | 1564 | 1220 | 1.28196721311475 | 0.601731500139185 | 0.601731500139185 | false | false | false | true | false | |||||||||||||||
| bbd474e1-8f62-452d-95e0-3bbb3dd727a1 | 2026-08-17 09:35 | 2026-08-17 09:35 | 2026-08-17 09:35 | ONON | ONON260821C00032000 | call | 32.0000 | 2026-08-21 | 0.9200 | 0.8600 | 1.0600 | 32.3550 | 14853.00 | 188.00 | 14665.00 | 162 | 24 | 333 | 1220 | 0.272950819672131 | 0.50380754903216 | 0.521450306199551 | true | false | false | true | false |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8155111007.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |