PREVIEW / stock_5min / 2009-08-31
file: by_date/stock_5min/2009/2009-08-31.parquet size: 4.7 MB rows: 326,796 symbols: 3,385
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-08-31 07:00:00 | AAPL | Stock | 6.0536 | 6.0536 | 6.0536 | 6.0536 | 11200.0 |
| 2009-08-31 07:20:00 | AAPL | Stock | 6.0196 | 6.0196 | 6.0196 | 6.0196 | 35784.0 |
| 2009-08-31 07:25:00 | AAPL | Stock | 6.0196 | 6.035 | 6.0196 | 6.035 | 36400.0 |
| 2009-08-31 07:35:00 | AAPL | Stock | 6.0268 | 6.0268 | 6.0268 | 6.0268 | 14000.0 |
| 2009-08-31 07:45:00 | AAPL | Stock | 6.0139 | 6.0239 | 6.0139 | 6.0239 | 8400.0 |
| 2009-08-31 07:55:00 | AAPL | Stock | 6.0232 | 6.025 | 6.0232 | 6.025 | 40348.0 |
| 2009-08-31 08:00:00 | AAPL | Stock | 6.0268 | 6.0268 | 6.0107 | 6.0107 | 147252.0 |
| 2009-08-31 08:05:00 | AAPL | Stock | 6.0107 | 6.0139 | 6.0054 | 6.0107 | 132776.0 |
| 2009-08-31 08:10:00 | AAPL | Stock | 6.0107 | 6.0125 | 6.0107 | 6.0111 | 19180.0 |
| 2009-08-31 08:15:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0161 | 6.0179 | 46480.0 |
| 2009-08-31 08:20:00 | AAPL | Stock | 6.0225 | 6.0225 | 6.0168 | 6.0214 | 30884.0 |
| 2009-08-31 08:25:00 | AAPL | Stock | 6.0214 | 6.0232 | 6.0125 | 6.0125 | 82852.0 |
| 2009-08-31 08:30:00 | AAPL | Stock | 6.0121 | 6.0125 | 6.0107 | 6.0125 | 64176.0 |
| 2009-08-31 08:35:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0114 | 6.0168 | 20160.0 |
| 2009-08-31 08:40:00 | AAPL | Stock | 6.0168 | 6.0179 | 6.0168 | 6.0175 | 39844.0 |
| 2009-08-31 08:45:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0132 | 6.0146 | 50232.0 |
| 2009-08-31 08:50:00 | AAPL | Stock | 6.0132 | 6.0132 | 6.0125 | 6.0125 | 22120.0 |
| 2009-08-31 08:55:00 | AAPL | Stock | 6.0125 | 6.0125 | 6.0089 | 6.0089 | 105000.0 |
| 2009-08-31 09:00:00 | AAPL | Stock | 6.0057 | 6.0107 | 6.0054 | 6.0089 | 104384.0 |
| 2009-08-31 09:05:00 | AAPL | Stock | 6.0082 | 6.0089 | 6.0039 | 6.0039 | 167720.0 |
| 2009-08-31 09:10:00 | AAPL | Stock | 6.0054 | 6.0107 | 6.0054 | 6.0089 | 63532.0 |
| 2009-08-31 09:15:00 | AAPL | Stock | 6.0107 | 6.0171 | 6.0107 | 6.0171 | 50988.0 |
| 2009-08-31 09:20:00 | AAPL | Stock | 6.0168 | 6.0168 | 6.0136 | 6.0139 | 33600.0 |
| 2009-08-31 09:25:00 | AAPL | Stock | 6.0171 | 6.0171 | 6.0018 | 6.0032 | 569576.0 |
| 2009-08-31 09:30:00 | AAPL | Stock | 6.0057 | 6.0246 | 5.9932 | 6.0082 | 16262848.0 |
| 2009-08-31 09:35:00 | AAPL | Stock | 6.01 | 6.0229 | 6.0007 | 6.0225 | 6627460.0 |
| 2009-08-31 09:40:00 | AAPL | Stock | 6.0225 | 6.0264 | 6.0054 | 6.0133 | 8819160.0 |
| 2009-08-31 09:45:00 | AAPL | Stock | 6.0121 | 6.0304 | 5.9911 | 5.9957 | 11233292.0 |
| 2009-08-31 09:50:00 | AAPL | Stock | 5.995 | 5.9964 | 5.975 | 5.9843 | 11298952.0 |
| 2009-08-31 09:55:00 | AAPL | Stock | 5.9836 | 5.9986 | 5.9829 | 5.9914 | 5910408.0 |
| 2009-08-31 10:00:00 | AAPL | Stock | 5.9911 | 6.0014 | 5.9868 | 6.0014 | 5932696.0 |
| 2009-08-31 10:05:00 | AAPL | Stock | 6.0007 | 6.0009 | 5.9929 | 5.9989 | 2809240.0 |
| 2009-08-31 10:10:00 | AAPL | Stock | 5.9989 | 5.9989 | 5.9875 | 5.9936 | 4283048.0 |
| 2009-08-31 10:15:00 | AAPL | Stock | 5.9939 | 5.9982 | 5.9825 | 5.9882 | 4908428.0 |
| 2009-08-31 10:20:00 | AAPL | Stock | 5.9889 | 5.9993 | 5.9886 | 5.99 | 4693920.0 |
| 2009-08-31 10:25:00 | AAPL | Stock | 5.99 | 5.9946 | 5.9839 | 5.9929 | 4383120.0 |
| 2009-08-31 10:30:00 | AAPL | Stock | 5.9929 | 5.9946 | 5.9836 | 5.9911 | 2282000.0 |
| 2009-08-31 10:35:00 | AAPL | Stock | 5.9914 | 6.0057 | 5.99 | 6.0032 | 4061484.0 |
| 2009-08-31 10:40:00 | AAPL | Stock | 6.0039 | 6.0161 | 6.0029 | 6.0146 | 8772596.0 |
| 2009-08-31 10:45:00 | AAPL | Stock | 6.0147 | 6.0171 | 6.005 | 6.0086 | 3067680.0 |
| 2009-08-31 10:50:00 | AAPL | Stock | 6.0089 | 6.0171 | 6.0089 | 6.0121 | 3690148.0 |
| 2009-08-31 10:55:00 | AAPL | Stock | 6.0114 | 6.0129 | 6.0004 | 6.0093 | 3843756.0 |
| 2009-08-31 11:00:00 | AAPL | Stock | 6.0093 | 6.0111 | 5.9993 | 6.0036 | 2288804.0 |
| 2009-08-31 11:05:00 | AAPL | Stock | 6.0029 | 6.0054 | 6.0 | 6.0039 | 1994328.0 |
| 2009-08-31 11:10:00 | AAPL | Stock | 6.005 | 6.0054 | 5.9957 | 5.9957 | 2035096.0 |
| 2009-08-31 11:15:00 | AAPL | Stock | 5.9957 | 5.9993 | 5.9893 | 5.9909 | 2771580.0 |
| 2009-08-31 11:20:00 | AAPL | Stock | 5.9911 | 5.9975 | 5.9829 | 5.9854 | 3068268.0 |
| 2009-08-31 11:25:00 | AAPL | Stock | 5.9854 | 5.9896 | 5.9854 | 5.9864 | 2394336.0 |
| 2009-08-31 11:30:00 | AAPL | Stock | 5.9868 | 5.9957 | 5.9864 | 5.9882 | 2046940.0 |
| 2009-08-31 11:35:00 | AAPL | Stock | 5.9893 | 5.9981 | 5.9871 | 5.9971 | 1704080.0 |
> showing 50 of 326,796 rows — these rows as CSV