PREVIEW / stock_1min / 2007-10-19
file: by_date/stock_1min/2007/2007-10-19.parquet size: 12.2 MB rows: 979,452 symbols: 2,582
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-10-19 04:15:00 | AAPL | Stock | 6.2 | 6.2 | 6.2 | 6.2 | 2800.0 |
| 2007-10-19 06:15:00 | AAPL | Stock | 6.2104 | 6.2104 | 6.2104 | 6.2104 | 2800.0 |
| 2007-10-19 06:49:00 | AAPL | Stock | 6.2104 | 6.2104 | 6.2104 | 6.2104 | 2800.0 |
| 2007-10-19 06:50:00 | AAPL | Stock | 6.2104 | 6.2104 | 6.2104 | 6.2104 | 11200.0 |
| 2007-10-19 07:01:00 | AAPL | Stock | 6.2107 | 6.2107 | 6.2107 | 6.2107 | 14000.0 |
| 2007-10-19 07:24:00 | AAPL | Stock | 6.2164 | 6.2164 | 6.2164 | 6.2164 | 14000.0 |
| 2007-10-19 07:37:00 | AAPL | Stock | 6.2218 | 6.2218 | 6.2179 | 6.2179 | 14000.0 |
| 2007-10-19 07:38:00 | AAPL | Stock | 6.2371 | 6.2375 | 6.2371 | 6.2375 | 12600.0 |
| 2007-10-19 07:39:00 | AAPL | Stock | 6.2393 | 6.2393 | 6.2375 | 6.2393 | 58800.0 |
| 2007-10-19 07:40:00 | AAPL | Stock | 6.2443 | 6.2443 | 6.2357 | 6.2357 | 22540.0 |
| 2007-10-19 07:42:00 | AAPL | Stock | 6.2411 | 6.2411 | 6.2411 | 6.2411 | 14000.0 |
| 2007-10-19 07:43:00 | AAPL | Stock | 6.2425 | 6.25 | 6.2425 | 6.2425 | 211344.0 |
| 2007-10-19 07:48:00 | AAPL | Stock | 6.2425 | 6.2425 | 6.2425 | 6.2425 | 7000.0 |
| 2007-10-19 07:49:00 | AAPL | Stock | 6.2461 | 6.25 | 6.2457 | 6.25 | 29680.0 |
| 2007-10-19 07:50:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 8260.0 |
| 2007-10-19 07:56:00 | AAPL | Stock | 6.2464 | 6.2464 | 6.2464 | 6.2464 | 2800.0 |
| 2007-10-19 07:57:00 | AAPL | Stock | 6.2464 | 6.2464 | 6.2464 | 6.2464 | 2800.0 |
| 2007-10-19 07:58:00 | AAPL | Stock | 6.2457 | 6.2457 | 6.2457 | 6.2457 | 2800.0 |
| 2007-10-19 07:59:00 | AAPL | Stock | 6.2479 | 6.2479 | 6.2479 | 6.2479 | 10080.0 |
| 2007-10-19 08:00:00 | AAPL | Stock | 6.2479 | 6.2493 | 6.2379 | 6.2411 | 199136.0 |
| 2007-10-19 08:01:00 | AAPL | Stock | 6.2411 | 6.25 | 6.2379 | 6.2446 | 253512.0 |
| 2007-10-19 08:02:00 | AAPL | Stock | 6.2446 | 6.2464 | 6.24 | 6.24 | 62580.0 |
| 2007-10-19 08:03:00 | AAPL | Stock | 6.2454 | 6.2464 | 6.2393 | 6.2446 | 93660.0 |
| 2007-10-19 08:04:00 | AAPL | Stock | 6.245 | 6.2454 | 6.2357 | 6.2375 | 203280.0 |
| 2007-10-19 08:05:00 | AAPL | Stock | 6.2371 | 6.2375 | 6.2357 | 6.2375 | 92428.0 |
| 2007-10-19 08:06:00 | AAPL | Stock | 6.2375 | 6.2446 | 6.2375 | 6.2411 | 103880.0 |
| 2007-10-19 08:07:00 | AAPL | Stock | 6.2411 | 6.2446 | 6.2357 | 6.2393 | 308700.0 |
| 2007-10-19 08:08:00 | AAPL | Stock | 6.2371 | 6.2396 | 6.2329 | 6.2396 | 25200.0 |
| 2007-10-19 08:09:00 | AAPL | Stock | 6.2357 | 6.2357 | 6.2268 | 6.2268 | 115080.0 |
| 2007-10-19 08:10:00 | AAPL | Stock | 6.2275 | 6.2321 | 6.2264 | 6.2311 | 142800.0 |
| 2007-10-19 08:11:00 | AAPL | Stock | 6.2304 | 6.2339 | 6.2304 | 6.2321 | 35000.0 |
| 2007-10-19 08:12:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2364 | 6.2364 | 8400.0 |
| 2007-10-19 08:13:00 | AAPL | Stock | 6.2357 | 6.2393 | 6.23 | 6.2357 | 294000.0 |
| 2007-10-19 08:14:00 | AAPL | Stock | 6.2321 | 6.2375 | 6.2321 | 6.2361 | 56840.0 |
| 2007-10-19 08:15:00 | AAPL | Stock | 6.2371 | 6.2371 | 6.2371 | 6.2371 | 56000.0 |
| 2007-10-19 08:16:00 | AAPL | Stock | 6.2393 | 6.2418 | 6.2375 | 6.2418 | 370860.0 |
| 2007-10-19 08:17:00 | AAPL | Stock | 6.2436 | 6.2446 | 6.2418 | 6.2421 | 137900.0 |
| 2007-10-19 08:18:00 | AAPL | Stock | 6.2439 | 6.2461 | 6.2429 | 6.2429 | 158200.0 |
| 2007-10-19 08:19:00 | AAPL | Stock | 6.2429 | 6.2461 | 6.2429 | 6.2461 | 181636.0 |
| 2007-10-19 08:20:00 | AAPL | Stock | 6.2418 | 6.2432 | 6.2393 | 6.2421 | 270200.0 |
| 2007-10-19 08:21:00 | AAPL | Stock | 6.2414 | 6.2429 | 6.2357 | 6.2429 | 208600.0 |
| 2007-10-19 08:22:00 | AAPL | Stock | 6.235 | 6.24 | 6.235 | 6.2379 | 116592.0 |
| 2007-10-19 08:23:00 | AAPL | Stock | 6.2379 | 6.2379 | 6.235 | 6.235 | 96208.0 |
| 2007-10-19 08:24:00 | AAPL | Stock | 6.2354 | 6.2354 | 6.2271 | 6.2271 | 336756.0 |
| 2007-10-19 08:25:00 | AAPL | Stock | 6.2279 | 6.2332 | 6.2279 | 6.2321 | 133280.0 |
| 2007-10-19 08:26:00 | AAPL | Stock | 6.2336 | 6.2371 | 6.2336 | 6.2357 | 110796.0 |
| 2007-10-19 08:27:00 | AAPL | Stock | 6.2371 | 6.2411 | 6.2371 | 6.2375 | 22820.0 |
| 2007-10-19 08:28:00 | AAPL | Stock | 6.2379 | 6.2379 | 6.2375 | 6.2375 | 28420.0 |
| 2007-10-19 08:29:00 | AAPL | Stock | 6.2357 | 6.2379 | 6.2354 | 6.2357 | 181748.0 |
| 2007-10-19 08:30:00 | AAPL | Stock | 6.2364 | 6.2364 | 6.2364 | 6.2364 | 5600.0 |
> showing 50 of 979,452 rows — these rows as CSV