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 |
|---|
| 054f89f2-0ebd-41fd-8a54-a937122804ab | 2026-09-28 11:28 | 2026-09-28 11:28 | 2026-09-28 11:28 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 2.3400 | 2.3200 | 2.3400 | 340.8800 | 13104.00 | 13104.00 | 0.00 | 56 | 9 | 765 | 2754 | 0.277777777777778 | 0.341731135543643 | 0.341731135543643 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2011257000000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T15:32:36.194150Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| c5e2b7a9-c7b9-4914-ab63-08481ae94213 | 2026-09-28 12:26 | 2026-09-28 12:26 | 2026-09-28 12:26 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 2.3700 | 2.2400 | 2.3700 | 340.8100 | 15878.00 | 15878.00 | 0.00 | 67 | 5 | 925 | 2754 | 0.335875090777052 | 0.345839271343508 | 0.345040239114194 | false | false | false | |||||||||||||||||
| 66e00da6-03aa-480c-a6d7-9e696e75ed07 | 2026-09-28 12:41 | 2026-09-28 12:41 | 2026-09-28 12:41 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 2.2000 | 2.2000 | 2.3000 | 340.0000 | 12320.00 | 0.00 | 12320.00 | 56 | 11 | 1018 | 2754 | 0.369644153957879 | 0.339870231212017 | 0.339870231212017 | false | false | false | |||||||||||||||||
| 08482c63-8af5-4252-855f-7fdc45f5786b | 2026-09-28 14:05 | 2026-09-28 14:05 | 2026-09-28 14:05 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 3.0500 | 3.0000 | 3.1000 | 342.0000 | 10065.00 | 915.00 | 9150.00 | 33 | 13 | 1389 | 2754 | 0.504357298474945 | 0.345719916351853 | 0.345719916351853 | true | false | false | |||||||||||||||||
| 503a5399-381d-4a07-815f-ae3b9c32fdc9 | 2026-09-28 14:34 | 2026-09-28 14:34 | 2026-09-28 14:34 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 2.7600 | 2.6600 | 2.7700 | 342.0877 | 29255.00 | 28429.00 | 0.00 | 106 | 16 | 1543 | 2754 | 0.560275962236747 | 0.3448044840961 | 0.344713568061436 | true | false | false | |||||||||||||||||
| dbf84d47-0cec-4d71-91a4-bddba45cff3c | 2026-09-29 09:31 | 2026-09-29 09:31 | 2026-09-29 09:31 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 2.3000 | 2.2000 | 2.6000 | 341.6901 | 22300.00 | 226.00 | 22074.00 | 97 | 17 | 112 | 3508 | 0.031927023945268 | 0.365200810288033 | 0.364395165276027 | true | false | false | |||||||||||||||||
| 3b8f1257-13b4-4a42-95bb-16ae60102a66 | 2026-09-29 13:28 | 2026-09-29 13:28 | 2026-09-29 13:28 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 1.5200 | 1.5200 | 1.6000 | 339.2063 | 108380.00 | 612.00 | 107768.00 | 713 | 66 | 1749 | 3508 | 0.498574686431015 | 0.358555130208675 | 0.359897972758203 | false | false | false | |||||||||||||||||
| 351156fd-3ae0-458f-af58-fffcbb1ab07b | 2026-09-29 13:40 | 2026-09-29 13:40 | 2026-09-29 13:40 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 1.4900 | 1.4900 | 1.6100 | 339.1100 | 85377.00 | 0.00 | 85377.00 | 573 | 49 | 2335 | 3508 | 0.665621436716078 | 0.359130851526531 | 0.359130851526531 | false | false | false | |||||||||||||||||
| 220ef499-d619-4dbf-bb9e-2114bce6dfdb | 2026-09-30 09:31 | 2026-09-30 09:31 | 2026-09-30 09:31 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 3.9500 | 3.7000 | 3.9500 | 346.4200 | 14220.00 | 14220.00 | 0.00 | 36 | 9 | 179 | 5081 | 0.035229285573706 | 0.432767911088963 | 0.432767911088963 | true | false | false | |||||||||||||||||
| 9f04242c-abd5-4c26-8069-af38e4fdbe57 | 2026-09-30 09:33 | 2026-09-30 09:33 | 2026-09-30 09:33 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 4.0000 | 4.0000 | 4.2000 | 346.5700 | 15200.00 | 0.00 | 15200.00 | 38 | 5 | 457 | 5081 | 0.0899429246211376 | 0.430715668205144 | 0.430715668205144 | false | false | false | |||||||||||||||||
| bb1d42d0-ba8f-4859-ba87-69e1a98d2f25 | 2026-09-30 09:39 | 2026-09-30 09:39 | 2026-09-30 09:39 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 4.1000 | 3.9000 | 4.1000 | 346.7650 | 10660.00 | 10660.00 | 0.00 | 26 | 7 | 661 | 5081 | 0.130092501476087 | 0.431357880653255 | 0.431357880653255 | true | false | false | |||||||||||||||||
| 1207e91e-da54-4be5-b65b-70f0127283bf | 2026-09-30 10:07 | 2026-09-30 10:07 | 2026-09-30 10:07 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 6.6000 | 6.5000 | 6.9500 | 351.0000 | 133320.00 | 0.00 | 133320.00 | 202 | 14 | 1809 | 5081 | 0.356032277110805 | 0.412267906141532 | 0.416344671499044 | false | false | false | |||||||||||||||||
| 4ce5bb68-28eb-48f3-b88d-395a2920ba70 | 2026-09-30 14:55 | 2026-09-30 14:55 | 2026-09-30 14:55 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 4.9500 | 4.6500 | 4.9500 | 349.3450 | 49500.00 | 49500.00 | 0.00 | 100 | 6 | 3173 | 5081 | 0.624483369415469 | 0.380469482874161 | 0.380469482874161 | false | false | false | |||||||||||||||||
| de838332-631f-4f90-ad4f-8558834841f1 | 2026-09-30 14:55 | 2026-09-30 14:55 | 2026-09-30 14:55 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 4.9500 | 4.6500 | 4.9500 | 349.3500 | 49499.00 | 49499.00 | 0.00 | 100 | 23 | 3273 | 5081 | 0.644164534540445 | 0.380180474140781 | 0.380180474140781 | false | false | false | |||||||||||||||||
| 59e59972-c9bb-41fd-96cd-ea303e15a57c | 2026-09-30 15:52 | 2026-09-30 15:52 | 2026-09-30 15:52 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 3.1500 | 3.0000 | 3.1500 | 346.0000 | 641025.00 | 641025.00 | 0.00 | 2035 | 13 | 5471 | 5081 | 1.0767565439874 | 0.363282871176601 | 0.363282871176601 | true | false | false | |||||||||||||||||
| 5c87f9d3-0bc7-4977-b835-521b1be2f3dd | 2026-10-01 10:44 | 2026-10-01 10:44 | 2026-10-01 10:44 | GOOGL | GOOGL261002C00347500 | call | 347.5000 | 2026-10-02 | 0.9100 | 0.9000 | 0.9300 | 341.3500 | 11282.00 | 0.00 | 11282.00 | 124 | 5 | 5098 | 5425 | 0.939723502304147 | 0.41984340767889 | 0.420287040488923 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:26:41.677786Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:43:39.735275Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:10:39.755253Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2011257000000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:31:56.202644Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:35:56.522795Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:44:25.905906Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:32:13.617209Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:34:41.867394Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:41:13.731534Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:09:43.877107Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:00:58.122879Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:00:58.122879Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2000518560000.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:54:17.966040Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1984792320000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:46:09.839552Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |