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 |
|---|
| 6a692cc8-2552-4d0e-8e27-9194e99b5783 | 2026-09-21 12:40 | 2026-09-21 12:40 | 2026-09-21 12:40 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 20.5000 | 20.5000 | 20.7000 | 727.9100 | 30750.00 | 0.00 | 30750.00 | 15 | 6 | 161 | 31 | 5.19354838709677 | 0.46664185214706 | 0.46664185214706 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:41:29.676906Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| e9c3fd39-9457-4761-be86-392d72ae351e | 2026-09-23 09:41 | 2026-09-23 09:41 | 2026-09-23 09:41 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 33.3100 | 32.9000 | 33.5500 | 749.9168 | 23320.00 | 13340.00 | 9980.00 | 7 | 5 | 8 | 283 | 0.0282685512367491 | 0.520774978012624 | 0.520774978012624 | true | false | false | |||||||||||||||||
| 6d4ce788-ca48-407f-b826-3b653960d2fb | 2026-09-24 09:49 | 2026-09-24 09:49 | 2026-09-24 09:49 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 34.2000 | 33.2000 | 34.2000 | 754.3400 | 212040.00 | 212040.00 | 0.00 | 62 | 13 | 86 | 362 | 0.237569060773481 | 0.482837279413948 | 0.482837279413948 | true | false | false | |||||||||||||||||
| 05a03895-47f9-4a87-bb33-e5d2a57b58de | 2026-09-28 09:43 | 2026-09-28 09:43 | 2026-09-28 09:43 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 4.0000 | 4.0000 | 4.2500 | 721.0000 | 10000.00 | 0.00 | 10000.00 | 25 | 6 | 1623 | 306 | 5.30392156862745 | 0.747847655729662 | 0.747847655729662 | true | false | false | true | ||||||||||||||||
| 061da3e5-1f85-43f4-9164-ea843baf8591 | 2026-09-28 10:01 | 2026-09-28 10:01 | 2026-09-28 10:01 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 3.7900 | 3.5500 | 3.9000 | 722.6600 | 12520.00 | 12160.00 | 360.00 | 33 | 6 | 3832 | 306 | 12.5228758169935 | 0.651828333272086 | 0.618667686882189 | false | false | false | |||||||||||||||||
| d0c5333a-e6f6-4e5a-8597-c89509f9a741 | 2026-09-28 10:13 | 2026-09-28 10:13 | 2026-09-28 10:13 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.0000 | 1.8900 | 2.0300 | 717.9800 | 10000.00 | 10000.00 | 0.00 | 50 | 6 | 7128 | 306 | 23.2941176470588 | 0.64295602375805 | 0.630108798704728 | true | false | false | true | ||||||||||||||||
| 3615b62b-512f-43ff-9e02-f8a5f5e2af07 | 2026-09-28 10:16 | 2026-09-28 10:16 | 2026-09-28 10:16 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 3.1500 | 3.1000 | 3.3000 | 721.9100 | 11025.00 | 0.00 | 11025.00 | 35 | 6 | 8515 | 306 | 27.8267973856209 | 0.592840929888317 | 0.612485552518162 | true | false | false | true | ||||||||||||||||
| a2f918c3-135e-4dd1-be4a-183c5bf6b7ef | 2026-09-28 10:32 | 2026-09-28 10:32 | 2026-09-28 10:32 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.9800 | 2.8000 | 2.9800 | 722.3725 | 26820.00 | 26820.00 | 0.00 | 90 | 13 | 11026 | 306 | 36.0326797385621 | 0.580920215376048 | 0.576161943519967 | false | false | false | |||||||||||||||||
| 2f7f1252-4f0b-4eac-b70f-0292e0b28283 | 2026-09-28 10:38 | 2026-09-28 10:38 | 2026-09-28 10:38 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.0000 | 2.0000 | 2.0800 | 719.2700 | 17600.00 | 0.00 | 17600.00 | 88 | 12 | 11960 | 306 | 39.0849673202614 | 0.598120207003112 | 0.598120207003112 | false | false | false | |||||||||||||||||
| 86737658-d075-4022-93cd-f867ab304df8 | 2026-09-28 12:26 | 2026-09-28 12:25 | 2026-09-28 12:25 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.1800 | 2.1800 | 2.2500 | 723.4200 | 19838.00 | 0.00 | 19838.00 | 91 | 15 | 23378 | 306 | 76.3986928104575 | 0.496854169333562 | 0.496854169333562 | true | false | false | |||||||||||||||||
| fd85b95c-a212-427c-b5b9-2c7b3554accd | 2026-09-28 12:26 | 2026-09-28 12:26 | 2026-09-28 12:26 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 2.6000 | 2.5000 | 2.5000 | 724.1603 | 19756.00 | 19756.00 | 0.00 | 76 | 7 | 23991 | 306 | 78.4019607843137 | 0.514328545827881 | 0.514328545827881 | true | false | false | |||||||||||||||||
| 21ddf628-c80f-4ea4-8a16-4968b30d011d | 2026-09-28 12:27 | 2026-09-28 12:27 | 2026-09-28 12:27 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 3.0000 | 2.9100 | 3.0000 | 724.7568 | 13500.00 | 13500.00 | 0.00 | 45 | 10 | 24278 | 306 | 79.3398692810458 | 0.535052851522722 | 0.535052851522722 | false | false | false | |||||||||||||||||
| 327228c1-eb85-4b4a-a252-a567fe4f0203 | 2026-09-28 12:27 | 2026-09-28 12:27 | 2026-09-28 12:27 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 3.1000 | 3.0500 | 3.1000 | 725.2350 | 26350.00 | 26350.00 | 0.00 | 85 | 9 | 24507 | 306 | 80.0882352941177 | 0.51140327755891 | 0.51140327755891 | true | false | false | true | ||||||||||||||||
| b3035bdd-2df2-47fd-b606-07c03959eec7 | 2026-09-28 12:32 | 2026-09-28 12:31 | 2026-09-28 12:31 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 3.1500 | 3.0000 | 3.1500 | 725.1800 | 15750.00 | 15750.00 | 0.00 | 50 | 10 | 25605 | 306 | 83.6764705882353 | 0.530465076664521 | 0.530465076664521 | false | false | false | |||||||||||||||||
| 5620cadb-31f2-4a85-8335-381e62004585 | 2026-09-28 13:22 | 2026-09-28 13:22 | 2026-09-28 13:22 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 1.1300 | 1.0500 | 1.1300 | 720.8500 | 11297.00 | 11297.00 | 0.00 | 100 | 6 | 34634 | 306 | 113.183006535948 | 0.543060517228601 | 0.535811940553064 | false | false | false | |||||||||||||||||
| 64e74af8-3100-4196-a184-4a86ee2a3974 | 2026-09-28 13:41 | 2026-09-28 13:41 | 2026-09-28 13:41 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 1.6600 | 1.6600 | 1.6700 | 723.0000 | 16600.00 | 0.00 | 16600.00 | 100 | 10 | 36481 | 306 | 119.218954248366 | 0.510669833124981 | 0.510669833124981 | true | false | false | |||||||||||||||||
| 810a39a7-b646-4fda-ab6b-bf36d1a228c0 | 2026-09-28 13:44 | 2026-09-28 13:44 | 2026-09-28 13:44 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 1.0900 | 1.0900 | 1.1500 | 722.0000 | 10900.00 | 0.00 | 10900.00 | 100 | 5 | 36945 | 306 | 120.735294117647 | 0.492775562638167 | 0.492775562638167 | false | false | false | |||||||||||||||||
| 817da8f6-3335-4652-a3db-cb5d1c25bfc4 | 2026-09-28 13:52 | 2026-09-28 13:52 | 2026-09-28 13:52 | META | META260928C00725000 | call | 725.0000 | 2026-09-28 | 1.4000 | 1.4000 | 1.4200 | 723.0000 | 11340.00 | 0.00 | 11340.00 | 81 | 5 | 37716 | 306 | 123.254901960784 | 0.501457500732051 | 0.501457500732051 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:45:28.249714Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:03:25.739526Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:13:51.758637Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:18:45.811547Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:35:37.335936Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:39:59.726153Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:26:41.677786Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:27:13.606769Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:27:13.606769Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:28:39.612628Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:34:48.281149Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:25:25.188359Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:41:35.586557Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:50:34.009292Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1578034063611.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:00:44.175376Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |