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 | 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 |
|---|
| 4bfae61f-3beb-4498-b385-01e3f846b27c | 2026-09-18 11:51 | 2026-09-18 11:50 | 2026-09-18 11:50 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 9.2000 | 8.8000 | 9.4000 | 910.5392 | 126960.00 | 126960.00 | 0.00 | 138 | 13 | 2705 | 803 | 3.36861768368618 | 0.726055406910714 | 0.726055406910714 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 83502627000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 127c2a9f-9707-4374-9de1-7aa1d776acf9 | 2026-09-18 12:08 | 2026-09-18 12:07 | 2026-09-18 12:07 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 9.5000 | 9.4000 | 9.9000 | 914.0000 | 190950.00 | 121600.00 | 65550.00 | 201 | 46 | 3122 | 803 | 3.8879202988792 | 0.714670557428629 | 0.714670557428629 | false | false | false | |||||||||||||||||
| b00e7d7d-58de-4d29-a51b-c16e525c94f2 | 2026-09-18 12:53 | 2026-09-18 12:53 | 2026-09-18 12:53 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 9.0000 | 8.5000 | 9.5000 | 912.5000 | 166500.00 | 163800.00 | 2700.00 | 185 | 32 | 3470 | 803 | 4.32129514321295 | 0.721838681784734 | 0.709338172136242 | true | false | false | |||||||||||||||||
| 0735299b-27bf-41e5-ac14-9ad1d972db29 | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.5000 | 13.2000 | 930.0000 | 226550.00 | 93440.00 | 104950.00 | 177 | 23 | 4430 | 803 | 5.51681195516812 | 0.700605984846798 | 0.700439875550775 | false | false | false | |||||||||||||||||
| 3f5933d7-345c-48f3-a7f7-f7360c67850e | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.6000 | 12.2000 | 13.2000 | 930.0000 | 75600.00 | 3780.00 | 60480.00 | 60 | 6 | 4491 | 803 | 5.59277708592777 | 0.700594092951237 | 0.700594092951237 | false | false | false | |||||||||||||||||
| 232acbed-04df-42ce-97a2-166ef2ba1845 | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.6000 | 12.5000 | 12.6000 | 931.0000 | 317520.00 | 317520.00 | 0.00 | 252 | 5 | 4762 | 803 | 5.93026151930261 | 0.696104112287348 | 0.696104112287348 | false | false | false | |||||||||||||||||
| 061d70f4-72aa-4a1e-89b9-d12c39372aa3 | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.7000 | 12.8000 | 931.0000 | 52480.00 | 52480.00 | 0.00 | 41 | 18 | 4840 | 803 | 6.02739726027397 | 0.699631271808726 | 0.699631271808726 | false | false | false | |||||||||||||||||
| 5c480fcf-bac3-480e-918c-73116fb56b0e | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.7000 | 12.8000 | 931.0000 | 89600.00 | 89600.00 | 0.00 | 70 | 11 | 4936 | 803 | 6.14694894146949 | 0.697589697705384 | 0.697589697705384 | false | false | false | |||||||||||||||||
| 5e6e4051-a517-4b55-9e37-b8eabf1c77cb | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.5000 | 12.8000 | 931.0000 | 136960.00 | 136960.00 | 0.00 | 107 | 8 | 5045 | 803 | 6.2826899128269 | 0.701458665265164 | 0.701458665265164 | false | false | false | |||||||||||||||||
| 9e2cc93f-bc72-4008-8491-a5a4b7defb70 | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.8000 | 12.5000 | 13.0000 | 931.0000 | 225280.00 | 225280.00 | 0.00 | 176 | 6 | 5222 | 803 | 6.50311332503113 | 0.697711612065377 | 0.697711612065377 | false | false | false | |||||||||||||||||
| a61e305f-026a-4a4c-84fa-17ec29a0af31 | 2026-09-18 16:00 | 2026-09-18 15:59 | 2026-09-18 15:59 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 12.2000 | 12.1000 | 12.2000 | 931.0000 | 143960.00 | 143960.00 | 0.00 | 118 | 7 | 6306 | 803 | 7.85305105853051 | 0.684262168564956 | 0.684262168564956 | false | false | false | |||||||||||||||||
| 73210790-ef89-4ac5-9b08-a65c80ac0340 | 2026-09-21 12:34 | 2026-09-21 12:34 | 2026-09-21 12:34 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 19.8000 | 19.3000 | 19.8000 | 967.6350 | 13860.00 | 13860.00 | 0.00 | 7 | 6 | 3076 | 3748 | 0.820704375667022 | 0.812480447750513 | 0.812480447750513 | true | false | false | |||||||||||||||||
| 387e7e33-bcc1-42d1-b6cb-beab63687ce3 | 2026-09-21 12:49 | 2026-09-21 12:49 | 2026-09-21 12:49 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 20.0000 | 20.0000 | 20.7000 | 968.5200 | 14000.00 | 0.00 | 14000.00 | 7 | 6 | 3136 | 3748 | 0.836712913553895 | 0.809170944142545 | 0.809170944142545 | true | false | false | |||||||||||||||||
| 41ce96ca-595a-4524-a017-b41c3bab7d2e | 2026-09-22 09:46 | 2026-09-22 09:46 | 2026-09-22 09:46 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 23.1000 | 22.5000 | 23.1000 | 979.9750 | 11550.00 | 11550.00 | 0.00 | 5 | 5 | 172 | 5346 | 0.0321735877291433 | 0.893828793429292 | 0.893828793429292 | false | false | false | |||||||||||||||||
| 622576ce-5902-4363-8fc5-b89b89d4fdd7 | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 27.9900 | 26.8000 | 28.0000 | 991.2100 | 41980.00 | 41980.00 | 0.00 | 15 | 9 | 339 | 5346 | 0.0634118967452301 | 0.919317436815282 | 0.884983818478162 | false | false | false | |||||||||||||||||
| 407931fa-b587-4827-92db-d446b303039e | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 30.0000 | 28.0000 | 30.5000 | 993.7400 | 36000.00 | 36000.00 | 0.00 | 12 | 10 | 352 | 5346 | 0.065843621399177 | 0.907115189171035 | 0.912415405463434 | false | false | false | |||||||||||||||||
| a77dbcde-aed7-44b3-9609-89892500a3b4 | 2026-09-22 09:58 | 2026-09-22 09:58 | 2026-09-22 09:58 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 32.5000 | 31.5000 | 32.5000 | 998.0300 | 19500.00 | 19500.00 | 0.00 | 6 | 6 | 404 | 5346 | 0.0755705200149645 | 0.922468854225051 | 0.922468854225051 | false | false | false | |||||||||||||||||
| 8d3f4da4-715f-43df-970a-2f9e81012a28 | 2026-09-22 10:38 | 2026-09-22 10:38 | 2026-09-22 10:38 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 18.8000 | 17.8000 | 19.4000 | 968.8950 | 30080.00 | 30080.00 | 0.00 | 16 | 5 | 785 | 5346 | 0.146838757949869 | 0.895041006380892 | 0.895041006380892 | false | false | false | |||||||||||||||||
| f657abc5-443d-4bc0-b1f7-553193bd4bbe | 2026-09-22 15:14 | 2026-09-22 15:14 | 2026-09-22 15:14 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 9.5000 | 9.4000 | 9.9000 | 942.4400 | 60812.00 | 950.00 | 12362.00 | 64 | 9 | 1507 | 5346 | 0.281893004115226 | 0.847942420329411 | 0.847942420329411 | false | false | false | |||||||||||||||||
| df3eb8e6-95d5-4c41-87db-0f6fb5cf1540 | 2026-09-22 15:14 | 2026-09-22 15:14 | 2026-09-22 15:14 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 9.5000 | 9.0000 | 9.5000 | 941.3800 | 46550.00 | 46550.00 | 0.00 | 49 | 10 | 1443 | 5346 | 0.269921436588103 | 0.857386207060911 | 0.857386207060911 | false | false | false | |||||||||||||||||
| b456668c-f468-4e67-9597-9437360b284f | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | LITE | LITE260925C01000000 | call | 1000.0000 | 2026-09-25 | 10.2000 | 10.0000 | 10.4000 | 945.7200 | 150960.00 | 96900.00 | 3060.00 | 148 | 12 | 1769 | 5346 | 0.330901608679386 | 0.844701613870034 | 0.844701613870034 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 83502627000.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 85617753000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 85617753000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:51:16.040164Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 84826599000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:48:39.949749Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 84826599000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:54:31.756724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 84826599000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:56:25.927111Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 84826599000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:58:41.675080Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 84826599000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 84826599000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 84826599000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 84826599000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |