PREVIEW / stock_1min / 2013-04-02
file: by_date/stock_1min/2013/2013-04-02.parquet size: 13.6 MB rows: 1,000,680 symbols: 2,819
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-02 04:00:00 | AAPL | Stock | 15.295 | 15.295 | 15.2107 | 15.2143 | 36400.0 |
| 2013-04-02 04:09:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 2800.0 |
| 2013-04-02 04:11:00 | AAPL | Stock | 15.25 | 15.25 | 15.2143 | 15.2143 | 7280.0 |
| 2013-04-02 04:42:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 2940.0 |
| 2013-04-02 04:52:00 | AAPL | Stock | 15.2429 | 15.2429 | 15.2429 | 15.2429 | 2800.0 |
| 2013-04-02 04:54:00 | AAPL | Stock | 15.25 | 15.25 | 15.2429 | 15.2429 | 14000.0 |
| 2013-04-02 05:08:00 | AAPL | Stock | 15.2504 | 15.2504 | 15.2504 | 15.2504 | 5600.0 |
| 2013-04-02 05:22:00 | AAPL | Stock | 15.2511 | 15.2511 | 15.2511 | 15.2511 | 2800.0 |
| 2013-04-02 05:23:00 | AAPL | Stock | 15.28 | 15.28 | 15.28 | 15.28 | 2800.0 |
| 2013-04-02 05:24:00 | AAPL | Stock | 15.2821 | 15.2821 | 15.2821 | 15.2821 | 2800.0 |
| 2013-04-02 05:41:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2857 | 15.2857 | 4144.0 |
| 2013-04-02 05:48:00 | AAPL | Stock | 15.3154 | 15.3154 | 15.3154 | 15.3154 | 2800.0 |
| 2013-04-02 05:49:00 | AAPL | Stock | 15.3154 | 15.3154 | 15.3154 | 15.3154 | 2800.0 |
| 2013-04-02 06:07:00 | AAPL | Stock | 15.2911 | 15.2911 | 15.2911 | 15.2911 | 2800.0 |
| 2013-04-02 06:10:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2857 | 15.2857 | 14000.0 |
| 2013-04-02 06:21:00 | AAPL | Stock | 15.2946 | 15.2946 | 15.2946 | 15.2946 | 8400.0 |
| 2013-04-02 06:30:00 | AAPL | Stock | 15.2804 | 15.2804 | 15.2804 | 15.2804 | 4200.0 |
| 2013-04-02 06:31:00 | AAPL | Stock | 15.2929 | 15.2929 | 15.2929 | 15.2929 | 48496.0 |
| 2013-04-02 06:42:00 | AAPL | Stock | 15.2946 | 15.2946 | 15.2946 | 15.2946 | 13720.0 |
| 2013-04-02 06:46:00 | AAPL | Stock | 15.2946 | 15.2946 | 15.2946 | 15.2946 | 2800.0 |
| 2013-04-02 06:47:00 | AAPL | Stock | 15.2946 | 15.2946 | 15.2946 | 15.2946 | 2800.0 |
| 2013-04-02 06:50:00 | AAPL | Stock | 15.3018 | 15.3036 | 15.3018 | 15.3036 | 14084.0 |
| 2013-04-02 06:58:00 | AAPL | Stock | 15.3143 | 15.3143 | 15.3143 | 15.3143 | 2800.0 |
| 2013-04-02 07:00:00 | AAPL | Stock | 15.3143 | 15.3143 | 15.3143 | 15.3143 | 5068.0 |
| 2013-04-02 07:02:00 | AAPL | Stock | 15.3554 | 15.3554 | 15.3518 | 15.3518 | 5656.0 |
| 2013-04-02 07:03:00 | AAPL | Stock | 15.3411 | 15.3571 | 15.3411 | 15.3571 | 12600.0 |
| 2013-04-02 07:04:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 2800.0 |
| 2013-04-02 07:06:00 | AAPL | Stock | 15.3579 | 15.3732 | 15.3579 | 15.3732 | 5600.0 |
| 2013-04-02 07:07:00 | AAPL | Stock | 15.375 | 15.375 | 15.3693 | 15.3693 | 8400.0 |
| 2013-04-02 07:08:00 | AAPL | Stock | 15.3571 | 15.3714 | 15.3571 | 15.3707 | 25200.0 |
| 2013-04-02 07:09:00 | AAPL | Stock | 15.3589 | 15.3589 | 15.3586 | 15.3586 | 5600.0 |
| 2013-04-02 07:10:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3486 | 15.3486 | 47936.0 |
| 2013-04-02 07:11:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 5600.0 |
| 2013-04-02 07:12:00 | AAPL | Stock | 15.355 | 15.3571 | 15.355 | 15.3571 | 26488.0 |
| 2013-04-02 07:17:00 | AAPL | Stock | 15.35 | 15.35 | 15.35 | 15.35 | 36400.0 |
| 2013-04-02 07:18:00 | AAPL | Stock | 15.3521 | 15.3571 | 15.3521 | 15.3571 | 26152.0 |
| 2013-04-02 07:21:00 | AAPL | Stock | 15.365 | 15.365 | 15.3643 | 15.3643 | 34832.0 |
| 2013-04-02 07:23:00 | AAPL | Stock | 15.3693 | 15.3693 | 15.3693 | 15.3693 | 2800.0 |
| 2013-04-02 07:25:00 | AAPL | Stock | 15.3714 | 15.3857 | 15.3714 | 15.3857 | 55328.0 |
| 2013-04-02 07:27:00 | AAPL | Stock | 15.3911 | 15.3929 | 15.3911 | 15.3929 | 19600.0 |
| 2013-04-02 07:29:00 | AAPL | Stock | 15.3943 | 15.3943 | 15.3929 | 15.3929 | 24920.0 |
| 2013-04-02 07:30:00 | AAPL | Stock | 15.405 | 15.4196 | 15.405 | 15.4143 | 91000.0 |
| 2013-04-02 07:31:00 | AAPL | Stock | 15.4075 | 15.4075 | 15.4071 | 15.4071 | 8400.0 |
| 2013-04-02 07:32:00 | AAPL | Stock | 15.3864 | 15.3864 | 15.3857 | 15.3857 | 5600.0 |
| 2013-04-02 07:33:00 | AAPL | Stock | 15.3964 | 15.3964 | 15.3857 | 15.3857 | 39676.0 |
| 2013-04-02 07:34:00 | AAPL | Stock | 15.3957 | 15.4036 | 15.3957 | 15.4036 | 72800.0 |
| 2013-04-02 07:35:00 | AAPL | Stock | 15.4036 | 15.4071 | 15.4036 | 15.4071 | 14000.0 |
| 2013-04-02 07:38:00 | AAPL | Stock | 15.4046 | 15.4046 | 15.4046 | 15.4046 | 5600.0 |
| 2013-04-02 07:40:00 | AAPL | Stock | 15.4007 | 15.4007 | 15.3879 | 15.3879 | 42000.0 |
| 2013-04-02 07:41:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 26012.0 |
> showing 50 of 1,000,680 rows — these rows as CSV