PREVIEW / stock_5min / 2007-10-02
file: by_date/stock_5min/2007/2007-10-02.parquet size: 4.2 MB rows: 310,102 symbols: 3,114
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-02 05:45:00 | AAPL | Stock | 5.6018 | 5.6018 | 5.6018 | 5.6018 | 4200.0 |
| 2007-10-02 05:55:00 | AAPL | Stock | 5.6018 | 5.6018 | 5.6018 | 5.6018 | 11200.0 |
| 2007-10-02 06:00:00 | AAPL | Stock | 5.6018 | 5.6018 | 5.6018 | 5.6018 | 6272.0 |
| 2007-10-02 06:20:00 | AAPL | Stock | 5.6154 | 5.6154 | 5.6154 | 5.6154 | 2800.0 |
| 2007-10-02 06:40:00 | AAPL | Stock | 5.6154 | 5.6154 | 5.6154 | 5.6154 | 2800.0 |
| 2007-10-02 07:05:00 | AAPL | Stock | 5.6018 | 5.6161 | 5.6018 | 5.6061 | 56000.0 |
| 2007-10-02 07:10:00 | AAPL | Stock | 5.6043 | 5.6171 | 5.6043 | 5.6171 | 5600.0 |
| 2007-10-02 07:15:00 | AAPL | Stock | 5.6168 | 5.6189 | 5.6168 | 5.6175 | 53200.0 |
| 2007-10-02 07:20:00 | AAPL | Stock | 5.6143 | 5.6143 | 5.6054 | 5.6054 | 11200.0 |
| 2007-10-02 07:25:00 | AAPL | Stock | 5.5929 | 5.5936 | 5.5929 | 5.5936 | 5600.0 |
| 2007-10-02 07:35:00 | AAPL | Stock | 5.5982 | 5.6071 | 5.5982 | 5.6071 | 15400.0 |
| 2007-10-02 07:40:00 | AAPL | Stock | 5.6068 | 5.6114 | 5.6068 | 5.6114 | 32900.0 |
| 2007-10-02 07:50:00 | AAPL | Stock | 5.6125 | 5.6125 | 5.6121 | 5.6125 | 50400.0 |
| 2007-10-02 07:55:00 | AAPL | Stock | 5.6061 | 5.6061 | 5.6054 | 5.6054 | 42000.0 |
| 2007-10-02 08:00:00 | AAPL | Stock | 5.6071 | 5.615 | 5.6039 | 5.6075 | 837200.0 |
| 2007-10-02 08:05:00 | AAPL | Stock | 5.6071 | 5.6107 | 5.6043 | 5.6096 | 309232.0 |
| 2007-10-02 08:10:00 | AAPL | Stock | 5.6107 | 5.6125 | 5.6043 | 5.6089 | 440552.0 |
| 2007-10-02 08:15:00 | AAPL | Stock | 5.6089 | 5.6121 | 5.6036 | 5.6036 | 350336.0 |
| 2007-10-02 08:20:00 | AAPL | Stock | 5.6039 | 5.6071 | 5.5964 | 5.6 | 499576.0 |
| 2007-10-02 08:25:00 | AAPL | Stock | 5.5993 | 5.6029 | 5.5989 | 5.6021 | 188972.0 |
| 2007-10-02 08:30:00 | AAPL | Stock | 5.6018 | 5.6032 | 5.5982 | 5.6011 | 173292.0 |
| 2007-10-02 08:35:00 | AAPL | Stock | 5.5986 | 5.6043 | 5.5893 | 5.5904 | 660100.0 |
| 2007-10-02 08:40:00 | AAPL | Stock | 5.5868 | 5.5907 | 5.5811 | 5.5857 | 913976.0 |
| 2007-10-02 08:45:00 | AAPL | Stock | 5.5857 | 5.5857 | 5.5736 | 5.5811 | 738024.0 |
| 2007-10-02 08:50:00 | AAPL | Stock | 5.5839 | 5.5839 | 5.5768 | 5.5786 | 459032.0 |
| 2007-10-02 08:55:00 | AAPL | Stock | 5.5793 | 5.5861 | 5.5786 | 5.5861 | 164556.0 |
| 2007-10-02 09:00:00 | AAPL | Stock | 5.5864 | 5.5875 | 5.5857 | 5.5861 | 285292.0 |
| 2007-10-02 09:05:00 | AAPL | Stock | 5.5861 | 5.5946 | 5.5857 | 5.5911 | 621348.0 |
| 2007-10-02 09:10:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5786 | 5.5861 | 393120.0 |
| 2007-10-02 09:15:00 | AAPL | Stock | 5.5857 | 5.5857 | 5.5835 | 5.5854 | 71680.0 |
| 2007-10-02 09:20:00 | AAPL | Stock | 5.5854 | 5.6039 | 5.5854 | 5.6039 | 506184.0 |
| 2007-10-02 09:25:00 | AAPL | Stock | 5.5993 | 5.6011 | 5.5914 | 5.5918 | 356300.0 |
| 2007-10-02 09:30:00 | AAPL | Stock | 5.5911 | 5.6143 | 5.5761 | 5.6118 | 29082228.0 |
| 2007-10-02 09:35:00 | AAPL | Stock | 5.6125 | 5.6325 | 5.6075 | 5.6107 | 26275228.0 |
| 2007-10-02 09:40:00 | AAPL | Stock | 5.6104 | 5.6231 | 5.5929 | 5.6129 | 18713128.0 |
| 2007-10-02 09:45:00 | AAPL | Stock | 5.6129 | 5.6143 | 5.5929 | 5.5946 | 12597312.0 |
| 2007-10-02 09:50:00 | AAPL | Stock | 5.5932 | 5.6122 | 5.5914 | 5.6046 | 15451772.0 |
| 2007-10-02 09:55:00 | AAPL | Stock | 5.605 | 5.6207 | 5.6039 | 5.6118 | 13629980.0 |
| 2007-10-02 10:00:00 | AAPL | Stock | 5.6111 | 5.6364 | 5.6068 | 5.6304 | 20392176.0 |
| 2007-10-02 10:05:00 | AAPL | Stock | 5.6304 | 5.6489 | 5.6279 | 5.6468 | 22481480.0 |
| 2007-10-02 10:10:00 | AAPL | Stock | 5.6479 | 5.6639 | 5.6468 | 5.6561 | 21746872.0 |
| 2007-10-02 10:15:00 | AAPL | Stock | 5.6561 | 5.66 | 5.6386 | 5.6421 | 12091772.0 |
| 2007-10-02 10:20:00 | AAPL | Stock | 5.642 | 5.6421 | 5.6236 | 5.625 | 12243952.0 |
| 2007-10-02 10:25:00 | AAPL | Stock | 5.625 | 5.6311 | 5.6171 | 5.6289 | 13592236.0 |
| 2007-10-02 10:30:00 | AAPL | Stock | 5.6289 | 5.6418 | 5.6254 | 5.6361 | 10128188.0 |
| 2007-10-02 10:35:00 | AAPL | Stock | 5.6371 | 5.6386 | 5.6264 | 5.6364 | 9277968.0 |
| 2007-10-02 10:40:00 | AAPL | Stock | 5.6354 | 5.6393 | 5.6279 | 5.6329 | 8723456.0 |
| 2007-10-02 10:45:00 | AAPL | Stock | 5.6332 | 5.6343 | 5.6221 | 5.6221 | 10595032.0 |
| 2007-10-02 10:50:00 | AAPL | Stock | 5.6221 | 5.625 | 5.5907 | 5.593 | 29079400.0 |
| 2007-10-02 10:55:00 | AAPL | Stock | 5.5929 | 5.6104 | 5.5893 | 5.5964 | 21793492.0 |
> showing 50 of 310,102 rows — these rows as CSV