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 |
|---|
| b75c55e2-eeb1-4807-a143-b467a605c06d | 2026-09-29 10:24 | 2026-09-29 10:24 | 2026-09-29 10:24 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 15.0000 | 14.6000 | 15.0000 | 244.0650 | 19500.00 | 19500.00 | 0.00 | 13 | 9 | 1553 | 5015 | 0.309670987038883 | 0.829320492834573 | 0.829320492834573 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 52091135962.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T14:27:05.819137Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 2d5160d8-463d-4ca4-b3b2-5b074f9fd572 | 2026-09-29 12:40 | 2026-09-29 12:40 | 2026-09-29 12:40 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 13.0000 | 12.9000 | 13.5000 | 241.0900 | 18200.00 | 1300.00 | 16900.00 | 14 | 10 | 2024 | 5015 | 0.403589232303091 | 0.800554684410268 | 0.800554684410268 | true | false | false | true | ||||||||||||||||
| add5ec46-a535-48bd-a50a-b55348421609 | 2026-09-29 14:43 | 2026-09-29 14:43 | 2026-09-29 14:43 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 12.2500 | 11.9500 | 12.3500 | 239.4000 | 200900.00 | 88200.00 | 75950.00 | 164 | 5 | 2224 | 5015 | 0.443469591226321 | 0.800825987965078 | 0.800825987965078 | false | false | false | true | ||||||||||||||||
| a9c01090-be59-4f85-bd14-22272374f771 | 2026-09-30 09:31 | 2026-09-30 09:30 | 2026-09-30 09:30 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 15.8700 | 15.6000 | 15.9500 | 247.5000 | 20635.00 | 15885.00 | 4750.00 | 13 | 9 | 450 | 4361 | 0.103187342352671 | 0.81311899047445 | 0.815539258419335 | true | false | false | true | ||||||||||||||||
| 5a6a1ff5-aadd-4723-811b-1c8b78e10919 | 2026-09-30 09:35 | 2026-09-30 09:35 | 2026-09-30 09:35 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 17.0000 | 16.9500 | 17.0000 | 249.2100 | 40800.00 | 40800.00 | 0.00 | 24 | 7 | 570 | 4361 | 0.13070396698005 | 0.825470007464068 | 0.825470007464068 | false | false | false | true | ||||||||||||||||
| dccce7bc-df12-4c7d-9636-4bc0cfea8f0b | 2026-09-30 11:18 | 2026-09-30 11:18 | 2026-09-30 11:18 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 10.0000 | 10.0000 | 10.1500 | 236.2000 | 167000.00 | 0.00 | 167000.00 | 167 | 5 | 1830 | 4361 | 0.41962852556753 | 0.779296612759745 | 0.779296612759745 | false | false | false | true | ||||||||||||||||
| 33b3db9d-269d-421e-97fb-3e68867858fe | 2026-09-30 12:06 | 2026-09-30 12:06 | 2026-09-30 12:06 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 12.2000 | 12.1500 | 12.2500 | 241.0800 | 52460.00 | 40260.00 | 12200.00 | 43 | 6 | 1961 | 4361 | 0.449667507452419 | 0.785936594800475 | 0.785936594800475 | false | false | false | true | ||||||||||||||||
| d9205888-2d66-4ae0-9186-7d8669e45775 | 2026-09-30 15:32 | 2026-09-30 15:32 | 2026-09-30 15:32 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 10.0000 | 9.8500 | 10.1500 | 235.7253 | 141000.00 | 0.00 | 131000.00 | 141 | 5 | 2973 | 4361 | 0.681724375143316 | 0.789204701137829 | 0.789204701137829 | false | false | false | true | ||||||||||||||||
| e344322b-c3c4-4ad9-be11-681ee5d970fb | 2026-09-30 15:35 | 2026-09-30 15:35 | 2026-09-30 15:35 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 10.3000 | 10.2500 | 10.3000 | 236.2420 | 228632.00 | 221450.00 | 7182.00 | 222 | 6 | 3309 | 4361 | 0.758770924099977 | 0.792017715647442 | 0.794107734099477 | false | false | false | true | ||||||||||||||||
| efc0f32d-31a7-4644-a791-0617d297a15a | 2026-09-30 15:37 | 2026-09-30 15:37 | 2026-09-30 15:37 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 10.3000 | 10.1500 | 10.3000 | 236.0950 | 228660.00 | 195700.00 | 0.00 | 222 | 13 | 3534 | 4361 | 0.810364595276313 | 0.797198088674414 | 0.797198088674414 | false | false | false | true | ||||||||||||||||
| 7b2a71c6-7f4f-4fbe-ae10-11f0c9b5ec5f | 2026-09-30 15:41 | 2026-09-30 15:41 | 2026-09-30 15:41 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 10.3000 | 10.2000 | 10.3000 | 236.1000 | 126680.00 | 126680.00 | 0.00 | 123 | 8 | 3662 | 4361 | 0.839715661545517 | 0.79709302000424 | 0.796569987489535 | false | false | false | true | ||||||||||||||||
| 5d282424-2823-4ab0-b3d6-ecb0b187e485 | 2026-10-01 10:08 | 2026-10-01 10:08 | 2026-10-01 10:08 | NBIS | NBIS261016C00250000 | call | 250.0000 | 2026-10-16 | 7.5800 | 7.2000 | 7.6000 | 230.2900 | 21975.00 | 12160.00 | 9815.00 | 29 | 16 | 693 | 5555 | 0.124752475247525 | 0.792764604011968 | 0.792764604011968 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:44:24.816424Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:44:56.074296Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:31:22.078710Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:36:52.270461Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T15:21:43.469361Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:13:44.335833Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:37:24.384434Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:37:24.384434Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:37:24.384434Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 52091135962.00 |
| — |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:42:03.921497Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 50977350641.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:08:52.492718Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |