PREVIEW / stock_5min / 2010-12-29
file: by_date/stock_5min/2010/2010-12-29.parquet size: 4.6 MB rows: 318,559 symbols: 3,539
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-29 04:15:00 | AAPL | Stock | 11.6421 | 11.6421 | 11.6421 | 11.6421 | 5600.0 |
| 2010-12-29 05:40:00 | AAPL | Stock | 11.6107 | 11.6107 | 11.6107 | 11.6107 | 2800.0 |
| 2010-12-29 07:00:00 | AAPL | Stock | 11.6425 | 11.6425 | 11.6425 | 11.6425 | 5600.0 |
| 2010-12-29 07:15:00 | AAPL | Stock | 11.6429 | 11.6429 | 11.6429 | 11.6429 | 2800.0 |
| 2010-12-29 07:55:00 | AAPL | Stock | 11.6393 | 11.6393 | 11.6393 | 11.6393 | 5600.0 |
| 2010-12-29 08:00:00 | AAPL | Stock | 11.6389 | 11.6425 | 11.6311 | 11.6386 | 161980.0 |
| 2010-12-29 08:05:00 | AAPL | Stock | 11.6386 | 11.6386 | 11.6296 | 11.6296 | 112000.0 |
| 2010-12-29 08:10:00 | AAPL | Stock | 11.6357 | 11.6357 | 11.6339 | 11.6339 | 77000.0 |
| 2010-12-29 08:15:00 | AAPL | Stock | 11.6339 | 11.6361 | 11.6339 | 11.6354 | 50400.0 |
| 2010-12-29 08:20:00 | AAPL | Stock | 11.6339 | 11.6339 | 11.6321 | 11.6321 | 29960.0 |
| 2010-12-29 08:25:00 | AAPL | Stock | 11.6321 | 11.6339 | 11.6321 | 11.6339 | 5600.0 |
| 2010-12-29 08:30:00 | AAPL | Stock | 11.6318 | 11.6321 | 11.6304 | 11.6321 | 25200.0 |
| 2010-12-29 08:35:00 | AAPL | Stock | 11.6321 | 11.6339 | 11.6321 | 11.6339 | 25200.0 |
| 2010-12-29 08:40:00 | AAPL | Stock | 11.6339 | 11.6339 | 11.6314 | 11.6314 | 56196.0 |
| 2010-12-29 08:45:00 | AAPL | Stock | 11.6336 | 11.6339 | 11.6336 | 11.6339 | 50400.0 |
| 2010-12-29 08:50:00 | AAPL | Stock | 11.6339 | 11.6425 | 11.6339 | 11.6418 | 170520.0 |
| 2010-12-29 08:55:00 | AAPL | Stock | 11.6425 | 11.6425 | 11.6382 | 11.6382 | 44800.0 |
| 2010-12-29 09:00:00 | AAPL | Stock | 11.6404 | 11.6404 | 11.6375 | 11.6393 | 41944.0 |
| 2010-12-29 09:05:00 | AAPL | Stock | 11.6364 | 11.6464 | 11.6364 | 11.6429 | 233996.0 |
| 2010-12-29 09:10:00 | AAPL | Stock | 11.6411 | 11.6429 | 11.6393 | 11.6429 | 116060.0 |
| 2010-12-29 09:15:00 | AAPL | Stock | 11.6436 | 11.6457 | 11.6411 | 11.6429 | 94612.0 |
| 2010-12-29 09:20:00 | AAPL | Stock | 11.6407 | 11.6411 | 11.64 | 11.6407 | 77000.0 |
| 2010-12-29 09:25:00 | AAPL | Stock | 11.6425 | 11.6493 | 11.6425 | 11.6486 | 222600.0 |
| 2010-12-29 09:30:00 | AAPL | Stock | 11.6454 | 11.6589 | 11.6446 | 11.6446 | 8915816.0 |
| 2010-12-29 09:35:00 | AAPL | Stock | 11.6446 | 11.6461 | 11.6332 | 11.6381 | 5206544.0 |
| 2010-12-29 09:40:00 | AAPL | Stock | 11.6375 | 11.6454 | 11.6354 | 11.6393 | 5282620.0 |
| 2010-12-29 09:45:00 | AAPL | Stock | 11.64 | 11.6411 | 11.6357 | 11.6386 | 1942780.0 |
| 2010-12-29 09:50:00 | AAPL | Stock | 11.6386 | 11.6421 | 11.6357 | 11.6389 | 2599492.0 |
| 2010-12-29 09:55:00 | AAPL | Stock | 11.6386 | 11.6425 | 11.6364 | 11.6421 | 1865304.0 |
| 2010-12-29 10:00:00 | AAPL | Stock | 11.6421 | 11.6471 | 11.6404 | 11.6434 | 2757076.0 |
| 2010-12-29 10:05:00 | AAPL | Stock | 11.6439 | 11.6454 | 11.6357 | 11.6379 | 4307996.0 |
| 2010-12-29 10:10:00 | AAPL | Stock | 11.6389 | 11.6418 | 11.6361 | 11.6379 | 1607032.0 |
| 2010-12-29 10:15:00 | AAPL | Stock | 11.6379 | 11.6454 | 11.6357 | 11.6443 | 2349928.0 |
| 2010-12-29 10:20:00 | AAPL | Stock | 11.6443 | 11.6454 | 11.64 | 11.6436 | 2589664.0 |
| 2010-12-29 10:25:00 | AAPL | Stock | 11.6418 | 11.6479 | 11.6414 | 11.6425 | 2222416.0 |
| 2010-12-29 10:30:00 | AAPL | Stock | 11.6421 | 11.6518 | 11.6421 | 11.6506 | 2422588.0 |
| 2010-12-29 10:35:00 | AAPL | Stock | 11.6514 | 11.6536 | 11.645 | 11.6466 | 1998640.0 |
| 2010-12-29 10:40:00 | AAPL | Stock | 11.6468 | 11.65 | 11.6439 | 11.6496 | 1806140.0 |
| 2010-12-29 10:45:00 | AAPL | Stock | 11.6496 | 11.6511 | 11.6464 | 11.6492 | 1369788.0 |
| 2010-12-29 10:50:00 | AAPL | Stock | 11.6493 | 11.65 | 11.6446 | 11.6461 | 1430464.0 |
| 2010-12-29 10:55:00 | AAPL | Stock | 11.645 | 11.65 | 11.6239 | 11.6404 | 3327100.0 |
| 2010-12-29 11:00:00 | AAPL | Stock | 11.6411 | 11.6439 | 11.6396 | 11.6421 | 2282476.0 |
| 2010-12-29 11:05:00 | AAPL | Stock | 11.6421 | 11.6421 | 11.6346 | 11.6404 | 3285464.0 |
| 2010-12-29 11:10:00 | AAPL | Stock | 11.6387 | 11.6407 | 11.6263 | 11.6268 | 2873612.0 |
| 2010-12-29 11:15:00 | AAPL | Stock | 11.6271 | 11.6311 | 11.6214 | 11.627 | 4371332.0 |
| 2010-12-29 11:20:00 | AAPL | Stock | 11.6271 | 11.6287 | 11.6161 | 11.6179 | 3252676.0 |
| 2010-12-29 11:25:00 | AAPL | Stock | 11.6175 | 11.6275 | 11.6175 | 11.625 | 1763188.0 |
| 2010-12-29 11:30:00 | AAPL | Stock | 11.625 | 11.6296 | 11.6211 | 11.6257 | 1323028.0 |
| 2010-12-29 11:35:00 | AAPL | Stock | 11.625 | 11.63 | 11.6246 | 11.625 | 841260.0 |
| 2010-12-29 11:40:00 | AAPL | Stock | 11.6258 | 11.6292 | 11.625 | 11.6268 | 1098552.0 |
> showing 50 of 318,559 rows — these rows as CSV