PREVIEW / stock_5min / 2009-10-12
file: by_date/stock_5min/2009/2009-10-12.parquet size: 4.5 MB rows: 310,746 symbols: 3,357
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-12 06:00:00 | AAPL | Stock | 6.8529 | 6.8529 | 6.8529 | 6.8529 | 2800.0 |
| 2009-10-12 06:50:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8214 | 6.8214 | 26656.0 |
| 2009-10-12 07:00:00 | AAPL | Stock | 6.8571 | 6.8579 | 6.8536 | 6.8536 | 50400.0 |
| 2009-10-12 07:05:00 | AAPL | Stock | 6.8554 | 6.8554 | 6.8554 | 6.8554 | 2800.0 |
| 2009-10-12 07:10:00 | AAPL | Stock | 6.8482 | 6.8482 | 6.8482 | 6.8482 | 5656.0 |
| 2009-10-12 07:20:00 | AAPL | Stock | 6.8464 | 6.8554 | 6.8464 | 6.8554 | 5600.0 |
| 2009-10-12 07:30:00 | AAPL | Stock | 6.8393 | 6.8411 | 6.8393 | 6.8411 | 13664.0 |
| 2009-10-12 07:50:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8393 | 6.8393 | 4900.0 |
| 2009-10-12 07:55:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8393 | 6.8393 | 10332.0 |
| 2009-10-12 08:00:00 | AAPL | Stock | 6.8393 | 6.8482 | 6.8393 | 6.8411 | 182980.0 |
| 2009-10-12 08:05:00 | AAPL | Stock | 6.8407 | 6.8479 | 6.8407 | 6.8457 | 15400.0 |
| 2009-10-12 08:10:00 | AAPL | Stock | 6.845 | 6.845 | 6.8329 | 6.8329 | 101752.0 |
| 2009-10-12 08:15:00 | AAPL | Stock | 6.835 | 6.8393 | 6.8054 | 6.825 | 310072.0 |
| 2009-10-12 08:20:00 | AAPL | Stock | 6.8246 | 6.8314 | 6.8246 | 6.8279 | 23800.0 |
| 2009-10-12 08:25:00 | AAPL | Stock | 6.8264 | 6.8314 | 6.8264 | 6.8286 | 73276.0 |
| 2009-10-12 08:30:00 | AAPL | Stock | 6.8286 | 6.8336 | 6.8246 | 6.8321 | 106820.0 |
| 2009-10-12 08:35:00 | AAPL | Stock | 6.8336 | 6.8336 | 6.8314 | 6.8314 | 25200.0 |
| 2009-10-12 08:40:00 | AAPL | Stock | 6.8289 | 6.8314 | 6.8286 | 6.8304 | 26600.0 |
| 2009-10-12 08:45:00 | AAPL | Stock | 6.8325 | 6.835 | 6.8325 | 6.835 | 35672.0 |
| 2009-10-12 08:50:00 | AAPL | Stock | 6.8332 | 6.8339 | 6.8311 | 6.8339 | 60620.0 |
| 2009-10-12 08:55:00 | AAPL | Stock | 6.8329 | 6.8429 | 6.8329 | 6.8386 | 174552.0 |
| 2009-10-12 09:00:00 | AAPL | Stock | 6.8407 | 6.8461 | 6.8375 | 6.8446 | 559524.0 |
| 2009-10-12 09:05:00 | AAPL | Stock | 6.8439 | 6.8464 | 6.8386 | 6.8386 | 309820.0 |
| 2009-10-12 09:10:00 | AAPL | Stock | 6.8382 | 6.8429 | 6.8375 | 6.8393 | 452452.0 |
| 2009-10-12 09:15:00 | AAPL | Stock | 6.8425 | 6.8429 | 6.8379 | 6.8407 | 42000.0 |
| 2009-10-12 09:20:00 | AAPL | Stock | 6.8393 | 6.8393 | 6.8321 | 6.8357 | 321076.0 |
| 2009-10-12 09:25:00 | AAPL | Stock | 6.8382 | 6.8393 | 6.8189 | 6.8204 | 282380.0 |
| 2009-10-12 09:30:00 | AAPL | Stock | 6.8243 | 6.8396 | 6.8143 | 6.8214 | 11304692.0 |
| 2009-10-12 09:35:00 | AAPL | Stock | 6.8214 | 6.8314 | 6.7982 | 6.8196 | 12830328.0 |
| 2009-10-12 09:40:00 | AAPL | Stock | 6.819 | 6.8214 | 6.805 | 6.8193 | 5179972.0 |
| 2009-10-12 09:45:00 | AAPL | Stock | 6.8193 | 6.8236 | 6.8068 | 6.8071 | 7910532.0 |
| 2009-10-12 09:50:00 | AAPL | Stock | 6.8068 | 6.8093 | 6.8 | 6.8093 | 7178920.0 |
| 2009-10-12 09:55:00 | AAPL | Stock | 6.8093 | 6.825 | 6.8082 | 6.8239 | 7076524.0 |
| 2009-10-12 10:00:00 | AAPL | Stock | 6.8246 | 6.8282 | 6.8189 | 6.8261 | 5856928.0 |
| 2009-10-12 10:05:00 | AAPL | Stock | 6.825 | 6.825 | 6.8196 | 6.8225 | 3037888.0 |
| 2009-10-12 10:10:00 | AAPL | Stock | 6.8218 | 6.8236 | 6.8107 | 6.8164 | 6527276.0 |
| 2009-10-12 10:15:00 | AAPL | Stock | 6.8154 | 6.8225 | 6.81 | 6.8107 | 2999920.0 |
| 2009-10-12 10:20:00 | AAPL | Stock | 6.8118 | 6.8125 | 6.8043 | 6.8061 | 3525284.0 |
| 2009-10-12 10:25:00 | AAPL | Stock | 6.805 | 6.8161 | 6.805 | 6.8118 | 2412536.0 |
| 2009-10-12 10:30:00 | AAPL | Stock | 6.8116 | 6.8175 | 6.8112 | 6.816 | 1914080.0 |
| 2009-10-12 10:35:00 | AAPL | Stock | 6.8161 | 6.8171 | 6.8036 | 6.8061 | 3319316.0 |
| 2009-10-12 10:40:00 | AAPL | Stock | 6.8057 | 6.8121 | 6.8054 | 6.8064 | 2010148.0 |
| 2009-10-12 10:45:00 | AAPL | Stock | 6.8064 | 6.8082 | 6.8036 | 6.8057 | 3138828.0 |
| 2009-10-12 10:50:00 | AAPL | Stock | 6.8061 | 6.8132 | 6.8054 | 6.8116 | 2609124.0 |
| 2009-10-12 10:55:00 | AAPL | Stock | 6.8118 | 6.8211 | 6.8114 | 6.8186 | 3202724.0 |
| 2009-10-12 11:00:00 | AAPL | Stock | 6.8186 | 6.8189 | 6.8118 | 6.8168 | 2431212.0 |
| 2009-10-12 11:05:00 | AAPL | Stock | 6.8168 | 6.8214 | 6.8143 | 6.8211 | 2390780.0 |
| 2009-10-12 11:10:00 | AAPL | Stock | 6.8211 | 6.8246 | 6.8204 | 6.8232 | 2910936.0 |
| 2009-10-12 11:15:00 | AAPL | Stock | 6.8236 | 6.8282 | 6.8232 | 6.8271 | 2841804.0 |
| 2009-10-12 11:20:00 | AAPL | Stock | 6.8268 | 6.8304 | 6.8261 | 6.8286 | 2155664.0 |
> showing 50 of 310,746 rows — these rows as CSV