PREVIEW / stock_1min / 2008-05-15
file: by_date/stock_1min/2008/2008-05-15.parquet size: 12.0 MB rows: 970,328 symbols: 2,691
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-05-15 07:06:00 | AAPL | Stock | 6.6875 | 6.6882 | 6.6875 | 6.6882 | 25200.0 |
| 2008-05-15 07:14:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 28000.0 |
| 2008-05-15 07:16:00 | AAPL | Stock | 6.6961 | 6.6961 | 6.6961 | 6.6961 | 8400.0 |
| 2008-05-15 07:17:00 | AAPL | Stock | 6.6961 | 6.6961 | 6.6961 | 6.6961 | 8400.0 |
| 2008-05-15 07:21:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7036 | 6.7036 | 5600.0 |
| 2008-05-15 07:32:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 8400.0 |
| 2008-05-15 07:33:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6911 | 6.6911 | 9940.0 |
| 2008-05-15 07:35:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6911 | 6.6911 | 14000.0 |
| 2008-05-15 07:37:00 | AAPL | Stock | 6.7014 | 6.7036 | 6.7014 | 6.7036 | 43036.0 |
| 2008-05-15 07:39:00 | AAPL | Stock | 6.7093 | 6.7093 | 6.7093 | 6.7093 | 2800.0 |
| 2008-05-15 07:41:00 | AAPL | Stock | 6.7093 | 6.7096 | 6.7093 | 6.7096 | 14000.0 |
| 2008-05-15 07:44:00 | AAPL | Stock | 6.7061 | 6.7061 | 6.7061 | 6.7061 | 2800.0 |
| 2008-05-15 07:45:00 | AAPL | Stock | 6.7061 | 6.7061 | 6.7061 | 6.7061 | 25200.0 |
| 2008-05-15 07:48:00 | AAPL | Stock | 6.6968 | 6.7061 | 6.6968 | 6.7061 | 5600.0 |
| 2008-05-15 07:49:00 | AAPL | Stock | 6.7061 | 6.7061 | 6.7061 | 6.7061 | 28000.0 |
| 2008-05-15 07:50:00 | AAPL | Stock | 6.7096 | 6.7096 | 6.7096 | 6.7096 | 14000.0 |
| 2008-05-15 07:51:00 | AAPL | Stock | 6.7104 | 6.7143 | 6.7104 | 6.7143 | 16800.0 |
| 2008-05-15 07:52:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7139 | 6.7139 | 19600.0 |
| 2008-05-15 07:53:00 | AAPL | Stock | 6.7036 | 6.7036 | 6.7036 | 6.7036 | 2800.0 |
| 2008-05-15 07:54:00 | AAPL | Stock | 6.7036 | 6.7139 | 6.6964 | 6.7139 | 172760.0 |
| 2008-05-15 07:55:00 | AAPL | Stock | 6.7054 | 6.7143 | 6.7054 | 6.7132 | 69300.0 |
| 2008-05-15 07:56:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7143 | 6.7143 | 2800.0 |
| 2008-05-15 07:57:00 | AAPL | Stock | 6.7061 | 6.7061 | 6.7054 | 6.7054 | 6580.0 |
| 2008-05-15 07:58:00 | AAPL | Stock | 6.7086 | 6.7089 | 6.7086 | 6.7089 | 14000.0 |
| 2008-05-15 07:59:00 | AAPL | Stock | 6.7089 | 6.71 | 6.7089 | 6.71 | 30800.0 |
| 2008-05-15 08:00:00 | AAPL | Stock | 6.7089 | 6.7143 | 6.7036 | 6.7121 | 230860.0 |
| 2008-05-15 08:01:00 | AAPL | Stock | 6.7125 | 6.7139 | 6.7089 | 6.7089 | 52080.0 |
| 2008-05-15 08:02:00 | AAPL | Stock | 6.7107 | 6.7139 | 6.7071 | 6.7107 | 156044.0 |
| 2008-05-15 08:03:00 | AAPL | Stock | 6.7104 | 6.7104 | 6.7071 | 6.7071 | 58156.0 |
| 2008-05-15 08:04:00 | AAPL | Stock | 6.7071 | 6.7143 | 6.7071 | 6.7143 | 451696.0 |
| 2008-05-15 08:05:00 | AAPL | Stock | 6.7143 | 6.7164 | 6.7143 | 6.7164 | 268240.0 |
| 2008-05-15 08:06:00 | AAPL | Stock | 6.7164 | 6.7189 | 6.7121 | 6.7121 | 224084.0 |
| 2008-05-15 08:07:00 | AAPL | Stock | 6.7118 | 6.7118 | 6.7064 | 6.7107 | 174832.0 |
| 2008-05-15 08:08:00 | AAPL | Stock | 6.7107 | 6.7143 | 6.7089 | 6.7111 | 62664.0 |
| 2008-05-15 08:09:00 | AAPL | Stock | 6.7129 | 6.7143 | 6.7104 | 6.7104 | 64400.0 |
| 2008-05-15 08:10:00 | AAPL | Stock | 6.7107 | 6.715 | 6.7104 | 6.7111 | 145320.0 |
| 2008-05-15 08:11:00 | AAPL | Stock | 6.7093 | 6.7093 | 6.7071 | 6.7093 | 106960.0 |
| 2008-05-15 08:12:00 | AAPL | Stock | 6.7086 | 6.7086 | 6.7064 | 6.7064 | 51072.0 |
| 2008-05-15 08:13:00 | AAPL | Stock | 6.7086 | 6.7089 | 6.7071 | 6.7089 | 28000.0 |
| 2008-05-15 08:14:00 | AAPL | Stock | 6.7089 | 6.7121 | 6.7089 | 6.7093 | 155820.0 |
| 2008-05-15 08:15:00 | AAPL | Stock | 6.7089 | 6.7093 | 6.7071 | 6.7071 | 126280.0 |
| 2008-05-15 08:16:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 16800.0 |
| 2008-05-15 08:17:00 | AAPL | Stock | 6.7064 | 6.7064 | 6.7032 | 6.7032 | 116200.0 |
| 2008-05-15 08:18:00 | AAPL | Stock | 6.7036 | 6.7039 | 6.6982 | 6.6982 | 348124.0 |
| 2008-05-15 08:19:00 | AAPL | Stock | 6.7014 | 6.7025 | 6.7004 | 6.7025 | 19936.0 |
| 2008-05-15 08:20:00 | AAPL | Stock | 6.7036 | 6.7036 | 6.7032 | 6.7032 | 19600.0 |
| 2008-05-15 08:21:00 | AAPL | Stock | 6.7032 | 6.7068 | 6.7032 | 6.7068 | 61600.0 |
| 2008-05-15 08:22:00 | AAPL | Stock | 6.7054 | 6.7057 | 6.7036 | 6.7036 | 55160.0 |
| 2008-05-15 08:23:00 | AAPL | Stock | 6.7039 | 6.7057 | 6.7039 | 6.7057 | 53200.0 |
| 2008-05-15 08:24:00 | AAPL | Stock | 6.705 | 6.7061 | 6.7046 | 6.7061 | 19600.0 |
> showing 50 of 970,328 rows — these rows as CSV