PREVIEW / stock_5min / 2009-07-23
file: by_date/stock_5min/2009/2009-07-23.parquet size: 4.9 MB rows: 333,841 symbols: 3,359
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-07-23 04:10:00 | AAPL | Stock | 5.6207 | 5.6207 | 5.6207 | 5.6207 | 8400.0 |
| 2009-07-23 07:05:00 | AAPL | Stock | 5.6071 | 5.6071 | 5.6071 | 5.6071 | 26600.0 |
| 2009-07-23 07:30:00 | AAPL | Stock | 5.6068 | 5.6071 | 5.6068 | 5.6071 | 15400.0 |
| 2009-07-23 07:45:00 | AAPL | Stock | 5.615 | 5.615 | 5.615 | 5.615 | 2800.0 |
| 2009-07-23 07:50:00 | AAPL | Stock | 5.6071 | 5.6143 | 5.6071 | 5.6071 | 88200.0 |
| 2009-07-23 07:55:00 | AAPL | Stock | 5.6143 | 5.6161 | 5.6143 | 5.6161 | 18200.0 |
| 2009-07-23 08:00:00 | AAPL | Stock | 5.6071 | 5.6125 | 5.6054 | 5.6054 | 194656.0 |
| 2009-07-23 08:05:00 | AAPL | Stock | 5.6054 | 5.6054 | 5.5982 | 5.6054 | 128436.0 |
| 2009-07-23 08:10:00 | AAPL | Stock | 5.6071 | 5.6125 | 5.6054 | 5.6107 | 33292.0 |
| 2009-07-23 08:15:00 | AAPL | Stock | 5.6071 | 5.6107 | 5.5982 | 5.5982 | 175000.0 |
| 2009-07-23 08:20:00 | AAPL | Stock | 5.5982 | 5.6018 | 5.5982 | 5.6 | 81200.0 |
| 2009-07-23 08:25:00 | AAPL | Stock | 5.5989 | 5.6029 | 5.595 | 5.6 | 203308.0 |
| 2009-07-23 08:30:00 | AAPL | Stock | 5.6054 | 5.6054 | 5.6 | 5.6 | 98420.0 |
| 2009-07-23 08:35:00 | AAPL | Stock | 5.5968 | 5.6107 | 5.5968 | 5.6107 | 93800.0 |
| 2009-07-23 08:40:00 | AAPL | Stock | 5.6104 | 5.6175 | 5.6096 | 5.6096 | 159124.0 |
| 2009-07-23 08:45:00 | AAPL | Stock | 5.6125 | 5.6154 | 5.61 | 5.615 | 71680.0 |
| 2009-07-23 08:50:00 | AAPL | Stock | 5.6139 | 5.6139 | 5.6 | 5.6 | 103600.0 |
| 2009-07-23 08:55:00 | AAPL | Stock | 5.6018 | 5.6018 | 5.5893 | 5.5929 | 194964.0 |
| 2009-07-23 09:00:00 | AAPL | Stock | 5.5929 | 5.5968 | 5.5857 | 5.5946 | 115556.0 |
| 2009-07-23 09:05:00 | AAPL | Stock | 5.5911 | 5.5911 | 5.5804 | 5.5821 | 217168.0 |
| 2009-07-23 09:10:00 | AAPL | Stock | 5.5836 | 5.5839 | 5.5771 | 5.5811 | 199164.0 |
| 2009-07-23 09:15:00 | AAPL | Stock | 5.5804 | 5.5821 | 5.5757 | 5.5821 | 213836.0 |
| 2009-07-23 09:20:00 | AAPL | Stock | 5.5821 | 5.5893 | 5.5804 | 5.5804 | 148932.0 |
| 2009-07-23 09:25:00 | AAPL | Stock | 5.5804 | 5.5964 | 5.5804 | 5.5921 | 347172.0 |
| 2009-07-23 09:30:00 | AAPL | Stock | 5.5939 | 5.5943 | 5.5557 | 5.5929 | 16995300.0 |
| 2009-07-23 09:35:00 | AAPL | Stock | 5.5929 | 5.5961 | 5.5668 | 5.5836 | 12705672.0 |
| 2009-07-23 09:40:00 | AAPL | Stock | 5.5828 | 5.5914 | 5.5646 | 5.5786 | 9980040.0 |
| 2009-07-23 09:45:00 | AAPL | Stock | 5.5775 | 5.6004 | 5.5754 | 5.5896 | 12034456.0 |
| 2009-07-23 09:50:00 | AAPL | Stock | 5.5882 | 5.5961 | 5.5825 | 5.5896 | 7071680.0 |
| 2009-07-23 09:55:00 | AAPL | Stock | 5.5893 | 5.6286 | 5.5893 | 5.6286 | 18441696.0 |
| 2009-07-23 10:00:00 | AAPL | Stock | 5.6286 | 5.6357 | 5.6154 | 5.6186 | 13009584.0 |
| 2009-07-23 10:05:00 | AAPL | Stock | 5.6184 | 5.64 | 5.6171 | 5.6389 | 9775836.0 |
| 2009-07-23 10:10:00 | AAPL | Stock | 5.6393 | 5.6418 | 5.6254 | 5.6275 | 9255680.0 |
| 2009-07-23 10:15:00 | AAPL | Stock | 5.6284 | 5.6389 | 5.6207 | 5.6286 | 7484344.0 |
| 2009-07-23 10:20:00 | AAPL | Stock | 5.6286 | 5.6339 | 5.6193 | 5.6196 | 6165964.0 |
| 2009-07-23 10:25:00 | AAPL | Stock | 5.62 | 5.6236 | 5.6121 | 5.6236 | 5904108.0 |
| 2009-07-23 10:30:00 | AAPL | Stock | 5.6236 | 5.6286 | 5.6139 | 5.6236 | 5956132.0 |
| 2009-07-23 10:35:00 | AAPL | Stock | 5.6232 | 5.6407 | 5.6189 | 5.6358 | 8238412.0 |
| 2009-07-23 10:40:00 | AAPL | Stock | 5.6357 | 5.6375 | 5.6257 | 5.6279 | 5478228.0 |
| 2009-07-23 10:45:00 | AAPL | Stock | 5.6279 | 5.6293 | 5.6189 | 5.6286 | 7866432.0 |
| 2009-07-23 10:50:00 | AAPL | Stock | 5.6282 | 5.6339 | 5.6179 | 5.6279 | 8147104.0 |
| 2009-07-23 10:55:00 | AAPL | Stock | 5.6275 | 5.6304 | 5.6171 | 5.6203 | 8025192.0 |
| 2009-07-23 11:00:00 | AAPL | Stock | 5.6207 | 5.6296 | 5.6093 | 5.6264 | 12646928.0 |
| 2009-07-23 11:05:00 | AAPL | Stock | 5.6261 | 5.6371 | 5.6257 | 5.6329 | 8057672.0 |
| 2009-07-23 11:10:00 | AAPL | Stock | 5.6329 | 5.6454 | 5.6321 | 5.64 | 10789436.0 |
| 2009-07-23 11:15:00 | AAPL | Stock | 5.6404 | 5.6482 | 5.6339 | 5.6357 | 7926380.0 |
| 2009-07-23 11:20:00 | AAPL | Stock | 5.635 | 5.64 | 5.6307 | 5.6359 | 4333728.0 |
| 2009-07-23 11:25:00 | AAPL | Stock | 5.6361 | 5.6464 | 5.6318 | 5.6464 | 5136264.0 |
| 2009-07-23 11:30:00 | AAPL | Stock | 5.6464 | 5.6475 | 5.6375 | 5.6407 | 4034856.0 |
| 2009-07-23 11:35:00 | AAPL | Stock | 5.6407 | 5.65 | 5.6388 | 5.6436 | 7492912.0 |
> showing 50 of 333,841 rows — these rows as CSV