PREVIEW / stock_5min / 2009-07-24
file: by_date/stock_5min/2009/2009-07-24.parquet size: 4.5 MB rows: 312,739 symbols: 3,348
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-24 04:15:00 | AAPL | Stock | 5.5971 | 5.5971 | 5.5971 | 5.5971 | 2800.0 |
| 2009-07-24 05:35:00 | AAPL | Stock | 5.5714 | 5.5714 | 5.5714 | 5.5714 | 5600.0 |
| 2009-07-24 06:15:00 | AAPL | Stock | 5.6429 | 5.6429 | 5.6429 | 5.6429 | 2800.0 |
| 2009-07-24 07:00:00 | AAPL | Stock | 5.58 | 5.58 | 5.58 | 5.58 | 5600.0 |
| 2009-07-24 07:25:00 | AAPL | Stock | 5.5979 | 5.5979 | 5.5857 | 5.5893 | 53788.0 |
| 2009-07-24 07:30:00 | AAPL | Stock | 5.6054 | 5.6054 | 5.6054 | 5.6054 | 2800.0 |
| 2009-07-24 07:40:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5893 | 5.5893 | 3136.0 |
| 2009-07-24 08:00:00 | AAPL | Stock | 5.6007 | 5.6007 | 5.5893 | 5.5929 | 95508.0 |
| 2009-07-24 08:05:00 | AAPL | Stock | 5.5943 | 5.6007 | 5.5932 | 5.5968 | 19600.0 |
| 2009-07-24 08:10:00 | AAPL | Stock | 5.6036 | 5.6318 | 5.6036 | 5.6146 | 91140.0 |
| 2009-07-24 08:15:00 | AAPL | Stock | 5.6136 | 5.6146 | 5.6132 | 5.6132 | 28840.0 |
| 2009-07-24 08:20:00 | AAPL | Stock | 5.6132 | 5.6161 | 5.6114 | 5.6161 | 49224.0 |
| 2009-07-24 08:25:00 | AAPL | Stock | 5.6161 | 5.6179 | 5.6139 | 5.6143 | 81116.0 |
| 2009-07-24 08:30:00 | AAPL | Stock | 5.6143 | 5.6171 | 5.6143 | 5.6143 | 39816.0 |
| 2009-07-24 08:35:00 | AAPL | Stock | 5.6125 | 5.625 | 5.6125 | 5.6175 | 238728.0 |
| 2009-07-24 08:40:00 | AAPL | Stock | 5.6236 | 5.625 | 5.6182 | 5.625 | 169512.0 |
| 2009-07-24 08:45:00 | AAPL | Stock | 5.6182 | 5.6207 | 5.6175 | 5.6196 | 29036.0 |
| 2009-07-24 08:50:00 | AAPL | Stock | 5.6179 | 5.6179 | 5.6096 | 5.6096 | 203644.0 |
| 2009-07-24 08:55:00 | AAPL | Stock | 5.61 | 5.61 | 5.6057 | 5.6061 | 296800.0 |
| 2009-07-24 09:00:00 | AAPL | Stock | 5.6036 | 5.6036 | 5.5893 | 5.5964 | 224924.0 |
| 2009-07-24 09:05:00 | AAPL | Stock | 5.5961 | 5.6018 | 5.5961 | 5.6018 | 47600.0 |
| 2009-07-24 09:10:00 | AAPL | Stock | 5.6021 | 5.6021 | 5.5929 | 5.5929 | 129248.0 |
| 2009-07-24 09:15:00 | AAPL | Stock | 5.5929 | 5.5957 | 5.5893 | 5.5957 | 170184.0 |
| 2009-07-24 09:20:00 | AAPL | Stock | 5.5929 | 5.5964 | 5.5921 | 5.5964 | 32928.0 |
| 2009-07-24 09:25:00 | AAPL | Stock | 5.5964 | 5.6054 | 5.5964 | 5.6046 | 75320.0 |
| 2009-07-24 09:30:00 | AAPL | Stock | 5.6054 | 5.6371 | 5.5893 | 5.6361 | 19477668.0 |
| 2009-07-24 09:35:00 | AAPL | Stock | 5.6361 | 5.655 | 5.6321 | 5.6536 | 16270352.0 |
| 2009-07-24 09:40:00 | AAPL | Stock | 5.6532 | 5.6854 | 5.6511 | 5.6779 | 24224452.0 |
| 2009-07-24 09:45:00 | AAPL | Stock | 5.6782 | 5.695 | 5.6625 | 5.6704 | 19711748.0 |
| 2009-07-24 09:50:00 | AAPL | Stock | 5.6714 | 5.6736 | 5.6454 | 5.6657 | 14009576.0 |
| 2009-07-24 09:55:00 | AAPL | Stock | 5.6654 | 5.6654 | 5.6214 | 5.6371 | 16437428.0 |
| 2009-07-24 10:00:00 | AAPL | Stock | 5.6386 | 5.6571 | 5.6275 | 5.6525 | 8289708.0 |
| 2009-07-24 10:05:00 | AAPL | Stock | 5.6525 | 5.6629 | 5.6464 | 5.6503 | 6667080.0 |
| 2009-07-24 10:10:00 | AAPL | Stock | 5.6488 | 5.6593 | 5.6432 | 5.6506 | 4713408.0 |
| 2009-07-24 10:15:00 | AAPL | Stock | 5.6493 | 5.6643 | 5.6457 | 5.651 | 6040860.0 |
| 2009-07-24 10:20:00 | AAPL | Stock | 5.6532 | 5.6604 | 5.6496 | 5.6596 | 3582572.0 |
| 2009-07-24 10:25:00 | AAPL | Stock | 5.66 | 5.6743 | 5.6543 | 5.6718 | 5708808.0 |
| 2009-07-24 10:30:00 | AAPL | Stock | 5.672 | 5.6821 | 5.6625 | 5.6682 | 9644096.0 |
| 2009-07-24 10:35:00 | AAPL | Stock | 5.6671 | 5.6693 | 5.6496 | 5.6511 | 4840920.0 |
| 2009-07-24 10:40:00 | AAPL | Stock | 5.6502 | 5.6586 | 5.6468 | 5.6486 | 4216352.0 |
| 2009-07-24 10:45:00 | AAPL | Stock | 5.6489 | 5.6625 | 5.6464 | 5.6593 | 4348288.0 |
| 2009-07-24 10:50:00 | AAPL | Stock | 5.6593 | 5.6593 | 5.6468 | 5.6482 | 2746492.0 |
| 2009-07-24 10:55:00 | AAPL | Stock | 5.6496 | 5.6504 | 5.6389 | 5.6471 | 5697272.0 |
| 2009-07-24 11:00:00 | AAPL | Stock | 5.6464 | 5.6578 | 5.6436 | 5.6554 | 3288460.0 |
| 2009-07-24 11:05:00 | AAPL | Stock | 5.6554 | 5.6554 | 5.6436 | 5.6439 | 3033380.0 |
| 2009-07-24 11:10:00 | AAPL | Stock | 5.6436 | 5.6546 | 5.6421 | 5.6511 | 3386320.0 |
| 2009-07-24 11:15:00 | AAPL | Stock | 5.6514 | 5.6586 | 5.65 | 5.6586 | 2982084.0 |
| 2009-07-24 11:20:00 | AAPL | Stock | 5.6586 | 5.6743 | 5.6583 | 5.6687 | 5863396.0 |
| 2009-07-24 11:25:00 | AAPL | Stock | 5.6682 | 5.6718 | 5.6668 | 5.6714 | 2912028.0 |
| 2009-07-24 11:30:00 | AAPL | Stock | 5.6711 | 5.6804 | 5.6693 | 5.6779 | 6740272.0 |
> showing 50 of 312,739 rows — these rows as CSV