PREVIEW / stock_5min / 2005-08-12
file: by_date/stock_5min/2005/2005-08-12.parquet size: 2.7 MB rows: 201,883 symbols: 2,049
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-12 07:20:00 | AAPL | Stock | 1.5493 | 1.5493 | 1.5493 | 1.5493 | 5600.0 |
| 2005-08-12 07:25:00 | AAPL | Stock | 1.5471 | 1.5471 | 1.5471 | 1.5471 | 14000.0 |
| 2005-08-12 07:45:00 | AAPL | Stock | 1.5471 | 1.5471 | 1.5471 | 1.5471 | 84000.0 |
| 2005-08-12 07:50:00 | AAPL | Stock | 1.5471 | 1.5471 | 1.5471 | 1.5471 | 196000.0 |
| 2005-08-12 08:00:00 | AAPL | Stock | 1.5471 | 1.5514 | 1.5375 | 1.5464 | 379260.0 |
| 2005-08-12 08:05:00 | AAPL | Stock | 1.5454 | 1.5468 | 1.5439 | 1.5439 | 190792.0 |
| 2005-08-12 08:10:00 | AAPL | Stock | 1.5464 | 1.5464 | 1.5464 | 1.5464 | 108192.0 |
| 2005-08-12 08:15:00 | AAPL | Stock | 1.55 | 1.55 | 1.5454 | 1.55 | 77672.0 |
| 2005-08-12 08:20:00 | AAPL | Stock | 1.5496 | 1.55 | 1.5471 | 1.5471 | 95424.0 |
| 2005-08-12 08:25:00 | AAPL | Stock | 1.5464 | 1.5468 | 1.5457 | 1.5457 | 107800.0 |
| 2005-08-12 08:30:00 | AAPL | Stock | 1.545 | 1.5464 | 1.5429 | 1.5432 | 277200.0 |
| 2005-08-12 08:35:00 | AAPL | Stock | 1.5457 | 1.5457 | 1.5457 | 1.5457 | 56000.0 |
| 2005-08-12 08:40:00 | AAPL | Stock | 1.5486 | 1.55 | 1.5486 | 1.5496 | 11200.0 |
| 2005-08-12 08:45:00 | AAPL | Stock | 1.5482 | 1.5493 | 1.5464 | 1.5464 | 221200.0 |
| 2005-08-12 08:50:00 | AAPL | Stock | 1.5464 | 1.5479 | 1.5464 | 1.5464 | 154000.0 |
| 2005-08-12 08:55:00 | AAPL | Stock | 1.5479 | 1.5482 | 1.5479 | 1.5482 | 92400.0 |
| 2005-08-12 09:00:00 | AAPL | Stock | 1.5457 | 1.5464 | 1.545 | 1.5464 | 194600.0 |
| 2005-08-12 09:05:00 | AAPL | Stock | 1.5454 | 1.5454 | 1.545 | 1.5454 | 53200.0 |
| 2005-08-12 09:10:00 | AAPL | Stock | 1.5454 | 1.5482 | 1.5446 | 1.5482 | 167720.0 |
| 2005-08-12 09:15:00 | AAPL | Stock | 1.5482 | 1.5496 | 1.5464 | 1.5496 | 361200.0 |
| 2005-08-12 09:20:00 | AAPL | Stock | 1.5514 | 1.5514 | 1.5482 | 1.55 | 257740.0 |
| 2005-08-12 09:25:00 | AAPL | Stock | 1.55 | 1.5518 | 1.5496 | 1.55 | 100044.0 |
| 2005-08-12 09:30:00 | AAPL | Stock | 1.5521 | 1.5596 | 1.5486 | 1.5589 | 8835876.0 |
| 2005-08-12 09:35:00 | AAPL | Stock | 1.5589 | 1.5596 | 1.5532 | 1.5539 | 8346884.0 |
| 2005-08-12 09:40:00 | AAPL | Stock | 1.5539 | 1.5561 | 1.5536 | 1.5557 | 4481484.0 |
| 2005-08-12 09:45:00 | AAPL | Stock | 1.5557 | 1.5564 | 1.5539 | 1.5554 | 4033932.0 |
| 2005-08-12 09:50:00 | AAPL | Stock | 1.555 | 1.5561 | 1.5543 | 1.555 | 4150580.0 |
| 2005-08-12 09:55:00 | AAPL | Stock | 1.5554 | 1.5586 | 1.5546 | 1.5579 | 3248000.0 |
| 2005-08-12 10:00:00 | AAPL | Stock | 1.5582 | 1.5654 | 1.5575 | 1.5586 | 7311248.0 |
| 2005-08-12 10:05:00 | AAPL | Stock | 1.5589 | 1.5596 | 1.5543 | 1.5564 | 4721752.0 |
| 2005-08-12 10:10:00 | AAPL | Stock | 1.5564 | 1.5607 | 1.5564 | 1.5607 | 5005756.0 |
| 2005-08-12 10:15:00 | AAPL | Stock | 1.5607 | 1.5632 | 1.5589 | 1.5616 | 5493656.0 |
| 2005-08-12 10:20:00 | AAPL | Stock | 1.5614 | 1.5632 | 1.56 | 1.5632 | 3077564.0 |
| 2005-08-12 10:25:00 | AAPL | Stock | 1.5632 | 1.5693 | 1.5621 | 1.5679 | 5643652.0 |
| 2005-08-12 10:30:00 | AAPL | Stock | 1.5679 | 1.5682 | 1.5621 | 1.5664 | 5039748.0 |
| 2005-08-12 10:35:00 | AAPL | Stock | 1.5664 | 1.5664 | 1.5625 | 1.5643 | 3021620.0 |
| 2005-08-12 10:40:00 | AAPL | Stock | 1.5643 | 1.565 | 1.5618 | 1.565 | 2881844.0 |
| 2005-08-12 10:45:00 | AAPL | Stock | 1.565 | 1.5654 | 1.5629 | 1.5646 | 2578688.0 |
| 2005-08-12 10:50:00 | AAPL | Stock | 1.5654 | 1.5657 | 1.5639 | 1.5646 | 3039988.0 |
| 2005-08-12 10:55:00 | AAPL | Stock | 1.5643 | 1.5668 | 1.5643 | 1.5668 | 1609580.0 |
| 2005-08-12 11:00:00 | AAPL | Stock | 1.5665 | 1.5707 | 1.5664 | 1.5689 | 3669652.0 |
| 2005-08-12 11:05:00 | AAPL | Stock | 1.5696 | 1.5696 | 1.5682 | 1.5686 | 1516480.0 |
| 2005-08-12 11:10:00 | AAPL | Stock | 1.5689 | 1.5707 | 1.5679 | 1.57 | 2524900.0 |
| 2005-08-12 11:15:00 | AAPL | Stock | 1.57 | 1.5714 | 1.5682 | 1.5682 | 3687936.0 |
| 2005-08-12 11:20:00 | AAPL | Stock | 1.5682 | 1.5682 | 1.5657 | 1.5661 | 2143484.0 |
| 2005-08-12 11:25:00 | AAPL | Stock | 1.5661 | 1.5675 | 1.5639 | 1.5643 | 2900016.0 |
| 2005-08-12 11:30:00 | AAPL | Stock | 1.5643 | 1.57 | 1.5636 | 1.57 | 4713828.0 |
| 2005-08-12 11:35:00 | AAPL | Stock | 1.57 | 1.5789 | 1.5693 | 1.5775 | 13436584.0 |
| 2005-08-12 11:40:00 | AAPL | Stock | 1.5775 | 1.5786 | 1.5714 | 1.5754 | 16163868.0 |
| 2005-08-12 11:45:00 | AAPL | Stock | 1.5761 | 1.5793 | 1.5736 | 1.5736 | 7364224.0 |
> showing 50 of 201,883 rows — these rows as CSV