PREVIEW / stock_1min / 2007-02-20
file: by_date/stock_1min/2007/2007-02-20.parquet size: 9.6 MB rows: 775,873 symbols: 2,070
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-20 06:44:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0304 | 3.0304 | 11200.0 |
| 2007-02-20 08:00:00 | AAPL | Stock | 3.0296 | 3.0296 | 3.0296 | 3.0296 | 2800.0 |
| 2007-02-20 08:05:00 | AAPL | Stock | 3.025 | 3.025 | 3.025 | 3.025 | 21504.0 |
| 2007-02-20 08:06:00 | AAPL | Stock | 3.0243 | 3.0243 | 3.0193 | 3.0232 | 51940.0 |
| 2007-02-20 08:23:00 | AAPL | Stock | 3.0268 | 3.0268 | 3.0268 | 3.0268 | 2800.0 |
| 2007-02-20 08:24:00 | AAPL | Stock | 3.0296 | 3.0296 | 3.0296 | 3.0296 | 2800.0 |
| 2007-02-20 08:30:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 2800.0 |
| 2007-02-20 08:31:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 14000.0 |
| 2007-02-20 08:34:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 28000.0 |
| 2007-02-20 08:39:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0296 | 3.0296 | 32200.0 |
| 2007-02-20 08:40:00 | AAPL | Stock | 3.0321 | 3.0346 | 3.0321 | 3.0346 | 16800.0 |
| 2007-02-20 08:41:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 15400.0 |
| 2007-02-20 08:42:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 2800.0 |
| 2007-02-20 08:48:00 | AAPL | Stock | 3.0325 | 3.0325 | 3.0325 | 3.0325 | 2800.0 |
| 2007-02-20 08:50:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 21000.0 |
| 2007-02-20 08:51:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 7000.0 |
| 2007-02-20 08:52:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 14000.0 |
| 2007-02-20 08:54:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 2800.0 |
| 2007-02-20 08:55:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 14000.0 |
| 2007-02-20 08:57:00 | AAPL | Stock | 3.0296 | 3.0296 | 3.0296 | 3.0296 | 4200.0 |
| 2007-02-20 08:58:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 23884.0 |
| 2007-02-20 08:59:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 156800.0 |
| 2007-02-20 09:00:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 89516.0 |
| 2007-02-20 09:03:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0304 | 3.0304 | 2800.0 |
| 2007-02-20 09:05:00 | AAPL | Stock | 3.0289 | 3.0289 | 3.0261 | 3.0261 | 65968.0 |
| 2007-02-20 09:06:00 | AAPL | Stock | 3.0254 | 3.0254 | 3.0214 | 3.0232 | 39200.0 |
| 2007-02-20 09:07:00 | AAPL | Stock | 3.0229 | 3.0286 | 3.0229 | 3.0268 | 25200.0 |
| 2007-02-20 09:09:00 | AAPL | Stock | 3.0304 | 3.0318 | 3.0304 | 3.0318 | 6580.0 |
| 2007-02-20 09:11:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0261 | 3.0261 | 14000.0 |
| 2007-02-20 09:13:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0261 | 3.0261 | 16800.0 |
| 2007-02-20 09:14:00 | AAPL | Stock | 3.0257 | 3.0261 | 3.0257 | 3.0261 | 33936.0 |
| 2007-02-20 09:15:00 | AAPL | Stock | 3.0268 | 3.0304 | 3.0268 | 3.0304 | 28000.0 |
| 2007-02-20 09:17:00 | AAPL | Stock | 3.0321 | 3.0339 | 3.0321 | 3.0339 | 14000.0 |
| 2007-02-20 09:18:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 19600.0 |
| 2007-02-20 09:19:00 | AAPL | Stock | 3.0339 | 3.035 | 3.0339 | 3.035 | 47600.0 |
| 2007-02-20 09:21:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 28000.0 |
| 2007-02-20 09:23:00 | AAPL | Stock | 3.0264 | 3.0264 | 3.0264 | 3.0264 | 25200.0 |
| 2007-02-20 09:24:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0261 | 3.0261 | 56000.0 |
| 2007-02-20 09:25:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.025 | 3.025 | 28000.0 |
| 2007-02-20 09:26:00 | AAPL | Stock | 3.025 | 3.025 | 3.025 | 3.025 | 2800.0 |
| 2007-02-20 09:27:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0261 | 3.0261 | 19600.0 |
| 2007-02-20 09:28:00 | AAPL | Stock | 3.0254 | 3.0254 | 3.0196 | 3.02 | 162400.0 |
| 2007-02-20 09:29:00 | AAPL | Stock | 3.0229 | 3.0232 | 3.0196 | 3.0232 | 136920.0 |
| 2007-02-20 09:30:00 | AAPL | Stock | 3.0232 | 3.025 | 3.015 | 3.0154 | 9128056.0 |
| 2007-02-20 09:31:00 | AAPL | Stock | 3.0154 | 3.0214 | 3.0057 | 3.0136 | 3311056.0 |
| 2007-02-20 09:32:00 | AAPL | Stock | 3.0136 | 3.0193 | 3.0071 | 3.0168 | 2588964.0 |
| 2007-02-20 09:33:00 | AAPL | Stock | 3.0168 | 3.0175 | 3.0118 | 3.0139 | 1833636.0 |
| 2007-02-20 09:34:00 | AAPL | Stock | 3.0139 | 3.0174 | 3.0125 | 3.0143 | 1584632.0 |
| 2007-02-20 09:35:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0121 | 3.0132 | 1543808.0 |
| 2007-02-20 09:36:00 | AAPL | Stock | 3.0129 | 3.0143 | 3.0118 | 3.0118 | 1343412.0 |
> showing 50 of 775,873 rows — these rows as CSV