PREVIEW / stock_5min / 2009-02-10
file: by_date/stock_5min/2009/2009-02-10.parquet size: 4.5 MB rows: 305,326 symbols: 3,317
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-02-10 04:20:00 | AAPL | Stock | 3.6307 | 3.6325 | 3.6307 | 3.6325 | 7000.0 |
| 2009-02-10 07:10:00 | AAPL | Stock | 3.6357 | 3.6357 | 3.6357 | 3.6357 | 5600.0 |
| 2009-02-10 07:15:00 | AAPL | Stock | 3.6357 | 3.6357 | 3.6357 | 3.6357 | 5600.0 |
| 2009-02-10 07:45:00 | AAPL | Stock | 3.6404 | 3.6404 | 3.6404 | 3.6404 | 2800.0 |
| 2009-02-10 08:05:00 | AAPL | Stock | 3.655 | 3.655 | 3.655 | 3.655 | 14000.0 |
| 2009-02-10 08:10:00 | AAPL | Stock | 3.6471 | 3.6496 | 3.6464 | 3.6496 | 71064.0 |
| 2009-02-10 08:15:00 | AAPL | Stock | 3.6471 | 3.6471 | 3.6454 | 3.6454 | 19320.0 |
| 2009-02-10 08:20:00 | AAPL | Stock | 3.6471 | 3.6471 | 3.6418 | 3.6418 | 36820.0 |
| 2009-02-10 08:25:00 | AAPL | Stock | 3.6325 | 3.6336 | 3.6307 | 3.6336 | 44520.0 |
| 2009-02-10 08:30:00 | AAPL | Stock | 3.6339 | 3.6429 | 3.6339 | 3.6429 | 100688.0 |
| 2009-02-10 08:35:00 | AAPL | Stock | 3.6421 | 3.6421 | 3.6386 | 3.6393 | 60760.0 |
| 2009-02-10 08:40:00 | AAPL | Stock | 3.6357 | 3.6425 | 3.6311 | 3.6311 | 148764.0 |
| 2009-02-10 08:45:00 | AAPL | Stock | 3.6343 | 3.6371 | 3.6304 | 3.6304 | 294028.0 |
| 2009-02-10 08:50:00 | AAPL | Stock | 3.6304 | 3.6304 | 3.625 | 3.625 | 270340.0 |
| 2009-02-10 08:55:00 | AAPL | Stock | 3.625 | 3.6254 | 3.6143 | 3.6143 | 120400.0 |
| 2009-02-10 09:00:00 | AAPL | Stock | 3.615 | 3.625 | 3.6129 | 3.625 | 232960.0 |
| 2009-02-10 09:05:00 | AAPL | Stock | 3.6246 | 3.625 | 3.6179 | 3.6221 | 106428.0 |
| 2009-02-10 09:10:00 | AAPL | Stock | 3.6243 | 3.6243 | 3.6196 | 3.6196 | 51100.0 |
| 2009-02-10 09:15:00 | AAPL | Stock | 3.6214 | 3.6214 | 3.6107 | 3.6179 | 63168.0 |
| 2009-02-10 09:20:00 | AAPL | Stock | 3.6193 | 3.6236 | 3.6168 | 3.6221 | 198800.0 |
| 2009-02-10 09:25:00 | AAPL | Stock | 3.6214 | 3.6214 | 3.6146 | 3.6146 | 377720.0 |
| 2009-02-10 09:30:00 | AAPL | Stock | 3.6143 | 3.6429 | 3.6 | 3.6214 | 18197564.0 |
| 2009-02-10 09:35:00 | AAPL | Stock | 3.6207 | 3.6429 | 3.6207 | 3.6339 | 14553028.0 |
| 2009-02-10 09:40:00 | AAPL | Stock | 3.6339 | 3.6382 | 3.6171 | 3.6311 | 11895744.0 |
| 2009-02-10 09:45:00 | AAPL | Stock | 3.6318 | 3.6586 | 3.6318 | 3.6436 | 18940180.0 |
| 2009-02-10 09:50:00 | AAPL | Stock | 3.6436 | 3.66 | 3.64 | 3.6529 | 15271256.0 |
| 2009-02-10 09:55:00 | AAPL | Stock | 3.6532 | 3.6568 | 3.6339 | 3.645 | 11098976.0 |
| 2009-02-10 10:00:00 | AAPL | Stock | 3.645 | 3.655 | 3.6429 | 3.6432 | 8772568.0 |
| 2009-02-10 10:05:00 | AAPL | Stock | 3.6432 | 3.6554 | 3.6429 | 3.6536 | 6915496.0 |
| 2009-02-10 10:10:00 | AAPL | Stock | 3.6532 | 3.655 | 3.625 | 3.6254 | 11320848.0 |
| 2009-02-10 10:15:00 | AAPL | Stock | 3.6254 | 3.6339 | 3.6229 | 3.6325 | 11666144.0 |
| 2009-02-10 10:20:00 | AAPL | Stock | 3.6325 | 3.6332 | 3.6107 | 3.6161 | 14202608.0 |
| 2009-02-10 10:25:00 | AAPL | Stock | 3.6164 | 3.6175 | 3.6011 | 3.6011 | 13568100.0 |
| 2009-02-10 10:30:00 | AAPL | Stock | 3.6014 | 3.6132 | 3.595 | 3.6104 | 8305136.0 |
| 2009-02-10 10:35:00 | AAPL | Stock | 3.6104 | 3.6157 | 3.6029 | 3.6093 | 9140208.0 |
| 2009-02-10 10:40:00 | AAPL | Stock | 3.6093 | 3.6132 | 3.5982 | 3.6 | 9425752.0 |
| 2009-02-10 10:45:00 | AAPL | Stock | 3.6004 | 3.6143 | 3.6 | 3.6107 | 6766760.0 |
| 2009-02-10 10:50:00 | AAPL | Stock | 3.6114 | 3.6161 | 3.6064 | 3.6096 | 8563212.0 |
| 2009-02-10 10:55:00 | AAPL | Stock | 3.6096 | 3.6125 | 3.6036 | 3.6107 | 7726964.0 |
| 2009-02-10 11:00:00 | AAPL | Stock | 3.6107 | 3.6221 | 3.6054 | 3.6079 | 14324156.0 |
| 2009-02-10 11:05:00 | AAPL | Stock | 3.6079 | 3.61 | 3.5739 | 3.5864 | 18547900.0 |
| 2009-02-10 11:10:00 | AAPL | Stock | 3.5868 | 3.5929 | 3.5775 | 3.5921 | 14731556.0 |
| 2009-02-10 11:15:00 | AAPL | Stock | 3.5921 | 3.5986 | 3.5886 | 3.5986 | 8427636.0 |
| 2009-02-10 11:20:00 | AAPL | Stock | 3.5979 | 3.6071 | 3.5907 | 3.5971 | 12817644.0 |
| 2009-02-10 11:25:00 | AAPL | Stock | 3.5982 | 3.5996 | 3.5886 | 3.5946 | 7193116.0 |
| 2009-02-10 11:30:00 | AAPL | Stock | 3.5946 | 3.5961 | 3.5611 | 3.5611 | 22691088.0 |
| 2009-02-10 11:35:00 | AAPL | Stock | 3.5611 | 3.5618 | 3.5332 | 3.5332 | 22088948.0 |
| 2009-02-10 11:40:00 | AAPL | Stock | 3.5332 | 3.5502 | 3.5271 | 3.5479 | 15935304.0 |
| 2009-02-10 11:45:00 | AAPL | Stock | 3.5482 | 3.5621 | 3.5471 | 3.5604 | 13520332.0 |
| 2009-02-10 11:50:00 | AAPL | Stock | 3.5604 | 3.565 | 3.5554 | 3.5618 | 5970944.0 |
> showing 50 of 305,326 rows — these rows as CSV