PREVIEW / stock_1min / 2005-03-09
file: by_date/stock_1min/2005/2005-03-09.parquet size: 6.8 MB rows: 560,077 symbols: 1,588
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-09 08:00:00 | AAPL | Stock | 1.4521 | 1.4521 | 1.4521 | 1.4521 | 7280.0 |
| 2005-03-09 08:01:00 | AAPL | Stock | 1.45 | 1.4529 | 1.4461 | 1.4461 | 343924.0 |
| 2005-03-09 08:02:00 | AAPL | Stock | 1.4464 | 1.4471 | 1.4464 | 1.4471 | 61600.0 |
| 2005-03-09 08:03:00 | AAPL | Stock | 1.4496 | 1.4496 | 1.4471 | 1.4471 | 11200.0 |
| 2005-03-09 08:04:00 | AAPL | Stock | 1.4489 | 1.4496 | 1.4471 | 1.4496 | 83188.0 |
| 2005-03-09 08:05:00 | AAPL | Stock | 1.4496 | 1.4507 | 1.4496 | 1.4507 | 15988.0 |
| 2005-03-09 08:06:00 | AAPL | Stock | 1.4511 | 1.4511 | 1.45 | 1.45 | 114800.0 |
| 2005-03-09 08:07:00 | AAPL | Stock | 1.4525 | 1.4525 | 1.45 | 1.45 | 25200.0 |
| 2005-03-09 08:08:00 | AAPL | Stock | 1.45 | 1.4518 | 1.45 | 1.4518 | 88200.0 |
| 2005-03-09 08:09:00 | AAPL | Stock | 1.4496 | 1.45 | 1.4496 | 1.45 | 12600.0 |
| 2005-03-09 08:10:00 | AAPL | Stock | 1.4496 | 1.45 | 1.4471 | 1.4486 | 60088.0 |
| 2005-03-09 08:12:00 | AAPL | Stock | 1.4464 | 1.4475 | 1.4446 | 1.4446 | 33600.0 |
| 2005-03-09 08:13:00 | AAPL | Stock | 1.4446 | 1.4446 | 1.4411 | 1.4411 | 84000.0 |
| 2005-03-09 08:14:00 | AAPL | Stock | 1.4368 | 1.4414 | 1.4329 | 1.4411 | 168000.0 |
| 2005-03-09 08:15:00 | AAPL | Stock | 1.4411 | 1.4414 | 1.4411 | 1.4414 | 22400.0 |
| 2005-03-09 08:16:00 | AAPL | Stock | 1.4414 | 1.4414 | 1.4393 | 1.4396 | 84000.0 |
| 2005-03-09 08:17:00 | AAPL | Stock | 1.4411 | 1.4411 | 1.4393 | 1.4393 | 126000.0 |
| 2005-03-09 08:18:00 | AAPL | Stock | 1.4375 | 1.4382 | 1.4357 | 1.4375 | 42560.0 |
| 2005-03-09 08:19:00 | AAPL | Stock | 1.4368 | 1.4368 | 1.4346 | 1.4368 | 117040.0 |
| 2005-03-09 08:20:00 | AAPL | Stock | 1.4364 | 1.4364 | 1.4346 | 1.4357 | 16800.0 |
| 2005-03-09 08:21:00 | AAPL | Stock | 1.4339 | 1.4357 | 1.4329 | 1.4357 | 59108.0 |
| 2005-03-09 08:22:00 | AAPL | Stock | 1.4339 | 1.4339 | 1.4325 | 1.4339 | 69384.0 |
| 2005-03-09 08:23:00 | AAPL | Stock | 1.4357 | 1.4375 | 1.4325 | 1.4339 | 388752.0 |
| 2005-03-09 08:24:00 | AAPL | Stock | 1.4339 | 1.4339 | 1.4329 | 1.4339 | 202832.0 |
| 2005-03-09 08:25:00 | AAPL | Stock | 1.4325 | 1.4336 | 1.4289 | 1.4289 | 341292.0 |
| 2005-03-09 08:26:00 | AAPL | Stock | 1.4289 | 1.43 | 1.4286 | 1.4293 | 438200.0 |
| 2005-03-09 08:27:00 | AAPL | Stock | 1.4304 | 1.4318 | 1.4296 | 1.4307 | 40600.0 |
| 2005-03-09 08:28:00 | AAPL | Stock | 1.4307 | 1.4307 | 1.4268 | 1.4268 | 156800.0 |
| 2005-03-09 08:29:00 | AAPL | Stock | 1.43 | 1.43 | 1.4268 | 1.4268 | 344008.0 |
| 2005-03-09 08:30:00 | AAPL | Stock | 1.4261 | 1.4264 | 1.4239 | 1.425 | 179200.0 |
| 2005-03-09 08:31:00 | AAPL | Stock | 1.4257 | 1.4261 | 1.4236 | 1.4246 | 162400.0 |
| 2005-03-09 08:32:00 | AAPL | Stock | 1.4243 | 1.425 | 1.4232 | 1.4232 | 305200.0 |
| 2005-03-09 08:33:00 | AAPL | Stock | 1.4246 | 1.4246 | 1.4229 | 1.4232 | 137200.0 |
| 2005-03-09 08:34:00 | AAPL | Stock | 1.4232 | 1.4232 | 1.4196 | 1.4196 | 149800.0 |
| 2005-03-09 08:35:00 | AAPL | Stock | 1.4196 | 1.4196 | 1.4125 | 1.4143 | 480004.0 |
| 2005-03-09 08:36:00 | AAPL | Stock | 1.4139 | 1.4196 | 1.4125 | 1.4143 | 828884.0 |
| 2005-03-09 08:37:00 | AAPL | Stock | 1.4161 | 1.4161 | 1.4114 | 1.4143 | 174160.0 |
| 2005-03-09 08:38:00 | AAPL | Stock | 1.4157 | 1.4157 | 1.4143 | 1.415 | 203140.0 |
| 2005-03-09 08:39:00 | AAPL | Stock | 1.415 | 1.4164 | 1.4136 | 1.4161 | 577108.0 |
| 2005-03-09 08:40:00 | AAPL | Stock | 1.4139 | 1.4157 | 1.4125 | 1.4143 | 253176.0 |
| 2005-03-09 08:41:00 | AAPL | Stock | 1.4143 | 1.4143 | 1.4114 | 1.4125 | 211400.0 |
| 2005-03-09 08:42:00 | AAPL | Stock | 1.4125 | 1.4125 | 1.4075 | 1.4096 | 514696.0 |
| 2005-03-09 08:43:00 | AAPL | Stock | 1.4079 | 1.4118 | 1.4075 | 1.4089 | 435260.0 |
| 2005-03-09 08:44:00 | AAPL | Stock | 1.4086 | 1.4089 | 1.4071 | 1.4075 | 330400.0 |
| 2005-03-09 08:45:00 | AAPL | Stock | 1.4071 | 1.4468 | 1.4054 | 1.4054 | 465780.0 |
| 2005-03-09 08:46:00 | AAPL | Stock | 1.4054 | 1.4068 | 1.4036 | 1.4039 | 341600.0 |
| 2005-03-09 08:47:00 | AAPL | Stock | 1.4039 | 1.4054 | 1.4025 | 1.4036 | 374248.0 |
| 2005-03-09 08:48:00 | AAPL | Stock | 1.4032 | 1.4054 | 1.4025 | 1.4054 | 333648.0 |
| 2005-03-09 08:49:00 | AAPL | Stock | 1.4025 | 1.4029 | 1.4 | 1.4018 | 729932.0 |
| 2005-03-09 08:50:00 | AAPL | Stock | 1.4004 | 1.4068 | 1.4004 | 1.4061 | 502656.0 |
> showing 50 of 560,077 rows — these rows as CSV