PREVIEW / stock_5min / 2009-09-30
file: by_date/stock_5min/2009/2009-09-30.parquet size: 5.0 MB rows: 337,403 symbols: 3,400
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-30 06:10:00 | AAPL | Stock | 6.6671 | 6.6671 | 6.6671 | 6.6671 | 2800.0 |
| 2009-09-30 06:55:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 2800.0 |
| 2009-09-30 07:05:00 | AAPL | Stock | 6.6257 | 6.6429 | 6.6257 | 6.6429 | 19600.0 |
| 2009-09-30 07:10:00 | AAPL | Stock | 6.6429 | 6.65 | 6.6429 | 6.6432 | 22260.0 |
| 2009-09-30 07:20:00 | AAPL | Stock | 6.645 | 6.645 | 6.645 | 6.645 | 5600.0 |
| 2009-09-30 07:30:00 | AAPL | Stock | 6.6446 | 6.6446 | 6.6446 | 6.6446 | 9800.0 |
| 2009-09-30 07:35:00 | AAPL | Stock | 6.6554 | 6.6564 | 6.6554 | 6.6564 | 5600.0 |
| 2009-09-30 07:40:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.6554 | 6.6554 | 2800.0 |
| 2009-09-30 07:45:00 | AAPL | Stock | 6.645 | 6.645 | 6.645 | 6.645 | 2800.0 |
| 2009-09-30 07:55:00 | AAPL | Stock | 6.65 | 6.6557 | 6.65 | 6.6518 | 30800.0 |
| 2009-09-30 08:00:00 | AAPL | Stock | 6.6554 | 6.6564 | 6.65 | 6.6536 | 189952.0 |
| 2009-09-30 08:05:00 | AAPL | Stock | 6.6536 | 6.6625 | 6.6536 | 6.6564 | 64792.0 |
| 2009-09-30 08:10:00 | AAPL | Stock | 6.6554 | 6.6621 | 6.6554 | 6.6614 | 82180.0 |
| 2009-09-30 08:15:00 | AAPL | Stock | 6.6589 | 6.6589 | 6.6429 | 6.6518 | 195020.0 |
| 2009-09-30 08:20:00 | AAPL | Stock | 6.6518 | 6.6532 | 6.6518 | 6.6532 | 30352.0 |
| 2009-09-30 08:25:00 | AAPL | Stock | 6.6518 | 6.6564 | 6.6518 | 6.6564 | 61964.0 |
| 2009-09-30 08:30:00 | AAPL | Stock | 6.6589 | 6.6661 | 6.6564 | 6.6629 | 164612.0 |
| 2009-09-30 08:35:00 | AAPL | Stock | 6.6589 | 6.6607 | 6.6536 | 6.6536 | 171472.0 |
| 2009-09-30 08:40:00 | AAPL | Stock | 6.6536 | 6.6546 | 6.6536 | 6.6546 | 14000.0 |
| 2009-09-30 08:45:00 | AAPL | Stock | 6.6518 | 6.6518 | 6.6454 | 6.6518 | 201180.0 |
| 2009-09-30 08:50:00 | AAPL | Stock | 6.655 | 6.655 | 6.6471 | 6.6489 | 78400.0 |
| 2009-09-30 08:55:00 | AAPL | Stock | 6.6482 | 6.6489 | 6.6482 | 6.6486 | 48440.0 |
| 2009-09-30 09:00:00 | AAPL | Stock | 6.6489 | 6.65 | 6.6482 | 6.65 | 64260.0 |
| 2009-09-30 09:05:00 | AAPL | Stock | 6.6482 | 6.6518 | 6.6468 | 6.6518 | 116200.0 |
| 2009-09-30 09:10:00 | AAPL | Stock | 6.6536 | 6.6536 | 6.6486 | 6.6525 | 35336.0 |
| 2009-09-30 09:15:00 | AAPL | Stock | 6.6496 | 6.6496 | 6.6496 | 6.6496 | 5600.0 |
| 2009-09-30 09:20:00 | AAPL | Stock | 6.6493 | 6.6493 | 6.6446 | 6.6464 | 58016.0 |
| 2009-09-30 09:25:00 | AAPL | Stock | 6.6432 | 6.6479 | 6.6429 | 6.6475 | 60200.0 |
| 2009-09-30 09:30:00 | AAPL | Stock | 6.6475 | 6.6496 | 6.625 | 6.6282 | 13085128.0 |
| 2009-09-30 09:35:00 | AAPL | Stock | 6.6282 | 6.6518 | 6.6236 | 6.6493 | 9966096.0 |
| 2009-09-30 09:40:00 | AAPL | Stock | 6.6493 | 6.6543 | 6.6114 | 6.6157 | 10938704.0 |
| 2009-09-30 09:45:00 | AAPL | Stock | 6.6157 | 6.6163 | 6.56 | 6.5675 | 18249896.0 |
| 2009-09-30 09:50:00 | AAPL | Stock | 6.5654 | 6.5793 | 6.5475 | 6.5757 | 14953708.0 |
| 2009-09-30 09:55:00 | AAPL | Stock | 6.5754 | 6.5804 | 6.5219 | 6.5485 | 15683640.0 |
| 2009-09-30 10:00:00 | AAPL | Stock | 6.5475 | 6.56 | 6.5357 | 6.5439 | 10445652.0 |
| 2009-09-30 10:05:00 | AAPL | Stock | 6.5446 | 6.56 | 6.5286 | 6.5389 | 7473788.0 |
| 2009-09-30 10:10:00 | AAPL | Stock | 6.5379 | 6.5525 | 6.5357 | 6.5493 | 5294632.0 |
| 2009-09-30 10:15:00 | AAPL | Stock | 6.5504 | 6.5507 | 6.5357 | 6.5443 | 7120512.0 |
| 2009-09-30 10:20:00 | AAPL | Stock | 6.5443 | 6.5457 | 6.5375 | 6.5407 | 5431356.0 |
| 2009-09-30 10:25:00 | AAPL | Stock | 6.5386 | 6.5564 | 6.5286 | 6.5504 | 9526944.0 |
| 2009-09-30 10:30:00 | AAPL | Stock | 6.5504 | 6.5554 | 6.5375 | 6.5543 | 5067384.0 |
| 2009-09-30 10:35:00 | AAPL | Stock | 6.5543 | 6.5671 | 6.5518 | 6.5618 | 6056540.0 |
| 2009-09-30 10:40:00 | AAPL | Stock | 6.5618 | 6.5618 | 6.5436 | 6.55 | 4882332.0 |
| 2009-09-30 10:45:00 | AAPL | Stock | 6.5504 | 6.5539 | 6.5393 | 6.5404 | 4639572.0 |
| 2009-09-30 10:50:00 | AAPL | Stock | 6.5403 | 6.5486 | 6.5402 | 6.5457 | 3694796.0 |
| 2009-09-30 10:55:00 | AAPL | Stock | 6.5457 | 6.5521 | 6.5411 | 6.5454 | 5992812.0 |
| 2009-09-30 11:00:00 | AAPL | Stock | 6.545 | 6.5607 | 6.5436 | 6.5546 | 4844168.0 |
| 2009-09-30 11:05:00 | AAPL | Stock | 6.5557 | 6.5629 | 6.5518 | 6.5546 | 3701460.0 |
| 2009-09-30 11:10:00 | AAPL | Stock | 6.5543 | 6.5586 | 6.5507 | 6.5507 | 3778880.0 |
| 2009-09-30 11:15:00 | AAPL | Stock | 6.5511 | 6.5696 | 6.55 | 6.5668 | 5704300.0 |
> showing 50 of 337,403 rows — these rows as CSV