PREVIEW / stock_5min / 2010-07-20
file: by_date/stock_5min/2010/2010-07-20.parquet size: 4.6 MB rows: 314,431 symbols: 3,463
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-07-20 05:00:00 | AAPL | Stock | 8.735 | 8.735 | 8.735 | 8.735 | 2800.0 |
| 2010-07-20 05:45:00 | AAPL | Stock | 8.7357 | 8.7357 | 8.7357 | 8.7357 | 2800.0 |
| 2010-07-20 05:50:00 | AAPL | Stock | 8.7039 | 8.7039 | 8.7 | 8.7 | 27580.0 |
| 2010-07-20 05:55:00 | AAPL | Stock | 8.7 | 8.7 | 8.6868 | 8.6964 | 21140.0 |
| 2010-07-20 06:10:00 | AAPL | Stock | 8.6868 | 8.6868 | 8.6868 | 8.6868 | 2800.0 |
| 2010-07-20 06:15:00 | AAPL | Stock | 8.6825 | 8.6825 | 8.6825 | 8.6825 | 14000.0 |
| 2010-07-20 06:20:00 | AAPL | Stock | 8.6821 | 8.6821 | 8.6821 | 8.6821 | 2800.0 |
| 2010-07-20 06:25:00 | AAPL | Stock | 8.6821 | 8.6821 | 8.6607 | 8.6607 | 22400.0 |
| 2010-07-20 06:35:00 | AAPL | Stock | 8.6607 | 8.6607 | 8.6607 | 8.6607 | 2800.0 |
| 2010-07-20 06:40:00 | AAPL | Stock | 8.6707 | 8.6711 | 8.6707 | 8.6711 | 20748.0 |
| 2010-07-20 06:45:00 | AAPL | Stock | 8.6643 | 8.6711 | 8.6643 | 8.6711 | 5600.0 |
| 2010-07-20 06:50:00 | AAPL | Stock | 8.6711 | 8.6711 | 8.6711 | 8.6711 | 2800.0 |
| 2010-07-20 07:00:00 | AAPL | Stock | 8.6575 | 8.6575 | 8.6571 | 8.6571 | 14000.0 |
| 2010-07-20 07:10:00 | AAPL | Stock | 8.6643 | 8.6921 | 8.6643 | 8.6921 | 33600.0 |
| 2010-07-20 07:15:00 | AAPL | Stock | 8.6857 | 8.6946 | 8.6821 | 8.6946 | 23800.0 |
| 2010-07-20 07:20:00 | AAPL | Stock | 8.6875 | 8.6875 | 8.6789 | 8.6789 | 36120.0 |
| 2010-07-20 07:25:00 | AAPL | Stock | 8.6789 | 8.6789 | 8.6789 | 8.6789 | 8400.0 |
| 2010-07-20 07:35:00 | AAPL | Stock | 8.6807 | 8.6807 | 8.6807 | 8.6807 | 8400.0 |
| 2010-07-20 07:45:00 | AAPL | Stock | 8.6896 | 8.7 | 8.6807 | 8.6879 | 75600.0 |
| 2010-07-20 07:50:00 | AAPL | Stock | 8.6918 | 8.6918 | 8.6821 | 8.6821 | 33600.0 |
| 2010-07-20 07:55:00 | AAPL | Stock | 8.6864 | 8.6957 | 8.6821 | 8.6957 | 56000.0 |
| 2010-07-20 08:00:00 | AAPL | Stock | 8.6964 | 8.7125 | 8.6946 | 8.6964 | 380800.0 |
| 2010-07-20 08:05:00 | AAPL | Stock | 8.6964 | 8.7089 | 8.675 | 8.6789 | 684124.0 |
| 2010-07-20 08:10:00 | AAPL | Stock | 8.6825 | 8.6825 | 8.6382 | 8.6393 | 557956.0 |
| 2010-07-20 08:15:00 | AAPL | Stock | 8.6604 | 8.6604 | 8.6289 | 8.6375 | 302540.0 |
| 2010-07-20 08:20:00 | AAPL | Stock | 8.6379 | 8.6607 | 8.6311 | 8.6429 | 222936.0 |
| 2010-07-20 08:25:00 | AAPL | Stock | 8.6446 | 8.6468 | 8.6357 | 8.6429 | 165760.0 |
| 2010-07-20 08:30:00 | AAPL | Stock | 8.6432 | 8.6611 | 8.6429 | 8.6536 | 650636.0 |
| 2010-07-20 08:35:00 | AAPL | Stock | 8.6532 | 8.6564 | 8.6504 | 8.6532 | 508172.0 |
| 2010-07-20 08:40:00 | AAPL | Stock | 8.6536 | 8.6611 | 8.6536 | 8.6571 | 324240.0 |
| 2010-07-20 08:45:00 | AAPL | Stock | 8.6589 | 8.6589 | 8.6429 | 8.6554 | 347396.0 |
| 2010-07-20 08:50:00 | AAPL | Stock | 8.6539 | 8.6546 | 8.6429 | 8.6482 | 249900.0 |
| 2010-07-20 08:55:00 | AAPL | Stock | 8.6479 | 8.6482 | 8.6429 | 8.6432 | 245924.0 |
| 2010-07-20 09:00:00 | AAPL | Stock | 8.6457 | 8.6482 | 8.6429 | 8.6479 | 336000.0 |
| 2010-07-20 09:05:00 | AAPL | Stock | 8.6475 | 8.6532 | 8.6429 | 8.6464 | 662032.0 |
| 2010-07-20 09:10:00 | AAPL | Stock | 8.6471 | 8.6486 | 8.64 | 8.6486 | 374052.0 |
| 2010-07-20 09:15:00 | AAPL | Stock | 8.6479 | 8.6661 | 8.6431 | 8.6661 | 349384.0 |
| 2010-07-20 09:20:00 | AAPL | Stock | 8.6639 | 8.6743 | 8.6621 | 8.6661 | 240408.0 |
| 2010-07-20 09:25:00 | AAPL | Stock | 8.6596 | 8.68 | 8.6589 | 8.6782 | 355432.0 |
| 2010-07-20 09:30:00 | AAPL | Stock | 8.675 | 8.6854 | 8.6129 | 8.6396 | 23400244.0 |
| 2010-07-20 09:35:00 | AAPL | Stock | 8.6404 | 8.6525 | 8.5854 | 8.6121 | 24295600.0 |
| 2010-07-20 09:40:00 | AAPL | Stock | 8.6139 | 8.6214 | 8.5896 | 8.5936 | 16629676.0 |
| 2010-07-20 09:45:00 | AAPL | Stock | 8.5936 | 8.6161 | 8.5718 | 8.5886 | 20308904.0 |
| 2010-07-20 09:50:00 | AAPL | Stock | 8.5875 | 8.6464 | 8.5832 | 8.6432 | 18343696.0 |
| 2010-07-20 09:55:00 | AAPL | Stock | 8.6429 | 8.6557 | 8.6282 | 8.6475 | 13216672.0 |
| 2010-07-20 10:00:00 | AAPL | Stock | 8.6475 | 8.6554 | 8.6332 | 8.6407 | 11393956.0 |
| 2010-07-20 10:05:00 | AAPL | Stock | 8.6407 | 8.6664 | 8.6357 | 8.6536 | 12189716.0 |
| 2010-07-20 10:10:00 | AAPL | Stock | 8.6554 | 8.6921 | 8.6486 | 8.6611 | 15136212.0 |
| 2010-07-20 10:15:00 | AAPL | Stock | 8.6625 | 8.6914 | 8.6596 | 8.6907 | 12296508.0 |
| 2010-07-20 10:20:00 | AAPL | Stock | 8.6889 | 8.6911 | 8.6693 | 8.683 | 11221812.0 |
> showing 50 of 314,431 rows — these rows as CSV