PREVIEW / stock_5min / 2010-12-27
file: by_date/stock_5min/2010/2010-12-27.parquet size: 4.5 MB rows: 310,870 symbols: 3,520
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-27 04:00:00 | AAPL | Stock | 11.5486 | 11.5486 | 11.5486 | 11.5486 | 6496.0 |
| 2010-12-27 04:45:00 | AAPL | Stock | 11.5343 | 11.5343 | 11.5343 | 11.5343 | 8400.0 |
| 2010-12-27 07:00:00 | AAPL | Stock | 11.5361 | 11.5361 | 11.5357 | 11.5357 | 19600.0 |
| 2010-12-27 07:20:00 | AAPL | Stock | 11.5657 | 11.5657 | 11.5657 | 11.5657 | 3416.0 |
| 2010-12-27 07:25:00 | AAPL | Stock | 11.5396 | 11.5536 | 11.5393 | 11.5536 | 16184.0 |
| 2010-12-27 07:30:00 | AAPL | Stock | 11.5411 | 11.5411 | 11.5411 | 11.5411 | 4200.0 |
| 2010-12-27 07:35:00 | AAPL | Stock | 11.5411 | 11.5414 | 11.5411 | 11.5414 | 15400.0 |
| 2010-12-27 07:45:00 | AAPL | Stock | 11.5361 | 11.5361 | 11.5329 | 11.5329 | 28000.0 |
| 2010-12-27 07:55:00 | AAPL | Stock | 11.5364 | 11.5364 | 11.5364 | 11.5364 | 2800.0 |
| 2010-12-27 08:00:00 | AAPL | Stock | 11.5329 | 11.5411 | 11.5214 | 11.5214 | 187712.0 |
| 2010-12-27 08:05:00 | AAPL | Stock | 11.5214 | 11.5232 | 11.5143 | 11.5143 | 53592.0 |
| 2010-12-27 08:10:00 | AAPL | Stock | 11.5286 | 11.5286 | 11.5161 | 11.5161 | 21000.0 |
| 2010-12-27 08:15:00 | AAPL | Stock | 11.5114 | 11.5218 | 11.5107 | 11.5125 | 39536.0 |
| 2010-12-27 08:20:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5125 | 11.5125 | 25872.0 |
| 2010-12-27 08:25:00 | AAPL | Stock | 11.5143 | 11.5171 | 11.5143 | 11.5171 | 18340.0 |
| 2010-12-27 08:30:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5179 | 11.5179 | 3724.0 |
| 2010-12-27 08:35:00 | AAPL | Stock | 11.5179 | 11.5196 | 11.5161 | 11.5196 | 22400.0 |
| 2010-12-27 08:40:00 | AAPL | Stock | 11.5214 | 11.5311 | 11.5214 | 11.5268 | 39200.0 |
| 2010-12-27 08:50:00 | AAPL | Stock | 11.525 | 11.5264 | 11.525 | 11.5264 | 8400.0 |
| 2010-12-27 08:55:00 | AAPL | Stock | 11.5268 | 11.5268 | 11.5232 | 11.5236 | 28000.0 |
| 2010-12-27 09:00:00 | AAPL | Stock | 11.5246 | 11.5286 | 11.5246 | 11.5279 | 94052.0 |
| 2010-12-27 09:05:00 | AAPL | Stock | 11.5268 | 11.5268 | 11.5232 | 11.5232 | 43400.0 |
| 2010-12-27 09:10:00 | AAPL | Stock | 11.5214 | 11.5225 | 11.5204 | 11.5204 | 19376.0 |
| 2010-12-27 09:15:00 | AAPL | Stock | 11.5225 | 11.525 | 11.5214 | 11.525 | 196000.0 |
| 2010-12-27 09:20:00 | AAPL | Stock | 11.5214 | 11.5214 | 11.5204 | 11.5204 | 22400.0 |
| 2010-12-27 09:25:00 | AAPL | Stock | 11.5232 | 11.5429 | 11.5232 | 11.5429 | 436072.0 |
| 2010-12-27 09:30:00 | AAPL | Stock | 11.5418 | 11.5536 | 11.5304 | 11.545 | 17659964.0 |
| 2010-12-27 09:35:00 | AAPL | Stock | 11.5446 | 11.58 | 11.54 | 11.5539 | 12579812.0 |
| 2010-12-27 09:40:00 | AAPL | Stock | 11.5539 | 11.5596 | 11.5364 | 11.54 | 8572900.0 |
| 2010-12-27 09:45:00 | AAPL | Stock | 11.5404 | 11.5468 | 11.5179 | 11.5229 | 7980336.0 |
| 2010-12-27 09:50:00 | AAPL | Stock | 11.5215 | 11.5225 | 11.4875 | 11.4946 | 12533080.0 |
| 2010-12-27 09:55:00 | AAPL | Stock | 11.495 | 11.5043 | 11.4829 | 11.5043 | 7565292.0 |
| 2010-12-27 10:00:00 | AAPL | Stock | 11.5036 | 11.5118 | 11.5011 | 11.5054 | 3832556.0 |
| 2010-12-27 10:05:00 | AAPL | Stock | 11.5061 | 11.515 | 11.5061 | 11.5096 | 3136364.0 |
| 2010-12-27 10:10:00 | AAPL | Stock | 11.5101 | 11.5161 | 11.5068 | 11.5143 | 3542644.0 |
| 2010-12-27 10:15:00 | AAPL | Stock | 11.5136 | 11.5261 | 11.5093 | 11.5218 | 5258176.0 |
| 2010-12-27 10:20:00 | AAPL | Stock | 11.5221 | 11.5282 | 11.5143 | 11.5196 | 3911768.0 |
| 2010-12-27 10:25:00 | AAPL | Stock | 11.5189 | 11.5279 | 11.5186 | 11.5196 | 3342416.0 |
| 2010-12-27 10:30:00 | AAPL | Stock | 11.5204 | 11.525 | 11.515 | 11.5211 | 3268104.0 |
| 2010-12-27 10:35:00 | AAPL | Stock | 11.5196 | 11.5229 | 11.51 | 11.5164 | 3061044.0 |
| 2010-12-27 10:40:00 | AAPL | Stock | 11.5164 | 11.5214 | 11.5121 | 11.5146 | 2409652.0 |
| 2010-12-27 10:45:00 | AAPL | Stock | 11.5146 | 11.5146 | 11.5075 | 11.5118 | 1898512.0 |
| 2010-12-27 10:50:00 | AAPL | Stock | 11.5104 | 11.5157 | 11.5061 | 11.5082 | 2245824.0 |
| 2010-12-27 10:55:00 | AAPL | Stock | 11.5093 | 11.5121 | 11.5046 | 11.5054 | 1985172.0 |
| 2010-12-27 11:00:00 | AAPL | Stock | 11.5064 | 11.5121 | 11.5057 | 11.5107 | 1557724.0 |
| 2010-12-27 11:05:00 | AAPL | Stock | 11.512 | 11.5132 | 11.5061 | 11.5125 | 2611224.0 |
| 2010-12-27 11:10:00 | AAPL | Stock | 11.5125 | 11.5139 | 11.5071 | 11.5136 | 1587152.0 |
| 2010-12-27 11:15:00 | AAPL | Stock | 11.5129 | 11.52 | 11.5107 | 11.5171 | 2836876.0 |
| 2010-12-27 11:20:00 | AAPL | Stock | 11.5164 | 11.5211 | 11.5146 | 11.5175 | 1797432.0 |
| 2010-12-27 11:25:00 | AAPL | Stock | 11.5193 | 11.5193 | 11.5096 | 11.5146 | 1201060.0 |
> showing 50 of 310,870 rows — these rows as CSV