PREVIEW / stock_5min / 2009-03-26
file: by_date/stock_5min/2009/2009-03-26.parquet size: 4.5 MB rows: 313,054 symbols: 3,307
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-03-26 08:00:00 | AAPL | Stock | 3.8214 | 3.8496 | 3.8214 | 3.8482 | 41776.0 |
| 2009-03-26 08:05:00 | AAPL | Stock | 3.8339 | 3.8393 | 3.8321 | 3.8354 | 158592.0 |
| 2009-03-26 08:10:00 | AAPL | Stock | 3.8354 | 3.8354 | 3.8321 | 3.8321 | 14000.0 |
| 2009-03-26 08:15:00 | AAPL | Stock | 3.8321 | 3.8321 | 3.8321 | 3.8321 | 2800.0 |
| 2009-03-26 08:20:00 | AAPL | Stock | 3.8325 | 3.8339 | 3.8304 | 3.8304 | 156996.0 |
| 2009-03-26 08:25:00 | AAPL | Stock | 3.835 | 3.835 | 3.8218 | 3.8339 | 45500.0 |
| 2009-03-26 08:30:00 | AAPL | Stock | 3.8339 | 3.8339 | 3.8286 | 3.8286 | 193760.0 |
| 2009-03-26 08:35:00 | AAPL | Stock | 3.8286 | 3.8343 | 3.8286 | 3.8343 | 94500.0 |
| 2009-03-26 08:40:00 | AAPL | Stock | 3.8343 | 3.8354 | 3.8343 | 3.8354 | 206500.0 |
| 2009-03-26 08:45:00 | AAPL | Stock | 3.8382 | 3.8439 | 3.8382 | 3.8439 | 72660.0 |
| 2009-03-26 08:50:00 | AAPL | Stock | 3.8454 | 3.8454 | 3.8396 | 3.8418 | 88200.0 |
| 2009-03-26 08:55:00 | AAPL | Stock | 3.8418 | 3.8457 | 3.8404 | 3.8446 | 170100.0 |
| 2009-03-26 09:00:00 | AAPL | Stock | 3.8464 | 3.8468 | 3.8457 | 3.8464 | 107100.0 |
| 2009-03-26 09:05:00 | AAPL | Stock | 3.8479 | 3.8532 | 3.8479 | 3.8482 | 310240.0 |
| 2009-03-26 09:10:00 | AAPL | Stock | 3.85 | 3.85 | 3.8464 | 3.8464 | 263480.0 |
| 2009-03-26 09:15:00 | AAPL | Stock | 3.8475 | 3.85 | 3.8475 | 3.85 | 93800.0 |
| 2009-03-26 09:20:00 | AAPL | Stock | 3.8482 | 3.8529 | 3.8461 | 3.8464 | 177800.0 |
| 2009-03-26 09:25:00 | AAPL | Stock | 3.8504 | 3.8571 | 3.85 | 3.8571 | 248500.0 |
| 2009-03-26 09:30:00 | AAPL | Stock | 3.8511 | 3.8696 | 3.8421 | 3.8554 | 16060828.0 |
| 2009-03-26 09:35:00 | AAPL | Stock | 3.8571 | 3.8814 | 3.8507 | 3.8662 | 12879636.0 |
| 2009-03-26 09:40:00 | AAPL | Stock | 3.8657 | 3.8829 | 3.865 | 3.88 | 11483612.0 |
| 2009-03-26 09:45:00 | AAPL | Stock | 3.88 | 3.8818 | 3.8611 | 3.8632 | 11137952.0 |
| 2009-03-26 09:50:00 | AAPL | Stock | 3.8632 | 3.8768 | 3.8554 | 3.8586 | 10463348.0 |
| 2009-03-26 09:55:00 | AAPL | Stock | 3.8579 | 3.8711 | 3.8561 | 3.8693 | 7245896.0 |
| 2009-03-26 10:00:00 | AAPL | Stock | 3.8696 | 3.8907 | 3.865 | 3.8864 | 12089196.0 |
| 2009-03-26 10:05:00 | AAPL | Stock | 3.8864 | 3.9043 | 3.8832 | 3.8861 | 13134436.0 |
| 2009-03-26 10:10:00 | AAPL | Stock | 3.8853 | 3.8857 | 3.8621 | 3.8636 | 12386864.0 |
| 2009-03-26 10:15:00 | AAPL | Stock | 3.8643 | 3.8725 | 3.8607 | 3.8632 | 9272172.0 |
| 2009-03-26 10:20:00 | AAPL | Stock | 3.8636 | 3.8732 | 3.86 | 3.8686 | 6708212.0 |
| 2009-03-26 10:25:00 | AAPL | Stock | 3.8687 | 3.87 | 3.8514 | 3.8521 | 7022540.0 |
| 2009-03-26 10:30:00 | AAPL | Stock | 3.8525 | 3.8571 | 3.8436 | 3.8564 | 8890644.0 |
| 2009-03-26 10:35:00 | AAPL | Stock | 3.8568 | 3.8782 | 3.8564 | 3.869 | 7078232.0 |
| 2009-03-26 10:40:00 | AAPL | Stock | 3.8696 | 3.8789 | 3.865 | 3.8661 | 4849768.0 |
| 2009-03-26 10:45:00 | AAPL | Stock | 3.8654 | 3.8743 | 3.8611 | 3.8679 | 3539396.0 |
| 2009-03-26 10:50:00 | AAPL | Stock | 3.8686 | 3.8743 | 3.861 | 3.865 | 4387712.0 |
| 2009-03-26 10:55:00 | AAPL | Stock | 3.8654 | 3.8832 | 3.8621 | 3.8829 | 8473752.0 |
| 2009-03-26 11:00:00 | AAPL | Stock | 3.8829 | 3.8957 | 3.8782 | 3.8914 | 8163008.0 |
| 2009-03-26 11:05:00 | AAPL | Stock | 3.8904 | 3.9018 | 3.8861 | 3.8932 | 5473132.0 |
| 2009-03-26 11:10:00 | AAPL | Stock | 3.8932 | 3.8943 | 3.8779 | 3.8811 | 6904492.0 |
| 2009-03-26 11:15:00 | AAPL | Stock | 3.8807 | 3.8861 | 3.8682 | 3.875 | 9200716.0 |
| 2009-03-26 11:20:00 | AAPL | Stock | 3.8752 | 3.8925 | 3.8725 | 3.8861 | 4994248.0 |
| 2009-03-26 11:25:00 | AAPL | Stock | 3.8861 | 3.8957 | 3.875 | 3.8782 | 5114844.0 |
| 2009-03-26 11:30:00 | AAPL | Stock | 3.8779 | 3.8918 | 3.8764 | 3.8879 | 3523660.0 |
| 2009-03-26 11:35:00 | AAPL | Stock | 3.8875 | 3.8946 | 3.8832 | 3.8925 | 5346628.0 |
| 2009-03-26 11:40:00 | AAPL | Stock | 3.8929 | 3.8964 | 3.8857 | 3.8946 | 4312224.0 |
| 2009-03-26 11:45:00 | AAPL | Stock | 3.8946 | 3.8964 | 3.8814 | 3.8839 | 4197284.0 |
| 2009-03-26 11:50:00 | AAPL | Stock | 3.8839 | 3.89 | 3.8807 | 3.8882 | 4987948.0 |
| 2009-03-26 11:55:00 | AAPL | Stock | 3.8879 | 3.8907 | 3.8796 | 3.8864 | 4001732.0 |
| 2009-03-26 12:00:00 | AAPL | Stock | 3.8871 | 3.8914 | 3.8793 | 3.8882 | 3204292.0 |
| 2009-03-26 12:05:00 | AAPL | Stock | 3.8882 | 3.8961 | 3.8864 | 3.8896 | 4820508.0 |
> showing 50 of 313,054 rows — these rows as CSV