PREVIEW / stock_5min / 2007-10-09
file: by_date/stock_5min/2007/2007-10-09.parquet size: 4.2 MB rows: 306,651 symbols: 3,136
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-09 05:40:00 | AAPL | Stock | 6.0157 | 6.0157 | 6.0157 | 6.0157 | 11200.0 |
| 2007-10-09 05:45:00 | AAPL | Stock | 6.0157 | 6.0157 | 6.0157 | 6.0157 | 2800.0 |
| 2007-10-09 05:50:00 | AAPL | Stock | 6.0157 | 6.0157 | 6.0157 | 6.0157 | 8400.0 |
| 2007-10-09 06:00:00 | AAPL | Stock | 6.0371 | 6.0371 | 6.0371 | 6.0371 | 5124.0 |
| 2007-10-09 06:10:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0179 | 6.0179 | 28000.0 |
| 2007-10-09 06:20:00 | AAPL | Stock | 6.0268 | 6.0268 | 6.0268 | 6.0268 | 14000.0 |
| 2007-10-09 06:55:00 | AAPL | Stock | 6.0268 | 6.0339 | 6.0268 | 6.0307 | 84000.0 |
| 2007-10-09 07:00:00 | AAPL | Stock | 6.0346 | 6.0346 | 6.0346 | 6.0346 | 56000.0 |
| 2007-10-09 07:05:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 21840.0 |
| 2007-10-09 07:10:00 | AAPL | Stock | 6.0357 | 6.0493 | 6.0357 | 6.0493 | 151200.0 |
| 2007-10-09 07:15:00 | AAPL | Stock | 6.0493 | 6.0532 | 6.0493 | 6.0532 | 58800.0 |
| 2007-10-09 07:20:00 | AAPL | Stock | 6.0493 | 6.0493 | 6.0357 | 6.0493 | 194740.0 |
| 2007-10-09 07:25:00 | AAPL | Stock | 6.0368 | 6.0393 | 6.0357 | 6.0393 | 106400.0 |
| 2007-10-09 07:30:00 | AAPL | Stock | 6.0357 | 6.0446 | 6.0357 | 6.0357 | 44800.0 |
| 2007-10-09 07:35:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 30800.0 |
| 2007-10-09 07:40:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 33600.0 |
| 2007-10-09 07:45:00 | AAPL | Stock | 6.0357 | 6.0361 | 6.0357 | 6.0357 | 254800.0 |
| 2007-10-09 07:50:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 47600.0 |
| 2007-10-09 07:55:00 | AAPL | Stock | 6.0357 | 6.0393 | 6.0357 | 6.0393 | 96600.0 |
| 2007-10-09 08:00:00 | AAPL | Stock | 6.0429 | 6.0625 | 6.0357 | 6.0614 | 1774164.0 |
| 2007-10-09 08:05:00 | AAPL | Stock | 6.0607 | 6.0693 | 6.0571 | 6.0604 | 1446900.0 |
| 2007-10-09 08:10:00 | AAPL | Stock | 6.0604 | 6.0704 | 6.0589 | 6.0625 | 718620.0 |
| 2007-10-09 08:15:00 | AAPL | Stock | 6.0579 | 6.0625 | 6.0575 | 6.0607 | 401716.0 |
| 2007-10-09 08:20:00 | AAPL | Stock | 6.0607 | 6.0643 | 6.0571 | 6.0589 | 583296.0 |
| 2007-10-09 08:25:00 | AAPL | Stock | 6.0579 | 6.0625 | 6.0536 | 6.0604 | 1139852.0 |
| 2007-10-09 08:30:00 | AAPL | Stock | 6.0604 | 6.0668 | 6.0589 | 6.0639 | 465556.0 |
| 2007-10-09 08:35:00 | AAPL | Stock | 6.0643 | 6.0818 | 6.0607 | 6.0736 | 2022356.0 |
| 2007-10-09 08:40:00 | AAPL | Stock | 6.075 | 6.0839 | 6.0661 | 6.0711 | 2140796.0 |
| 2007-10-09 08:45:00 | AAPL | Stock | 6.0707 | 6.0761 | 6.0679 | 6.0714 | 1164492.0 |
| 2007-10-09 08:50:00 | AAPL | Stock | 6.0714 | 6.0743 | 6.0696 | 6.0704 | 343700.0 |
| 2007-10-09 08:55:00 | AAPL | Stock | 6.07 | 6.0821 | 6.07 | 6.0821 | 499884.0 |
| 2007-10-09 09:00:00 | AAPL | Stock | 6.0818 | 6.0925 | 6.0814 | 6.0911 | 1520176.0 |
| 2007-10-09 09:05:00 | AAPL | Stock | 6.0911 | 6.0982 | 6.09 | 6.0929 | 1846628.0 |
| 2007-10-09 09:10:00 | AAPL | Stock | 6.0921 | 6.1032 | 6.0921 | 6.1 | 2219952.0 |
| 2007-10-09 09:15:00 | AAPL | Stock | 6.1 | 6.1 | 6.0804 | 6.0911 | 6263796.0 |
| 2007-10-09 09:20:00 | AAPL | Stock | 6.09 | 6.09 | 5.9968 | 6.08 | 1307460.0 |
| 2007-10-09 09:25:00 | AAPL | Stock | 6.08 | 6.0875 | 6.0736 | 6.0754 | 2985360.0 |
| 2007-10-09 09:30:00 | AAPL | Stock | 6.0786 | 6.0986 | 6.0107 | 6.0214 | 71815548.0 |
| 2007-10-09 09:35:00 | AAPL | Stock | 6.0207 | 6.1111 | 6.0136 | 6.0539 | 40725776.0 |
| 2007-10-09 09:40:00 | AAPL | Stock | 6.0529 | 6.0832 | 6.0414 | 6.0679 | 24466960.0 |
| 2007-10-09 09:45:00 | AAPL | Stock | 6.0668 | 6.1089 | 6.0411 | 6.0457 | 22124536.0 |
| 2007-10-09 09:50:00 | AAPL | Stock | 6.0461 | 6.0504 | 6.0143 | 6.0232 | 30143232.0 |
| 2007-10-09 09:55:00 | AAPL | Stock | 6.0239 | 6.0486 | 6.0221 | 6.0329 | 19430852.0 |
| 2007-10-09 10:00:00 | AAPL | Stock | 6.0321 | 6.0332 | 5.9975 | 6.0093 | 28382508.0 |
| 2007-10-09 10:05:00 | AAPL | Stock | 6.0086 | 6.0175 | 5.9725 | 5.9746 | 33983208.0 |
| 2007-10-09 10:10:00 | AAPL | Stock | 5.975 | 5.9818 | 5.9529 | 5.9789 | 35714084.0 |
| 2007-10-09 10:15:00 | AAPL | Stock | 5.9793 | 6.0064 | 5.9786 | 5.9807 | 23821532.0 |
| 2007-10-09 10:20:00 | AAPL | Stock | 5.9789 | 5.9996 | 5.9739 | 5.9889 | 17257744.0 |
| 2007-10-09 10:25:00 | AAPL | Stock | 5.9879 | 6.0082 | 5.9829 | 5.9964 | 19187980.0 |
| 2007-10-09 10:30:00 | AAPL | Stock | 5.9964 | 5.9979 | 5.9646 | 5.9696 | 12657092.0 |
> showing 50 of 306,651 rows — these rows as CSV