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_alerts474,253 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 |
|---|
| dd7c8949-b45b-4101-a014-1ea5bed6e875 | 2026-08-27 15:35 | 2026-08-27 15:35 | 2026-08-27 15:35 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 31.9600 | 31.6000 | 32.0000 | 7723.5600 | 4634200.00 | 0.00 | 0.00 | 1450 | 11 | 2178 | 23595 | 0.0923076923076923 | 0.263944076629793 | 0.263954681772084 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 67a2f894-0b4a-4b25-93ff-8bbcf7bda2c1 | 2026-09-15 09:52 | 2026-09-15 09:52 | 2026-09-15 09:52 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 32.2000 | 32.1000 | 32.4000 | 7606.7700 | 644000.00 | 466900.00 | 177100.00 | 200 | 5 | 1929 | 28385 | 0.0679584287475779 | 0.2732396786908 | 0.2732396786908 | false | false | false | true | ||||||||||||||||
| f3975ed7-8a22-4167-91d8-a4f0375172e0 | 2026-09-15 09:54 | 2026-09-15 09:54 | 2026-09-15 09:54 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 32.0000 | 31.8000 | 32.2000 | 7609.2400 | 1280000.00 | 876800.00 | 134400.00 | 400 | 13 | 3454 | 28385 | 0.121683988021843 | 0.273140028429154 | 0.273163978298513 | false | false | false | |||||||||||||||||
| 76340eb5-6198-4e3b-bd40-7b564e5c40ef | 2026-09-18 16:13 | 2026-09-18 16:13 | 2026-09-18 16:13 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 25.8200 | 25.5000 | 25.9000 | 7630.0000 | 1291000.00 | 0.00 | 0.00 | 500 | 12 | 975 | 26892 | 0.036256135653726 | 0.269376005211711 | 0.269376005211711 | false | false | false | true | ||||||||||||||||
| 2081c988-ca71-46db-ba6c-e32260657b16 | 2026-09-21 15:09 | 2026-09-21 15:09 | 2026-09-21 15:09 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 21.8000 | 21.7000 | 22.0000 | 7771.9800 | 13080.00 | 0.00 | 13080.00 | 6 | 6 | 470 | 26462 | 0.0177613181165445 | 0.278894114996139 | 0.278894114996139 | false | false | false | true | ||||||||||||||||
| 24701f7a-daa2-46e6-96aa-88fb70a63aa6 | 2026-09-21 15:21 | 2026-09-21 15:21 | 2026-09-21 15:21 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 21.8000 | 21.7000 | 22.0000 | 7772.0400 | 30520.00 | 0.00 | 30520.00 | 14 | 12 | 498 | 26462 | 0.018819439195828 | 0.278901643283728 | 0.278901643283728 | false | false | false | true | ||||||||||||||||
| 9689bc31-e6c0-46a5-a9a0-9dea44edb4ad | 2026-09-21 15:26 | 2026-09-21 15:26 | 2026-09-21 15:26 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 21.8000 | 21.7000 | 22.0000 | 7770.7700 | 10900.00 | 0.00 | 10900.00 | 5 | 5 | 511 | 26462 | 0.0193107096969239 | 0.278742272236711 | 0.278742272236711 | false | false | false | true | ||||||||||||||||
| 52f24433-ff14-405f-bda3-d5c6b6f803c1 | 2026-09-21 15:26 | 2026-09-21 15:26 | 2026-09-21 15:26 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 21.8000 | 21.7000 | 22.0000 | 7770.7200 | 17440.00 | 2180.00 | 15260.00 | 8 | 6 | 506 | 26462 | 0.0191217595041947 | 0.278735996828324 | 0.278735996828324 | false | false | false | true | ||||||||||||||||
| aec14f7d-da2e-4e62-a56d-3fb891c2b289 | 2026-09-21 15:32 | 2026-09-21 15:32 | 2026-09-21 15:32 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 21.6000 | 21.5000 | 21.8000 | 7750.0000 | 23760.00 | 0.00 | 23760.00 | 11 | 10 | 527 | 26462 | 0.0199153503136573 | 0.278426515022901 | 0.27843152713314 | false | false | false | true | ||||||||||||||||
| 5a37c862-c578-47ea-9d2f-6dadad192d99 | 2026-09-21 15:38 | 2026-09-21 15:38 | 2026-09-21 15:38 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 21.4000 | 21.3000 | 21.6000 | 7778.7100 | 17120.00 | 0.00 | 8560.00 | 8 | 8 | 541 | 26462 | 0.0204444108532991 | 0.278662608708526 | 0.278662608708526 | false | false | false | true | ||||||||||||||||
| 3480fbe7-1899-4fd6-b23c-851986edac47 | 2026-09-21 15:43 | 2026-09-21 15:43 | 2026-09-21 15:43 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 21.4000 | 21.3000 | 21.6000 | 7774.8000 | 23540.00 | 2140.00 | 19260.00 | 11 | 10 | 554 | 26462 | 0.020935681354395 | 0.278147485896458 | 0.278173753990776 | false | false | false | true | ||||||||||||||||
| 9cc19de2-1f82-46f4-9829-ebf3331c8e4b | 2026-09-23 15:11 | 2026-09-23 15:11 | 2026-09-23 15:11 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 22.0000 | 21.8000 | 22.1000 | 7710.5300 | 22000.00 | 17600.00 | 2200.00 | 10 | 8 | 528 | 26413 | 0.0199901563623973 | 0.27461462576453 | 0.274603021754274 | false | false | false | true | ||||||||||||||||
| 2c83847a-b348-4d3e-8b16-e1ab8f77fa99 | 2026-09-23 15:18 | 2026-09-23 15:17 | 2026-09-23 15:17 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 22.3000 | 22.1000 | 22.4000 | 7707.3900 | 22300.00 | 20070.00 | 2230.00 | 10 | 9 | 645 | 26413 | 0.0244197932836103 | 0.274985932246034 | 0.274985932246034 | false | false | false | true | ||||||||||||||||
| 65ab22c6-7115-4fc5-bb8b-5e0531e22e29 | 2026-09-23 15:30 | 2026-09-23 15:29 | 2026-09-23 15:29 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 22.5000 | 22.3000 | 22.6000 | 7685.0000 | 13500.00 | 11250.00 | 2250.00 | 6 | 6 | 772 | 26413 | 0.0292280316510809 | 0.275308738537683 | 0.275308738537683 | false | false | false | true | ||||||||||||||||
| c8420fec-3ae3-4f79-a900-d32a83855ffc | 2026-09-23 15:36 | 2026-09-23 15:35 | 2026-09-23 15:35 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 22.4000 | 22.2000 | 22.5000 | 7708.7300 | 20160.00 | 20160.00 | 0.00 | 9 | 9 | 792 | 26413 | 0.029985234543596 | 0.275428367714187 | 0.27542060964103 | false | false | false | true | ||||||||||||||||
| fb52f7eb-80de-458e-98f4-7d426690a3dc | 2026-09-23 15:48 | 2026-09-23 15:48 | 2026-09-23 15:48 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 22.5000 | 22.3000 | 22.6000 | 7708.6900 | 18000.00 | 18000.00 | 0.00 | 8 | 8 | 820 | 26413 | 0.031045318593117 | 0.275676304092293 | 0.275676304092293 | false | false | false | true | ||||||||||||||||
| 907180bd-c87f-4a04-babd-ff9334cd4db3 | 2026-09-25 14:09 | 2026-09-25 14:09 | 2026-09-25 14:09 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 20.9000 | 20.6000 | 20.9000 | 7720.0000 | 238260.00 | 238260.00 | 0.00 | 114 | 6 | 670 | 26680 | 0.0251124437781109 | 0.278752175614689 | 0.278752175614689 | false | false | false | true | ||||||||||||||||
| 6fda0b3b-f448-4b61-82ba-ef69ca68f652 | 2026-09-25 14:10 | 2026-09-25 14:10 | 2026-09-25 14:10 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 21.0000 | 20.7000 | 21.0000 | 7720.0000 | 182700.00 | 182700.00 | 0.00 | 87 | 6 | 972 | 26680 | 0.036431784107946 | 0.279098179948089 | 0.279098179948089 | false | false | false | true | ||||||||||||||||
| 4c8fd64b-a95d-4005-b0a4-3b1a565a4e90 | 2026-09-25 14:10 | 2026-09-25 14:10 | 2026-09-25 14:10 | SPX | SPX261218P06300000 | put | 6300.0000 | 2026-12-18 | 21.0000 | 20.7000 | 21.0000 | 7720.0000 | 176400.00 | 176400.00 | 0.00 | 84 | 6 | 1056 | 26680 | 0.0395802098950525 | 0.279100754305542 | 0.279100754305542 | false | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| 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 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:12:23.721983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:31:17.816750Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:37:14.904379Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |