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 | 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 |
|---|
| 1e7b166d-9b74-440f-9680-e71ea881e67d | 2026-09-25 15:55 | 2026-09-25 15:55 | 2026-09-25 15:55 | REPL | REPL261016C00012500 | call | 12.5000 | 2026-10-16 | 0.9400 | 0.8500 | 0.9500 | 12.4000 | 15420.00 | 12540.00 | 2790.00 | 164 | 14 | 230 | 0 | 0 | 0.787035640094713 | 0.787035640094713 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1164554676.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:58:21.779683Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| f656693c-e703-4b65-81fe-eb7b1aa00759 | 2026-09-22 12:52 | 2026-09-22 12:52 | 2026-09-22 12:52 | REPL | REPL270115C00019000 | call | 19.0000 | 2027-01-15 | 1.0000 | 0.6000 | 1.0500 | 13.4200 | 11100.00 | 9000.00 | 100.00 | 111 | 16 | 321 | 9 | 35.6666666666667 | 0.824212919082621 | 0.826555613754509 | false | false | false | |||||||||||||||||
| 77ac4ad7-0a57-417c-b76c-56d28ed17888 | 2026-09-14 11:11 | 2026-09-14 11:11 | 2026-09-14 11:11 | REPL | REPL260918P00013500 | put | 13.5000 | 2026-09-18 | 0.4500 | 0.4000 | 0.7000 | 13.3050 | 13500.00 | 1215.00 | 45.00 | 300 | 11 | 400 | 718 | 0.557103064066852 | 0.620616357521017 | 0.620616357521017 | false | false | false | |||||||||||||||||
| 9bcdce72-bee2-4c55-bb29-4b3beefda239 | 2026-09-10 12:17 | 2026-09-10 12:17 | 2026-09-10 12:17 | REPL | REPL260918P00013000 | put | 13.0000 | 2026-09-18 | 0.4000 | 0.3500 | 0.5000 | 13.5500 | 16920.00 | 9560.00 | 6840.00 | 423 | 13 | 870 | 1175 | 0.740425531914894 | 0.819549467022369 | 0.819549467022369 | true | false | false | |||||||||||||||||
| 824f1aeb-4e4d-427c-a4e5-430c3c980f83 | 2026-09-10 12:17 | 2026-09-10 12:17 | 2026-09-10 12:17 | REPL | REPL260918P00013000 | put | 13.0000 | 2026-09-18 | 0.3500 | 0.3500 | 0.4000 | 13.6000 | 11970.00 | 0.00 | 9625.00 | 342 | 14 | 342 | 1175 | 0.291063829787234 | 0.795975644405986 | 0.773817941096971 | false | false | false | |||||||||||||||||
| 0a1ef01b-6669-40bb-b095-d2c25a213c40 | 2026-08-25 15:53 | 2026-08-25 15:52 | 2026-08-25 15:52 | REPL | REPL260918C00015000 | call | 15.0000 | 2026-09-18 | 1.1500 | 1.1500 | 2.3000 | 15.7510 | 23000.00 | 0.00 | 23000.00 | 200 | 12 | 202 | 241 | 0.838174273858921 | 0.436269916018632 | 0.436269916018632 | false | false | false | |||||||||||||||||
| b26a6718-f723-446e-923d-538486b308d2 | 2026-08-25 13:45 | 2026-08-25 13:45 | 2026-08-25 13:45 | REPL | REPL260828C00016000 | call | 16.0000 | 2026-08-28 | 0.4000 | 0.1500 | 0.4500 | 15.8000 | 12959.00 | 2999.00 | 5760.00 | 324 | 23 | 712 | 300 | 2.37333333333333 | 0.902073587984422 | 0.854795502005955 | false | false | false | |||||||||||||||||
| 8ff3afc7-83dd-4623-b68e-eb55d69c05a3 | 2026-08-24 11:11 | 2026-08-24 11:11 | 2026-08-24 11:11 | REPL | REPL261120P00014000 | put | 14.0000 | 2026-11-20 | 2.1000 | 2.1000 | 2.2500 | 14.6400 | 12180.00 | 0.00 | 12180.00 | 58 | 5 | 59 | 162 | 0.364197530864198 | 0.890407525419919 | 0.890407525419919 | false | false | false | |||||||||||||||||
| 8e600560-1413-4b2b-8b19-f6bdf42a7f37 | 2026-08-19 11:57 | 2026-08-19 11:57 | 2026-08-19 11:57 | REPL | REPL260918C00015000 | call | 15.0000 | 2026-09-18 | 1.6000 | 1.2500 | 2.0000 | 14.9100 | 32000.00 | 25600.00 | 2720.00 | 200 | 6 | 200 | 53 | 3.77358490566038 | 0.952507701688333 | 0.952507701688333 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 1269138470.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:59:26.444099Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 1235219402.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 1235219402.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 1235219402.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 1235219402.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 1235219402.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 1235219402.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 1235219402.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |