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 | 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 |
|---|
| eb978189-bb97-4475-ad48-d88ebabf8be9 | 2026-08-19 10:12 | 2026-08-19 10:12 | 2026-08-19 10:12 | SKM | SKM270115C00045000 | call | 45.0000 | 2027-01-15 | 4.6000 | 4.5000 | 4.8000 | 39.1050 | 23000.00 | 7820.00 | 15180.00 | 50 | 12 | 73 | 2956 | 0.0246955345060893 | 0.653004891395551 | 0.653004891395551 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 41b6e391-cbc9-49ec-93a1-aed63cefd7a3 | 2026-08-18 15:44 | 2026-08-18 15:44 | 2026-08-18 15:44 | SKM | SKM260918P00035000 | put | 35.0000 | 2026-09-18 | 1.3000 | 1.2500 | 1.3500 | 38.4900 | 34970.00 | 4550.00 | 30420.00 | 269 | 16 | 702 | 2222 | 0.315931593159316 | 0.641926620730209 | 0.641926620730209 | false | false | false | true | ||||||||||||||||
| 6f92bf88-8be3-4d82-92ee-3842bb703f69 | 2026-08-18 15:42 | 2026-08-18 15:42 | 2026-08-18 15:42 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.1500 | 2.1000 | 2.3000 | 38.4800 | 59340.00 | 6665.00 | 52675.00 | 276 | 6 | 978 | 5775 | 0.169350649350649 | 0.613497295217851 | 0.613497295217851 | false | false | false | true | ||||||||||||||||
| e602a9cb-8977-4ffc-be86-8850ac9de922 | 2026-08-18 13:36 | 2026-08-18 13:36 | 2026-08-18 13:36 | SKM | SKM260918C00050000 | call | 50.0000 | 2026-09-18 | 0.4000 | 0.3000 | 0.5500 | 38.4800 | 60000.00 | 36160.00 | 8800.00 | 1500 | 15 | 3478 | 7674 | 0.45321866041178 | 0.684828282422651 | 0.684828282422651 | false | false | false | true | ||||||||||||||||
| d04626f2-ddf0-426f-b884-774bfead58b6 | 2026-08-18 12:40 | 2026-08-18 12:40 | 2026-08-18 12:40 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.2500 | 2.2500 | 2.3000 | 38.5850 | 90000.00 | 0.00 | 90000.00 | 400 | 33 | 634 | 5775 | 0.10978354978355 | 0.625080217239825 | 0.625080217239825 | false | false | false | true | ||||||||||||||||
| a0a012f7-4959-4f30-b08b-2f1c755bdbee | 2026-08-18 12:03 | 2026-08-18 12:03 | 2026-08-18 12:03 | SKM | SKM261218P00040000 | put | 40.0000 | 2026-12-18 | 6.7000 | 6.7000 | 6.8000 | 38.6000 | 14071.00 | 0.00 | 14071.00 | 21 | 8 | 65 | 1691 | 0.0384387936132466 | 0.699194520401821 | 0.699194520401821 | false | false | false | true | ||||||||||||||||
| 99f9dbde-9159-4d2b-aca7-12c720239215 | 2026-08-18 11:37 | 2026-08-18 11:37 | 2026-08-18 11:37 | SKM | SKM260918P00035000 | put | 35.0000 | 2026-09-18 | 1.3500 | 1.3500 | 1.5000 | 38.4300 | 12015.00 | 0.00 | 12015.00 | 89 | 8 | 191 | 2222 | 0.085958595859586 | 0.651035949271476 | 0.651035949271476 | false | false | false | true | ||||||||||||||||
| 79c7cc79-3ebc-46bf-961a-8e26f44d70ca | 2026-08-18 11:37 | 2026-08-18 11:37 | 2026-08-18 11:37 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.1500 | 2.1500 | 2.3500 | 38.4300 | 21500.00 | 0.00 | 21500.00 | 100 | 7 | 150 | 5775 | 0.025974025974026 | 0.618624107434123 | 0.618624107434123 | false | false | false | true | ||||||||||||||||
| 33ff6bec-2140-4508-a10f-7a59105e597c | 2026-08-18 10:19 | 2026-08-18 10:19 | 2026-08-18 10:19 | SKM | SKM261218C00045000 | call | 45.0000 | 2026-12-18 | 4.0900 | 3.8000 | 4.1000 | 38.8000 | 40937.00 | 40937.00 | 0.00 | 100 | 16 | 409 | 2544 | 0.160770440251572 | 0.686445724412701 | 0.67527910301677 | true | false | false | true | ||||||||||||||||
| 7924c947-c63a-4f81-9a59-67714c5a77e1 | 2026-08-18 10:12 | 2026-08-18 10:11 | 2026-08-18 10:11 | SKM | SKM260918C00050000 | call | 50.0000 | 2026-09-18 | 0.4500 | 0.4000 | 0.5000 | 38.5300 | 28935.00 | 0.00 | 24480.00 | 643 | 9 | 1121 | 7674 | 0.146077664842325 | 0.705194642508395 | 0.70438364080799 | false | false | false | true | ||||||||||||||||
| a9738462-ae85-4587-973a-22ca87176aa5 | 2026-08-17 15:37 | 2026-08-17 15:37 | 2026-08-17 15:37 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.9000 | 2.6500 | 2.9000 | 39.7000 | 49589.00 | 49589.00 | 0.00 | 171 | 24 | 1667 | 4667 | 0.357188772230555 | 0.635611383384033 | 0.635611383384033 | true | false | false | true | ||||||||||||||||
| 7f4152d4-96cf-476d-a58c-a368a326a420 | 2026-08-17 14:55 | 2026-08-17 14:55 | 2026-08-17 14:55 | SKM | SKM261218P00035000 | put | 35.0000 | 2026-12-18 | 3.5000 | 3.4000 | 3.8000 | 39.4600 | 24153.00 | 12950.00 | 11203.00 | 69 | 17 | 95 | 2339 | 0.0406156477126977 | 0.661111828893084 | 0.661111828893084 | false | false | false | true | ||||||||||||||||
| d794d170-9801-4591-8962-e8f499d6bb76 | 2026-08-17 14:53 | 2026-08-17 14:52 | 2026-08-17 14:52 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.8000 | 2.5500 | 2.8500 | 39.4600 | 56000.00 | 29120.00 | 0.00 | 200 | 8 | 1457 | 4667 | 0.312191986286694 | 0.64326700369215 | 0.641051160558231 | false | false | false | true | ||||||||||||||||
| 8d64c030-0ab1-4ff2-8659-c3998370c6ec | 2026-08-17 14:52 | 2026-08-17 14:52 | 2026-08-17 14:52 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.6000 | 2.5500 | 2.7000 | 39.4550 | 52000.00 | 0.00 | 52000.00 | 200 | 5 | 457 | 4667 | 0.0979215770302121 | 0.598665454306917 | 0.598665454306917 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| 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 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| 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 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| 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 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Communication Services |
| 13923929210.00 |
| 2026-10-29 |
| 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 |