PREVIEW / stock_5min / 2008-12-15
file: by_date/stock_5min/2008/2008-12-15.parquet size: 4.2 MB rows: 308,738 symbols: 3,337
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-12-15 04:15:00 | AAPL | Stock | 3.5096 | 3.5096 | 3.5096 | 3.5096 | 2800.0 |
| 2008-12-15 04:20:00 | AAPL | Stock | 3.4536 | 3.4536 | 3.45 | 3.45 | 39200.0 |
| 2008-12-15 06:30:00 | AAPL | Stock | 3.4325 | 3.4325 | 3.4325 | 3.4325 | 2800.0 |
| 2008-12-15 06:55:00 | AAPL | Stock | 3.4311 | 3.4311 | 3.4311 | 3.4311 | 2800.0 |
| 2008-12-15 07:00:00 | AAPL | Stock | 3.4075 | 3.4075 | 3.4075 | 3.4075 | 2800.0 |
| 2008-12-15 07:05:00 | AAPL | Stock | 3.4311 | 3.4311 | 3.4196 | 3.4196 | 16800.0 |
| 2008-12-15 07:10:00 | AAPL | Stock | 3.4268 | 3.4268 | 3.4268 | 3.4268 | 2800.0 |
| 2008-12-15 07:25:00 | AAPL | Stock | 3.4125 | 3.4196 | 3.3679 | 3.3946 | 283640.0 |
| 2008-12-15 07:30:00 | AAPL | Stock | 3.3946 | 3.3946 | 3.3946 | 3.3946 | 26600.0 |
| 2008-12-15 07:35:00 | AAPL | Stock | 3.395 | 3.4021 | 3.3946 | 3.4021 | 48720.0 |
| 2008-12-15 07:40:00 | AAPL | Stock | 3.4207 | 3.4286 | 3.4161 | 3.4286 | 589092.0 |
| 2008-12-15 07:45:00 | AAPL | Stock | 3.4214 | 3.4214 | 3.4118 | 3.4118 | 29400.0 |
| 2008-12-15 07:50:00 | AAPL | Stock | 3.4264 | 3.4286 | 3.4261 | 3.4268 | 170492.0 |
| 2008-12-15 07:55:00 | AAPL | Stock | 3.4243 | 3.4243 | 3.4243 | 3.4243 | 2800.0 |
| 2008-12-15 08:00:00 | AAPL | Stock | 3.4275 | 3.4321 | 3.4143 | 3.4304 | 405356.0 |
| 2008-12-15 08:05:00 | AAPL | Stock | 3.4304 | 3.4321 | 3.4196 | 3.4196 | 662032.0 |
| 2008-12-15 08:10:00 | AAPL | Stock | 3.4196 | 3.4304 | 3.4196 | 3.4304 | 422492.0 |
| 2008-12-15 08:15:00 | AAPL | Stock | 3.4321 | 3.4325 | 3.4232 | 3.4289 | 370580.0 |
| 2008-12-15 08:20:00 | AAPL | Stock | 3.4321 | 3.4321 | 3.425 | 3.4275 | 641676.0 |
| 2008-12-15 08:25:00 | AAPL | Stock | 3.4304 | 3.4321 | 3.4257 | 3.43 | 169400.0 |
| 2008-12-15 08:30:00 | AAPL | Stock | 3.4361 | 3.4371 | 3.4286 | 3.4286 | 129080.0 |
| 2008-12-15 08:35:00 | AAPL | Stock | 3.4286 | 3.4357 | 3.4286 | 3.4339 | 192780.0 |
| 2008-12-15 08:40:00 | AAPL | Stock | 3.4343 | 3.4464 | 3.4343 | 3.4393 | 335692.0 |
| 2008-12-15 08:45:00 | AAPL | Stock | 3.4393 | 3.4475 | 3.4379 | 3.4475 | 350196.0 |
| 2008-12-15 08:50:00 | AAPL | Stock | 3.4511 | 3.455 | 3.4446 | 3.4446 | 186508.0 |
| 2008-12-15 08:55:00 | AAPL | Stock | 3.445 | 3.445 | 3.4393 | 3.4429 | 288680.0 |
| 2008-12-15 09:00:00 | AAPL | Stock | 3.4414 | 3.4429 | 3.4411 | 3.4425 | 115500.0 |
| 2008-12-15 09:05:00 | AAPL | Stock | 3.4421 | 3.4496 | 3.4418 | 3.4432 | 619024.0 |
| 2008-12-15 09:10:00 | AAPL | Stock | 3.4446 | 3.4464 | 3.4414 | 3.4432 | 387184.0 |
| 2008-12-15 09:15:00 | AAPL | Stock | 3.4439 | 3.4464 | 3.4411 | 3.4411 | 390880.0 |
| 2008-12-15 09:20:00 | AAPL | Stock | 3.4418 | 3.4468 | 3.4418 | 3.4464 | 197764.0 |
| 2008-12-15 09:25:00 | AAPL | Stock | 3.4446 | 3.4446 | 3.4225 | 3.4293 | 855428.0 |
| 2008-12-15 09:30:00 | AAPL | Stock | 3.4289 | 3.4361 | 3.4086 | 3.414 | 27023556.0 |
| 2008-12-15 09:35:00 | AAPL | Stock | 3.4136 | 3.4196 | 3.3857 | 3.395 | 29636852.0 |
| 2008-12-15 09:40:00 | AAPL | Stock | 3.3939 | 3.4089 | 3.3857 | 3.3954 | 20261780.0 |
| 2008-12-15 09:45:00 | AAPL | Stock | 3.3957 | 3.4104 | 3.39 | 3.3986 | 15709932.0 |
| 2008-12-15 09:50:00 | AAPL | Stock | 3.3979 | 3.3996 | 3.3839 | 3.3882 | 17427676.0 |
| 2008-12-15 09:55:00 | AAPL | Stock | 3.3871 | 3.3979 | 3.3796 | 3.3807 | 13118980.0 |
| 2008-12-15 10:00:00 | AAPL | Stock | 3.3804 | 3.3821 | 3.3614 | 3.3625 | 16708496.0 |
| 2008-12-15 10:05:00 | AAPL | Stock | 3.3629 | 3.3732 | 3.3579 | 3.3661 | 14089292.0 |
| 2008-12-15 10:10:00 | AAPL | Stock | 3.365 | 3.3779 | 3.3596 | 3.3604 | 10292520.0 |
| 2008-12-15 10:15:00 | AAPL | Stock | 3.3607 | 3.365 | 3.3436 | 3.3497 | 15974224.0 |
| 2008-12-15 10:20:00 | AAPL | Stock | 3.35 | 3.35 | 3.3268 | 3.3321 | 15899912.0 |
| 2008-12-15 10:25:00 | AAPL | Stock | 3.331 | 3.3464 | 3.33 | 3.3418 | 13910260.0 |
| 2008-12-15 10:30:00 | AAPL | Stock | 3.3414 | 3.3593 | 3.3393 | 3.3546 | 13654984.0 |
| 2008-12-15 10:35:00 | AAPL | Stock | 3.3543 | 3.3625 | 3.3468 | 3.36 | 12765732.0 |
| 2008-12-15 10:40:00 | AAPL | Stock | 3.36 | 3.3704 | 3.3546 | 3.3629 | 9025296.0 |
| 2008-12-15 10:45:00 | AAPL | Stock | 3.3618 | 3.365 | 3.3411 | 3.3436 | 10148656.0 |
| 2008-12-15 10:50:00 | AAPL | Stock | 3.3436 | 3.3493 | 3.3357 | 3.3432 | 7914956.0 |
| 2008-12-15 10:55:00 | AAPL | Stock | 3.3432 | 3.3446 | 3.3357 | 3.3409 | 8432592.0 |
> showing 50 of 308,738 rows — these rows as CSV