PREVIEW / stock_5min / 2008-03-18
file: by_date/stock_5min/2008/2008-03-18.parquet size: 4.5 MB rows: 323,105 symbols: 3,295
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-03-18 06:15:00 | AAPL | Stock | 4.5921 | 4.6064 | 4.5921 | 4.6064 | 61488.0 |
| 2008-03-18 06:30:00 | AAPL | Stock | 4.5893 | 4.5893 | 4.5893 | 4.5893 | 44800.0 |
| 2008-03-18 06:35:00 | AAPL | Stock | 4.5861 | 4.5893 | 4.5861 | 4.5893 | 34748.0 |
| 2008-03-18 06:45:00 | AAPL | Stock | 4.6054 | 4.6054 | 4.6054 | 4.6054 | 22400.0 |
| 2008-03-18 07:20:00 | AAPL | Stock | 4.5975 | 4.5982 | 4.5975 | 4.5982 | 30940.0 |
| 2008-03-18 07:25:00 | AAPL | Stock | 4.5893 | 4.59 | 4.5893 | 4.59 | 11200.0 |
| 2008-03-18 07:30:00 | AAPL | Stock | 4.5971 | 4.6018 | 4.5971 | 4.6018 | 59444.0 |
| 2008-03-18 07:35:00 | AAPL | Stock | 4.6054 | 4.6071 | 4.5929 | 4.6036 | 91532.0 |
| 2008-03-18 07:40:00 | AAPL | Stock | 4.5932 | 4.5932 | 4.5932 | 4.5932 | 8400.0 |
| 2008-03-18 07:45:00 | AAPL | Stock | 4.5932 | 4.6 | 4.5932 | 4.6 | 43680.0 |
| 2008-03-18 07:50:00 | AAPL | Stock | 4.6 | 4.6082 | 4.6 | 4.6071 | 79156.0 |
| 2008-03-18 07:55:00 | AAPL | Stock | 4.6018 | 4.6082 | 4.6018 | 4.6054 | 229600.0 |
| 2008-03-18 08:00:00 | AAPL | Stock | 4.6039 | 4.6136 | 4.5914 | 4.6071 | 755776.0 |
| 2008-03-18 08:05:00 | AAPL | Stock | 4.6068 | 4.6107 | 4.6 | 4.6 | 480984.0 |
| 2008-03-18 08:10:00 | AAPL | Stock | 4.5925 | 4.6107 | 4.5893 | 4.6079 | 465584.0 |
| 2008-03-18 08:15:00 | AAPL | Stock | 4.6107 | 4.6107 | 4.5971 | 4.6018 | 302540.0 |
| 2008-03-18 08:20:00 | AAPL | Stock | 4.6007 | 4.6068 | 4.5982 | 4.6068 | 665672.0 |
| 2008-03-18 08:25:00 | AAPL | Stock | 4.6007 | 4.6064 | 4.6 | 4.6 | 1697808.0 |
| 2008-03-18 08:30:00 | AAPL | Stock | 4.5968 | 4.6064 | 4.5911 | 4.6029 | 494312.0 |
| 2008-03-18 08:35:00 | AAPL | Stock | 4.6029 | 4.6036 | 4.5993 | 4.6 | 107996.0 |
| 2008-03-18 08:40:00 | AAPL | Stock | 4.6 | 4.6039 | 4.5993 | 4.6032 | 184296.0 |
| 2008-03-18 08:45:00 | AAPL | Stock | 4.6036 | 4.6046 | 4.6 | 4.6046 | 348964.0 |
| 2008-03-18 08:50:00 | AAPL | Stock | 4.605 | 4.6071 | 4.595 | 4.595 | 207732.0 |
| 2008-03-18 08:55:00 | AAPL | Stock | 4.595 | 4.6011 | 4.5936 | 4.5946 | 232848.0 |
| 2008-03-18 09:00:00 | AAPL | Stock | 4.5979 | 4.6093 | 4.5979 | 4.6089 | 1117144.0 |
| 2008-03-18 09:05:00 | AAPL | Stock | 4.6089 | 4.6125 | 4.6071 | 4.6082 | 756672.0 |
| 2008-03-18 09:10:00 | AAPL | Stock | 4.6093 | 4.6168 | 4.6093 | 4.6168 | 635012.0 |
| 2008-03-18 09:15:00 | AAPL | Stock | 4.6171 | 4.6179 | 4.6089 | 4.6114 | 410200.0 |
| 2008-03-18 09:20:00 | AAPL | Stock | 4.6107 | 4.6139 | 4.6071 | 4.6139 | 119280.0 |
| 2008-03-18 09:25:00 | AAPL | Stock | 4.6139 | 4.6196 | 4.6104 | 4.6157 | 2283120.0 |
| 2008-03-18 09:30:00 | AAPL | Stock | 4.6136 | 4.6429 | 4.6111 | 4.6386 | 31391696.0 |
| 2008-03-18 09:35:00 | AAPL | Stock | 4.6386 | 4.6411 | 4.6207 | 4.64 | 27236524.0 |
| 2008-03-18 09:40:00 | AAPL | Stock | 4.6404 | 4.6496 | 4.6214 | 4.6425 | 28821212.0 |
| 2008-03-18 09:45:00 | AAPL | Stock | 4.6432 | 4.6464 | 4.6329 | 4.6436 | 20945736.0 |
| 2008-03-18 09:50:00 | AAPL | Stock | 4.6437 | 4.6564 | 4.5954 | 4.6175 | 35172816.0 |
| 2008-03-18 09:55:00 | AAPL | Stock | 4.6168 | 4.6387 | 4.6164 | 4.6296 | 16429700.0 |
| 2008-03-18 10:00:00 | AAPL | Stock | 4.6296 | 4.6443 | 4.625 | 4.6275 | 13068580.0 |
| 2008-03-18 10:05:00 | AAPL | Stock | 4.6282 | 4.6346 | 4.6129 | 4.62 | 15943144.0 |
| 2008-03-18 10:10:00 | AAPL | Stock | 4.6204 | 4.6225 | 4.6086 | 4.6145 | 15111460.0 |
| 2008-03-18 10:15:00 | AAPL | Stock | 4.6188 | 4.6204 | 4.6004 | 4.6107 | 13219724.0 |
| 2008-03-18 10:20:00 | AAPL | Stock | 4.61 | 4.6125 | 4.6014 | 4.6058 | 7639996.0 |
| 2008-03-18 10:25:00 | AAPL | Stock | 4.6057 | 4.6207 | 4.6055 | 4.6164 | 9722608.0 |
| 2008-03-18 10:30:00 | AAPL | Stock | 4.6165 | 4.6246 | 4.61 | 4.6118 | 8366176.0 |
| 2008-03-18 10:35:00 | AAPL | Stock | 4.6121 | 4.6343 | 4.6118 | 4.6318 | 11413948.0 |
| 2008-03-18 10:40:00 | AAPL | Stock | 4.6321 | 4.6396 | 4.6261 | 4.6379 | 10590412.0 |
| 2008-03-18 10:45:00 | AAPL | Stock | 4.6386 | 4.645 | 4.6289 | 4.6368 | 12649476.0 |
| 2008-03-18 10:50:00 | AAPL | Stock | 4.6364 | 4.6404 | 4.63 | 4.6321 | 6929468.0 |
| 2008-03-18 10:55:00 | AAPL | Stock | 4.6325 | 4.6357 | 4.6207 | 4.6214 | 9887612.0 |
| 2008-03-18 11:00:00 | AAPL | Stock | 4.6207 | 4.6339 | 4.6196 | 4.63 | 10497452.0 |
| 2008-03-18 11:05:00 | AAPL | Stock | 4.6304 | 4.6379 | 4.6264 | 4.6344 | 8400700.0 |
> showing 50 of 323,105 rows — these rows as CSV