PREVIEW / stock_5min / 2008-10-30
file: by_date/stock_5min/2008/2008-10-30.parquet size: 4.5 MB rows: 319,225 symbols: 3,338
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-30 04:40:00 | AAPL | Stock | 3.8214 | 3.8214 | 3.8214 | 3.8214 | 2800.0 |
| 2008-10-30 06:15:00 | AAPL | Stock | 3.8564 | 3.8571 | 3.8564 | 3.8571 | 14000.0 |
| 2008-10-30 06:20:00 | AAPL | Stock | 3.8571 | 3.8571 | 3.8571 | 3.8571 | 2800.0 |
| 2008-10-30 06:40:00 | AAPL | Stock | 3.8571 | 3.8571 | 3.8571 | 3.8571 | 2800.0 |
| 2008-10-30 06:55:00 | AAPL | Stock | 3.8571 | 3.8571 | 3.8571 | 3.8571 | 5600.0 |
| 2008-10-30 07:00:00 | AAPL | Stock | 3.8571 | 3.8571 | 3.8571 | 3.8571 | 5600.0 |
| 2008-10-30 07:05:00 | AAPL | Stock | 3.8289 | 3.875 | 3.8286 | 3.875 | 92792.0 |
| 2008-10-30 07:10:00 | AAPL | Stock | 3.8571 | 3.8571 | 3.8571 | 3.8571 | 10976.0 |
| 2008-10-30 07:15:00 | AAPL | Stock | 3.875 | 3.875 | 3.8571 | 3.8571 | 19600.0 |
| 2008-10-30 07:20:00 | AAPL | Stock | 3.8482 | 3.8571 | 3.8482 | 3.8571 | 23940.0 |
| 2008-10-30 07:25:00 | AAPL | Stock | 3.8482 | 3.8482 | 3.8482 | 3.8482 | 13300.0 |
| 2008-10-30 07:30:00 | AAPL | Stock | 3.8407 | 3.8407 | 3.8393 | 3.8393 | 56000.0 |
| 2008-10-30 07:35:00 | AAPL | Stock | 3.8393 | 3.8393 | 3.8393 | 3.8393 | 21000.0 |
| 2008-10-30 07:40:00 | AAPL | Stock | 3.8393 | 3.8393 | 3.8393 | 3.8393 | 34160.0 |
| 2008-10-30 07:45:00 | AAPL | Stock | 3.8393 | 3.85 | 3.8393 | 3.85 | 51660.0 |
| 2008-10-30 07:50:00 | AAPL | Stock | 3.8532 | 3.8571 | 3.8532 | 3.8571 | 24360.0 |
| 2008-10-30 07:55:00 | AAPL | Stock | 3.8536 | 3.8571 | 3.8518 | 3.8571 | 134400.0 |
| 2008-10-30 08:00:00 | AAPL | Stock | 3.8571 | 3.8714 | 3.8429 | 3.8571 | 1623272.0 |
| 2008-10-30 08:05:00 | AAPL | Stock | 3.8571 | 3.86 | 3.8489 | 3.8536 | 298088.0 |
| 2008-10-30 08:10:00 | AAPL | Stock | 3.8525 | 3.8525 | 3.8393 | 3.8414 | 301616.0 |
| 2008-10-30 08:15:00 | AAPL | Stock | 3.8379 | 3.8482 | 3.8371 | 3.8464 | 210000.0 |
| 2008-10-30 08:20:00 | AAPL | Stock | 3.8414 | 3.8464 | 3.8393 | 3.8393 | 81760.0 |
| 2008-10-30 08:25:00 | AAPL | Stock | 3.8393 | 3.8393 | 3.8321 | 3.8343 | 70420.0 |
| 2008-10-30 08:30:00 | AAPL | Stock | 3.8339 | 3.8729 | 3.8321 | 3.8607 | 1061116.0 |
| 2008-10-30 08:35:00 | AAPL | Stock | 3.8607 | 3.8607 | 3.8464 | 3.8464 | 290500.0 |
| 2008-10-30 08:40:00 | AAPL | Stock | 3.8464 | 3.8464 | 3.835 | 3.8379 | 722792.0 |
| 2008-10-30 08:45:00 | AAPL | Stock | 3.8368 | 3.8429 | 3.8318 | 3.84 | 485884.0 |
| 2008-10-30 08:50:00 | AAPL | Stock | 3.8407 | 3.8461 | 3.8407 | 3.8421 | 145600.0 |
| 2008-10-30 08:55:00 | AAPL | Stock | 3.8429 | 3.8496 | 3.8429 | 3.8496 | 166628.0 |
| 2008-10-30 09:00:00 | AAPL | Stock | 3.85 | 3.8571 | 3.85 | 3.8554 | 335524.0 |
| 2008-10-30 09:05:00 | AAPL | Stock | 3.8554 | 3.8739 | 3.8546 | 3.8661 | 711788.0 |
| 2008-10-30 09:10:00 | AAPL | Stock | 3.8654 | 3.8661 | 3.86 | 3.8643 | 430696.0 |
| 2008-10-30 09:15:00 | AAPL | Stock | 3.8646 | 3.8679 | 3.8571 | 3.8604 | 504728.0 |
| 2008-10-30 09:20:00 | AAPL | Stock | 3.8607 | 3.8621 | 3.8529 | 3.8529 | 406280.0 |
| 2008-10-30 09:25:00 | AAPL | Stock | 3.8496 | 3.8796 | 3.8496 | 3.8632 | 1841812.0 |
| 2008-10-30 09:30:00 | AAPL | Stock | 3.8664 | 3.8896 | 3.8539 | 3.8721 | 39300688.0 |
| 2008-10-30 09:35:00 | AAPL | Stock | 3.8718 | 3.8818 | 3.8432 | 3.8629 | 30075584.0 |
| 2008-10-30 09:40:00 | AAPL | Stock | 3.8614 | 3.8982 | 3.8511 | 3.8943 | 29093456.0 |
| 2008-10-30 09:45:00 | AAPL | Stock | 3.895 | 3.9357 | 3.8943 | 3.9286 | 40428276.0 |
| 2008-10-30 09:50:00 | AAPL | Stock | 3.9286 | 3.9289 | 3.8996 | 3.8996 | 34759088.0 |
| 2008-10-30 09:55:00 | AAPL | Stock | 3.8993 | 3.9311 | 3.8854 | 3.9093 | 31490732.0 |
| 2008-10-30 10:00:00 | AAPL | Stock | 3.91 | 3.9204 | 3.8882 | 3.9129 | 22823220.0 |
| 2008-10-30 10:05:00 | AAPL | Stock | 3.9129 | 3.9432 | 3.9036 | 3.9257 | 38372796.0 |
| 2008-10-30 10:10:00 | AAPL | Stock | 3.925 | 3.9421 | 3.9211 | 3.9302 | 26312832.0 |
| 2008-10-30 10:15:00 | AAPL | Stock | 3.9293 | 3.9321 | 3.9 | 3.9018 | 24681328.0 |
| 2008-10-30 10:20:00 | AAPL | Stock | 3.9018 | 3.9121 | 3.8907 | 3.9007 | 26522300.0 |
| 2008-10-30 10:25:00 | AAPL | Stock | 3.8996 | 3.9125 | 3.8857 | 3.8907 | 25041800.0 |
| 2008-10-30 10:30:00 | AAPL | Stock | 3.89 | 3.9075 | 3.8864 | 3.9 | 22828988.0 |
| 2008-10-30 10:35:00 | AAPL | Stock | 3.9 | 3.9086 | 3.8857 | 3.9018 | 23450168.0 |
| 2008-10-30 10:40:00 | AAPL | Stock | 3.9011 | 3.9096 | 3.89 | 3.9043 | 25105808.0 |
> showing 50 of 319,225 rows — these rows as CSV