PREVIEW / stock_5min / 2007-08-16
file: by_date/stock_5min/2007/2007-08-16.parquet size: 4.6 MB rows: 325,636 symbols: 3,145
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-08-16 09:30:00 | AAPL | Stock | 4.1789 | 4.2107 | 4.1393 | 4.1887 | 73658984.0 |
| 2007-08-16 09:35:00 | AAPL | Stock | 4.1911 | 4.2143 | 4.1714 | 4.1939 | 30971528.0 |
| 2007-08-16 09:40:00 | AAPL | Stock | 4.1939 | 4.2236 | 4.1821 | 4.2214 | 28664188.0 |
| 2007-08-16 09:45:00 | AAPL | Stock | 4.2221 | 4.2321 | 4.2007 | 4.21 | 23403828.0 |
| 2007-08-16 09:50:00 | AAPL | Stock | 4.2096 | 4.2154 | 4.1743 | 4.175 | 20676712.0 |
| 2007-08-16 09:55:00 | AAPL | Stock | 4.1746 | 4.1786 | 4.1375 | 4.1407 | 33418504.0 |
| 2007-08-16 10:00:00 | AAPL | Stock | 4.1406 | 4.1446 | 4.0621 | 4.085 | 51216256.0 |
| 2007-08-16 10:05:00 | AAPL | Stock | 4.085 | 4.1239 | 4.0821 | 4.1218 | 40825092.0 |
| 2007-08-16 10:10:00 | AAPL | Stock | 4.1205 | 4.1336 | 4.1036 | 4.1227 | 26049968.0 |
| 2007-08-16 10:15:00 | AAPL | Stock | 4.1196 | 4.1261 | 4.0754 | 4.0907 | 20977516.0 |
| 2007-08-16 10:20:00 | AAPL | Stock | 4.0914 | 4.0918 | 4.0036 | 4.0121 | 40062428.0 |
| 2007-08-16 10:25:00 | AAPL | Stock | 4.0111 | 4.0468 | 3.9864 | 4.0296 | 46541600.0 |
| 2007-08-16 10:30:00 | AAPL | Stock | 4.0286 | 4.0512 | 3.9982 | 4.0339 | 27058444.0 |
| 2007-08-16 10:35:00 | AAPL | Stock | 4.0339 | 4.0871 | 4.0321 | 4.0795 | 33520060.0 |
| 2007-08-16 10:40:00 | AAPL | Stock | 4.0804 | 4.1025 | 4.0589 | 4.1005 | 28298620.0 |
| 2007-08-16 10:45:00 | AAPL | Stock | 4.1007 | 4.1071 | 4.0771 | 4.0786 | 31520048.0 |
| 2007-08-16 10:50:00 | AAPL | Stock | 4.0779 | 4.1139 | 4.0746 | 4.1004 | 29074920.0 |
| 2007-08-16 10:55:00 | AAPL | Stock | 4.0997 | 4.1036 | 4.0725 | 4.0757 | 22503376.0 |
| 2007-08-16 11:00:00 | AAPL | Stock | 4.075 | 4.0961 | 4.0575 | 4.0936 | 21289688.0 |
| 2007-08-16 11:05:00 | AAPL | Stock | 4.095 | 4.1204 | 4.0939 | 4.1132 | 29496992.0 |
| 2007-08-16 11:10:00 | AAPL | Stock | 4.1131 | 4.1296 | 4.1014 | 4.1121 | 22729056.0 |
| 2007-08-16 11:15:00 | AAPL | Stock | 4.1142 | 4.1336 | 4.1118 | 4.1161 | 18238920.0 |
| 2007-08-16 11:20:00 | AAPL | Stock | 4.115 | 4.1161 | 4.0793 | 4.0836 | 2533580.0 |
| 2007-08-16 11:25:00 | AAPL | Stock | 4.0832 | 4.0986 | 4.08 | 4.085 | 18262580.0 |
| 2007-08-16 11:30:00 | AAPL | Stock | 4.0871 | 4.0957 | 4.0446 | 4.045 | 20692336.0 |
| 2007-08-16 11:35:00 | AAPL | Stock | 4.0446 | 4.0711 | 4.0411 | 4.0694 | 22854888.0 |
| 2007-08-16 11:40:00 | AAPL | Stock | 4.0695 | 4.0921 | 4.0586 | 4.0857 | 18240768.0 |
| 2007-08-16 11:45:00 | AAPL | Stock | 4.0843 | 4.0843 | 4.0464 | 4.0584 | 15573236.0 |
| 2007-08-16 11:50:00 | AAPL | Stock | 4.0585 | 4.075 | 4.0439 | 4.075 | 17085012.0 |
| 2007-08-16 11:55:00 | AAPL | Stock | 4.075 | 4.0925 | 4.0646 | 4.0664 | 17181360.0 |
| 2007-08-16 12:00:00 | AAPL | Stock | 4.065 | 4.0664 | 4.0279 | 4.0539 | 27214852.0 |
| 2007-08-16 12:05:00 | AAPL | Stock | 4.0521 | 4.0521 | 4.0211 | 4.0279 | 17423392.0 |
| 2007-08-16 12:10:00 | AAPL | Stock | 4.0279 | 4.055 | 4.0268 | 4.0511 | 18539164.0 |
| 2007-08-16 12:15:00 | AAPL | Stock | 4.0511 | 4.0618 | 4.0304 | 4.0486 | 13444284.0 |
| 2007-08-16 12:20:00 | AAPL | Stock | 4.0486 | 4.0543 | 4.0357 | 4.0404 | 9117836.0 |
| 2007-08-16 12:25:00 | AAPL | Stock | 4.0411 | 4.055 | 4.0339 | 4.0425 | 12204136.0 |
| 2007-08-16 12:30:00 | AAPL | Stock | 4.0425 | 4.0657 | 4.0411 | 4.0532 | 12750444.0 |
| 2007-08-16 12:35:00 | AAPL | Stock | 4.0522 | 4.0546 | 4.0289 | 4.0304 | 13724900.0 |
| 2007-08-16 12:40:00 | AAPL | Stock | 4.03 | 4.0354 | 4.0 | 4.0046 | 21686364.0 |
| 2007-08-16 12:45:00 | AAPL | Stock | 4.0046 | 4.0214 | 4.0 | 4.0189 | 23192204.0 |
| 2007-08-16 12:50:00 | AAPL | Stock | 4.0196 | 4.0229 | 4.0 | 4.0136 | 18403952.0 |
| 2007-08-16 12:55:00 | AAPL | Stock | 4.0143 | 4.0225 | 4.0 | 4.0068 | 16998072.0 |
| 2007-08-16 13:00:00 | AAPL | Stock | 4.0071 | 4.0179 | 3.9871 | 4.0129 | 18356268.0 |
| 2007-08-16 13:05:00 | AAPL | Stock | 4.0143 | 4.0389 | 4.0018 | 4.0239 | 19212480.0 |
| 2007-08-16 13:10:00 | AAPL | Stock | 4.025 | 4.0457 | 4.02 | 4.0379 | 18037656.0 |
| 2007-08-16 13:15:00 | AAPL | Stock | 4.0382 | 4.0754 | 4.0379 | 4.0689 | 19354524.0 |
| 2007-08-16 13:20:00 | AAPL | Stock | 4.0693 | 4.0718 | 4.0357 | 4.0439 | 14504420.0 |
| 2007-08-16 13:25:00 | AAPL | Stock | 4.0427 | 4.0586 | 4.0375 | 4.0545 | 11576992.0 |
| 2007-08-16 13:30:00 | AAPL | Stock | 4.055 | 4.0693 | 4.0476 | 4.0693 | 11202324.0 |
| 2007-08-16 13:35:00 | AAPL | Stock | 4.0689 | 4.1071 | 4.0682 | 4.0957 | 23641352.0 |
> showing 50 of 325,636 rows — these rows as CSV