PREVIEW / stock_1min / 2001-04-23
file: by_date/stock_1min/2001/2001-04-23.parquet size: 3.0 MB rows: 243,823 symbols: 1,055
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-23 08:02:00 | AAPL | Stock | 0.447 | 0.447 | 0.447 | 0.447 | 1702400.0 |
| 2001-04-23 08:11:00 | AAPL | Stock | 0.4423 | 0.4423 | 0.4423 | 0.4423 | 50400.0 |
| 2001-04-23 08:24:00 | AAPL | Stock | 0.4421 | 0.4421 | 0.4421 | 0.4421 | 11200.0 |
| 2001-04-23 08:28:00 | AAPL | Stock | 0.4393 | 0.4405 | 0.4393 | 0.4405 | 78400.0 |
| 2001-04-23 08:32:00 | AAPL | Stock | 0.4416 | 0.4416 | 0.4416 | 0.4416 | 5600.0 |
| 2001-04-23 08:33:00 | AAPL | Stock | 0.4429 | 0.4429 | 0.4429 | 0.4429 | 16800.0 |
| 2001-04-23 08:34:00 | AAPL | Stock | 0.4429 | 0.4429 | 0.4429 | 0.4429 | 56000.0 |
| 2001-04-23 08:35:00 | AAPL | Stock | 0.4429 | 0.4429 | 0.4429 | 0.4429 | 16800.0 |
| 2001-04-23 08:36:00 | AAPL | Stock | 0.4429 | 0.4429 | 0.4429 | 0.4429 | 16800.0 |
| 2001-04-23 08:38:00 | AAPL | Stock | 0.4446 | 0.4446 | 0.4429 | 0.4429 | 56000.0 |
| 2001-04-23 08:39:00 | AAPL | Stock | 0.4446 | 0.4446 | 0.4446 | 0.4446 | 5600.0 |
| 2001-04-23 08:45:00 | AAPL | Stock | 0.4438 | 0.4438 | 0.4438 | 0.4438 | 56000.0 |
| 2001-04-23 08:48:00 | AAPL | Stock | 0.4439 | 0.4439 | 0.4439 | 0.4439 | 33600.0 |
| 2001-04-23 08:49:00 | AAPL | Stock | 0.4446 | 0.4446 | 0.4446 | 0.4446 | 16800.0 |
| 2001-04-23 09:02:00 | AAPL | Stock | 0.4429 | 0.4429 | 0.4429 | 0.4429 | 28000.0 |
| 2001-04-23 09:03:00 | AAPL | Stock | 0.4446 | 0.4446 | 0.4446 | 0.4446 | 28000.0 |
| 2001-04-23 09:05:00 | AAPL | Stock | 0.4446 | 0.4446 | 0.4438 | 0.4446 | 33600.0 |
| 2001-04-23 09:10:00 | AAPL | Stock | 0.443 | 0.443 | 0.443 | 0.443 | 22400.0 |
| 2001-04-23 09:17:00 | AAPL | Stock | 0.4402 | 0.4402 | 0.4402 | 0.4402 | 16800.0 |
| 2001-04-23 09:18:00 | AAPL | Stock | 0.4402 | 0.4402 | 0.4402 | 0.4402 | 11200.0 |
| 2001-04-23 09:22:00 | AAPL | Stock | 0.4429 | 0.4429 | 0.4429 | 0.4429 | 11200.0 |
| 2001-04-23 09:23:00 | AAPL | Stock | 0.4421 | 0.4421 | 0.4421 | 0.4421 | 72800.0 |
| 2001-04-23 09:26:00 | AAPL | Stock | 0.4418 | 0.4418 | 0.4393 | 0.4393 | 380800.0 |
| 2001-04-23 09:27:00 | AAPL | Stock | 0.4393 | 0.4393 | 0.4377 | 0.4377 | 78400.0 |
| 2001-04-23 09:28:00 | AAPL | Stock | 0.4377 | 0.4377 | 0.4375 | 0.4375 | 184800.0 |
| 2001-04-23 09:29:00 | AAPL | Stock | 0.4357 | 0.4371 | 0.4339 | 0.4339 | 336000.0 |
| 2001-04-23 09:30:00 | AAPL | Stock | 0.4345 | 0.4373 | 0.4327 | 0.4332 | 1019200.0 |
| 2001-04-23 09:31:00 | AAPL | Stock | 0.4332 | 0.4346 | 0.4327 | 0.433 | 3875200.0 |
| 2001-04-23 09:32:00 | AAPL | Stock | 0.433 | 0.4354 | 0.433 | 0.4346 | 2749600.0 |
| 2001-04-23 09:33:00 | AAPL | Stock | 0.4354 | 0.4354 | 0.433 | 0.4345 | 1248800.0 |
| 2001-04-23 09:34:00 | AAPL | Stock | 0.4343 | 0.4355 | 0.4332 | 0.4348 | 1052800.0 |
| 2001-04-23 09:35:00 | AAPL | Stock | 0.435 | 0.4375 | 0.435 | 0.4373 | 1327200.0 |
| 2001-04-23 09:36:00 | AAPL | Stock | 0.4375 | 0.4375 | 0.4368 | 0.437 | 1461600.0 |
| 2001-04-23 09:37:00 | AAPL | Stock | 0.437 | 0.4386 | 0.4368 | 0.4382 | 1316000.0 |
| 2001-04-23 09:38:00 | AAPL | Stock | 0.4382 | 0.4393 | 0.4375 | 0.4393 | 2788800.0 |
| 2001-04-23 09:39:00 | AAPL | Stock | 0.4393 | 0.4409 | 0.4389 | 0.4405 | 2917600.0 |
| 2001-04-23 09:40:00 | AAPL | Stock | 0.4404 | 0.4407 | 0.4396 | 0.44 | 1377600.0 |
| 2001-04-23 09:41:00 | AAPL | Stock | 0.4396 | 0.4407 | 0.4391 | 0.4391 | 1489600.0 |
| 2001-04-23 09:42:00 | AAPL | Stock | 0.4398 | 0.4398 | 0.4375 | 0.4375 | 834400.0 |
| 2001-04-23 09:43:00 | AAPL | Stock | 0.4375 | 0.4393 | 0.4375 | 0.4391 | 2688000.0 |
| 2001-04-23 09:44:00 | AAPL | Stock | 0.4384 | 0.4393 | 0.4384 | 0.4393 | 2850400.0 |
| 2001-04-23 09:45:00 | AAPL | Stock | 0.4396 | 0.4398 | 0.4386 | 0.4389 | 2217600.0 |
| 2001-04-23 09:46:00 | AAPL | Stock | 0.4393 | 0.4393 | 0.4366 | 0.4375 | 554400.0 |
| 2001-04-23 09:47:00 | AAPL | Stock | 0.4366 | 0.4375 | 0.4366 | 0.4375 | 739200.0 |
| 2001-04-23 09:48:00 | AAPL | Stock | 0.4373 | 0.4396 | 0.4373 | 0.4384 | 1657600.0 |
| 2001-04-23 09:49:00 | AAPL | Stock | 0.4396 | 0.4407 | 0.4377 | 0.4377 | 414400.0 |
| 2001-04-23 09:50:00 | AAPL | Stock | 0.4386 | 0.4386 | 0.4357 | 0.4357 | 952000.0 |
| 2001-04-23 09:51:00 | AAPL | Stock | 0.4357 | 0.4363 | 0.4339 | 0.4341 | 968800.0 |
| 2001-04-23 09:52:00 | AAPL | Stock | 0.435 | 0.435 | 0.4341 | 0.4348 | 946400.0 |
| 2001-04-23 09:53:00 | AAPL | Stock | 0.4348 | 0.4357 | 0.4343 | 0.4345 | 2296000.0 |
> showing 50 of 243,823 rows — these rows as CSV