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_alerts523,327 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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| dee8807a-bf8f-4496-9a45-f51144a8e0ad | 2026-09-25 12:21 | 2026-09-25 12:21 | 2026-09-25 12:21 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 0.2600 | 0.2300 | 0.2600 | 344.5000 | 42718.00 | 42718.00 | 0.00 | 1643 | 55 | 11639 | 2353 | 4.94645133871653 | 0.33716865413603 | 0.33716865413603 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 2018122560000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T16:23:36.031471Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 82d142a0-fa80-4195-a899-d2f53ce120d3 | 2026-09-25 12:05 | 2026-09-25 12:04 | 2026-09-25 12:04 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 0.2500 | 0.2200 | 0.2500 | 344.9700 | 46625.00 | 46625.00 | 0.00 | 1865 | 65 | 9577 | 2353 | 4.07012324691883 | 0.364658072835086 | 0.364658072835086 | false | false | false | |||||||||||||||||
| 66334cf2-233f-4f4f-a6ba-e159a9fd0e87 | 2026-09-25 10:43 | 2026-09-25 10:43 | 2026-09-25 10:43 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 1.1200 | 1.1200 | 1.1800 | 342.5600 | 12432.00 | 0.00 | 12432.00 | 111 | 31 | 4943 | 2353 | 2.10072248193795 | 0.344181823210907 | 0.344181823210907 | true | false | false | |||||||||||||||||
| 57c4db7d-4e30-418b-a3d5-175fa3b30873 | 2026-09-24 15:54 | 2026-09-24 15:54 | 2026-09-24 15:54 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 2.3900 | 2.2400 | 2.3900 | 342.6700 | 21510.00 | 21510.00 | 0.00 | 90 | 7 | 2410 | 2196 | 1.09744990892532 | 0.348422355837326 | 0.348422355837326 | false | false | false | |||||||||||||||||
| 385757fc-6d15-46c5-8dc4-4ea160d41f4b | 2026-09-24 15:00 | 2026-09-24 15:00 | 2026-09-24 15:00 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 2.8500 | 2.7400 | 2.8500 | 341.7200 | 11400.00 | 11400.00 | 0.00 | 40 | 8 | 2112 | 2196 | 0.961748633879781 | 0.34450553924656 | 0.34450553924656 | false | false | false | |||||||||||||||||
| 35df729b-9d75-4a2e-b70a-c9260c8158fe | 2026-09-24 12:41 | 2026-09-24 12:41 | 2026-09-24 12:41 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 2.8900 | 2.8800 | 3.1000 | 341.8800 | 20519.00 | 289.00 | 20230.00 | 71 | 13 | 1148 | 2196 | 0.522768670309654 | 0.361505408813409 | 0.362253577905888 | false | false | false | |||||||||||||||||
| 5663d85f-4d73-46cf-84fc-815e467974a4 | 2026-09-24 12:15 | 2026-09-24 12:14 | 2026-09-24 12:14 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 3.9500 | 3.9000 | 4.2000 | 340.1250 | 24095.00 | 395.00 | 23700.00 | 61 | 9 | 928 | 2196 | 0.422586520947177 | 0.366709451378513 | 0.367184925114492 | false | false | false | |||||||||||||||||
| d27a7c08-3aea-448e-9714-56e27b2d9429 | 2026-09-24 11:59 | 2026-09-24 11:59 | 2026-09-24 11:59 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 4.6500 | 4.6500 | 4.9000 | 339.1273 | 29295.00 | 0.00 | 29295.00 | 63 | 7 | 554 | 2196 | 0.252276867030965 | 0.371312778130661 | 0.373215123380287 | false | false | false | |||||||||||||||||
| 9a0d8496-2c08-48a4-9cef-152f085029b0 | 2026-09-24 10:52 | 2026-09-24 10:52 | 2026-09-24 10:52 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 4.2500 | 4.2500 | 4.3500 | 339.9250 | 50150.00 | 0.00 | 50150.00 | 118 | 23 | 364 | 2196 | 0.165755919854281 | 0.393036527245662 | 0.393036527245662 | false | false | false | |||||||||||||||||
| 93d24a90-9182-4a5e-8903-62ce25cadfb5 | 2026-09-24 10:09 | 2026-09-24 10:09 | 2026-09-24 10:09 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 4.6000 | 4.6000 | 4.7500 | 339.4199 | 17480.00 | 0.00 | 17480.00 | 38 | 11 | 167 | 2196 | 0.0760473588342441 | 0.396324017198632 | 0.396324017198632 | false | false | false | |||||||||||||||||
| 022a2bf2-e736-4cfd-a1ed-689d158b2038 | 2026-09-23 12:25 | 2026-09-23 12:25 | 2026-09-23 12:25 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 5.2000 | 5.2000 | 5.5000 | 339.8450 | 20280.00 | 0.00 | 20280.00 | 39 | 13 | 2663 | 1749 | 1.52258433390509 | 0.374247491902326 | 0.374247491902326 | false | false | false | |||||||||||||||||
| 7aedcbec-352f-46f5-a7df-4bdddcaf896d | 2026-09-23 10:30 | 2026-09-23 10:29 | 2026-09-23 10:29 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 4.4500 | 4.4000 | 4.7000 | 341.3700 | 44500.00 | 5785.00 | 38715.00 | 100 | 6 | 2159 | 1749 | 1.23441966838193 | 0.386236365648222 | 0.386236365648222 | false | false | false | |||||||||||||||||
| aeaa534c-e2cb-4f1c-9212-121c6f66857a | 2026-09-23 10:20 | 2026-09-23 10:19 | 2026-09-23 10:19 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 5.1500 | 5.1000 | 5.3000 | 340.5100 | 14935.00 | 5150.00 | 9785.00 | 29 | 6 | 1958 | 1749 | 1.11949685534591 | 0.409320909409397 | 0.408748521909939 | false | false | false | |||||||||||||||||
| 21cebe84-f0ba-43e5-b59f-aa28552f322b | 2026-09-22 13:11 | 2026-09-22 13:11 | 2026-09-22 13:11 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 1.7000 | 1.6100 | 1.7000 | 350.7800 | 27710.00 | 27710.00 | 0.00 | 163 | 16 | 740 | 1599 | 0.462789243277048 | 0.380249946772495 | 0.380249946772495 | false | false | false | |||||||||||||||||
| 28bf34df-ecd2-4993-9d89-e4ccc703e800 | 2026-09-22 12:30 | 2026-09-22 12:30 | 2026-09-22 12:30 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 1.3600 | 1.2700 | 1.3600 | 352.1200 | 19856.00 | 19856.00 | 0.00 | 146 | 23 | 472 | 1599 | 0.295184490306442 | 0.375113857560873 | 0.375113857560873 | false | false | false | |||||||||||||||||
| 06448e5c-2db2-49f5-8a53-81cbbc336953 | 2026-09-21 10:10 | 2026-09-21 10:10 | 2026-09-21 10:10 | GOOGL | GOOGL260925P00342500 | put | 342.5000 | 2026-09-25 | 1.1000 | 1.0200 | 1.1100 | 354.7200 | 20680.00 | 20570.00 | 110.00 | 188 | 6 | 264 | 1556 | 0.169665809768638 | 0.347014485385923 | 0.346839295492536 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2018122560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:05:43.599354Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2018122560000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:47:41.799650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:58:08.680508Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:02:51.984196Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:41:33.894916Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:15:47.773676Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:00:52.133329Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:53:28.868411Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:10:55.671270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:31:43.812748Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:31:12.586989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1982386440000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:21:45.775363Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2060606880000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:35:05.886735Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 2082963960000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:10:29.738922Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |