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 | 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 |
|---|
| 739f17af-bb22-461a-9ad6-5476c2c41af9 | 2026-08-20 12:00 | 2026-08-20 12:00 | 2026-08-20 12:00 | GE | GE261120P00360000 | put | 360.0000 | 2026-11-20 | 28.9500 | 28.2500 | 28.9500 | 346.6100 | 115785.00 | 115785.00 | 0.00 | 40 | 9 | 45 | 169 | 0.266272189349112 | 0.334545871840628 | 0.336713956129138 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 329488351628.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5ea9171a-7c42-4c42-88dd-377d77e56bc6 | 2026-08-24 09:30 | 2026-08-24 09:30 | 2026-08-24 09:30 | GE | GE261016C00340000 | call | 340.0000 | 2026-10-16 | 20.0700 | 19.6000 | 21.6000 | 346.5900 | 66246.00 | 0.00 | 66246.00 | 33 | 6 | 66 | 131 | 0.50381679389313 | 0.280892716113523 | 0.298650588036356 | true | false | false | true | ||||||||||||||||
| 45c0a665-4ace-47c8-a9a3-a65649211ba2 | 2026-08-24 09:34 | 2026-08-24 09:34 | 2026-08-24 09:34 | GE | GE261016C00340000 | call | 340.0000 | 2026-10-16 | 19.4900 | 18.7500 | 21.0000 | 344.4995 | 77941.00 | 0.00 | 77941.00 | 40 | 22 | 108 | 131 | 0.824427480916031 | 0.307248392400549 | 0.307248392400549 | false | false | false | true | ||||||||||||||||
| 75a5e8a3-1338-4831-a9b3-3f823f363eb8 | 2026-08-28 10:55 | 2026-08-28 10:55 | 2026-08-28 10:55 | GE | GE260904C00312500 | call | 312.5000 | 2026-09-04 | 31.3400 | 31.3000 | 32.8000 | 343.6900 | 59550.00 | 18810.00 | 6270.00 | 19 | 19 | 19 | 0 | 0 | 0.360692552001996 | 0.567009490982327 | true | false | false | true | ||||||||||||||||
| 49b9e9a1-3823-4a46-b3d3-40c832b5ac1e | 2026-08-28 13:54 | 2026-08-28 13:54 | 2026-08-28 13:54 | GE | GE261120C00340000 | call | 340.0000 | 2026-11-20 | 24.0900 | 23.1500 | 24.2000 | 341.7100 | 122865.00 | 91530.00 | 28920.00 | 51 | 13 | 57 | 167 | 0.341317365269461 | 0.333212317992008 | 0.334762792265783 | true | false | false | true | ||||||||||||||||
| cb7dd32c-7ec2-4fd1-97e9-8d504f55e629 | 2026-09-03 09:53 | 2026-09-03 09:52 | 2026-09-03 09:52 | GE | GE270115C00450000 | call | 450.0000 | 2027-01-15 | 2.2000 | 2.0600 | 2.4700 | 334.3000 | 91914.00 | 60712.00 | 1547.00 | 417 | 68 | 503 | 976 | 0.515368852459016 | 0.313212446270547 | 0.314189767408572 | false | false | false | true | ||||||||||||||||
| 063e659e-0008-4514-8409-6796889ee2de | 2026-09-11 10:02 | 2026-09-11 10:02 | 2026-09-11 10:02 | GE | GE261016P00310000 | put | 310.0000 | 2026-10-16 | 5.6000 | 5.6000 | 5.9500 | 325.0800 | 246990.00 | 0.00 | 246990.00 | 441 | 42 | 441 | 1400 | 0.315 | 0.306492674504949 | 0.306492674504949 | false | false | false | true | ||||||||||||||||
| 08e42b86-26bc-4190-b804-8c73f97c2f2f | 2026-09-11 10:43 | 2026-09-11 10:43 | 2026-09-11 10:43 | GE | GE270115C00360000 | call | 360.0000 | 2027-01-15 | 12.2500 | 11.9500 | 12.7000 | 323.3600 | 120070.00 | 2465.00 | 117605.00 | 98 | 23 | 98 | 895 | 0.109497206703911 | 0.314319082321213 | 0.316472338351324 | false | false | false | true | ||||||||||||||||
| 2e184b86-62dc-4900-8321-26c377290cae | 2026-09-15 15:29 | 2026-09-15 15:29 | 2026-09-15 15:29 | GE | GE261016P00310000 | put | 310.0000 | 2026-10-16 | 11.6700 | 11.4500 | 11.8000 | 307.8650 | 87538.00 | 87538.00 | 0.00 | 75 | 9 | 458 | 1837 | 0.249319542732716 | 0.310738469507069 | 0.309900309598979 | false | false | false | true | ||||||||||||||||
| 375d2722-85fb-4254-b117-e874b0139f0b | 2026-09-15 15:30 | 2026-09-15 15:30 | 2026-09-15 15:30 | GE | GE261016P00310000 | put | 310.0000 | 2026-10-16 | 11.7800 | 11.5500 | 11.8000 | 307.7800 | 88367.00 | 88367.00 | 0.00 | 75 | 13 | 533 | 1837 | 0.290146978769733 | 0.310953292694605 | 0.312909510603021 | false | false | false | true | ||||||||||||||||
| 0f4429df-570f-4fea-9ecb-376a5c0c903e | 2026-09-15 15:30 | 2026-09-15 15:30 | 2026-09-15 15:30 | GE | GE261016P00310000 | put | 310.0000 | 2026-10-16 | 11.7100 | 11.5500 | 11.7500 | 307.8450 | 67942.00 | 67942.00 | 0.00 | 58 | 6 | 633 | 1837 | 0.344583560152422 | 0.31129876704508 | 0.31129876704508 | false | false | false | true | ||||||||||||||||
| 736f674f-112a-4c16-b6cb-cbccd4633c88 | 2026-09-15 15:51 | 2026-09-15 15:51 | 2026-09-15 15:51 | GE | GE261016P00300000 | put | 300.0000 | 2026-10-16 | 7.4200 | 7.1500 | 7.5000 | 307.0000 | 222600.00 | 222600.00 | 0.00 | 300 | 16 | 467 | 461 | 1.01301518438178 | 0.319218507937252 | 0.32070808315253 | false | true | false | true | ||||||||||||||||
| 80c5783a-1bd3-413b-8e1f-4775ae603ed3 | 2026-09-21 11:08 | 2026-09-21 11:07 | 2026-09-21 11:07 | GE | GE261016P00280000 | put | 280.0000 | 2026-10-16 | 0.7500 | 0.6400 | 0.9800 | 318.7400 | 10597.00 | 170.00 | 10427.00 | 141 | 21 | 174 | 400 | 0.435 | 0.334967323005111 | 0.344685278247435 | false | false | false | true | ||||||||||||||||
| b75a00f8-2d5d-45ca-a017-256e3242d34b | 2026-09-21 11:28 | 2026-09-21 11:28 | 2026-09-21 11:28 | GE | GE270115C00350000 | call | 350.0000 | 2027-01-15 | 13.2400 | 12.9000 | 13.5000 | 318.6700 | 52953.00 | 52953.00 | 0.00 | 40 | 7 | 253 | 3027 | 0.083581103402709 | 0.325255142870524 | 0.325255142870524 | false | false | false | true | ||||||||||||||||
| 4a7ab2e7-57d1-405e-a392-b46b86736b32 | 2026-09-21 11:30 | 2026-09-21 11:30 | 2026-09-21 11:30 | GE | GE270115C00350000 | call | 350.0000 | 2027-01-15 | 13.1800 | 13.0000 | 13.4500 | 318.6000 | 65917.00 | 0.00 | 65917.00 | 50 | 6 | 303 | 3027 | 0.10009910802775 | 0.324891970495567 | 0.324891970495567 | false | false | false | true | ||||||||||||||||
| c923214b-6e8a-45af-81d4-e77783a28e20 | 2026-09-22 10:29 | 2026-09-22 10:29 | 2026-09-22 10:29 | GE | GE270115C00330000 | call | 330.0000 | 2027-01-15 | 18.5500 | 17.6500 | 19.8500 | 314.8500 | 20400.00 | 1850.00 | 18550.00 | 11 | 11 | 71 | 547 | 0.129798903107861 | 0.327997078467009 | 0.328709132720355 | false | false | false | true | ||||||||||||||||
| 6d341d1d-6584-404c-8fc5-70900f56abc3 | 2026-09-22 10:50 | 2026-09-22 10:50 | 2026-09-22 10:50 | GE | GE261120P00290000 | put | 290.0000 | 2026-11-20 | 7.1900 | 7.1000 | 7.4000 | 314.8750 | 11510.00 | 3645.00 | 7865.00 | 16 | 6 | 29 | 603 | 0.0480928689883914 | 0.359438690395793 | 0.363193481856847 | true | false | false | true | ||||||||||||||||
| 16f3f640-d528-48ba-bbba-df6b61353e43 | 2026-09-22 12:38 | 2026-09-22 12:38 | 2026-09-22 12:38 | GE | GE261120C00350000 | call | 350.0000 | 2026-11-20 | 7.0200 | 7.0000 | 7.1000 | 318.0950 | 24580.00 | 5680.00 | 18900.00 | 35 | 10 | 208 | 1445 | 0.143944636678201 | 0.33894571316121 | 0.341267660140732 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T18:18:32.282709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:11:33.656123Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 329488351628.00 |
| 2026-10-20 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 330992817272.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 330992817272.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 330992817272.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 331210705400.00 |
| 2026-10-20 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 331210705400.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 331210705400.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:42:20.042631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |