PREVIEW / stock_1min / 2008-08-01
file: by_date/stock_1min/2008/2008-08-01.parquet size: 12.4 MB rows: 998,167 symbols: 2,683
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-08-01 06:50:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6786 | 5.6786 | 5600.0 |
| 2008-08-01 08:07:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6786 | 5.6786 | 3276.0 |
| 2008-08-01 08:09:00 | AAPL | Stock | 5.6782 | 5.6782 | 5.6782 | 5.6782 | 7000.0 |
| 2008-08-01 08:11:00 | AAPL | Stock | 5.6632 | 5.6786 | 5.6632 | 5.6786 | 19600.0 |
| 2008-08-01 08:12:00 | AAPL | Stock | 5.6768 | 5.6768 | 5.6768 | 5.6768 | 635600.0 |
| 2008-08-01 08:16:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6786 | 5.6786 | 15960.0 |
| 2008-08-01 08:18:00 | AAPL | Stock | 5.6779 | 5.6786 | 5.6779 | 5.6786 | 19320.0 |
| 2008-08-01 08:20:00 | AAPL | Stock | 5.6782 | 5.6782 | 5.6782 | 5.6782 | 5600.0 |
| 2008-08-01 08:21:00 | AAPL | Stock | 5.6686 | 5.6686 | 5.6686 | 5.6686 | 11200.0 |
| 2008-08-01 08:22:00 | AAPL | Stock | 5.6718 | 5.6718 | 5.6714 | 5.6714 | 11200.0 |
| 2008-08-01 08:23:00 | AAPL | Stock | 5.6714 | 5.6714 | 5.6714 | 5.6714 | 75600.0 |
| 2008-08-01 08:24:00 | AAPL | Stock | 5.6746 | 5.6786 | 5.6746 | 5.6786 | 47180.0 |
| 2008-08-01 08:25:00 | AAPL | Stock | 5.6746 | 5.6746 | 5.6746 | 5.6746 | 11200.0 |
| 2008-08-01 08:26:00 | AAPL | Stock | 5.6686 | 5.6686 | 5.6632 | 5.6632 | 8400.0 |
| 2008-08-01 08:27:00 | AAPL | Stock | 5.6746 | 5.6786 | 5.6682 | 5.6786 | 76496.0 |
| 2008-08-01 08:28:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6782 | 5.6782 | 30800.0 |
| 2008-08-01 08:29:00 | AAPL | Stock | 5.6718 | 5.6718 | 5.6718 | 5.6718 | 2800.0 |
| 2008-08-01 08:30:00 | AAPL | Stock | 5.6779 | 5.7321 | 5.6779 | 5.7175 | 539168.0 |
| 2008-08-01 08:31:00 | AAPL | Stock | 5.7182 | 5.7239 | 5.71 | 5.7179 | 867272.0 |
| 2008-08-01 08:32:00 | AAPL | Stock | 5.7186 | 5.7232 | 5.7125 | 5.7214 | 285600.0 |
| 2008-08-01 08:33:00 | AAPL | Stock | 5.7214 | 5.7421 | 5.7214 | 5.73 | 492520.0 |
| 2008-08-01 08:34:00 | AAPL | Stock | 5.7304 | 5.7386 | 5.7264 | 5.7357 | 396424.0 |
| 2008-08-01 08:35:00 | AAPL | Stock | 5.7325 | 5.735 | 5.7239 | 5.7275 | 92400.0 |
| 2008-08-01 08:36:00 | AAPL | Stock | 5.7257 | 5.7257 | 5.72 | 5.72 | 339920.0 |
| 2008-08-01 08:37:00 | AAPL | Stock | 5.72 | 5.7214 | 5.7143 | 5.7214 | 176400.0 |
| 2008-08-01 08:38:00 | AAPL | Stock | 5.7232 | 5.7232 | 5.7186 | 5.7186 | 37800.0 |
| 2008-08-01 08:39:00 | AAPL | Stock | 5.7211 | 5.7211 | 5.7211 | 5.7211 | 2800.0 |
| 2008-08-01 08:40:00 | AAPL | Stock | 5.7193 | 5.7225 | 5.7189 | 5.7225 | 22400.0 |
| 2008-08-01 08:41:00 | AAPL | Stock | 5.7214 | 5.725 | 5.7214 | 5.7246 | 83384.0 |
| 2008-08-01 08:42:00 | AAPL | Stock | 5.7221 | 5.7268 | 5.7221 | 5.7268 | 67200.0 |
| 2008-08-01 08:43:00 | AAPL | Stock | 5.7264 | 5.7268 | 5.7186 | 5.7186 | 30800.0 |
| 2008-08-01 08:44:00 | AAPL | Stock | 5.7186 | 5.7218 | 5.7125 | 5.7125 | 89516.0 |
| 2008-08-01 08:45:00 | AAPL | Stock | 5.7096 | 5.7096 | 5.7089 | 5.7089 | 5600.0 |
| 2008-08-01 08:46:00 | AAPL | Stock | 5.7139 | 5.7261 | 5.7107 | 5.7143 | 162400.0 |
| 2008-08-01 08:47:00 | AAPL | Stock | 5.7143 | 5.7146 | 5.7125 | 5.7143 | 61600.0 |
| 2008-08-01 08:49:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7143 | 5.7143 | 36400.0 |
| 2008-08-01 08:50:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.6768 | 5.7143 | 119000.0 |
| 2008-08-01 08:51:00 | AAPL | Stock | 5.7111 | 5.7143 | 5.7071 | 5.7143 | 118832.0 |
| 2008-08-01 08:52:00 | AAPL | Stock | 5.7071 | 5.7071 | 5.7071 | 5.7071 | 2800.0 |
| 2008-08-01 08:53:00 | AAPL | Stock | 5.7125 | 5.7125 | 5.7125 | 5.7125 | 23800.0 |
| 2008-08-01 08:56:00 | AAPL | Stock | 5.7107 | 5.7107 | 5.7107 | 5.7107 | 28000.0 |
| 2008-08-01 08:57:00 | AAPL | Stock | 5.7086 | 5.7086 | 5.7086 | 5.7086 | 5600.0 |
| 2008-08-01 09:00:00 | AAPL | Stock | 5.7104 | 5.7125 | 5.7104 | 5.7125 | 68712.0 |
| 2008-08-01 09:01:00 | AAPL | Stock | 5.7139 | 5.7139 | 5.7139 | 5.7139 | 14000.0 |
| 2008-08-01 09:02:00 | AAPL | Stock | 5.7175 | 5.7214 | 5.7175 | 5.7214 | 68600.0 |
| 2008-08-01 09:04:00 | AAPL | Stock | 5.7214 | 5.7214 | 5.7214 | 5.7214 | 2800.0 |
| 2008-08-01 09:05:00 | AAPL | Stock | 5.7211 | 5.7214 | 5.7211 | 5.7211 | 88004.0 |
| 2008-08-01 09:06:00 | AAPL | Stock | 5.7232 | 5.7232 | 5.7214 | 5.7214 | 54320.0 |
| 2008-08-01 09:08:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.71 | 5.71 | 5600.0 |
| 2008-08-01 09:10:00 | AAPL | Stock | 5.7211 | 5.7211 | 5.7129 | 5.7143 | 40880.0 |
> showing 50 of 998,167 rows — these rows as CSV