PREVIEW / stock_5min / 2009-06-12
file: by_date/stock_5min/2009/2009-06-12.parquet size: 4.6 MB rows: 318,828 symbols: 3,364
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-06-12 07:20:00 | AAPL | Stock | 4.9818 | 4.9818 | 4.98 | 4.98 | 9800.0 |
| 2009-06-12 08:00:00 | AAPL | Stock | 4.98 | 4.9821 | 4.98 | 4.9821 | 13244.0 |
| 2009-06-12 08:05:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9818 | 4.9821 | 47516.0 |
| 2009-06-12 08:10:00 | AAPL | Stock | 4.9768 | 4.9768 | 4.975 | 4.9757 | 19600.0 |
| 2009-06-12 08:15:00 | AAPL | Stock | 4.9757 | 4.9757 | 4.9643 | 4.9643 | 122640.0 |
| 2009-06-12 08:20:00 | AAPL | Stock | 4.9675 | 4.9679 | 4.9611 | 4.9611 | 84084.0 |
| 2009-06-12 08:25:00 | AAPL | Stock | 4.9621 | 4.9621 | 4.9593 | 4.9593 | 45668.0 |
| 2009-06-12 08:30:00 | AAPL | Stock | 4.9621 | 5.0 | 4.9571 | 4.9607 | 557732.0 |
| 2009-06-12 08:35:00 | AAPL | Stock | 4.9593 | 4.9643 | 4.9593 | 4.9636 | 44100.0 |
| 2009-06-12 08:40:00 | AAPL | Stock | 4.9621 | 4.9636 | 4.9621 | 4.9636 | 18480.0 |
| 2009-06-12 08:45:00 | AAPL | Stock | 4.9593 | 4.9614 | 4.9589 | 4.9614 | 38360.0 |
| 2009-06-12 08:50:00 | AAPL | Stock | 4.9607 | 4.9607 | 4.9582 | 4.9582 | 25200.0 |
| 2009-06-12 08:55:00 | AAPL | Stock | 4.9607 | 4.9607 | 4.9536 | 4.9571 | 107436.0 |
| 2009-06-12 09:00:00 | AAPL | Stock | 4.9571 | 4.9607 | 4.9536 | 4.9575 | 128800.0 |
| 2009-06-12 09:05:00 | AAPL | Stock | 4.9575 | 4.9607 | 4.9575 | 4.9589 | 90272.0 |
| 2009-06-12 09:10:00 | AAPL | Stock | 4.9589 | 4.9607 | 4.9579 | 4.9589 | 75908.0 |
| 2009-06-12 09:15:00 | AAPL | Stock | 4.9589 | 4.9607 | 4.9564 | 4.9564 | 58100.0 |
| 2009-06-12 09:20:00 | AAPL | Stock | 4.9564 | 4.9607 | 4.9554 | 4.96 | 61264.0 |
| 2009-06-12 09:25:00 | AAPL | Stock | 4.96 | 4.9668 | 4.9593 | 4.9593 | 109200.0 |
| 2009-06-12 09:30:00 | AAPL | Stock | 4.9575 | 4.9679 | 4.9118 | 4.9154 | 19679716.0 |
| 2009-06-12 09:35:00 | AAPL | Stock | 4.9157 | 4.9357 | 4.9132 | 4.9296 | 17393600.0 |
| 2009-06-12 09:40:00 | AAPL | Stock | 4.9293 | 4.93 | 4.9125 | 4.9179 | 13576808.0 |
| 2009-06-12 09:45:00 | AAPL | Stock | 4.9182 | 4.93 | 4.9161 | 4.9207 | 8112860.0 |
| 2009-06-12 09:50:00 | AAPL | Stock | 4.9218 | 4.9286 | 4.91 | 4.9171 | 12960892.0 |
| 2009-06-12 09:55:00 | AAPL | Stock | 4.9168 | 4.9196 | 4.8964 | 4.8993 | 13968248.0 |
| 2009-06-12 10:00:00 | AAPL | Stock | 4.8993 | 4.9 | 4.8764 | 4.8846 | 19986484.0 |
| 2009-06-12 10:05:00 | AAPL | Stock | 4.885 | 4.8975 | 4.8818 | 4.8925 | 12123048.0 |
| 2009-06-12 10:10:00 | AAPL | Stock | 4.8929 | 4.9021 | 4.8871 | 4.8993 | 7562828.0 |
| 2009-06-12 10:15:00 | AAPL | Stock | 4.8995 | 4.9071 | 4.8946 | 4.9036 | 8135624.0 |
| 2009-06-12 10:20:00 | AAPL | Stock | 4.9039 | 4.9132 | 4.9004 | 4.9004 | 7193284.0 |
| 2009-06-12 10:25:00 | AAPL | Stock | 4.9004 | 4.9018 | 4.8929 | 4.8939 | 5303256.0 |
| 2009-06-12 10:30:00 | AAPL | Stock | 4.8939 | 4.8996 | 4.8871 | 4.8975 | 4937184.0 |
| 2009-06-12 10:35:00 | AAPL | Stock | 4.8971 | 4.9 | 4.8889 | 4.8925 | 11127116.0 |
| 2009-06-12 10:40:00 | AAPL | Stock | 4.8932 | 4.8982 | 4.8929 | 4.8982 | 8409016.0 |
| 2009-06-12 10:45:00 | AAPL | Stock | 4.8979 | 4.9032 | 4.8857 | 4.8864 | 7711592.0 |
| 2009-06-12 10:50:00 | AAPL | Stock | 4.8868 | 4.8954 | 4.8796 | 4.8932 | 8236844.0 |
| 2009-06-12 10:55:00 | AAPL | Stock | 4.8932 | 4.8936 | 4.8871 | 4.8914 | 3990140.0 |
| 2009-06-12 11:00:00 | AAPL | Stock | 4.8914 | 4.8954 | 4.8886 | 4.8911 | 5635252.0 |
| 2009-06-12 11:05:00 | AAPL | Stock | 4.8907 | 4.8936 | 4.8886 | 4.8894 | 3898720.0 |
| 2009-06-12 11:10:00 | AAPL | Stock | 4.8893 | 4.8946 | 4.8871 | 4.8896 | 3288964.0 |
| 2009-06-12 11:15:00 | AAPL | Stock | 4.89 | 4.8929 | 4.8857 | 4.8898 | 2537584.0 |
| 2009-06-12 11:20:00 | AAPL | Stock | 4.8896 | 4.8943 | 4.8893 | 4.893 | 3049284.0 |
| 2009-06-12 11:25:00 | AAPL | Stock | 4.8936 | 4.8968 | 4.8893 | 4.8942 | 3193596.0 |
| 2009-06-12 11:30:00 | AAPL | Stock | 4.8936 | 4.8954 | 4.8882 | 4.8886 | 3257688.0 |
| 2009-06-12 11:35:00 | AAPL | Stock | 4.8882 | 4.8896 | 4.8807 | 4.8889 | 6425104.0 |
| 2009-06-12 11:40:00 | AAPL | Stock | 4.8893 | 4.8939 | 4.8807 | 4.8832 | 3693256.0 |
| 2009-06-12 11:45:00 | AAPL | Stock | 4.8832 | 4.8864 | 4.8789 | 4.8818 | 4378528.0 |
| 2009-06-12 11:50:00 | AAPL | Stock | 4.8818 | 4.8864 | 4.8814 | 4.8854 | 2632056.0 |
| 2009-06-12 11:55:00 | AAPL | Stock | 4.8854 | 4.8893 | 4.8814 | 4.8821 | 3206504.0 |
| 2009-06-12 12:00:00 | AAPL | Stock | 4.8825 | 4.8825 | 4.8775 | 4.8785 | 4650800.0 |
> showing 50 of 318,828 rows — these rows as CSV