PREVIEW / stock_5min / 2010-02-09
file: by_date/stock_5min/2010/2010-02-09.parquet size: 4.7 MB rows: 324,426 symbols: 3,434
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-09 04:15:00 | AAPL | Stock | 6.9361 | 6.9682 | 6.9361 | 6.9682 | 9100.0 |
| 2010-02-09 04:45:00 | AAPL | Stock | 6.9961 | 6.9961 | 6.9961 | 6.9961 | 2800.0 |
| 2010-02-09 05:40:00 | AAPL | Stock | 6.9657 | 6.9657 | 6.9657 | 6.9657 | 14000.0 |
| 2010-02-09 06:25:00 | AAPL | Stock | 6.9793 | 6.9793 | 6.9793 | 6.9793 | 3640.0 |
| 2010-02-09 07:05:00 | AAPL | Stock | 6.9611 | 6.9611 | 6.9607 | 6.9607 | 5600.0 |
| 2010-02-09 07:10:00 | AAPL | Stock | 6.9679 | 6.9846 | 6.9679 | 6.9786 | 323008.0 |
| 2010-02-09 07:15:00 | AAPL | Stock | 6.9921 | 6.9921 | 6.9821 | 6.99 | 107212.0 |
| 2010-02-09 07:20:00 | AAPL | Stock | 6.9911 | 6.9911 | 6.99 | 6.99 | 25396.0 |
| 2010-02-09 07:25:00 | AAPL | Stock | 6.9911 | 6.9921 | 6.9911 | 6.9921 | 8400.0 |
| 2010-02-09 07:30:00 | AAPL | Stock | 6.9893 | 6.9893 | 6.9893 | 6.9893 | 28000.0 |
| 2010-02-09 07:35:00 | AAPL | Stock | 6.975 | 6.9825 | 6.975 | 6.9825 | 44800.0 |
| 2010-02-09 07:40:00 | AAPL | Stock | 6.9882 | 6.9925 | 6.9807 | 6.9807 | 67200.0 |
| 2010-02-09 07:45:00 | AAPL | Stock | 6.9889 | 6.9893 | 6.9861 | 6.9864 | 33600.0 |
| 2010-02-09 07:50:00 | AAPL | Stock | 6.9893 | 6.9893 | 6.9857 | 6.9861 | 71400.0 |
| 2010-02-09 08:00:00 | AAPL | Stock | 6.9821 | 7.0 | 6.9764 | 6.9954 | 680400.0 |
| 2010-02-09 08:05:00 | AAPL | Stock | 6.9857 | 7.0 | 6.9857 | 6.9964 | 342524.0 |
| 2010-02-09 08:10:00 | AAPL | Stock | 6.9946 | 7.0025 | 6.9946 | 7.0 | 385728.0 |
| 2010-02-09 08:15:00 | AAPL | Stock | 7.0004 | 7.0004 | 6.9964 | 6.9964 | 54600.0 |
| 2010-02-09 08:20:00 | AAPL | Stock | 6.9946 | 7.0018 | 6.9946 | 7.0 | 580440.0 |
| 2010-02-09 08:25:00 | AAPL | Stock | 7.0011 | 7.0179 | 7.0007 | 7.0179 | 517160.0 |
| 2010-02-09 08:30:00 | AAPL | Stock | 7.0143 | 7.0254 | 7.0143 | 7.0214 | 358932.0 |
| 2010-02-09 08:35:00 | AAPL | Stock | 7.0229 | 7.0243 | 7.0179 | 7.0179 | 176820.0 |
| 2010-02-09 08:40:00 | AAPL | Stock | 7.0196 | 7.0211 | 7.0121 | 7.0211 | 324436.0 |
| 2010-02-09 08:45:00 | AAPL | Stock | 7.0207 | 7.0207 | 7.0143 | 7.0179 | 288708.0 |
| 2010-02-09 08:50:00 | AAPL | Stock | 7.0193 | 7.0275 | 7.0177 | 7.0249 | 577108.0 |
| 2010-02-09 08:55:00 | AAPL | Stock | 7.0268 | 7.0321 | 7.0239 | 7.0286 | 461188.0 |
| 2010-02-09 09:00:00 | AAPL | Stock | 7.0293 | 7.0296 | 7.0243 | 7.0257 | 207200.0 |
| 2010-02-09 09:05:00 | AAPL | Stock | 7.0257 | 7.0268 | 7.0161 | 7.0196 | 461888.0 |
| 2010-02-09 09:10:00 | AAPL | Stock | 7.0182 | 7.0182 | 7.0143 | 7.0146 | 212800.0 |
| 2010-02-09 09:15:00 | AAPL | Stock | 7.0161 | 7.0175 | 7.0107 | 7.0139 | 291032.0 |
| 2010-02-09 09:20:00 | AAPL | Stock | 7.0132 | 7.0132 | 7.0089 | 7.0129 | 165284.0 |
| 2010-02-09 09:25:00 | AAPL | Stock | 7.0129 | 7.0143 | 6.9986 | 7.0143 | 874832.0 |
| 2010-02-09 09:30:00 | AAPL | Stock | 7.0107 | 7.035 | 7.0 | 7.0154 | 17340960.0 |
| 2010-02-09 09:35:00 | AAPL | Stock | 7.0154 | 7.035 | 7.0068 | 7.0129 | 13422276.0 |
| 2010-02-09 09:40:00 | AAPL | Stock | 7.0121 | 7.0196 | 6.9921 | 7.0107 | 12072900.0 |
| 2010-02-09 09:45:00 | AAPL | Stock | 7.0096 | 7.0143 | 6.9875 | 7.0018 | 9616152.0 |
| 2010-02-09 09:50:00 | AAPL | Stock | 7.0011 | 7.0164 | 6.9936 | 7.0154 | 10816036.0 |
| 2010-02-09 09:55:00 | AAPL | Stock | 7.0154 | 7.0175 | 7.0 | 7.0096 | 7209608.0 |
| 2010-02-09 10:00:00 | AAPL | Stock | 7.0096 | 7.0161 | 6.9932 | 7.0075 | 9730980.0 |
| 2010-02-09 10:05:00 | AAPL | Stock | 7.0086 | 7.0214 | 7.0021 | 7.0154 | 7071148.0 |
| 2010-02-09 10:10:00 | AAPL | Stock | 7.0139 | 7.0261 | 7.0127 | 7.019 | 5880616.0 |
| 2010-02-09 10:15:00 | AAPL | Stock | 7.0193 | 7.0389 | 7.0189 | 7.0332 | 9783424.0 |
| 2010-02-09 10:20:00 | AAPL | Stock | 7.0332 | 7.0443 | 7.0246 | 7.0416 | 8473780.0 |
| 2010-02-09 10:25:00 | AAPL | Stock | 7.0414 | 7.0429 | 7.0321 | 7.0339 | 7367752.0 |
| 2010-02-09 10:30:00 | AAPL | Stock | 7.0339 | 7.0429 | 7.0286 | 7.035 | 9194248.0 |
| 2010-02-09 10:35:00 | AAPL | Stock | 7.0342 | 7.0386 | 7.025 | 7.0264 | 5259688.0 |
| 2010-02-09 10:40:00 | AAPL | Stock | 7.0255 | 7.0311 | 7.0129 | 7.0179 | 7267540.0 |
| 2010-02-09 10:45:00 | AAPL | Stock | 7.0164 | 7.0243 | 7.0079 | 7.0189 | 5652220.0 |
| 2010-02-09 10:50:00 | AAPL | Stock | 7.0193 | 7.0239 | 7.0118 | 7.0236 | 3728396.0 |
| 2010-02-09 10:55:00 | AAPL | Stock | 7.0239 | 7.0268 | 6.9964 | 7.0011 | 8600704.0 |
> showing 50 of 324,426 rows — these rows as CSV