PREVIEW / stock_5min / 2008-10-10
file: by_date/stock_5min/2008/2008-10-10.parquet size: 5.1 MB rows: 358,551 symbols: 3,414
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-10 04:15:00 | AAPL | Stock | 3.1179 | 3.1207 | 3.1179 | 3.1207 | 56000.0 |
| 2008-10-10 05:00:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 2800.0 |
| 2008-10-10 05:05:00 | AAPL | Stock | 3.0718 | 3.0718 | 3.0718 | 3.0718 | 2800.0 |
| 2008-10-10 05:10:00 | AAPL | Stock | 3.0718 | 3.0718 | 3.0714 | 3.0714 | 5600.0 |
| 2008-10-10 05:15:00 | AAPL | Stock | 3.1211 | 3.1211 | 3.1211 | 3.1211 | 2800.0 |
| 2008-10-10 05:20:00 | AAPL | Stock | 3.0361 | 3.0361 | 3.0361 | 3.0361 | 19600.0 |
| 2008-10-10 05:25:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0536 | 3.0714 | 58800.0 |
| 2008-10-10 05:30:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 30800.0 |
| 2008-10-10 05:35:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 40768.0 |
| 2008-10-10 05:40:00 | AAPL | Stock | 3.0536 | 3.0714 | 3.0536 | 3.0714 | 28560.0 |
| 2008-10-10 05:55:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 2800.0 |
| 2008-10-10 06:00:00 | AAPL | Stock | 3.0696 | 3.0696 | 3.0696 | 3.0696 | 14000.0 |
| 2008-10-10 06:35:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 2800.0 |
| 2008-10-10 06:40:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 17836.0 |
| 2008-10-10 06:50:00 | AAPL | Stock | 3.0857 | 3.0857 | 3.0857 | 3.0857 | 5040.0 |
| 2008-10-10 06:55:00 | AAPL | Stock | 3.0875 | 3.0889 | 3.0875 | 3.0875 | 19600.0 |
| 2008-10-10 07:05:00 | AAPL | Stock | 3.1064 | 3.115 | 3.1064 | 3.1143 | 103236.0 |
| 2008-10-10 07:10:00 | AAPL | Stock | 3.1268 | 3.1425 | 3.125 | 3.1375 | 86800.0 |
| 2008-10-10 07:15:00 | AAPL | Stock | 3.1368 | 3.1586 | 3.1357 | 3.1429 | 48916.0 |
| 2008-10-10 07:20:00 | AAPL | Stock | 3.1432 | 3.1579 | 3.115 | 3.1161 | 156800.0 |
| 2008-10-10 07:25:00 | AAPL | Stock | 3.1071 | 3.1239 | 3.1071 | 3.1239 | 29400.0 |
| 2008-10-10 07:30:00 | AAPL | Stock | 3.1214 | 3.125 | 3.1214 | 3.1214 | 22400.0 |
| 2008-10-10 07:35:00 | AAPL | Stock | 3.1089 | 3.1143 | 3.1036 | 3.1143 | 122584.0 |
| 2008-10-10 07:40:00 | AAPL | Stock | 3.1068 | 3.1075 | 3.1036 | 3.1075 | 36400.0 |
| 2008-10-10 07:45:00 | AAPL | Stock | 3.1089 | 3.1089 | 3.0796 | 3.0796 | 123060.0 |
| 2008-10-10 07:50:00 | AAPL | Stock | 3.0804 | 3.0893 | 3.08 | 3.08 | 19628.0 |
| 2008-10-10 07:55:00 | AAPL | Stock | 3.0989 | 3.0989 | 3.0811 | 3.0811 | 17304.0 |
| 2008-10-10 08:00:00 | AAPL | Stock | 3.1007 | 3.1018 | 3.06 | 3.0711 | 673988.0 |
| 2008-10-10 08:05:00 | AAPL | Stock | 3.0643 | 3.0836 | 3.0586 | 3.0804 | 426356.0 |
| 2008-10-10 08:10:00 | AAPL | Stock | 3.0804 | 3.1036 | 3.0761 | 3.0964 | 474040.0 |
| 2008-10-10 08:15:00 | AAPL | Stock | 3.0964 | 3.0979 | 3.0857 | 3.0921 | 805756.0 |
| 2008-10-10 08:20:00 | AAPL | Stock | 3.0893 | 3.0896 | 3.0839 | 3.0893 | 218148.0 |
| 2008-10-10 08:25:00 | AAPL | Stock | 3.0896 | 3.1107 | 3.0893 | 3.1036 | 354116.0 |
| 2008-10-10 08:30:00 | AAPL | Stock | 3.1039 | 3.1057 | 3.0861 | 3.0861 | 425992.0 |
| 2008-10-10 08:35:00 | AAPL | Stock | 3.0875 | 3.0875 | 3.0754 | 3.0779 | 331856.0 |
| 2008-10-10 08:40:00 | AAPL | Stock | 3.0793 | 3.0893 | 3.07 | 3.0714 | 528556.0 |
| 2008-10-10 08:45:00 | AAPL | Stock | 3.0714 | 3.0725 | 3.0643 | 3.0675 | 301952.0 |
| 2008-10-10 08:50:00 | AAPL | Stock | 3.0675 | 3.0718 | 3.0654 | 3.0689 | 273588.0 |
| 2008-10-10 08:55:00 | AAPL | Stock | 3.0682 | 3.0693 | 3.0375 | 3.0411 | 426720.0 |
| 2008-10-10 09:00:00 | AAPL | Stock | 3.0425 | 3.0446 | 3.0357 | 3.0411 | 535080.0 |
| 2008-10-10 09:05:00 | AAPL | Stock | 3.0411 | 3.0418 | 3.0218 | 3.0296 | 950796.0 |
| 2008-10-10 09:10:00 | AAPL | Stock | 3.0339 | 3.0357 | 3.0039 | 3.0107 | 585256.0 |
| 2008-10-10 09:15:00 | AAPL | Stock | 3.0132 | 3.0304 | 3.0132 | 3.0304 | 319816.0 |
| 2008-10-10 09:20:00 | AAPL | Stock | 3.0329 | 3.0621 | 3.0329 | 3.0607 | 452088.0 |
| 2008-10-10 09:25:00 | AAPL | Stock | 3.0646 | 3.0814 | 3.0575 | 3.0586 | 1455160.0 |
| 2008-10-10 09:30:00 | AAPL | Stock | 3.0586 | 3.1429 | 3.0461 | 3.0643 | 48841212.0 |
| 2008-10-10 09:35:00 | AAPL | Stock | 3.0636 | 3.2332 | 3.0357 | 3.1607 | 47814060.0 |
| 2008-10-10 09:40:00 | AAPL | Stock | 3.1607 | 3.2857 | 3.151 | 3.2846 | 43427048.0 |
| 2008-10-10 09:45:00 | AAPL | Stock | 3.285 | 3.3146 | 3.1664 | 3.2636 | 44114364.0 |
| 2008-10-10 09:50:00 | AAPL | Stock | 3.2736 | 3.3214 | 3.1411 | 3.3211 | 35684936.0 |
> showing 50 of 358,551 rows — these rows as CSV