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_alerts658,639 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 |
|---|
| f96a2bec-770b-4a49-8412-ba1fc8993c2f | 2026-09-04 15:35 | 2026-09-04 15:35 | 2026-09-04 15:35 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 37.4000 | 37.4000 | 37.6000 | 1721.7999 | 52360.00 | 0.00 | 52360.00 | 14 | 5 | 4917 | 1058 | 4.64744801512287 | 0.711429613633974 | 0.711429613633974 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 227240825362.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f5994346-681a-4b3e-8094-2b7ca667e493 | 2026-09-04 15:54 | 2026-09-04 15:53 | 2026-09-04 15:53 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 40.4000 | 40.1000 | 40.8000 | 1730.7633 | 121200.00 | 0.00 | 121200.00 | 30 | 5 | 5340 | 1058 | 5.04725897920605 | 0.709257353553707 | 0.709257353553707 | false | false | false | |||||||||||||||||
| be4b24b2-391c-49ce-b3a0-f1d001e948af | 2026-09-08 09:38 | 2026-09-08 09:38 | 2026-09-08 09:38 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 60.0100 | 58.9000 | 60.6000 | 1789.3100 | 114020.00 | 107990.00 | 6030.00 | 19 | 11 | 487 | 2083 | 0.233797407585214 | 0.987886185734966 | 1.00559997222413 | true | false | false | |||||||||||||||||
| 5e16d8bc-5266-4ada-bae6-6d86a1301456 | 2026-09-08 09:53 | 2026-09-08 09:53 | 2026-09-08 09:53 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 54.7400 | 54.2000 | 55.2000 | 1781.3800 | 197080.00 | 87580.00 | 109500.00 | 36 | 6 | 1063 | 2083 | 0.510321651464234 | 0.978942489905684 | 0.978942489905684 | false | false | false | |||||||||||||||||
| f0d92cde-e307-4f65-ba9c-bf234167cf86 | 2026-09-08 09:55 | 2026-09-08 09:55 | 2026-09-08 09:55 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 50.0000 | 49.5000 | 50.0000 | 1771.9450 | 500000.00 | 500000.00 | 0.00 | 100 | 9 | 1235 | 2083 | 0.592894863178108 | 0.972567787602407 | 0.972567787602407 | false | false | false | |||||||||||||||||
| fe0c05b5-56da-41f6-b25a-45d51bb01dc2 | 2026-09-08 10:55 | 2026-09-08 10:55 | 2026-09-08 10:55 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 51.1000 | 50.4000 | 51.1000 | 1782.9900 | 337260.00 | 337260.00 | 0.00 | 66 | 9 | 2428 | 2083 | 1.16562650024004 | 0.910355160855242 | 0.910355160855242 | true | false | false | |||||||||||||||||
| b067d17c-dc8a-4d33-8b8d-b5a3e175d208 | 2026-09-08 11:18 | 2026-09-08 11:18 | 2026-09-08 11:18 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 54.9400 | 54.7000 | 55.7000 | 1791.1300 | 192290.00 | 16510.00 | 175780.00 | 35 | 7 | 2790 | 2083 | 1.33941430628901 | 0.909854844796657 | 0.906767197376965 | true | false | false | |||||||||||||||||
| 3588e853-7bde-44b0-b02b-b5408bdf30c2 | 2026-09-08 11:23 | 2026-09-08 11:23 | 2026-09-08 11:23 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 54.0900 | 53.3000 | 54.1000 | 1788.8900 | 64912.00 | 64912.00 | 0.00 | 12 | 5 | 3024 | 2083 | 1.45175228036486 | 0.904548820208875 | 0.912946437299835 | false | false | false | |||||||||||||||||
| f5f9129a-59af-41f4-899b-65e1a856939c | 2026-09-08 11:45 | 2026-09-08 11:45 | 2026-09-08 11:45 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 60.0000 | 59.5000 | 60.0000 | 1800.8700 | 234000.00 | 234000.00 | 0.00 | 39 | 6 | 3740 | 2083 | 1.79548727796447 | 0.910776266521092 | 0.910776266521092 | false | false | false | |||||||||||||||||
| 206d6eb8-1229-4bfa-b6bc-2eddd9a03296 | 2026-09-08 11:52 | 2026-09-08 11:52 | 2026-09-08 11:52 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 61.0000 | 60.9000 | 61.2000 | 1801.6600 | 158610.00 | 61010.00 | 24400.00 | 26 | 6 | 4013 | 2083 | 1.92654824771964 | 0.919816150178671 | 0.919816150178671 | false | false | false | |||||||||||||||||
| 5017b933-940c-4408-bd87-303e68edb2db | 2026-09-08 12:03 | 2026-09-08 12:03 | 2026-09-08 12:03 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 60.0100 | 59.7000 | 60.5000 | 1798.8500 | 162040.00 | 6010.00 | 156030.00 | 27 | 8 | 4385 | 2083 | 2.1051368218915 | 0.926857894036444 | 0.923781620147748 | false | false | false | |||||||||||||||||
| 8c5aca8a-699c-4143-8aee-f989576c71a2 | 2026-09-08 12:49 | 2026-09-08 12:49 | 2026-09-08 12:49 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 50.0000 | 50.0000 | 50.4000 | 1782.2700 | 85000.00 | 0.00 | 85000.00 | 17 | 5 | 4851 | 2083 | 2.32885261641863 | 0.89851874010389 | 0.89851874010389 | false | false | false | |||||||||||||||||
| e719efb2-d893-4855-a8c5-3104fdacfb9b | 2026-09-08 13:52 | 2026-09-08 13:52 | 2026-09-08 13:52 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 55.9900 | 55.4000 | 56.2000 | 1790.6500 | 67190.00 | 33610.00 | 33580.00 | 12 | 7 | 5650 | 2083 | 2.71243398943831 | 0.933713360023521 | 0.930499510766492 | true | false | false | |||||||||||||||||
| cca6d0f0-0fa6-439d-a89b-792a3028fdf6 | 2026-09-08 15:39 | 2026-09-08 15:39 | 2026-09-08 15:39 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 38.0000 | 37.9000 | 38.4000 | 1759.8700 | 570000.00 | 566200.00 | 3800.00 | 150 | 5 | 7675 | 2083 | 3.68458953432549 | 0.863390429070056 | 0.863390429070056 | false | false | false | |||||||||||||||||
| 0b6e621e-afaf-4056-924d-2612b8634c8b | 2026-09-09 09:55 | 2026-09-09 09:55 | 2026-09-09 09:55 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 40.8000 | 40.0000 | 41.3000 | 1773.8000 | 85680.00 | 24480.00 | 61200.00 | 21 | 11 | 800 | 2524 | 0.316957210776545 | 0.991204885074051 | 0.999203043995994 | false | false | false | |||||||||||||||||
| 4e95162a-f36f-4f73-8df6-520ae4bf7d3e | 2026-09-09 10:01 | 2026-09-09 10:01 | 2026-09-09 10:01 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 50.0000 | 50.0000 | 50.2000 | 1794.6100 | 60000.00 | 0.00 | 60000.00 | 12 | 8 | 1281 | 2524 | 0.507527733755943 | 0.98888323401755 | 0.98888323401755 | false | false | false | |||||||||||||||||
| 50ca01c9-d06e-41e6-bdf4-f7e936e24d06 | 2026-09-09 10:05 | 2026-09-09 10:05 | 2026-09-09 10:05 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 55.0000 | 54.3000 | 55.0000 | 1805.5371 | 82500.00 | 82500.00 | 0.00 | 15 | 6 | 1708 | 2524 | 0.676703645007924 | 0.976881993649076 | 0.976881993649076 | false | false | false | |||||||||||||||||
| ed8582ed-a8cc-4177-980e-75ed14ac7de9 | 2026-09-09 12:18 | 2026-09-09 12:18 | 2026-09-09 12:18 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 33.0000 | 33.0000 | 33.6000 | 1768.3001 | 59400.00 | 0.00 | 59400.00 | 18 | 12 | 5031 | 2524 | 1.993264659271 | 0.888036724974838 | 0.892532605377301 | true | false | false | |||||||||||||||||
| 639b4d23-487d-4445-afcd-aaf1af153c9d | 2026-09-09 12:25 | 2026-09-09 12:25 | 2026-09-09 12:25 | SNDK | SNDK260911C01800000 | call | 1800.0000 | 2026-09-11 | 35.0000 | 34.9000 | 35.0000 | 1772.6100 | 1050000.00 | 1050000.00 | 0.00 | 300 | 9 | 5381 | 2524 | 2.13193343898574 | 0.896635395930031 | 0.896635395930031 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:00:45.446709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:11:22.686371Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:11:22.686371Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 227240825362.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:45:40.179334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |