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_alerts658,639 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 |
|---|
| 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 |
|---|
| fafcda2d-1b3d-44f2-ae28-0bee342c5997 | 2026-09-03 09:50 | 2026-09-03 09:49 | 2026-09-03 09:49 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.3400 | 9.3300 | 9.3400 | 769.6300 | 202678.00 | 176526.00 | 0.00 | 217 | 14 | 4015 | 6281 | 0.63922942206655 | 0.14283055137337 | 0.142902818049632 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 802935622223.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e1faf5f5-3c8e-48d4-bd59-89bbc46b2e2d | 2026-09-03 09:49 | 2026-09-03 09:49 | 2026-09-03 09:49 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.3500 | 9.3400 | 9.3500 | 769.6100 | 141185.00 | 141185.00 | 0.00 | 151 | 6 | 3731 | 6281 | 0.594013692087247 | 0.142932170549594 | 0.142932170549594 | false | false | false | true | false | |||||||||||||||
| dcf69d2c-29c6-4fe1-acf5-3b469085bbbf | 2026-09-03 09:49 | 2026-09-03 09:49 | 2026-09-03 09:49 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.3900 | 9.3800 | 9.3900 | 769.5100 | 136155.00 | 134277.00 | 0.00 | 145 | 6 | 3580 | 6281 | 0.569972934246139 | 0.143012864629133 | 0.142976651148692 | false | false | false | true | false | |||||||||||||||
| 9dbb71f9-cd3c-4c0b-83e1-07ebd55fc645 | 2026-09-03 09:48 | 2026-09-03 09:48 | 2026-09-03 09:48 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.3100 | 9.3000 | 9.3100 | 769.7500 | 223440.00 | 203889.00 | 0.00 | 240 | 11 | 3193 | 6281 | 0.508358541633498 | 0.143030857346212 | 0.143030857346212 | false | false | false | true | false | |||||||||||||||
| 4c66f4df-7950-4476-86aa-89f2984ec12a | 2026-09-03 09:48 | 2026-09-03 09:48 | 2026-09-03 09:48 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.2500 | 9.2400 | 9.2500 | 769.8150 | 197950.00 | 197950.00 | 0.00 | 214 | 12 | 2911 | 6281 | 0.463461232287852 | 0.142654345503006 | 0.142654345503006 | false | false | false | true | false | |||||||||||||||
| 92c23288-d7b0-4b45-b365-74b498582a4c | 2026-09-03 09:48 | 2026-09-03 09:48 | 2026-09-03 09:48 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.2400 | 9.2300 | 9.2400 | 769.8600 | 224531.00 | 193116.00 | 923.00 | 243 | 18 | 2696 | 6281 | 0.429231014169718 | 0.142714386332701 | 0.142612529401287 | false | false | false | true | false | |||||||||||||||
| fe3395e9-34fc-41c8-ba99-e60d49ef8b79 | 2026-09-03 09:47 | 2026-09-03 09:47 | 2026-09-03 09:47 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.2400 | 9.2300 | 9.2400 | 769.8700 | 116424.00 | 116424.00 | 0.00 | 126 | 5 | 2125 | 6281 | 0.338321923260627 | 0.142750342451092 | 0.142750342451092 | false | false | false | true | false | |||||||||||||||
| c13c3ace-58bf-4d68-8677-661542635abd | 2026-09-03 09:47 | 2026-09-03 09:47 | 2026-09-03 09:47 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.2600 | 9.2400 | 9.2600 | 769.7900 | 247242.00 | 247242.00 | 0.00 | 267 | 10 | 1924 | 6281 | 0.306320649578093 | 0.14266616359136 | 0.14266616359136 | false | false | false | true | false | |||||||||||||||
| 5cc602f7-2689-413e-a458-1d9d6176ff2e | 2026-09-03 09:47 | 2026-09-03 09:46 | 2026-09-03 09:46 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.2700 | 9.2500 | 9.2700 | 769.7550 | 252144.00 | 226188.00 | 0.00 | 272 | 10 | 1657 | 6281 | 0.263811494984875 | 0.142641888991886 | 0.142641888991886 | false | false | false | true | false | |||||||||||||||
| 698aff9c-8b78-42ab-8448-59cbd78f167d | 2026-09-03 09:46 | 2026-09-03 09:46 | 2026-09-03 09:46 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.2500 | 9.2500 | 9.2600 | 769.7800 | 276575.00 | 0.00 | 276575.00 | 299 | 7 | 1356 | 6281 | 0.215889189619487 | 0.142492357273516 | 0.142528363267437 | false | false | false | true | false | |||||||||||||||
| 942d6c10-43a3-45e7-ad9c-f3af3cbda049 | 2026-09-03 09:46 | 2026-09-03 09:46 | 2026-09-03 09:46 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 9.2600 | 9.2400 | 9.2600 | 769.7601 | 262058.00 | 262058.00 | 0.00 | 283 | 5 | 729 | 6281 | 0.116064320967999 | 0.142558488787347 | 0.142558488787347 | false | false | false | true | false | |||||||||||||||
| 917bf297-cb5b-4beb-a14f-ea2f1a9c6c7f | 2026-08-28 10:59 | 2026-08-28 10:59 | 2026-08-28 10:59 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 8.4000 | 8.3900 | 8.4000 | 774.9700 | 210000.00 | 210000.00 | 0.00 | 250 | 6 | 1064 | 4724 | 0.225232853513971 | 0.143861764388494 | 0.143892761783654 | false | false | false | true | false | |||||||||||||||
| 6a25ae50-3f0e-45f1-916f-e3fd469eab90 | 2026-08-26 13:42 | 2026-08-26 13:42 | 2026-08-26 13:42 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 12.1300 | 12.1000 | 12.1300 | 765.4700 | 114022.00 | 114022.00 | 0.00 | 94 | 7 | 471 | 4315 | 0.109154113557358 | 0.145109249538101 | 0.144964974655545 | false | false | false | true | false | |||||||||||||||
| 674378f8-08c8-4722-9bec-a2516d919086 | 2026-08-25 12:04 | 2026-08-25 12:04 | 2026-08-25 12:04 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 12.2500 | 12.2300 | 12.2500 | 765.6500 | 128625.00 | 128625.00 | 0.00 | 105 | 6 | 1564 | 4483 | 0.348873522194959 | 0.145578919198209 | 0.145578919198209 | false | false | false | true | false | |||||||||||||||
| 439e7a23-95e5-4ae4-a276-6533f6734986 | 2026-08-25 10:48 | 2026-08-25 10:48 | 2026-08-25 10:48 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 12.9000 | 12.8600 | 12.9100 | 764.2700 | 258000.00 | 258000.00 | 0.00 | 200 | 5 | 1102 | 4483 | 0.245817532902075 | 0.146410070427894 | 0.146410070427894 | false | false | false | true | false | |||||||||||||||
| 909cdd68-f624-4277-a753-437cf0d14459 | 2026-08-25 09:34 | 2026-08-25 09:34 | 2026-08-25 09:34 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 12.1400 | 12.1000 | 12.1400 | 766.5200 | 364200.00 | 364200.00 | 0.00 | 300 | 12 | 342 | 4483 | 0.076288199866161 | 0.147669555187494 | 0.147669555187494 | false | false | false | true | false | |||||||||||||||
| 73b87a9e-82c3-40ed-b849-1f9666467b0f | 2026-08-24 09:42 | 2026-08-24 09:42 | 2026-08-24 09:42 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 13.4300 | 13.3900 | 13.4300 | 763.4200 | 401557.00 | 401557.00 | 0.00 | 299 | 8 | 514 | 3543 | 0.145074795371154 | 0.146893739395813 | 0.146893739395813 | false | false | false | true | false | |||||||||||||||
| 834ab7b7-a887-4861-b605-f7785644b61c | 2026-08-18 11:09 | 2026-08-18 11:09 | 2026-08-18 11:09 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 13.0700 | 13.0700 | 13.1200 | 767.8694 | 133314.00 | 0.00 | 133314.00 | 102 | 7 | 522 | 3417 | 0.152765583845479 | 0.152922838758333 | 0.152922838758333 | false | false | false | true | false | |||||||||||||||
| fff42b17-0f1b-4adc-bc57-a63ec3c1f8ce | 2026-08-17 12:17 | 2026-08-17 12:17 | 2026-08-17 12:17 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 10.7500 | 10.7400 | 10.7700 | 775.4600 | 293475.00 | 0.00 | 293475.00 | 273 | 7 | 1013 | 3165 | 0.320063191153239 | 0.154996234125144 | 0.154996234125144 | false | false | false | true | false | |||||||||||||||
| c5ae2b98-14b1-4399-8628-aeb16973d571 | 2026-08-17 12:15 | 2026-08-17 12:15 | 2026-08-17 12:15 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 10.7500 | 10.7400 | 10.7700 | 775.4400 | 198875.00 | 21500.00 | 177375.00 | 185 | 6 | 598 | 3165 | 0.188941548183254 | 0.15493870329928 | 0.15493870329928 | false | false | false | true | false | |||||||||||||||
| 5bdc5335-c4ab-4e5e-a1e3-3d256acc3e64 | 2026-08-17 12:15 | 2026-08-17 12:15 | 2026-08-17 12:15 | SPY | SPY261016P00760000 | put | 760.0000 | 2026-10-16 | 10.7500 | 10.7500 | 10.7600 | 775.4400 | 152650.00 | 0.00 | 152650.00 | 142 | 5 | 740 | 3165 | 0.233807266982622 | 0.15493870329928 | 0.15493870329928 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:41:46.514863Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:46:45.098903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.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 |
| — |
| 802935622223.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 |