PREVIEW / stock_5min / 2005-03-28
file: by_date/stock_5min/2005/2005-03-28.parquet size: 2.6 MB rows: 194,066 symbols: 1,946
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2005-03-28 08:00:00 | AAPL | Stock | 1.5196 | 1.5286 | 1.5196 | 1.5286 | 184772.0 |
| 2005-03-28 08:05:00 | AAPL | Stock | 1.5236 | 1.5286 | 1.5236 | 1.5286 | 33600.0 |
| 2005-03-28 08:15:00 | AAPL | Stock | 1.5271 | 1.5286 | 1.5268 | 1.5268 | 54600.0 |
| 2005-03-28 08:20:00 | AAPL | Stock | 1.5254 | 1.5264 | 1.525 | 1.5264 | 42000.0 |
| 2005-03-28 08:25:00 | AAPL | Stock | 1.5257 | 1.5257 | 1.5257 | 1.5257 | 28000.0 |
| 2005-03-28 08:30:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 12600.0 |
| 2005-03-28 08:35:00 | AAPL | Stock | 1.525 | 1.5254 | 1.525 | 1.5254 | 18200.0 |
| 2005-03-28 08:40:00 | AAPL | Stock | 1.5264 | 1.5282 | 1.5264 | 1.5282 | 8400.0 |
| 2005-03-28 08:45:00 | AAPL | Stock | 1.5282 | 1.5286 | 1.5282 | 1.5286 | 13300.0 |
| 2005-03-28 08:50:00 | AAPL | Stock | 1.5286 | 1.5293 | 1.5286 | 1.5286 | 839300.0 |
| 2005-03-28 08:55:00 | AAPL | Stock | 1.5286 | 1.5321 | 1.5286 | 1.5321 | 112056.0 |
| 2005-03-28 09:00:00 | AAPL | Stock | 1.5311 | 1.5311 | 1.5311 | 1.5311 | 8400.0 |
| 2005-03-28 09:05:00 | AAPL | Stock | 1.5314 | 1.5321 | 1.5314 | 1.5321 | 72800.0 |
| 2005-03-28 09:10:00 | AAPL | Stock | 1.5314 | 1.5329 | 1.5314 | 1.5329 | 382200.0 |
| 2005-03-28 09:15:00 | AAPL | Stock | 1.5286 | 1.53 | 1.5286 | 1.53 | 25200.0 |
| 2005-03-28 09:20:00 | AAPL | Stock | 1.53 | 1.53 | 1.5293 | 1.5293 | 14000.0 |
| 2005-03-28 09:25:00 | AAPL | Stock | 1.5275 | 1.5296 | 1.5214 | 1.5279 | 234892.0 |
| 2005-03-28 09:30:00 | AAPL | Stock | 1.5268 | 1.5329 | 1.5268 | 1.5289 | 9718492.0 |
| 2005-03-28 09:35:00 | AAPL | Stock | 1.5289 | 1.5343 | 1.5264 | 1.5307 | 8084384.0 |
| 2005-03-28 09:40:00 | AAPL | Stock | 1.5307 | 1.5318 | 1.5286 | 1.5286 | 3871700.0 |
| 2005-03-28 09:45:00 | AAPL | Stock | 1.5286 | 1.5336 | 1.5275 | 1.5314 | 3987116.0 |
| 2005-03-28 09:50:00 | AAPL | Stock | 1.5318 | 1.5343 | 1.5293 | 1.5296 | 3396652.0 |
| 2005-03-28 09:55:00 | AAPL | Stock | 1.5296 | 1.5307 | 1.5196 | 1.5243 | 9819964.0 |
| 2005-03-28 10:00:00 | AAPL | Stock | 1.5246 | 1.5257 | 1.5211 | 1.5214 | 6166216.0 |
| 2005-03-28 10:05:00 | AAPL | Stock | 1.5214 | 1.5257 | 1.5214 | 1.525 | 5506060.0 |
| 2005-03-28 10:10:00 | AAPL | Stock | 1.5249 | 1.5254 | 1.5225 | 1.5246 | 4205852.0 |
| 2005-03-28 10:15:00 | AAPL | Stock | 1.5243 | 1.5264 | 1.5232 | 1.5246 | 4711028.0 |
| 2005-03-28 10:20:00 | AAPL | Stock | 1.525 | 1.5279 | 1.5239 | 1.5268 | 3346112.0 |
| 2005-03-28 10:25:00 | AAPL | Stock | 1.5268 | 1.5289 | 1.525 | 1.5279 | 4834116.0 |
| 2005-03-28 10:30:00 | AAPL | Stock | 1.5282 | 1.5321 | 1.525 | 1.5307 | 6653696.0 |
| 2005-03-28 10:35:00 | AAPL | Stock | 1.5307 | 1.5332 | 1.5282 | 1.5318 | 4568872.0 |
| 2005-03-28 10:40:00 | AAPL | Stock | 1.5318 | 1.5325 | 1.5279 | 1.5279 | 4202576.0 |
| 2005-03-28 10:45:00 | AAPL | Stock | 1.5279 | 1.5318 | 1.5271 | 1.5311 | 4200728.0 |
| 2005-03-28 10:50:00 | AAPL | Stock | 1.5307 | 1.5311 | 1.5282 | 1.5289 | 4379732.0 |
| 2005-03-28 10:55:00 | AAPL | Stock | 1.5289 | 1.5314 | 1.5286 | 1.5289 | 2594872.0 |
| 2005-03-28 11:00:00 | AAPL | Stock | 1.5289 | 1.5325 | 1.5289 | 1.5325 | 3404016.0 |
| 2005-03-28 11:05:00 | AAPL | Stock | 1.5325 | 1.534 | 1.5314 | 1.5329 | 4373684.0 |
| 2005-03-28 11:10:00 | AAPL | Stock | 1.5336 | 1.5339 | 1.5286 | 1.5296 | 4091136.0 |
| 2005-03-28 11:15:00 | AAPL | Stock | 1.5296 | 1.5307 | 1.5268 | 1.5289 | 6199256.0 |
| 2005-03-28 11:20:00 | AAPL | Stock | 1.5293 | 1.5293 | 1.5275 | 1.5279 | 2603664.0 |
| 2005-03-28 11:25:00 | AAPL | Stock | 1.5279 | 1.53 | 1.5275 | 1.53 | 2655156.0 |
| 2005-03-28 11:30:00 | AAPL | Stock | 1.53 | 1.5311 | 1.5289 | 1.5293 | 1629908.0 |
| 2005-03-28 11:35:00 | AAPL | Stock | 1.5293 | 1.5304 | 1.5268 | 1.5283 | 2630208.0 |
| 2005-03-28 11:40:00 | AAPL | Stock | 1.5286 | 1.53 | 1.5268 | 1.5279 | 3018792.0 |
| 2005-03-28 11:45:00 | AAPL | Stock | 1.5275 | 1.5286 | 1.5268 | 1.5275 | 2915612.0 |
| 2005-03-28 11:50:00 | AAPL | Stock | 1.5275 | 1.5275 | 1.525 | 1.5261 | 3475024.0 |
| 2005-03-28 11:55:00 | AAPL | Stock | 1.5261 | 1.5289 | 1.5257 | 1.5279 | 1798244.0 |
| 2005-03-28 12:00:00 | AAPL | Stock | 1.5275 | 1.5286 | 1.5268 | 1.5282 | 963816.0 |
| 2005-03-28 12:05:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5239 | 1.5243 | 3123484.0 |
| 2005-03-28 12:10:00 | AAPL | Stock | 1.5239 | 1.525 | 1.5236 | 1.525 | 2689680.0 |
> showing 50 of 194,066 rows — these rows as CSV