PREVIEW / stock_5min / 2010-03-11
file: by_date/stock_5min/2010/2010-03-11.parquet size: 4.7 MB rows: 321,759 symbols: 3,461
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-11 05:25:00 | AAPL | Stock | 8.0618 | 8.0618 | 8.0618 | 8.0618 | 7000.0 |
| 2010-03-11 07:10:00 | AAPL | Stock | 8.0393 | 8.0393 | 8.0393 | 8.0393 | 2800.0 |
| 2010-03-11 07:25:00 | AAPL | Stock | 8.0429 | 8.0429 | 8.0429 | 8.0429 | 2800.0 |
| 2010-03-11 07:30:00 | AAPL | Stock | 8.0329 | 8.0329 | 8.0286 | 8.0286 | 56000.0 |
| 2010-03-11 07:35:00 | AAPL | Stock | 8.0286 | 8.0286 | 8.0286 | 8.0286 | 28000.0 |
| 2010-03-11 07:50:00 | AAPL | Stock | 8.0289 | 8.0289 | 8.0289 | 8.0289 | 5600.0 |
| 2010-03-11 07:55:00 | AAPL | Stock | 8.0289 | 8.0289 | 8.025 | 8.025 | 33712.0 |
| 2010-03-11 08:00:00 | AAPL | Stock | 8.025 | 8.025 | 8.0179 | 8.0179 | 70420.0 |
| 2010-03-11 08:05:00 | AAPL | Stock | 8.0164 | 8.0261 | 8.0157 | 8.0261 | 86996.0 |
| 2010-03-11 08:10:00 | AAPL | Stock | 8.0257 | 8.0261 | 8.0164 | 8.0164 | 44576.0 |
| 2010-03-11 08:15:00 | AAPL | Stock | 8.0239 | 8.0239 | 8.0179 | 8.0179 | 15400.0 |
| 2010-03-11 08:20:00 | AAPL | Stock | 8.0214 | 8.0243 | 8.0202 | 8.0204 | 31920.0 |
| 2010-03-11 08:25:00 | AAPL | Stock | 8.0204 | 8.025 | 8.0129 | 8.02 | 75768.0 |
| 2010-03-11 08:30:00 | AAPL | Stock | 8.0196 | 8.0307 | 8.0036 | 8.0146 | 209748.0 |
| 2010-03-11 08:35:00 | AAPL | Stock | 8.0129 | 8.0136 | 8.0068 | 8.0107 | 129920.0 |
| 2010-03-11 08:40:00 | AAPL | Stock | 8.0093 | 8.0093 | 7.9921 | 7.9921 | 513520.0 |
| 2010-03-11 08:45:00 | AAPL | Stock | 7.9932 | 7.9961 | 7.9889 | 7.9961 | 308392.0 |
| 2010-03-11 08:50:00 | AAPL | Stock | 7.9954 | 8.0 | 7.9914 | 7.9943 | 156968.0 |
| 2010-03-11 08:55:00 | AAPL | Stock | 7.9957 | 8.0004 | 7.9929 | 8.0 | 116900.0 |
| 2010-03-11 09:00:00 | AAPL | Stock | 7.9971 | 8.0004 | 7.9971 | 7.9996 | 143668.0 |
| 2010-03-11 09:05:00 | AAPL | Stock | 7.9996 | 7.9996 | 7.9964 | 7.9993 | 110600.0 |
| 2010-03-11 09:10:00 | AAPL | Stock | 7.9993 | 8.0011 | 7.9975 | 8.0011 | 87556.0 |
| 2010-03-11 09:15:00 | AAPL | Stock | 8.0004 | 8.0061 | 8.0004 | 8.0014 | 140644.0 |
| 2010-03-11 09:20:00 | AAPL | Stock | 8.0014 | 8.0043 | 8.0014 | 8.0021 | 75600.0 |
| 2010-03-11 09:25:00 | AAPL | Stock | 8.0036 | 8.0057 | 7.9964 | 7.9968 | 188664.0 |
| 2010-03-11 09:30:00 | AAPL | Stock | 7.9968 | 8.0129 | 7.9757 | 7.9793 | 15960924.0 |
| 2010-03-11 09:35:00 | AAPL | Stock | 7.9786 | 7.9921 | 7.9771 | 7.985 | 11099984.0 |
| 2010-03-11 09:40:00 | AAPL | Stock | 7.9864 | 8.0214 | 7.9854 | 8.0161 | 13863248.0 |
| 2010-03-11 09:45:00 | AAPL | Stock | 8.0164 | 8.0261 | 8.0011 | 8.0011 | 10269616.0 |
| 2010-03-11 09:50:00 | AAPL | Stock | 8.0025 | 8.0064 | 7.9821 | 7.9996 | 14009268.0 |
| 2010-03-11 09:55:00 | AAPL | Stock | 7.9982 | 8.0061 | 7.9886 | 7.9957 | 6620068.0 |
| 2010-03-11 10:00:00 | AAPL | Stock | 7.9961 | 8.0114 | 7.9957 | 8.0039 | 6839448.0 |
| 2010-03-11 10:05:00 | AAPL | Stock | 8.0046 | 8.0211 | 8.0018 | 8.0089 | 7567868.0 |
| 2010-03-11 10:10:00 | AAPL | Stock | 8.01 | 8.0136 | 7.9971 | 7.9979 | 5275312.0 |
| 2010-03-11 10:15:00 | AAPL | Stock | 7.9986 | 8.0132 | 7.9979 | 8.0107 | 3229240.0 |
| 2010-03-11 10:20:00 | AAPL | Stock | 8.0108 | 8.0157 | 7.9975 | 8.0018 | 4606112.0 |
| 2010-03-11 10:25:00 | AAPL | Stock | 8.0007 | 8.0096 | 8.0007 | 8.0041 | 2432640.0 |
| 2010-03-11 10:30:00 | AAPL | Stock | 8.0041 | 8.0054 | 7.9936 | 7.9939 | 5217128.0 |
| 2010-03-11 10:35:00 | AAPL | Stock | 7.9939 | 8.0079 | 7.9939 | 8.0066 | 4583572.0 |
| 2010-03-11 10:40:00 | AAPL | Stock | 8.0064 | 8.0157 | 8.0061 | 8.0114 | 5157264.0 |
| 2010-03-11 10:45:00 | AAPL | Stock | 8.0111 | 8.0161 | 8.0086 | 8.016 | 3683736.0 |
| 2010-03-11 10:50:00 | AAPL | Stock | 8.015 | 8.0229 | 8.0121 | 8.0196 | 6284628.0 |
| 2010-03-11 10:55:00 | AAPL | Stock | 8.0196 | 8.0229 | 8.0182 | 8.0186 | 3866016.0 |
| 2010-03-11 11:00:00 | AAPL | Stock | 8.0188 | 8.0268 | 8.0121 | 8.0121 | 7356272.0 |
| 2010-03-11 11:05:00 | AAPL | Stock | 8.0125 | 8.0171 | 8.0061 | 8.0121 | 6353368.0 |
| 2010-03-11 11:10:00 | AAPL | Stock | 8.0129 | 8.0161 | 8.0071 | 8.0149 | 3502968.0 |
| 2010-03-11 11:15:00 | AAPL | Stock | 8.0155 | 8.02 | 8.0118 | 8.0143 | 3650024.0 |
| 2010-03-11 11:20:00 | AAPL | Stock | 8.0157 | 8.0214 | 8.0146 | 8.0161 | 3658508.0 |
| 2010-03-11 11:25:00 | AAPL | Stock | 8.0168 | 8.0175 | 8.0093 | 8.0102 | 2446080.0 |
| 2010-03-11 11:30:00 | AAPL | Stock | 8.0114 | 8.0136 | 8.0071 | 8.0071 | 2161964.0 |
> showing 50 of 321,759 rows — these rows as CSV