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 |
|---|
| 97641c3e-776b-498f-95bb-60b471805101 | 2026-09-29 13:10 | 2026-09-29 13:09 | 2026-09-29 13:09 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 23.3500 | 23.3500 | 23.6500 | 352.0950 | 14010.00 | 0.00 | 14010.00 | 6 | 6 | 2013 | 11273 | 0.178568260445312 | 0.447510016873019 | 0.447510016873019 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1393558302499.00 | 2026-10-28 | unknown | — | 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 |
| 3b15815a-f671-471f-9bff-4a89772780ce | 2026-09-29 12:53 | 2026-09-29 12:53 | 2026-09-29 12:53 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 23.3500 | 23.3500 | 23.7000 | 352.0500 | 14010.00 | 0.00 | 14010.00 | 6 | 6 | 2001 | 11273 | 0.177503770070079 | 0.447392818636841 | 0.447392818636841 | false | false | false | true | false | |||||||||||||||
| c7918fe6-0908-4a59-ba1d-f74cfb4c9302 | 2026-09-29 10:54 | 2026-09-29 10:54 | 2026-09-29 10:54 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 22.8500 | 22.8500 | 22.9500 | 355.1450 | 57125.00 | 0.00 | 57125.00 | 25 | 8 | 838 | 11273 | 0.0743369112037612 | 0.449940177076136 | 0.44997843050258 | false | false | false | true | false | |||||||||||||||
| e874c286-b04a-48f2-bc04-f1a8e308903c | 2026-09-29 10:54 | 2026-09-29 10:54 | 2026-09-29 10:54 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 22.9000 | 22.9000 | 22.9500 | 355.0000 | 59540.00 | 0.00 | 59540.00 | 26 | 10 | 761 | 11273 | 0.067506431296017 | 0.450047012644776 | 0.450149143019404 | false | false | false | true | ||||||||||||||||
| 977460d2-0127-44c9-adb9-0b774d48a3ef | 2026-09-29 10:53 | 2026-09-29 10:53 | 2026-09-29 10:53 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 22.9500 | 22.9500 | 23.0000 | 354.6941 | 91800.00 | 0.00 | 91800.00 | 40 | 5 | 612 | 11273 | 0.0542890091368757 | 0.44990777105281 | 0.44990777105281 | false | false | false | true | false | |||||||||||||||
| d8876184-441a-4907-a175-a718b24b1de5 | 2026-09-29 09:51 | 2026-09-29 09:51 | 2026-09-29 09:51 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 23.7200 | 23.7000 | 23.8000 | 352.3800 | 346290.00 | 0.00 | 346290.00 | 146 | 6 | 249 | 11273 | 0.0220881752860818 | 0.451933530995377 | 0.452011384702808 | false | false | false | true | ||||||||||||||||
| 521e2329-0416-4b05-b70b-6a66df6780ed | 2026-09-28 11:36 | 2026-09-28 11:36 | 2026-09-28 11:36 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 22.3000 | 21.7500 | 22.3000 | 360.0400 | 111500.00 | 111500.00 | 0.00 | 50 | 5 | 93 | 11267 | 0.00825419366290938 | 0.4548294673624 | 0.4548294673624 | false | false | false | true | false | |||||||||||||||
| 7bf8a2c2-0ed6-4742-ac67-3aeba356e877 | 2026-09-24 12:33 | 2026-09-24 12:33 | 2026-09-24 12:33 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 18.9000 | 18.9000 | 19.0000 | 379.5600 | 66150.00 | 0.00 | 66150.00 | 35 | 5 | 823 | 11252 | 0.0731425524351226 | 0.459053700824784 | 0.459053700824784 | false | false | false | true | ||||||||||||||||
| 4ce200e3-2143-4503-8739-571df58cabf8 | 2026-09-24 12:33 | 2026-09-24 12:33 | 2026-09-24 12:33 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 18.9000 | 18.9000 | 19.0000 | 379.5400 | 66150.00 | 0.00 | 66150.00 | 35 | 5 | 743 | 11252 | 0.0660327052968361 | 0.459010524382162 | 0.459010524382162 | false | false | false | true | ||||||||||||||||
| 5e08f1d5-2de2-45a7-946b-cf8f2552d094 | 2026-09-24 12:33 | 2026-09-24 12:33 | 2026-09-24 12:33 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 18.9000 | 18.9000 | 19.0000 | 379.6100 | 100170.00 | 0.00 | 100170.00 | 53 | 11 | 670 | 11252 | 0.0595449697831497 | 0.458945751506854 | 0.459161622778811 | false | false | false | true | ||||||||||||||||
| 27f4753d-77e4-4559-ab1a-e7b3672beed1 | 2026-09-24 12:33 | 2026-09-24 12:32 | 2026-09-24 12:32 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 18.9000 | 18.9000 | 19.0000 | 379.6200 | 58590.00 | 0.00 | 58590.00 | 31 | 5 | 561 | 11252 | 0.0498578030572343 | 0.458859372339918 | 0.459183203887333 | false | false | false | true | ||||||||||||||||
| d8dcbc5c-3a9b-4aac-bc26-4fb7e59abf33 | 2026-09-24 12:32 | 2026-09-24 12:32 | 2026-09-24 12:32 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 18.9000 | 18.9000 | 19.0000 | 379.6600 | 32130.00 | 0.00 | 32130.00 | 17 | 5 | 360 | 11252 | 0.0319943121222894 | 0.459269517384669 | 0.459269517384669 | false | false | false | true | ||||||||||||||||
| 1ccfc10d-e8ae-4abb-9515-6daae2baa961 | 2026-09-23 13:38 | 2026-09-23 13:37 | 2026-09-23 13:37 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 19.4000 | 19.4000 | 19.6500 | 378.9100 | 81480.00 | 0.00 | 81480.00 | 42 | 5 | 2756 | 11126 | 0.247708071184613 | 0.462126818276964 | 0.462126818276964 | false | false | false | true | ||||||||||||||||
| 73807b33-e77c-4ecf-b0b1-78c1f9a1f312 | 2026-09-23 13:34 | 2026-09-23 13:34 | 2026-09-23 13:34 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 19.4500 | 19.4500 | 19.6500 | 378.6899 | 68075.00 | 0.00 | 68075.00 | 35 | 5 | 2683 | 11126 | 0.241146863203308 | 0.462213615230686 | 0.462213615230686 | false | false | false | true | ||||||||||||||||
| a4bf7388-2703-465a-ae41-abfcda686149 | 2026-09-23 11:30 | 2026-09-23 11:30 | 2026-09-23 11:30 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 19.2000 | 19.2000 | 19.3000 | 380.0000 | 30720.00 | 0.00 | 30720.00 | 16 | 5 | 1810 | 11126 | 0.16268200611181 | 0.46341222023248 | 0.46341222023248 | false | false | false | true | false | |||||||||||||||
| e24d69e3-1d2c-48dd-9ea1-16d1b33aaa69 | 2026-09-23 10:48 | 2026-09-23 10:48 | 2026-09-23 10:48 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 19.4500 | 19.4500 | 19.5000 | 379.4300 | 17505.00 | 0.00 | 17505.00 | 9 | 5 | 845 | 11126 | 0.0759482293726407 | 0.463818492187504 | 0.463818492187504 | false | false | false | true | ||||||||||||||||
| b4c34c4c-3675-402b-8762-494548e2a7c9 | 2026-09-23 10:46 | 2026-09-23 10:46 | 2026-09-23 10:46 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 19.5000 | 19.5000 | 19.6000 | 379.3400 | 58500.00 | 0.00 | 58500.00 | 30 | 8 | 809 | 11126 | 0.072712565162682 | 0.464188373089193 | 0.464188373089193 | false | false | false | true | ||||||||||||||||
| bafdc6fe-28f7-4d79-8523-fd07d8f8a51f | 2026-09-23 10:37 | 2026-09-23 10:37 | 2026-09-23 10:37 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 19.5000 | 19.5000 | 19.5500 | 379.5300 | 21450.00 | 0.00 | 21450.00 | 11 | 5 | 586 | 11126 | 0.0526694229732159 | 0.464599726449944 | 0.464599726449944 | false | false | false | true | ||||||||||||||||
| 30813ddf-33e1-41c0-be49-80fdd98b3ddc | 2026-09-15 13:03 | 2026-09-15 13:03 | 2026-09-15 13:03 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 24.6500 | 24.3500 | 24.7000 | 359.2700 | 157760.00 | 51765.00 | 105995.00 | 64 | 6 | 241 | 11125 | 0.0216629213483146 | 0.46756948515914 | 0.46756948515914 | false | false | false | true | ||||||||||||||||
| 165af83d-d428-4e72-b2d3-45c7fe5407de | 2026-09-08 11:00 | 2026-09-08 11:00 | 2026-09-08 11:00 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 24.2000 | 24.0000 | 24.2000 | 365.2900 | 113740.00 | 113740.00 | 0.00 | 47 | 5 | 72 | 11074 | 0.00650171573054 | 0.470107201653662 | 0.470200410914697 | false | false | false | true | ||||||||||||||||
| 0d0b8844-f108-4d6b-9512-99ea52af4453 | 2026-08-27 12:29 | 2026-08-27 12:29 | 2026-08-27 12:29 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 28.4000 | 28.2500 | 28.6500 | 352.7500 | 142000.00 | 127800.00 | 14200.00 | 50 | 5 | 81 | 10605 | 0.00763790664780764 | 0.47332085727879 | 0.47332085727879 | false | false | false | true | ||||||||||||||||
| ab5ff0c9-64d0-47e4-9ed8-71fc6582ea3a | 2026-08-17 13:21 | 2026-08-17 13:21 | 2026-08-17 13:21 | TSLA | TSLA270617P00300000 | put | 300.0000 | 2027-06-17 | 32.5600 | 32.2500 | 32.6000 | 339.6850 | 130224.00 | 130224.00 | 0.00 | 40 | 10 | 58 | 10608 | 0.00546757164404223 | 0.473274893646434 | 0.472892127686732 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1393558302499.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:54:42.907148Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1393558302499.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:54:53.700318Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1393558302499.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:54:53.700318Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1393558302499.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:54:53.700318Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1393558302499.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:54:00.139875Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1411765715985.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:37:38.003662Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:36:42.025876Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:36:42.025876Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:36:42.025876Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:36:42.025876Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:39:01.188751Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:39:01.188751Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:31:00.015856Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:51:34.694161Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:47:19.358930Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:39:41.777134Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1417769028024.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1417769028024.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1417769028024.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1417769028024.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |