PREVIEW / stock_1min / 2010-04-09
file: by_date/stock_1min/2010/2010-04-09.parquet size: 12.4 MB rows: 934,627 symbols: 2,825
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-09 04:15:00 | AAPL | Stock | 8.5893 | 8.6036 | 8.5893 | 8.6036 | 22400.0 |
| 2010-04-09 04:19:00 | AAPL | Stock | 8.6071 | 8.6071 | 8.6071 | 8.6071 | 5600.0 |
| 2010-04-09 04:40:00 | AAPL | Stock | 8.6304 | 8.6304 | 8.6304 | 8.6304 | 5600.0 |
| 2010-04-09 05:14:00 | AAPL | Stock | 8.6418 | 8.6507 | 8.6418 | 8.6507 | 11200.0 |
| 2010-04-09 05:15:00 | AAPL | Stock | 8.6646 | 8.6646 | 8.6646 | 8.6646 | 8400.0 |
| 2010-04-09 05:16:00 | AAPL | Stock | 8.6643 | 8.6643 | 8.6643 | 8.6643 | 2800.0 |
| 2010-04-09 06:00:00 | AAPL | Stock | 8.6357 | 8.6357 | 8.6357 | 8.6357 | 8400.0 |
| 2010-04-09 06:02:00 | AAPL | Stock | 8.6464 | 8.6464 | 8.6464 | 8.6464 | 5600.0 |
| 2010-04-09 06:07:00 | AAPL | Stock | 8.6464 | 8.6464 | 8.6464 | 8.6464 | 6384.0 |
| 2010-04-09 06:08:00 | AAPL | Stock | 8.6511 | 8.6511 | 8.6511 | 8.6511 | 2800.0 |
| 2010-04-09 07:01:00 | AAPL | Stock | 8.6429 | 8.6429 | 8.6429 | 8.6429 | 19600.0 |
| 2010-04-09 07:02:00 | AAPL | Stock | 8.6429 | 8.6511 | 8.6429 | 8.6511 | 22400.0 |
| 2010-04-09 07:06:00 | AAPL | Stock | 8.6425 | 8.6425 | 8.6425 | 8.6425 | 2800.0 |
| 2010-04-09 07:07:00 | AAPL | Stock | 8.6507 | 8.6511 | 8.6425 | 8.6425 | 33600.0 |
| 2010-04-09 07:08:00 | AAPL | Stock | 8.6425 | 8.6425 | 8.6425 | 8.6425 | 3528.0 |
| 2010-04-09 07:09:00 | AAPL | Stock | 8.6425 | 8.6425 | 8.6425 | 8.6425 | 2800.0 |
| 2010-04-09 07:10:00 | AAPL | Stock | 8.6393 | 8.6393 | 8.6375 | 8.6375 | 5600.0 |
| 2010-04-09 07:11:00 | AAPL | Stock | 8.6407 | 8.6411 | 8.6375 | 8.6375 | 42700.0 |
| 2010-04-09 07:12:00 | AAPL | Stock | 8.6361 | 8.6361 | 8.6361 | 8.6361 | 14000.0 |
| 2010-04-09 07:15:00 | AAPL | Stock | 8.6361 | 8.6361 | 8.6357 | 8.6357 | 16800.0 |
| 2010-04-09 07:16:00 | AAPL | Stock | 8.6357 | 8.6357 | 8.6357 | 8.6357 | 2800.0 |
| 2010-04-09 07:17:00 | AAPL | Stock | 8.6404 | 8.6404 | 8.6404 | 8.6404 | 3752.0 |
| 2010-04-09 07:20:00 | AAPL | Stock | 8.64 | 8.64 | 8.6361 | 8.6361 | 11088.0 |
| 2010-04-09 07:21:00 | AAPL | Stock | 8.6361 | 8.6361 | 8.6339 | 8.6339 | 17500.0 |
| 2010-04-09 07:25:00 | AAPL | Stock | 8.6321 | 8.6321 | 8.6275 | 8.6275 | 8400.0 |
| 2010-04-09 07:28:00 | AAPL | Stock | 8.6286 | 8.6286 | 8.625 | 8.625 | 47600.0 |
| 2010-04-09 07:32:00 | AAPL | Stock | 8.6321 | 8.6321 | 8.6321 | 8.6321 | 8400.0 |
| 2010-04-09 07:39:00 | AAPL | Stock | 8.6321 | 8.635 | 8.6321 | 8.635 | 13384.0 |
| 2010-04-09 07:40:00 | AAPL | Stock | 8.635 | 8.635 | 8.635 | 8.635 | 16968.0 |
| 2010-04-09 07:43:00 | AAPL | Stock | 8.6339 | 8.6339 | 8.6339 | 8.6339 | 2800.0 |
| 2010-04-09 07:44:00 | AAPL | Stock | 8.6339 | 8.6339 | 8.6339 | 8.6339 | 14000.0 |
| 2010-04-09 07:47:00 | AAPL | Stock | 8.6286 | 8.6286 | 8.6286 | 8.6286 | 5600.0 |
| 2010-04-09 07:48:00 | AAPL | Stock | 8.6286 | 8.6286 | 8.625 | 8.6282 | 20860.0 |
| 2010-04-09 07:49:00 | AAPL | Stock | 8.625 | 8.625 | 8.625 | 8.625 | 41076.0 |
| 2010-04-09 07:50:00 | AAPL | Stock | 8.625 | 8.625 | 8.625 | 8.625 | 26124.0 |
| 2010-04-09 07:53:00 | AAPL | Stock | 8.6279 | 8.6279 | 8.6279 | 8.6279 | 2800.0 |
| 2010-04-09 07:54:00 | AAPL | Stock | 8.6321 | 8.6321 | 8.6279 | 8.6279 | 13440.0 |
| 2010-04-09 07:55:00 | AAPL | Stock | 8.6279 | 8.6279 | 8.6279 | 8.6279 | 5600.0 |
| 2010-04-09 07:57:00 | AAPL | Stock | 8.6268 | 8.6279 | 8.6268 | 8.6279 | 14000.0 |
| 2010-04-09 07:59:00 | AAPL | Stock | 8.625 | 8.625 | 8.625 | 8.625 | 7000.0 |
| 2010-04-09 08:00:00 | AAPL | Stock | 8.6232 | 8.625 | 8.6064 | 8.6125 | 150164.0 |
| 2010-04-09 08:01:00 | AAPL | Stock | 8.6071 | 8.6104 | 8.6064 | 8.6104 | 77476.0 |
| 2010-04-09 08:02:00 | AAPL | Stock | 8.6107 | 8.6118 | 8.6107 | 8.6118 | 44800.0 |
| 2010-04-09 08:03:00 | AAPL | Stock | 8.6118 | 8.6161 | 8.6118 | 8.6143 | 75096.0 |
| 2010-04-09 08:04:00 | AAPL | Stock | 8.6175 | 8.6179 | 8.6139 | 8.6161 | 98000.0 |
| 2010-04-09 08:05:00 | AAPL | Stock | 8.6132 | 8.6161 | 8.6132 | 8.6161 | 56112.0 |
| 2010-04-09 08:06:00 | AAPL | Stock | 8.6161 | 8.6161 | 8.6136 | 8.6136 | 30800.0 |
| 2010-04-09 08:07:00 | AAPL | Stock | 8.6125 | 8.6125 | 8.6107 | 8.6107 | 36400.0 |
| 2010-04-09 08:08:00 | AAPL | Stock | 8.6093 | 8.6093 | 8.6089 | 8.6089 | 19600.0 |
| 2010-04-09 08:09:00 | AAPL | Stock | 8.6107 | 8.6121 | 8.6107 | 8.6121 | 43540.0 |
> showing 50 of 934,627 rows — these rows as CSV