PREVIEW / stock_5min / 2010-01-21
file: by_date/stock_5min/2010/2010-01-21.parquet size: 5.0 MB rows: 336,372 symbols: 3,437
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-21 04:35:00 | AAPL | Stock | 7.5714 | 7.5714 | 7.5714 | 7.5714 | 2800.0 |
| 2010-01-21 05:00:00 | AAPL | Stock | 7.5618 | 7.5618 | 7.5618 | 7.5618 | 2800.0 |
| 2010-01-21 05:10:00 | AAPL | Stock | 7.5618 | 7.5618 | 7.5618 | 7.5618 | 2800.0 |
| 2010-01-21 06:35:00 | AAPL | Stock | 7.5679 | 7.5679 | 7.5679 | 7.5679 | 2800.0 |
| 2010-01-21 06:50:00 | AAPL | Stock | 7.5679 | 7.5679 | 7.5679 | 7.5679 | 2800.0 |
| 2010-01-21 07:05:00 | AAPL | Stock | 7.5918 | 7.5918 | 7.5918 | 7.5918 | 13020.0 |
| 2010-01-21 07:10:00 | AAPL | Stock | 7.5825 | 7.5825 | 7.5825 | 7.5825 | 5600.0 |
| 2010-01-21 07:15:00 | AAPL | Stock | 7.5871 | 7.5871 | 7.5871 | 7.5871 | 2800.0 |
| 2010-01-21 07:20:00 | AAPL | Stock | 7.5871 | 7.5907 | 7.5871 | 7.5907 | 52640.0 |
| 2010-01-21 07:25:00 | AAPL | Stock | 7.5857 | 7.5857 | 7.5821 | 7.5821 | 16100.0 |
| 2010-01-21 07:30:00 | AAPL | Stock | 7.5921 | 7.5921 | 7.5921 | 7.5921 | 2800.0 |
| 2010-01-21 07:35:00 | AAPL | Stock | 7.5893 | 7.5893 | 7.5893 | 7.5893 | 5600.0 |
| 2010-01-21 07:40:00 | AAPL | Stock | 7.5918 | 7.5964 | 7.5918 | 7.5964 | 35000.0 |
| 2010-01-21 07:45:00 | AAPL | Stock | 7.6036 | 7.6036 | 7.6032 | 7.6032 | 29680.0 |
| 2010-01-21 07:50:00 | AAPL | Stock | 7.5964 | 7.5993 | 7.5964 | 7.5964 | 39200.0 |
| 2010-01-21 07:55:00 | AAPL | Stock | 7.5929 | 7.5929 | 7.5918 | 7.5918 | 38780.0 |
| 2010-01-21 08:00:00 | AAPL | Stock | 7.6032 | 7.6032 | 7.5875 | 7.5875 | 256620.0 |
| 2010-01-21 08:05:00 | AAPL | Stock | 7.5871 | 7.5871 | 7.5679 | 7.5689 | 183540.0 |
| 2010-01-21 08:10:00 | AAPL | Stock | 7.5782 | 7.5782 | 7.5611 | 7.5766 | 243068.0 |
| 2010-01-21 08:15:00 | AAPL | Stock | 7.5736 | 7.5795 | 7.5679 | 7.5679 | 294784.0 |
| 2010-01-21 08:20:00 | AAPL | Stock | 7.5712 | 7.5712 | 7.5625 | 7.5664 | 164220.0 |
| 2010-01-21 08:25:00 | AAPL | Stock | 7.5679 | 7.5696 | 7.5614 | 7.5614 | 4295508.0 |
| 2010-01-21 08:30:00 | AAPL | Stock | 7.5696 | 7.5696 | 7.5482 | 7.555 | 666568.0 |
| 2010-01-21 08:35:00 | AAPL | Stock | 7.5536 | 7.5571 | 7.5404 | 7.5482 | 414484.0 |
| 2010-01-21 08:40:00 | AAPL | Stock | 7.5521 | 7.5571 | 7.55 | 7.5536 | 83692.0 |
| 2010-01-21 08:45:00 | AAPL | Stock | 7.5504 | 7.5536 | 7.5493 | 7.5536 | 42728.0 |
| 2010-01-21 08:50:00 | AAPL | Stock | 7.5511 | 7.5529 | 7.5464 | 7.5525 | 86072.0 |
| 2010-01-21 08:55:00 | AAPL | Stock | 7.5532 | 7.5536 | 7.5532 | 7.5536 | 6720.0 |
| 2010-01-21 09:00:00 | AAPL | Stock | 7.5529 | 7.5534 | 7.5493 | 7.5493 | 14000.0 |
| 2010-01-21 09:05:00 | AAPL | Stock | 7.5489 | 7.5536 | 7.5486 | 7.5536 | 70000.0 |
| 2010-01-21 09:10:00 | AAPL | Stock | 7.5554 | 7.5625 | 7.5532 | 7.5625 | 157836.0 |
| 2010-01-21 09:15:00 | AAPL | Stock | 7.5591 | 7.5604 | 7.5582 | 7.5604 | 38444.0 |
| 2010-01-21 09:20:00 | AAPL | Stock | 7.5593 | 7.5607 | 7.5593 | 7.5607 | 65408.0 |
| 2010-01-21 09:25:00 | AAPL | Stock | 7.5607 | 7.5771 | 7.56 | 7.5768 | 360080.0 |
| 2010-01-21 09:30:00 | AAPL | Stock | 7.5743 | 7.6182 | 7.5721 | 7.6182 | 20819764.0 |
| 2010-01-21 09:35:00 | AAPL | Stock | 7.6182 | 7.6184 | 7.5804 | 7.5857 | 11680284.0 |
| 2010-01-21 09:40:00 | AAPL | Stock | 7.585 | 7.5982 | 7.5407 | 7.5454 | 14971292.0 |
| 2010-01-21 09:45:00 | AAPL | Stock | 7.5452 | 7.5464 | 7.5082 | 7.5286 | 12652136.0 |
| 2010-01-21 09:50:00 | AAPL | Stock | 7.5286 | 7.5457 | 7.5114 | 7.5336 | 10401356.0 |
| 2010-01-21 09:55:00 | AAPL | Stock | 7.5343 | 7.5614 | 7.5339 | 7.5468 | 7920752.0 |
| 2010-01-21 10:00:00 | AAPL | Stock | 7.5471 | 7.5525 | 7.5307 | 7.5525 | 7470428.0 |
| 2010-01-21 10:05:00 | AAPL | Stock | 7.5532 | 7.5725 | 7.5525 | 7.56 | 10265696.0 |
| 2010-01-21 10:10:00 | AAPL | Stock | 7.5578 | 7.56 | 7.5418 | 7.5471 | 5127752.0 |
| 2010-01-21 10:15:00 | AAPL | Stock | 7.5464 | 7.5529 | 7.5404 | 7.5494 | 4409440.0 |
| 2010-01-21 10:20:00 | AAPL | Stock | 7.5493 | 7.5493 | 7.5 | 7.5039 | 12148640.0 |
| 2010-01-21 10:25:00 | AAPL | Stock | 7.5061 | 7.5143 | 7.4821 | 7.4839 | 17909192.0 |
| 2010-01-21 10:30:00 | AAPL | Stock | 7.4846 | 7.4882 | 7.4429 | 7.4771 | 20462512.0 |
| 2010-01-21 10:35:00 | AAPL | Stock | 7.4771 | 7.4807 | 7.4536 | 7.4618 | 9422588.0 |
| 2010-01-21 10:40:00 | AAPL | Stock | 7.4614 | 7.4679 | 7.4496 | 7.4514 | 8305472.0 |
| 2010-01-21 10:45:00 | AAPL | Stock | 7.4518 | 7.4535 | 7.4393 | 7.452 | 8731912.0 |
> showing 50 of 336,372 rows — these rows as CSV