PREVIEW / stock_5min / 2012-03-02
file: by_date/stock_5min/2012/2012-03-02.parquet size: 4.9 MB rows: 330,702 symbols: 3,498
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-03-02 06:20:00 | AAPL | Stock | 19.4464 | 19.4464 | 19.4464 | 19.4464 | 5600.0 |
| 2012-03-02 06:30:00 | AAPL | Stock | 19.4464 | 19.4464 | 19.4464 | 19.4464 | 2800.0 |
| 2012-03-02 07:00:00 | AAPL | Stock | 19.4443 | 19.4443 | 19.4096 | 19.4096 | 88956.0 |
| 2012-03-02 07:05:00 | AAPL | Stock | 19.4104 | 19.4129 | 19.4036 | 19.4036 | 50400.0 |
| 2012-03-02 07:10:00 | AAPL | Stock | 19.4082 | 19.4136 | 19.4014 | 19.4129 | 57120.0 |
| 2012-03-02 07:15:00 | AAPL | Stock | 19.4196 | 19.4268 | 19.4196 | 19.425 | 87164.0 |
| 2012-03-02 07:20:00 | AAPL | Stock | 19.4154 | 19.4261 | 19.4154 | 19.4232 | 32844.0 |
| 2012-03-02 07:25:00 | AAPL | Stock | 19.4179 | 19.4196 | 19.4179 | 19.4196 | 12880.0 |
| 2012-03-02 07:30:00 | AAPL | Stock | 19.4161 | 19.4204 | 19.4125 | 19.4196 | 77924.0 |
| 2012-03-02 07:35:00 | AAPL | Stock | 19.4136 | 19.4136 | 19.3714 | 19.375 | 271740.0 |
| 2012-03-02 07:40:00 | AAPL | Stock | 19.3743 | 19.3929 | 19.3743 | 19.3929 | 210560.0 |
| 2012-03-02 07:45:00 | AAPL | Stock | 19.3946 | 19.3946 | 19.3864 | 19.3864 | 8400.0 |
| 2012-03-02 07:50:00 | AAPL | Stock | 19.3929 | 19.4064 | 19.3893 | 19.3982 | 132300.0 |
| 2012-03-02 07:55:00 | AAPL | Stock | 19.3939 | 19.4029 | 19.3939 | 19.4029 | 26320.0 |
| 2012-03-02 08:00:00 | AAPL | Stock | 19.4071 | 19.4386 | 19.3975 | 19.4386 | 857052.0 |
| 2012-03-02 08:05:00 | AAPL | Stock | 19.4318 | 19.4464 | 19.4204 | 19.4204 | 285264.0 |
| 2012-03-02 08:10:00 | AAPL | Stock | 19.4139 | 19.4214 | 19.3979 | 19.4107 | 417508.0 |
| 2012-03-02 08:15:00 | AAPL | Stock | 19.4107 | 19.4207 | 19.4104 | 19.4179 | 177940.0 |
| 2012-03-02 08:20:00 | AAPL | Stock | 19.4107 | 19.4111 | 19.3929 | 19.4039 | 514836.0 |
| 2012-03-02 08:25:00 | AAPL | Stock | 19.4079 | 19.415 | 19.4057 | 19.4143 | 47516.0 |
| 2012-03-02 08:30:00 | AAPL | Stock | 19.4139 | 19.4161 | 19.4036 | 19.4161 | 69160.0 |
| 2012-03-02 08:35:00 | AAPL | Stock | 19.4193 | 19.4243 | 19.4179 | 19.4182 | 87472.0 |
| 2012-03-02 08:40:00 | AAPL | Stock | 19.415 | 19.415 | 19.4082 | 19.4086 | 38640.0 |
| 2012-03-02 08:45:00 | AAPL | Stock | 19.4071 | 19.4211 | 19.4036 | 19.4039 | 149912.0 |
| 2012-03-02 08:50:00 | AAPL | Stock | 19.4132 | 19.4132 | 19.3968 | 19.3971 | 95648.0 |
| 2012-03-02 08:55:00 | AAPL | Stock | 19.3971 | 19.4054 | 19.3964 | 19.4007 | 60200.0 |
| 2012-03-02 09:00:00 | AAPL | Stock | 19.4032 | 19.4179 | 19.4007 | 19.4114 | 187600.0 |
| 2012-03-02 09:05:00 | AAPL | Stock | 19.4129 | 19.4179 | 19.4104 | 19.4104 | 115360.0 |
| 2012-03-02 09:10:00 | AAPL | Stock | 19.4093 | 19.4179 | 19.4068 | 19.4179 | 76188.0 |
| 2012-03-02 09:15:00 | AAPL | Stock | 19.4193 | 19.4411 | 19.4189 | 19.4286 | 249256.0 |
| 2012-03-02 09:20:00 | AAPL | Stock | 19.4289 | 19.4289 | 19.4125 | 19.4193 | 92820.0 |
| 2012-03-02 09:25:00 | AAPL | Stock | 19.4239 | 19.4554 | 19.4214 | 19.4339 | 592200.0 |
| 2012-03-02 09:30:00 | AAPL | Stock | 19.4371 | 19.4718 | 19.3957 | 19.4568 | 17790472.0 |
| 2012-03-02 09:35:00 | AAPL | Stock | 19.4507 | 19.455 | 19.4107 | 19.4254 | 10662260.0 |
| 2012-03-02 09:40:00 | AAPL | Stock | 19.4245 | 19.4296 | 19.3757 | 19.3868 | 11015564.0 |
| 2012-03-02 09:45:00 | AAPL | Stock | 19.3857 | 19.4107 | 19.3839 | 19.3982 | 8071112.0 |
| 2012-03-02 09:50:00 | AAPL | Stock | 19.3986 | 19.4414 | 19.3943 | 19.4111 | 12241488.0 |
| 2012-03-02 09:55:00 | AAPL | Stock | 19.4125 | 19.4193 | 19.3929 | 19.4079 | 6374116.0 |
| 2012-03-02 10:00:00 | AAPL | Stock | 19.4075 | 19.4189 | 19.3857 | 19.3896 | 9245936.0 |
| 2012-03-02 10:05:00 | AAPL | Stock | 19.3914 | 19.4214 | 19.3857 | 19.42 | 5862752.0 |
| 2012-03-02 10:10:00 | AAPL | Stock | 19.42 | 19.425 | 19.4075 | 19.4104 | 5837608.0 |
| 2012-03-02 10:15:00 | AAPL | Stock | 19.41 | 19.4304 | 19.4082 | 19.4126 | 6849668.0 |
| 2012-03-02 10:20:00 | AAPL | Stock | 19.4136 | 19.4325 | 19.4111 | 19.4132 | 4183844.0 |
| 2012-03-02 10:25:00 | AAPL | Stock | 19.4164 | 19.4564 | 19.4125 | 19.4446 | 7851480.0 |
| 2012-03-02 10:30:00 | AAPL | Stock | 19.4404 | 19.4429 | 19.4239 | 19.4362 | 4350332.0 |
| 2012-03-02 10:35:00 | AAPL | Stock | 19.4355 | 19.4368 | 19.4211 | 19.4275 | 3671360.0 |
| 2012-03-02 10:40:00 | AAPL | Stock | 19.4282 | 19.4446 | 19.4261 | 19.4396 | 5048428.0 |
| 2012-03-02 10:45:00 | AAPL | Stock | 19.4404 | 19.4489 | 19.4225 | 19.4329 | 5349932.0 |
| 2012-03-02 10:50:00 | AAPL | Stock | 19.4332 | 19.4446 | 19.4304 | 19.4404 | 3723580.0 |
| 2012-03-02 10:55:00 | AAPL | Stock | 19.4411 | 19.4411 | 19.425 | 19.4354 | 3919496.0 |
> showing 50 of 330,702 rows — these rows as CSV