PREVIEW / stock_5min / 2009-02-04
file: by_date/stock_5min/2009/2009-02-04.parquet size: 4.4 MB rows: 303,030 symbols: 3,304
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-04 06:35:00 | AAPL | Stock | 3.2968 | 3.3054 | 3.2968 | 3.3054 | 28000.0 |
| 2009-02-04 06:40:00 | AAPL | Stock | 3.2743 | 3.2743 | 3.2743 | 3.2743 | 2800.0 |
| 2009-02-04 07:15:00 | AAPL | Stock | 3.3143 | 3.3143 | 3.3143 | 3.3143 | 2800.0 |
| 2009-02-04 07:25:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.3036 | 3.3036 | 5600.0 |
| 2009-02-04 07:30:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.3036 | 3.3036 | 22036.0 |
| 2009-02-04 07:35:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.3036 | 3.3036 | 5124.0 |
| 2009-02-04 08:00:00 | AAPL | Stock | 3.3089 | 3.3207 | 3.3089 | 3.3096 | 67200.0 |
| 2009-02-04 08:05:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.3036 | 3.3036 | 17892.0 |
| 2009-02-04 08:10:00 | AAPL | Stock | 3.3039 | 3.3039 | 3.3039 | 3.3039 | 17920.0 |
| 2009-02-04 08:15:00 | AAPL | Stock | 3.31 | 3.3189 | 3.31 | 3.3143 | 17864.0 |
| 2009-02-04 08:20:00 | AAPL | Stock | 3.3143 | 3.3146 | 3.3143 | 3.3143 | 44800.0 |
| 2009-02-04 08:25:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.3039 | 3.3096 | 52080.0 |
| 2009-02-04 08:30:00 | AAPL | Stock | 3.3096 | 3.32 | 3.3096 | 3.32 | 53200.0 |
| 2009-02-04 08:35:00 | AAPL | Stock | 3.3214 | 3.3229 | 3.3196 | 3.3196 | 58800.0 |
| 2009-02-04 08:40:00 | AAPL | Stock | 3.3193 | 3.3196 | 3.3143 | 3.3182 | 90468.0 |
| 2009-02-04 08:45:00 | AAPL | Stock | 3.3179 | 3.3218 | 3.3179 | 3.3214 | 70308.0 |
| 2009-02-04 08:50:00 | AAPL | Stock | 3.3261 | 3.3304 | 3.3261 | 3.3264 | 100408.0 |
| 2009-02-04 08:55:00 | AAPL | Stock | 3.3254 | 3.3293 | 3.3254 | 3.3286 | 100800.0 |
| 2009-02-04 09:00:00 | AAPL | Stock | 3.3293 | 3.3296 | 3.3207 | 3.3207 | 2963772.0 |
| 2009-02-04 09:05:00 | AAPL | Stock | 3.3268 | 3.3268 | 3.3239 | 3.3246 | 70168.0 |
| 2009-02-04 09:10:00 | AAPL | Stock | 3.325 | 3.325 | 3.3232 | 3.3232 | 62160.0 |
| 2009-02-04 09:15:00 | AAPL | Stock | 3.3236 | 3.3254 | 3.3232 | 3.325 | 95200.0 |
| 2009-02-04 09:20:00 | AAPL | Stock | 3.3239 | 3.3254 | 3.3207 | 3.3254 | 322000.0 |
| 2009-02-04 09:25:00 | AAPL | Stock | 3.3254 | 3.335 | 3.3232 | 3.3321 | 624764.0 |
| 2009-02-04 09:30:00 | AAPL | Stock | 3.3304 | 3.3482 | 3.325 | 3.3461 | 16293200.0 |
| 2009-02-04 09:35:00 | AAPL | Stock | 3.3464 | 3.3564 | 3.3314 | 3.355 | 16123240.0 |
| 2009-02-04 09:40:00 | AAPL | Stock | 3.3557 | 3.3743 | 3.3536 | 3.3739 | 18870432.0 |
| 2009-02-04 09:45:00 | AAPL | Stock | 3.3739 | 3.3757 | 3.3661 | 3.37 | 11476136.0 |
| 2009-02-04 09:50:00 | AAPL | Stock | 3.3704 | 3.3889 | 3.3689 | 3.3889 | 15538460.0 |
| 2009-02-04 09:55:00 | AAPL | Stock | 3.3889 | 3.3907 | 3.3864 | 3.3864 | 10865232.0 |
| 2009-02-04 10:00:00 | AAPL | Stock | 3.3864 | 3.4 | 3.3864 | 3.3918 | 24748612.0 |
| 2009-02-04 10:05:00 | AAPL | Stock | 3.3911 | 3.3979 | 3.3864 | 3.3911 | 13356448.0 |
| 2009-02-04 10:10:00 | AAPL | Stock | 3.3907 | 3.4089 | 3.3907 | 3.4082 | 19624416.0 |
| 2009-02-04 10:15:00 | AAPL | Stock | 3.4086 | 3.4193 | 3.4082 | 3.4093 | 16661960.0 |
| 2009-02-04 10:20:00 | AAPL | Stock | 3.4098 | 3.4129 | 3.4061 | 3.4082 | 9223900.0 |
| 2009-02-04 10:25:00 | AAPL | Stock | 3.4082 | 3.4196 | 3.405 | 3.4186 | 9122652.0 |
| 2009-02-04 10:30:00 | AAPL | Stock | 3.4182 | 3.4279 | 3.415 | 3.4212 | 11818688.0 |
| 2009-02-04 10:35:00 | AAPL | Stock | 3.4217 | 3.4261 | 3.4179 | 3.4243 | 8737988.0 |
| 2009-02-04 10:40:00 | AAPL | Stock | 3.424 | 3.4254 | 3.4161 | 3.4204 | 7997752.0 |
| 2009-02-04 10:45:00 | AAPL | Stock | 3.4204 | 3.4211 | 3.4136 | 3.4164 | 6771604.0 |
| 2009-02-04 10:50:00 | AAPL | Stock | 3.4161 | 3.4214 | 3.4118 | 3.4161 | 13936720.0 |
| 2009-02-04 10:55:00 | AAPL | Stock | 3.4161 | 3.4236 | 3.4136 | 3.4207 | 7199024.0 |
| 2009-02-04 11:00:00 | AAPL | Stock | 3.4207 | 3.4232 | 3.4186 | 3.4225 | 4655252.0 |
| 2009-02-04 11:05:00 | AAPL | Stock | 3.4218 | 3.425 | 3.4168 | 3.4246 | 8240232.0 |
| 2009-02-04 11:10:00 | AAPL | Stock | 3.4246 | 3.425 | 3.4196 | 3.4229 | 6314504.0 |
| 2009-02-04 11:15:00 | AAPL | Stock | 3.4236 | 3.4286 | 3.4157 | 3.4264 | 13278524.0 |
| 2009-02-04 11:20:00 | AAPL | Stock | 3.4264 | 3.4264 | 3.4196 | 3.4246 | 7778008.0 |
| 2009-02-04 11:25:00 | AAPL | Stock | 3.4246 | 3.4304 | 3.4221 | 3.4232 | 11322584.0 |
| 2009-02-04 11:30:00 | AAPL | Stock | 3.4236 | 3.4346 | 3.4204 | 3.4346 | 9004548.0 |
| 2009-02-04 11:35:00 | AAPL | Stock | 3.4346 | 3.4348 | 3.4254 | 3.4286 | 11710552.0 |
> showing 50 of 303,030 rows — these rows as CSV