PREVIEW / stock_1min / 2008-08-28
file: by_date/stock_1min/2008/2008-08-28.parquet size: 11.8 MB rows: 960,432 symbols: 2,689
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-28 07:51:00 | AAPL | Stock | 6.2479 | 6.2479 | 6.2479 | 6.2479 | 2800.0 |
| 2008-08-28 08:00:00 | AAPL | Stock | 6.2007 | 6.2007 | 6.2007 | 6.2007 | 5180.0 |
| 2008-08-28 08:02:00 | AAPL | Stock | 6.2246 | 6.2264 | 6.2246 | 6.2264 | 13916.0 |
| 2008-08-28 08:03:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 13916.0 |
| 2008-08-28 08:05:00 | AAPL | Stock | 6.2254 | 6.2254 | 6.2254 | 6.2254 | 2800.0 |
| 2008-08-28 08:06:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.2214 | 6.2214 | 14000.0 |
| 2008-08-28 08:08:00 | AAPL | Stock | 6.2243 | 6.2243 | 6.2243 | 6.2243 | 2800.0 |
| 2008-08-28 08:09:00 | AAPL | Stock | 6.2243 | 6.2243 | 6.2243 | 6.2243 | 16492.0 |
| 2008-08-28 08:13:00 | AAPL | Stock | 6.2186 | 6.2218 | 6.2186 | 6.2214 | 64400.0 |
| 2008-08-28 08:16:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.2211 | 6.2211 | 6720.0 |
| 2008-08-28 08:25:00 | AAPL | Stock | 6.2243 | 6.2314 | 6.2236 | 6.2314 | 11200.0 |
| 2008-08-28 08:26:00 | AAPL | Stock | 6.2314 | 6.2314 | 6.225 | 6.225 | 8400.0 |
| 2008-08-28 08:27:00 | AAPL | Stock | 6.2254 | 6.2254 | 6.225 | 6.225 | 32200.0 |
| 2008-08-28 08:29:00 | AAPL | Stock | 6.2264 | 6.2264 | 6.2261 | 6.2261 | 11480.0 |
| 2008-08-28 08:30:00 | AAPL | Stock | 6.23 | 6.2464 | 6.23 | 6.2464 | 144704.0 |
| 2008-08-28 08:31:00 | AAPL | Stock | 6.2464 | 6.2475 | 6.2418 | 6.2443 | 104720.0 |
| 2008-08-28 08:32:00 | AAPL | Stock | 6.2443 | 6.2446 | 6.2346 | 6.2382 | 121800.0 |
| 2008-08-28 08:33:00 | AAPL | Stock | 6.2393 | 6.2396 | 6.2375 | 6.2396 | 47600.0 |
| 2008-08-28 08:34:00 | AAPL | Stock | 6.2418 | 6.2425 | 6.2371 | 6.2418 | 22400.0 |
| 2008-08-28 08:35:00 | AAPL | Stock | 6.2418 | 6.2418 | 6.2368 | 6.2368 | 54040.0 |
| 2008-08-28 08:36:00 | AAPL | Stock | 6.2375 | 6.2414 | 6.2357 | 6.2414 | 50120.0 |
| 2008-08-28 08:37:00 | AAPL | Stock | 6.2414 | 6.2489 | 6.2414 | 6.2486 | 207480.0 |
| 2008-08-28 08:38:00 | AAPL | Stock | 6.2482 | 6.2571 | 6.2482 | 6.2536 | 189448.0 |
| 2008-08-28 08:39:00 | AAPL | Stock | 6.2568 | 6.2568 | 6.25 | 6.25 | 70000.0 |
| 2008-08-28 08:40:00 | AAPL | Stock | 6.2518 | 6.2536 | 6.2518 | 6.2536 | 40600.0 |
| 2008-08-28 08:41:00 | AAPL | Stock | 6.25 | 6.255 | 6.25 | 6.2521 | 108640.0 |
| 2008-08-28 08:42:00 | AAPL | Stock | 6.2575 | 6.2575 | 6.2568 | 6.2571 | 15400.0 |
| 2008-08-28 08:43:00 | AAPL | Stock | 6.2579 | 6.2579 | 6.2554 | 6.2554 | 56560.0 |
| 2008-08-28 08:44:00 | AAPL | Stock | 6.2571 | 6.2571 | 6.2557 | 6.2571 | 23800.0 |
| 2008-08-28 08:45:00 | AAPL | Stock | 6.2571 | 6.2604 | 6.2571 | 6.2604 | 42700.0 |
| 2008-08-28 08:46:00 | AAPL | Stock | 6.2593 | 6.2596 | 6.2593 | 6.2596 | 25200.0 |
| 2008-08-28 08:47:00 | AAPL | Stock | 6.2607 | 6.2607 | 6.2596 | 6.2607 | 42000.0 |
| 2008-08-28 08:48:00 | AAPL | Stock | 6.2596 | 6.2596 | 6.2557 | 6.2557 | 27412.0 |
| 2008-08-28 08:49:00 | AAPL | Stock | 6.2568 | 6.2571 | 6.2568 | 6.2571 | 5600.0 |
| 2008-08-28 08:50:00 | AAPL | Stock | 6.2579 | 6.2611 | 6.2579 | 6.2611 | 260400.0 |
| 2008-08-28 08:51:00 | AAPL | Stock | 6.2618 | 6.2618 | 6.2554 | 6.2604 | 90860.0 |
| 2008-08-28 08:52:00 | AAPL | Stock | 6.2604 | 6.2607 | 6.2564 | 6.2564 | 16800.0 |
| 2008-08-28 08:53:00 | AAPL | Stock | 6.2586 | 6.2596 | 6.2586 | 6.2596 | 19600.0 |
| 2008-08-28 08:54:00 | AAPL | Stock | 6.2596 | 6.2607 | 6.2596 | 6.2607 | 41412.0 |
| 2008-08-28 08:55:00 | AAPL | Stock | 6.2607 | 6.2639 | 6.2589 | 6.2589 | 167860.0 |
| 2008-08-28 08:56:00 | AAPL | Stock | 6.2618 | 6.2636 | 6.2614 | 6.2636 | 11200.0 |
| 2008-08-28 08:57:00 | AAPL | Stock | 6.2618 | 6.2618 | 6.2575 | 6.2575 | 96600.0 |
| 2008-08-28 08:58:00 | AAPL | Stock | 6.2586 | 6.2586 | 6.2586 | 6.2586 | 2800.0 |
| 2008-08-28 08:59:00 | AAPL | Stock | 6.2575 | 6.2618 | 6.2575 | 6.2618 | 168000.0 |
| 2008-08-28 09:00:00 | AAPL | Stock | 6.2618 | 6.2618 | 6.2607 | 6.2607 | 30800.0 |
| 2008-08-28 09:01:00 | AAPL | Stock | 6.2607 | 6.2618 | 6.2607 | 6.2618 | 61292.0 |
| 2008-08-28 09:02:00 | AAPL | Stock | 6.2607 | 6.2607 | 6.2607 | 6.2607 | 12600.0 |
| 2008-08-28 09:03:00 | AAPL | Stock | 6.2607 | 6.2611 | 6.2589 | 6.2589 | 19600.0 |
| 2008-08-28 09:04:00 | AAPL | Stock | 6.2614 | 6.2614 | 6.2614 | 6.2614 | 2800.0 |
| 2008-08-28 09:05:00 | AAPL | Stock | 6.26 | 6.26 | 6.26 | 6.26 | 2800.0 |
> showing 50 of 960,432 rows — these rows as CSV