PREVIEW / stock_5min / 2012-03-26
file: by_date/stock_5min/2012/2012-03-26.parquet size: 5.0 MB rows: 338,876 symbols: 3,556
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-26 04:00:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3571 | 21.3571 | 2800.0 |
| 2012-03-26 04:45:00 | AAPL | Stock | 21.3514 | 21.3514 | 21.3514 | 21.3514 | 8400.0 |
| 2012-03-26 05:10:00 | AAPL | Stock | 21.3071 | 21.3071 | 21.3071 | 21.3071 | 2800.0 |
| 2012-03-26 05:35:00 | AAPL | Stock | 21.3214 | 21.3214 | 21.3214 | 21.3214 | 23912.0 |
| 2012-03-26 06:15:00 | AAPL | Stock | 21.3446 | 21.3571 | 21.3446 | 21.3571 | 375452.0 |
| 2012-03-26 06:35:00 | AAPL | Stock | 21.3625 | 21.3625 | 21.3625 | 21.3625 | 2800.0 |
| 2012-03-26 06:40:00 | AAPL | Stock | 21.3611 | 21.3611 | 21.3611 | 21.3611 | 2800.0 |
| 2012-03-26 06:50:00 | AAPL | Stock | 21.3486 | 21.3493 | 21.3486 | 21.3493 | 5684.0 |
| 2012-03-26 06:55:00 | AAPL | Stock | 21.3611 | 21.3611 | 21.3611 | 21.3611 | 5600.0 |
| 2012-03-26 07:00:00 | AAPL | Stock | 21.3611 | 21.3768 | 21.3493 | 21.3768 | 56196.0 |
| 2012-03-26 07:05:00 | AAPL | Stock | 21.375 | 21.375 | 21.3611 | 21.3746 | 44800.0 |
| 2012-03-26 07:10:00 | AAPL | Stock | 21.3714 | 21.3925 | 21.3679 | 21.3925 | 71708.0 |
| 2012-03-26 07:15:00 | AAPL | Stock | 21.3893 | 21.4107 | 21.3886 | 21.3929 | 163184.0 |
| 2012-03-26 07:20:00 | AAPL | Stock | 21.3929 | 21.3929 | 21.3929 | 21.3929 | 2800.0 |
| 2012-03-26 07:25:00 | AAPL | Stock | 21.3925 | 21.3925 | 21.3786 | 21.3786 | 22400.0 |
| 2012-03-26 07:30:00 | AAPL | Stock | 21.3839 | 21.4018 | 21.3839 | 21.3839 | 69020.0 |
| 2012-03-26 07:35:00 | AAPL | Stock | 21.3839 | 21.3839 | 21.375 | 21.3821 | 21224.0 |
| 2012-03-26 07:40:00 | AAPL | Stock | 21.3821 | 21.3921 | 21.3821 | 21.3921 | 17444.0 |
| 2012-03-26 07:45:00 | AAPL | Stock | 21.3893 | 21.3929 | 21.3857 | 21.3857 | 112420.0 |
| 2012-03-26 07:50:00 | AAPL | Stock | 21.3882 | 21.3882 | 21.3839 | 21.3839 | 11200.0 |
| 2012-03-26 07:55:00 | AAPL | Stock | 21.3839 | 21.3839 | 21.3786 | 21.3821 | 35896.0 |
| 2012-03-26 08:00:00 | AAPL | Stock | 21.3832 | 21.3868 | 21.345 | 21.385 | 588812.0 |
| 2012-03-26 08:05:00 | AAPL | Stock | 21.385 | 21.4032 | 21.3839 | 21.3986 | 317352.0 |
| 2012-03-26 08:10:00 | AAPL | Stock | 21.4 | 21.4232 | 21.3982 | 21.4229 | 395164.0 |
| 2012-03-26 08:15:00 | AAPL | Stock | 21.4229 | 21.4425 | 21.4182 | 21.4371 | 509068.0 |
| 2012-03-26 08:20:00 | AAPL | Stock | 21.4461 | 21.4721 | 21.4429 | 21.4607 | 597492.0 |
| 2012-03-26 08:25:00 | AAPL | Stock | 21.4625 | 21.4675 | 21.4393 | 21.4536 | 611408.0 |
| 2012-03-26 08:30:00 | AAPL | Stock | 21.4561 | 21.4568 | 21.4321 | 21.445 | 235984.0 |
| 2012-03-26 08:35:00 | AAPL | Stock | 21.4457 | 21.4518 | 21.4364 | 21.4486 | 131628.0 |
| 2012-03-26 08:40:00 | AAPL | Stock | 21.4475 | 21.4475 | 21.4314 | 21.4314 | 197596.0 |
| 2012-03-26 08:45:00 | AAPL | Stock | 21.4311 | 21.4393 | 21.4286 | 21.4339 | 387632.0 |
| 2012-03-26 08:50:00 | AAPL | Stock | 21.4307 | 21.4354 | 21.4243 | 21.4286 | 375984.0 |
| 2012-03-26 08:55:00 | AAPL | Stock | 21.4321 | 21.4321 | 21.4196 | 21.4254 | 348208.0 |
| 2012-03-26 09:00:00 | AAPL | Stock | 21.4282 | 21.4286 | 21.4021 | 21.4118 | 744968.0 |
| 2012-03-26 09:05:00 | AAPL | Stock | 21.4089 | 21.4107 | 21.4018 | 21.4025 | 263424.0 |
| 2012-03-26 09:10:00 | AAPL | Stock | 21.4046 | 21.4229 | 21.4018 | 21.4136 | 185612.0 |
| 2012-03-26 09:15:00 | AAPL | Stock | 21.4193 | 21.4246 | 21.4157 | 21.4243 | 103600.0 |
| 2012-03-26 09:20:00 | AAPL | Stock | 21.4211 | 21.4229 | 21.4161 | 21.4161 | 93912.0 |
| 2012-03-26 09:25:00 | AAPL | Stock | 21.4182 | 21.4286 | 21.4071 | 21.4254 | 1097572.0 |
| 2012-03-26 09:30:00 | AAPL | Stock | 21.4211 | 21.4282 | 21.3596 | 21.3904 | 28596512.0 |
| 2012-03-26 09:35:00 | AAPL | Stock | 21.3925 | 21.3936 | 21.3489 | 21.3714 | 12930568.0 |
| 2012-03-26 09:40:00 | AAPL | Stock | 21.3711 | 21.3711 | 21.3332 | 21.3443 | 9080820.0 |
| 2012-03-26 09:45:00 | AAPL | Stock | 21.3436 | 21.3682 | 21.3239 | 21.3543 | 9980964.0 |
| 2012-03-26 09:50:00 | AAPL | Stock | 21.3539 | 21.3571 | 21.3304 | 21.3334 | 6952092.0 |
| 2012-03-26 09:55:00 | AAPL | Stock | 21.3361 | 21.3875 | 21.3345 | 21.3789 | 8901900.0 |
| 2012-03-26 10:00:00 | AAPL | Stock | 21.3721 | 21.38 | 21.3596 | 21.3657 | 5258008.0 |
| 2012-03-26 10:05:00 | AAPL | Stock | 21.3687 | 21.3739 | 21.3471 | 21.3607 | 5827752.0 |
| 2012-03-26 10:10:00 | AAPL | Stock | 21.366 | 21.37 | 21.3325 | 21.3325 | 6687492.0 |
| 2012-03-26 10:15:00 | AAPL | Stock | 21.3321 | 21.3512 | 21.2857 | 21.3036 | 14879172.0 |
| 2012-03-26 10:20:00 | AAPL | Stock | 21.3036 | 21.3082 | 21.265 | 21.2975 | 11448584.0 |
> showing 50 of 338,876 rows — these rows as CSV