PREVIEW / stock_5min / 2008-11-24
file: by_date/stock_5min/2008/2008-11-24.parquet size: 4.6 MB rows: 331,222 symbols: 3,377
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-11-24 06:35:00 | AAPL | Stock | 2.9679 | 2.9679 | 2.9679 | 2.9679 | 2800.0 |
| 2008-11-24 07:00:00 | AAPL | Stock | 3.0 | 3.0089 | 3.0 | 3.0089 | 49560.0 |
| 2008-11-24 07:05:00 | AAPL | Stock | 3.0089 | 3.0143 | 3.0089 | 3.0143 | 30800.0 |
| 2008-11-24 07:10:00 | AAPL | Stock | 3.0146 | 3.0357 | 3.0143 | 3.0357 | 155680.0 |
| 2008-11-24 07:15:00 | AAPL | Stock | 3.035 | 3.0357 | 3.035 | 3.0354 | 94724.0 |
| 2008-11-24 07:20:00 | AAPL | Stock | 3.0111 | 3.0111 | 3.0089 | 3.0089 | 8400.0 |
| 2008-11-24 07:30:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 49280.0 |
| 2008-11-24 07:35:00 | AAPL | Stock | 3.0089 | 3.0089 | 2.9954 | 2.9954 | 10780.0 |
| 2008-11-24 07:45:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 5600.0 |
| 2008-11-24 07:50:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 8400.0 |
| 2008-11-24 07:55:00 | AAPL | Stock | 3.0071 | 3.0071 | 3.0071 | 3.0071 | 19600.0 |
| 2008-11-24 08:00:00 | AAPL | Stock | 3.0071 | 3.0157 | 2.9911 | 2.9964 | 256284.0 |
| 2008-11-24 08:05:00 | AAPL | Stock | 2.9989 | 2.9993 | 2.9911 | 2.9954 | 113204.0 |
| 2008-11-24 08:10:00 | AAPL | Stock | 3.0 | 3.0107 | 3.0 | 3.0107 | 178136.0 |
| 2008-11-24 08:15:00 | AAPL | Stock | 3.0107 | 3.0107 | 3.0 | 3.0 | 43120.0 |
| 2008-11-24 08:20:00 | AAPL | Stock | 2.9968 | 3.0107 | 2.9968 | 3.0107 | 207564.0 |
| 2008-11-24 08:25:00 | AAPL | Stock | 3.0075 | 3.015 | 3.0071 | 3.0121 | 334796.0 |
| 2008-11-24 08:30:00 | AAPL | Stock | 3.01 | 3.0125 | 3.0064 | 3.0089 | 126644.0 |
| 2008-11-24 08:35:00 | AAPL | Stock | 3.0079 | 3.0089 | 3.0 | 3.0 | 263200.0 |
| 2008-11-24 08:40:00 | AAPL | Stock | 3.0004 | 3.0029 | 2.9929 | 2.9929 | 216580.0 |
| 2008-11-24 08:45:00 | AAPL | Stock | 2.9946 | 3.0121 | 2.9946 | 3.0121 | 301560.0 |
| 2008-11-24 08:50:00 | AAPL | Stock | 3.0118 | 3.0118 | 3.0004 | 3.0064 | 91700.0 |
| 2008-11-24 08:55:00 | AAPL | Stock | 3.0064 | 3.0089 | 3.0064 | 3.0089 | 100800.0 |
| 2008-11-24 09:00:00 | AAPL | Stock | 3.0082 | 3.0118 | 3.0071 | 3.01 | 60480.0 |
| 2008-11-24 09:05:00 | AAPL | Stock | 3.0082 | 3.0107 | 3.0082 | 3.0107 | 43876.0 |
| 2008-11-24 09:10:00 | AAPL | Stock | 3.0089 | 3.0114 | 3.0071 | 3.0089 | 162820.0 |
| 2008-11-24 09:15:00 | AAPL | Stock | 3.0089 | 3.0175 | 3.0079 | 3.0175 | 357168.0 |
| 2008-11-24 09:20:00 | AAPL | Stock | 3.0129 | 3.0318 | 3.0125 | 3.0286 | 886928.0 |
| 2008-11-24 09:25:00 | AAPL | Stock | 3.0286 | 3.0432 | 3.025 | 3.0407 | 1196776.0 |
| 2008-11-24 09:30:00 | AAPL | Stock | 3.0432 | 3.0814 | 3.0393 | 3.0711 | 34159748.0 |
| 2008-11-24 09:35:00 | AAPL | Stock | 3.0711 | 3.0982 | 3.0671 | 3.0775 | 32209408.0 |
| 2008-11-24 09:40:00 | AAPL | Stock | 3.0775 | 3.0789 | 3.0507 | 3.0618 | 26284720.0 |
| 2008-11-24 09:45:00 | AAPL | Stock | 3.0618 | 3.0707 | 3.0364 | 3.0457 | 23771244.0 |
| 2008-11-24 09:50:00 | AAPL | Stock | 3.0457 | 3.0493 | 3.03 | 3.0446 | 23696036.0 |
| 2008-11-24 09:55:00 | AAPL | Stock | 3.045 | 3.0654 | 3.035 | 3.0618 | 18075176.0 |
| 2008-11-24 10:00:00 | AAPL | Stock | 3.0618 | 3.08 | 3.0589 | 3.0766 | 19724740.0 |
| 2008-11-24 10:05:00 | AAPL | Stock | 3.0768 | 3.0821 | 3.0589 | 3.0811 | 20266064.0 |
| 2008-11-24 10:10:00 | AAPL | Stock | 3.0821 | 3.0929 | 3.0811 | 3.0929 | 16967300.0 |
| 2008-11-24 10:15:00 | AAPL | Stock | 3.0925 | 3.1211 | 3.0925 | 3.117 | 28493696.0 |
| 2008-11-24 10:20:00 | AAPL | Stock | 3.1171 | 3.1439 | 3.1143 | 3.1429 | 29210076.0 |
| 2008-11-24 10:25:00 | AAPL | Stock | 3.1429 | 3.1764 | 3.1418 | 3.1682 | 27430984.0 |
| 2008-11-24 10:30:00 | AAPL | Stock | 3.1693 | 3.195 | 3.1664 | 3.1882 | 30618728.0 |
| 2008-11-24 10:35:00 | AAPL | Stock | 3.1886 | 3.1925 | 3.1714 | 3.1771 | 24967684.0 |
| 2008-11-24 10:40:00 | AAPL | Stock | 3.1779 | 3.1929 | 3.1668 | 3.1921 | 18672724.0 |
| 2008-11-24 10:45:00 | AAPL | Stock | 3.1921 | 3.1946 | 3.1614 | 3.1614 | 20389488.0 |
| 2008-11-24 10:50:00 | AAPL | Stock | 3.1618 | 3.1846 | 3.1614 | 3.1764 | 17857952.0 |
| 2008-11-24 10:55:00 | AAPL | Stock | 3.1764 | 3.2054 | 3.1721 | 3.2039 | 17587332.0 |
| 2008-11-24 11:00:00 | AAPL | Stock | 3.2039 | 3.2136 | 3.1889 | 3.1896 | 17160136.0 |
| 2008-11-24 11:05:00 | AAPL | Stock | 3.1896 | 3.1961 | 3.1743 | 3.1821 | 13642664.0 |
| 2008-11-24 11:10:00 | AAPL | Stock | 3.1807 | 3.195 | 3.1743 | 3.1929 | 11219880.0 |
> showing 50 of 331,222 rows — these rows as CSV