PREVIEW / stock_5min / 2002-05-20
file: by_date/stock_5min/2002/2002-05-20.parquet size: 1.7 MB rows: 118,747 symbols: 1,419
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-20 08:05:00 | AAPL | Stock | 0.4461 | 0.4461 | 0.4461 | 0.4461 | 5600.0 |
| 2002-05-20 08:25:00 | AAPL | Stock | 0.4436 | 0.4436 | 0.4379 | 0.4379 | 28000.0 |
| 2002-05-20 08:30:00 | AAPL | Stock | 0.4379 | 0.4382 | 0.4379 | 0.4382 | 11200.0 |
| 2002-05-20 08:40:00 | AAPL | Stock | 0.4382 | 0.4382 | 0.4382 | 0.4382 | 11200.0 |
| 2002-05-20 08:45:00 | AAPL | Stock | 0.4382 | 0.4457 | 0.4382 | 0.4457 | 44800.0 |
| 2002-05-20 08:55:00 | AAPL | Stock | 0.445 | 0.445 | 0.445 | 0.445 | 11200.0 |
| 2002-05-20 09:05:00 | AAPL | Stock | 0.4438 | 0.4443 | 0.4438 | 0.4443 | 67200.0 |
| 2002-05-20 09:10:00 | AAPL | Stock | 0.4439 | 0.4448 | 0.4438 | 0.4448 | 56000.0 |
| 2002-05-20 09:15:00 | AAPL | Stock | 0.4438 | 0.4438 | 0.4438 | 0.4438 | 33600.0 |
| 2002-05-20 09:20:00 | AAPL | Stock | 0.443 | 0.443 | 0.4425 | 0.4425 | 106400.0 |
| 2002-05-20 09:25:00 | AAPL | Stock | 0.442 | 0.442 | 0.4382 | 0.4391 | 744800.0 |
| 2002-05-20 09:30:00 | AAPL | Stock | 0.4388 | 0.442 | 0.438 | 0.4404 | 10953600.0 |
| 2002-05-20 09:35:00 | AAPL | Stock | 0.4405 | 0.4416 | 0.4398 | 0.4411 | 11771200.0 |
| 2002-05-20 09:40:00 | AAPL | Stock | 0.4411 | 0.442 | 0.4388 | 0.4398 | 7145600.0 |
| 2002-05-20 09:45:00 | AAPL | Stock | 0.4396 | 0.4418 | 0.4396 | 0.4411 | 15556800.0 |
| 2002-05-20 09:50:00 | AAPL | Stock | 0.4413 | 0.442 | 0.4404 | 0.4405 | 8568000.0 |
| 2002-05-20 09:55:00 | AAPL | Stock | 0.4405 | 0.4415 | 0.4404 | 0.4411 | 6255200.0 |
| 2002-05-20 10:00:00 | AAPL | Stock | 0.4411 | 0.442 | 0.4391 | 0.4398 | 5975200.0 |
| 2002-05-20 10:05:00 | AAPL | Stock | 0.4402 | 0.4409 | 0.4393 | 0.4393 | 2861600.0 |
| 2002-05-20 10:10:00 | AAPL | Stock | 0.4396 | 0.4405 | 0.4393 | 0.4398 | 8288000.0 |
| 2002-05-20 10:15:00 | AAPL | Stock | 0.4398 | 0.4411 | 0.4396 | 0.4403 | 4200000.0 |
| 2002-05-20 10:20:00 | AAPL | Stock | 0.44 | 0.4404 | 0.4393 | 0.4395 | 5236000.0 |
| 2002-05-20 10:25:00 | AAPL | Stock | 0.4402 | 0.4414 | 0.44 | 0.4414 | 2996000.0 |
| 2002-05-20 10:30:00 | AAPL | Stock | 0.4413 | 0.4414 | 0.4404 | 0.4407 | 5073600.0 |
| 2002-05-20 10:35:00 | AAPL | Stock | 0.4409 | 0.4438 | 0.4405 | 0.4432 | 4429600.0 |
| 2002-05-20 10:40:00 | AAPL | Stock | 0.4432 | 0.4434 | 0.4418 | 0.4423 | 3824800.0 |
| 2002-05-20 10:45:00 | AAPL | Stock | 0.4423 | 0.4423 | 0.44 | 0.4411 | 2676800.0 |
| 2002-05-20 10:50:00 | AAPL | Stock | 0.4413 | 0.4418 | 0.4404 | 0.4411 | 4519200.0 |
| 2002-05-20 10:55:00 | AAPL | Stock | 0.4411 | 0.4421 | 0.4405 | 0.4407 | 4866400.0 |
| 2002-05-20 11:00:00 | AAPL | Stock | 0.4411 | 0.4413 | 0.4388 | 0.4396 | 5672800.0 |
| 2002-05-20 11:05:00 | AAPL | Stock | 0.4396 | 0.4402 | 0.4389 | 0.4389 | 2408000.0 |
| 2002-05-20 11:10:00 | AAPL | Stock | 0.4398 | 0.4402 | 0.4393 | 0.44 | 5583200.0 |
| 2002-05-20 11:15:00 | AAPL | Stock | 0.44 | 0.4409 | 0.4395 | 0.4404 | 5521600.0 |
| 2002-05-20 11:20:00 | AAPL | Stock | 0.4404 | 0.4407 | 0.4393 | 0.4395 | 3264800.0 |
| 2002-05-20 11:25:00 | AAPL | Stock | 0.4396 | 0.4402 | 0.4393 | 0.4398 | 873600.0 |
| 2002-05-20 11:30:00 | AAPL | Stock | 0.4401 | 0.4405 | 0.4391 | 0.4391 | 3500000.0 |
| 2002-05-20 11:35:00 | AAPL | Stock | 0.4391 | 0.4404 | 0.4389 | 0.4398 | 1596000.0 |
| 2002-05-20 11:40:00 | AAPL | Stock | 0.44 | 0.4404 | 0.4393 | 0.4393 | 6535200.0 |
| 2002-05-20 11:45:00 | AAPL | Stock | 0.4393 | 0.4402 | 0.4389 | 0.4398 | 2396800.0 |
| 2002-05-20 11:50:00 | AAPL | Stock | 0.4396 | 0.44 | 0.4396 | 0.4396 | 1058400.0 |
| 2002-05-20 11:55:00 | AAPL | Stock | 0.4402 | 0.4404 | 0.44 | 0.44 | 1142400.0 |
| 2002-05-20 12:00:00 | AAPL | Stock | 0.4402 | 0.4402 | 0.4384 | 0.4389 | 4457600.0 |
| 2002-05-20 12:05:00 | AAPL | Stock | 0.4389 | 0.4396 | 0.4388 | 0.4389 | 235200.0 |
| 2002-05-20 12:10:00 | AAPL | Stock | 0.4389 | 0.4389 | 0.4386 | 0.4386 | 414400.0 |
| 2002-05-20 12:15:00 | AAPL | Stock | 0.4384 | 0.4393 | 0.4384 | 0.4393 | 918400.0 |
| 2002-05-20 12:20:00 | AAPL | Stock | 0.4393 | 0.4398 | 0.4393 | 0.4393 | 789600.0 |
| 2002-05-20 12:25:00 | AAPL | Stock | 0.4393 | 0.44 | 0.4389 | 0.4393 | 3914400.0 |
| 2002-05-20 12:30:00 | AAPL | Stock | 0.4393 | 0.4396 | 0.4389 | 0.4393 | 1327200.0 |
| 2002-05-20 12:35:00 | AAPL | Stock | 0.4393 | 0.4396 | 0.4393 | 0.4393 | 1125600.0 |
| 2002-05-20 12:40:00 | AAPL | Stock | 0.4395 | 0.4404 | 0.4395 | 0.44 | 1904000.0 |
> showing 50 of 118,747 rows — these rows as CSV