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 |
|---|
| 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 |
|---|
| 4bfd3eb7-4ab4-4d29-85c3-849583661947 | 2026-08-26 09:40 | 2026-08-26 09:40 | 2026-08-26 09:40 | LUV | LUV261016C00042500 | call | 42.5000 | 2026-10-16 | 1.8700 | 1.6500 | 2.0800 | 41.3300 | 69200.00 | 19645.00 | 187.00 | 370 | 6 | 370 | 583 | 0.634648370497427 | 0.364962462165649 | 0.372794265407224 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 19333508104.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 79a1e0f3-2b0c-4524-ae5b-dc01c777e193 | 2026-08-25 11:35 | 2026-08-25 11:35 | 2026-08-25 11:35 | LUV | LUV260918P00045000 | put | 45.0000 | 2026-09-18 | 4.7000 | 4.7000 | 5.0000 | 40.5900 | 27730.00 | 0.00 | 27730.00 | 59 | 5 | 64 | 3721 | 0.0171996775060468 | 0.408942103547203 | 0.408942103547203 | false | false | false | true | ||||||||||||||||
| 8d2e5132-77e2-4620-a4e7-b40161c5b8f0 | 2026-08-24 14:14 | 2026-08-24 14:14 | 2026-08-24 14:14 | LUV | LUV261218P00040000 | put | 40.0000 | 2026-12-18 | 3.2500 | 3.1500 | 3.4500 | 40.6950 | 19175.00 | 14950.00 | 4225.00 | 59 | 9 | 64 | 416 | 0.153846153846154 | 0.42398380427535 | 0.42398380427535 | false | false | false | true | ||||||||||||||||
| b56b6d60-0489-434c-bc39-cf4c9d14b69a | 2026-08-24 13:47 | 2026-08-24 13:47 | 2026-08-24 13:47 | LUV | LUV260918C00041000 | call | 41.0000 | 2026-09-18 | 1.2700 | 1.2700 | 1.4000 | 40.3500 | 11727.00 | 0.00 | 11727.00 | 92 | 13 | 115 | 0 | 0 | 0.357813428292233 | 0.360020524967333 | false | false | false | true | false | |||||||||||||||
| d2cdf5cf-5a07-4e73-899b-fd31c462dcb9 | 2026-08-24 11:05 | 2026-08-24 11:05 | 2026-08-24 11:05 | LUV | LUV261016C00042500 | call | 42.5000 | 2026-10-16 | 1.5200 | 1.4700 | 1.5200 | 40.3600 | 31920.00 | 31920.00 | 0.00 | 210 | 5 | 229 | 380 | 0.602631578947368 | 0.374747008765705 | 0.374747008765705 | false | false | false | true | ||||||||||||||||
| 2e7d892b-41b0-4695-93ce-c98f3f83bba4 | 2026-08-24 10:04 | 2026-08-24 10:04 | 2026-08-24 10:04 | LUV | LUV260918C00042500 | call | 42.5000 | 2026-09-18 | 0.7900 | 0.7900 | 0.8500 | 40.4899 | 21567.00 | 0.00 | 21567.00 | 273 | 26 | 306 | 3905 | 0.0783610755441741 | 0.360564742897865 | 0.360564742897865 | false | false | false | true | ||||||||||||||||
| c6642661-7dfd-43b5-9c1a-20f08fccc682 | 2026-08-21 13:26 | 2026-08-21 13:26 | 2026-08-21 13:26 | LUV | LUV260918P00040000 | put | 40.0000 | 2026-09-18 | 1.6400 | 1.5400 | 1.6400 | 40.0900 | 11152.00 | 11152.00 | 0.00 | 68 | 6 | 473 | 4808 | 0.0983777038269551 | 0.394297083919158 | 0.394297083919158 | false | false | false | true | ||||||||||||||||
| 157d4e4b-5ef3-4906-bf35-1761a5fbc12a | 2026-08-21 13:25 | 2026-08-21 13:25 | 2026-08-21 13:25 | LUV | LUV260918C00040000 | call | 40.0000 | 2026-09-18 | 1.6700 | 1.6700 | 1.7200 | 40.1000 | 74483.00 | 0.00 | 74483.00 | 446 | 22 | 684 | 2513 | 0.272184639872662 | 0.353033882494522 | 0.355303075885381 | false | false | false | true | ||||||||||||||||
| 8221afac-b0cd-4648-b00f-549d968c895a | 2026-08-20 15:40 | 2026-08-20 15:40 | 2026-08-20 15:40 | LUV | LUV270617P00027500 | put | 27.5000 | 2027-06-17 | 1.3500 | 1.3200 | 1.3500 | 39.9300 | 12285.00 | 12285.00 | 0.00 | 91 | 9 | 1400 | 57 | 24.5614035087719 | 0.483025523762004 | 0.483025523762004 | false | false | false | true | ||||||||||||||||
| 324fdf76-058f-40e0-846d-bbbc0ad51805 | 2026-08-20 15:40 | 2026-08-20 15:40 | 2026-08-20 15:40 | LUV | LUV261218C00045000 | call | 45.0000 | 2026-12-18 | 1.9000 | 1.9000 | 1.9900 | 39.9200 | 21090.00 | 0.00 | 21090.00 | 111 | 7 | 266 | 1115 | 0.238565022421525 | 0.387702823323432 | 0.387702823323432 | false | false | false | true | ||||||||||||||||
| ee3f6501-30ce-4951-9c1e-a01a0007d174 | 2026-08-20 14:51 | 2026-08-20 14:51 | 2026-08-20 14:51 | LUV | LUV260918C00042500 | call | 42.5000 | 2026-09-18 | 0.7500 | 0.7300 | 0.8700 | 40.1150 | 97500.00 | 0.00 | 97500.00 | 1300 | 6 | 1701 | 3691 | 0.460850717962612 | 0.353241319853788 | 0.353241319853788 | false | true | false | true | ||||||||||||||||
| a47c1519-9e8f-43ea-9025-2e7db1333ee8 | 2026-08-20 11:32 | 2026-08-20 11:32 | 2026-08-20 11:32 | LUV | LUV270319C00052500 | call | 52.5000 | 2027-03-19 | 1.5700 | 1.5600 | 1.6900 | 40.5650 | 235500.00 | 0.00 | 235500.00 | 1500 | 1 | 1502 | 85 | 17.6705882352941 | 0.383058619622344 | 0.383058619622344 | false | true | false | true | ||||||||||||||||
| d363c7c9-e069-4db1-8d32-4186ba906d0f | 2026-08-19 15:16 | 2026-08-19 15:16 | 2026-08-19 15:16 | LUV | LUV270319C00040000 | call | 40.0000 | 2027-03-19 | 6.3000 | 6.3000 | 6.6000 | 41.6400 | 37170.00 | 0.00 | 37170.00 | 59 | 8 | 59 | 896 | 0.0658482142857143 | 0.402338913442624 | 0.402338913442624 | false | false | false | true | ||||||||||||||||
| 9db7d5f6-84dc-455f-ac13-437cfd00c156 | 2026-08-19 13:45 | 2026-08-19 13:45 | 2026-08-19 13:45 | LUV | LUV261218P00042500 | put | 42.5000 | 2026-12-18 | 4.0500 | 4.0500 | 4.2000 | 41.8303 | 57510.00 | 0.00 | 57510.00 | 142 | 15 | 154 | 225 | 0.684444444444444 | 0.415734529011021 | 0.415734529011021 | false | false | false | true | ||||||||||||||||
| 463a7a66-4ef2-418b-a05e-ede4541137d8 | 2026-08-19 12:49 | 2026-08-19 12:49 | 2026-08-19 12:49 | LUV | LUV280121C00042500 | call | 42.5000 | 2028-01-21 | 8.8500 | 8.8500 | 9.3000 | 41.9300 | 66376.00 | 0.00 | 66376.00 | 75 | 9 | 75 | 174 | 0.431034482758621 | 0.40718499363175 | 0.40718499363175 | false | false | false | true | ||||||||||||||||
| 8daef167-d764-41f3-909a-77111582e52c | 2026-08-19 10:48 | 2026-08-19 10:48 | 2026-08-19 10:48 | LUV | LUV260918C00040000 | call | 40.0000 | 2026-09-18 | 3.1500 | 3.1500 | 3.9500 | 42.2700 | 15435.00 | 0.00 | 15435.00 | 49 | 10 | 54 | 2454 | 0.0220048899755501 | 0.360024624186607 | 0.360024624186607 | false | false | false | true | ||||||||||||||||
| 1d28a128-4b9b-4fec-891a-05051a5f0ced | 2026-08-18 15:15 | 2026-08-18 15:14 | 2026-08-18 15:14 | LUV | LUV270115P00042500 | put | 42.5000 | 2027-01-15 | 4.2000 | 4.1500 | 4.2000 | 42.4650 | 46618.00 | 46618.00 | 0.00 | 111 | 10 | 145 | 847 | 0.171192443919717 | 0.419485834390111 | 0.419485834390111 | false | false | false | true | ||||||||||||||||
| 4466b7f9-7740-4bf2-a73e-7f697f5804a4 | 2026-08-18 14:51 | 2026-08-18 14:51 | 2026-08-18 14:51 | LUV | LUV260918C00042500 | call | 42.5000 | 2026-09-18 | 1.9000 | 1.9000 | 1.9700 | 42.6600 | 15770.00 | 0.00 | 15770.00 | 83 | 26 | 241 | 3592 | 0.0670935412026726 | 0.353649269037854 | 0.353649269037854 | false | false | false | true | ||||||||||||||||
| 601464a6-ca53-4891-93c9-cac25a5ef1ca | 2026-08-18 14:16 | 2026-08-18 14:16 | 2026-08-18 14:16 | LUV | LUV260918C00047500 | call | 47.5000 | 2026-09-18 | 0.4200 | 0.4200 | 0.4700 | 42.7500 | 11592.00 | 0.00 | 11592.00 | 276 | 30 | 548 | 4959 | 0.110506150433555 | 0.362059672547126 | 0.362059672547126 | false | false | false | true | ||||||||||||||||
| 8510d016-7b43-4b5a-a5b0-2a7fe3afa2d4 | 2026-08-18 11:34 | 2026-08-18 11:34 | 2026-08-18 11:34 | LUV | LUV270115P00045000 | put | 45.0000 | 2027-01-15 | 5.2500 | 5.1500 | 5.4500 | 42.8700 | 2625000.00 | 0.00 | 0.00 | 5000 | 7 | 5000 | 4332 | 1.15420129270545 | 0.40612203010076 | 0.40612203010076 | false | false | false | true | ||||||||||||||||
| 818e70ed-77e1-400d-ac43-fc5270f81b2b | 2026-08-18 11:34 | 2026-08-18 11:34 | 2026-08-18 11:34 | LUV | LUV260918P00047500 | put | 47.5000 | 2026-09-18 | 5.0100 | 4.8000 | 5.1500 | 42.8700 | 2505000.00 | 0.00 | 0.00 | 5000 | 7 | 5002 | 5904 | 0.847222222222222 | 0.388583132032899 | 0.388583132032899 | false | false | false | true | ||||||||||||||||
| 6565cf5f-46ba-48f9-8c61-6e0a6957bf3e | 2026-08-17 15:19 | 2026-08-17 15:19 | 2026-08-17 15:19 | LUV | LUV270319C00047500 | call | 47.5000 | 2027-03-19 | 4.1000 | 3.9500 | 4.2500 | 43.4150 | 20500.00 | 0.00 | 0.00 | 50 | 5 | 51 | 195 | 0.261538461538462 | 0.400076729920772 | 0.400076729920772 | false | false | false | true | ||||||||||||||||
| 5a7d19b1-c69d-4bab-99d1-5443001e8f4e | 2026-08-17 10:52 | 2026-08-17 10:52 | 2026-08-17 10:52 | LUV | LUV261218C00045000 | call | 45.0000 | 2026-12-18 | 3.8500 | 3.8000 | 4.0000 | 43.9500 | 17325.00 | 13860.00 | 3465.00 | 45 | 5 | 76 | 1152 | 0.0659722222222222 | 0.399041981641677 | 0.399041981641677 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 19333508104.00 |
| 2026-10-28 |
| 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 |