PREVIEW / stock_5min / 2010-09-10
file: by_date/stock_5min/2010/2010-09-10.parquet size: 4.4 MB rows: 304,513 symbols: 3,445
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-09-10 04:05:00 | AAPL | Stock | 9.4375 | 9.4375 | 9.4375 | 9.4375 | 2800.0 |
| 2010-09-10 06:05:00 | AAPL | Stock | 9.4286 | 9.4286 | 9.4286 | 9.4286 | 2800.0 |
| 2010-09-10 07:00:00 | AAPL | Stock | 9.4357 | 9.4357 | 9.4321 | 9.4321 | 28000.0 |
| 2010-09-10 07:15:00 | AAPL | Stock | 9.4275 | 9.4275 | 9.4275 | 9.4275 | 4900.0 |
| 2010-09-10 07:20:00 | AAPL | Stock | 9.4286 | 9.4286 | 9.4286 | 9.4286 | 14700.0 |
| 2010-09-10 07:25:00 | AAPL | Stock | 9.4289 | 9.4293 | 9.42 | 9.42 | 39200.0 |
| 2010-09-10 07:35:00 | AAPL | Stock | 9.4257 | 9.4257 | 9.4196 | 9.4196 | 7000.0 |
| 2010-09-10 07:40:00 | AAPL | Stock | 9.4136 | 9.4136 | 9.4136 | 9.4136 | 5600.0 |
| 2010-09-10 07:45:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 28000.0 |
| 2010-09-10 07:50:00 | AAPL | Stock | 9.4107 | 9.4171 | 9.4107 | 9.4171 | 46368.0 |
| 2010-09-10 08:00:00 | AAPL | Stock | 9.4132 | 9.4161 | 9.4096 | 9.4104 | 257712.0 |
| 2010-09-10 08:05:00 | AAPL | Stock | 9.4157 | 9.4164 | 9.4111 | 9.4111 | 73444.0 |
| 2010-09-10 08:10:00 | AAPL | Stock | 9.4125 | 9.4161 | 9.4125 | 9.4143 | 74928.0 |
| 2010-09-10 08:15:00 | AAPL | Stock | 9.4129 | 9.415 | 9.4071 | 9.415 | 89796.0 |
| 2010-09-10 08:20:00 | AAPL | Stock | 9.4146 | 9.415 | 9.4143 | 9.4143 | 16800.0 |
| 2010-09-10 08:25:00 | AAPL | Stock | 9.4125 | 9.4143 | 9.4111 | 9.4125 | 67200.0 |
| 2010-09-10 08:30:00 | AAPL | Stock | 9.4146 | 9.4329 | 9.4107 | 9.4286 | 637644.0 |
| 2010-09-10 08:35:00 | AAPL | Stock | 9.4286 | 9.4386 | 9.4286 | 9.4293 | 478184.0 |
| 2010-09-10 08:40:00 | AAPL | Stock | 9.4286 | 9.4286 | 9.415 | 9.415 | 283920.0 |
| 2010-09-10 08:45:00 | AAPL | Stock | 9.42 | 9.4243 | 9.4179 | 9.4239 | 61600.0 |
| 2010-09-10 08:50:00 | AAPL | Stock | 9.4218 | 9.4218 | 9.4071 | 9.4079 | 230860.0 |
| 2010-09-10 08:55:00 | AAPL | Stock | 9.4104 | 9.4139 | 9.4039 | 9.4039 | 163380.0 |
| 2010-09-10 09:00:00 | AAPL | Stock | 9.4036 | 9.4118 | 9.4018 | 9.4043 | 116760.0 |
| 2010-09-10 09:05:00 | AAPL | Stock | 9.4064 | 9.4071 | 9.4036 | 9.4036 | 60340.0 |
| 2010-09-10 09:10:00 | AAPL | Stock | 9.4064 | 9.4064 | 9.4054 | 9.4054 | 30800.0 |
| 2010-09-10 09:15:00 | AAPL | Stock | 9.4021 | 9.4021 | 9.3968 | 9.3986 | 130200.0 |
| 2010-09-10 09:20:00 | AAPL | Stock | 9.3989 | 9.4064 | 9.3982 | 9.4036 | 229600.0 |
| 2010-09-10 09:25:00 | AAPL | Stock | 9.4025 | 9.4025 | 9.3954 | 9.3957 | 147000.0 |
| 2010-09-10 09:30:00 | AAPL | Stock | 9.3961 | 9.4104 | 9.3507 | 9.3529 | 23025800.0 |
| 2010-09-10 09:35:00 | AAPL | Stock | 9.3529 | 9.3561 | 9.34 | 9.345 | 18785032.0 |
| 2010-09-10 09:40:00 | AAPL | Stock | 9.3436 | 9.3893 | 9.3357 | 9.3723 | 16272396.0 |
| 2010-09-10 09:45:00 | AAPL | Stock | 9.3742 | 9.3957 | 9.3646 | 9.3957 | 9357768.0 |
| 2010-09-10 09:50:00 | AAPL | Stock | 9.3943 | 9.41 | 9.3918 | 9.3954 | 12223316.0 |
| 2010-09-10 09:55:00 | AAPL | Stock | 9.3964 | 9.4185 | 9.3821 | 9.3839 | 10738056.0 |
| 2010-09-10 10:00:00 | AAPL | Stock | 9.3846 | 9.3929 | 9.3696 | 9.3864 | 9044756.0 |
| 2010-09-10 10:05:00 | AAPL | Stock | 9.3879 | 9.3964 | 9.375 | 9.3925 | 5538428.0 |
| 2010-09-10 10:10:00 | AAPL | Stock | 9.3921 | 9.4096 | 9.3893 | 9.4016 | 6084232.0 |
| 2010-09-10 10:15:00 | AAPL | Stock | 9.4021 | 9.4075 | 9.3929 | 9.405 | 3810184.0 |
| 2010-09-10 10:20:00 | AAPL | Stock | 9.4061 | 9.4312 | 9.4036 | 9.4279 | 10360560.0 |
| 2010-09-10 10:25:00 | AAPL | Stock | 9.428 | 9.4311 | 9.4196 | 9.4286 | 4245444.0 |
| 2010-09-10 10:30:00 | AAPL | Stock | 9.4286 | 9.4464 | 9.4193 | 9.425 | 10157868.0 |
| 2010-09-10 10:35:00 | AAPL | Stock | 9.4243 | 9.4336 | 9.4225 | 9.4261 | 2632420.0 |
| 2010-09-10 10:40:00 | AAPL | Stock | 9.4275 | 9.4279 | 9.415 | 9.4188 | 5265484.0 |
| 2010-09-10 10:45:00 | AAPL | Stock | 9.4184 | 9.4236 | 9.4139 | 9.4193 | 3734528.0 |
| 2010-09-10 10:50:00 | AAPL | Stock | 9.4182 | 9.4332 | 9.4157 | 9.4254 | 4211900.0 |
| 2010-09-10 10:55:00 | AAPL | Stock | 9.4246 | 9.4439 | 9.4246 | 9.4432 | 3151512.0 |
| 2010-09-10 11:00:00 | AAPL | Stock | 9.4436 | 9.4457 | 9.4357 | 9.4421 | 3694516.0 |
| 2010-09-10 11:05:00 | AAPL | Stock | 9.4411 | 9.4425 | 9.4196 | 9.4245 | 4274200.0 |
| 2010-09-10 11:10:00 | AAPL | Stock | 9.4252 | 9.4286 | 9.4189 | 9.4218 | 2199792.0 |
| 2010-09-10 11:15:00 | AAPL | Stock | 9.4229 | 9.4243 | 9.4068 | 9.4179 | 3977456.0 |
> showing 50 of 304,513 rows — these rows as CSV