PREVIEW / stock_1min / 2006-06-02
file: by_date/stock_1min/2006/2006-06-02.parquet size: 8.7 MB rows: 709,201 symbols: 1,860
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-02 08:02:00 | AAPL | Stock | 2.2279 | 2.2279 | 2.2279 | 2.2279 | 14000.0 |
| 2006-06-02 08:04:00 | AAPL | Stock | 2.225 | 2.225 | 2.2246 | 2.2246 | 14000.0 |
| 2006-06-02 08:05:00 | AAPL | Stock | 2.2246 | 2.2279 | 2.2246 | 2.2279 | 67760.0 |
| 2006-06-02 08:06:00 | AAPL | Stock | 2.2279 | 2.2279 | 2.2279 | 2.2279 | 12432.0 |
| 2006-06-02 08:07:00 | AAPL | Stock | 2.2279 | 2.2304 | 2.2279 | 2.2279 | 53760.0 |
| 2006-06-02 08:08:00 | AAPL | Stock | 2.2279 | 2.2279 | 2.2279 | 2.2279 | 56000.0 |
| 2006-06-02 08:09:00 | AAPL | Stock | 2.2286 | 2.2286 | 2.2286 | 2.2286 | 7000.0 |
| 2006-06-02 08:10:00 | AAPL | Stock | 2.2286 | 2.2304 | 2.2286 | 2.2304 | 89600.0 |
| 2006-06-02 08:11:00 | AAPL | Stock | 2.2304 | 2.2304 | 2.2304 | 2.2304 | 42000.0 |
| 2006-06-02 08:12:00 | AAPL | Stock | 2.2304 | 2.2307 | 2.2304 | 2.2307 | 64400.0 |
| 2006-06-02 08:13:00 | AAPL | Stock | 2.2304 | 2.2304 | 2.2289 | 2.2289 | 36400.0 |
| 2006-06-02 08:15:00 | AAPL | Stock | 2.2296 | 2.2296 | 2.2296 | 2.2296 | 19600.0 |
| 2006-06-02 08:16:00 | AAPL | Stock | 2.2286 | 2.2296 | 2.2279 | 2.2289 | 28000.0 |
| 2006-06-02 08:19:00 | AAPL | Stock | 2.2293 | 2.2293 | 2.2293 | 2.2293 | 5600.0 |
| 2006-06-02 08:21:00 | AAPL | Stock | 2.2289 | 2.2289 | 2.2289 | 2.2289 | 5600.0 |
| 2006-06-02 08:22:00 | AAPL | Stock | 2.2268 | 2.2279 | 2.225 | 2.225 | 125776.0 |
| 2006-06-02 08:23:00 | AAPL | Stock | 2.225 | 2.225 | 2.225 | 2.225 | 47880.0 |
| 2006-06-02 08:24:00 | AAPL | Stock | 2.225 | 2.225 | 2.225 | 2.225 | 63112.0 |
| 2006-06-02 08:25:00 | AAPL | Stock | 2.225 | 2.225 | 2.2232 | 2.2232 | 42000.0 |
| 2006-06-02 08:27:00 | AAPL | Stock | 2.225 | 2.225 | 2.225 | 2.225 | 17192.0 |
| 2006-06-02 08:28:00 | AAPL | Stock | 2.225 | 2.225 | 2.225 | 2.225 | 2800.0 |
| 2006-06-02 08:29:00 | AAPL | Stock | 2.2268 | 2.2268 | 2.225 | 2.225 | 14392.0 |
| 2006-06-02 08:30:00 | AAPL | Stock | 2.2268 | 2.2321 | 2.2268 | 2.2318 | 275184.0 |
| 2006-06-02 08:31:00 | AAPL | Stock | 2.2318 | 2.2357 | 2.2286 | 2.2321 | 206976.0 |
| 2006-06-02 08:32:00 | AAPL | Stock | 2.2318 | 2.2354 | 2.2318 | 2.2354 | 111720.0 |
| 2006-06-02 08:33:00 | AAPL | Stock | 2.2354 | 2.2407 | 2.235 | 2.2404 | 311696.0 |
| 2006-06-02 08:34:00 | AAPL | Stock | 2.2404 | 2.2404 | 2.2375 | 2.2404 | 184800.0 |
| 2006-06-02 08:35:00 | AAPL | Stock | 2.2393 | 2.2407 | 2.2375 | 2.2404 | 156072.0 |
| 2006-06-02 08:36:00 | AAPL | Stock | 2.2407 | 2.2407 | 2.2393 | 2.2396 | 102060.0 |
| 2006-06-02 08:37:00 | AAPL | Stock | 2.2393 | 2.2396 | 2.2375 | 2.2396 | 103460.0 |
| 2006-06-02 08:38:00 | AAPL | Stock | 2.2375 | 2.2393 | 2.2375 | 2.2393 | 140364.0 |
| 2006-06-02 08:39:00 | AAPL | Stock | 2.2375 | 2.2393 | 2.2375 | 2.2393 | 50400.0 |
| 2006-06-02 08:40:00 | AAPL | Stock | 2.2382 | 2.2389 | 2.2379 | 2.2389 | 47600.0 |
| 2006-06-02 08:41:00 | AAPL | Stock | 2.2389 | 2.2389 | 2.2389 | 2.2389 | 40600.0 |
| 2006-06-02 08:42:00 | AAPL | Stock | 2.2379 | 2.2389 | 2.2375 | 2.2389 | 77000.0 |
| 2006-06-02 08:43:00 | AAPL | Stock | 2.2389 | 2.2389 | 2.2375 | 2.2375 | 42000.0 |
| 2006-06-02 08:44:00 | AAPL | Stock | 2.2389 | 2.2393 | 2.2386 | 2.2393 | 57400.0 |
| 2006-06-02 08:45:00 | AAPL | Stock | 2.2396 | 2.2396 | 2.2389 | 2.2389 | 36120.0 |
| 2006-06-02 08:46:00 | AAPL | Stock | 2.2389 | 2.2393 | 2.2389 | 2.2393 | 54320.0 |
| 2006-06-02 08:47:00 | AAPL | Stock | 2.2393 | 2.2393 | 2.2389 | 2.2389 | 42560.0 |
| 2006-06-02 08:48:00 | AAPL | Stock | 2.2379 | 2.2379 | 2.2364 | 2.2364 | 8400.0 |
| 2006-06-02 08:49:00 | AAPL | Stock | 2.2389 | 2.24 | 2.2389 | 2.24 | 157388.0 |
| 2006-06-02 08:50:00 | AAPL | Stock | 2.2404 | 2.2407 | 2.2396 | 2.2407 | 87808.0 |
| 2006-06-02 08:51:00 | AAPL | Stock | 2.2407 | 2.2407 | 2.2393 | 2.2396 | 154588.0 |
| 2006-06-02 08:52:00 | AAPL | Stock | 2.2396 | 2.2404 | 2.2396 | 2.2404 | 23828.0 |
| 2006-06-02 08:53:00 | AAPL | Stock | 2.2404 | 2.2429 | 2.2404 | 2.2429 | 146720.0 |
| 2006-06-02 08:54:00 | AAPL | Stock | 2.2429 | 2.2429 | 2.2404 | 2.2404 | 29400.0 |
| 2006-06-02 08:55:00 | AAPL | Stock | 2.2404 | 2.2411 | 2.2404 | 2.2411 | 36400.0 |
| 2006-06-02 08:56:00 | AAPL | Stock | 2.2411 | 2.2411 | 2.2404 | 2.2411 | 22400.0 |
| 2006-06-02 08:57:00 | AAPL | Stock | 2.2411 | 2.2411 | 2.2393 | 2.2393 | 84000.0 |
> showing 50 of 709,201 rows — these rows as CSV