PREVIEW / stock_5min / 2009-06-10
file: by_date/stock_5min/2009/2009-06-10.parquet size: 4.8 MB rows: 330,718 symbols: 3,349
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-06-10 04:15:00 | AAPL | Stock | 5.1304 | 5.1304 | 5.1304 | 5.1304 | 9100.0 |
| 2009-06-10 04:20:00 | AAPL | Stock | 5.1425 | 5.1425 | 5.1425 | 5.1425 | 2856.0 |
| 2009-06-10 05:10:00 | AAPL | Stock | 5.1318 | 5.1318 | 5.1318 | 5.1318 | 2800.0 |
| 2009-06-10 05:55:00 | AAPL | Stock | 5.1421 | 5.1421 | 5.1421 | 5.1421 | 2800.0 |
| 2009-06-10 06:40:00 | AAPL | Stock | 5.1425 | 5.1425 | 5.1425 | 5.1425 | 2800.0 |
| 2009-06-10 07:00:00 | AAPL | Stock | 5.1425 | 5.1425 | 5.1389 | 5.1425 | 34580.0 |
| 2009-06-10 07:05:00 | AAPL | Stock | 5.1432 | 5.1432 | 5.1429 | 5.1429 | 5600.0 |
| 2009-06-10 07:10:00 | AAPL | Stock | 5.1461 | 5.1464 | 5.1429 | 5.1464 | 25200.0 |
| 2009-06-10 07:15:00 | AAPL | Stock | 5.1493 | 5.1493 | 5.1446 | 5.1446 | 5600.0 |
| 2009-06-10 07:20:00 | AAPL | Stock | 5.1471 | 5.1489 | 5.1464 | 5.1464 | 11200.0 |
| 2009-06-10 07:25:00 | AAPL | Stock | 5.1429 | 5.1507 | 5.1357 | 5.1507 | 123200.0 |
| 2009-06-10 07:30:00 | AAPL | Stock | 5.1446 | 5.1446 | 5.1411 | 5.1411 | 19600.0 |
| 2009-06-10 07:40:00 | AAPL | Stock | 5.1336 | 5.1357 | 5.1336 | 5.1357 | 25760.0 |
| 2009-06-10 07:45:00 | AAPL | Stock | 5.1357 | 5.1357 | 5.1339 | 5.1339 | 50204.0 |
| 2009-06-10 07:50:00 | AAPL | Stock | 5.1296 | 5.1296 | 5.1218 | 5.1218 | 11200.0 |
| 2009-06-10 07:55:00 | AAPL | Stock | 5.1232 | 5.1232 | 5.1079 | 5.1086 | 44800.0 |
| 2009-06-10 08:00:00 | AAPL | Stock | 5.1196 | 5.12 | 5.0893 | 5.0943 | 262444.0 |
| 2009-06-10 08:05:00 | AAPL | Stock | 5.0929 | 5.0964 | 5.0839 | 5.0929 | 137620.0 |
| 2009-06-10 08:10:00 | AAPL | Stock | 5.0929 | 5.1029 | 5.0925 | 5.1014 | 162008.0 |
| 2009-06-10 08:15:00 | AAPL | Stock | 5.1032 | 5.1171 | 5.1004 | 5.1125 | 242760.0 |
| 2009-06-10 08:20:00 | AAPL | Stock | 5.1143 | 5.1193 | 5.1129 | 5.1143 | 218960.0 |
| 2009-06-10 08:25:00 | AAPL | Stock | 5.1143 | 5.1189 | 5.1143 | 5.1179 | 87920.0 |
| 2009-06-10 08:30:00 | AAPL | Stock | 5.1179 | 5.1189 | 5.1118 | 5.1143 | 322700.0 |
| 2009-06-10 08:35:00 | AAPL | Stock | 5.1143 | 5.1143 | 5.1 | 5.1036 | 146188.0 |
| 2009-06-10 08:40:00 | AAPL | Stock | 5.0993 | 5.1018 | 5.0993 | 5.1 | 94640.0 |
| 2009-06-10 08:45:00 | AAPL | Stock | 5.0993 | 5.1 | 5.0932 | 5.0982 | 102004.0 |
| 2009-06-10 08:50:00 | AAPL | Stock | 5.1 | 5.1036 | 5.0982 | 5.1004 | 91700.0 |
| 2009-06-10 08:55:00 | AAPL | Stock | 5.1014 | 5.1064 | 5.1 | 5.1064 | 166488.0 |
| 2009-06-10 09:00:00 | AAPL | Stock | 5.1039 | 5.1071 | 5.1036 | 5.1036 | 117544.0 |
| 2009-06-10 09:05:00 | AAPL | Stock | 5.1046 | 5.1046 | 5.0982 | 5.0986 | 252000.0 |
| 2009-06-10 09:10:00 | AAPL | Stock | 5.1 | 5.1014 | 5.0946 | 5.0946 | 438816.0 |
| 2009-06-10 09:15:00 | AAPL | Stock | 5.0943 | 5.0946 | 5.0864 | 5.0936 | 324576.0 |
| 2009-06-10 09:20:00 | AAPL | Stock | 5.0971 | 5.0982 | 5.0893 | 5.0921 | 140000.0 |
| 2009-06-10 09:25:00 | AAPL | Stock | 5.0864 | 5.0893 | 5.0714 | 5.0836 | 702212.0 |
| 2009-06-10 09:30:00 | AAPL | Stock | 5.0843 | 5.0868 | 5.0316 | 5.0607 | 25224332.0 |
| 2009-06-10 09:35:00 | AAPL | Stock | 5.0604 | 5.0607 | 5.0261 | 5.0354 | 19189856.0 |
| 2009-06-10 09:40:00 | AAPL | Stock | 5.0354 | 5.0393 | 5.0 | 5.0161 | 23687832.0 |
| 2009-06-10 09:45:00 | AAPL | Stock | 5.0161 | 5.0336 | 5.0007 | 5.0011 | 16992864.0 |
| 2009-06-10 09:50:00 | AAPL | Stock | 5.0025 | 5.0157 | 4.9964 | 5.0075 | 15374548.0 |
| 2009-06-10 09:55:00 | AAPL | Stock | 5.0075 | 5.0214 | 5.0068 | 5.0214 | 10846948.0 |
| 2009-06-10 10:00:00 | AAPL | Stock | 5.0212 | 5.0268 | 4.99 | 4.9911 | 18297468.0 |
| 2009-06-10 10:05:00 | AAPL | Stock | 4.9918 | 5.0089 | 4.9843 | 5.0086 | 13062000.0 |
| 2009-06-10 10:10:00 | AAPL | Stock | 5.0075 | 5.0207 | 4.99 | 4.9907 | 11778200.0 |
| 2009-06-10 10:15:00 | AAPL | Stock | 4.9911 | 4.9964 | 4.9736 | 4.9807 | 18550532.0 |
| 2009-06-10 10:20:00 | AAPL | Stock | 4.9807 | 4.9893 | 4.9689 | 4.9779 | 15483300.0 |
| 2009-06-10 10:25:00 | AAPL | Stock | 4.9789 | 4.9821 | 4.9771 | 4.98 | 6418860.0 |
| 2009-06-10 10:30:00 | AAPL | Stock | 4.98 | 4.9875 | 4.96 | 4.9704 | 15092616.0 |
| 2009-06-10 10:35:00 | AAPL | Stock | 4.9711 | 4.9821 | 4.9671 | 4.9796 | 7627536.0 |
| 2009-06-10 10:40:00 | AAPL | Stock | 4.98 | 4.9821 | 4.975 | 4.9796 | 4593540.0 |
| 2009-06-10 10:45:00 | AAPL | Stock | 4.9796 | 4.9814 | 4.9686 | 4.973 | 11549832.0 |
> showing 50 of 330,718 rows — these rows as CSV