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_alerts566,287 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 |
|---|
| e032eeb8-c893-4a4a-aa6f-f953094aff61 | 2026-08-18 11:29 | 2026-08-18 11:29 | 2026-08-18 11:29 | AU | AU261218C00100000 | call | 100.0000 | 2026-12-18 | 10.7200 | 9.5000 | 11.2000 | 97.3150 | 53589.00 | 49240.00 | 4349.00 | 50 | 20 | 53 | 483 | 0.109730848861284 | 0.504968677262543 | 0.518402302931015 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 50743150083.00 | 2026-11-10 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2891e8b2-2032-44f0-af00-853b081f404f | 2026-08-18 10:43 | 2026-08-18 10:43 | 2026-08-18 10:43 | HYMC | HYMC260918P00021000 | put | 21.0000 | 2026-09-18 | 0.9500 | 0.9500 | 1.0500 | 24.7500 | 42002.00 | 0.00 | 42002.00 | 442 | 41 | 445 | 133 | 3.34586466165414 | 0.904443094183632 | 0.904443094183632 | false | false | false | |||||||||||||||||
| 81a773e2-c1cd-4967-8283-d27d2cbff4c3 | 2026-08-18 10:20 | 2026-08-18 10:20 | 2026-08-18 10:20 | CC | CC280121C00025000 | call | 25.0000 | 2028-01-21 | 2.2900 | 2.0000 | 2.3500 | 15.1500 | 19445.00 | 19445.00 | 0.00 | 85 | 6 | 551 | 267 | 2.06367041198502 | 0.618323202713434 | 0.621164226099974 | true | false | false | |||||||||||||||||
| d1c577a4-3c6b-4203-aa05-ff7407bfdcc5 | 2026-08-18 10:20 | 2026-08-18 10:20 | 2026-08-18 10:20 | CC | CC280121C00025000 | call | 25.0000 | 2028-01-21 | 2.2400 | 2.0000 | 2.3500 | 15.1400 | 11215.00 | 11215.00 | 0.00 | 50 | 16 | 466 | 267 | 1.74531835205993 | 0.607504882683237 | 0.607504882683237 | false | false | false | |||||||||||||||||
| e10c4953-aa1f-4ddb-9928-3473e268ab09 | 2026-08-18 10:07 | 2026-08-18 10:07 | 2026-08-18 10:07 | CDE | CDE261218C00025000 | call | 25.0000 | 2026-12-18 | 1.2400 | 1.1500 | 1.2500 | 18.9001 | 116750.00 | 115550.00 | 0.00 | 938 | 22 | 947 | 1598 | 0.59261576971214 | 0.668238518858927 | 0.681160315049722 | false | false | false | |||||||||||||||||
| 1db664a4-1586-45bd-9677-3c3c39d6fa61 | 2026-08-18 10:06 | 2026-08-18 10:06 | 2026-08-18 10:06 | CRML | CRML261120C00015000 | call | 15.0000 | 2026-11-20 | 0.1000 | 0.1000 | 0.2000 | 6.2900 | 44450.00 | 0.00 | 44450.00 | 4443 | 52 | 4443 | 15589 | 0.285008659952531 | 1.02334391718054 | 1.02334391718054 | false | false | false | |||||||||||||||||
| 360fa2ab-5c11-4050-85c0-01826227a642 | 2026-08-18 09:58 | 2026-08-18 09:58 | 2026-08-18 09:58 | LWLG | LWLG280121C00010000 | call | 10.0000 | 2028-01-21 | 2.9100 | 2.9000 | 3.3000 | 6.8745 | 21835.00 | 0.00 | 21835.00 | 75 | 11 | 75 | 2597 | 0.0288794763188294 | 1.13186693790552 | 1.14772987228192 | true | false | false | |||||||||||||||||
| 3400abc3-8829-4016-91c8-bdc5264f4bd8 | 2026-08-17 14:48 | 2026-08-17 14:47 | 2026-08-17 14:47 | PAAS | PAAS260918C00050000 | call | 50.0000 | 2026-09-18 | 1.9500 | 1.9500 | 2.3000 | 48.1819 | 192964.00 | 0.00 | 192964.00 | 989 | 40 | 1086 | 1810 | 0.6 | 0.463123755241975 | 0.47140378058085 | true | false | false | |||||||||||||||||
| aee9d5d7-0b4d-4c2b-9f7e-578a2ba2b49d | 2026-08-17 14:33 | 2026-08-17 14:33 | 2026-08-17 14:33 | SA | SA261120C00030000 | call | 30.0000 | 2026-11-20 | 6.0000 | 5.7000 | 6.3000 | 32.6200 | 600012.00 | 137400.00 | 107412.00 | 1000 | 52 | 1679 | 2862 | 0.586652690426275 | 0.69340409857903 | 0.695633199211374 | false | false | false | |||||||||||||||||
| b4d70cc2-cdc9-4f76-a8b8-89bc67e550e6 | 2026-08-17 13:07 | 2026-08-17 13:07 | 2026-08-17 13:07 | EGO | EGO270319C00055000 | call | 55.0000 | 2027-03-19 | 3.3200 | 2.5000 | 3.5000 | 40.8800 | 94025.00 | 94025.00 | 0.00 | 283 | 6 | 283 | 102 | 2.77450980392157 | 0.562818004532222 | 0.562818004532222 | false | false | false | |||||||||||||||||
| 19ceb0c4-f05c-4d5c-a7c1-abcbf06513a5 | 2026-08-17 13:04 | 2026-08-17 13:04 | 2026-08-17 13:04 | FCX | FCX261218C00075000 | call | 75.0000 | 2026-12-18 | 5.7000 | 5.4500 | 5.7000 | 68.7200 | 113998.00 | 113998.00 | 0.00 | 200 | 7 | 2932 | 4270 | 0.686651053864169 | 0.488891825254759 | 0.490157422368222 | false | false | false | |||||||||||||||||
| d2f70c29-91a0-4be2-a29f-1c34e8069f0c | 2026-08-17 12:22 | 2026-08-17 12:22 | 2026-08-17 12:22 | AA | AA261016C00055000 | call | 55.0000 | 2026-10-16 | 2.9000 | 2.8300 | 2.9100 | 51.3900 | 43241.00 | 42661.00 | 0.00 | 149 | 25 | 231 | 2329 | 0.0991841992271361 | 0.506980709433882 | 0.508207218725546 | false | false | false | |||||||||||||||||
| f1b020d3-ebba-46d7-be41-0f1458b2d005 | 2026-08-17 11:53 | 2026-08-17 11:53 | 2026-08-17 11:53 | EXK | EXK270115C00010000 | call | 10.0000 | 2027-01-15 | 2.1000 | 2.1000 | 2.1500 | 10.2350 | 10516.00 | 0.00 | 10516.00 | 50 | 5 | 176 | 18053 | 0.00974907217636958 | 0.742868971802433 | 0.750890992379647 | false | false | false | |||||||||||||||||
| d9702076-0cd9-4abb-8e2e-3053bc8c80f2 | 2026-08-17 11:41 | 2026-08-17 11:41 | 2026-08-17 11:41 | FCX | FCX270617C00080000 | call | 80.0000 | 2027-06-17 | 8.9000 | 8.4500 | 8.9000 | 68.5100 | 112090.00 | 112090.00 | 0.00 | 126 | 12 | 173 | 540 | 0.32037037037037 | 0.48823335322356 | 0.488634775352923 | false | false | false | |||||||||||||||||
| bf247944-0754-4b52-95e0-cb207ca0cd14 | 2026-08-17 11:25 | 2026-08-17 11:25 | 2026-08-17 11:25 | CDE | CDE261120C00020000 | call | 20.0000 | 2026-11-20 | 2.4500 | 2.4500 | 2.5000 | 19.4301 | 156833.00 | 0.00 | 156833.00 | 640 | 35 | 664 | 9388 | 0.0707285896889646 | 0.662038493594998 | 0.662038493594998 | false | false | false | |||||||||||||||||
| de7d0682-493f-4536-a44e-38084aeac59c | 2026-08-17 11:02 | 2026-08-17 11:02 | 2026-08-17 11:02 | ALB | ALB270115C00125000 | call | 125.0000 | 2027-01-15 | 22.1400 | 22.1000 | 22.5500 | 133.4000 | 11068.00 | 2215.00 | 8853.00 | 5 | 5 | 5 | 391 | 0.0127877237851662 | 0.499830844093207 | 0.502376714893345 | false | false | false | |||||||||||||||||
| fcd1d944-caa0-41cf-bf01-ec2953c296fe | 2026-08-17 10:43 | 2026-08-17 10:43 | 2026-08-17 10:43 | PAAS | PAAS260828P00045500 | put | 45.5000 | 2026-08-28 | 0.6000 | 0.6000 | 0.7500 | 48.1600 | 18068.00 | 0.00 | 18068.00 | 300 | 6 | 304 | 69 | 4.40579710144928 | 0.493663080578805 | 0.506823472402781 | false | false | false | |||||||||||||||||
| aadcd22d-65be-4c6e-8424-432c109184f1 | 2026-08-17 10:40 | 2026-08-17 10:40 | 2026-08-17 10:40 | AGI | AGI270521C00040000 | call | 40.0000 | 2027-05-21 | 4.6600 | 4.0000 | 4.8000 | 34.5286 | 10262.00 | 10262.00 | 0.00 | 22 | 6 | 32 | 20 | 1.6 | 0.521372829513768 | 0.521372829513768 | false | false | false | true | ||||||||||||||||
| 47c3f7ec-59ec-4a7b-8876-aabf42957ded | 2026-08-17 10:03 | 2026-08-17 10:03 | 2026-08-17 10:03 | MP | MP261218C00055000 | call | 55.0000 | 2026-12-18 | 9.8000 | 9.8000 | 10.3000 | 56.7550 | 176414.00 | 0.00 | 176414.00 | 180 | 21 | 189 | 901 | 0.20976692563818 | 0.665475187880321 | 0.665475187880321 | false | false | false | |||||||||||||||||
| 5e7f12dc-0f78-4484-ac94-9937a0144ff6 | 2026-08-17 09:51 | 2026-08-17 09:51 | 2026-08-17 09:51 | CRML | CRML280121C00007500 | call | 7.5000 | 2028-01-21 | 2.6000 | 2.4500 | 2.6000 | 6.6040 | 34059.00 | 34059.00 | 0.00 | 131 | 7 | 138 | 2817 | 0.0489882854100106 | 0.905988530906264 | 0.909550873336443 | false | false | false | |||||||||||||||||
| 8f1964b7-e34b-4d68-81f2-a0a7a429fd4a | 2026-08-17 09:47 | 2026-08-17 09:47 | 2026-08-17 09:47 | GROY | GROY260918P00003000 | put | 3.0000 | 2026-09-18 | 0.1100 | 0.0500 | 0.2000 | 3.1400 | 10798.00 | 1300.00 | 9498.00 | 1000 | 12 | 1000 | 100 | 10 | 0.454008340379364 | 0.483482684278076 | false | false | false | |||||||||||||||||
| a9b3cef8-be42-40bc-99c8-ee107e9e6dc1 | 2026-08-17 09:38 | 2026-08-17 09:38 | 2026-08-17 09:38 | ALM | ALM260821C00015000 | call | 15.0000 | 2026-08-21 | 1.5400 | 1.5000 | 1.8000 | 16.3800 | 14000.00 | 0.00 | 7335.00 | 91 | 8 | 426 | 2527 | 0.168579343094579 | 0.840610835717356 | 0.840610835717356 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 1914883545.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 2194275347.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 2194275347.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 738461151.00 |
| 2026-11-13 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20518640317.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 2721541532.00 |
| 2026-09-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 8173162603.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 99573455045.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 12390548443.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 2549787948.00 |
| 2026-11-06 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 99573455045.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20435347760.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 13574121707.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 20518640317.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 14972234131.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 9026188480.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 677737030.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 754422336.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Basic Materials |
| 3862810552.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |