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 | strikenumeric |
|---|
| 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 |
|---|
| ae1bcf92-ef80-4706-b427-ba81c77be5c3 | 2026-09-28 10:00 | 2026-09-28 10:00 | 2026-09-28 10:00 | BLLN | BLLN261218C00130000 | call | 130.0000 | 2026-12-18 | 13.5000 | 11.5000 | 13.5000 | 122.9000 | 86400.00 | 86400.00 | 0.00 | 64 | 5 | 64 | 15 | 4.26666666666667 | 0.691217678345203 | 0.691217678345203 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | Healthcare | 5190674907.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T14:03:25.739526Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 949c64a0-18bd-4ede-8542-d9499d87c883 | 2026-09-25 13:30 | 2026-09-25 13:29 | 2026-09-25 13:29 | BLLN | BLLN261218P00085000 | put | 85.0000 | 2026-12-18 | 2.5000 | 1.5000 | 2.5000 | 125.3400 | 21737.00 | 21737.00 | 0.00 | 87 | 19 | 89 | 55 | 1.61818181818182 | 0.750309204050177 | 0.750309204050177 | false | false | false | |||||||||||||||||
| 91cd912d-5836-463c-9662-c582fabfbc0f | 2026-09-24 14:59 | 2026-09-24 14:59 | 2026-09-24 14:59 | BLLN | BLLN261218C00170000 | call | 170.0000 | 2026-12-18 | 4.8000 | 3.0000 | 4.8000 | 126.6800 | 16320.00 | 16320.00 | 0.00 | 34 | 14 | 835 | 6 | 139.166666666667 | 0.665557203448286 | 0.665557203448286 | false | false | false | |||||||||||||||||
| 7fa1c852-f48c-455f-a3c5-cb4fdf89153c | 2026-09-24 14:59 | 2026-09-24 14:58 | 2026-09-24 14:58 | BLLN | BLLN261218C00170000 | call | 170.0000 | 2026-12-18 | 4.7900 | 3.0000 | 4.9000 | 126.6800 | 383200.00 | 383200.00 | 0.00 | 800 | 2 | 801 | 6 | 133.5 | 0.660208672941492 | 0.660208672941492 | false | true | false | |||||||||||||||||
| 796e962e-4d3a-4c16-a469-5b29dd9ca670 | 2026-09-24 10:07 | 2026-09-24 10:07 | 2026-09-24 10:07 | BLLN | BLLN261016C00125000 | call | 125.0000 | 2026-10-16 | 5.2900 | 3.0000 | 5.3000 | 119.4100 | 37010.00 | 37010.00 | 0.00 | 70 | 19 | 70 | 286 | 0.244755244755245 | 0.632458014439702 | 0.641179507724972 | true | false | false | |||||||||||||||||
| 0f1d8bde-0bf9-481d-9608-c5662a53e878 | 2026-09-22 13:34 | 2026-09-22 13:34 | 2026-09-22 13:34 | BLLN | BLLN270319C00115000 | call | 115.0000 | 2027-03-19 | 22.7000 | 21.8000 | 24.3000 | 116.0000 | 11350.00 | 0.00 | 11350.00 | 5 | 5 | 24 | 3 | 8 | 0.663872716374774 | 0.663872716374774 | false | false | false | |||||||||||||||||
| 620933d2-8c5a-493a-94a0-5fd48e7758f6 | 2026-09-22 12:31 | 2026-09-22 12:30 | 2026-09-22 12:30 | BLLN | BLLN261016C00110000 | call | 110.0000 | 2026-10-16 | 9.8900 | 8.6000 | 10.8000 | 115.4400 | 79120.00 | 59340.00 | 19780.00 | 80 | 5 | 102 | 49 | 2.08163265306122 | 0.587955896910751 | 0.577019374359862 | false | false | false | |||||||||||||||||
| 89b74a04-4ceb-4851-ae36-72700d2c8ce6 | 2026-09-21 11:35 | 2026-09-21 11:35 | 2026-09-21 11:35 | BLLN | BLLN261016P00105000 | put | 105.0000 | 2026-10-16 | 5.4000 | 4.9000 | 5.4000 | 105.0000 | 23220.00 | 5400.00 | 0.00 | 43 | 15 | 146 | 13 | 11.2307692307692 | 0.541978271667409 | 0.541978271667409 | false | false | false | |||||||||||||||||
| f740e221-1716-423f-8c94-6d6d3d8214cb | 2026-09-21 11:35 | 2026-09-21 11:35 | 2026-09-21 11:35 | BLLN | BLLN261016P00105000 | put | 105.0000 | 2026-10-16 | 5.5000 | 4.7000 | 5.5000 | 105.0000 | 51700.00 | 550.00 | 0.00 | 94 | 19 | 97 | 13 | 7.46153846153846 | 0.523305980883875 | 0.523305980883875 | false | false | false | |||||||||||||||||
| 32067894-b69e-478b-9aca-dbdc40e4aba9 | 2026-09-17 12:57 | 2026-09-17 12:57 | 2026-09-17 12:57 | BLLN | BLLN261218C00135000 | call | 135.0000 | 2026-12-18 | 5.1500 | 4.8000 | 7.7000 | 108.7350 | 154500.00 | 0.00 | 154500.00 | 300 | 2 | 300 | 3 | 100 | 0.594385231096319 | 0.594385231096319 | false | true | false | |||||||||||||||||
| 20506e42-325f-4baa-b2f3-d9bd4b75c34a | 2026-09-15 10:40 | 2026-09-15 10:40 | 2026-09-15 10:40 | BLLN | BLLN261016C00105000 | call | 105.0000 | 2026-10-16 | 6.0000 | 5.3000 | 6.0000 | 102.5350 | 18600.00 | 18600.00 | 0.00 | 31 | 22 | 33 | 1 | 33 | 0.582077242309414 | 0.582077242309414 | false | false | false | |||||||||||||||||
| 4f3de3e2-300d-4080-b279-e702d1f8b0df | 2026-09-15 09:40 | 2026-09-15 09:40 | 2026-09-15 09:40 | BLLN | BLLN260918C00100000 | call | 100.0000 | 2026-09-18 | 4.8000 | 3.4000 | 5.7000 | 103.3900 | 48000.00 | 48000.00 | 0.00 | 100 | 6 | 100 | 342 | 0.292397660818713 | 0.750054055045553 | 0.750054055045553 | false | false | false | |||||||||||||||||
| 527b65b9-e595-4fef-9799-c69259d1af70 | 2026-08-26 11:14 | 2026-08-26 11:14 | 2026-08-26 11:14 | BLLN | BLLN270319C00100000 | call | 100.0000 | 2027-03-19 | 20.4000 | 20.4000 | 21.5000 | 97.4800 | 10200.00 | 0.00 | 10200.00 | 5 | 5 | 5 | 92 | 0.0543478260869565 | 0.712286370734762 | 0.712286370734762 | false | false | false | |||||||||||||||||
| adc816e2-8fa7-4834-af25-b92401fc180f | 2026-08-21 11:11 | 2026-08-21 11:11 | 2026-08-21 11:11 | BLLN | BLLN260918P00100000 | put | 100.0000 | 2026-09-18 | 7.0000 | 6.8000 | 8.1000 | 97.3250 | 35000.00 | 3500.00 | 3500.00 | 50 | 18 | 50 | 34 | 1.47058823529412 | 0.528311594629191 | 0.528311594629191 | false | false | false | |||||||||||||||||
| d715684b-1784-45b7-980f-5912f5567525 | 2026-08-20 11:54 | 2026-08-20 11:54 | 2026-08-20 11:54 | BLLN | BLLN260918C00100000 | call | 100.0000 | 2026-09-18 | 3.8000 | 2.4000 | 4.8000 | 94.9000 | 38000.00 | 380.00 | 29640.00 | 100 | 23 | 101 | 77 | 1.31168831168831 | 0.539114643672361 | 0.539114643672361 | false | false | false | |||||||||||||||||
| ab1cf832-4985-4fc6-b111-62fab491a5e3 | 2026-08-19 10:51 | 2026-08-19 10:50 | 2026-08-19 10:50 | BLLN | BLLN260918C00095000 | call | 95.0000 | 2026-09-18 | 5.1000 | 3.2000 | 6.7000 | 92.7000 | 16830.00 | 2040.00 | 14790.00 | 33 | 5 | 120 | 66 | 1.81818181818182 | 0.565143675168153 | 0.565143675168153 | false | false | false | |||||||||||||||||
| 7abad377-9150-4643-a7b2-fd582f85056a | 2026-08-19 09:36 | 2026-08-19 09:36 | 2026-08-19 09:36 | BLLN | BLLN260918C00095000 | call | 95.0000 | 2026-09-18 | 4.8000 | 3.2000 | 6.5000 | 91.9200 | 25440.00 | 24960.00 | 480.00 | 53 | 7 | 70 | 66 | 1.06060606060606 | 0.571456851269154 | 0.571456851269154 | false | false | false | |||||||||||||||||
| 0b86cc7d-257f-4cd2-93f5-48059ec568c5 | 2026-08-17 10:06 | 2026-08-17 10:06 | 2026-08-17 10:06 | BLLN | BLLN260821C00095000 | call | 95.0000 | 2026-08-21 | 2.2000 | 1.3000 | 3.3000 | 95.1300 | 15400.00 | 220.00 | 12320.00 | 70 | 15 | 72 | 273 | 0.263736263736264 | 0.532693253006473 | 0.532693253006473 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| Healthcare |
| 5248671275.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:33:28.969909Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4879370875.00 |
| 2026-12-08 |
| 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 |
| true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4879370875.00 |
| 2026-12-08 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| — |
| Healthcare |
| 4879370875.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4949734115.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4949734115.00 |
| 2026-12-08 |
| 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 |
| — |
| Healthcare |
| 4429046138.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:36:47.844885Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4429046138.00 |
| 2026-12-08 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:36:47.844885Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4719454420.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4299407198.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4299407198.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4299407198.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4299407198.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4299407198.00 |
| 2026-12-08 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4299407198.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4299407198.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| Healthcare |
| 4299407198.00 |
| 2026-12-08 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |