PREVIEW / stock_5min / 2008-10-29
file: by_date/stock_5min/2008/2008-10-29.parquet size: 4.5 MB rows: 319,359 symbols: 3,323
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-10-29 04:15:00 | AAPL | Stock | 3.5689 | 3.5689 | 3.5689 | 3.5689 | 2800.0 |
| 2008-10-29 06:05:00 | AAPL | Stock | 3.5575 | 3.5575 | 3.5418 | 3.5543 | 28000.0 |
| 2008-10-29 06:10:00 | AAPL | Stock | 3.5571 | 3.5629 | 3.5571 | 3.5629 | 16800.0 |
| 2008-10-29 06:35:00 | AAPL | Stock | 3.5454 | 3.5454 | 3.5454 | 3.5454 | 5600.0 |
| 2008-10-29 06:55:00 | AAPL | Stock | 3.6179 | 3.6179 | 3.6179 | 3.6179 | 2800.0 |
| 2008-10-29 07:00:00 | AAPL | Stock | 3.6071 | 3.6071 | 3.6071 | 3.6071 | 2800.0 |
| 2008-10-29 07:10:00 | AAPL | Stock | 3.5818 | 3.5893 | 3.5818 | 3.5893 | 79800.0 |
| 2008-10-29 07:25:00 | AAPL | Stock | 3.5982 | 3.5982 | 3.5982 | 3.5982 | 10752.0 |
| 2008-10-29 07:30:00 | AAPL | Stock | 3.5921 | 3.6071 | 3.5911 | 3.5914 | 93128.0 |
| 2008-10-29 07:35:00 | AAPL | Stock | 3.5964 | 3.6071 | 3.5911 | 3.6071 | 85400.0 |
| 2008-10-29 07:40:00 | AAPL | Stock | 3.6071 | 3.6161 | 3.6071 | 3.6161 | 22400.0 |
| 2008-10-29 07:45:00 | AAPL | Stock | 3.6071 | 3.6429 | 3.6071 | 3.6429 | 91504.0 |
| 2008-10-29 07:50:00 | AAPL | Stock | 3.6232 | 3.6357 | 3.6071 | 3.6357 | 28000.0 |
| 2008-10-29 07:55:00 | AAPL | Stock | 3.6357 | 3.6357 | 3.625 | 3.625 | 41440.0 |
| 2008-10-29 08:00:00 | AAPL | Stock | 3.6232 | 3.625 | 3.5979 | 3.6096 | 484288.0 |
| 2008-10-29 08:05:00 | AAPL | Stock | 3.6096 | 3.6271 | 3.5982 | 3.6221 | 596260.0 |
| 2008-10-29 08:10:00 | AAPL | Stock | 3.6268 | 3.6339 | 3.6268 | 3.6321 | 423332.0 |
| 2008-10-29 08:15:00 | AAPL | Stock | 3.6321 | 3.6357 | 3.6254 | 3.6268 | 364644.0 |
| 2008-10-29 08:20:00 | AAPL | Stock | 3.6232 | 3.6271 | 3.6114 | 3.6114 | 364448.0 |
| 2008-10-29 08:25:00 | AAPL | Stock | 3.6111 | 3.6118 | 3.5929 | 3.5929 | 456820.0 |
| 2008-10-29 08:30:00 | AAPL | Stock | 3.5946 | 3.6143 | 3.5946 | 3.6 | 672392.0 |
| 2008-10-29 08:35:00 | AAPL | Stock | 3.5986 | 3.5993 | 3.5771 | 3.5811 | 599984.0 |
| 2008-10-29 08:40:00 | AAPL | Stock | 3.5786 | 3.5925 | 3.5761 | 3.5907 | 502208.0 |
| 2008-10-29 08:45:00 | AAPL | Stock | 3.5907 | 3.5943 | 3.5832 | 3.5832 | 427616.0 |
| 2008-10-29 08:50:00 | AAPL | Stock | 3.5836 | 3.5857 | 3.5825 | 3.5825 | 58800.0 |
| 2008-10-29 08:55:00 | AAPL | Stock | 3.5846 | 3.5875 | 3.5814 | 3.5875 | 161560.0 |
| 2008-10-29 09:00:00 | AAPL | Stock | 3.5857 | 3.5911 | 3.5764 | 3.5861 | 207760.0 |
| 2008-10-29 09:05:00 | AAPL | Stock | 3.5846 | 3.5846 | 3.5786 | 3.5804 | 323400.0 |
| 2008-10-29 09:10:00 | AAPL | Stock | 3.5804 | 3.5857 | 3.5804 | 3.5839 | 319928.0 |
| 2008-10-29 09:15:00 | AAPL | Stock | 3.5839 | 3.5839 | 3.5786 | 3.5807 | 226324.0 |
| 2008-10-29 09:20:00 | AAPL | Stock | 3.5832 | 3.5868 | 3.5771 | 3.5779 | 305732.0 |
| 2008-10-29 09:25:00 | AAPL | Stock | 3.5804 | 3.6046 | 3.5796 | 3.5982 | 856464.0 |
| 2008-10-29 09:30:00 | AAPL | Stock | 3.6021 | 3.6193 | 3.5864 | 3.6007 | 43775032.0 |
| 2008-10-29 09:35:00 | AAPL | Stock | 3.6004 | 3.6175 | 3.5693 | 3.6175 | 36186612.0 |
| 2008-10-29 09:40:00 | AAPL | Stock | 3.6175 | 3.6729 | 3.6129 | 3.6721 | 50871072.0 |
| 2008-10-29 09:45:00 | AAPL | Stock | 3.6721 | 3.6764 | 3.6357 | 3.6623 | 31374616.0 |
| 2008-10-29 09:50:00 | AAPL | Stock | 3.6621 | 3.6625 | 3.6289 | 3.6418 | 24808392.0 |
| 2008-10-29 09:55:00 | AAPL | Stock | 3.6421 | 3.6929 | 3.6393 | 3.6757 | 33645668.0 |
| 2008-10-29 10:00:00 | AAPL | Stock | 3.6761 | 3.6793 | 3.6586 | 3.6736 | 24852800.0 |
| 2008-10-29 10:05:00 | AAPL | Stock | 3.6741 | 3.7214 | 3.6729 | 3.7157 | 36389556.0 |
| 2008-10-29 10:10:00 | AAPL | Stock | 3.7168 | 3.7496 | 3.7032 | 3.7439 | 33095272.0 |
| 2008-10-29 10:15:00 | AAPL | Stock | 3.7439 | 3.7768 | 3.7396 | 3.7579 | 42242312.0 |
| 2008-10-29 10:20:00 | AAPL | Stock | 3.7586 | 3.7857 | 3.7468 | 3.7693 | 34347572.0 |
| 2008-10-29 10:25:00 | AAPL | Stock | 3.7689 | 3.8129 | 3.7679 | 3.7975 | 39325300.0 |
| 2008-10-29 10:30:00 | AAPL | Stock | 3.7975 | 3.8125 | 3.7636 | 3.7696 | 41108956.0 |
| 2008-10-29 10:35:00 | AAPL | Stock | 3.7696 | 3.7779 | 3.7254 | 3.7293 | 33665128.0 |
| 2008-10-29 10:40:00 | AAPL | Stock | 3.7286 | 3.7407 | 3.7189 | 3.7357 | 27233164.0 |
| 2008-10-29 10:45:00 | AAPL | Stock | 3.7357 | 3.7414 | 3.7071 | 3.7139 | 22400644.0 |
| 2008-10-29 10:50:00 | AAPL | Stock | 3.7125 | 3.7311 | 3.7064 | 3.7139 | 19645472.0 |
| 2008-10-29 10:55:00 | AAPL | Stock | 3.7132 | 3.7321 | 3.7043 | 3.7188 | 17021956.0 |
> showing 50 of 319,359 rows — these rows as CSV