PREVIEW / stock_5min / 2004-06-14
file: by_date/stock_5min/2004/2004-06-14.parquet size: 2.5 MB rows: 185,942 symbols: 1,785
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-14 08:00:00 | AAPL | Stock | 0.5455 | 0.5455 | 0.5455 | 0.5455 | 56000.0 |
| 2004-06-14 08:05:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 5600.0 |
| 2004-06-14 08:10:00 | AAPL | Stock | 0.5445 | 0.5445 | 0.5445 | 0.5445 | 22400.0 |
| 2004-06-14 08:15:00 | AAPL | Stock | 0.5446 | 0.5448 | 0.5446 | 0.5448 | 72800.0 |
| 2004-06-14 08:20:00 | AAPL | Stock | 0.5448 | 0.5448 | 0.5446 | 0.5446 | 33600.0 |
| 2004-06-14 08:25:00 | AAPL | Stock | 0.5446 | 0.5489 | 0.5446 | 0.5489 | 78400.0 |
| 2004-06-14 08:30:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 28000.0 |
| 2004-06-14 08:35:00 | AAPL | Stock | 0.5438 | 0.5438 | 0.5438 | 0.5438 | 5600.0 |
| 2004-06-14 08:40:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5446 | 0.5446 | 56000.0 |
| 2004-06-14 08:45:00 | AAPL | Stock | 0.5454 | 0.5454 | 0.5454 | 0.5454 | 5600.0 |
| 2004-06-14 08:50:00 | AAPL | Stock | 0.5454 | 0.5454 | 0.5454 | 0.5454 | 25200.0 |
| 2004-06-14 08:55:00 | AAPL | Stock | 0.5454 | 0.5455 | 0.5454 | 0.5455 | 53200.0 |
| 2004-06-14 09:10:00 | AAPL | Stock | 0.5455 | 0.5455 | 0.5455 | 0.5455 | 22400.0 |
| 2004-06-14 09:15:00 | AAPL | Stock | 0.5459 | 0.5459 | 0.5459 | 0.5459 | 5600.0 |
| 2004-06-14 09:25:00 | AAPL | Stock | 0.5455 | 0.5477 | 0.545 | 0.5473 | 587944.0 |
| 2004-06-14 09:30:00 | AAPL | Stock | 0.5473 | 0.5479 | 0.5439 | 0.5439 | 10605280.0 |
| 2004-06-14 09:35:00 | AAPL | Stock | 0.5438 | 0.5448 | 0.5427 | 0.5446 | 6107976.0 |
| 2004-06-14 09:40:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5434 | 0.5434 | 4432288.0 |
| 2004-06-14 09:45:00 | AAPL | Stock | 0.5436 | 0.5438 | 0.5427 | 0.543 | 5184256.0 |
| 2004-06-14 09:50:00 | AAPL | Stock | 0.5432 | 0.5443 | 0.5429 | 0.5443 | 3005744.0 |
| 2004-06-14 09:55:00 | AAPL | Stock | 0.5439 | 0.5446 | 0.5432 | 0.5443 | 2913568.0 |
| 2004-06-14 10:00:00 | AAPL | Stock | 0.5439 | 0.5446 | 0.5432 | 0.5446 | 2340744.0 |
| 2004-06-14 10:05:00 | AAPL | Stock | 0.5446 | 0.5446 | 0.5435 | 0.5436 | 8832600.0 |
| 2004-06-14 10:10:00 | AAPL | Stock | 0.5438 | 0.5446 | 0.5436 | 0.5443 | 2961336.0 |
| 2004-06-14 10:15:00 | AAPL | Stock | 0.5441 | 0.5443 | 0.5434 | 0.5439 | 2988384.0 |
| 2004-06-14 10:20:00 | AAPL | Stock | 0.5439 | 0.5439 | 0.542 | 0.542 | 2780176.0 |
| 2004-06-14 10:25:00 | AAPL | Stock | 0.542 | 0.5443 | 0.5413 | 0.5441 | 8620080.0 |
| 2004-06-14 10:30:00 | AAPL | Stock | 0.5439 | 0.5443 | 0.5411 | 0.5416 | 9437176.0 |
| 2004-06-14 10:35:00 | AAPL | Stock | 0.5416 | 0.5423 | 0.5414 | 0.5421 | 2553656.0 |
| 2004-06-14 10:40:00 | AAPL | Stock | 0.5421 | 0.5427 | 0.5416 | 0.5421 | 2372664.0 |
| 2004-06-14 10:45:00 | AAPL | Stock | 0.5421 | 0.5421 | 0.5407 | 0.5407 | 2663304.0 |
| 2004-06-14 10:50:00 | AAPL | Stock | 0.5407 | 0.5411 | 0.5388 | 0.5398 | 5709032.0 |
| 2004-06-14 10:55:00 | AAPL | Stock | 0.5398 | 0.5405 | 0.5396 | 0.5402 | 1932392.0 |
| 2004-06-14 11:00:00 | AAPL | Stock | 0.5402 | 0.5404 | 0.5393 | 0.5396 | 4896416.0 |
| 2004-06-14 11:05:00 | AAPL | Stock | 0.5396 | 0.5405 | 0.5393 | 0.5405 | 1594656.0 |
| 2004-06-14 11:10:00 | AAPL | Stock | 0.5407 | 0.5411 | 0.54 | 0.5411 | 4222120.0 |
| 2004-06-14 11:15:00 | AAPL | Stock | 0.5411 | 0.542 | 0.5411 | 0.5418 | 2016168.0 |
| 2004-06-14 11:20:00 | AAPL | Stock | 0.542 | 0.542 | 0.5411 | 0.5413 | 1044176.0 |
| 2004-06-14 11:25:00 | AAPL | Stock | 0.5411 | 0.5411 | 0.5402 | 0.5402 | 763224.0 |
| 2004-06-14 11:30:00 | AAPL | Stock | 0.54 | 0.5416 | 0.5398 | 0.5404 | 1157744.0 |
| 2004-06-14 11:35:00 | AAPL | Stock | 0.5404 | 0.5405 | 0.5402 | 0.5404 | 234528.0 |
| 2004-06-14 11:40:00 | AAPL | Stock | 0.5405 | 0.5405 | 0.5396 | 0.54 | 539672.0 |
| 2004-06-14 11:45:00 | AAPL | Stock | 0.5396 | 0.54 | 0.5393 | 0.5398 | 1214528.0 |
| 2004-06-14 11:50:00 | AAPL | Stock | 0.5398 | 0.5405 | 0.5395 | 0.5395 | 1038296.0 |
| 2004-06-14 11:55:00 | AAPL | Stock | 0.5395 | 0.5398 | 0.5393 | 0.5395 | 1492624.0 |
| 2004-06-14 12:00:00 | AAPL | Stock | 0.5395 | 0.5396 | 0.5388 | 0.5391 | 2865632.0 |
| 2004-06-14 12:05:00 | AAPL | Stock | 0.5386 | 0.5388 | 0.5361 | 0.5368 | 4543672.0 |
| 2004-06-14 12:10:00 | AAPL | Stock | 0.5368 | 0.537 | 0.5359 | 0.5364 | 4445560.0 |
| 2004-06-14 12:15:00 | AAPL | Stock | 0.5364 | 0.5375 | 0.5363 | 0.537 | 2745288.0 |
| 2004-06-14 12:20:00 | AAPL | Stock | 0.537 | 0.5371 | 0.5364 | 0.5364 | 1368640.0 |
> showing 50 of 185,942 rows — these rows as CSV