PREVIEW / stock_5min / 2008-04-24
file: by_date/stock_5min/2008/2008-04-24.parquet size: 4.4 MB rows: 312,994 symbols: 3,292
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-04-24 05:45:00 | AAPL | Stock | 5.7796 | 5.785 | 5.7796 | 5.7836 | 39200.0 |
| 2008-04-24 06:00:00 | AAPL | Stock | 5.7893 | 5.7893 | 5.7893 | 5.7893 | 2800.0 |
| 2008-04-24 06:05:00 | AAPL | Stock | 5.7911 | 5.7911 | 5.7911 | 5.7911 | 70000.0 |
| 2008-04-24 06:15:00 | AAPL | Stock | 5.7929 | 5.7929 | 5.7893 | 5.7893 | 33600.0 |
| 2008-04-24 06:20:00 | AAPL | Stock | 5.7757 | 5.7757 | 5.7757 | 5.7757 | 2800.0 |
| 2008-04-24 06:25:00 | AAPL | Stock | 5.7757 | 5.7757 | 5.7754 | 5.7754 | 36820.0 |
| 2008-04-24 06:35:00 | AAPL | Stock | 5.775 | 5.775 | 5.775 | 5.775 | 2800.0 |
| 2008-04-24 06:45:00 | AAPL | Stock | 5.7729 | 5.7732 | 5.7589 | 5.7732 | 50624.0 |
| 2008-04-24 06:50:00 | AAPL | Stock | 5.7643 | 5.7643 | 5.7539 | 5.7539 | 33880.0 |
| 2008-04-24 06:55:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7321 | 5.7357 | 131600.0 |
| 2008-04-24 07:00:00 | AAPL | Stock | 5.7325 | 5.7468 | 5.7182 | 5.7182 | 64288.0 |
| 2008-04-24 07:05:00 | AAPL | Stock | 5.7221 | 5.7368 | 5.7221 | 5.7321 | 70896.0 |
| 2008-04-24 07:10:00 | AAPL | Stock | 5.7321 | 5.7357 | 5.7268 | 5.7268 | 84000.0 |
| 2008-04-24 07:15:00 | AAPL | Stock | 5.7321 | 5.7461 | 5.7321 | 5.7321 | 142520.0 |
| 2008-04-24 07:20:00 | AAPL | Stock | 5.7379 | 5.7393 | 5.7321 | 5.7393 | 118440.0 |
| 2008-04-24 07:25:00 | AAPL | Stock | 5.7461 | 5.7643 | 5.7461 | 5.7632 | 165200.0 |
| 2008-04-24 07:30:00 | AAPL | Stock | 5.7625 | 5.7711 | 5.7593 | 5.7711 | 330428.0 |
| 2008-04-24 07:35:00 | AAPL | Stock | 5.7732 | 5.7857 | 5.7539 | 5.7768 | 989212.0 |
| 2008-04-24 07:40:00 | AAPL | Stock | 5.7804 | 5.7857 | 5.7768 | 5.7768 | 492548.0 |
| 2008-04-24 07:45:00 | AAPL | Stock | 5.7714 | 5.7821 | 5.7714 | 5.7786 | 72800.0 |
| 2008-04-24 07:50:00 | AAPL | Stock | 5.775 | 5.8036 | 5.775 | 5.8 | 701036.0 |
| 2008-04-24 07:55:00 | AAPL | Stock | 5.8 | 5.8393 | 5.8 | 5.8393 | 1063440.0 |
| 2008-04-24 08:00:00 | AAPL | Stock | 5.8393 | 5.8879 | 5.7929 | 5.8832 | 7569884.0 |
| 2008-04-24 08:05:00 | AAPL | Stock | 5.8796 | 5.8796 | 5.8125 | 5.8311 | 3122868.0 |
| 2008-04-24 08:10:00 | AAPL | Stock | 5.8354 | 5.8929 | 5.8325 | 5.8914 | 4380516.0 |
| 2008-04-24 08:15:00 | AAPL | Stock | 5.89 | 5.9018 | 5.8643 | 5.8689 | 6048308.0 |
| 2008-04-24 08:20:00 | AAPL | Stock | 5.8675 | 5.8911 | 5.8611 | 5.8868 | 3443944.0 |
| 2008-04-24 08:25:00 | AAPL | Stock | 5.8864 | 5.8868 | 5.8618 | 5.8636 | 2839480.0 |
| 2008-04-24 08:30:00 | AAPL | Stock | 5.8636 | 5.8786 | 5.8571 | 5.8729 | 3521812.0 |
| 2008-04-24 08:35:00 | AAPL | Stock | 5.8718 | 5.8896 | 5.8696 | 5.8893 | 1537480.0 |
| 2008-04-24 08:40:00 | AAPL | Stock | 5.8896 | 5.8904 | 5.8732 | 5.8836 | 1674148.0 |
| 2008-04-24 08:45:00 | AAPL | Stock | 5.8839 | 5.8939 | 5.8821 | 5.89 | 3568936.0 |
| 2008-04-24 08:50:00 | AAPL | Stock | 5.89 | 5.89 | 5.8721 | 5.8779 | 3359804.0 |
| 2008-04-24 08:55:00 | AAPL | Stock | 5.8779 | 5.8854 | 5.8732 | 5.8821 | 1129240.0 |
| 2008-04-24 09:00:00 | AAPL | Stock | 5.8821 | 5.9089 | 5.8821 | 5.9064 | 4381580.0 |
| 2008-04-24 09:05:00 | AAPL | Stock | 5.9057 | 5.9521 | 5.8993 | 5.9454 | 9730280.0 |
| 2008-04-24 09:10:00 | AAPL | Stock | 5.9446 | 5.9454 | 5.9136 | 5.9275 | 6165488.0 |
| 2008-04-24 09:15:00 | AAPL | Stock | 5.9282 | 5.9568 | 5.9243 | 5.9504 | 2863280.0 |
| 2008-04-24 09:20:00 | AAPL | Stock | 5.9532 | 5.9564 | 5.9286 | 5.9521 | 4401768.0 |
| 2008-04-24 09:25:00 | AAPL | Stock | 5.9504 | 5.9511 | 5.8993 | 5.9057 | 7621292.0 |
| 2008-04-24 09:30:00 | AAPL | Stock | 5.9061 | 5.9214 | 5.8293 | 5.83 | 67023432.0 |
| 2008-04-24 09:35:00 | AAPL | Stock | 5.8289 | 5.8404 | 5.7614 | 5.7643 | 63244664.0 |
| 2008-04-24 09:40:00 | AAPL | Stock | 5.765 | 5.7707 | 5.6855 | 5.7664 | 62346900.0 |
| 2008-04-24 09:45:00 | AAPL | Stock | 5.765 | 5.8111 | 5.7407 | 5.8079 | 35479024.0 |
| 2008-04-24 09:50:00 | AAPL | Stock | 5.8086 | 5.8107 | 5.7464 | 5.7854 | 33430516.0 |
| 2008-04-24 09:55:00 | AAPL | Stock | 5.7854 | 5.8368 | 5.7721 | 5.8329 | 27478220.0 |
| 2008-04-24 10:00:00 | AAPL | Stock | 5.8329 | 5.8343 | 5.7893 | 5.8025 | 34992916.0 |
| 2008-04-24 10:05:00 | AAPL | Stock | 5.7998 | 5.8329 | 5.7804 | 5.7914 | 25008676.0 |
| 2008-04-24 10:10:00 | AAPL | Stock | 5.7896 | 5.8382 | 5.7886 | 5.8236 | 25008200.0 |
| 2008-04-24 10:15:00 | AAPL | Stock | 5.8236 | 5.8236 | 5.8036 | 5.8179 | 15586256.0 |
> showing 50 of 312,994 rows — these rows as CSV