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 |
|---|
| dd8513aa-218d-4ac0-855c-cdcb4677f37a | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TWLO | TWLO261016C00310000 | call | 310.0000 | 2026-10-16 | 6.7000 | 6.0000 | 7.4000 | 284.0800 | 14740.00 | 3350.00 | 670.00 | 22 | 6 | 468 | 52 | 9 | 0.536743576673523 | 0.536743576673523 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 43696757347.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| d324a50a-3172-46de-b79c-339226f50c53 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TWLO | TWLO261016C00270000 | call | 270.0000 | 2026-10-16 | 24.6600 | 22.4000 | 24.7000 | 284.0800 | 83830.00 | 19760.00 | 24600.00 | 34 | 9 | 573 | 967 | 0.592554291623578 | 0.574780286294242 | 0.57099412023468 | false | false | false | true | false | |||||||||||||||
| b7c9da33-3f9e-4e7a-95db-ea3adb2fc44a | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TWLO | TWLO261016C00310000 | call | 310.0000 | 2026-10-16 | 6.9000 | 6.9000 | 7.4500 | 284.0800 | 19320.00 | 0.00 | 8970.00 | 28 | 5 | 532 | 52 | 10.2307692307692 | 0.544712990530195 | 0.544712990530195 | true | false | false | true | false | |||||||||||||||
| 676518e1-e617-4574-9b1b-29566d3e6384 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TWLO | TWLO261016C00310000 | call | 310.0000 | 2026-10-16 | 7.1000 | 7.0000 | 7.1000 | 283.3400 | 17750.00 | 17750.00 | 0.00 | 25 | 6 | 575 | 52 | 11.0576923076923 | 0.561381367827647 | 0.561381367827647 | false | false | false | true | false | |||||||||||||||
| 40246e14-7c5e-468c-9bcc-760ecc4811e3 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TWLO | TWLO261016C00270000 | call | 270.0000 | 2026-10-16 | 24.4000 | 22.9000 | 24.6000 | 283.3400 | 31720.00 | 7320.00 | 19520.00 | 13 | 5 | 657 | 967 | 0.679420889348501 | 0.582022228123098 | 0.582022228123098 | false | false | false | true | false | |||||||||||||||
| 51b2e2af-4e36-49b3-b97a-b4890572ad26 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TWLO | TWLO261016C00310000 | call | 310.0000 | 2026-10-16 | 7.1000 | 7.0000 | 7.1000 | 283.3400 | 44020.00 | 44020.00 | 0.00 | 62 | 11 | 647 | 52 | 12.4423076923077 | 0.561381367827647 | 0.561381367827647 | false | false | false | true | false | |||||||||||||||
| 175e0192-dfb5-4166-b221-a2f79c14f7b9 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TWLO | TWLO261016C00270000 | call | 270.0000 | 2026-10-16 | 24.6000 | 23.4000 | 24.8000 | 283.3400 | 31980.00 | 17220.00 | 14760.00 | 13 | 5 | 698 | 967 | 0.72182006204757 | 0.589538140543294 | 0.589538140543294 | false | false | false | true | false | |||||||||||||||
| b38c40de-799f-43e4-b803-67cb9addb86f | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TWLO | TWLO261016C00310000 | call | 310.0000 | 2026-10-16 | 6.6800 | 6.3000 | 7.8000 | 283.3400 | 34750.00 | 15480.00 | 8050.00 | 52 | 10 | 699 | 52 | 13.4423076923077 | 0.557396157921128 | 0.561381367827647 | false | false | false | true | false | |||||||||||||||
| 57da8775-59be-4ac6-9acd-23684ca4a7f1 | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | TWLO | TWLO261016C00310000 | call | 310.0000 | 2026-10-16 | 7.1000 | 6.7000 | 7.8000 | 283.3400 | 12780.00 | 8520.00 | 4260.00 | 18 | 5 | 717 | 52 | 13.7884615384615 | 0.561381367827647 | 0.561381367827647 | false | false | false | true | false | |||||||||||||||
| 1ee18e38-c2f0-4393-9d44-6cb2623c3c67 | 2026-09-22 09:51 | 2026-09-22 09:51 | 2026-09-22 09:51 | TWLO | TWLO260925C00285000 | call | 285.0000 | 2026-09-25 | 3.9000 | 3.5000 | 4.0000 | 274.5900 | 10920.00 | 10140.00 | 390.00 | 28 | 17 | 94 | 64 | 1.46875 | 0.793477945823576 | 0.793477945823576 | false | false | false | true | false | |||||||||||||||
| f1074d75-8ef4-43e8-9519-40113811595a | 2026-09-22 09:52 | 2026-09-22 09:51 | 2026-09-22 09:51 | TWLO | TWLO260925C00285000 | call | 285.0000 | 2026-09-25 | 3.9800 | 3.9000 | 4.6000 | 274.8000 | 34228.00 | 0.00 | 34228.00 | 86 | 11 | 230 | 64 | 3.59375 | 0.794944874980393 | 0.794944874980393 | false | false | false | true | false | |||||||||||||||
| 0670e09d-c1cb-42aa-b749-57fa113911e9 | 2026-09-22 10:06 | 2026-09-22 10:06 | 2026-09-22 10:06 | TWLO | TWLO270319C00350000 | call | 350.0000 | 2027-03-19 | 28.0100 | 24.5000 | 28.3000 | 281.7450 | 316480.00 | 280990.00 | 35490.00 | 113 | 31 | 114 | 5 | 22.8 | 0.618189835483163 | 0.606996340523377 | true | false | false | true | false | |||||||||||||||
| 6dec961d-d3ce-43c4-8fc8-7ca2122a9f0c | 2026-09-22 10:06 | 2026-09-22 10:06 | 2026-09-22 10:06 | TWLO | TWLO270319C00370000 | call | 370.0000 | 2027-03-19 | 23.3600 | 21.8000 | 24.5000 | 281.5801 | 42040.00 | 25830.00 | 16210.00 | 18 | 9 | 22 | 2 | 11 | 0.615962176896936 | 0.609121445571157 | true | false | false | true | false | |||||||||||||||
| 168b2ec8-36c5-481b-afb5-191d2643a822 | 2026-09-22 10:06 | 2026-09-22 10:06 | 2026-09-22 10:06 | TWLO | TWLO270319C00360000 | call | 360.0000 | 2027-03-19 | 25.5900 | 22.5000 | 26.9000 | 281.5000 | 371010.00 | 231300.00 | 139710.00 | 145 | 12 | 146 | 1 | 146 | 0.616969914120274 | 0.619549048135807 | true | false | false | true | false | |||||||||||||||
| c5348c7d-45f6-4481-bc76-b126d98fb96e | 2026-09-22 10:28 | 2026-09-22 10:28 | 2026-09-22 10:28 | TWLO | TWLO261218P00260000 | put | 260.0000 | 2026-12-18 | 24.0000 | 21.5000 | 24.0000 | 277.2500 | 24000.00 | 24000.00 | 0.00 | 10 | 5 | 10 | 1 | 10 | 0.635963685206991 | 0.635963685206991 | false | false | false | true | false | |||||||||||||||
| 2c98800d-a7f5-45e6-81c5-f82f2348f9cf | 2026-09-22 11:01 | 2026-09-22 11:01 | 2026-09-22 11:01 | TWLO | TWLO260925C00280000 | call | 280.0000 | 2026-09-25 | 6.8000 | 6.8000 | 8.2000 | 279.3600 | 66640.00 | 0.00 | 66640.00 | 98 | 18 | 334 | 237 | 1.40928270042194 | 0.699265099217809 | 0.699265099217809 | false | false | false | true | false | |||||||||||||||
| fff1ec6c-2ff0-4cc2-8a67-863c84f4937f | 2026-09-22 11:04 | 2026-09-22 11:04 | 2026-09-22 11:04 | TWLO | TWLO261030C00350000 | call | 350.0000 | 2026-10-30 | 6.0000 | 4.0000 | 6.4000 | 278.9500 | 13210.00 | 12590.00 | 620.00 | 22 | 7 | 35 | 1 | 35 | 0.699811845781719 | 0.707921053734578 | true | false | false | true | false | |||||||||||||||
| 2e10688c-03a5-4aac-b7b1-3d456d6c78b4 | 2026-09-22 11:56 | 2026-09-22 11:56 | 2026-09-22 11:56 | TWLO | TWLO261016C00275000 | call | 275.0000 | 2026-10-16 | 17.1000 | 17.1000 | 18.2000 | 277.4150 | 418950.00 | 0.00 | 418950.00 | 245 | 28 | 424 | 14 | 30.2857142857143 | 0.549188771072116 | 0.549188771072116 | false | false | false | true | false | |||||||||||||||
| b66c790d-2f00-4af8-b994-eecd21b3953d | 2026-09-22 14:29 | 2026-09-22 14:29 | 2026-09-22 14:29 | TWLO | TWLO270115C00330000 | call | 330.0000 | 2027-01-15 | 22.0000 | 22.0000 | 22.5000 | 280.4850 | 712800.00 | 0.00 | 712800.00 | 324 | 19 | 455 | 38 | 11.9736842105263 | 0.602784429459157 | 0.602784429459157 | false | false | false | true | false | |||||||||||||||
| b01b692b-1190-428f-a871-e8ec3a7e71a7 | 2026-09-22 15:03 | 2026-09-22 15:02 | 2026-09-22 15:02 | TWLO | TWLO260925P00285000 | put | 285.0000 | 2026-09-25 | 8.0200 | 7.6000 | 8.8000 | 283.1450 | 10420.00 | 810.00 | 9610.00 | 13 | 6 | 18 | 0 | 0 | 0.689714145985127 | 0.699500995731002 | false | false | false | true | false | |||||||||||||||
| 306a079c-f3e5-4b1d-9117-ff0b403e5923 | 2026-09-22 15:23 | 2026-09-22 15:23 | 2026-09-22 15:23 | TWLO | TWLO270115P00250000 | put | 250.0000 | 2027-01-15 | 20.9000 | 19.8000 | 21.1000 | 284.0050 | 98230.00 | 85690.00 | 12540.00 | 47 | 9 | 135 | 123 | 1.09756097560976 | 0.61973321819157 | 0.61973321819157 | false | false | false | true | false | |||||||||||||||
| 8d99d466-9683-4245-80c3-d5bae225bed3 | 2026-09-22 15:30 | 2026-09-22 15:30 | 2026-09-22 15:30 | TWLO | TWLO270115C00340000 | call | 340.0000 | 2027-01-15 | 21.5000 | 21.0000 | 21.5000 | 284.0000 | 303150.00 | 303150.00 | 0.00 | 141 | 24 | 198 | 26 | 7.61538461538461 | 0.609453894725817 | 0.609453894725817 | false | false | false | true | false | |||||||||||||||
| f923e271-55bc-4c02-bffe-d9f6edd80fb0 | 2026-09-22 15:53 | 2026-09-22 15:53 | 2026-09-22 15:53 | TWLO | TWLO270617P00155000 | put | 155.0000 | 2027-06-17 | 7.9000 | 7.0000 | 8.7000 | 284.0000 | 43450.00 | 24490.00 | 18960.00 | 55 | 13 | 96 | 2 | 48 | 0.675781392898546 | 0.675781392898546 | false | false | false | true | false |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:52:22.219586Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:52:22.219586Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| 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 |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:05:44.724527Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:05:44.724527Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:56:22.412787Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:33:11.786837Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 43696757347.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |