PREVIEW / stock_5min / 2012-03-09
file: by_date/stock_5min/2012/2012-03-09.parquet size: 4.8 MB rows: 325,074 symbols: 3,507
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-09 04:00:00 | AAPL | Stock | 19.3929 | 19.4068 | 19.3929 | 19.3929 | 53200.0 |
| 2012-03-09 04:05:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 14000.0 |
| 2012-03-09 04:15:00 | AAPL | Stock | 19.4107 | 19.4107 | 19.4107 | 19.4107 | 8400.0 |
| 2012-03-09 04:20:00 | AAPL | Stock | 19.4321 | 19.4321 | 19.4321 | 19.4321 | 6440.0 |
| 2012-03-09 04:30:00 | AAPL | Stock | 19.4143 | 19.4143 | 19.4143 | 19.4143 | 5572.0 |
| 2012-03-09 05:00:00 | AAPL | Stock | 19.4243 | 19.4243 | 19.4243 | 19.4243 | 8400.0 |
| 2012-03-09 05:10:00 | AAPL | Stock | 19.4196 | 19.4196 | 19.4196 | 19.4196 | 2800.0 |
| 2012-03-09 05:40:00 | AAPL | Stock | 19.4429 | 19.4429 | 19.4429 | 19.4429 | 11200.0 |
| 2012-03-09 05:45:00 | AAPL | Stock | 19.4214 | 19.4214 | 19.4179 | 19.4179 | 33600.0 |
| 2012-03-09 05:55:00 | AAPL | Stock | 19.4196 | 19.4196 | 19.4196 | 19.4196 | 5600.0 |
| 2012-03-09 06:00:00 | AAPL | Stock | 19.3964 | 19.3964 | 19.3929 | 19.3929 | 22400.0 |
| 2012-03-09 06:05:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 16800.0 |
| 2012-03-09 06:10:00 | AAPL | Stock | 19.3839 | 19.3839 | 19.3839 | 19.3839 | 14000.0 |
| 2012-03-09 06:15:00 | AAPL | Stock | 19.375 | 19.3821 | 19.375 | 19.3821 | 9800.0 |
| 2012-03-09 06:25:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 8400.0 |
| 2012-03-09 06:30:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 56000.0 |
| 2012-03-09 07:00:00 | AAPL | Stock | 19.4054 | 19.4054 | 19.3964 | 19.4 | 36400.0 |
| 2012-03-09 07:05:00 | AAPL | Stock | 19.4 | 19.4 | 19.3839 | 19.3839 | 67200.0 |
| 2012-03-09 07:10:00 | AAPL | Stock | 19.3918 | 19.3929 | 19.3839 | 19.3857 | 36400.0 |
| 2012-03-09 07:15:00 | AAPL | Stock | 19.3921 | 19.3929 | 19.3857 | 19.3929 | 35700.0 |
| 2012-03-09 07:20:00 | AAPL | Stock | 19.3929 | 19.4036 | 19.3929 | 19.4036 | 53200.0 |
| 2012-03-09 07:25:00 | AAPL | Stock | 19.4036 | 19.4036 | 19.4029 | 19.4029 | 8400.0 |
| 2012-03-09 07:30:00 | AAPL | Stock | 19.4014 | 19.4014 | 19.3861 | 19.3929 | 44800.0 |
| 2012-03-09 07:35:00 | AAPL | Stock | 19.3975 | 19.3975 | 19.3929 | 19.3929 | 5600.0 |
| 2012-03-09 07:40:00 | AAPL | Stock | 19.3875 | 19.3875 | 19.3839 | 19.3839 | 38080.0 |
| 2012-03-09 07:45:00 | AAPL | Stock | 19.3839 | 19.3875 | 19.3761 | 19.3829 | 59920.0 |
| 2012-03-09 07:50:00 | AAPL | Stock | 19.3804 | 19.3889 | 19.3589 | 19.3589 | 218400.0 |
| 2012-03-09 07:55:00 | AAPL | Stock | 19.3696 | 19.3696 | 19.3693 | 19.3696 | 54180.0 |
| 2012-03-09 08:00:00 | AAPL | Stock | 19.3632 | 19.4014 | 19.34 | 19.34 | 578900.0 |
| 2012-03-09 08:05:00 | AAPL | Stock | 19.3411 | 19.3532 | 19.3404 | 19.3464 | 43960.0 |
| 2012-03-09 08:10:00 | AAPL | Stock | 19.3482 | 19.3743 | 19.3482 | 19.3643 | 267624.0 |
| 2012-03-09 08:15:00 | AAPL | Stock | 19.3718 | 19.3836 | 19.3536 | 19.3836 | 334180.0 |
| 2012-03-09 08:20:00 | AAPL | Stock | 19.3757 | 19.3875 | 19.3714 | 19.3796 | 211876.0 |
| 2012-03-09 08:25:00 | AAPL | Stock | 19.3764 | 19.3818 | 19.3714 | 19.3804 | 298900.0 |
| 2012-03-09 08:30:00 | AAPL | Stock | 19.3782 | 19.4179 | 19.3632 | 19.3807 | 1519112.0 |
| 2012-03-09 08:35:00 | AAPL | Stock | 19.3854 | 19.4036 | 19.3768 | 19.4 | 446432.0 |
| 2012-03-09 08:40:00 | AAPL | Stock | 19.4014 | 19.4279 | 19.4014 | 19.4046 | 1091860.0 |
| 2012-03-09 08:45:00 | AAPL | Stock | 19.4107 | 19.4121 | 19.3996 | 19.4107 | 324240.0 |
| 2012-03-09 08:50:00 | AAPL | Stock | 19.4114 | 19.4168 | 19.4 | 19.4161 | 237468.0 |
| 2012-03-09 08:55:00 | AAPL | Stock | 19.4168 | 19.4286 | 19.4118 | 19.4204 | 321496.0 |
| 2012-03-09 09:00:00 | AAPL | Stock | 19.4221 | 19.4221 | 19.4107 | 19.4193 | 238448.0 |
| 2012-03-09 09:05:00 | AAPL | Stock | 19.4175 | 19.4211 | 19.4107 | 19.4211 | 306684.0 |
| 2012-03-09 09:10:00 | AAPL | Stock | 19.4204 | 19.4204 | 19.4146 | 19.4146 | 90720.0 |
| 2012-03-09 09:15:00 | AAPL | Stock | 19.4157 | 19.4207 | 19.4143 | 19.4189 | 107688.0 |
| 2012-03-09 09:20:00 | AAPL | Stock | 19.4196 | 19.425 | 19.4196 | 19.425 | 117236.0 |
| 2012-03-09 09:25:00 | AAPL | Stock | 19.4243 | 19.4443 | 19.4171 | 19.4429 | 1014048.0 |
| 2012-03-09 09:30:00 | AAPL | Stock | 19.4361 | 19.4643 | 19.4018 | 19.4639 | 13580280.0 |
| 2012-03-09 09:35:00 | AAPL | Stock | 19.4639 | 19.5064 | 19.4571 | 19.5064 | 20106240.0 |
| 2012-03-09 09:40:00 | AAPL | Stock | 19.5054 | 19.5621 | 19.5018 | 19.5296 | 24133312.0 |
| 2012-03-09 09:45:00 | AAPL | Stock | 19.5321 | 19.5554 | 19.4775 | 19.5111 | 17204236.0 |
> showing 50 of 325,074 rows — these rows as CSV