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_alerts609,118 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 |
|---|
| 451bbf6c-eac4-4df3-9a76-e1f9e53eba2f | 2026-09-18 10:56 | 2026-09-18 10:56 | 2026-09-18 10:56 | SBET | SBET261016C00011000 | call | 11.0000 | 2026-10-16 | 0.3600 | 0.3300 | 0.3700 | 9.2300 | 24705.00 | 24705.00 | 0.00 | 683 | 32 | 1645 | 8518 | 0.193120450810049 | 0.88952828925476 | 0.90932386877737 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 2031040697.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 984cddc8-78a3-43f9-8111-b552bbf3046c | 2026-09-18 10:56 | 2026-09-18 10:56 | 2026-09-18 10:56 | SBET | SBET261016C00011000 | call | 11.0000 | 2026-10-16 | 0.3600 | 0.3300 | 0.3700 | 9.2123 | 15466.00 | 15466.00 | 0.00 | 428 | 10 | 962 | 8518 | 0.112937309227518 | 0.903640490397484 | 0.903640490397484 | false | false | false | |||||||||||||||||
| b649763a-c88c-470f-9be7-0be7eb833f2d | 2026-09-18 10:22 | 2026-09-18 10:22 | 2026-09-18 10:22 | SBET | SBET260925C00009500 | call | 9.5000 | 2026-09-25 | 0.2500 | 0.2200 | 0.2500 | 8.9550 | 37432.00 | 37432.00 | 0.00 | 1500 | 35 | 1573 | 228 | 6.89912280701754 | 0.906717056260511 | 0.924830738041033 | false | false | false | |||||||||||||||||
| da2538bc-fe6a-4acc-aa05-73ff9f8fa84e | 2026-09-16 14:52 | 2026-09-16 14:52 | 2026-09-16 14:52 | SBET | SBET280121C00010000 | call | 10.0000 | 2028-01-21 | 2.3100 | 2.2900 | 2.6000 | 7.9100 | 25161.00 | 9252.00 | 13149.00 | 109 | 9 | 371 | 12608 | 0.0294257614213198 | 0.771028740913365 | 0.771028740913365 | true | false | false | |||||||||||||||||
| 0d58aa65-9611-4cb8-bf70-758c5f09ad92 | 2026-09-11 11:56 | 2026-09-11 11:56 | 2026-09-11 11:56 | SBET | SBET260918P00009000 | put | 9.0000 | 2026-09-18 | 0.3400 | 0.2900 | 0.3400 | 9.1800 | 17126.00 | 17126.00 | 0.00 | 510 | 11 | 1037 | 877 | 1.1824401368301 | 0.830606818436333 | 0.830606818436333 | false | false | false | |||||||||||||||||
| 09deff52-e5c2-46ea-9532-b9318cf2d206 | 2026-09-11 11:34 | 2026-09-11 11:34 | 2026-09-11 11:34 | SBET | SBET261120C00010000 | call | 10.0000 | 2026-11-20 | 1.2000 | 1.1500 | 1.2000 | 9.3550 | 50320.00 | 10600.00 | 0.00 | 420 | 5 | 1205 | 1376 | 0.875726744186046 | 0.870464548261114 | 0.876587226396646 | true | false | false | |||||||||||||||||
| b9f207da-5157-4a5d-9869-40caf140307b | 2026-09-11 10:54 | 2026-09-11 10:54 | 2026-09-11 10:54 | SBET | SBET261016C00011000 | call | 11.0000 | 2026-10-16 | 0.4600 | 0.4500 | 0.4800 | 9.2950 | 13511.00 | 12926.00 | 585.00 | 294 | 6 | 1606 | 3185 | 0.504238618524333 | 0.871617791117962 | 0.871617791117962 | true | false | false | |||||||||||||||||
| cd0ec3fb-50dc-4d6f-a3ac-eb5734aef4e8 | 2026-09-11 10:41 | 2026-09-11 10:41 | 2026-09-11 10:41 | SBET | SBET280121C00013000 | call | 13.0000 | 2028-01-21 | 2.5200 | 2.4200 | 2.5300 | 9.1500 | 27212.00 | 21920.00 | 5292.00 | 108 | 17 | 221 | 31634 | 0.00698615413795284 | 0.801547645457525 | 0.811050787397894 | false | false | false | |||||||||||||||||
| ab4c050b-ec53-4e2c-b931-34a2d99a6f3a | 2026-09-02 15:03 | 2026-09-02 15:03 | 2026-09-02 15:03 | SBET | SBET270115P00003000 | put | 3.0000 | 2027-01-15 | 0.0600 | 0.0200 | 0.0600 | 8.2000 | 22646.00 | 22646.00 | 0.00 | 4108 | 7 | 5000 | 8181 | 0.611172228333944 | 0.978448018017194 | 0.978448018017194 | false | false | false | |||||||||||||||||
| f05daf5d-f9fa-4c1c-ac3e-7aba424e8bf1 | 2026-09-02 13:03 | 2026-09-02 13:02 | 2026-09-02 13:02 | SBET | SBET270416C00015000 | call | 15.0000 | 2027-04-16 | 0.7600 | 0.6800 | 0.7900 | 8.1500 | 11676.00 | 11676.00 | 0.00 | 153 | 6 | 330 | 877 | 0.376282782212087 | 0.857206527405769 | 0.870626018209233 | false | false | false | |||||||||||||||||
| 26df5325-074c-4cad-8d8e-420f88c008b5 | 2026-09-01 11:39 | 2026-09-01 11:39 | 2026-09-01 11:39 | SBET | SBET261002C00011000 | call | 11.0000 | 2026-10-02 | 0.1500 | 0.1400 | 0.1600 | 8.3100 | 14786.00 | 0.00 | 14786.00 | 1000 | 48 | 1000 | 340 | 2.94117647058824 | 0.819117423389663 | 0.840551699509186 | false | false | false | |||||||||||||||||
| cc7f4533-d1a9-495a-85b8-6f74c8ce5128 | 2026-08-26 12:16 | 2026-08-26 12:16 | 2026-08-26 12:16 | SBET | SBET281215C00010000 | call | 10.0000 | 2028-12-15 | 3.5500 | 3.3500 | 3.5500 | 8.2050 | 10648.00 | 10648.00 | 0.00 | 30 | 5 | 54 | 4723 | 0.0114334109676053 | 0.804800848245282 | 0.804800848245282 | false | false | false | |||||||||||||||||
| 16d00fad-b6d2-4d18-8055-c6d7120f2d13 | 2026-08-24 11:03 | 2026-08-24 11:03 | 2026-08-24 11:03 | SBET | SBET270416C00011000 | call | 11.0000 | 2027-04-16 | 1.6200 | 1.5300 | 1.6500 | 8.4450 | 40514.00 | 40514.00 | 0.00 | 250 | 8 | 255 | 57 | 4.47368421052632 | 0.865295897677632 | 0.865295897677632 | false | false | false | |||||||||||||||||
| 1ac25730-f99e-412a-b9ec-da7b981ca561 | 2026-08-20 10:03 | 2026-08-20 10:03 | 2026-08-20 10:03 | SBET | SBET260821C00007000 | call | 7.0000 | 2026-08-21 | 0.4500 | 0.4200 | 0.4800 | 7.3900 | 32285.00 | 9000.00 | 22925.00 | 713 | 10 | 9820 | 5408 | 1.81582840236686 | 1.05007536588093 | 1.30269620812835 | true | false | false | |||||||||||||||||
| 5a851e4c-a78c-4514-bfd4-285407827c65 | 2026-08-19 11:34 | 2026-08-19 11:33 | 2026-08-19 11:33 | SBET | SBET280121C00008000 | call | 8.0000 | 2028-01-21 | 2.5400 | 2.5300 | 2.6100 | 7.0850 | 16026.00 | 14756.00 | 1270.00 | 63 | 10 | 749 | 18462 | 0.0405698190878561 | 0.825221733968948 | 0.828474166774716 | false | false | false | |||||||||||||||||
| 2559d530-0740-4876-aec7-99d9d80acc2a | 2026-08-19 10:50 | 2026-08-19 10:50 | 2026-08-19 10:50 | SBET | SBET261016C00008000 | call | 8.0000 | 2026-10-16 | 0.4600 | 0.4300 | 0.4700 | 6.7600 | 11616.00 | 11616.00 | 0.00 | 250 | 13 | 312 | 3171 | 0.098391674550615 | 0.806931571166279 | 0.816786543189107 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2031040697.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2031040697.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1733444360.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:20:29.379987Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:08:56.003529Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1987595977.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |