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_alerts566,287 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 |
|---|
| 53f96021-6317-46fe-8804-5ee101232e5a | 2026-08-26 15:54 | 2026-08-26 15:54 | 2026-08-26 15:54 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.2100 | 0.1800 | 0.2100 | 106.7600 | 16162.00 | 15682.00 | 0.00 | 784 | 33 | 939 | 91453 | 0.010267569133872 | 0.080642411678117 | 0.0820986484175881 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 27583004809.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a420b25b-7b69-4534-89d3-285d7d141b64 | 2026-08-31 10:57 | 2026-08-31 10:57 | 2026-08-31 10:57 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.2200 | 0.2200 | 0.2300 | 106.1600 | 49500.00 | 0.00 | 49500.00 | 2250 | 22 | 2329 | 79169 | 0.0294180803092119 | 0.0748175443113706 | 0.0748175443113706 | false | false | false | true | ||||||||||||||||
| fb643714-63ac-4bae-bdd9-3c50871869e4 | 2026-08-31 11:28 | 2026-08-31 11:28 | 2026-08-31 11:28 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.2200 | 0.2200 | 0.2300 | 106.1050 | 40348.00 | 0.00 | 40348.00 | 1834 | 16 | 4216 | 79169 | 0.0532531672750698 | 0.0730881537036623 | 0.0730881537036623 | false | false | false | true | ||||||||||||||||
| 32038068-7b9b-4676-ac00-c9ea9effa46e | 2026-08-31 11:51 | 2026-08-31 11:51 | 2026-08-31 11:51 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.2200 | 0.2200 | 0.2300 | 106.1050 | 42966.00 | 0.00 | 42966.00 | 1953 | 16 | 6191 | 79169 | 0.0781998004269348 | 0.0730881537036623 | 0.0730881537036623 | false | false | false | true | ||||||||||||||||
| 10f7f573-70f3-4ff5-a053-4dd7d0f1b8f9 | 2026-09-01 10:40 | 2026-09-01 10:40 | 2026-09-01 10:40 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.2200 | 0.2200 | 0.2300 | 105.6300 | 37400.00 | 0.00 | 37400.00 | 1700 | 21 | 1824 | 85225 | 0.0214021707245527 | 0.0585970564001521 | 0.0585970564001521 | false | false | false | true | ||||||||||||||||
| bcb11c01-3e95-4e78-8689-2601f4866abe | 2026-09-02 12:34 | 2026-09-02 12:34 | 2026-09-02 12:34 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.3400 | 0.3400 | 0.3700 | 105.2450 | 25398.00 | 0.00 | 25398.00 | 747 | 34 | 5748 | 87139 | 0.0659635754369456 | 0.0597532308314304 | 0.0597532308314304 | false | false | false | true | ||||||||||||||||
| 514175ca-3ecd-48b9-910f-f4eb0fcd8cc2 | 2026-09-02 13:52 | 2026-09-02 13:52 | 2026-09-02 13:52 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.3000 | 0.3000 | 0.3300 | 105.3250 | 18180.00 | 0.00 | 18180.00 | 606 | 27 | 6642 | 87139 | 0.0762230459380989 | 0.0583806981175015 | 0.0583806981175015 | false | false | false | true | ||||||||||||||||
| 180ac19c-03fa-40f5-b370-493996d1010c | 2026-09-02 14:12 | 2026-09-02 14:12 | 2026-09-02 14:12 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.3100 | 0.3100 | 0.3300 | 105.2900 | 34410.00 | 0.00 | 34410.00 | 1110 | 25 | 7752 | 87139 | 0.0889613146811416 | 0.0581036492279129 | 0.0581036492279129 | false | false | false | true | ||||||||||||||||
| 197aaacf-c809-4f94-a1bd-cf13def5b6d8 | 2026-09-10 15:50 | 2026-09-10 15:50 | 2026-09-10 15:50 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.7900 | 0.7900 | 0.8600 | 104.3350 | 79000.00 | 0.00 | 79000.00 | 1000 | 5 | 2395 | 87103 | 0.0274961826802751 | 0.0715570978045953 | 0.0715570978045953 | false | false | false | true | ||||||||||||||||
| d53699bb-d08a-4cb7-acc9-7a8dc9761a95 | 2026-09-14 11:05 | 2026-09-14 11:05 | 2026-09-14 11:05 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.8200 | 0.8200 | 0.8400 | 104.2450 | 10332.00 | 0.00 | 10332.00 | 126 | 10 | 1461 | 81103 | 0.0180141301801413 | 0.0821438884066415 | 0.0821438884066415 | false | false | false | true | ||||||||||||||||
| 6ac35acb-b1a3-4956-ac50-a2ce51994121 | 2026-09-14 11:05 | 2026-09-14 11:05 | 2026-09-14 11:05 | LQD | LQD260918P00105000 | put | 105.0000 | 2026-09-18 | 0.8300 | 0.8300 | 0.8900 | 104.2400 | 17264.00 | 0.00 | 17264.00 | 208 | 13 | 1294 | 81103 | 0.0159550201595502 | 0.0840381765333765 | 0.0840381765333765 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27583004809.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:07:09.972110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27583004809.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27583004809.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27583004809.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27583004809.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27583004809.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 27583004809.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28077877716.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:30:31.573730Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28077877716.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 28077877716.00 |
| — |
| — |
| — |
| 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 |