PREVIEW / stock_5min / 2004-06-08
file: by_date/stock_5min/2004/2004-06-08.parquet size: 2.3 MB rows: 169,438 symbols: 1,784
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-08 08:00:00 | AAPL | Stock | 0.5338 | 0.5348 | 0.5332 | 0.5346 | 84000.0 |
| 2004-06-08 08:05:00 | AAPL | Stock | 0.5346 | 0.5346 | 0.5343 | 0.5343 | 29848.0 |
| 2004-06-08 08:10:00 | AAPL | Stock | 0.5346 | 0.5357 | 0.5346 | 0.5357 | 418880.0 |
| 2004-06-08 08:15:00 | AAPL | Stock | 0.5357 | 0.5357 | 0.5336 | 0.5336 | 50400.0 |
| 2004-06-08 08:30:00 | AAPL | Stock | 0.5357 | 0.5357 | 0.5355 | 0.5355 | 58800.0 |
| 2004-06-08 08:35:00 | AAPL | Stock | 0.5357 | 0.5357 | 0.5355 | 0.5357 | 95200.0 |
| 2004-06-08 08:40:00 | AAPL | Stock | 0.5355 | 0.5402 | 0.5355 | 0.5402 | 901600.0 |
| 2004-06-08 08:45:00 | AAPL | Stock | 0.5398 | 0.54 | 0.5384 | 0.5391 | 252000.0 |
| 2004-06-08 08:50:00 | AAPL | Stock | 0.5384 | 0.5384 | 0.5366 | 0.5366 | 262080.0 |
| 2004-06-08 08:55:00 | AAPL | Stock | 0.5366 | 0.5366 | 0.5366 | 0.5366 | 16800.0 |
| 2004-06-08 09:00:00 | AAPL | Stock | 0.5355 | 0.5355 | 0.5327 | 0.5339 | 404600.0 |
| 2004-06-08 09:05:00 | AAPL | Stock | 0.5343 | 0.5348 | 0.5339 | 0.5339 | 39200.0 |
| 2004-06-08 09:10:00 | AAPL | Stock | 0.5354 | 0.5366 | 0.5345 | 0.5345 | 44800.0 |
| 2004-06-08 09:15:00 | AAPL | Stock | 0.535 | 0.5357 | 0.535 | 0.5357 | 61600.0 |
| 2004-06-08 09:20:00 | AAPL | Stock | 0.5357 | 0.5366 | 0.5348 | 0.5348 | 123200.0 |
| 2004-06-08 09:25:00 | AAPL | Stock | 0.5354 | 0.5355 | 0.5341 | 0.5348 | 981008.0 |
| 2004-06-08 09:30:00 | AAPL | Stock | 0.5341 | 0.5359 | 0.5327 | 0.5357 | 15650376.0 |
| 2004-06-08 09:35:00 | AAPL | Stock | 0.5355 | 0.5386 | 0.5343 | 0.5357 | 23876664.0 |
| 2004-06-08 09:40:00 | AAPL | Stock | 0.5366 | 0.5405 | 0.5366 | 0.54 | 20715408.0 |
| 2004-06-08 09:45:00 | AAPL | Stock | 0.5396 | 0.5436 | 0.5386 | 0.5396 | 19005504.0 |
| 2004-06-08 09:50:00 | AAPL | Stock | 0.5398 | 0.5405 | 0.5382 | 0.5389 | 10455256.0 |
| 2004-06-08 09:55:00 | AAPL | Stock | 0.5391 | 0.5404 | 0.5348 | 0.535 | 12508216.0 |
| 2004-06-08 10:00:00 | AAPL | Stock | 0.535 | 0.5389 | 0.535 | 0.5382 | 10391808.0 |
| 2004-06-08 10:05:00 | AAPL | Stock | 0.5382 | 0.5402 | 0.5379 | 0.5396 | 9750496.0 |
| 2004-06-08 10:10:00 | AAPL | Stock | 0.5395 | 0.5414 | 0.5382 | 0.5389 | 6713056.0 |
| 2004-06-08 10:15:00 | AAPL | Stock | 0.5391 | 0.54 | 0.5375 | 0.5398 | 7296016.0 |
| 2004-06-08 10:20:00 | AAPL | Stock | 0.5398 | 0.5425 | 0.5396 | 0.5423 | 6461056.0 |
| 2004-06-08 10:25:00 | AAPL | Stock | 0.542 | 0.5432 | 0.5413 | 0.5418 | 7040656.0 |
| 2004-06-08 10:30:00 | AAPL | Stock | 0.5414 | 0.5418 | 0.5395 | 0.5404 | 7125272.0 |
| 2004-06-08 10:35:00 | AAPL | Stock | 0.5404 | 0.5404 | 0.5368 | 0.5375 | 13481384.0 |
| 2004-06-08 10:40:00 | AAPL | Stock | 0.5377 | 0.5391 | 0.5371 | 0.5386 | 5411168.0 |
| 2004-06-08 10:45:00 | AAPL | Stock | 0.5386 | 0.5388 | 0.5357 | 0.5366 | 11953032.0 |
| 2004-06-08 10:50:00 | AAPL | Stock | 0.5366 | 0.538 | 0.5366 | 0.5377 | 2749768.0 |
| 2004-06-08 10:55:00 | AAPL | Stock | 0.5375 | 0.5388 | 0.5375 | 0.5382 | 5772200.0 |
| 2004-06-08 11:00:00 | AAPL | Stock | 0.5382 | 0.5396 | 0.538 | 0.5391 | 2781128.0 |
| 2004-06-08 11:05:00 | AAPL | Stock | 0.5389 | 0.5391 | 0.537 | 0.5379 | 3760680.0 |
| 2004-06-08 11:10:00 | AAPL | Stock | 0.5379 | 0.5379 | 0.5366 | 0.5371 | 3469816.0 |
| 2004-06-08 11:15:00 | AAPL | Stock | 0.537 | 0.5371 | 0.5357 | 0.5366 | 3617152.0 |
| 2004-06-08 11:20:00 | AAPL | Stock | 0.5364 | 0.5371 | 0.5364 | 0.5366 | 1986992.0 |
| 2004-06-08 11:25:00 | AAPL | Stock | 0.5368 | 0.5371 | 0.5366 | 0.537 | 1606752.0 |
| 2004-06-08 11:30:00 | AAPL | Stock | 0.537 | 0.5373 | 0.5357 | 0.5371 | 4051992.0 |
| 2004-06-08 11:35:00 | AAPL | Stock | 0.5371 | 0.5375 | 0.5361 | 0.537 | 1925728.0 |
| 2004-06-08 11:40:00 | AAPL | Stock | 0.5368 | 0.537 | 0.5357 | 0.5363 | 3558912.0 |
| 2004-06-08 11:45:00 | AAPL | Stock | 0.5363 | 0.5363 | 0.5357 | 0.5359 | 1684088.0 |
| 2004-06-08 11:50:00 | AAPL | Stock | 0.5361 | 0.5371 | 0.5361 | 0.5371 | 2248904.0 |
| 2004-06-08 11:55:00 | AAPL | Stock | 0.5373 | 0.538 | 0.537 | 0.538 | 4598384.0 |
| 2004-06-08 12:00:00 | AAPL | Stock | 0.538 | 0.5382 | 0.5375 | 0.5382 | 2752848.0 |
| 2004-06-08 12:05:00 | AAPL | Stock | 0.538 | 0.5389 | 0.538 | 0.5382 | 1903272.0 |
| 2004-06-08 12:10:00 | AAPL | Stock | 0.5386 | 0.5391 | 0.5375 | 0.5375 | 2381120.0 |
| 2004-06-08 12:15:00 | AAPL | Stock | 0.5377 | 0.5382 | 0.5377 | 0.5382 | 1767136.0 |
> showing 50 of 169,438 rows — these rows as CSV