PREVIEW / stock_1min / 2013-04-09
file: by_date/stock_1min/2013/2013-04-09.parquet size: 12.9 MB rows: 942,533 symbols: 2,835
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 |
|---|---|---|---|---|---|---|---|
| 2013-04-09 05:21:00 | AAPL | Stock | 15.2668 | 15.2668 | 15.2668 | 15.2668 | 23772.0 |
| 2013-04-09 05:43:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 2800.0 |
| 2013-04-09 05:56:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 2800.0 |
| 2013-04-09 05:57:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 2800.0 |
| 2013-04-09 06:14:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 2800.0 |
| 2013-04-09 06:54:00 | AAPL | Stock | 15.2464 | 15.2464 | 15.2464 | 15.2464 | 2800.0 |
| 2013-04-09 07:00:00 | AAPL | Stock | 15.2464 | 15.2464 | 15.2464 | 15.2464 | 16800.0 |
| 2013-04-09 07:03:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 5600.0 |
| 2013-04-09 07:04:00 | AAPL | Stock | 15.2514 | 15.2514 | 15.2514 | 15.2514 | 5600.0 |
| 2013-04-09 07:05:00 | AAPL | Stock | 15.2514 | 15.2514 | 15.2514 | 15.2514 | 5600.0 |
| 2013-04-09 07:17:00 | AAPL | Stock | 15.2671 | 15.2671 | 15.2671 | 15.2671 | 7224.0 |
| 2013-04-09 07:19:00 | AAPL | Stock | 15.2668 | 15.2668 | 15.2668 | 15.2668 | 8932.0 |
| 2013-04-09 07:20:00 | AAPL | Stock | 15.2671 | 15.2704 | 15.2671 | 15.2704 | 11452.0 |
| 2013-04-09 07:26:00 | AAPL | Stock | 15.28 | 15.28 | 15.28 | 15.28 | 4228.0 |
| 2013-04-09 07:27:00 | AAPL | Stock | 15.2646 | 15.2646 | 15.2646 | 15.2646 | 2800.0 |
| 2013-04-09 07:28:00 | AAPL | Stock | 15.28 | 15.28 | 15.28 | 15.28 | 2800.0 |
| 2013-04-09 07:32:00 | AAPL | Stock | 15.2696 | 15.2696 | 15.2696 | 15.2696 | 3052.0 |
| 2013-04-09 07:36:00 | AAPL | Stock | 15.2675 | 15.2675 | 15.2675 | 15.2675 | 2800.0 |
| 2013-04-09 07:44:00 | AAPL | Stock | 15.2625 | 15.2625 | 15.2625 | 15.2625 | 2800.0 |
| 2013-04-09 07:46:00 | AAPL | Stock | 15.2571 | 15.2571 | 15.2571 | 15.2571 | 2800.0 |
| 2013-04-09 07:47:00 | AAPL | Stock | 15.2618 | 15.2618 | 15.2582 | 15.2582 | 5796.0 |
| 2013-04-09 07:49:00 | AAPL | Stock | 15.2557 | 15.2557 | 15.2557 | 15.2557 | 2800.0 |
| 2013-04-09 07:50:00 | AAPL | Stock | 15.2525 | 15.2525 | 15.2525 | 15.2525 | 16800.0 |
| 2013-04-09 07:51:00 | AAPL | Stock | 15.2496 | 15.2496 | 15.2496 | 15.2496 | 2800.0 |
| 2013-04-09 07:52:00 | AAPL | Stock | 15.2496 | 15.2607 | 15.2496 | 15.2607 | 19600.0 |
| 2013-04-09 07:54:00 | AAPL | Stock | 15.2536 | 15.2536 | 15.2521 | 15.2521 | 37800.0 |
| 2013-04-09 08:00:00 | AAPL | Stock | 15.2486 | 15.28 | 15.2464 | 15.25 | 33320.0 |
| 2013-04-09 08:01:00 | AAPL | Stock | 15.2411 | 15.2411 | 15.2286 | 15.2286 | 36176.0 |
| 2013-04-09 08:02:00 | AAPL | Stock | 15.225 | 15.2254 | 15.2236 | 15.2236 | 12432.0 |
| 2013-04-09 08:03:00 | AAPL | Stock | 15.2218 | 15.2282 | 15.2218 | 15.2282 | 13776.0 |
| 2013-04-09 08:04:00 | AAPL | Stock | 15.225 | 15.2357 | 15.225 | 15.2318 | 59976.0 |
| 2013-04-09 08:05:00 | AAPL | Stock | 15.2318 | 15.2321 | 15.1786 | 15.1786 | 19992.0 |
| 2013-04-09 08:07:00 | AAPL | Stock | 15.2289 | 15.2289 | 15.2289 | 15.2289 | 2800.0 |
| 2013-04-09 08:09:00 | AAPL | Stock | 15.2232 | 15.2232 | 15.2232 | 15.2232 | 2800.0 |
| 2013-04-09 08:10:00 | AAPL | Stock | 15.2225 | 15.2225 | 15.2225 | 15.2225 | 2800.0 |
| 2013-04-09 08:12:00 | AAPL | Stock | 15.2204 | 15.2211 | 15.2204 | 15.2211 | 30800.0 |
| 2013-04-09 08:13:00 | AAPL | Stock | 15.2221 | 15.2221 | 15.2221 | 15.2221 | 2800.0 |
| 2013-04-09 08:15:00 | AAPL | Stock | 15.2286 | 15.2286 | 15.2286 | 15.2286 | 8400.0 |
| 2013-04-09 08:17:00 | AAPL | Stock | 15.2282 | 15.2282 | 15.2232 | 15.2232 | 16800.0 |
| 2013-04-09 08:18:00 | AAPL | Stock | 15.2232 | 15.2232 | 15.2 | 15.2 | 77392.0 |
| 2013-04-09 08:19:00 | AAPL | Stock | 15.2004 | 15.2004 | 15.1982 | 15.1982 | 14000.0 |
| 2013-04-09 08:20:00 | AAPL | Stock | 15.2054 | 15.2057 | 15.2054 | 15.2054 | 9240.0 |
| 2013-04-09 08:21:00 | AAPL | Stock | 15.205 | 15.205 | 15.1814 | 15.1936 | 66640.0 |
| 2013-04-09 08:22:00 | AAPL | Stock | 15.1871 | 15.1875 | 15.1821 | 15.1857 | 95900.0 |
| 2013-04-09 08:23:00 | AAPL | Stock | 15.1861 | 15.1861 | 15.1861 | 15.1861 | 2800.0 |
| 2013-04-09 08:24:00 | AAPL | Stock | 15.1875 | 15.1875 | 15.1825 | 15.1825 | 5600.0 |
| 2013-04-09 08:25:00 | AAPL | Stock | 15.1864 | 15.1864 | 15.1864 | 15.1864 | 2800.0 |
| 2013-04-09 08:26:00 | AAPL | Stock | 15.1914 | 15.1964 | 15.1914 | 15.1964 | 18312.0 |
| 2013-04-09 08:28:00 | AAPL | Stock | 15.2032 | 15.2036 | 15.1968 | 15.2036 | 22400.0 |
| 2013-04-09 08:29:00 | AAPL | Stock | 15.2025 | 15.2054 | 15.2025 | 15.2029 | 63672.0 |
> showing 50 of 942,533 rows — these rows as CSV