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_alerts326,449 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 | price |
|---|
| 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 |
|---|
| 0cc2465c-8a02-4ef2-a09a-b101ae1a389f | 2026-08-21 09:43 | 2026-08-21 09:43 | 2026-08-21 09:43 | BX | BX281215C00150000 | call | 150.0000 | 2028-12-15 | 30.5000 | 27.1000 | 30.5000 | 143.8700 | 109800.00 | 109800.00 | 0.00 | 36 | 5 | 36 | 706 | 0.0509915014164306 | 0.313770162861777 | 0.313770162861777 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 96297695875.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 49455e41-a9fe-470c-87c3-d9f43d130a67 | 2026-08-20 15:42 | 2026-08-20 15:42 | 2026-08-20 15:42 | BX | BX281215C00150000 | call | 150.0000 | 2028-12-15 | 28.5000 | 27.5000 | 28.5000 | 141.3385 | 165300.00 | 165300.00 | 0.00 | 58 | 6 | 60 | 656 | 0.0914634146341463 | 0.308599966828456 | 0.308599966828456 | false | false | false | true | false | |||||||||||||||
| 6c35a49e-5adb-4350-9adb-37c31436016c | 2026-08-20 15:39 | 2026-08-20 15:39 | 2026-08-20 15:39 | BX | BX260918P00140000 | put | 140.0000 | 2026-09-18 | 4.8500 | 4.8500 | 4.9000 | 141.3950 | 70810.00 | 0.00 | 70810.00 | 146 | 6 | 3480 | 2480 | 1.40322580645161 | 0.361668247574355 | 0.361668247574355 | true | false | false | true | false | |||||||||||||||
| 8af0a34e-9452-42f6-ab8c-44d0b76eeec3 | 2026-08-20 15:39 | 2026-08-20 15:39 | 2026-08-20 15:39 | BX | BX260918P00140000 | put | 140.0000 | 2026-09-18 | 4.8000 | 4.6500 | 4.8500 | 141.4800 | 63838.00 | 63358.00 | 480.00 | 133 | 42 | 3286 | 2480 | 1.325 | 0.360799541028593 | 0.360799541028593 | false | false | false | true | false | |||||||||||||||
| 324c923f-886e-4b38-a4d1-395a2d1eefdc | 2026-08-20 14:24 | 2026-08-20 14:24 | 2026-08-20 14:24 | BX | BX260918P00140000 | put | 140.0000 | 2026-09-18 | 4.2900 | 4.1500 | 4.3000 | 142.8100 | 214681.00 | 214681.00 | 0.00 | 500 | 52 | 2957 | 2480 | 1.19233870967742 | 0.359776680066701 | 0.363657147293981 | false | false | false | true | false | |||||||||||||||
| 76a84e33-1ecc-492d-814f-e33ac4a9606b | 2026-08-20 12:31 | 2026-08-20 12:31 | 2026-08-20 12:31 | BX | BX260911P00140000 | put | 140.0000 | 2026-09-11 | 3.6500 | 3.6000 | 3.6500 | 142.2500 | 67160.00 | 67160.00 | 0.00 | 184 | 31 | 184 | 32 | 5.75 | 0.349625534160048 | 0.349625534160048 | false | false | false | true | false | |||||||||||||||
| 36c6cacf-bd62-4b86-b257-bf35268b29a9 | 2026-08-20 12:31 | 2026-08-20 12:31 | 2026-08-20 12:31 | BX | BX260911P00137000 | put | 137.0000 | 2026-09-11 | 2.5200 | 2.5200 | 2.5300 | 142.2500 | 215996.00 | 3812.00 | 12600.00 | 857 | 21 | 857 | 10 | 85.7 | 0.352907449378749 | 0.351277098122802 | true | false | false | true | false | |||||||||||||||
| 535e8a69-9673-42a5-871e-fdbfa1e84a83 | 2026-08-20 12:13 | 2026-08-20 12:13 | 2026-08-20 12:13 | BX | BX260918P00140000 | put | 140.0000 | 2026-09-18 | 4.2000 | 4.2000 | 4.3000 | 142.7400 | 78540.00 | 0.00 | 78540.00 | 187 | 12 | 1676 | 2480 | 0.675806451612903 | 0.355415748218995 | 0.355415748218995 | false | false | false | true | false | |||||||||||||||
| 9cfdbf6f-ebcf-4daf-8443-c79a0bbaf516 | 2026-08-20 12:11 | 2026-08-20 12:11 | 2026-08-20 12:11 | BX | BX260918P00140000 | put | 140.0000 | 2026-09-18 | 4.2000 | 4.2000 | 4.3000 | 142.6601 | 82740.00 | 0.00 | 82740.00 | 197 | 8 | 1447 | 2480 | 0.583467741935484 | 0.353384938744285 | 0.353384938744285 | false | false | false | true | false | |||||||||||||||
| dfb9064a-b462-4df1-abf2-815838dcce8e | 2026-08-20 12:11 | 2026-08-20 12:11 | 2026-08-20 12:11 | BX | BX260918P00140000 | put | 140.0000 | 2026-09-18 | 4.2000 | 4.2000 | 4.3000 | 142.6601 | 54600.00 | 0.00 | 54600.00 | 130 | 6 | 1250 | 2480 | 0.504032258064516 | 0.353384938744285 | 0.353384938744285 | false | false | false | true | false | |||||||||||||||
| d44d7be3-70a7-41da-afcc-8f91898e5901 | 2026-08-20 11:49 | 2026-08-20 11:49 | 2026-08-20 11:49 | BX | BX261120P00140000 | put | 140.0000 | 2026-11-20 | 9.0000 | 9.0000 | 9.5000 | 142.4800 | 100800.00 | 0.00 | 100800.00 | 112 | 24 | 116 | 916 | 0.126637554585153 | 0.38470063046992 | 0.38470063046992 | false | false | false | true | false | |||||||||||||||
| 8c622f50-2e7a-40e8-997d-22206e0417ab | 2026-08-20 10:04 | 2026-08-20 10:04 | 2026-08-20 10:04 | BX | BX260821C00132000 | call | 132.0000 | 2026-08-21 | 10.2000 | 9.8500 | 12.3000 | 142.1100 | 55080.00 | 0.00 | 55080.00 | 54 | 22 | 54 | 207 | 0.260869565217391 | 0.777416977927111 | 0.777416977927111 | true | false | false | true | false | |||||||||||||||
| 16fcef35-8ff4-465c-afa8-3788f2c6e98a | 2026-08-19 13:48 | 2026-08-19 13:48 | 2026-08-19 13:48 | BX | BX280121P00160000 | put | 160.0000 | 2028-01-21 | 32.5000 | 32.1250 | 32.6000 | 144.7600 | 325000.00 | 35750.00 | 0.00 | 100 | 20 | 100 | 645 | 0.155038759689922 | 0.422671617790047 | 0.422671617790047 | false | false | false | true | false | |||||||||||||||
| ffa8f3ff-82bf-400d-a49b-283882e30ac3 | 2026-08-19 11:34 | 2026-08-19 11:34 | 2026-08-19 11:34 | BX | BX261218C00155000 | call | 155.0000 | 2026-12-18 | 8.8500 | 8.8000 | 8.9000 | 146.6000 | 65495.00 | 57530.00 | 3540.00 | 74 | 31 | 324 | 1349 | 0.240177909562639 | 0.342464818133302 | 0.34266811662161 | false | false | false | true | false | |||||||||||||||
| 82f2d824-4c25-440b-bf99-6a9199f4e204 | 2026-08-19 10:00 | 2026-08-19 10:00 | 2026-08-19 10:00 | BX | BX281215C00165000 | call | 165.0000 | 2028-12-15 | 25.5500 | 25.3500 | 25.5500 | 144.9800 | 155844.00 | 153299.00 | 2545.00 | 61 | 11 | 174 | 369 | 0.471544715447154 | 0.313398920143355 | 0.313513979755614 | false | false | false | true | false | |||||||||||||||
| e6dc31bf-9d55-4956-a907-372b648d7474 | 2026-08-19 10:00 | 2026-08-19 10:00 | 2026-08-19 10:00 | BX | BX281215C00165000 | call | 165.0000 | 2028-12-15 | 25.4000 | 22.8500 | 25.4000 | 144.6600 | 157480.00 | 157480.00 | 0.00 | 62 | 12 | 62 | 369 | 0.168021680216802 | 0.313878187082663 | 0.313878187082663 | false | false | false | true | false | |||||||||||||||
| 882ba73e-3f98-4860-bf41-92b97e10bbd5 | 2026-08-19 09:35 | 2026-08-19 09:35 | 2026-08-19 09:35 | BX | BX260918C00145000 | call | 145.0000 | 2026-09-18 | 5.6000 | 4.6000 | 5.7000 | 143.7700 | 50400.00 | 50400.00 | 0.00 | 90 | 20 | 96 | 3122 | 0.0307495195387572 | 0.362973196334443 | 0.362973196334443 | false | false | false | true | false | |||||||||||||||
| 047412ee-ef89-458d-8569-4c3ceff8fe51 | 2026-08-18 15:20 | 2026-08-18 15:20 | 2026-08-18 15:20 | BX | BX281215C00145000 | call | 145.0000 | 2028-12-15 | 30.2000 | 28.0000 | 30.2000 | 141.2900 | 57380.00 | 57380.00 | 0.00 | 19 | 10 | 43 | 813 | 0.0528905289052891 | 0.30402539181342 | 0.30402539181342 | false | false | false | true | false | |||||||||||||||
| a5cca6af-ea8d-43bf-a7c2-602d828b21fa | 2026-08-18 11:22 | 2026-08-18 11:22 | 2026-08-18 11:22 | BX | BX260828P00133000 | put | 133.0000 | 2026-08-28 | 0.9300 | 0.6000 | 0.9300 | 140.0150 | 63612.00 | 63612.00 | 0.00 | 684 | 48 | 685 | 160 | 4.28125 | 0.37350198984712 | 0.37350198984712 | false | false | false | true | false | |||||||||||||||
| 354f5616-16af-4b4c-8e71-cd69182e747a | 2026-08-17 15:16 | 2026-08-17 15:16 | 2026-08-17 15:16 | BX | BX271217C00150000 | call | 150.0000 | 2027-12-17 | 20.0000 | 19.9500 | 20.0000 | 140.4100 | 160000.00 | 160000.00 | 0.00 | 80 | 5 | 602 | 109 | 5.52293577981651 | 0.320988510661464 | 0.320504628036499 | false | false | false | true | false | |||||||||||||||
| ec455f9d-e361-47d7-ab3e-103e84894bb6 | 2026-08-17 14:46 | 2026-08-17 14:46 | 2026-08-17 14:46 | BX | BX270617C00125000 | call | 125.0000 | 2027-06-17 | 26.9700 | 26.3000 | 28.6500 | 139.5550 | 1726297.00 | 755952.00 | 970345.00 | 640 | 45 | 646 | 934 | 0.691648822269807 | 0.339084071014399 | 0.339084071014399 | true | false | false | true | false | |||||||||||||||
| 00419351-5027-4ccc-830e-e235bde5159d | 2026-08-17 13:39 | 2026-08-17 13:39 | 2026-08-17 13:39 | BX | BX260918P00140000 | put | 140.0000 | 2026-09-18 | 5.0000 | 5.0000 | 5.0500 | 140.7700 | 50000.00 | 0.00 | 50000.00 | 100 | 7 | 652 | 1870 | 0.348663101604278 | 0.338204206235879 | 0.338204206235879 | false | false | false | true | false | |||||||||||||||
| d0cc7dbd-9338-4982-843b-e07830d9c0f8 | 2026-08-17 09:31 | 2026-08-17 09:31 | 2026-08-17 09:31 | BX | BX261016P00130000 | put | 130.0000 | 2026-10-16 | 3.2000 | 3.2000 | 3.3500 | 141.4100 | 64000.00 | 0.00 | 64000.00 | 200 | 8 | 200 | 804 | 0.248756218905473 | 0.358903182878025 | 0.358903182878025 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 96297695875.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |