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 | expirydate | price |
|---|
| 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 |
|---|
| 29c92adb-6892-425e-8242-5ac258ef386d | 2026-09-22 10:18 | 2026-09-22 10:18 | 2026-09-22 10:18 | ALAB | ALAB261218C00480000 | call | 480.0000 | 2026-12-18 | 27.4100 | 27.3500 | 29.7000 | 359.9575 | 65776.00 | 0.00 | 65776.00 | 24 | 6 | 26 | 326 | 0.0797546012269939 | 0.88002057033714 | 0.88002057033714 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 63054895900.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T14:20:22.518739Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 3f9c0631-4c8c-4e43-8091-4470a148ceef | 2026-09-22 10:19 | 2026-09-22 10:19 | 2026-09-22 10:19 | ALAB | ALAB261016P00365000 | put | 365.0000 | 2026-10-16 | 34.4600 | 31.8500 | 34.8000 | 359.8300 | 41350.00 | 6900.00 | 34450.00 | 12 | 6 | 29 | 0 | 0 | 0.875441437926659 | 0.874080653206907 | false | false | false | true | false | |||||||||||||||
| 5bef2628-36ab-4fb0-bc98-bbbc93490f45 | 2026-09-22 10:21 | 2026-09-22 10:21 | 2026-09-22 10:21 | ALAB | ALAB261002C00360000 | call | 360.0000 | 2026-10-02 | 22.0300 | 20.9500 | 23.1500 | 359.1100 | 41860.00 | 26460.00 | 15400.00 | 19 | 5 | 72 | 62 | 1.16129032258065 | 0.940652877062986 | 0.940652877062986 | true | false | false | true | false | |||||||||||||||
| ac05d4f8-0569-4846-87d1-3d90684e9278 | 2026-09-22 10:24 | 2026-09-22 10:24 | 2026-09-22 10:24 | ALAB | ALAB260925P00350000 | put | 350.0000 | 2026-09-25 | 8.6000 | 8.4000 | 9.0500 | 360.0000 | 10320.00 | 860.00 | 9460.00 | 12 | 7 | 27 | 2 | 13.5 | 1.02161042210974 | 1.02161042210974 | true | false | false | true | false | |||||||||||||||
| 7ec48170-0c2a-414e-8c98-e42d029e8db6 | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | ALAB | ALAB270319P00300000 | put | 300.0000 | 2027-03-19 | 46.6000 | 45.8000 | 51.0000 | 359.2900 | 27960.00 | 4660.00 | 18640.00 | 6 | 6 | 7 | 54 | 0.12962962962963 | 0.836974913470217 | 0.836974913470217 | false | false | false | true | false | |||||||||||||||
| b9b229bb-91f0-46f2-b807-adc0ff2f34a2 | 2026-09-22 10:32 | 2026-09-22 10:32 | 2026-09-22 10:32 | ALAB | ALAB261120P00310000 | put | 310.0000 | 2026-11-20 | 25.0000 | 25.0000 | 25.0500 | 361.6800 | 35000.00 | 0.00 | 35000.00 | 14 | 14 | 17 | 84 | 0.202380952380952 | 0.882914875077897 | 0.882914875077897 | true | false | false | true | false | |||||||||||||||
| 184058d7-efd1-44cc-8578-b86a2970e74f | 2026-09-22 10:42 | 2026-09-22 10:42 | 2026-09-22 10:42 | ALAB | ALAB270319P00280000 | put | 280.0000 | 2027-03-19 | 37.4600 | 36.5500 | 38.4500 | 358.9400 | 74910.00 | 59920.00 | 7490.00 | 20 | 10 | 31 | 88 | 0.352272727272727 | 0.833063326635771 | 0.833727484906826 | false | false | false | true | false | |||||||||||||||
| 8cbbd402-86be-46c6-912d-7fd4946545d3 | 2026-09-22 10:57 | 2026-09-22 10:57 | 2026-09-22 10:57 | ALAB | ALAB261016C00500000 | call | 500.0000 | 2026-10-16 | 3.9000 | 3.9000 | 4.5000 | 362.1000 | 12480.00 | 0.00 | 12480.00 | 32 | 7 | 121 | 1086 | 0.111418047882136 | 0.912954179610373 | 0.912954179610373 | false | false | false | true | false | |||||||||||||||
| 4e592167-ed75-4500-bdd0-b05ad7bd5ea1 | 2026-09-22 10:58 | 2026-09-22 10:58 | 2026-09-22 10:58 | ALAB | ALAB261009C00360000 | call | 360.0000 | 2026-10-09 | 28.3500 | 27.4500 | 29.5500 | 362.1300 | 170095.00 | 14200.00 | 155895.00 | 60 | 14 | 105 | 68 | 1.54411764705882 | 0.869985902894894 | 0.868367528066983 | true | false | false | true | false | |||||||||||||||
| 917602c1-2b30-40e2-adbd-95687c75e25f | 2026-09-22 11:08 | 2026-09-22 11:08 | 2026-09-22 11:08 | ALAB | ALAB261002P00352500 | put | 352.5000 | 2026-10-02 | 16.5000 | 15.9750 | 17.7000 | 362.0000 | 33005.00 | 0.00 | 33005.00 | 20 | 6 | 25 | 0 | 0 | 0.898917150844643 | 0.898917150844643 | true | false | false | true | false | |||||||||||||||
| 307ede20-4d30-4e10-80f3-eb786ad54152 | 2026-09-22 11:08 | 2026-09-22 11:08 | 2026-09-22 11:08 | ALAB | ALAB261002P00350000 | put | 350.0000 | 2026-10-02 | 15.4200 | 14.8500 | 15.8000 | 362.0000 | 49355.00 | 26280.00 | 23075.00 | 32 | 8 | 54 | 32 | 1.6875 | 0.901428706963099 | 0.90581942592527 | true | false | false | true | false | |||||||||||||||
| ba248190-6917-46e9-8f95-5c540889808f | 2026-09-22 11:16 | 2026-09-22 11:15 | 2026-09-22 11:15 | ALAB | ALAB261023C00510000 | call | 510.0000 | 2026-10-23 | 5.0400 | 4.9000 | 5.5500 | 363.7250 | 12600.00 | 7650.00 | 4950.00 | 25 | 5 | 40 | 0 | 0 | 0.887277034605361 | 0.887277034605361 | false | false | false | true | false | |||||||||||||||
| 4324a3bd-37c3-4c22-886e-f1f78dba41b9 | 2026-09-22 11:27 | 2026-09-22 11:27 | 2026-09-22 11:27 | ALAB | ALAB261009C00380000 | call | 380.0000 | 2026-10-09 | 19.9900 | 19.2500 | 21.6000 | 363.0000 | 33975.00 | 0.00 | 33975.00 | 17 | 14 | 178 | 247 | 0.720647773279352 | 0.848206925620227 | 0.85809489639159 | true | false | false | true | false | |||||||||||||||
| c274a4ab-7625-4b95-b866-a923a79b713e | 2026-09-22 11:36 | 2026-09-22 11:35 | 2026-09-22 11:35 | ALAB | ALAB261002P00350000 | put | 350.0000 | 2026-10-02 | 14.7500 | 14.7500 | 15.8000 | 362.9900 | 33925.00 | 0.00 | 33925.00 | 23 | 7 | 106 | 32 | 3.3125 | 0.882947353894757 | 0.882947353894757 | false | false | false | true | false | |||||||||||||||
| b355051c-65e0-4ff4-beea-ff207747c626 | 2026-09-22 11:57 | 2026-09-22 11:57 | 2026-09-22 11:57 | ALAB | ALAB261120P00240000 | put | 240.0000 | 2026-11-20 | 6.2000 | 5.8500 | 6.5500 | 365.2200 | 62000.00 | 22940.00 | 23560.00 | 100 | 10 | 128 | 494 | 0.259109311740891 | 0.90046557902663 | 0.90046557902663 | false | false | false | true | false | |||||||||||||||
| 3065c3a1-aa05-47ee-b0ed-10615a68195d | 2026-09-22 12:50 | 2026-09-22 12:50 | 2026-09-22 12:50 | ALAB | ALAB260925C00390000 | call | 390.0000 | 2026-09-25 | 5.0000 | 4.6500 | 5.5000 | 365.9000 | 14000.00 | 11500.00 | 2500.00 | 28 | 9 | 163 | 430 | 0.37906976744186 | 1.01030402255582 | 1.01030402255582 | true | false | false | true | false | |||||||||||||||
| 80ff99e8-05b1-482c-bfc4-67f09c7a7559 | 2026-09-22 13:02 | 2026-09-22 13:02 | 2026-09-22 13:02 | ALAB | ALAB270617C00600000 | call | 600.0000 | 2027-06-17 | 52.8900 | 50.5500 | 53.6500 | 366.0000 | 74050.00 | 58255.00 | 15795.00 | 14 | 6 | 14 | 28 | 0.5 | 0.860338946385988 | 0.856624593560246 | false | false | false | true | false | |||||||||||||||
| 9622f1c1-54e5-4f44-962c-254044788c0d | 2026-09-22 13:11 | 2026-09-22 13:10 | 2026-09-22 13:10 | ALAB | ALAB260925C00400000 | call | 400.0000 | 2026-09-25 | 3.5000 | 3.1500 | 3.6500 | 367.3850 | 21000.00 | 2800.00 | 18200.00 | 60 | 8 | 1719 | 182 | 9.44505494505495 | 1.02520449025928 | 1.02520449025928 | false | false | false | true | false | |||||||||||||||
| 647ae945-6e6d-46d4-b60c-f9cca7ae27b8 | 2026-09-22 13:21 | 2026-09-22 13:21 | 2026-09-22 13:21 | ALAB | ALAB261016C00480000 | call | 480.0000 | 2026-10-16 | 5.5500 | 5.5500 | 5.7500 | 367.0600 | 12765.00 | 0.00 | 12765.00 | 23 | 5 | 33 | 73 | 0.452054794520548 | 0.880682586238781 | 0.880682586238781 | false | false | false | true | false | |||||||||||||||
| 7f89a957-2770-4986-9c8a-fddc0162ddb7 | 2026-09-22 14:00 | 2026-09-22 14:00 | 2026-09-22 14:00 | ALAB | ALAB261218C00360000 | call | 360.0000 | 2026-12-18 | 63.5500 | 63.5500 | 66.7500 | 364.5400 | 50840.00 | 0.00 | 50840.00 | 8 | 5 | 44 | 107 | 0.411214953271028 | 0.849719031665333 | 0.852314159161381 | false | false | false | true | false | |||||||||||||||
| a489045a-8ca8-4dd0-b688-2639251f34e1 | 2026-09-22 14:01 | 2026-09-22 14:00 | 2026-09-22 14:00 | ALAB | ALAB270319C00500000 | call | 500.0000 | 2027-03-19 | 47.9800 | 46.1500 | 50.8000 | 362.4300 | 95950.00 | 19200.00 | 76750.00 | 20 | 5 | 42 | 142 | 0.295774647887324 | 0.851680007758024 | 0.850646609107767 | false | false | false | true | false | |||||||||||||||
| 685bc1dd-8bea-45bf-b891-98952399a4a9 | 2026-09-22 15:16 | 2026-09-22 15:16 | 2026-09-22 15:16 | ALAB | ALAB261016P00310000 | put | 310.0000 | 2026-10-16 | 9.9300 | 8.4000 | 9.9500 | 362.1300 | 20850.00 | 20850.00 | 0.00 | 21 | 5 | 41 | 161 | 0.254658385093168 | 0.832642528084149 | 0.84993534895305 | false | false | false | true | false |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:20:22.518739Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:23:46.275389Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:27:42.600893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:31:31.654153Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:34:01.762519Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:45:53.881330Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:29:11.777432Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:38:41.762966Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:00:55.569269Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:52:20.560244Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:06:21.234354Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:14:46.677665Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:23:35.118331Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 63054895900.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 63054895900.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 |