PREVIEW / stock_1min / 2012-08-23
file: by_date/stock_1min/2012/2012-08-23.parquet size: 11.8 MB rows: 879,359 symbols: 2,777
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-08-23 04:00:00 | AAPL | Stock | 23.9286 | 24.0118 | 23.9286 | 24.0118 | 8400.0 |
| 2012-08-23 04:02:00 | AAPL | Stock | 24.0004 | 24.0179 | 24.0004 | 24.0179 | 8400.0 |
| 2012-08-23 04:03:00 | AAPL | Stock | 24.0179 | 24.0179 | 24.0179 | 24.0179 | 15036.0 |
| 2012-08-23 04:06:00 | AAPL | Stock | 24.0089 | 24.0089 | 24.0004 | 24.0004 | 14140.0 |
| 2012-08-23 04:22:00 | AAPL | Stock | 24.0179 | 24.0179 | 24.0179 | 24.0179 | 11200.0 |
| 2012-08-23 04:23:00 | AAPL | Stock | 24.0354 | 24.0354 | 24.0354 | 24.0354 | 2800.0 |
| 2012-08-23 04:26:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 2800.0 |
| 2012-08-23 04:32:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 6944.0 |
| 2012-08-23 04:33:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 5656.0 |
| 2012-08-23 04:52:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 5600.0 |
| 2012-08-23 04:59:00 | AAPL | Stock | 23.9911 | 23.9911 | 23.9911 | 23.9911 | 2800.0 |
| 2012-08-23 05:00:00 | AAPL | Stock | 23.9861 | 23.9861 | 23.9861 | 23.9861 | 2800.0 |
| 2012-08-23 05:17:00 | AAPL | Stock | 24.0004 | 24.0004 | 24.0 | 24.0 | 5600.0 |
| 2012-08-23 05:18:00 | AAPL | Stock | 24.0046 | 24.0046 | 24.0046 | 24.0046 | 5880.0 |
| 2012-08-23 05:22:00 | AAPL | Stock | 24.0068 | 24.0068 | 24.0068 | 24.0068 | 2800.0 |
| 2012-08-23 05:23:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 5600.0 |
| 2012-08-23 05:24:00 | AAPL | Stock | 23.9929 | 23.9929 | 23.9929 | 23.9929 | 11200.0 |
| 2012-08-23 05:25:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 8400.0 |
| 2012-08-23 05:36:00 | AAPL | Stock | 24.0071 | 24.0071 | 24.0071 | 24.0071 | 8400.0 |
| 2012-08-23 05:44:00 | AAPL | Stock | 24.0071 | 24.0071 | 24.0071 | 24.0071 | 14000.0 |
| 2012-08-23 06:09:00 | AAPL | Stock | 24.0154 | 24.0154 | 24.0154 | 24.0154 | 2800.0 |
| 2012-08-23 06:11:00 | AAPL | Stock | 24.0114 | 24.0114 | 24.0114 | 24.0114 | 2800.0 |
| 2012-08-23 06:22:00 | AAPL | Stock | 24.0211 | 24.0214 | 24.0079 | 24.0079 | 8400.0 |
| 2012-08-23 06:30:00 | AAPL | Stock | 24.0207 | 24.0214 | 24.0207 | 24.0214 | 12600.0 |
| 2012-08-23 06:31:00 | AAPL | Stock | 24.01 | 24.01 | 24.01 | 24.01 | 2800.0 |
| 2012-08-23 06:32:00 | AAPL | Stock | 24.0193 | 24.0193 | 24.0193 | 24.0193 | 5600.0 |
| 2012-08-23 06:43:00 | AAPL | Stock | 24.0071 | 24.0071 | 24.0071 | 24.0071 | 2800.0 |
| 2012-08-23 06:44:00 | AAPL | Stock | 24.0039 | 24.0039 | 24.0036 | 24.0036 | 5600.0 |
| 2012-08-23 06:45:00 | AAPL | Stock | 24.0011 | 24.0011 | 24.0 | 24.0 | 8400.0 |
| 2012-08-23 06:49:00 | AAPL | Stock | 23.9946 | 23.9946 | 23.9946 | 23.9946 | 3080.0 |
| 2012-08-23 07:00:00 | AAPL | Stock | 23.9857 | 23.9857 | 23.9857 | 23.9857 | 4900.0 |
| 2012-08-23 07:01:00 | AAPL | Stock | 23.975 | 23.9929 | 23.975 | 23.9929 | 28000.0 |
| 2012-08-23 07:02:00 | AAPL | Stock | 23.9857 | 23.9943 | 23.9786 | 23.9943 | 72940.0 |
| 2012-08-23 07:03:00 | AAPL | Stock | 23.9946 | 23.9946 | 23.9925 | 23.9946 | 14168.0 |
| 2012-08-23 07:04:00 | AAPL | Stock | 23.9946 | 24.0 | 23.9946 | 24.0 | 15848.0 |
| 2012-08-23 07:05:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 2800.0 |
| 2012-08-23 07:06:00 | AAPL | Stock | 23.9946 | 23.995 | 23.9946 | 23.995 | 12320.0 |
| 2012-08-23 07:07:00 | AAPL | Stock | 24.0 | 24.0004 | 24.0 | 24.0004 | 11200.0 |
| 2012-08-23 07:08:00 | AAPL | Stock | 24.0 | 24.0 | 23.9843 | 23.9843 | 96460.0 |
| 2012-08-23 07:10:00 | AAPL | Stock | 23.9989 | 23.9989 | 23.9989 | 23.9989 | 8400.0 |
| 2012-08-23 07:11:00 | AAPL | Stock | 23.9821 | 23.9829 | 23.9821 | 23.9829 | 18760.0 |
| 2012-08-23 07:12:00 | AAPL | Stock | 23.9839 | 23.9839 | 23.9821 | 23.9821 | 15400.0 |
| 2012-08-23 07:14:00 | AAPL | Stock | 23.9771 | 23.9771 | 23.9643 | 23.9643 | 42784.0 |
| 2012-08-23 07:15:00 | AAPL | Stock | 23.9746 | 23.9771 | 23.9746 | 23.9771 | 10836.0 |
| 2012-08-23 07:16:00 | AAPL | Stock | 23.9746 | 23.9771 | 23.9746 | 23.9771 | 24444.0 |
| 2012-08-23 07:17:00 | AAPL | Stock | 23.9786 | 23.9786 | 23.9682 | 23.9693 | 11200.0 |
| 2012-08-23 07:18:00 | AAPL | Stock | 23.975 | 23.975 | 23.975 | 23.975 | 2800.0 |
| 2012-08-23 07:19:00 | AAPL | Stock | 23.975 | 23.9786 | 23.9746 | 23.9786 | 30800.0 |
| 2012-08-23 07:20:00 | AAPL | Stock | 23.9786 | 23.9821 | 23.975 | 23.9821 | 32760.0 |
| 2012-08-23 07:22:00 | AAPL | Stock | 23.9893 | 23.9893 | 23.9893 | 23.9893 | 2800.0 |
> showing 50 of 879,359 rows — these rows as CSV