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 |
|---|
| expirydate |
|---|
| 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 |
|---|
| a1ecf72d-a34d-4a63-ac86-544a38d3991e | 2026-08-19 11:47 | 2026-08-19 11:47 | 2026-08-19 11:47 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 3.4000 | 3.3000 | 3.5000 | 28.0200 | 81260.00 | 78880.00 | 2380.00 | 239 | 27 | 429 | 1509 | 0.284294234592445 | 0.930032908969285 | 0.927190661617908 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7164310773.00 | 2026-10-08 | 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 |
| c8ee0303-b9ff-466e-85aa-98ee21b04e1c | 2026-08-20 10:25 | 2026-08-20 10:25 | 2026-08-20 10:25 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 3.7000 | 3.6500 | 3.8500 | 28.5850 | 15540.00 | 14800.00 | 740.00 | 42 | 7 | 87 | 1760 | 0.0494318181818182 | 0.937302014612823 | 0.937302014612823 | false | false | false | |||||||||||||||||
| 776d5622-334a-41ba-81f7-20586944cfcd | 2026-08-26 14:39 | 2026-08-26 14:39 | 2026-08-26 14:39 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 2.7500 | 2.7000 | 2.7500 | 27.2550 | 29966.00 | 29966.00 | 0.00 | 109 | 14 | 286 | 2502 | 0.114308553157474 | 0.923076770711918 | 0.923076770711918 | true | false | false | |||||||||||||||||
| 9532a2f9-fc67-4c0f-9de7-c99c02f43b2f | 2026-08-26 15:01 | 2026-08-26 15:01 | 2026-08-26 15:01 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 2.6800 | 2.6200 | 2.6800 | 27.0750 | 26800.00 | 26800.00 | 0.00 | 100 | 16 | 409 | 2502 | 0.163469224620304 | 0.926277261974918 | 0.926277261974918 | true | false | false | |||||||||||||||||
| d32e97c1-4a22-43ad-8efb-a3a017d3d5b8 | 2026-08-26 15:55 | 2026-08-26 15:55 | 2026-08-26 15:55 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 2.5000 | 2.3900 | 2.6500 | 26.9150 | 13020.00 | 260.00 | 10260.00 | 52 | 11 | 525 | 2502 | 0.209832134292566 | 0.921591388167979 | 0.899281821997349 | true | false | false | |||||||||||||||||
| eb2a18c0-ee11-4e41-b103-8fe8af96351c | 2026-09-01 09:30 | 2026-09-01 09:30 | 2026-09-01 09:30 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.4500 | 1.2400 | 1.6300 | 24.7850 | 15950.00 | 15950.00 | 0.00 | 110 | 5 | 120 | 3801 | 0.0315706393054459 | 0.894960100253736 | 0.894960100253736 | false | false | false | |||||||||||||||||
| 01475cc0-b9f6-46bb-9d62-7b43a0c53b3d | 2026-09-03 15:58 | 2026-09-03 15:58 | 2026-09-03 15:58 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.6500 | 1.5500 | 1.6700 | 25.8450 | 73299.00 | 73136.00 | 163.00 | 445 | 27 | 1195 | 4279 | 0.279270857677027 | 0.863107144670101 | 0.857115685526534 | false | false | false | |||||||||||||||||
| 6e4e858a-3b01-43b5-86d9-91d38b0459c9 | 2026-09-03 15:59 | 2026-09-03 15:58 | 2026-09-03 15:58 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.6900 | 1.6800 | 1.7000 | 25.8550 | 17757.00 | 17757.00 | 0.00 | 105 | 9 | 1451 | 4279 | 0.339097920074784 | 0.876940052632417 | 0.873958015824353 | false | false | false | |||||||||||||||||
| 678c6f34-b984-418c-ac69-e4cdee967575 | 2026-09-09 11:34 | 2026-09-09 11:34 | 2026-09-09 11:34 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 2.2300 | 2.2200 | 2.2500 | 27.5100 | 27652.00 | 25199.00 | 2453.00 | 124 | 7 | 614 | 5280 | 0.116287878787879 | 0.903566399381147 | 0.903566399381147 | true | false | false | |||||||||||||||||
| f509ed1f-ddc9-4d2d-9c8f-b3f275694f24 | 2026-09-17 10:58 | 2026-09-17 10:58 | 2026-09-17 10:58 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.2900 | 1.2600 | 1.2900 | 25.9550 | 30831.00 | 30831.00 | 0.00 | 239 | 14 | 1149 | 7233 | 0.158855246785566 | 0.907808543709296 | 0.907808543709296 | false | false | false | |||||||||||||||||
| bedd183c-a4e8-4568-8cef-bd5ba33d2db2 | 2026-09-17 11:21 | 2026-09-17 11:21 | 2026-09-17 11:21 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.1800 | 1.1700 | 1.2000 | 25.5200 | 23482.00 | 0.00 | 17582.00 | 199 | 16 | 2601 | 7233 | 0.359601824968893 | 0.917354917080881 | 0.919819696386664 | false | false | false | |||||||||||||||||
| b64be74c-f614-4500-b184-4fe65b10a533 | 2026-09-17 11:50 | 2026-09-17 11:50 | 2026-09-17 11:50 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.4000 | 1.3800 | 1.4000 | 26.2373 | 11200.00 | 11200.00 | 0.00 | 80 | 9 | 3140 | 7233 | 0.4341213880824 | 0.91262052032615 | 0.91262052032615 | false | false | false | |||||||||||||||||
| 46f9f6eb-6fa9-4447-b834-6cc20e0e9b82 | 2026-09-17 14:12 | 2026-09-17 14:12 | 2026-09-17 14:12 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.5500 | 1.5100 | 1.5500 | 26.6150 | 11780.00 | 11780.00 | 0.00 | 76 | 9 | 5179 | 7233 | 0.716023779897691 | 0.917248294480835 | 0.917248294480835 | false | false | false | |||||||||||||||||
| f844a6b0-f9fa-47a1-9a2d-6ab664fbfc96 | 2026-09-18 14:10 | 2026-09-18 14:10 | 2026-09-18 14:10 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.8400 | 1.8400 | 1.8700 | 27.5850 | 95680.00 | 0.00 | 95680.00 | 520 | 15 | 3189 | 9284 | 0.343494183541577 | 0.900871903136884 | 0.900871903136884 | false | false | false | |||||||||||||||||
| ad5673d1-5d40-4be9-9223-29b0841cfdd8 | 2026-09-21 10:33 | 2026-09-21 10:33 | 2026-09-21 10:33 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.9300 | 1.9100 | 1.9500 | 28.0002 | 13317.00 | 0.00 | 11387.00 | 69 | 8 | 2228 | 7596 | 0.293312269615587 | 0.923558849428805 | 0.923558849428805 | false | false | false | |||||||||||||||||
| fa92425d-8565-4153-93df-4ed95da1bb47 | 2026-09-24 11:41 | 2026-09-24 11:41 | 2026-09-24 11:41 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.2000 | 1.1700 | 1.2000 | 26.3250 | 12000.00 | 12000.00 | 0.00 | 100 | 7 | 522 | 6727 | 0.0775977404489371 | 0.953184471159405 | 0.953184471159405 | false | false | false | |||||||||||||||||
| ceac8d6f-da62-42be-b6bc-6e7fd286fb28 | 2026-09-25 11:57 | 2026-09-25 11:57 | 2026-09-25 11:57 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 1.0900 | 1.0600 | 1.1300 | 26.2900 | 12654.00 | 0.00 | 12654.00 | 116 | 13 | 858 | 6778 | 0.126586013573325 | 0.931910918423336 | 0.937051846017338 | false | false | false | |||||||||||||||||
| 75799b70-9a81-45c1-a82e-ac648ab3cf40 | 2026-09-29 13:14 | 2026-09-29 13:14 | 2026-09-29 13:14 | APLD | APLD261016C00030000 | call | 30.0000 | 2026-10-16 | 0.6800 | 0.6500 | 0.6900 | 25.0350 | 24140.00 | 24140.00 | 0.00 | 355 | 7 | 579 | 6113 | 0.0947161786356944 | 1.00645132440014 | 1.00503131851464 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:11:05.103195Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T19:59:46.397035Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7164310773.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7688955175.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7688955175.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7688955175.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7688955175.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8196111429.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 8216514267.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7936703920.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:45:14.547721Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7651064190.00 |
| 2026-10-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:59:16.361510Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 7406230136.00 |
| 2026-10-07 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:16:24.150546Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |