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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| 569d1a07-5dfa-4d63-b2e6-84c002d97dd5 | 2026-08-18 09:59 | 2026-08-18 09:58 | 2026-08-18 09:58 | HYG | HYG260918C00080000 | call | 80.0000 | 2026-09-18 | 0.0800 | 0.0400 | 0.0900 | 79.5300 | 375000.00 | 375000.00 | 0.00 | 50000 | 2 | 51002 | 286111 | 0.178259486702713 | 0.0165090347951434 | 0.0165090347951434 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ETF | — | 14312307094.00 | — | — | — | 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 |
| ee0b04eb-b79c-4a88-886d-6be6dee10e64 | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | HYG | HYG280121P00060000 | put | 60.0000 | 2028-01-21 | 0.7200 | 0.7200 | 2.0000 | 79.5300 | 22976.00 | 0.00 | 22976.00 | 318 | 5 | 321 | 559 | 0.574239713774597 | 0.214128455008189 | 0.214128455008189 | false | false | false | true | false | |||||||||||||||
| 3fe3ec13-6beb-4dfd-a7d9-8fad296fe5d5 | 2026-08-17 15:59 | 2026-08-17 15:59 | 2026-08-17 15:59 | HYG | HYG260918C00079000 | call | 79.0000 | 2026-09-18 | 0.7500 | 0.7300 | 0.7900 | 79.6100 | 207000.00 | 25650.00 | 129450.00 | 2760 | 52 | 7231 | 56241 | 0.128571682580324 | 0.0369146863075766 | 0.0369146863075766 | true | false | false | true | false | |||||||||||||||
| ace5ecf0-0a77-4108-848e-1340c68c0d2f | 2026-08-17 15:59 | 2026-08-17 15:58 | 2026-08-17 15:58 | HYG | HYG260918C00079000 | call | 79.0000 | 2026-09-18 | 0.7500 | 0.7300 | 0.7500 | 79.6150 | 18900.00 | 18900.00 | 0.00 | 252 | 8 | 4471 | 56241 | 0.0794971639906829 | 0.0369146863075766 | 0.0369146863075766 | false | false | false | true | false | |||||||||||||||
| 06adba11-4251-4859-9f75-e3a47bd5465b | 2026-08-17 15:40 | 2026-08-17 15:39 | 2026-08-17 15:39 | HYG | HYG260918P00079000 | put | 79.0000 | 2026-09-18 | 0.2200 | 0.2100 | 0.2200 | 79.6150 | 11000.00 | 11000.00 | 0.00 | 500 | 16 | 46049 | 365055 | 0.126142636041144 | 0.0589660264839574 | 0.0589660264839574 | false | false | false | true | false | |||||||||||||||
| 965d46ef-9acc-4233-8b3b-8fce4b32e138 | 2026-08-17 15:08 | 2026-08-17 15:08 | 2026-08-17 15:08 | HYG | HYG280121P00075000 | put | 75.0000 | 2028-01-21 | 2.6000 | 2.6000 | 3.1000 | 79.6150 | 10400.00 | 0.00 | 10400.00 | 40 | 11 | 472 | 322 | 1.46583850931677 | 0.169358924712285 | 0.169358924712285 | true | false | false | true | false | |||||||||||||||
| 3d0e5e81-456a-43fd-9783-b2e744eec261 | 2026-08-17 15:00 | 2026-08-17 14:59 | 2026-08-17 14:59 | HYG | HYG271217P00075000 | put | 75.0000 | 2027-12-17 | 2.4100 | 2.4100 | 2.7500 | 79.6250 | 79530.00 | 0.00 | 79530.00 | 330 | 29 | 4918 | 8 | 614.75 | 0.16579406600058 | 0.16579406600058 | false | false | false | true | false | |||||||||||||||
| 96cf109d-4272-4ece-8dd4-f29a0fbe5b77 | 2026-08-17 14:59 | 2026-08-17 14:59 | 2026-08-17 14:59 | HYG | HYG271217P00075000 | put | 75.0000 | 2027-12-17 | 2.3900 | 2.3800 | 3.1000 | 79.6250 | 119292.00 | 67637.00 | 51655.00 | 500 | 28 | 4581 | 8 | 572.625 | 0.164749217061141 | 0.165097762261743 | true | false | false | true | false | |||||||||||||||
| 701ce165-0ac2-4c9d-aaa0-91ad5937a33b | 2026-08-17 14:52 | 2026-08-17 14:52 | 2026-08-17 14:52 | HYG | HYG280121P00075000 | put | 75.0000 | 2028-01-21 | 2.6700 | 2.6700 | 3.3500 | 79.6150 | 10680.00 | 0.00 | 10680.00 | 40 | 11 | 198 | 322 | 0.614906832298137 | 0.1716927085472 | 0.1716927085472 | true | false | false | true | false | |||||||||||||||
| 38f73fae-70bc-494d-89d7-ff2689d69221 | 2026-08-17 14:43 | 2026-08-17 14:43 | 2026-08-17 14:43 | HYG | HYG271217P00075000 | put | 75.0000 | 2027-12-17 | 2.4300 | 2.3900 | 2.6200 | 79.6150 | 10449.00 | 0.00 | 10449.00 | 43 | 19 | 3998 | 8 | 499.75 | 0.16640490071931 | 0.16640490071931 | false | false | false | true | false | |||||||||||||||
| f0929522-6d68-46eb-bf07-105abbda7f15 | 2026-08-17 14:35 | 2026-08-17 14:35 | 2026-08-17 14:35 | HYG | HYG260821C00079500 | call | 79.5000 | 2026-08-21 | 0.2000 | 0.2000 | 0.2100 | 79.6150 | 29300.00 | 0.00 | 29300.00 | 1465 | 21 | 2685 | 126354 | 0.0212498219288665 | 0.0332925527277536 | 0.0332925527277536 | false | false | false | true | false | |||||||||||||||
| 2a1db768-f3e2-4593-8fd2-73722e79c39e | 2026-08-17 14:21 | 2026-08-17 14:21 | 2026-08-17 14:21 | HYG | HYG260918P00080000 | put | 80.0000 | 2026-09-18 | 0.6800 | 0.6500 | 0.6800 | 79.6050 | 27132.00 | 27132.00 | 0.00 | 399 | 7 | 555 | 281653 | 0.00197050981171867 | 0.0652191451997955 | 0.0652191451997955 | false | false | false | true | false | |||||||||||||||
| a80c149a-22a2-4b9b-bd84-4a22b19e8e2e | 2026-08-17 14:20 | 2026-08-17 14:20 | 2026-08-17 14:20 | HYG | HYG260918P00079000 | put | 79.0000 | 2026-09-18 | 0.2300 | 0.2100 | 0.2300 | 79.6100 | 24955.00 | 24955.00 | 0.00 | 1085 | 29 | 42922 | 365055 | 0.117576803495364 | 0.060097421877242 | 0.060097421877242 | true | false | false | true | false | |||||||||||||||
| 23b17dc2-2c37-46a6-87c3-26fa939bfe44 | 2026-08-17 13:58 | 2026-08-17 13:58 | 2026-08-17 13:58 | HYG | HYG260918C00079000 | call | 79.0000 | 2026-09-18 | 0.7500 | 0.7500 | 0.8000 | 79.0000 | 87450.00 | 0.00 | 87450.00 | 1166 | 22 | 3146 | 56241 | 0.0559378389431198 | 0.0411079902965702 | 0.0411079902965702 | false | false | false | true | false | |||||||||||||||
| afd40937-e34c-44b9-b75a-0c509569669f | 2026-08-17 13:58 | 2026-08-17 13:58 | 2026-08-17 13:58 | HYG | HYG260918C00079000 | call | 79.0000 | 2026-09-18 | 0.7500 | 0.7500 | 0.8000 | 79.0000 | 62550.00 | 0.00 | 62550.00 | 834 | 26 | 1980 | 56241 | 0.0352056329012642 | 0.0411079902965702 | 0.0411079902965702 | false | false | false | true | false | |||||||||||||||
| 73888ff5-b734-4a99-ae07-2cd67d1039df | 2026-08-17 12:56 | 2026-08-17 12:56 | 2026-08-17 12:56 | HYG | HYG271217P00075000 | put | 75.0000 | 2027-12-17 | 2.5900 | 2.5900 | 2.6000 | 79.6300 | 161098.00 | 0.00 | 161098.00 | 622 | 35 | 2136 | 8 | 267 | 0.172058727110221 | 0.172058727110221 | false | false | false | true | false | |||||||||||||||
| 6b5e53cf-26f4-472e-81f9-35a2672727b8 | 2026-08-17 12:03 | 2026-08-17 12:03 | 2026-08-17 12:03 | HYG | HYG260918P00079000 | put | 79.0000 | 2026-09-18 | 0.2000 | 0.2000 | 0.2300 | 79.6550 | 13720.00 | 0.00 | 13720.00 | 686 | 18 | 26171 | 365055 | 0.0716905671748093 | 0.0576537091310818 | 0.0576537091310818 | false | false | false | true | false | |||||||||||||||
| d158d435-e6d1-4576-b2ac-28a4f68bc94a | 2026-08-17 10:53 | 2026-08-17 10:53 | 2026-08-17 10:53 | HYG | HYG271217P00075000 | put | 75.0000 | 2027-12-17 | 2.5500 | 2.5500 | 2.5600 | 79.6800 | 53295.00 | 0.00 | 53295.00 | 209 | 22 | 1008 | 8 | 126 | 0.171107318865136 | 0.171107318865136 | false | false | false | true | false | |||||||||||||||
| 8882c6af-b4db-4428-855d-62b0ad6d44e4 | 2026-08-17 10:32 | 2026-08-17 10:32 | 2026-08-17 10:32 | HYG | HYG270716P00075000 | put | 75.0000 | 2027-07-16 | 1.4200 | 1.4200 | 1.5100 | 79.6950 | 32093.00 | 0.00 | 32093.00 | 226 | 21 | 460 | 48170 | 0.00954951214448827 | 0.141487044510497 | 0.141487044510497 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:59:29.758034Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| 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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 14312307094.00 |
| — |
| — |
| — |
| 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 |