PREVIEW / stock_5min / 2008-03-06
file: by_date/stock_5min/2008/2008-03-06.parquet size: 4.4 MB rows: 318,744 symbols: 3,254
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-03-06 04:35:00 | AAPL | Stock | 4.4711 | 4.4711 | 4.4711 | 4.4711 | 11200.0 |
| 2008-03-06 05:05:00 | AAPL | Stock | 4.4786 | 4.4786 | 4.4786 | 4.4786 | 2800.0 |
| 2008-03-06 05:10:00 | AAPL | Stock | 4.4571 | 4.4571 | 4.4571 | 4.4571 | 8400.0 |
| 2008-03-06 05:25:00 | AAPL | Stock | 4.4579 | 4.4579 | 4.4571 | 4.4571 | 5600.0 |
| 2008-03-06 06:50:00 | AAPL | Stock | 4.4575 | 4.4575 | 4.4571 | 4.4571 | 14000.0 |
| 2008-03-06 07:00:00 | AAPL | Stock | 4.4607 | 4.4607 | 4.4607 | 4.4607 | 6160.0 |
| 2008-03-06 07:05:00 | AAPL | Stock | 4.4646 | 4.4818 | 4.4643 | 4.4818 | 81396.0 |
| 2008-03-06 07:10:00 | AAPL | Stock | 4.4786 | 4.4821 | 4.4732 | 4.4732 | 53200.0 |
| 2008-03-06 07:20:00 | AAPL | Stock | 4.4732 | 4.4821 | 4.4714 | 4.4821 | 54264.0 |
| 2008-03-06 07:25:00 | AAPL | Stock | 4.4714 | 4.4714 | 4.4714 | 4.4714 | 8400.0 |
| 2008-03-06 07:30:00 | AAPL | Stock | 4.4714 | 4.4714 | 4.45 | 4.4643 | 74732.0 |
| 2008-03-06 07:35:00 | AAPL | Stock | 4.4611 | 4.4625 | 4.4593 | 4.4625 | 73500.0 |
| 2008-03-06 07:40:00 | AAPL | Stock | 4.4625 | 4.4625 | 4.4625 | 4.4625 | 15400.0 |
| 2008-03-06 07:45:00 | AAPL | Stock | 4.4589 | 4.4589 | 4.4571 | 4.4571 | 148400.0 |
| 2008-03-06 07:50:00 | AAPL | Stock | 4.4536 | 4.4571 | 4.4536 | 4.4571 | 98588.0 |
| 2008-03-06 07:55:00 | AAPL | Stock | 4.4536 | 4.4543 | 4.4464 | 4.4464 | 131600.0 |
| 2008-03-06 08:00:00 | AAPL | Stock | 4.4518 | 4.4571 | 4.44 | 4.4461 | 438172.0 |
| 2008-03-06 08:05:00 | AAPL | Stock | 4.4464 | 4.4532 | 4.4357 | 4.4357 | 361256.0 |
| 2008-03-06 08:10:00 | AAPL | Stock | 4.4357 | 4.4425 | 4.4336 | 4.4368 | 303408.0 |
| 2008-03-06 08:15:00 | AAPL | Stock | 4.4336 | 4.4336 | 4.4214 | 4.425 | 190344.0 |
| 2008-03-06 08:20:00 | AAPL | Stock | 4.4229 | 4.425 | 4.4196 | 4.4196 | 102200.0 |
| 2008-03-06 08:25:00 | AAPL | Stock | 4.4211 | 4.4275 | 4.4182 | 4.4275 | 90832.0 |
| 2008-03-06 08:30:00 | AAPL | Stock | 4.4275 | 4.4286 | 4.4175 | 4.4286 | 387100.0 |
| 2008-03-06 08:35:00 | AAPL | Stock | 4.4286 | 4.4286 | 4.425 | 4.425 | 358092.0 |
| 2008-03-06 08:40:00 | AAPL | Stock | 4.425 | 4.4271 | 4.4236 | 4.4268 | 29372.0 |
| 2008-03-06 08:45:00 | AAPL | Stock | 4.4254 | 4.4286 | 4.4254 | 4.4275 | 380128.0 |
| 2008-03-06 08:50:00 | AAPL | Stock | 4.4282 | 4.4289 | 4.4254 | 4.4264 | 189896.0 |
| 2008-03-06 08:55:00 | AAPL | Stock | 4.4275 | 4.4371 | 4.4275 | 4.4339 | 209300.0 |
| 2008-03-06 09:00:00 | AAPL | Stock | 4.4318 | 4.4318 | 4.4254 | 4.4286 | 485240.0 |
| 2008-03-06 09:05:00 | AAPL | Stock | 4.4286 | 4.4439 | 4.4286 | 4.4429 | 659400.0 |
| 2008-03-06 09:10:00 | AAPL | Stock | 4.4432 | 4.4461 | 4.4286 | 4.4436 | 521724.0 |
| 2008-03-06 09:15:00 | AAPL | Stock | 4.445 | 4.4464 | 4.4436 | 4.4446 | 175280.0 |
| 2008-03-06 09:20:00 | AAPL | Stock | 4.4457 | 4.4461 | 4.4421 | 4.4461 | 201600.0 |
| 2008-03-06 09:25:00 | AAPL | Stock | 4.4464 | 4.4636 | 4.4411 | 4.4504 | 1822520.0 |
| 2008-03-06 09:30:00 | AAPL | Stock | 4.4511 | 4.4811 | 4.4493 | 4.4696 | 30526468.0 |
| 2008-03-06 09:35:00 | AAPL | Stock | 4.47 | 4.4971 | 4.4682 | 4.4961 | 30426956.0 |
| 2008-03-06 09:40:00 | AAPL | Stock | 4.4964 | 4.5243 | 4.4943 | 4.5143 | 36382444.0 |
| 2008-03-06 09:45:00 | AAPL | Stock | 4.5144 | 4.5282 | 4.5025 | 4.5186 | 32338432.0 |
| 2008-03-06 09:50:00 | AAPL | Stock | 4.5186 | 4.5382 | 4.5132 | 4.5339 | 41243944.0 |
| 2008-03-06 09:55:00 | AAPL | Stock | 4.5339 | 4.5457 | 4.5204 | 4.5321 | 34610548.0 |
| 2008-03-06 10:00:00 | AAPL | Stock | 4.5293 | 4.5314 | 4.4957 | 4.5079 | 39014052.0 |
| 2008-03-06 10:05:00 | AAPL | Stock | 4.5079 | 4.5168 | 4.5068 | 4.5107 | 18379536.0 |
| 2008-03-06 10:10:00 | AAPL | Stock | 4.5107 | 4.525 | 4.5071 | 4.5189 | 23053492.0 |
| 2008-03-06 10:15:00 | AAPL | Stock | 4.5193 | 4.5304 | 4.5157 | 4.5171 | 20238960.0 |
| 2008-03-06 10:20:00 | AAPL | Stock | 4.5175 | 4.5496 | 4.5154 | 4.5436 | 30841440.0 |
| 2008-03-06 10:25:00 | AAPL | Stock | 4.5436 | 4.5479 | 4.5289 | 4.5314 | 20788852.0 |
| 2008-03-06 10:30:00 | AAPL | Stock | 4.5311 | 4.5521 | 4.5307 | 4.5482 | 18500300.0 |
| 2008-03-06 10:35:00 | AAPL | Stock | 4.5482 | 4.5536 | 4.5389 | 4.5436 | 22668492.0 |
| 2008-03-06 10:40:00 | AAPL | Stock | 4.5436 | 4.55 | 4.5296 | 4.5314 | 18887540.0 |
| 2008-03-06 10:45:00 | AAPL | Stock | 4.5307 | 4.5386 | 4.5296 | 4.5339 | 12434072.0 |
> showing 50 of 318,744 rows — these rows as CSV