uw_flow_alerts728,802 rows| 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 |
|---|
| 2365c734-4eb6-4380-a526-e8098b7e7bda | 2026-09-25 12:45 | 2026-09-25 12:45 | 2026-09-25 12:45 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 2.9400 | 2.9300 | 3.3500 | 202.3600 | 10891.00 | 610.00 | 10281.00 | 37 | 12 | 15377 | 8824 | 1.74263372620127 | 1.07387919420501 | 1.03556628139435 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 79400033604.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T16:52:03.026935Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 3f77482e-16e6-4fb1-ba26-bf64f19b8b3d | 2026-09-25 10:08 | 2026-09-25 10:08 | 2026-09-25 10:08 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 0.3800 | 0.3800 | 0.5000 | 192.0000 | 20086.00 | 0.00 | 19646.00 | 527 | 40 | 3924 | 8824 | 0.444696282864914 | 1.30230880045753 | 1.24553821904689 | false | false | false | |||||||||||||||||
| d6716148-e357-4783-9063-5631010d5c12 | 2026-09-24 15:10 | 2026-09-24 15:09 | 2026-09-24 15:09 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 2.0300 | 2.0100 | 2.1300 | 194.3200 | 11983.00 | 204.00 | 11779.00 | 59 | 10 | 11500 | 8133 | 1.41399237673675 | 1.04186971208939 | 1.04186971208939 | false | false | false | |||||||||||||||||
| e0a5b72a-4e43-4d31-865a-1b9d3654c446 | 2026-09-24 10:38 | 2026-09-24 10:38 | 2026-09-24 10:38 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 0.8400 | 0.7700 | 0.8800 | 187.9000 | 16723.00 | 16723.00 | 0.00 | 200 | 8 | 4030 | 8133 | 0.495512111152096 | 1.13774000412852 | 1.11178069050353 | false | false | false | |||||||||||||||||
| 50f647a1-12f0-4346-9eaa-278b235aba7f | 2026-09-23 11:28 | 2026-09-23 11:27 | 2026-09-23 11:27 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 1.0900 | 1.0000 | 1.1000 | 184.7600 | 10926.00 | 10926.00 | 0.00 | 100 | 8 | 10869 | 8199 | 1.32564946944749 | 1.01862738057346 | 1.0124989633056 | false | false | false | |||||||||||||||||
| 0a4e8937-4234-435f-b74d-7b1cb6635984 | 2026-09-23 09:58 | 2026-09-23 09:58 | 2026-09-23 09:58 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 2.3100 | 2.3900 | 2.5000 | 190.4200 | 47407.00 | 0.00 | 47407.00 | 205 | 10 | 5272 | 8199 | 0.643005244542017 | 1.04794149950738 | 1.03945632770352 | true | false | false | |||||||||||||||||
| 4993b0de-f321-4df0-9771-17f97eddddba | 2026-09-22 15:52 | 2026-09-22 15:52 | 2026-09-22 15:52 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 0.9200 | 0.9100 | 0.9300 | 182.5900 | 14354.00 | 9938.00 | 0.00 | 156 | 19 | 23403 | 3696 | 6.33198051948052 | 0.868769067818436 | 0.865950454259346 | false | false | false | |||||||||||||||||
| 9fed4042-c485-4ecd-a6c3-818729e83a3e | 2026-09-22 15:51 | 2026-09-22 15:51 | 2026-09-22 15:51 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 1.0200 | 1.0100 | 1.0700 | 182.8600 | 12701.00 | 1995.00 | 10706.00 | 125 | 26 | 23058 | 3696 | 6.23863636363636 | 0.891385775691022 | 0.880651074315417 | false | false | false | |||||||||||||||||
| 6c702093-2901-41cb-977f-be8e5a0d6034 | 2026-09-22 10:54 | 2026-09-22 10:53 | 2026-09-22 10:53 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 1.5100 | 1.4900 | 1.5500 | 183.6000 | 15066.00 | 0.00 | 15066.00 | 100 | 17 | 6930 | 3696 | 1.875 | 0.977572245256956 | 0.975275951275552 | true | false | false | |||||||||||||||||
| c3c3c83d-a4f7-4c5a-8117-d609889a7f25 | 2026-09-22 10:08 | 2026-09-22 10:08 | 2026-09-22 10:08 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 1.1500 | 1.1000 | 1.1600 | 179.3076 | 12976.00 | 6555.00 | 6308.00 | 113 | 15 | 3601 | 3696 | 0.974296536796537 | 1.05494689917408 | 1.05494689917408 | false | false | false | |||||||||||||||||
| bebaa2c0-63e2-4968-a07f-af6cc1a3538d | 2026-09-21 13:47 | 2026-09-21 13:46 | 2026-09-21 13:46 | MRNA | MRNA260925C00200000 | call | 200.0000 | 2026-09-25 | 1.1800 | 1.0700 | 1.2100 | 176.0000 | 11941.00 | 11186.00 | 755.00 | 101 | 5 | 4534 | 1334 | 3.39880059970015 | 1.00988365894471 | 1.0332757908518 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 79400033604.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:09:41.700516Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 72704847746.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:15:33.602136Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 72704847746.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:39:59.397883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 72704847746.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 72704847746.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:58:49.832976Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 72884503896.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 72884503896.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 72884503896.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 72884503896.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:10:05.607073Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 69043854644.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:50:05.863152Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |