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_alerts326,449 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 | price |
|---|
| 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 |
|---|
| 55cd81b3-fb05-4b21-938a-f4e0afa4b522 | 2026-08-17 10:25 | 2026-08-17 10:25 | 2026-08-17 10:25 | INDI | INDI260918C00005000 | call | 5.0000 | 2026-09-18 | 0.7000 | 0.6500 | 0.7000 | 4.9400 | 27999.00 | 27999.00 | 0.00 | 400 | 9 | 984 | 2363 | 0.416419805332205 | 1.23786227360413 | 1.22051008278351 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 682116944.00 | 2026-11-05 | 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 |
| 5e5e22bf-bf92-4b30-be6e-adb93a53590d | 2026-08-17 10:30 | 2026-08-17 10:30 | 2026-08-17 10:30 | INDI | INDI260918C00007500 | call | 7.5000 | 2026-09-18 | 0.2500 | 0.2000 | 0.2500 | 5.0790 | 18750.00 | 18750.00 | 0.00 | 750 | 17 | 1863 | 524 | 3.55534351145038 | 1.42473197267762 | 1.42473197267762 | false | false | false | true | false | |||||||||||||||
| 6218f4fa-f1e8-4231-bc70-416f5d0d1026 | 2026-08-17 10:31 | 2026-08-17 10:31 | 2026-08-17 10:31 | INDI | INDI260918C00007500 | call | 7.5000 | 2026-09-18 | 0.2500 | 0.2000 | 0.2500 | 5.0850 | 18405.00 | 18405.00 | 0.00 | 740 | 9 | 3013 | 524 | 5.75 | 1.40017915814078 | 1.42165120780834 | false | false | false | true | false | |||||||||||||||
| 10ffe7d1-3306-43b3-8bdf-e23b7b7901d9 | 2026-08-17 10:31 | 2026-08-17 10:31 | 2026-08-17 10:31 | INDI | INDI280121C00010000 | call | 10.0000 | 2028-01-21 | 1.3500 | 1.1000 | 1.4500 | 5.1300 | 14580.00 | 12960.00 | 1620.00 | 108 | 6 | 170 | 5745 | 0.0295909486510009 | 0.945611760193704 | 0.945611760193704 | false | false | false | true | false | |||||||||||||||
| 7f68e470-77df-45b2-a3d6-a0a28e1ab7f4 | 2026-08-17 10:38 | 2026-08-17 10:38 | 2026-08-17 10:38 | INDI | INDI260918C00004500 | call | 4.5000 | 2026-09-18 | 1.0500 | 0.9500 | 1.0500 | 5.0350 | 21000.00 | 21000.00 | 0.00 | 200 | 5 | 336 | 3579 | 0.0938809723386421 | 1.33115244377598 | 1.33115244377598 | false | false | false | true | false | |||||||||||||||
| a86c9e83-e9f8-4966-86f9-69d4cf67197e | 2026-08-17 10:40 | 2026-08-17 10:40 | 2026-08-17 10:40 | INDI | INDI260918C00004500 | call | 4.5000 | 2026-09-18 | 1.0500 | 0.9500 | 1.1000 | 5.0500 | 21000.00 | 17640.00 | 3360.00 | 200 | 6 | 736 | 3579 | 0.205644034646549 | 1.31151791146903 | 1.31151791146903 | false | false | false | true | false | |||||||||||||||
| 10fc05a7-570c-4581-bc4e-04efdb6a1329 | 2026-08-17 12:11 | 2026-08-17 12:11 | 2026-08-17 12:11 | INDI | INDI260918C00005000 | call | 5.0000 | 2026-09-18 | 0.6500 | 0.6500 | 0.7500 | 4.9650 | 19630.00 | 0.00 | 19630.00 | 302 | 7 | 2320 | 2363 | 0.98180279305967 | 1.126988115814 | 1.126988115814 | false | false | false | true | false | |||||||||||||||
| 71d5b12a-291c-4656-a723-44064ac5a99f | 2026-08-17 15:22 | 2026-08-17 15:22 | 2026-08-17 15:22 | INDI | INDI260918C00004500 | call | 4.5000 | 2026-09-18 | 0.8000 | 0.8000 | 0.8500 | 4.7700 | 15360.00 | 0.00 | 15360.00 | 192 | 5 | 2525 | 3579 | 0.705504330818664 | 1.19114732685186 | 1.19114732685186 | false | false | false | true | false | |||||||||||||||
| a7da137d-3427-4291-89cf-659fd34903e3 | 2026-08-18 09:46 | 2026-08-18 09:46 | 2026-08-18 09:46 | INDI | INDI260918C00007500 | call | 7.5000 | 2026-09-18 | 0.0500 | 0.0500 | 0.1500 | 4.0000 | 14707.00 | 0.00 | 14707.00 | 2800 | 18 | 2805 | 5737 | 0.488931497298239 | 1.27612005916831 | 1.27612005916831 | false | false | false | true | false | |||||||||||||||
| 4161a4be-3c9f-4d41-b709-a1c760474d1d | 2026-08-18 09:52 | 2026-08-18 09:51 | 2026-08-18 09:51 | INDI | INDI260918P00004000 | put | 4.0000 | 2026-09-18 | 0.4500 | 0.4500 | 0.5000 | 4.1650 | 12960.00 | 0.00 | 12960.00 | 288 | 5 | 504 | 288 | 1.75 | 1.13270192730641 | 1.13270192730641 | false | false | false | true | false | |||||||||||||||
| 8df05153-1570-4d57-a7e5-5d52b6c1d57f | 2026-08-18 10:09 | 2026-08-18 10:08 | 2026-08-18 10:08 | INDI | INDI260821C00004000 | call | 4.0000 | 2026-08-21 | 0.4000 | 0.3500 | 0.4000 | 4.2190 | 25510.00 | 25510.00 | 0.00 | 638 | 29 | 729 | 5935 | 0.122830665543387 | 1.8599148158755 | 1.8599148158755 | true | false | false | true | false | |||||||||||||||
| 2ce7740c-ff83-46c4-81a4-fc94001bab28 | 2026-08-18 11:34 | 2026-08-18 11:34 | 2026-08-18 11:34 | INDI | INDI260821C00004000 | call | 4.0000 | 2026-08-21 | 0.4500 | 0.4000 | 0.5500 | 4.2950 | 15904.00 | 0.00 | 15904.00 | 350 | 7 | 1111 | 5935 | 0.187194608256108 | 1.77652891213903 | 1.77652891213903 | false | false | false | true | false | |||||||||||||||
| 814018b9-3ace-4ca1-a026-cb33f4b63e38 | 2026-08-19 09:44 | 2026-08-19 09:44 | 2026-08-19 09:44 | INDI | INDI260918C00004000 | call | 4.0000 | 2026-09-18 | 0.5000 | 0.5000 | 0.6500 | 4.0450 | 10050.00 | 0.00 | 10050.00 | 201 | 6 | 326 | 10088 | 0.0323156225218081 | 1.02851014924983 | 1.02851014924983 | false | false | false | true | false | |||||||||||||||
| ceda063a-d79e-406b-b182-013060e5cde4 | 2026-08-21 10:36 | 2026-08-21 10:36 | 2026-08-21 10:36 | INDI | INDI270115C00005000 | call | 5.0000 | 2027-01-15 | 0.7000 | 0.7000 | 0.7500 | 4.0150 | 21000.00 | 0.00 | 21000.00 | 300 | 20 | 308 | 18227 | 0.0168980084490042 | 0.986226241053566 | 0.986226241053566 | false | false | false | true | false | |||||||||||||||
| 637133b1-06c9-4852-868c-8e8a80098534 | 2026-08-24 11:19 | 2026-08-24 11:19 | 2026-08-24 11:19 | INDI | INDI260918C00004000 | call | 4.0000 | 2026-09-18 | 0.4500 | 0.4000 | 0.4500 | 4.0200 | 11250.00 | 11250.00 | 0.00 | 250 | 5 | 350 | 4521 | 0.077416500774165 | 1.04268980987339 | 1.04268980987339 | false | false | false | true | false | |||||||||||||||
| 26038773-69df-4859-bf6b-c4739ce720e5 | 2026-08-27 10:43 | 2026-08-27 10:43 | 2026-08-27 10:43 | INDI | INDI270115C00004000 | call | 4.0000 | 2027-01-15 | 0.8000 | 0.8000 | 0.9500 | 3.8882 | 16000.00 | 0.00 | 16000.00 | 200 | 6 | 224 | 7554 | 0.0296531638866826 | 0.860719462044423 | 0.860719462044423 | false | false | false | true | false | |||||||||||||||
| 756f91b2-f92f-4e22-85b9-51e45b42a08c | 2026-08-31 10:35 | 2026-08-31 10:35 | 2026-08-31 10:35 | INDI | INDI280121C00010000 | call | 10.0000 | 2028-01-21 | 0.7000 | 0.6000 | 0.7500 | 3.6850 | 14840.00 | 420.00 | 14420.00 | 212 | 19 | 936 | 5659 | 0.165400247393532 | 0.963726785989965 | 0.963726785989965 | true | false | false | true | false | |||||||||||||||
| 5ccd3f69-cafc-4d1d-a242-39e7d3f53899 | 2026-08-31 10:38 | 2026-08-31 10:38 | 2026-08-31 10:38 | INDI | INDI280121C00010000 | call | 10.0000 | 2028-01-21 | 0.7000 | 0.6500 | 0.7000 | 3.7100 | 70000.00 | 70000.00 | 0.00 | 1000 | 7 | 3454 | 5659 | 0.610355186428698 | 0.957811601010296 | 0.957811601010296 | true | false | false | true | false | |||||||||||||||
| 41198c7a-be36-4e18-bf01-df8c962b4890 | 2026-09-01 09:57 | 2026-09-01 09:56 | 2026-09-01 09:56 | INDI | INDI280121C00007500 | call | 7.5000 | 2028-01-21 | 0.8500 | 0.8500 | 1.0500 | 3.5500 | 15810.00 | 0.00 | 595.00 | 186 | 29 | 592 | 1574 | 0.376111817026684 | 0.950408544373501 | 0.950408544373501 | false | false | false | true | false | |||||||||||||||
| 0086dfe9-7917-43bf-80ee-d0f13d9c1f9c | 2026-09-01 09:57 | 2026-09-01 09:57 | 2026-09-01 09:57 | INDI | INDI280121C00007500 | call | 7.5000 | 2028-01-21 | 0.8500 | 0.8500 | 0.9000 | 3.5550 | 21250.00 | 0.00 | 85.00 | 250 | 42 | 906 | 1574 | 0.575603557814485 | 0.94897432583755 | 0.94897432583755 | false | false | false | true | false | |||||||||||||||
| bc3f1246-4043-4720-b263-e1eb11ade0df | 2026-09-11 15:02 | 2026-09-11 15:02 | 2026-09-11 15:02 | INDI | INDI280121C00005000 | call | 5.0000 | 2028-01-21 | 1.0000 | 1.0000 | 1.1500 | 3.3200 | 20300.00 | 0.00 | 20300.00 | 203 | 5 | 216 | 2530 | 0.0853754940711463 | 0.903549257469341 | 0.903549257469341 | false | false | false | true | false | |||||||||||||||
| cf7d7a83-1ae1-4029-a8d8-220bf9d78ee4 | 2026-09-16 15:24 | 2026-09-16 15:24 | 2026-09-16 15:24 | INDI | INDI270115P00002500 | put | 2.5000 | 2027-01-15 | 0.3000 | 0.2500 | 0.4500 | 2.9400 | 16492.00 | 0.00 | 16492.00 | 547 | 5 | 547 | 785 | 0.696815286624204 | 0.889100445411392 | 0.818018352128132 | false | false | false | true | false | |||||||||||||||
| 94d88cfa-eb13-4d53-9f5e-94415f2cf93d | 2026-09-17 13:27 | 2026-09-17 13:27 | 2026-09-17 13:27 | INDI | INDI261016C00003500 | call | 3.5000 | 2026-10-16 | 0.2000 | 0.1500 | 0.2000 | 3.2150 | 18420.00 | 18420.00 | 0.00 | 921 | 15 | 1755 | 277 | 6.33574007220217 | 0.858910243760866 | 0.847244117254646 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:49:52.356548Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:00:27.391289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:00:27.391289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 658144783.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 682116944.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |