PREVIEW / stock_5min / 2012-03-23
file: by_date/stock_5min/2012/2012-03-23.parquet size: 4.7 MB rows: 318,188 symbols: 3,500
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-23 04:00:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.4643 | 21.4643 | 11200.0 |
| 2012-03-23 04:05:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.4357 | 21.4393 | 28000.0 |
| 2012-03-23 04:10:00 | AAPL | Stock | 21.4393 | 21.45 | 21.4336 | 21.4336 | 19600.0 |
| 2012-03-23 04:15:00 | AAPL | Stock | 21.4329 | 21.4329 | 21.4286 | 21.4286 | 8400.0 |
| 2012-03-23 04:20:00 | AAPL | Stock | 21.4286 | 21.4336 | 21.4286 | 21.4336 | 58800.0 |
| 2012-03-23 04:25:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 2800.0 |
| 2012-03-23 04:30:00 | AAPL | Stock | 21.4282 | 21.4286 | 21.4189 | 21.4257 | 44800.0 |
| 2012-03-23 04:35:00 | AAPL | Stock | 21.4214 | 21.4214 | 21.4214 | 21.4214 | 5600.0 |
| 2012-03-23 04:40:00 | AAPL | Stock | 21.4282 | 21.4282 | 21.4232 | 21.4268 | 20860.0 |
| 2012-03-23 04:45:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 56000.0 |
| 2012-03-23 04:50:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 28000.0 |
| 2012-03-23 04:55:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 8400.0 |
| 2012-03-23 05:00:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4286 | 21.4286 | 5600.0 |
| 2012-03-23 05:05:00 | AAPL | Stock | 21.45 | 21.45 | 21.4286 | 21.4286 | 8400.0 |
| 2012-03-23 05:10:00 | AAPL | Stock | 21.45 | 21.4643 | 21.45 | 21.4643 | 21560.0 |
| 2012-03-23 05:20:00 | AAPL | Stock | 21.4329 | 21.4357 | 21.4329 | 21.4357 | 5600.0 |
| 2012-03-23 05:25:00 | AAPL | Stock | 21.4375 | 21.4375 | 21.4375 | 21.4375 | 2800.0 |
| 2012-03-23 05:30:00 | AAPL | Stock | 21.4232 | 21.4232 | 21.4232 | 21.4232 | 14000.0 |
| 2012-03-23 05:45:00 | AAPL | Stock | 21.3914 | 21.3914 | 21.3571 | 21.3571 | 18200.0 |
| 2012-03-23 06:05:00 | AAPL | Stock | 21.3561 | 21.3561 | 21.3561 | 21.3561 | 11200.0 |
| 2012-03-23 06:30:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3571 | 21.3571 | 2800.0 |
| 2012-03-23 06:35:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3571 | 21.3571 | 2800.0 |
| 2012-03-23 06:45:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.3571 | 21.3571 | 5544.0 |
| 2012-03-23 06:50:00 | AAPL | Stock | 21.375 | 21.375 | 21.375 | 21.375 | 2800.0 |
| 2012-03-23 06:55:00 | AAPL | Stock | 21.375 | 21.375 | 21.375 | 21.375 | 8400.0 |
| 2012-03-23 07:00:00 | AAPL | Stock | 21.375 | 21.4104 | 21.375 | 21.4036 | 48524.0 |
| 2012-03-23 07:05:00 | AAPL | Stock | 21.4107 | 21.4107 | 21.4107 | 21.4107 | 14644.0 |
| 2012-03-23 07:10:00 | AAPL | Stock | 21.4054 | 21.4054 | 21.3929 | 21.4029 | 78400.0 |
| 2012-03-23 07:15:00 | AAPL | Stock | 21.4107 | 21.4107 | 21.4107 | 21.4107 | 5348.0 |
| 2012-03-23 07:20:00 | AAPL | Stock | 21.4096 | 21.4107 | 21.4 | 21.4054 | 37800.0 |
| 2012-03-23 07:25:00 | AAPL | Stock | 21.4107 | 21.4107 | 21.4 | 21.4107 | 38360.0 |
| 2012-03-23 07:30:00 | AAPL | Stock | 21.4004 | 21.4018 | 21.3679 | 21.3686 | 139496.0 |
| 2012-03-23 07:40:00 | AAPL | Stock | 21.3768 | 21.3911 | 21.3754 | 21.3771 | 29680.0 |
| 2012-03-23 07:45:00 | AAPL | Stock | 21.3786 | 21.3786 | 21.3786 | 21.3786 | 5600.0 |
| 2012-03-23 07:50:00 | AAPL | Stock | 21.3821 | 21.3821 | 21.3821 | 21.3821 | 2800.0 |
| 2012-03-23 07:55:00 | AAPL | Stock | 21.3768 | 21.3796 | 21.3707 | 21.3707 | 85456.0 |
| 2012-03-23 08:00:00 | AAPL | Stock | 21.3782 | 21.4107 | 21.3661 | 21.3661 | 260176.0 |
| 2012-03-23 08:05:00 | AAPL | Stock | 21.3661 | 21.3661 | 21.3393 | 21.3571 | 210336.0 |
| 2012-03-23 08:10:00 | AAPL | Stock | 21.3643 | 21.3839 | 21.3596 | 21.3771 | 116340.0 |
| 2012-03-23 08:15:00 | AAPL | Stock | 21.3775 | 21.3807 | 21.3661 | 21.3761 | 70336.0 |
| 2012-03-23 08:20:00 | AAPL | Stock | 21.38 | 21.3929 | 21.3775 | 21.3929 | 166908.0 |
| 2012-03-23 08:25:00 | AAPL | Stock | 21.3929 | 21.4136 | 21.3929 | 21.4107 | 180852.0 |
| 2012-03-23 08:30:00 | AAPL | Stock | 21.4021 | 21.4111 | 21.3982 | 21.4018 | 161196.0 |
| 2012-03-23 08:35:00 | AAPL | Stock | 21.4046 | 21.4171 | 21.4046 | 21.4107 | 185388.0 |
| 2012-03-23 08:40:00 | AAPL | Stock | 21.4146 | 21.4196 | 21.4125 | 21.4164 | 358120.0 |
| 2012-03-23 08:45:00 | AAPL | Stock | 21.4118 | 21.4221 | 21.4071 | 21.4071 | 176512.0 |
| 2012-03-23 08:50:00 | AAPL | Stock | 21.4071 | 21.4204 | 21.4071 | 21.4204 | 60200.0 |
| 2012-03-23 08:55:00 | AAPL | Stock | 21.4207 | 21.4232 | 21.4179 | 21.4214 | 47600.0 |
| 2012-03-23 09:00:00 | AAPL | Stock | 21.4221 | 21.425 | 21.4111 | 21.4164 | 44800.0 |
| 2012-03-23 09:05:00 | AAPL | Stock | 21.4182 | 21.4196 | 21.4143 | 21.4196 | 102900.0 |
> showing 50 of 318,188 rows — these rows as CSV