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_alerts609,118 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 |
|---|
| 9598fb91-7fad-4015-a89e-74f0ffc7d06c | 2026-09-01 12:40 | 2026-09-01 12:40 | 2026-09-01 12:40 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 95.2000 | 95.0000 | 95.2000 | 7638.0600 | 323680.00 | 323680.00 | 0.00 | 34 | 5 | 102 | 5 | 20.4 | 0.119856944519202 | 0.119856944519202 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:48:42.201804Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7e8c9b5f-e74f-46ac-94fb-a1c758e5711f | 2026-09-17 12:58 | 2026-09-17 12:58 | 2026-09-17 12:58 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 35.7000 | 35.6000 | 35.7000 | 7631.9400 | 114240.00 | 114240.00 | 0.00 | 32 | 7 | 188 | 339 | 0.554572271386431 | 0.105558860823628 | 0.105558860823628 | false | false | false | true | ||||||||||||||||
| 611e54bd-34ab-4549-8de1-5512d6a922f8 | 2026-09-18 09:38 | 2026-09-18 09:38 | 2026-09-18 09:38 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 31.0000 | 30.7000 | 31.1000 | 7642.8600 | 310000.00 | 34100.00 | 275900.00 | 100 | 7 | 117 | 433 | 0.270207852193995 | 0.0871279167941104 | 0.0871279167941104 | false | false | false | true | ||||||||||||||||
| d2dbc08a-803e-4bbf-bcce-07a1371c4f18 | 2026-09-18 09:50 | 2026-09-18 09:50 | 2026-09-18 09:50 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 25.0000 | 24.9000 | 25.2000 | 7633.8300 | 125000.00 | 110000.00 | 15000.00 | 50 | 6 | 231 | 433 | 0.533487297921478 | 0.0827887504551799 | 0.0827887504551799 | false | false | false | true | ||||||||||||||||
| 983d6711-2cf3-4fff-affa-b23c7325b8c1 | 2026-09-18 09:50 | 2026-09-18 09:50 | 2026-09-18 09:50 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 25.0000 | 24.9000 | 25.2000 | 7633.5500 | 125000.00 | 80000.00 | 45000.00 | 50 | 7 | 181 | 433 | 0.418013856812933 | 0.0832139913949946 | 0.0832139913949946 | false | false | false | true | ||||||||||||||||
| 75c8ea23-a9d8-4ada-819b-68ee3d925d05 | 2026-09-18 10:52 | 2026-09-18 10:52 | 2026-09-18 10:52 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 23.1000 | 22.8000 | 23.2000 | 7628.3100 | 231000.00 | 131670.00 | 99330.00 | 100 | 12 | 635 | 433 | 1.46651270207852 | 0.0849487319564486 | 0.0849487319564486 | false | false | false | true | ||||||||||||||||
| c89fcfc2-8dc3-4638-8504-cfa48dc5987b | 2026-09-18 11:02 | 2026-09-18 11:02 | 2026-09-18 11:02 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 21.5000 | 21.4000 | 21.7000 | 7625.5800 | 215000.00 | 55900.00 | 159100.00 | 100 | 14 | 750 | 433 | 1.73210161662818 | 0.0837215413665915 | 0.0837215413665915 | false | false | false | true | ||||||||||||||||
| 30ad0f4a-ece1-4a26-a7a2-4d081fc51113 | 2026-09-18 11:07 | 2026-09-18 11:07 | 2026-09-18 11:07 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 23.6000 | 23.3000 | 23.7000 | 7630.5400 | 118000.00 | 70800.00 | 47200.00 | 50 | 10 | 805 | 433 | 1.85912240184758 | 0.0832979722624295 | 0.0832979722624295 | false | false | false | true | ||||||||||||||||
| 08eab559-6a06-488d-9c3f-2714bf6d4259 | 2026-09-18 11:07 | 2026-09-18 11:07 | 2026-09-18 11:07 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 23.6000 | 23.4000 | 23.7000 | 7630.4000 | 118000.00 | 82600.00 | 35400.00 | 50 | 9 | 855 | 433 | 1.97459584295612 | 0.0835029023882869 | 0.0835029023882869 | false | false | false | true | ||||||||||||||||
| db2ee3de-c927-4cb0-912f-face6e5d91bd | 2026-09-18 11:39 | 2026-09-18 11:39 | 2026-09-18 11:39 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 19.7000 | 19.6000 | 19.9000 | 7623.6600 | 246270.00 | 139870.00 | 102440.00 | 125 | 16 | 1027 | 433 | 2.37182448036951 | 0.0809243775948029 | 0.0806041069932818 | false | false | false | true | ||||||||||||||||
| b2085104-8a15-4469-9c39-49fc8c22ba22 | 2026-09-18 11:43 | 2026-09-18 11:43 | 2026-09-18 11:43 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 20.1000 | 19.9000 | 20.2000 | 7623.3700 | 100500.00 | 60300.00 | 40200.00 | 50 | 12 | 1088 | 433 | 2.51270207852194 | 0.0822768722546971 | 0.0822768722546971 | false | false | false | true | ||||||||||||||||
| 24a50fb1-440c-45f2-b4ea-ede2872fd73d | 2026-09-18 11:43 | 2026-09-18 11:43 | 2026-09-18 11:43 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 20.1000 | 19.9000 | 20.2000 | 7623.3700 | 100500.00 | 76380.00 | 24120.00 | 50 | 12 | 1138 | 433 | 2.62817551963049 | 0.0822768722546971 | 0.0822768722546971 | false | false | false | true | ||||||||||||||||
| 0fb2be39-06c6-40a2-a71a-f002834a82ae | 2026-09-18 11:43 | 2026-09-18 11:43 | 2026-09-18 11:43 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 20.1000 | 20.0000 | 20.2000 | 7623.3700 | 100500.00 | 40200.00 | 60300.00 | 50 | 6 | 1188 | 433 | 2.74364896073903 | 0.0822768722546971 | 0.0822768722546971 | false | false | false | true | ||||||||||||||||
| 00260082-7075-4d76-ba0f-e0a939aaefb7 | 2026-09-18 15:39 | 2026-09-18 15:38 | 2026-09-18 15:38 | SPXW | SPXW260922C07640000 | call | 7640.0000 | 2026-09-22 | 26.9000 | 26.8000 | 27.1000 | 7640.7700 | 134500.00 | 0.00 | 134500.00 | 50 | 6 | 2297 | 433 | 5.30484988452656 | 0.0777378427346111 | 0.0777378427346111 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:40:42.153741Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |