PREVIEW / stock_5min / 2008-01-30
file: by_date/stock_5min/2008/2008-01-30.parquet size: 4.4 MB rows: 321,668 symbols: 3,269
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-01-30 04:35:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 4200.0 |
| 2008-01-30 05:00:00 | AAPL | Stock | 4.6761 | 4.6761 | 4.6761 | 4.6761 | 5600.0 |
| 2008-01-30 06:40:00 | AAPL | Stock | 4.6886 | 4.6886 | 4.6886 | 4.6886 | 2800.0 |
| 2008-01-30 06:45:00 | AAPL | Stock | 4.6893 | 4.6964 | 4.6893 | 4.6964 | 27384.0 |
| 2008-01-30 06:55:00 | AAPL | Stock | 4.6896 | 4.6896 | 4.6786 | 4.6786 | 13216.0 |
| 2008-01-30 07:10:00 | AAPL | Stock | 4.6821 | 4.6821 | 4.6821 | 4.6821 | 5600.0 |
| 2008-01-30 07:20:00 | AAPL | Stock | 4.6714 | 4.6714 | 4.6714 | 4.6714 | 5600.0 |
| 2008-01-30 07:25:00 | AAPL | Stock | 4.6704 | 4.6704 | 4.6696 | 4.6696 | 16800.0 |
| 2008-01-30 07:30:00 | AAPL | Stock | 4.6696 | 4.6714 | 4.6696 | 4.6714 | 11200.0 |
| 2008-01-30 07:45:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 5012.0 |
| 2008-01-30 07:55:00 | AAPL | Stock | 4.6854 | 4.6893 | 4.6786 | 4.6786 | 78456.0 |
| 2008-01-30 08:00:00 | AAPL | Stock | 4.6786 | 4.6854 | 4.675 | 4.6854 | 201404.0 |
| 2008-01-30 08:05:00 | AAPL | Stock | 4.6821 | 4.6946 | 4.6786 | 4.6825 | 279832.0 |
| 2008-01-30 08:10:00 | AAPL | Stock | 4.6829 | 4.6857 | 4.6821 | 4.6821 | 60200.0 |
| 2008-01-30 08:15:00 | AAPL | Stock | 4.6857 | 4.6961 | 4.6779 | 4.6882 | 260596.0 |
| 2008-01-30 08:20:00 | AAPL | Stock | 4.6879 | 4.6979 | 4.6846 | 4.6886 | 250600.0 |
| 2008-01-30 08:25:00 | AAPL | Stock | 4.6886 | 4.7014 | 4.6886 | 4.6982 | 275100.0 |
| 2008-01-30 08:30:00 | AAPL | Stock | 4.6964 | 4.6982 | 4.6821 | 4.6861 | 381220.0 |
| 2008-01-30 08:35:00 | AAPL | Stock | 4.6854 | 4.6982 | 4.6854 | 4.6929 | 185024.0 |
| 2008-01-30 08:40:00 | AAPL | Stock | 4.6929 | 4.6964 | 4.6868 | 4.6964 | 57400.0 |
| 2008-01-30 08:45:00 | AAPL | Stock | 4.6971 | 4.6986 | 4.6911 | 4.6911 | 133700.0 |
| 2008-01-30 08:50:00 | AAPL | Stock | 4.6879 | 4.6879 | 4.6843 | 4.6857 | 126140.0 |
| 2008-01-30 08:55:00 | AAPL | Stock | 4.6857 | 4.6875 | 4.6821 | 4.6821 | 251020.0 |
| 2008-01-30 09:00:00 | AAPL | Stock | 4.6839 | 4.6893 | 4.6839 | 4.6893 | 132496.0 |
| 2008-01-30 09:05:00 | AAPL | Stock | 4.6911 | 4.6911 | 4.6882 | 4.6886 | 80556.0 |
| 2008-01-30 09:10:00 | AAPL | Stock | 4.6893 | 4.6982 | 4.6882 | 4.6957 | 253960.0 |
| 2008-01-30 09:15:00 | AAPL | Stock | 4.6957 | 4.6982 | 4.6879 | 4.6879 | 117740.0 |
| 2008-01-30 09:20:00 | AAPL | Stock | 4.6896 | 4.6911 | 4.6879 | 4.6893 | 172172.0 |
| 2008-01-30 09:25:00 | AAPL | Stock | 4.6904 | 4.7007 | 4.6879 | 4.6929 | 448000.0 |
| 2008-01-30 09:30:00 | AAPL | Stock | 4.6929 | 4.7232 | 4.6807 | 4.6839 | 27689256.0 |
| 2008-01-30 09:35:00 | AAPL | Stock | 4.6832 | 4.69 | 4.6579 | 4.6686 | 21620200.0 |
| 2008-01-30 09:40:00 | AAPL | Stock | 4.6693 | 4.6893 | 4.6646 | 4.6789 | 16795492.0 |
| 2008-01-30 09:45:00 | AAPL | Stock | 4.6793 | 4.6836 | 4.6521 | 4.6564 | 15560916.0 |
| 2008-01-30 09:50:00 | AAPL | Stock | 4.6564 | 4.6861 | 4.6518 | 4.6825 | 22932140.0 |
| 2008-01-30 09:55:00 | AAPL | Stock | 4.6821 | 4.6839 | 4.6593 | 4.6754 | 15190784.0 |
| 2008-01-30 10:00:00 | AAPL | Stock | 4.675 | 4.685 | 4.6675 | 4.6679 | 13954416.0 |
| 2008-01-30 10:05:00 | AAPL | Stock | 4.6689 | 4.6693 | 4.6461 | 4.6625 | 19587568.0 |
| 2008-01-30 10:10:00 | AAPL | Stock | 4.6625 | 4.675 | 4.6539 | 4.6646 | 18265940.0 |
| 2008-01-30 10:15:00 | AAPL | Stock | 4.6646 | 4.6707 | 4.6579 | 4.6658 | 12446056.0 |
| 2008-01-30 10:20:00 | AAPL | Stock | 4.665 | 4.6854 | 4.6632 | 4.6802 | 18949756.0 |
| 2008-01-30 10:25:00 | AAPL | Stock | 4.6804 | 4.6868 | 4.6725 | 4.6785 | 10834264.0 |
| 2008-01-30 10:30:00 | AAPL | Stock | 4.6782 | 4.6832 | 4.6732 | 4.6761 | 9306668.0 |
| 2008-01-30 10:35:00 | AAPL | Stock | 4.6761 | 4.6821 | 4.6429 | 4.6746 | 9847096.0 |
| 2008-01-30 10:40:00 | AAPL | Stock | 4.6746 | 4.6946 | 4.6743 | 4.6936 | 15369956.0 |
| 2008-01-30 10:45:00 | AAPL | Stock | 4.6932 | 4.6986 | 4.6882 | 4.6943 | 12390364.0 |
| 2008-01-30 10:50:00 | AAPL | Stock | 4.6939 | 4.7196 | 4.6886 | 4.7132 | 20126400.0 |
| 2008-01-30 10:55:00 | AAPL | Stock | 4.7129 | 4.7154 | 4.7061 | 4.7118 | 13166104.0 |
| 2008-01-30 11:00:00 | AAPL | Stock | 4.7121 | 4.7321 | 4.7096 | 4.7096 | 14929404.0 |
| 2008-01-30 11:05:00 | AAPL | Stock | 4.7096 | 4.7114 | 4.7032 | 4.7096 | 10742788.0 |
| 2008-01-30 11:10:00 | AAPL | Stock | 4.7086 | 4.7096 | 4.7032 | 4.7086 | 6863696.0 |
> showing 50 of 321,668 rows — these rows as CSV