PREVIEW / stock_5min / 2008-03-14
file: by_date/stock_5min/2008/2008-03-14.parquet size: 4.4 MB rows: 316,330 symbols: 3,259
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-14 05:50:00 | AAPL | Stock | 4.5589 | 4.5589 | 4.5589 | 4.5589 | 2800.0 |
| 2008-03-14 06:00:00 | AAPL | Stock | 4.5589 | 4.5589 | 4.5589 | 4.5589 | 2800.0 |
| 2008-03-14 06:15:00 | AAPL | Stock | 4.56 | 4.56 | 4.56 | 4.56 | 2800.0 |
| 2008-03-14 06:20:00 | AAPL | Stock | 4.56 | 4.56 | 4.56 | 4.56 | 2800.0 |
| 2008-03-14 06:30:00 | AAPL | Stock | 4.5604 | 4.5604 | 4.56 | 4.56 | 8400.0 |
| 2008-03-14 06:40:00 | AAPL | Stock | 4.5679 | 4.5679 | 4.5679 | 4.5679 | 2800.0 |
| 2008-03-14 07:20:00 | AAPL | Stock | 4.56 | 4.56 | 4.5557 | 4.5571 | 25200.0 |
| 2008-03-14 07:25:00 | AAPL | Stock | 4.5536 | 4.5536 | 4.5536 | 4.5536 | 25200.0 |
| 2008-03-14 07:40:00 | AAPL | Stock | 4.5471 | 4.5471 | 4.5471 | 4.5471 | 47600.0 |
| 2008-03-14 07:50:00 | AAPL | Stock | 4.5504 | 4.5504 | 4.5504 | 4.5504 | 28000.0 |
| 2008-03-14 08:00:00 | AAPL | Stock | 4.5504 | 4.5711 | 4.55 | 4.5686 | 510608.0 |
| 2008-03-14 08:05:00 | AAPL | Stock | 4.5668 | 4.5857 | 4.5668 | 4.575 | 899808.0 |
| 2008-03-14 08:10:00 | AAPL | Stock | 4.5775 | 4.5839 | 4.5664 | 4.5839 | 416976.0 |
| 2008-03-14 08:15:00 | AAPL | Stock | 4.5843 | 4.5875 | 4.5718 | 4.5786 | 308000.0 |
| 2008-03-14 08:20:00 | AAPL | Stock | 4.5796 | 4.5796 | 4.5739 | 4.575 | 40040.0 |
| 2008-03-14 08:25:00 | AAPL | Stock | 4.575 | 4.575 | 4.5661 | 4.5696 | 369992.0 |
| 2008-03-14 08:30:00 | AAPL | Stock | 4.5725 | 4.6354 | 4.5711 | 4.6354 | 4413584.0 |
| 2008-03-14 08:35:00 | AAPL | Stock | 4.6354 | 4.64 | 4.6193 | 4.6386 | 1771980.0 |
| 2008-03-14 08:40:00 | AAPL | Stock | 4.6389 | 4.6429 | 4.63 | 4.6407 | 1860516.0 |
| 2008-03-14 08:45:00 | AAPL | Stock | 4.6421 | 4.6536 | 4.6421 | 4.6518 | 2498356.0 |
| 2008-03-14 08:50:00 | AAPL | Stock | 4.6514 | 4.6514 | 4.6379 | 4.6446 | 1018780.0 |
| 2008-03-14 08:55:00 | AAPL | Stock | 4.6461 | 4.6461 | 4.6332 | 4.6357 | 727524.0 |
| 2008-03-14 09:00:00 | AAPL | Stock | 4.6364 | 4.645 | 4.6357 | 4.6411 | 589092.0 |
| 2008-03-14 09:05:00 | AAPL | Stock | 4.6393 | 4.6486 | 4.6371 | 4.6464 | 1306144.0 |
| 2008-03-14 09:10:00 | AAPL | Stock | 4.6464 | 4.6696 | 4.6464 | 4.6661 | 1705508.0 |
| 2008-03-14 09:15:00 | AAPL | Stock | 4.6661 | 4.6679 | 4.6536 | 4.6607 | 1127476.0 |
| 2008-03-14 09:20:00 | AAPL | Stock | 4.6571 | 4.6589 | 4.645 | 4.6489 | 1308020.0 |
| 2008-03-14 09:25:00 | AAPL | Stock | 4.6486 | 4.6657 | 4.6357 | 4.6382 | 3760932.0 |
| 2008-03-14 09:30:00 | AAPL | Stock | 4.6357 | 4.6518 | 4.6021 | 4.6239 | 39601240.0 |
| 2008-03-14 09:35:00 | AAPL | Stock | 4.6232 | 4.6525 | 4.6232 | 4.6464 | 28915572.0 |
| 2008-03-14 09:40:00 | AAPL | Stock | 4.6461 | 4.6536 | 4.6261 | 4.6439 | 21414036.0 |
| 2008-03-14 09:45:00 | AAPL | Stock | 4.6439 | 4.6446 | 4.5618 | 4.5779 | 32304048.0 |
| 2008-03-14 09:50:00 | AAPL | Stock | 4.5779 | 4.5914 | 4.5261 | 4.5432 | 28463148.0 |
| 2008-03-14 09:55:00 | AAPL | Stock | 4.5432 | 4.5775 | 4.5179 | 4.5182 | 26629932.0 |
| 2008-03-14 10:00:00 | AAPL | Stock | 4.5189 | 4.5211 | 4.4357 | 4.4918 | 37657452.0 |
| 2008-03-14 10:05:00 | AAPL | Stock | 4.4979 | 4.5511 | 4.4671 | 4.5425 | 37512020.0 |
| 2008-03-14 10:10:00 | AAPL | Stock | 4.5421 | 4.5454 | 4.5179 | 4.5275 | 21755944.0 |
| 2008-03-14 10:15:00 | AAPL | Stock | 4.5275 | 4.575 | 4.5264 | 4.5514 | 27468924.0 |
| 2008-03-14 10:20:00 | AAPL | Stock | 4.5536 | 4.5636 | 4.5289 | 4.555 | 17626504.0 |
| 2008-03-14 10:25:00 | AAPL | Stock | 4.5561 | 4.5582 | 4.5 | 4.5229 | 17591392.0 |
| 2008-03-14 10:30:00 | AAPL | Stock | 4.5236 | 4.5446 | 4.515 | 4.5371 | 14227388.0 |
| 2008-03-14 10:35:00 | AAPL | Stock | 4.5364 | 4.5421 | 4.5157 | 4.5175 | 13029968.0 |
| 2008-03-14 10:40:00 | AAPL | Stock | 4.5175 | 4.5221 | 4.4929 | 4.5089 | 17030832.0 |
| 2008-03-14 10:45:00 | AAPL | Stock | 4.5089 | 4.5332 | 4.5 | 4.5236 | 14955388.0 |
| 2008-03-14 10:50:00 | AAPL | Stock | 4.5221 | 4.5618 | 4.5218 | 4.5571 | 20614888.0 |
| 2008-03-14 10:55:00 | AAPL | Stock | 4.5571 | 4.5657 | 4.5321 | 4.5484 | 14899220.0 |
| 2008-03-14 11:00:00 | AAPL | Stock | 4.5482 | 4.5636 | 4.5411 | 4.5443 | 13146168.0 |
| 2008-03-14 11:05:00 | AAPL | Stock | 4.5446 | 4.575 | 4.5375 | 4.5718 | 19011496.0 |
| 2008-03-14 11:10:00 | AAPL | Stock | 4.5718 | 4.5757 | 4.5593 | 4.5618 | 17345020.0 |
| 2008-03-14 11:15:00 | AAPL | Stock | 4.5632 | 4.5632 | 4.5304 | 4.5357 | 11634896.0 |
> showing 50 of 316,330 rows — these rows as CSV