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_alerts474,253 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 |
|---|
| 0e228e43-77b6-4767-b0f4-dbb2336e3c44 | 2026-09-25 15:53 | 2026-09-25 15:53 | 2026-09-25 15:53 | DKNG | DKNG261002C00022000 | call | 22.0000 | 2026-10-02 | 0.5500 | 0.4600 | 0.6000 | 21.7450 | 97106.00 | 87133.00 | 9859.00 | 1753 | 48 | 3271 | 2449 | 1.33564720293998 | 0.565514563536013 | 0.548382355472529 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 10931918137.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:54:56.567521Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| d7a94790-14a2-4ba8-b809-681aefa826fc | 2026-09-25 15:53 | 2026-09-25 15:53 | 2026-09-25 15:53 | DKNG | DKNG270617C00030000 | call | 30.0000 | 2027-06-17 | 2.1300 | 2.1300 | 2.1600 | 21.7050 | 66459.00 | 429.00 | 66030.00 | 312 | 6 | 380 | 8592 | 0.0442271880819367 | 0.584740108483033 | 0.587605095064076 | false | false | false | |||||||||||||||||
| e49ad69e-da0f-4077-bfc9-11d0e8942ac1 | 2026-09-25 15:41 | 2026-09-25 15:41 | 2026-09-25 15:41 | DKNG | DKNG260925P00022000 | put | 22.0000 | 2026-09-25 | 0.5500 | 0.5200 | 0.5500 | 21.0000 | 25221.00 | 24805.00 | 416.00 | 459 | 11 | 1292 | 2210 | 0.584615384615385 | 0 | 0 | false | false | false | |||||||||||||||||
| 48c91a50-37d1-415e-9b47-e4c0905a0163 | 2026-09-18 10:07 | 2026-09-18 10:07 | 2026-09-18 10:07 | DKNG | DKNG261120C00030000 | call | 30.0000 | 2026-11-20 | 0.3700 | 0.3700 | 0.4000 | 22.2050 | 13595.00 | 2063.00 | 11266.00 | 363 | 26 | 706 | 107156 | 0.00658852514091605 | 0.599891145532194 | 0.602895164846833 | false | false | false | |||||||||||||||||
| 530c1f00-a3e9-4cd1-bc9b-344ac37701b6 | 2026-09-17 15:56 | 2026-09-17 15:56 | 2026-09-17 15:56 | DKNG | DKNG261218P00023000 | put | 23.0000 | 2026-12-18 | 2.7100 | 2.5700 | 2.9000 | 22.0000 | 54422.00 | 6751.00 | 47671.00 | 201 | 5 | 398 | 6221 | 0.0639768525960457 | 0.57363919775038 | 0.580325318242006 | true | false | false | |||||||||||||||||
| 64618d46-9afe-4d59-9e67-8b6156823b36 | 2026-09-14 09:45 | 2026-09-14 09:45 | 2026-09-14 09:45 | DKNG | DKNG261120C00030000 | call | 30.0000 | 2026-11-20 | 0.7700 | 0.7500 | 0.9000 | 23.0000 | 33319.00 | 11528.00 | 21791.00 | 431 | 43 | 592 | 105835 | 0.00559361269901261 | 0.599120105300771 | 0.612088388134497 | false | false | false | |||||||||||||||||
| 34984919-8670-4326-aa5e-e5d7aca5ee01 | 2026-09-11 09:43 | 2026-09-11 09:43 | 2026-09-11 09:43 | DKNG | DKNG260918C00025000 | call | 25.0000 | 2026-09-18 | 0.2800 | 0.2100 | 0.2800 | 23.5650 | 137935.00 | 137911.00 | 24.00 | 5000 | 9 | 5474 | 12672 | 0.43197601010101 | 0.554431922275118 | 0.554431922275118 | false | false | false | |||||||||||||||||
| 92176d45-84d1-493e-8a62-a41e20a884d3 | 2026-09-10 09:50 | 2026-09-10 09:49 | 2026-09-10 09:49 | DKNG | DKNG260925C00025000 | call | 25.0000 | 2026-09-25 | 0.5000 | 0.5000 | 0.7000 | 23.6000 | 30104.00 | 0.00 | 30104.00 | 600 | 23 | 601 | 462 | 1.3008658008658 | 0.517969665354918 | 0.554347419812529 | false | false | false | |||||||||||||||||
| 85f2a8db-09d1-4643-82e5-6a55069aaf61 | 2026-09-04 14:33 | 2026-09-04 14:33 | 2026-09-04 14:33 | DKNG | DKNG260911C00025000 | call | 25.0000 | 2026-09-11 | 0.2700 | 0.2300 | 0.2800 | 24.0250 | 15823.00 | 15823.00 | 0.00 | 581 | 9 | 2369 | 1916 | 1.23643006263048 | 0.470949877534846 | 0.479764062237362 | false | false | false | |||||||||||||||||
| cc7a44ad-1ef0-483e-9ce7-01bb15a56435 | 2026-09-03 15:50 | 2026-09-03 15:50 | 2026-09-03 15:50 | DKNG | DKNG261120P00022500 | put | 22.5000 | 2026-11-20 | 1.5800 | 1.4900 | 1.5800 | 24.2650 | 13269.00 | 12955.00 | 314.00 | 84 | 20 | 162 | 1558 | 0.10397946084724 | 0.564792403105777 | 0.567264785857186 | false | false | false | |||||||||||||||||
| 4e6b0a91-08ac-4efd-a3db-791d89642ed3 | 2026-08-28 14:19 | 2026-08-28 14:19 | 2026-08-28 14:19 | DKNG | DKNG260918C00027500 | call | 27.5000 | 2026-09-18 | 0.9500 | 0.9000 | 0.9600 | 26.5101 | 34940.00 | 10905.00 | 24035.00 | 369 | 5 | 1525 | 9194 | 0.165869045029367 | 0.525091141132931 | 0.529120513557884 | false | false | false | |||||||||||||||||
| 60a28836-52a5-437d-be4d-5fe3810fe7c8 | 2026-08-28 11:44 | 2026-08-28 11:44 | 2026-08-28 11:44 | DKNG | DKNG261120C00040000 | call | 40.0000 | 2026-11-20 | 0.1400 | 0.0500 | 0.1600 | 24.0000 | 14505.00 | 6060.00 | 345.00 | 1015 | 31 | 3965 | 5642 | 0.702764976958525 | 0.574355169395009 | 0.590023701900212 | true | false | false | |||||||||||||||||
| 2683b6fb-82dc-44ed-9b7e-cb27a37fd973 | 2026-08-28 11:42 | 2026-08-28 11:42 | 2026-08-28 11:42 | DKNG | DKNG261120P00020000 | put | 20.0000 | 2026-11-20 | 0.7400 | 0.7000 | 0.7400 | 24.0000 | 48247.00 | 48247.00 | 0.00 | 652 | 36 | 1465 | 4365 | 0.335624284077892 | 0.552136437871891 | 0.555365886337507 | false | false | false | |||||||||||||||||
| c1b138be-c5a1-4b3d-804f-78edafa7fd2f | 2026-08-27 14:10 | 2026-08-27 14:09 | 2026-08-27 14:09 | DKNG | DKNG261120P00020000 | put | 20.0000 | 2026-11-20 | 0.7300 | 0.7200 | 0.7900 | 24.2950 | 16326.00 | 0.00 | 16326.00 | 225 | 7 | 522 | 3669 | 0.14227309893704 | 0.544109221118068 | 0.553731984190529 | false | false | false | |||||||||||||||||
| dd70c2d0-f53a-4d08-a9b5-44b3129f0107 | 2026-08-20 11:59 | 2026-08-20 11:58 | 2026-08-20 11:58 | DKNG | DKNG260828P00023500 | put | 23.5000 | 2026-08-28 | 0.2700 | 0.2400 | 0.2800 | 24.6700 | 16271.00 | 16271.00 | 0.00 | 599 | 32 | 616 | 1124 | 0.548042704626335 | 0.501111050583565 | 0.509865656324359 | false | false | false | |||||||||||||||||
| 16b9af60-d509-42e4-ac16-52c6bfc1360f | 2026-08-19 10:34 | 2026-08-19 10:34 | 2026-08-19 10:34 | DKNG | DKNG260918C00025000 | call | 25.0000 | 2026-09-18 | 1.2300 | 1.1900 | 1.2300 | 24.6000 | 22251.00 | 21525.00 | 726.00 | 181 | 16 | 349 | 11891 | 0.0293499285173661 | 0.482438580443408 | 0.489548975839608 | true | false | false | |||||||||||||||||
| 41ef8bce-792e-4abd-bd06-134d6a250912 | 2026-08-17 15:35 | 2026-08-17 15:35 | 2026-08-17 15:35 | DKNG | DKNG260918C00025000 | call | 25.0000 | 2026-09-18 | 1.6700 | 1.6100 | 1.6700 | 25.3650 | 28886.00 | 28886.00 | 0.00 | 173 | 12 | 1383 | 10623 | 0.130189212086981 | 0.480122930379921 | 0.483525427523286 | false | false | false | |||||||||||||||||
| a642e725-3ba0-46c4-bfe6-89bdfd3336e7 | 2026-08-17 10:21 | 2026-08-17 10:21 | 2026-08-17 10:21 | DKNG | DKNG260918P00027500 | put | 27.5000 | 2026-09-18 | 2.3100 | 2.2800 | 2.3400 | 25.9850 | 27729.00 | 26564.00 | 1165.00 | 120 | 21 | 539 | 969 | 0.5562435500516 | 0.470062101596312 | 0.480312740445173 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10931918137.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:54:56.567521Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10931918137.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 10797875544.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 11155322459.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:52:43.061304Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:52:06.240394Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:52:06.240394Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 12336883093.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |