PREVIEW / stock_5min / 2008-04-16
file: by_date/stock_5min/2008/2008-04-16.parquet size: 4.4 MB rows: 315,325 symbols: 3,294
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-16 07:00:00 | AAPL | Stock | 5.3725 | 5.3732 | 5.3718 | 5.3732 | 19600.0 |
| 2008-04-16 07:15:00 | AAPL | Stock | 5.3839 | 5.3839 | 5.3839 | 5.3839 | 5600.0 |
| 2008-04-16 07:20:00 | AAPL | Stock | 5.3825 | 5.3954 | 5.3825 | 5.3954 | 5600.0 |
| 2008-04-16 07:25:00 | AAPL | Stock | 5.3964 | 5.4107 | 5.3964 | 5.4107 | 333200.0 |
| 2008-04-16 07:30:00 | AAPL | Stock | 5.4107 | 5.4107 | 5.4107 | 5.4107 | 23800.0 |
| 2008-04-16 07:35:00 | AAPL | Stock | 5.4107 | 5.4107 | 5.4107 | 5.4107 | 151200.0 |
| 2008-04-16 07:40:00 | AAPL | Stock | 5.4107 | 5.4143 | 5.4071 | 5.4111 | 36540.0 |
| 2008-04-16 07:45:00 | AAPL | Stock | 5.4104 | 5.4107 | 5.4036 | 5.4036 | 312928.0 |
| 2008-04-16 07:50:00 | AAPL | Stock | 5.4018 | 5.4018 | 5.3964 | 5.3964 | 75600.0 |
| 2008-04-16 07:55:00 | AAPL | Stock | 5.4032 | 5.4036 | 5.4032 | 5.4036 | 25200.0 |
| 2008-04-16 08:00:00 | AAPL | Stock | 5.4 | 5.41 | 5.4 | 5.4029 | 482944.0 |
| 2008-04-16 08:05:00 | AAPL | Stock | 5.4036 | 5.4036 | 5.3864 | 5.3932 | 659820.0 |
| 2008-04-16 08:10:00 | AAPL | Stock | 5.3929 | 5.4 | 5.3929 | 5.3946 | 117600.0 |
| 2008-04-16 08:15:00 | AAPL | Stock | 5.3939 | 5.4036 | 5.3939 | 5.4036 | 150276.0 |
| 2008-04-16 08:20:00 | AAPL | Stock | 5.4036 | 5.4071 | 5.4007 | 5.4043 | 349580.0 |
| 2008-04-16 08:25:00 | AAPL | Stock | 5.4071 | 5.4214 | 5.4004 | 5.4071 | 757036.0 |
| 2008-04-16 08:30:00 | AAPL | Stock | 5.4071 | 5.4179 | 5.4025 | 5.4161 | 834904.0 |
| 2008-04-16 08:35:00 | AAPL | Stock | 5.4161 | 5.425 | 5.4161 | 5.4218 | 482580.0 |
| 2008-04-16 08:40:00 | AAPL | Stock | 5.4218 | 5.4329 | 5.4214 | 5.4282 | 1161916.0 |
| 2008-04-16 08:45:00 | AAPL | Stock | 5.4286 | 5.4339 | 5.4243 | 5.4304 | 415800.0 |
| 2008-04-16 08:50:00 | AAPL | Stock | 5.4318 | 5.4321 | 5.4239 | 5.4246 | 690732.0 |
| 2008-04-16 08:55:00 | AAPL | Stock | 5.4271 | 5.4271 | 5.4229 | 5.4246 | 163156.0 |
| 2008-04-16 09:00:00 | AAPL | Stock | 5.4229 | 5.4243 | 5.4225 | 5.4232 | 75376.0 |
| 2008-04-16 09:05:00 | AAPL | Stock | 5.4229 | 5.4246 | 5.42 | 5.4236 | 180796.0 |
| 2008-04-16 09:10:00 | AAPL | Stock | 5.4236 | 5.4246 | 5.4189 | 5.4229 | 107660.0 |
| 2008-04-16 09:15:00 | AAPL | Stock | 5.4204 | 5.4264 | 5.4182 | 5.4243 | 250180.0 |
| 2008-04-16 09:20:00 | AAPL | Stock | 5.4225 | 5.4225 | 5.4068 | 5.4071 | 841680.0 |
| 2008-04-16 09:25:00 | AAPL | Stock | 5.4071 | 5.4211 | 5.2993 | 5.4189 | 3430420.0 |
| 2008-04-16 09:30:00 | AAPL | Stock | 5.4189 | 5.4286 | 5.4036 | 5.4071 | 34907936.0 |
| 2008-04-16 09:35:00 | AAPL | Stock | 5.4068 | 5.4107 | 5.3864 | 5.4032 | 23869692.0 |
| 2008-04-16 09:40:00 | AAPL | Stock | 5.4032 | 5.4068 | 5.3793 | 5.3896 | 15871352.0 |
| 2008-04-16 09:45:00 | AAPL | Stock | 5.39 | 5.4236 | 5.3893 | 5.4218 | 19070072.0 |
| 2008-04-16 09:50:00 | AAPL | Stock | 5.422 | 5.4243 | 5.4025 | 5.4043 | 16221548.0 |
| 2008-04-16 09:55:00 | AAPL | Stock | 5.4043 | 5.4064 | 5.3929 | 5.3996 | 14701512.0 |
| 2008-04-16 10:00:00 | AAPL | Stock | 5.399 | 5.4157 | 5.3986 | 5.4118 | 9121252.0 |
| 2008-04-16 10:05:00 | AAPL | Stock | 5.4114 | 5.4129 | 5.4004 | 5.4057 | 8573432.0 |
| 2008-04-16 10:10:00 | AAPL | Stock | 5.4054 | 5.4175 | 5.4007 | 5.4164 | 11186252.0 |
| 2008-04-16 10:15:00 | AAPL | Stock | 5.4164 | 5.435 | 5.4054 | 5.4293 | 20275556.0 |
| 2008-04-16 10:20:00 | AAPL | Stock | 5.4293 | 5.4461 | 5.4286 | 5.4461 | 20244756.0 |
| 2008-04-16 10:25:00 | AAPL | Stock | 5.4446 | 5.4557 | 5.4436 | 5.4515 | 17721816.0 |
| 2008-04-16 10:30:00 | AAPL | Stock | 5.4514 | 5.4639 | 5.4418 | 5.4567 | 17495492.0 |
| 2008-04-16 10:35:00 | AAPL | Stock | 5.4561 | 5.46 | 5.4486 | 5.4532 | 11385808.0 |
| 2008-04-16 10:40:00 | AAPL | Stock | 5.4525 | 5.4543 | 5.4439 | 5.4464 | 10054884.0 |
| 2008-04-16 10:45:00 | AAPL | Stock | 5.4464 | 5.4518 | 5.4361 | 5.4464 | 10801560.0 |
| 2008-04-16 10:50:00 | AAPL | Stock | 5.4479 | 5.4571 | 5.4439 | 5.4543 | 8962968.0 |
| 2008-04-16 10:55:00 | AAPL | Stock | 5.4539 | 5.4604 | 5.4489 | 5.4589 | 7587860.0 |
| 2008-04-16 11:00:00 | AAPL | Stock | 5.4586 | 5.4661 | 5.4539 | 5.4621 | 12017684.0 |
| 2008-04-16 11:05:00 | AAPL | Stock | 5.4621 | 5.4624 | 5.4446 | 5.4457 | 10126984.0 |
| 2008-04-16 11:10:00 | AAPL | Stock | 5.4461 | 5.455 | 5.4446 | 5.4532 | 6690264.0 |
| 2008-04-16 11:15:00 | AAPL | Stock | 5.4529 | 5.4629 | 5.4507 | 5.4596 | 6402424.0 |
> showing 50 of 315,325 rows — these rows as CSV