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.
Simplify Analyticsuw_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 |
|---|
| 3cba90a2-e627-4b06-97fb-cf76337ae575 | 2026-08-21 15:15 | 2026-08-21 15:15 | 2026-08-21 15:15 | GEO | GEO260918C00031000 | call | 31.0000 | 2026-09-18 | 2.7000 | 2.6500 | 2.7000 | 32.6650 | 27000.00 | 27000.00 | 0.00 | 100 | 7 | 20995 | 1130 | 18.5796460176991 | 0.47832603963824 | 0.47832603963824 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Real Estate | 4060464166.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a1172083-8aa3-4212-8741-bceb1c765474 | 2026-08-21 14:49 | 2026-08-21 14:49 | 2026-08-21 14:49 | GEO | GEO260821C00029000 | call | 29.0000 | 2026-08-21 | 3.3800 | 3.3000 | 3.5000 | 32.4100 | 110870.00 | 67320.00 | 1675.00 | 328 | 42 | 2548 | 2530 | 1.00711462450593 | 2.23060611870082 | 6.84595359111676 | false | false | false | true | false | |||||||||||||||
| 49ca02bb-eb07-4072-a249-f15ca486c824 | 2026-08-21 14:49 | 2026-08-21 14:49 | 2026-08-21 14:49 | GEO | GEO260918C00031000 | call | 31.0000 | 2026-09-18 | 2.5000 | 2.4500 | 2.5000 | 32.4100 | 75000.00 | 75000.00 | 0.00 | 300 | 19 | 20409 | 1130 | 18.0610619469027 | 0.469794306041064 | 0.469794306041064 | false | false | false | true | false | |||||||||||||||
| 13f55f7b-6fd1-469a-831c-bfaaf536ef68 | 2026-08-21 14:48 | 2026-08-21 14:47 | 2026-08-21 14:47 | GEO | GEO260821C00029000 | call | 29.0000 | 2026-08-21 | 3.3700 | 3.3000 | 3.4000 | 32.3900 | 66410.00 | 28220.00 | 0.00 | 197 | 16 | 2220 | 2530 | 0.877470355731225 | 4.45728642291986 | 4.45728642291986 | false | false | false | true | false | |||||||||||||||
| 72e642cc-c313-4b81-9976-41758e542c8d | 2026-08-21 14:47 | 2026-08-21 14:47 | 2026-08-21 14:47 | GEO | GEO260821C00029000 | call | 29.0000 | 2026-08-21 | 3.3700 | 3.3000 | 3.4000 | 32.3900 | 55930.00 | 21760.00 | 0.00 | 166 | 10 | 1931 | 2530 | 0.763241106719368 | 4.45418505836468 | 4.45418505836468 | false | false | false | true | false | |||||||||||||||
| 45153c33-8c60-4695-a6e1-28f428974466 | 2026-08-21 14:47 | 2026-08-21 14:47 | 2026-08-21 14:47 | GEO | GEO260821C00029000 | call | 29.0000 | 2026-08-21 | 3.3800 | 3.3000 | 3.4000 | 32.4000 | 31125.00 | 20740.00 | 0.00 | 92 | 5 | 2023 | 2530 | 0.799604743083004 | 1.93211433629042 | 1.93211433629042 | false | false | false | true | false | |||||||||||||||
| 6b55f193-6456-4236-90d1-61fd563d15cb | 2026-08-21 14:47 | 2026-08-21 14:47 | 2026-08-21 14:47 | GEO | GEO260821C00029000 | call | 29.0000 | 2026-08-21 | 3.3700 | 3.3000 | 3.4000 | 32.3950 | 56940.00 | 22100.00 | 0.00 | 169 | 12 | 1765 | 2530 | 0.697628458498024 | 4.04745099450866 | 4.04745099450866 | false | false | false | true | false | |||||||||||||||
| 524cf2a8-29a1-419e-a180-644bc55734dc | 2026-08-21 14:47 | 2026-08-21 14:47 | 2026-08-21 14:47 | GEO | GEO260821C00029000 | call | 29.0000 | 2026-08-21 | 3.3700 | 3.1000 | 3.4000 | 32.4000 | 180490.00 | 88365.00 | 0.00 | 536 | 48 | 1575 | 2530 | 0.622529644268775 | 4.94846925357097 | 1.93211433629042 | false | false | false | true | false | |||||||||||||||
| c7576407-089a-45a4-8859-6fffc16cef7e | 2026-08-21 14:44 | 2026-08-21 14:43 | 2026-08-21 14:43 | GEO | GEO260918C00035000 | call | 35.0000 | 2026-09-18 | 0.7000 | 0.6000 | 0.7000 | 32.3100 | 21000.00 | 21000.00 | 0.00 | 300 | 9 | 20678 | 2370 | 8.72489451476793 | 0.455059650495724 | 0.455059650495724 | false | false | false | true | false | |||||||||||||||
| 4572c917-103a-4381-8988-15b96612559f | 2026-08-21 14:12 | 2026-08-21 14:12 | 2026-08-21 14:12 | GEO | GEO260918C00031000 | call | 31.0000 | 2026-09-18 | 2.4900 | 2.2500 | 2.5000 | 32.0000 | 4980000.00 | 4980000.00 | 0.00 | 20000 | 4 | 20006 | 1130 | 17.7044247787611 | 0.472831992653652 | 0.472831992653652 | false | true | true | false | true | |||||||||||||||
| cb778b52-e5b2-4225-98c1-3a2a26206e7e | 2026-08-21 14:01 | 2026-08-21 14:01 | 2026-08-21 14:01 | GEO | GEO260821C00029000 | call | 29.0000 | 2026-08-21 | 3.4000 | 3.4000 | 3.4000 | 32.5300 | 60870.00 | 3410.00 | 0.00 | 179 | 19 | 226 | 2530 | 0.0893280632411067 | 1.09723600550926 | 1.09723600550926 | false | false | false | true | false | |||||||||||||||
| 256025c4-ef84-45d5-a59a-0703f4da4ef0 | 2026-08-21 14:01 | 2026-08-21 14:01 | 2026-08-21 14:01 | GEO | GEO260821C00029000 | call | 29.0000 | 2026-08-21 | 3.4000 | 3.2000 | 3.6000 | 32.4400 | 276471.00 | 48840.00 | 198391.00 | 812 | 60 | 1038 | 2530 | 0.410276679841897 | 5.40699772302236 | 1.09723600550926 | true | false | false | true | false | |||||||||||||||
| 0c09dee8-06d6-4e30-a09b-021430378e93 | 2026-08-21 11:22 | 2026-08-21 11:21 | 2026-08-21 11:21 | GEO | GEO280121C00045000 | call | 45.0000 | 2028-01-21 | 5.2000 | 4.6000 | 5.2000 | 32.0000 | 207971.00 | 207971.00 | 0.00 | 400 | 7 | 400 | 3226 | 0.123992560446373 | 0.550499187179075 | 0.551160077169795 | false | false | false | true | false | |||||||||||||||
| dcedb8ee-0b8d-4bd8-8185-9ec1007f8038 | 2026-08-20 13:53 | 2026-08-20 13:53 | 2026-08-20 13:53 | GEO | GEO260821C00030000 | call | 30.0000 | 2026-08-21 | 1.8500 | 1.4000 | 2.0000 | 31.8400 | 27750.00 | 3330.00 | 24420.00 | 150 | 6 | 770 | 3067 | 0.251059667427454 | 0.706871854510544 | 0.558639056966902 | false | false | false | true | false | |||||||||||||||
| e35bc780-2d73-4503-b7ad-01c2254c0a6b | 2026-08-20 10:52 | 2026-08-20 10:52 | 2026-08-20 10:52 | GEO | GEO260918C00032000 | call | 32.0000 | 2026-09-18 | 1.5000 | 1.3000 | 1.6000 | 31.7900 | 15000.00 | 3300.00 | 3000.00 | 100 | 5 | 114 | 2243 | 0.050824788230049 | 0.434892850219687 | 0.434892850219687 | false | false | false | true | false | |||||||||||||||
| 3787c05b-93fc-436b-8298-06290241e007 | 2026-08-20 10:02 | 2026-08-20 10:02 | 2026-08-20 10:02 | GEO | GEO270115C00037000 | call | 37.0000 | 2027-01-15 | 2.3500 | 1.7000 | 2.3500 | 31.3500 | 58750.00 | 58750.00 | 0.00 | 250 | 15 | 500 | 961 | 0.520291363163371 | 0.517859395543553 | 0.517859395543553 | false | false | false | true | false | |||||||||||||||
| ff9eec29-94a6-47d9-9043-3d93f531a645 | 2026-08-19 11:44 | 2026-08-19 11:44 | 2026-08-19 11:44 | GEO | GEO260918C00030000 | call | 30.0000 | 2026-09-18 | 2.1700 | 1.7500 | 2.2000 | 30.7900 | 26070.00 | 26070.00 | 0.00 | 120 | 11 | 268 | 2597 | 0.103195995379284 | 0.496722020335047 | 0.48196603863336 | false | false | false | true | false | |||||||||||||||
| 5c89cf7c-8e60-42ae-8e29-63c6fa97969c | 2026-08-19 11:21 | 2026-08-19 11:21 | 2026-08-19 11:21 | GEO | GEO260918C00030000 | call | 30.0000 | 2026-09-18 | 1.8600 | 1.8500 | 2.2000 | 30.5800 | 22301.00 | 0.00 | 22301.00 | 120 | 8 | 148 | 2597 | 0.0569888332691567 | 0.424688830892045 | 0.439682517626272 | false | false | false | true | false | |||||||||||||||
| 28804177-4524-4738-8851-f39748f27f80 | 2026-08-17 13:52 | 2026-08-17 13:52 | 2026-08-17 13:52 | GEO | GEO261120P00027000 | put | 27.0000 | 2026-11-20 | 1.3500 | 1.3500 | 1.4500 | 31.0000 | 16335.00 | 0.00 | 16335.00 | 121 | 9 | 121 | 12 | 10.0833333333333 | 0.542403315613211 | 0.542403315613211 | false | false | false | true | false |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Real Estate |
| 4060464166.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |