PREVIEW / stock_5min / 2009-10-08
file: by_date/stock_5min/2009/2009-10-08.parquet size: 4.7 MB rows: 322,113 symbols: 3,386
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-10-08 06:15:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8393 | 6.8393 | 2800.0 |
| 2009-10-08 06:55:00 | AAPL | Stock | 6.8446 | 6.8446 | 6.8446 | 6.8446 | 5600.0 |
| 2009-10-08 07:00:00 | AAPL | Stock | 6.8446 | 6.85 | 6.8446 | 6.85 | 16800.0 |
| 2009-10-08 07:05:00 | AAPL | Stock | 6.8446 | 6.8446 | 6.8393 | 6.8393 | 11200.0 |
| 2009-10-08 07:10:00 | AAPL | Stock | 6.8411 | 6.8411 | 6.8411 | 6.8411 | 2800.0 |
| 2009-10-08 07:15:00 | AAPL | Stock | 6.8407 | 6.8425 | 6.8393 | 6.8393 | 11200.0 |
| 2009-10-08 07:20:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8393 | 6.8393 | 12516.0 |
| 2009-10-08 07:25:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8375 | 6.8375 | 11200.0 |
| 2009-10-08 07:30:00 | AAPL | Stock | 6.8339 | 6.8393 | 6.8221 | 6.8393 | 51100.0 |
| 2009-10-08 07:35:00 | AAPL | Stock | 6.8382 | 6.8389 | 6.8382 | 6.8389 | 14000.0 |
| 2009-10-08 07:45:00 | AAPL | Stock | 6.8375 | 6.8375 | 6.8343 | 6.8343 | 12600.0 |
| 2009-10-08 07:50:00 | AAPL | Stock | 6.8343 | 6.8343 | 6.8339 | 6.8339 | 5600.0 |
| 2009-10-08 07:55:00 | AAPL | Stock | 6.8286 | 6.8304 | 6.8286 | 6.8304 | 22260.0 |
| 2009-10-08 08:00:00 | AAPL | Stock | 6.8304 | 6.835 | 6.8221 | 6.8225 | 502124.0 |
| 2009-10-08 08:05:00 | AAPL | Stock | 6.8221 | 6.8286 | 6.8221 | 6.8282 | 177156.0 |
| 2009-10-08 08:10:00 | AAPL | Stock | 6.8286 | 6.8321 | 6.8232 | 6.8279 | 325276.0 |
| 2009-10-08 08:15:00 | AAPL | Stock | 6.8286 | 6.8289 | 6.825 | 6.8268 | 105000.0 |
| 2009-10-08 08:20:00 | AAPL | Stock | 6.8257 | 6.8311 | 6.8257 | 6.8311 | 342356.0 |
| 2009-10-08 08:25:00 | AAPL | Stock | 6.8307 | 6.8339 | 6.8307 | 6.8339 | 101444.0 |
| 2009-10-08 08:30:00 | AAPL | Stock | 6.8339 | 6.8375 | 6.8307 | 6.8307 | 436548.0 |
| 2009-10-08 08:35:00 | AAPL | Stock | 6.8321 | 6.8364 | 6.8286 | 6.8364 | 241668.0 |
| 2009-10-08 08:40:00 | AAPL | Stock | 6.8361 | 6.8361 | 6.8186 | 6.8246 | 1290800.0 |
| 2009-10-08 08:45:00 | AAPL | Stock | 6.8261 | 6.8264 | 6.8125 | 6.8129 | 358092.0 |
| 2009-10-08 08:50:00 | AAPL | Stock | 6.8182 | 6.8339 | 6.8182 | 6.8254 | 268128.0 |
| 2009-10-08 08:55:00 | AAPL | Stock | 6.8246 | 6.8254 | 6.8171 | 6.8229 | 353920.0 |
| 2009-10-08 09:00:00 | AAPL | Stock | 6.8218 | 6.8218 | 6.8168 | 6.8204 | 339668.0 |
| 2009-10-08 09:05:00 | AAPL | Stock | 6.8175 | 6.8225 | 6.8175 | 6.8214 | 233800.0 |
| 2009-10-08 09:10:00 | AAPL | Stock | 6.8196 | 6.825 | 6.8182 | 6.8246 | 391468.0 |
| 2009-10-08 09:15:00 | AAPL | Stock | 6.8232 | 6.825 | 6.8107 | 6.8107 | 330848.0 |
| 2009-10-08 09:20:00 | AAPL | Stock | 6.8086 | 6.8186 | 6.8036 | 6.8039 | 531916.0 |
| 2009-10-08 09:25:00 | AAPL | Stock | 6.8054 | 6.8246 | 6.8 | 6.8129 | 1811796.0 |
| 2009-10-08 09:30:00 | AAPL | Stock | 6.8129 | 6.8189 | 6.7893 | 6.8132 | 24139920.0 |
| 2009-10-08 09:35:00 | AAPL | Stock | 6.8125 | 6.8314 | 6.8043 | 6.8125 | 16581516.0 |
| 2009-10-08 09:40:00 | AAPL | Stock | 6.8116 | 6.8375 | 6.8114 | 6.8214 | 11089988.0 |
| 2009-10-08 09:45:00 | AAPL | Stock | 6.8225 | 6.8243 | 6.8068 | 6.8161 | 7804356.0 |
| 2009-10-08 09:50:00 | AAPL | Stock | 6.8145 | 6.8146 | 6.8021 | 6.8111 | 8855112.0 |
| 2009-10-08 09:55:00 | AAPL | Stock | 6.8104 | 6.8141 | 6.8018 | 6.8071 | 6524364.0 |
| 2009-10-08 10:00:00 | AAPL | Stock | 6.8068 | 6.8143 | 6.7939 | 6.8136 | 9792664.0 |
| 2009-10-08 10:05:00 | AAPL | Stock | 6.8136 | 6.8143 | 6.7893 | 6.7929 | 9847908.0 |
| 2009-10-08 10:10:00 | AAPL | Stock | 6.7939 | 6.8018 | 6.7864 | 6.8004 | 6333208.0 |
| 2009-10-08 10:15:00 | AAPL | Stock | 6.8004 | 6.8075 | 6.7911 | 6.7936 | 4837140.0 |
| 2009-10-08 10:20:00 | AAPL | Stock | 6.7939 | 6.8189 | 6.7893 | 6.8189 | 6610828.0 |
| 2009-10-08 10:25:00 | AAPL | Stock | 6.8189 | 6.8189 | 6.8057 | 6.8093 | 3684940.0 |
| 2009-10-08 10:30:00 | AAPL | Stock | 6.8079 | 6.8125 | 6.8025 | 6.8025 | 3560872.0 |
| 2009-10-08 10:35:00 | AAPL | Stock | 6.8032 | 6.8143 | 6.8025 | 6.8089 | 3606792.0 |
| 2009-10-08 10:40:00 | AAPL | Stock | 6.8082 | 6.8164 | 6.8068 | 6.8146 | 4064116.0 |
| 2009-10-08 10:45:00 | AAPL | Stock | 6.8129 | 6.8204 | 6.8089 | 6.811 | 4948412.0 |
| 2009-10-08 10:50:00 | AAPL | Stock | 6.81 | 6.8132 | 6.8071 | 6.8121 | 2252572.0 |
| 2009-10-08 10:55:00 | AAPL | Stock | 6.8121 | 6.8168 | 6.8118 | 6.8132 | 2613856.0 |
| 2009-10-08 11:00:00 | AAPL | Stock | 6.8129 | 6.815 | 6.8075 | 6.8079 | 3474828.0 |
> showing 50 of 322,113 rows — these rows as CSV