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 | 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 |
|---|
| ef86bcec-d3c2-4e1e-b08d-b9dadddc2e24 | 2026-09-23 13:22 | 2026-09-23 13:22 | 2026-09-23 13:22 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9500 | 0.9200 | 0.9500 | 13.5750 | 33345.00 | 33345.00 | 0.00 | 351 | 13 | 861 | 11994 | 0.0717858929464732 | 0.824119897199472 | 0.824119897199472 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 5157095615.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T17:25:27.822923Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| f850c13f-e3ce-4176-a9a5-4a03734a9962 | 2026-09-22 10:40 | 2026-09-22 10:40 | 2026-09-22 10:40 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 1.1000 | 1.0900 | 1.1100 | 13.8022 | 11000.00 | 8800.00 | 2200.00 | 100 | 10 | 602 | 11784 | 0.0510862186014936 | 0.831705047475466 | 0.831705047475466 | false | false | false | true | ||||||||||||||||
| dff3f15f-f3c7-4059-a3fa-0e0ca648d1ab | 2026-09-21 10:03 | 2026-09-21 10:03 | 2026-09-21 10:03 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 1.0000 | 0.9900 | 1.0200 | 13.4956 | 14200.00 | 0.00 | 14100.00 | 142 | 6 | 764 | 11303 | 0.0675926745111917 | 0.852287581469736 | 0.852287581469736 | false | false | false | true | ||||||||||||||||
| 3021677a-f420-455c-aa97-310a77f13f5e | 2026-09-18 15:59 | 2026-09-18 15:59 | 2026-09-18 15:59 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9200 | 0.9200 | 0.9400 | 13.0000 | 15640.00 | 0.00 | 15640.00 | 170 | 8 | 6402 | 7285 | 0.878792038435141 | 0.831249673327079 | 0.832813179379265 | false | false | false | true | ||||||||||||||||
| b8cd1fcd-9a89-49b5-bbc6-02174833e23c | 2026-09-18 15:32 | 2026-09-18 15:32 | 2026-09-18 15:32 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9200 | 0.9200 | 0.9400 | 13.2350 | 44620.00 | 0.00 | 44620.00 | 485 | 7 | 6157 | 7285 | 0.845161290322581 | 0.832813179379265 | 0.832813179379265 | false | false | false | true | ||||||||||||||||
| 8d5359d5-73ef-40cc-8148-6bb920b1a880 | 2026-09-18 13:12 | 2026-09-18 13:12 | 2026-09-18 13:12 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.7800 | 0.7800 | 0.8000 | 12.8401 | 17706.00 | 0.00 | 17706.00 | 227 | 7 | 4956 | 7285 | 0.680301990391215 | 0.851106864231457 | 0.853999278508681 | true | false | false | true | ||||||||||||||||
| 37859837-275a-423c-9282-c0bc72dae2aa | 2026-09-18 09:56 | 2026-09-18 09:56 | 2026-09-18 09:56 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.7000 | 0.7000 | 0.7100 | 12.5600 | 52710.00 | 0.00 | 52710.00 | 753 | 12 | 3081 | 7285 | 0.422923816060398 | 0.876054273227501 | 0.876054273227501 | false | false | false | true | ||||||||||||||||
| 406f3dd3-e7a6-4995-950e-a5e8de47c6fa | 2026-09-18 09:56 | 2026-09-18 09:56 | 2026-09-18 09:56 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.7000 | 0.7000 | 0.7100 | 12.5626 | 22470.00 | 0.00 | 22470.00 | 321 | 11 | 2286 | 7285 | 0.313795470144132 | 0.875312463314038 | 0.875312463314038 | false | false | false | true | ||||||||||||||||
| 0caa5173-f5db-4673-a151-46a90b3c1879 | 2026-09-18 09:56 | 2026-09-18 09:56 | 2026-09-18 09:56 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.7000 | 0.6900 | 0.7100 | 12.5700 | 61714.00 | 8094.00 | 53550.00 | 880 | 12 | 1965 | 7285 | 0.269732326698696 | 0.877708924607504 | 0.873200917944616 | false | false | false | true | ||||||||||||||||
| c3d8e10f-235e-4348-af27-d4b4bb383c84 | 2026-09-18 09:56 | 2026-09-18 09:55 | 2026-09-18 09:55 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.7000 | 0.7000 | 0.7100 | 12.5700 | 24010.00 | 0.00 | 24010.00 | 343 | 19 | 1085 | 7285 | 0.148936170212766 | 0.870147094008395 | 0.873200917944616 | false | false | false | true | ||||||||||||||||
| 717cf00d-de1e-4e6b-8026-482ad087140c | 2026-09-10 13:11 | 2026-09-10 13:10 | 2026-09-10 13:10 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.5400 | 0.5200 | 0.5500 | 11.6850 | 15606.00 | 15552.00 | 0.00 | 289 | 8 | 716 | 6239 | 0.114761981086713 | 0.868824821752395 | 0.868824821752395 | true | false | false | true | ||||||||||||||||
| b50681a2-45b2-49aa-ac32-2a6b133b0ca5 | 2026-09-03 10:56 | 2026-09-03 10:56 | 2026-09-03 10:56 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.6500 | 0.6400 | 0.6500 | 11.6200 | 22750.00 | 22750.00 | 0.00 | 350 | 7 | 1603 | 3810 | 0.420734908136483 | 0.885181848108923 | 0.885181848108923 | false | false | false | true | ||||||||||||||||
| 69dd40a9-af02-4f67-b46e-26f3dbfb6cac | 2026-09-03 10:56 | 2026-09-03 10:56 | 2026-09-03 10:56 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.6500 | 0.6400 | 0.6500 | 11.6215 | 16185.00 | 16185.00 | 0.00 | 249 | 6 | 1852 | 3810 | 0.486089238845144 | 0.884840578600492 | 0.884840578600492 | false | false | false | true | ||||||||||||||||
| aae376e5-56bd-429b-beaf-82b3bfcd99b4 | 2026-09-03 10:56 | 2026-09-03 10:56 | 2026-09-03 10:56 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.6500 | 0.6400 | 0.6500 | 11.6200 | 16250.00 | 16250.00 | 0.00 | 250 | 5 | 1253 | 3810 | 0.328871391076115 | 0.885181848108923 | 0.885181848108923 | false | false | false | true | ||||||||||||||||
| 74cf382a-9838-435f-9f00-1d9d138cb49f | 2026-08-25 12:49 | 2026-08-25 12:49 | 2026-08-25 12:49 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9500 | 0.9400 | 0.9500 | 11.9600 | 81890.00 | 81890.00 | 0.00 | 862 | 42 | 2431 | 897 | 2.71014492753623 | 0.91300531951758 | 0.909608058626082 | false | false | false | true | ||||||||||||||||
| a1935856-835a-44ce-a8b6-79bc43223a70 | 2026-08-25 12:32 | 2026-08-25 12:32 | 2026-08-25 12:32 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9500 | 0.9100 | 0.9500 | 11.9300 | 94905.00 | 94905.00 | 0.00 | 999 | 17 | 1046 | 897 | 1.16610925306577 | 0.916403613769821 | 0.916403613769821 | false | false | false | true | ||||||||||||||||
| 686b3503-09d3-4654-9ba6-d41de05f3809 | 2026-08-25 12:32 | 2026-08-25 12:32 | 2026-08-25 12:32 | MARA | MARA261016C00014000 | call | 14.0000 | 2026-10-16 | 0.9500 | 0.9400 | 0.9500 | 11.9350 | 47880.00 | 47880.00 | 0.00 | 504 | 8 | 1550 | 897 | 1.72798216276477 | 0.915270732118064 | 0.915270732118064 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 5265259418.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 5130054664.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 5114602692.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 5114602692.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 5114602692.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 5114602692.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 5114602692.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 5114602692.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 5114602692.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 4442441916.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T17:37:34.117542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 4442441916.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 4442441916.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 4442441916.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 4442441916.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 4442441916.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 4442441916.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |