PREVIEW / stock_5min / 2010-06-02
file: by_date/stock_5min/2010/2010-06-02.parquet size: 4.9 MB rows: 335,648 symbols: 3,475
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-02 04:05:00 | AAPL | Stock | 9.3932 | 9.3932 | 9.3932 | 9.3932 | 14000.0 |
| 2010-06-02 04:10:00 | AAPL | Stock | 9.3868 | 9.3886 | 9.3868 | 9.3886 | 25200.0 |
| 2010-06-02 04:15:00 | AAPL | Stock | 9.3843 | 9.3843 | 9.3754 | 9.3843 | 19600.0 |
| 2010-06-02 04:20:00 | AAPL | Stock | 9.4314 | 9.4314 | 9.3654 | 9.3664 | 30800.0 |
| 2010-06-02 05:30:00 | AAPL | Stock | 9.4204 | 9.4261 | 9.4204 | 9.4261 | 5600.0 |
| 2010-06-02 06:10:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 8120.0 |
| 2010-06-02 06:15:00 | AAPL | Stock | 9.42 | 9.4407 | 9.4186 | 9.4407 | 16800.0 |
| 2010-06-02 06:45:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 2800.0 |
| 2010-06-02 06:55:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 2800.0 |
| 2010-06-02 07:00:00 | AAPL | Stock | 9.425 | 9.4286 | 9.4118 | 9.4143 | 83300.0 |
| 2010-06-02 07:05:00 | AAPL | Stock | 9.4118 | 9.4175 | 9.4096 | 9.4104 | 42000.0 |
| 2010-06-02 07:10:00 | AAPL | Stock | 9.4179 | 9.4214 | 9.4179 | 9.4214 | 22876.0 |
| 2010-06-02 07:15:00 | AAPL | Stock | 9.4114 | 9.4286 | 9.4107 | 9.425 | 59584.0 |
| 2010-06-02 07:20:00 | AAPL | Stock | 9.4239 | 9.4239 | 9.4143 | 9.4143 | 16380.0 |
| 2010-06-02 07:25:00 | AAPL | Stock | 9.4214 | 9.4321 | 9.4211 | 9.4321 | 72800.0 |
| 2010-06-02 07:30:00 | AAPL | Stock | 9.4368 | 9.4368 | 9.4146 | 9.4146 | 28000.0 |
| 2010-06-02 07:35:00 | AAPL | Stock | 9.4132 | 9.4204 | 9.4132 | 9.4204 | 8400.0 |
| 2010-06-02 07:40:00 | AAPL | Stock | 9.425 | 9.4286 | 9.4189 | 9.4189 | 53424.0 |
| 2010-06-02 07:45:00 | AAPL | Stock | 9.4186 | 9.4264 | 9.3971 | 9.3971 | 165480.0 |
| 2010-06-02 07:50:00 | AAPL | Stock | 9.3971 | 9.4064 | 9.3946 | 9.4046 | 81424.0 |
| 2010-06-02 07:55:00 | AAPL | Stock | 9.4096 | 9.4143 | 9.4071 | 9.4071 | 48300.0 |
| 2010-06-02 08:00:00 | AAPL | Stock | 9.4071 | 9.4264 | 9.4018 | 9.4225 | 1010520.0 |
| 2010-06-02 08:05:00 | AAPL | Stock | 9.4248 | 9.4464 | 9.4243 | 9.4429 | 843920.0 |
| 2010-06-02 08:10:00 | AAPL | Stock | 9.4425 | 9.4464 | 9.4325 | 9.4429 | 562996.0 |
| 2010-06-02 08:15:00 | AAPL | Stock | 9.4429 | 9.455 | 9.4407 | 9.4529 | 973980.0 |
| 2010-06-02 08:20:00 | AAPL | Stock | 9.4504 | 9.4504 | 9.4364 | 9.4464 | 592424.0 |
| 2010-06-02 08:25:00 | AAPL | Stock | 9.4436 | 9.4489 | 9.4325 | 9.4382 | 468524.0 |
| 2010-06-02 08:30:00 | AAPL | Stock | 9.44 | 9.445 | 9.4289 | 9.4339 | 361200.0 |
| 2010-06-02 08:35:00 | AAPL | Stock | 9.4361 | 9.4386 | 9.4243 | 9.4293 | 468608.0 |
| 2010-06-02 08:40:00 | AAPL | Stock | 9.4296 | 9.4296 | 9.4196 | 9.4232 | 410900.0 |
| 2010-06-02 08:45:00 | AAPL | Stock | 9.4229 | 9.4264 | 9.4164 | 9.4189 | 325836.0 |
| 2010-06-02 08:50:00 | AAPL | Stock | 9.4196 | 9.4254 | 9.4193 | 9.4254 | 134120.0 |
| 2010-06-02 08:55:00 | AAPL | Stock | 9.4268 | 9.43 | 9.4179 | 9.4254 | 258048.0 |
| 2010-06-02 09:00:00 | AAPL | Stock | 9.4257 | 9.4275 | 9.4229 | 9.425 | 264292.0 |
| 2010-06-02 09:05:00 | AAPL | Stock | 9.425 | 9.4268 | 9.4214 | 9.4214 | 333340.0 |
| 2010-06-02 09:10:00 | AAPL | Stock | 9.4246 | 9.4275 | 9.4232 | 9.425 | 368368.0 |
| 2010-06-02 09:15:00 | AAPL | Stock | 9.425 | 9.4393 | 9.425 | 9.4379 | 411572.0 |
| 2010-06-02 09:20:00 | AAPL | Stock | 9.4393 | 9.4425 | 9.4354 | 9.4386 | 194180.0 |
| 2010-06-02 09:25:00 | AAPL | Stock | 9.4389 | 9.4525 | 9.4318 | 9.4479 | 1245384.0 |
| 2010-06-02 09:30:00 | AAPL | Stock | 9.4479 | 9.4571 | 9.4114 | 9.4161 | 29570604.0 |
| 2010-06-02 09:35:00 | AAPL | Stock | 9.4164 | 9.4336 | 9.3754 | 9.3754 | 19995220.0 |
| 2010-06-02 09:40:00 | AAPL | Stock | 9.3754 | 9.3868 | 9.3393 | 9.3714 | 18317544.0 |
| 2010-06-02 09:45:00 | AAPL | Stock | 9.3736 | 9.3854 | 9.3579 | 9.3761 | 12373760.0 |
| 2010-06-02 09:50:00 | AAPL | Stock | 9.3757 | 9.3782 | 9.325 | 9.3501 | 17775436.0 |
| 2010-06-02 09:55:00 | AAPL | Stock | 9.3554 | 9.3964 | 9.3539 | 9.3843 | 16308348.0 |
| 2010-06-02 10:00:00 | AAPL | Stock | 9.3864 | 9.4014 | 9.3732 | 9.3946 | 14487984.0 |
| 2010-06-02 10:05:00 | AAPL | Stock | 9.3971 | 9.4098 | 9.3871 | 9.4007 | 11896836.0 |
| 2010-06-02 10:10:00 | AAPL | Stock | 9.4013 | 9.4175 | 9.3869 | 9.3929 | 11035864.0 |
| 2010-06-02 10:15:00 | AAPL | Stock | 9.3939 | 9.4104 | 9.3893 | 9.4011 | 8175104.0 |
| 2010-06-02 10:20:00 | AAPL | Stock | 9.4004 | 9.4225 | 9.4 | 9.4139 | 10955980.0 |
> showing 50 of 335,648 rows — these rows as CSV