PREVIEW / stock_5min / 2005-12-28
file: by_date/stock_5min/2005/2005-12-28.parquet size: 2.8 MB rows: 207,965 symbols: 2,167
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-28 08:00:00 | AAPL | Stock | 2.6511 | 2.6607 | 2.6507 | 2.6607 | 186200.0 |
| 2005-12-28 08:05:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 74200.0 |
| 2005-12-28 08:10:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6571 | 2.6604 | 99008.0 |
| 2005-12-28 08:15:00 | AAPL | Stock | 2.6604 | 2.6604 | 2.6604 | 2.6604 | 13048.0 |
| 2005-12-28 08:20:00 | AAPL | Stock | 2.6586 | 2.6586 | 2.6586 | 2.6586 | 5600.0 |
| 2005-12-28 08:25:00 | AAPL | Stock | 2.6575 | 2.6604 | 2.6561 | 2.6604 | 114800.0 |
| 2005-12-28 08:30:00 | AAPL | Stock | 2.6561 | 2.6561 | 2.6561 | 2.6561 | 43400.0 |
| 2005-12-28 08:35:00 | AAPL | Stock | 2.6561 | 2.6561 | 2.6561 | 2.6561 | 7924.0 |
| 2005-12-28 08:40:00 | AAPL | Stock | 2.6589 | 2.6589 | 2.6571 | 2.6571 | 142800.0 |
| 2005-12-28 08:45:00 | AAPL | Stock | 2.6579 | 2.6586 | 2.6579 | 2.6586 | 31360.0 |
| 2005-12-28 08:50:00 | AAPL | Stock | 2.6589 | 2.6604 | 2.6571 | 2.6575 | 99400.0 |
| 2005-12-28 08:55:00 | AAPL | Stock | 2.6571 | 2.6711 | 2.6571 | 2.6639 | 280000.0 |
| 2005-12-28 09:00:00 | AAPL | Stock | 2.6643 | 2.6679 | 2.6643 | 2.6675 | 39200.0 |
| 2005-12-28 09:05:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6607 | 2.6607 | 293188.0 |
| 2005-12-28 09:10:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6571 | 2.66 | 138600.0 |
| 2005-12-28 09:15:00 | AAPL | Stock | 2.6575 | 2.6575 | 2.6536 | 2.6564 | 196000.0 |
| 2005-12-28 09:20:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6564 | 2.6593 | 40600.0 |
| 2005-12-28 09:25:00 | AAPL | Stock | 2.6571 | 2.6607 | 2.6554 | 2.6586 | 301392.0 |
| 2005-12-28 09:30:00 | AAPL | Stock | 2.6596 | 2.67 | 2.6554 | 2.6689 | 12927628.0 |
| 2005-12-28 09:35:00 | AAPL | Stock | 2.6693 | 2.67 | 2.6654 | 2.6675 | 5838000.0 |
| 2005-12-28 09:40:00 | AAPL | Stock | 2.6671 | 2.6679 | 2.6539 | 2.6579 | 9793756.0 |
| 2005-12-28 09:45:00 | AAPL | Stock | 2.6579 | 2.6579 | 2.6489 | 2.6532 | 11117428.0 |
| 2005-12-28 09:50:00 | AAPL | Stock | 2.6536 | 2.6621 | 2.6532 | 2.66 | 7958076.0 |
| 2005-12-28 09:55:00 | AAPL | Stock | 2.6604 | 2.6639 | 2.6564 | 2.66 | 6234508.0 |
| 2005-12-28 10:00:00 | AAPL | Stock | 2.6596 | 2.6657 | 2.6575 | 2.6629 | 8836520.0 |
| 2005-12-28 10:05:00 | AAPL | Stock | 2.6625 | 2.6661 | 2.6611 | 2.6621 | 4096764.0 |
| 2005-12-28 10:10:00 | AAPL | Stock | 2.6618 | 2.6643 | 2.6564 | 2.6586 | 4464404.0 |
| 2005-12-28 10:15:00 | AAPL | Stock | 2.6582 | 2.6618 | 2.6571 | 2.6593 | 4953480.0 |
| 2005-12-28 10:20:00 | AAPL | Stock | 2.6596 | 2.6614 | 2.6571 | 2.6586 | 2535456.0 |
| 2005-12-28 10:25:00 | AAPL | Stock | 2.6575 | 2.6575 | 2.6507 | 2.6511 | 6241900.0 |
| 2005-12-28 10:30:00 | AAPL | Stock | 2.6511 | 2.6546 | 2.6479 | 2.6493 | 7177884.0 |
| 2005-12-28 10:35:00 | AAPL | Stock | 2.649 | 2.6511 | 2.6357 | 2.6371 | 12639928.0 |
| 2005-12-28 10:40:00 | AAPL | Stock | 2.6368 | 2.6407 | 2.6279 | 2.6286 | 12708892.0 |
| 2005-12-28 10:45:00 | AAPL | Stock | 2.6285 | 2.6329 | 2.6268 | 2.6311 | 8788724.0 |
| 2005-12-28 10:50:00 | AAPL | Stock | 2.6311 | 2.6382 | 2.6307 | 2.6364 | 7915880.0 |
| 2005-12-28 10:55:00 | AAPL | Stock | 2.6368 | 2.6411 | 2.6364 | 2.6396 | 6611136.0 |
| 2005-12-28 11:00:00 | AAPL | Stock | 2.6389 | 2.6414 | 2.6375 | 2.6407 | 5263720.0 |
| 2005-12-28 11:05:00 | AAPL | Stock | 2.6407 | 2.6414 | 2.6346 | 2.6354 | 5162388.0 |
| 2005-12-28 11:10:00 | AAPL | Stock | 2.6357 | 2.6382 | 2.6332 | 2.6368 | 3950380.0 |
| 2005-12-28 11:15:00 | AAPL | Stock | 2.6371 | 2.6375 | 2.6343 | 2.6371 | 1455944.0 |
| 2005-12-28 11:20:00 | AAPL | Stock | 2.6371 | 2.6393 | 2.6357 | 2.6393 | 2344160.0 |
| 2005-12-28 11:25:00 | AAPL | Stock | 2.6393 | 2.6411 | 2.6393 | 2.6411 | 2845920.0 |
| 2005-12-28 11:30:00 | AAPL | Stock | 2.6411 | 2.6446 | 2.6404 | 2.6425 | 5752852.0 |
| 2005-12-28 11:35:00 | AAPL | Stock | 2.6425 | 2.6439 | 2.6404 | 2.6411 | 3232796.0 |
| 2005-12-28 11:40:00 | AAPL | Stock | 2.6414 | 2.6421 | 2.6382 | 2.6386 | 2868712.0 |
| 2005-12-28 11:45:00 | AAPL | Stock | 2.6382 | 2.6382 | 2.6329 | 2.6336 | 6051640.0 |
| 2005-12-28 11:50:00 | AAPL | Stock | 2.6336 | 2.6336 | 2.6307 | 2.6318 | 3914652.0 |
| 2005-12-28 11:55:00 | AAPL | Stock | 2.6318 | 2.6675 | 2.6304 | 2.6329 | 3126564.0 |
| 2005-12-28 12:00:00 | AAPL | Stock | 2.6325 | 2.6329 | 2.6304 | 2.6314 | 1897924.0 |
| 2005-12-28 12:05:00 | AAPL | Stock | 2.6314 | 2.6314 | 2.6221 | 2.6221 | 10297224.0 |
> showing 50 of 207,965 rows — these rows as CSV