PREVIEW / stock_1min / 2012-06-11
file: by_date/stock_1min/2012/2012-06-11.parquet size: 13.1 MB rows: 985,579 symbols: 2,834
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 |
|---|---|---|---|---|---|---|---|
| 2012-06-11 04:00:00 | AAPL | Stock | 20.7839 | 21.0246 | 20.7839 | 21.0246 | 11256.0 |
| 2012-06-11 04:01:00 | AAPL | Stock | 21.0136 | 21.0136 | 21.0114 | 21.0114 | 10640.0 |
| 2012-06-11 04:03:00 | AAPL | Stock | 21.0018 | 21.0018 | 21.0018 | 21.0018 | 2800.0 |
| 2012-06-11 04:06:00 | AAPL | Stock | 21.0239 | 21.0239 | 21.0239 | 21.0239 | 2800.0 |
| 2012-06-11 04:09:00 | AAPL | Stock | 21.0246 | 21.0246 | 21.0246 | 21.0246 | 2800.0 |
| 2012-06-11 04:10:00 | AAPL | Stock | 21.0246 | 21.0246 | 21.0246 | 21.0246 | 2800.0 |
| 2012-06-11 04:11:00 | AAPL | Stock | 21.0246 | 21.0246 | 21.0179 | 21.0179 | 30100.0 |
| 2012-06-11 04:13:00 | AAPL | Stock | 21.0046 | 21.0046 | 21.0 | 21.0 | 11200.0 |
| 2012-06-11 04:14:00 | AAPL | Stock | 21.0125 | 21.0246 | 21.0125 | 21.0246 | 14000.0 |
| 2012-06-11 04:15:00 | AAPL | Stock | 21.0554 | 21.0554 | 21.0554 | 21.0554 | 9716.0 |
| 2012-06-11 04:16:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0536 | 21.0536 | 3332.0 |
| 2012-06-11 04:17:00 | AAPL | Stock | 21.0475 | 21.0475 | 21.0475 | 21.0475 | 2800.0 |
| 2012-06-11 04:18:00 | AAPL | Stock | 21.0475 | 21.0475 | 21.0475 | 21.0475 | 8400.0 |
| 2012-06-11 04:21:00 | AAPL | Stock | 21.0357 | 21.0357 | 21.0357 | 21.0357 | 19600.0 |
| 2012-06-11 04:31:00 | AAPL | Stock | 21.0304 | 21.0304 | 21.0304 | 21.0304 | 8400.0 |
| 2012-06-11 04:49:00 | AAPL | Stock | 20.9825 | 20.9825 | 20.9825 | 20.9825 | 5600.0 |
| 2012-06-11 04:55:00 | AAPL | Stock | 20.9757 | 20.9757 | 20.9757 | 20.9757 | 5600.0 |
| 2012-06-11 05:09:00 | AAPL | Stock | 20.9861 | 20.9861 | 20.9861 | 20.9861 | 16800.0 |
| 2012-06-11 05:10:00 | AAPL | Stock | 20.9796 | 20.9796 | 20.9796 | 20.9796 | 2800.0 |
| 2012-06-11 05:14:00 | AAPL | Stock | 20.9646 | 20.9646 | 20.9646 | 20.9646 | 2800.0 |
| 2012-06-11 05:21:00 | AAPL | Stock | 20.965 | 20.965 | 20.965 | 20.965 | 2800.0 |
| 2012-06-11 05:22:00 | AAPL | Stock | 20.965 | 20.965 | 20.965 | 20.965 | 2800.0 |
| 2012-06-11 05:25:00 | AAPL | Stock | 20.965 | 20.965 | 20.965 | 20.965 | 5600.0 |
| 2012-06-11 05:27:00 | AAPL | Stock | 20.965 | 20.965 | 20.965 | 20.965 | 2800.0 |
| 2012-06-11 05:32:00 | AAPL | Stock | 20.965 | 20.965 | 20.965 | 20.965 | 2800.0 |
| 2012-06-11 05:59:00 | AAPL | Stock | 20.9611 | 20.9611 | 20.9607 | 20.9607 | 5600.0 |
| 2012-06-11 06:09:00 | AAPL | Stock | 20.9536 | 20.9536 | 20.9536 | 20.9536 | 2800.0 |
| 2012-06-11 06:10:00 | AAPL | Stock | 20.9536 | 20.9536 | 20.9536 | 20.9536 | 14000.0 |
| 2012-06-11 06:12:00 | AAPL | Stock | 20.9536 | 20.9536 | 20.9536 | 20.9536 | 2800.0 |
| 2012-06-11 06:13:00 | AAPL | Stock | 20.9536 | 20.9536 | 20.9536 | 20.9536 | 5600.0 |
| 2012-06-11 06:31:00 | AAPL | Stock | 20.9375 | 20.9375 | 20.9375 | 20.9375 | 45668.0 |
| 2012-06-11 06:33:00 | AAPL | Stock | 20.9375 | 20.9375 | 20.9343 | 20.9343 | 5600.0 |
| 2012-06-11 06:34:00 | AAPL | Stock | 20.9375 | 20.9375 | 20.9375 | 20.9375 | 3668.0 |
| 2012-06-11 06:36:00 | AAPL | Stock | 20.9379 | 20.9379 | 20.9343 | 20.9343 | 5600.0 |
| 2012-06-11 06:37:00 | AAPL | Stock | 20.9336 | 20.9336 | 20.9336 | 20.9336 | 2800.0 |
| 2012-06-11 06:38:00 | AAPL | Stock | 20.9336 | 20.9336 | 20.9336 | 20.9336 | 5600.0 |
| 2012-06-11 06:39:00 | AAPL | Stock | 20.9336 | 20.9336 | 20.9336 | 20.9336 | 2800.0 |
| 2012-06-11 06:43:00 | AAPL | Stock | 20.9339 | 20.9339 | 20.9339 | 20.9339 | 2800.0 |
| 2012-06-11 06:44:00 | AAPL | Stock | 20.9339 | 20.9339 | 20.9339 | 20.9339 | 2800.0 |
| 2012-06-11 06:45:00 | AAPL | Stock | 20.9289 | 20.9289 | 20.9289 | 20.9289 | 7000.0 |
| 2012-06-11 06:50:00 | AAPL | Stock | 20.9161 | 20.9161 | 20.9161 | 20.9161 | 2800.0 |
| 2012-06-11 06:54:00 | AAPL | Stock | 20.9021 | 20.9021 | 20.8929 | 20.8929 | 28000.0 |
| 2012-06-11 06:56:00 | AAPL | Stock | 20.8929 | 20.8929 | 20.8929 | 20.8929 | 11200.0 |
| 2012-06-11 07:00:00 | AAPL | Stock | 20.9046 | 20.9046 | 20.9032 | 20.9032 | 5600.0 |
| 2012-06-11 07:01:00 | AAPL | Stock | 20.9032 | 20.9032 | 20.8793 | 20.9029 | 17136.0 |
| 2012-06-11 07:02:00 | AAPL | Stock | 20.9032 | 20.9032 | 20.8929 | 20.9032 | 33124.0 |
| 2012-06-11 07:03:00 | AAPL | Stock | 20.9032 | 20.9039 | 20.8932 | 20.9039 | 25900.0 |
| 2012-06-11 07:04:00 | AAPL | Stock | 20.9 | 20.9 | 20.8929 | 20.8929 | 16800.0 |
| 2012-06-11 07:05:00 | AAPL | Stock | 20.8857 | 20.8893 | 20.875 | 20.875 | 43232.0 |
| 2012-06-11 07:06:00 | AAPL | Stock | 20.8732 | 20.8821 | 20.8732 | 20.8821 | 22316.0 |
> showing 50 of 985,579 rows — these rows as CSV