PREVIEW / stock_1min / 2012-04-02
file: by_date/stock_1min/2012/2012-04-02.parquet size: 13.8 MB rows: 1,025,801 symbols: 2,861
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-04-02 04:00:00 | AAPL | Stock | 21.5 | 21.5082 | 21.5 | 21.5082 | 5600.0 |
| 2012-04-02 04:03:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5714 | 21.5714 | 19600.0 |
| 2012-04-02 04:06:00 | AAPL | Stock | 21.575 | 21.575 | 21.575 | 21.575 | 2800.0 |
| 2012-04-02 04:12:00 | AAPL | Stock | 21.5893 | 21.5893 | 21.5893 | 21.5893 | 11200.0 |
| 2012-04-02 04:14:00 | AAPL | Stock | 21.5357 | 21.6018 | 21.5357 | 21.6018 | 9800.0 |
| 2012-04-02 04:15:00 | AAPL | Stock | 21.5893 | 21.5893 | 21.5893 | 21.5893 | 2800.0 |
| 2012-04-02 04:21:00 | AAPL | Stock | 21.6061 | 21.6071 | 21.6061 | 21.6071 | 26320.0 |
| 2012-04-02 04:24:00 | AAPL | Stock | 21.5807 | 21.5807 | 21.5807 | 21.5807 | 2800.0 |
| 2012-04-02 04:42:00 | AAPL | Stock | 21.5361 | 21.5361 | 21.5357 | 21.5357 | 16800.0 |
| 2012-04-02 04:51:00 | AAPL | Stock | 21.5004 | 21.5004 | 21.5 | 21.5 | 8400.0 |
| 2012-04-02 04:53:00 | AAPL | Stock | 21.5393 | 21.5393 | 21.5393 | 21.5393 | 5320.0 |
| 2012-04-02 04:59:00 | AAPL | Stock | 21.5393 | 21.5393 | 21.5393 | 21.5393 | 2800.0 |
| 2012-04-02 05:02:00 | AAPL | Stock | 21.5393 | 21.5393 | 21.5393 | 21.5393 | 5880.0 |
| 2012-04-02 05:10:00 | AAPL | Stock | 21.5146 | 21.5146 | 21.5146 | 21.5146 | 8400.0 |
| 2012-04-02 05:12:00 | AAPL | Stock | 21.505 | 21.505 | 21.505 | 21.505 | 11200.0 |
| 2012-04-02 05:15:00 | AAPL | Stock | 21.5036 | 21.5036 | 21.5036 | 21.5036 | 8400.0 |
| 2012-04-02 05:16:00 | AAPL | Stock | 21.5007 | 21.5007 | 21.4939 | 21.4939 | 5600.0 |
| 2012-04-02 05:17:00 | AAPL | Stock | 21.4939 | 21.4939 | 21.4936 | 21.4936 | 8400.0 |
| 2012-04-02 05:19:00 | AAPL | Stock | 21.49 | 21.49 | 21.49 | 21.49 | 5600.0 |
| 2012-04-02 05:21:00 | AAPL | Stock | 21.4939 | 21.4939 | 21.4939 | 21.4939 | 2800.0 |
| 2012-04-02 05:38:00 | AAPL | Stock | 21.5057 | 21.5057 | 21.5057 | 21.5057 | 2800.0 |
| 2012-04-02 05:45:00 | AAPL | Stock | 21.5075 | 21.5075 | 21.5075 | 21.5075 | 2800.0 |
| 2012-04-02 05:55:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5071 | 21.5071 | 28000.0 |
| 2012-04-02 06:07:00 | AAPL | Stock | 21.5143 | 21.5143 | 21.5143 | 21.5143 | 2800.0 |
| 2012-04-02 06:35:00 | AAPL | Stock | 21.5071 | 21.5071 | 21.5071 | 21.5071 | 5600.0 |
| 2012-04-02 06:44:00 | AAPL | Stock | 21.5071 | 21.5071 | 21.5071 | 21.5071 | 2800.0 |
| 2012-04-02 06:46:00 | AAPL | Stock | 21.5075 | 21.5075 | 21.5075 | 21.5075 | 2800.0 |
| 2012-04-02 06:52:00 | AAPL | Stock | 21.5011 | 21.5011 | 21.5011 | 21.5011 | 5600.0 |
| 2012-04-02 06:55:00 | AAPL | Stock | 21.5011 | 21.5011 | 21.5011 | 21.5011 | 5600.0 |
| 2012-04-02 06:57:00 | AAPL | Stock | 21.5011 | 21.5011 | 21.5011 | 21.5011 | 2800.0 |
| 2012-04-02 06:59:00 | AAPL | Stock | 21.5 | 21.5 | 21.5 | 21.5 | 5600.0 |
| 2012-04-02 07:00:00 | AAPL | Stock | 21.5107 | 21.5107 | 21.5107 | 21.5107 | 2800.0 |
| 2012-04-02 07:01:00 | AAPL | Stock | 21.5139 | 21.5143 | 21.5036 | 21.5036 | 39200.0 |
| 2012-04-02 07:02:00 | AAPL | Stock | 21.5071 | 21.5071 | 21.5 | 21.5 | 14000.0 |
| 2012-04-02 07:03:00 | AAPL | Stock | 21.4989 | 21.5 | 21.49 | 21.49 | 28224.0 |
| 2012-04-02 07:04:00 | AAPL | Stock | 21.4911 | 21.4929 | 21.4893 | 21.4893 | 11200.0 |
| 2012-04-02 07:05:00 | AAPL | Stock | 21.4861 | 21.4861 | 21.4861 | 21.4861 | 2800.0 |
| 2012-04-02 07:06:00 | AAPL | Stock | 21.4929 | 21.4929 | 21.4929 | 21.4929 | 2800.0 |
| 2012-04-02 07:07:00 | AAPL | Stock | 21.4929 | 21.4929 | 21.4929 | 21.4929 | 5600.0 |
| 2012-04-02 07:09:00 | AAPL | Stock | 21.5 | 21.5 | 21.5 | 21.5 | 2800.0 |
| 2012-04-02 07:10:00 | AAPL | Stock | 21.5 | 21.5 | 21.5 | 21.5 | 4032.0 |
| 2012-04-02 07:12:00 | AAPL | Stock | 21.5 | 21.5 | 21.5 | 21.5 | 14000.0 |
| 2012-04-02 07:13:00 | AAPL | Stock | 21.5036 | 21.5068 | 21.5036 | 21.5068 | 28812.0 |
| 2012-04-02 07:16:00 | AAPL | Stock | 21.5054 | 21.5104 | 21.5054 | 21.5104 | 8400.0 |
| 2012-04-02 07:17:00 | AAPL | Stock | 21.5057 | 21.5057 | 21.5057 | 21.5057 | 5600.0 |
| 2012-04-02 07:18:00 | AAPL | Stock | 21.5 | 21.5 | 21.4932 | 21.4932 | 24192.0 |
| 2012-04-02 07:19:00 | AAPL | Stock | 21.4857 | 21.4857 | 21.4854 | 21.4854 | 8400.0 |
| 2012-04-02 07:20:00 | AAPL | Stock | 21.4843 | 21.4843 | 21.4821 | 21.4821 | 14840.0 |
| 2012-04-02 07:21:00 | AAPL | Stock | 21.4786 | 21.4786 | 21.4689 | 21.4689 | 22260.0 |
| 2012-04-02 07:22:00 | AAPL | Stock | 21.4689 | 21.4689 | 21.4689 | 21.4689 | 2800.0 |
> showing 50 of 1,025,801 rows — these rows as CSV