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 |
|---|
| c600705e-2452-41f5-8950-7033f48a9d68 | 2026-09-25 09:41 | 2026-09-25 09:40 | 2026-09-25 09:40 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 6.7000 | 6.7000 | 6.9500 | 248.7350 | 616405.00 | 0.00 | 616405.00 | 920 | 21 | 942 | 16628 | 0.0566514313206639 | 0.341401049849568 | 0.341401049849568 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 2693018909521.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T13:41:37.814256Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| d5830dd8-bfad-48f0-a1c7-429a0462b822 | 2026-09-24 10:22 | 2026-09-24 10:22 | 2026-09-24 10:22 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 6.3000 | 6.2000 | 6.4000 | 246.5300 | 63000.00 | 52290.00 | 9450.00 | 100 | 8 | 168 | 16535 | 0.0101602661022074 | 0.343428363283129 | 0.343428363283129 | false | false | false | true | ||||||||||||||||
| bcb8370c-856d-4e31-9433-10af39f55dd6 | 2026-09-23 12:58 | 2026-09-23 12:57 | 2026-09-23 12:57 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 6.9400 | 6.8500 | 6.9500 | 248.4500 | 104050.00 | 104050.00 | 0.00 | 150 | 7 | 638 | 16500 | 0.0386666666666667 | 0.345555207498765 | 0.345113269473908 | false | false | false | true | ||||||||||||||||
| 5619a6f1-4cb9-457d-9494-bb6334f51d3b | 2026-09-23 11:02 | 2026-09-23 11:02 | 2026-09-23 11:02 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 7.5900 | 7.5000 | 7.6000 | 250.5200 | 189847.00 | 189847.00 | 0.00 | 250 | 13 | 368 | 16500 | 0.0223030303030303 | 0.347569103262507 | 0.347509878560939 | false | false | false | true | ||||||||||||||||
| 93db5c7f-d88e-4403-93d2-76b694b9ab14 | 2026-09-22 11:57 | 2026-09-22 11:56 | 2026-09-22 11:56 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 8.7000 | 8.6500 | 8.9000 | 254.6200 | 13050.00 | 3480.00 | 870.00 | 15 | 7 | 1076 | 17105 | 0.0629055831628179 | 0.343848776933747 | 0.343848776933747 | false | false | false | true | ||||||||||||||||
| cc4c46c9-8471-47e0-928b-63990c34b92e | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 9.9500 | 9.7000 | 9.9500 | 257.5000 | 370120.00 | 370120.00 | 0.00 | 372 | 9 | 602 | 17105 | 0.0351943876059632 | 0.349970141950623 | 0.350351939128216 | true | false | false | true | ||||||||||||||||
| 49bd6d5e-dec6-40d3-9ac5-69fb2b9e4a05 | 2026-09-22 09:36 | 2026-09-22 09:36 | 2026-09-22 09:36 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 9.7900 | 9.7500 | 9.9000 | 256.9750 | 85130.00 | 0.00 | 45930.00 | 87 | 7 | 230 | 17105 | 0.0134463607132417 | 0.350787251998708 | 0.349826511056074 | false | false | false | true | ||||||||||||||||
| 16151902-c604-4884-b58c-c4479101206b | 2026-09-22 09:36 | 2026-09-22 09:35 | 2026-09-22 09:35 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 9.7500 | 9.7500 | 9.9000 | 257.1000 | 67275.00 | 0.00 | 67275.00 | 69 | 8 | 143 | 17105 | 0.00836012861736334 | 0.348915951746119 | 0.349041558049482 | false | false | false | true | ||||||||||||||||
| be6c3085-03b8-4d6f-8bc9-34f4fb32d67a | 2026-09-22 09:35 | 2026-09-22 09:35 | 2026-09-22 09:35 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 9.7000 | 9.5500 | 9.8000 | 256.8596 | 71780.00 | 9700.00 | 28130.00 | 74 | 5 | 74 | 17105 | 0.00432622040339082 | 0.349588699082264 | 0.349588699082264 | false | false | false | true | ||||||||||||||||
| 2f36be25-3c84-4df4-b88f-f477442938a0 | 2026-09-21 14:30 | 2026-09-21 14:30 | 2026-09-21 14:30 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 10.1500 | 10.1500 | 10.2000 | 258.0000 | 417165.00 | 0.00 | 10150.00 | 411 | 74 | 976 | 16780 | 0.0581644815256257 | 0.347502464516135 | 0.347502464516135 | false | false | false | true | ||||||||||||||||
| bd6bf09a-5ecc-4f77-9cb0-4c35cd3bb2d4 | 2026-08-24 10:01 | 2026-08-24 10:01 | 2026-08-24 10:01 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 13.4500 | 13.4000 | 13.6000 | 262.6900 | 134500.00 | 112980.00 | 21520.00 | 100 | 7 | 597 | 15394 | 0.0387813433805379 | 0.337000368605778 | 0.337000368605778 | false | false | false | true | ||||||||||||||||
| 6be047e3-4f34-4f66-9dae-c3b947334482 | 2026-08-24 10:01 | 2026-08-24 10:01 | 2026-08-24 10:01 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 13.4500 | 13.4000 | 13.6000 | 262.7300 | 349700.00 | 28245.00 | 264965.00 | 260 | 22 | 477 | 15394 | 0.0309860984799272 | 0.336755401206397 | 0.336755401206397 | true | false | false | true | ||||||||||||||||
| 71970f8b-a644-4516-9a5b-1d9ff68b1306 | 2026-08-24 10:01 | 2026-08-24 10:01 | 2026-08-24 10:01 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 13.4500 | 13.3500 | 13.4500 | 262.6100 | 110290.00 | 110290.00 | 0.00 | 82 | 5 | 189 | 15394 | 0.0122775107184617 | 0.337490231621959 | 0.337490231621959 | false | false | false | true | ||||||||||||||||
| 6830a785-3331-4e4e-8f9e-3c015bc8fb62 | 2026-08-24 10:01 | 2026-08-24 10:01 | 2026-08-24 10:01 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 13.4500 | 13.3500 | 13.4500 | 262.5700 | 134500.00 | 134500.00 | 0.00 | 100 | 6 | 107 | 15394 | 0.00695076003637781 | 0.337612682494691 | 0.337735127439998 | false | false | false | true | ||||||||||||||||
| 30b82d02-5dec-4b6a-8d10-824c01f6480c | 2026-08-17 10:38 | 2026-08-17 10:38 | 2026-08-17 10:38 | AMZN | AMZN270115C00290000 | call | 290.0000 | 2027-01-15 | 13.1500 | 12.8500 | 13.1500 | 260.7700 | 394500.00 | 394500.00 | 0.00 | 300 | 9 | 308 | 15676 | 0.0196478693544271 | 0.334837146371251 | 0.334837146371251 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:24:55.986256Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:04:15.950179Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:00:55.569269Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:37:27.552956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:36:05.660724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:36:05.660724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| 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 |