PREVIEW / stock_1min / 2010-06-30
file: by_date/stock_1min/2010/2010-06-30.parquet size: 13.3 MB rows: 1,019,412 symbols: 2,824
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-06-30 04:15:00 | AAPL | Stock | 9.2139 | 9.2139 | 9.2139 | 9.2139 | 2800.0 |
| 2010-06-30 05:14:00 | AAPL | Stock | 9.1782 | 9.1782 | 9.1782 | 9.1782 | 2800.0 |
| 2010-06-30 05:18:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 5348.0 |
| 2010-06-30 05:20:00 | AAPL | Stock | 9.225 | 9.225 | 9.225 | 9.225 | 28000.0 |
| 2010-06-30 05:27:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 2800.0 |
| 2010-06-30 05:55:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 3192.0 |
| 2010-06-30 05:57:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 8400.0 |
| 2010-06-30 06:00:00 | AAPL | Stock | 9.2489 | 9.2489 | 9.2489 | 9.2489 | 3080.0 |
| 2010-06-30 06:02:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 5600.0 |
| 2010-06-30 06:12:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 3052.0 |
| 2010-06-30 06:15:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 3724.0 |
| 2010-06-30 06:16:00 | AAPL | Stock | 9.2493 | 9.2493 | 9.2493 | 9.2493 | 3500.0 |
| 2010-06-30 06:42:00 | AAPL | Stock | 9.2286 | 9.2286 | 9.2286 | 9.2286 | 25200.0 |
| 2010-06-30 06:45:00 | AAPL | Stock | 9.2264 | 9.2264 | 9.2264 | 9.2264 | 2800.0 |
| 2010-06-30 07:00:00 | AAPL | Stock | 9.2264 | 9.2264 | 9.2264 | 9.2264 | 23800.0 |
| 2010-06-30 07:01:00 | AAPL | Stock | 9.2261 | 9.2261 | 9.2261 | 9.2261 | 2800.0 |
| 2010-06-30 07:02:00 | AAPL | Stock | 9.2246 | 9.2246 | 9.2246 | 9.2246 | 2800.0 |
| 2010-06-30 07:03:00 | AAPL | Stock | 9.2189 | 9.2225 | 9.2189 | 9.2225 | 56784.0 |
| 2010-06-30 07:04:00 | AAPL | Stock | 9.2214 | 9.2246 | 9.2214 | 9.2246 | 19600.0 |
| 2010-06-30 07:05:00 | AAPL | Stock | 9.2264 | 9.2411 | 9.2232 | 9.225 | 50400.0 |
| 2010-06-30 07:06:00 | AAPL | Stock | 9.2407 | 9.2407 | 9.2357 | 9.2357 | 11200.0 |
| 2010-06-30 07:07:00 | AAPL | Stock | 9.2393 | 9.2479 | 9.2393 | 9.2479 | 25200.0 |
| 2010-06-30 07:10:00 | AAPL | Stock | 9.2393 | 9.2393 | 9.2393 | 9.2393 | 2800.0 |
| 2010-06-30 07:14:00 | AAPL | Stock | 9.2404 | 9.2407 | 9.2404 | 9.2407 | 16800.0 |
| 2010-06-30 07:15:00 | AAPL | Stock | 9.2304 | 9.2304 | 9.2304 | 9.2304 | 2800.0 |
| 2010-06-30 07:16:00 | AAPL | Stock | 9.2321 | 9.2411 | 9.2321 | 9.2411 | 61600.0 |
| 2010-06-30 07:17:00 | AAPL | Stock | 9.2421 | 9.2482 | 9.2421 | 9.2482 | 5600.0 |
| 2010-06-30 07:18:00 | AAPL | Stock | 9.2475 | 9.2482 | 9.2475 | 9.2482 | 25340.0 |
| 2010-06-30 07:20:00 | AAPL | Stock | 9.2443 | 9.2443 | 9.2443 | 9.2443 | 2800.0 |
| 2010-06-30 07:21:00 | AAPL | Stock | 9.2479 | 9.2479 | 9.2479 | 9.2479 | 3024.0 |
| 2010-06-30 07:22:00 | AAPL | Stock | 9.2479 | 9.2639 | 9.2479 | 9.2636 | 39536.0 |
| 2010-06-30 07:23:00 | AAPL | Stock | 9.2614 | 9.2614 | 9.2614 | 9.2614 | 2800.0 |
| 2010-06-30 07:24:00 | AAPL | Stock | 9.2607 | 9.2611 | 9.2589 | 9.2589 | 16800.0 |
| 2010-06-30 07:25:00 | AAPL | Stock | 9.2629 | 9.2661 | 9.2625 | 9.2646 | 39200.0 |
| 2010-06-30 07:26:00 | AAPL | Stock | 9.2571 | 9.2571 | 9.25 | 9.2504 | 48860.0 |
| 2010-06-30 07:28:00 | AAPL | Stock | 9.25 | 9.25 | 9.25 | 9.25 | 6972.0 |
| 2010-06-30 07:29:00 | AAPL | Stock | 9.25 | 9.25 | 9.25 | 9.25 | 11200.0 |
| 2010-06-30 07:30:00 | AAPL | Stock | 9.2493 | 9.25 | 9.2493 | 9.25 | 38752.0 |
| 2010-06-30 07:31:00 | AAPL | Stock | 9.2446 | 9.2446 | 9.2446 | 9.2446 | 5600.0 |
| 2010-06-30 07:32:00 | AAPL | Stock | 9.2357 | 9.2357 | 9.2357 | 9.2357 | 2800.0 |
| 2010-06-30 07:38:00 | AAPL | Stock | 9.225 | 9.2411 | 9.225 | 9.2411 | 19600.0 |
| 2010-06-30 07:41:00 | AAPL | Stock | 9.2261 | 9.2261 | 9.2261 | 9.2261 | 2800.0 |
| 2010-06-30 07:43:00 | AAPL | Stock | 9.2371 | 9.2371 | 9.2371 | 9.2371 | 3388.0 |
| 2010-06-30 07:44:00 | AAPL | Stock | 9.2393 | 9.2393 | 9.2393 | 9.2393 | 26628.0 |
| 2010-06-30 07:46:00 | AAPL | Stock | 9.2321 | 9.2321 | 9.2261 | 9.2261 | 14000.0 |
| 2010-06-30 07:47:00 | AAPL | Stock | 9.2214 | 9.2214 | 9.2214 | 9.2214 | 5600.0 |
| 2010-06-30 07:51:00 | AAPL | Stock | 9.2211 | 9.2211 | 9.2211 | 9.2211 | 2800.0 |
| 2010-06-30 07:54:00 | AAPL | Stock | 9.2171 | 9.2171 | 9.2168 | 9.2168 | 8400.0 |
| 2010-06-30 07:55:00 | AAPL | Stock | 9.2211 | 9.2268 | 9.2211 | 9.2268 | 40320.0 |
| 2010-06-30 07:56:00 | AAPL | Stock | 9.2214 | 9.2214 | 9.2214 | 9.2214 | 19600.0 |
> showing 50 of 1,019,412 rows — these rows as CSV