PREVIEW / stock_5min / 2009-10-28
file: by_date/stock_5min/2009/2009-10-28.parquet size: 4.9 MB rows: 328,542 symbols: 3,409
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-28 04:15:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 2800.0 |
| 2009-10-28 04:25:00 | AAPL | Stock | 6.9957 | 6.9957 | 6.9957 | 6.9957 | 25284.0 |
| 2009-10-28 04:35:00 | AAPL | Stock | 7.0304 | 7.0304 | 7.0304 | 7.0304 | 4312.0 |
| 2009-10-28 04:55:00 | AAPL | Stock | 6.995 | 6.995 | 6.995 | 6.995 | 8400.0 |
| 2009-10-28 05:20:00 | AAPL | Stock | 6.9929 | 6.9929 | 6.9929 | 6.9929 | 2800.0 |
| 2009-10-28 05:25:00 | AAPL | Stock | 7.0229 | 7.0229 | 6.9929 | 6.9929 | 13300.0 |
| 2009-10-28 06:10:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 15400.0 |
| 2009-10-28 06:25:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 6720.0 |
| 2009-10-28 06:30:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9857 | 6.9857 | 2800.0 |
| 2009-10-28 06:35:00 | AAPL | Stock | 6.9996 | 7.0054 | 6.9996 | 7.0054 | 21140.0 |
| 2009-10-28 06:45:00 | AAPL | Stock | 7.0054 | 7.0054 | 7.0054 | 7.0054 | 2800.0 |
| 2009-10-28 06:50:00 | AAPL | Stock | 7.0054 | 7.0054 | 7.0054 | 7.0054 | 2800.0 |
| 2009-10-28 06:55:00 | AAPL | Stock | 7.0071 | 7.0071 | 6.9982 | 6.9982 | 8624.0 |
| 2009-10-28 07:00:00 | AAPL | Stock | 7.0211 | 7.0214 | 7.0211 | 7.0214 | 11200.0 |
| 2009-10-28 07:05:00 | AAPL | Stock | 7.0075 | 7.0075 | 6.9921 | 6.9932 | 40320.0 |
| 2009-10-28 07:15:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 8400.0 |
| 2009-10-28 07:20:00 | AAPL | Stock | 7.0 | 7.0071 | 7.0 | 7.0071 | 5600.0 |
| 2009-10-28 07:25:00 | AAPL | Stock | 6.995 | 6.995 | 6.995 | 6.995 | 2800.0 |
| 2009-10-28 07:35:00 | AAPL | Stock | 6.9936 | 7.0 | 6.9918 | 6.9921 | 39228.0 |
| 2009-10-28 07:40:00 | AAPL | Stock | 6.9939 | 6.9939 | 6.9929 | 6.9932 | 16800.0 |
| 2009-10-28 07:45:00 | AAPL | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 5600.0 |
| 2009-10-28 07:50:00 | AAPL | Stock | 7.0089 | 7.0132 | 7.0043 | 7.0132 | 24276.0 |
| 2009-10-28 07:55:00 | AAPL | Stock | 7.0143 | 7.0268 | 7.0143 | 7.0268 | 56112.0 |
| 2009-10-28 08:00:00 | AAPL | Stock | 7.0282 | 7.0432 | 7.02 | 7.0429 | 153132.0 |
| 2009-10-28 08:05:00 | AAPL | Stock | 7.0429 | 7.0429 | 7.0286 | 7.0304 | 74508.0 |
| 2009-10-28 08:10:00 | AAPL | Stock | 7.0304 | 7.0312 | 7.0286 | 7.0312 | 78904.0 |
| 2009-10-28 08:15:00 | AAPL | Stock | 7.0289 | 7.0314 | 7.0214 | 7.0214 | 149996.0 |
| 2009-10-28 08:20:00 | AAPL | Stock | 7.0214 | 7.0232 | 7.0182 | 7.0232 | 157304.0 |
| 2009-10-28 08:25:00 | AAPL | Stock | 7.0236 | 7.0321 | 7.0236 | 7.0257 | 15372.0 |
| 2009-10-28 08:30:00 | AAPL | Stock | 7.0286 | 7.0357 | 7.0232 | 7.0357 | 66220.0 |
| 2009-10-28 08:35:00 | AAPL | Stock | 7.0357 | 7.0711 | 7.0357 | 7.0593 | 90440.0 |
| 2009-10-28 08:40:00 | AAPL | Stock | 7.0593 | 7.0625 | 7.0411 | 7.0411 | 122388.0 |
| 2009-10-28 08:45:00 | AAPL | Stock | 7.0432 | 7.0443 | 7.0361 | 7.0443 | 69076.0 |
| 2009-10-28 08:50:00 | AAPL | Stock | 7.0504 | 7.0661 | 7.0504 | 7.0643 | 178892.0 |
| 2009-10-28 08:55:00 | AAPL | Stock | 7.0675 | 7.0757 | 7.0643 | 7.0643 | 176736.0 |
| 2009-10-28 09:00:00 | AAPL | Stock | 7.0646 | 7.0743 | 7.0643 | 7.0675 | 295456.0 |
| 2009-10-28 09:05:00 | AAPL | Stock | 7.0668 | 7.0893 | 7.0614 | 7.0714 | 844480.0 |
| 2009-10-28 09:10:00 | AAPL | Stock | 7.0689 | 7.0804 | 7.0675 | 7.0729 | 305648.0 |
| 2009-10-28 09:15:00 | AAPL | Stock | 7.0743 | 7.0875 | 7.0743 | 7.0789 | 172172.0 |
| 2009-10-28 09:20:00 | AAPL | Stock | 7.0864 | 7.0868 | 7.0786 | 7.0861 | 93800.0 |
| 2009-10-28 09:25:00 | AAPL | Stock | 7.0857 | 7.0893 | 7.0446 | 7.0493 | 1365084.0 |
| 2009-10-28 09:30:00 | AAPL | Stock | 7.0543 | 7.07 | 6.9829 | 7.0311 | 33574576.0 |
| 2009-10-28 09:35:00 | AAPL | Stock | 7.0311 | 7.0479 | 6.9771 | 6.9907 | 26391904.0 |
| 2009-10-28 09:40:00 | AAPL | Stock | 6.9907 | 7.0387 | 6.9857 | 7.0368 | 23680160.0 |
| 2009-10-28 09:45:00 | AAPL | Stock | 7.0357 | 7.0446 | 7.0207 | 7.0286 | 15363068.0 |
| 2009-10-28 09:50:00 | AAPL | Stock | 7.0304 | 7.0625 | 7.0268 | 7.0532 | 17435124.0 |
| 2009-10-28 09:55:00 | AAPL | Stock | 7.0536 | 7.0661 | 7.0311 | 7.0346 | 10235848.0 |
| 2009-10-28 10:00:00 | AAPL | Stock | 7.0332 | 7.0607 | 7.0071 | 7.0534 | 21440188.0 |
| 2009-10-28 10:05:00 | AAPL | Stock | 7.0539 | 7.0721 | 7.0436 | 7.0593 | 17463796.0 |
| 2009-10-28 10:10:00 | AAPL | Stock | 7.0579 | 7.0657 | 7.0254 | 7.0318 | 13475532.0 |
> showing 50 of 328,542 rows — these rows as CSV