PREVIEW / stock_5min / 2012-05-10
file: by_date/stock_5min/2012/2012-05-10.parquet size: 4.9 MB rows: 330,739 symbols: 3,524
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-05-10 04:00:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 25900.0 |
| 2012-05-10 04:10:00 | AAPL | Stock | 20.325 | 20.325 | 20.3246 | 20.3246 | 5600.0 |
| 2012-05-10 04:15:00 | AAPL | Stock | 20.3246 | 20.3286 | 20.3246 | 20.3286 | 5600.0 |
| 2012-05-10 04:25:00 | AAPL | Stock | 20.2896 | 20.2896 | 20.2821 | 20.2821 | 50400.0 |
| 2012-05-10 04:30:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 2800.0 |
| 2012-05-10 04:35:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 2800.0 |
| 2012-05-10 04:40:00 | AAPL | Stock | 20.2893 | 20.2893 | 20.2893 | 20.2893 | 2800.0 |
| 2012-05-10 04:45:00 | AAPL | Stock | 20.2893 | 20.2893 | 20.2893 | 20.2893 | 8344.0 |
| 2012-05-10 05:05:00 | AAPL | Stock | 20.2771 | 20.2771 | 20.2771 | 20.2771 | 14000.0 |
| 2012-05-10 05:15:00 | AAPL | Stock | 20.2643 | 20.2643 | 20.2643 | 20.2643 | 9212.0 |
| 2012-05-10 05:25:00 | AAPL | Stock | 20.2643 | 20.2643 | 20.2643 | 20.2643 | 5880.0 |
| 2012-05-10 05:30:00 | AAPL | Stock | 20.2643 | 20.2643 | 20.2643 | 20.2643 | 7336.0 |
| 2012-05-10 06:15:00 | AAPL | Stock | 20.2643 | 20.2643 | 20.2643 | 20.2643 | 2800.0 |
| 2012-05-10 06:30:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 2800.0 |
| 2012-05-10 06:35:00 | AAPL | Stock | 20.3 | 20.3446 | 20.3 | 20.3446 | 25200.0 |
| 2012-05-10 06:45:00 | AAPL | Stock | 20.3446 | 20.3446 | 20.3446 | 20.3446 | 2800.0 |
| 2012-05-10 06:50:00 | AAPL | Stock | 20.33 | 20.33 | 20.33 | 20.33 | 4732.0 |
| 2012-05-10 06:55:00 | AAPL | Stock | 20.3554 | 20.3725 | 20.3554 | 20.3725 | 38920.0 |
| 2012-05-10 07:00:00 | AAPL | Stock | 20.3739 | 20.4068 | 20.3739 | 20.3925 | 26600.0 |
| 2012-05-10 07:05:00 | AAPL | Stock | 20.3893 | 20.4075 | 20.3893 | 20.4075 | 36540.0 |
| 2012-05-10 07:10:00 | AAPL | Stock | 20.4075 | 20.4107 | 20.4075 | 20.4107 | 13468.0 |
| 2012-05-10 07:15:00 | AAPL | Stock | 20.395 | 20.3957 | 20.3929 | 20.3929 | 8400.0 |
| 2012-05-10 07:25:00 | AAPL | Stock | 20.4018 | 20.4061 | 20.4018 | 20.4057 | 26600.0 |
| 2012-05-10 07:30:00 | AAPL | Stock | 20.4089 | 20.4311 | 20.4089 | 20.4311 | 16800.0 |
| 2012-05-10 07:35:00 | AAPL | Stock | 20.4286 | 20.4375 | 20.4164 | 20.4375 | 19600.0 |
| 2012-05-10 07:40:00 | AAPL | Stock | 20.4296 | 20.4375 | 20.4296 | 20.4375 | 18172.0 |
| 2012-05-10 07:45:00 | AAPL | Stock | 20.4454 | 20.5357 | 20.4454 | 20.4989 | 198940.0 |
| 2012-05-10 07:50:00 | AAPL | Stock | 20.49 | 20.5046 | 20.4857 | 20.4893 | 50400.0 |
| 2012-05-10 07:55:00 | AAPL | Stock | 20.5 | 20.5004 | 20.4821 | 20.4964 | 108444.0 |
| 2012-05-10 08:00:00 | AAPL | Stock | 20.4911 | 20.5207 | 20.4186 | 20.5025 | 369516.0 |
| 2012-05-10 08:05:00 | AAPL | Stock | 20.5039 | 20.5143 | 20.4929 | 20.5093 | 144340.0 |
| 2012-05-10 08:10:00 | AAPL | Stock | 20.5036 | 20.5179 | 20.5 | 20.5071 | 380800.0 |
| 2012-05-10 08:15:00 | AAPL | Stock | 20.5039 | 20.5246 | 20.5007 | 20.5143 | 237720.0 |
| 2012-05-10 08:20:00 | AAPL | Stock | 20.5096 | 20.5143 | 20.4918 | 20.4946 | 186060.0 |
| 2012-05-10 08:25:00 | AAPL | Stock | 20.495 | 20.5132 | 20.495 | 20.5132 | 126280.0 |
| 2012-05-10 08:30:00 | AAPL | Stock | 20.5168 | 20.5168 | 20.4879 | 20.5 | 240016.0 |
| 2012-05-10 08:35:00 | AAPL | Stock | 20.4982 | 20.5157 | 20.495 | 20.5157 | 195020.0 |
| 2012-05-10 08:40:00 | AAPL | Stock | 20.5132 | 20.5279 | 20.5132 | 20.5229 | 253512.0 |
| 2012-05-10 08:45:00 | AAPL | Stock | 20.525 | 20.5318 | 20.5196 | 20.5268 | 238896.0 |
| 2012-05-10 08:50:00 | AAPL | Stock | 20.5268 | 20.5286 | 20.4918 | 20.5182 | 500612.0 |
| 2012-05-10 08:55:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.505 | 20.5054 | 174440.0 |
| 2012-05-10 09:00:00 | AAPL | Stock | 20.5039 | 20.5057 | 20.4911 | 20.5 | 345632.0 |
| 2012-05-10 09:05:00 | AAPL | Stock | 20.505 | 20.5125 | 20.4996 | 20.5079 | 138516.0 |
| 2012-05-10 09:10:00 | AAPL | Stock | 20.5129 | 20.5129 | 20.5036 | 20.5107 | 307076.0 |
| 2012-05-10 09:15:00 | AAPL | Stock | 20.5107 | 20.5286 | 20.5064 | 20.5243 | 323680.0 |
| 2012-05-10 09:20:00 | AAPL | Stock | 20.5243 | 20.5286 | 20.5093 | 20.5179 | 283920.0 |
| 2012-05-10 09:25:00 | AAPL | Stock | 20.5129 | 20.5425 | 20.5107 | 20.5357 | 1237460.0 |
| 2012-05-10 09:30:00 | AAPL | Stock | 20.5354 | 20.5671 | 20.4786 | 20.5103 | 19096224.0 |
| 2012-05-10 09:35:00 | AAPL | Stock | 20.5036 | 20.51 | 20.4536 | 20.4841 | 11684848.0 |
| 2012-05-10 09:40:00 | AAPL | Stock | 20.4865 | 20.4865 | 20.4232 | 20.4579 | 8775284.0 |
> showing 50 of 330,739 rows — these rows as CSV