uw_flow_alerts728,802 rows| 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 |
|---|
| 07dc9fee-6201-40a7-a4ea-d2dd9b9858a6 | 2026-08-17 09:52 | 2026-08-17 09:52 | 2026-08-17 09:52 | CRCL | CRCL260828C00100000 | call | 100.0000 | 2026-08-28 | 0.2500 | 0.1800 | 0.2500 | 74.6450 | 35450.00 | 35450.00 | 0.00 | 1418 | 42 | 1836 | 229 | 8.0174672489083 | 0.972583861796413 | 0.972583861796413 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 22863031210.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8fb341fc-b5d7-4ab1-92a7-fe552ae0a4bf | 2026-08-21 10:07 | 2026-08-21 10:07 | 2026-08-21 10:07 | CRCL | CRCL260828C00100000 | call | 100.0000 | 2026-08-28 | 2.4400 | 2.4400 | 2.5700 | 91.7650 | 24400.00 | 0.00 | 24400.00 | 100 | 9 | 1182 | 2802 | 0.421841541755889 | 1.05917815539845 | 1.05917815539845 | false | false | false | true | ||||||||||||||||
| 5003330b-55e8-4df8-adb8-9b96b36fa115 | 2026-08-21 10:14 | 2026-08-21 10:14 | 2026-08-21 10:14 | CRCL | CRCL260828C00100000 | call | 100.0000 | 2026-08-28 | 2.0000 | 2.0000 | 2.1400 | 90.2900 | 15601.00 | 0.00 | 15601.00 | 78 | 12 | 1448 | 2802 | 0.516773733047823 | 1.05510154630899 | 1.05510154630899 | true | false | false | true | ||||||||||||||||
| 2f8f4119-37e0-4836-ba57-6496aa44cf76 | 2026-08-24 10:08 | 2026-08-24 10:08 | 2026-08-24 10:08 | CRCL | CRCL260828C00100000 | call | 100.0000 | 2026-08-28 | 1.0000 | 0.9200 | 1.0000 | 88.9250 | 20000.00 | 20000.00 | 0.00 | 200 | 7 | 3394 | 4257 | 0.797275076344844 | 1.15126555123166 | 1.15126555123166 | false | false | false | true | ||||||||||||||||
| 425a5dd6-b16e-4c51-988c-d3ad5d26dce8 | 2026-08-24 10:33 | 2026-08-24 10:33 | 2026-08-24 10:33 | CRCL | CRCL260828C00100000 | call | 100.0000 | 2026-08-28 | 1.3800 | 1.3000 | 1.4200 | 91.0551 | 13780.00 | 13780.00 | 0.00 | 100 | 10 | 4272 | 4257 | 1.00352360817477 | 1.12566922927364 | 1.12566922927364 | false | false | false | true | ||||||||||||||||
| 172bc278-a514-4cb3-8489-13d2b825ecb0 | 2026-08-24 11:54 | 2026-08-24 11:54 | 2026-08-24 11:54 | CRCL | CRCL260828C00100000 | call | 100.0000 | 2026-08-28 | 0.9800 | 0.9800 | 1.0400 | 89.3092 | 16660.00 | 0.00 | 16660.00 | 170 | 16 | 6323 | 4257 | 1.48531829927179 | 1.11479148432103 | 1.11479148432103 | false | false | false | true | ||||||||||||||||
| f08bbafc-4fbb-4969-8490-04735dbbdd54 | 2026-08-27 10:12 | 2026-08-27 10:12 | 2026-08-27 10:12 | CRCL | CRCL260828C00100000 | call | 100.0000 | 2026-08-28 | 0.5200 | 0.5200 | 0.5500 | 93.2800 | 11700.00 | 0.00 | 11700.00 | 225 | 7 | 1477 | 5794 | 0.254918881601657 | 1.29499865018194 | 1.29499865018194 | false | false | false | true | ||||||||||||||||
| 1c3ffd8b-fb1e-4a81-ba2f-30e21790b13b | 2026-08-27 10:46 | 2026-08-27 10:46 | 2026-08-27 10:46 | CRCL | CRCL260828C00100000 | call | 100.0000 | 2026-08-28 | 0.7600 | 0.7100 | 0.7600 | 95.0299 | 11248.00 | 11248.00 | 0.00 | 148 | 5 | 2355 | 5794 | 0.406454953400069 | 1.22511488222235 | 1.22511488222235 | false | false | false | true | ||||||||||||||||
| 728cf90a-aa2b-4f68-b37a-1c769d1f2617 | 2026-08-27 11:04 | 2026-08-27 11:04 | 2026-08-27 11:04 | CRCL | CRCL260828C00100000 | call | 100.0000 | 2026-08-28 | 0.5200 | 0.5200 | 0.5800 | 94.0745 | 10400.00 | 0.00 | 10400.00 | 200 | 20 | 2728 | 5794 | 0.470831895063859 | 1.18711514631187 | 1.18711514631187 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22863031210.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22863031210.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22863031210.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 22863031210.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:35:34.147296Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22863031210.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22863031210.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22863031210.00 |
| 2026-11-11 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22863031210.00 |
| 2026-11-11 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:06:04.251678Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |