PREVIEW / stock_1min / 2007-05-14
file: by_date/stock_1min/2007/2007-05-14.parquet size: 10.7 MB rows: 885,015 symbols: 2,260
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-05-14 09:30:00 | AAPL | Stock | 3.915 | 3.9179 | 3.8429 | 3.9068 | 7820932.0 |
| 2007-05-14 09:31:00 | AAPL | Stock | 3.9071 | 3.9143 | 3.906 | 3.9125 | 2453108.0 |
| 2007-05-14 09:32:00 | AAPL | Stock | 3.9129 | 3.9196 | 3.9129 | 3.9189 | 3184104.0 |
| 2007-05-14 09:33:00 | AAPL | Stock | 3.9193 | 3.9279 | 3.9186 | 3.9271 | 5466048.0 |
| 2007-05-14 09:34:00 | AAPL | Stock | 3.9271 | 3.9286 | 3.9261 | 3.9268 | 5684056.0 |
| 2007-05-14 09:35:00 | AAPL | Stock | 3.9264 | 3.9282 | 3.9218 | 3.9218 | 4405464.0 |
| 2007-05-14 09:36:00 | AAPL | Stock | 3.9229 | 3.9264 | 3.9218 | 3.9246 | 2791236.0 |
| 2007-05-14 09:37:00 | AAPL | Stock | 3.9243 | 3.925 | 3.9143 | 3.9164 | 3332056.0 |
| 2007-05-14 09:38:00 | AAPL | Stock | 3.9157 | 3.9179 | 3.9107 | 3.9175 | 4196920.0 |
| 2007-05-14 09:39:00 | AAPL | Stock | 3.9168 | 3.9225 | 3.9168 | 3.9207 | 1920632.0 |
| 2007-05-14 09:40:00 | AAPL | Stock | 3.9207 | 3.9243 | 3.92 | 3.9221 | 1471008.0 |
| 2007-05-14 09:41:00 | AAPL | Stock | 3.9221 | 3.9268 | 3.9221 | 3.9264 | 1992956.0 |
| 2007-05-14 09:42:00 | AAPL | Stock | 3.9264 | 3.9271 | 3.9193 | 3.9196 | 2911496.0 |
| 2007-05-14 09:43:00 | AAPL | Stock | 3.9193 | 3.9236 | 3.9171 | 3.9218 | 1990296.0 |
| 2007-05-14 09:44:00 | AAPL | Stock | 3.9221 | 3.9236 | 3.9186 | 3.92 | 1259860.0 |
| 2007-05-14 09:45:00 | AAPL | Stock | 3.92 | 3.9221 | 3.9164 | 3.9171 | 5762904.0 |
| 2007-05-14 09:46:00 | AAPL | Stock | 3.9164 | 3.9196 | 3.9136 | 3.9157 | 2246944.0 |
| 2007-05-14 09:47:00 | AAPL | Stock | 3.9164 | 3.9193 | 3.915 | 3.9168 | 1288868.0 |
| 2007-05-14 09:48:00 | AAPL | Stock | 3.9168 | 3.9236 | 3.9164 | 3.9221 | 1943088.0 |
| 2007-05-14 09:49:00 | AAPL | Stock | 3.9214 | 3.9232 | 3.9164 | 3.9193 | 2058588.0 |
| 2007-05-14 09:50:00 | AAPL | Stock | 3.9189 | 3.9193 | 3.9161 | 3.9179 | 2576700.0 |
| 2007-05-14 09:51:00 | AAPL | Stock | 3.9171 | 3.9214 | 3.9164 | 3.9193 | 3236324.0 |
| 2007-05-14 09:52:00 | AAPL | Stock | 3.9193 | 3.9193 | 3.9129 | 3.9136 | 2621416.0 |
| 2007-05-14 09:53:00 | AAPL | Stock | 3.9136 | 3.9171 | 3.9132 | 3.9164 | 2037952.0 |
| 2007-05-14 09:54:00 | AAPL | Stock | 3.9164 | 3.9171 | 3.9139 | 3.9162 | 1868048.0 |
| 2007-05-14 09:55:00 | AAPL | Stock | 3.9168 | 3.9175 | 3.9111 | 3.9111 | 2687468.0 |
| 2007-05-14 09:56:00 | AAPL | Stock | 3.9118 | 3.9129 | 3.9071 | 3.9071 | 4527824.0 |
| 2007-05-14 09:57:00 | AAPL | Stock | 3.9076 | 3.9121 | 3.9071 | 3.91 | 2840600.0 |
| 2007-05-14 09:58:00 | AAPL | Stock | 3.9111 | 3.9129 | 3.91 | 3.9107 | 2452772.0 |
| 2007-05-14 09:59:00 | AAPL | Stock | 3.9107 | 3.9154 | 3.9089 | 3.9154 | 2171764.0 |
| 2007-05-14 10:00:00 | AAPL | Stock | 3.9154 | 3.9164 | 3.91 | 3.9121 | 2525180.0 |
| 2007-05-14 10:01:00 | AAPL | Stock | 3.9125 | 3.9146 | 3.9089 | 3.9132 | 2999332.0 |
| 2007-05-14 10:02:00 | AAPL | Stock | 3.9136 | 3.9168 | 3.9118 | 3.9146 | 3176656.0 |
| 2007-05-14 10:03:00 | AAPL | Stock | 3.9146 | 3.9196 | 3.9132 | 3.9168 | 3056760.0 |
| 2007-05-14 10:04:00 | AAPL | Stock | 3.9168 | 3.9182 | 3.9146 | 3.9154 | 2322152.0 |
| 2007-05-14 10:05:00 | AAPL | Stock | 3.9154 | 3.9211 | 3.9146 | 3.9196 | 2344636.0 |
| 2007-05-14 10:06:00 | AAPL | Stock | 3.9196 | 3.9229 | 3.9189 | 3.9211 | 3396568.0 |
| 2007-05-14 10:07:00 | AAPL | Stock | 3.9218 | 3.9218 | 3.9182 | 3.9189 | 1836380.0 |
| 2007-05-14 10:08:00 | AAPL | Stock | 3.9189 | 3.9189 | 3.915 | 3.9157 | 1957424.0 |
| 2007-05-14 10:09:00 | AAPL | Stock | 3.9164 | 3.9186 | 3.9164 | 3.9179 | 1199100.0 |
| 2007-05-14 10:10:00 | AAPL | Stock | 3.9179 | 3.9196 | 3.9171 | 3.9175 | 1217356.0 |
| 2007-05-14 10:11:00 | AAPL | Stock | 3.9175 | 3.9204 | 3.9175 | 3.92 | 1121456.0 |
| 2007-05-14 10:12:00 | AAPL | Stock | 3.9193 | 3.9196 | 3.9125 | 3.9132 | 2367540.0 |
| 2007-05-14 10:13:00 | AAPL | Stock | 3.9132 | 3.9139 | 3.9089 | 3.9107 | 3728452.0 |
| 2007-05-14 10:14:00 | AAPL | Stock | 3.9104 | 3.9114 | 3.8986 | 3.9025 | 6156192.0 |
| 2007-05-14 10:15:00 | AAPL | Stock | 3.9018 | 3.9071 | 3.9004 | 3.9064 | 3663212.0 |
| 2007-05-14 10:16:00 | AAPL | Stock | 3.9068 | 3.9111 | 3.9054 | 3.9107 | 3386348.0 |
| 2007-05-14 10:17:00 | AAPL | Stock | 3.9111 | 3.9111 | 3.9079 | 3.9082 | 1760612.0 |
| 2007-05-14 10:18:00 | AAPL | Stock | 3.9079 | 3.91 | 3.9061 | 3.9078 | 1776936.0 |
| 2007-05-14 10:19:00 | AAPL | Stock | 3.9079 | 3.9086 | 3.9061 | 3.9068 | 2048172.0 |
> showing 50 of 885,015 rows — these rows as CSV