PREVIEW / stock_5min / 2009-04-22
file: by_date/stock_5min/2009/2009-04-22.parquet size: 4.5 MB rows: 308,531 symbols: 3,312
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-04-22 05:05:00 | AAPL | Stock | 4.3171 | 4.3171 | 4.3171 | 4.3171 | 5600.0 |
| 2009-04-22 06:35:00 | AAPL | Stock | 4.3125 | 4.3125 | 4.3125 | 4.3125 | 14000.0 |
| 2009-04-22 06:55:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3214 | 4.3214 | 5600.0 |
| 2009-04-22 07:05:00 | AAPL | Stock | 4.3325 | 4.3325 | 4.3325 | 4.3325 | 8400.0 |
| 2009-04-22 07:10:00 | AAPL | Stock | 4.3268 | 4.3268 | 4.325 | 4.325 | 16520.0 |
| 2009-04-22 07:15:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3214 | 4.3214 | 2800.0 |
| 2009-04-22 07:20:00 | AAPL | Stock | 4.3196 | 4.3196 | 4.3196 | 4.3196 | 2800.0 |
| 2009-04-22 07:30:00 | AAPL | Stock | 4.3482 | 4.3571 | 4.3375 | 4.3568 | 104972.0 |
| 2009-04-22 07:40:00 | AAPL | Stock | 4.3568 | 4.3568 | 4.3482 | 4.3482 | 11200.0 |
| 2009-04-22 08:00:00 | AAPL | Stock | 4.3429 | 4.3646 | 4.3361 | 4.3482 | 103124.0 |
| 2009-04-22 08:05:00 | AAPL | Stock | 4.3482 | 4.3536 | 4.3446 | 4.35 | 868252.0 |
| 2009-04-22 08:10:00 | AAPL | Stock | 4.3482 | 4.3643 | 4.3482 | 4.3643 | 330260.0 |
| 2009-04-22 08:15:00 | AAPL | Stock | 4.3661 | 4.3661 | 4.3493 | 4.35 | 70980.0 |
| 2009-04-22 08:20:00 | AAPL | Stock | 4.35 | 4.3536 | 4.35 | 4.3536 | 98280.0 |
| 2009-04-22 08:25:00 | AAPL | Stock | 4.3536 | 4.3625 | 4.3536 | 4.3536 | 118748.0 |
| 2009-04-22 08:30:00 | AAPL | Stock | 4.3575 | 4.3661 | 4.3571 | 4.3654 | 72128.0 |
| 2009-04-22 08:35:00 | AAPL | Stock | 4.3675 | 4.3882 | 4.3654 | 4.3696 | 393540.0 |
| 2009-04-22 08:40:00 | AAPL | Stock | 4.3704 | 4.3764 | 4.3696 | 4.375 | 222740.0 |
| 2009-04-22 08:45:00 | AAPL | Stock | 4.3739 | 4.3746 | 4.3696 | 4.3696 | 114576.0 |
| 2009-04-22 08:50:00 | AAPL | Stock | 4.3696 | 4.3786 | 4.3696 | 4.3779 | 113120.0 |
| 2009-04-22 08:55:00 | AAPL | Stock | 4.3789 | 4.3868 | 4.3786 | 4.3821 | 586684.0 |
| 2009-04-22 09:00:00 | AAPL | Stock | 4.3789 | 4.3889 | 4.3789 | 4.3875 | 160160.0 |
| 2009-04-22 09:05:00 | AAPL | Stock | 4.3875 | 4.3893 | 4.3839 | 4.385 | 388220.0 |
| 2009-04-22 09:10:00 | AAPL | Stock | 4.3861 | 4.3879 | 4.3821 | 4.3821 | 255696.0 |
| 2009-04-22 09:15:00 | AAPL | Stock | 4.3821 | 4.3836 | 4.3768 | 4.3775 | 288064.0 |
| 2009-04-22 09:20:00 | AAPL | Stock | 4.3768 | 4.3789 | 4.375 | 4.375 | 71092.0 |
| 2009-04-22 09:25:00 | AAPL | Stock | 4.3761 | 4.3839 | 4.3736 | 4.3796 | 559188.0 |
| 2009-04-22 09:30:00 | AAPL | Stock | 4.3786 | 4.4332 | 4.3668 | 4.4218 | 28164192.0 |
| 2009-04-22 09:35:00 | AAPL | Stock | 4.4211 | 4.4464 | 4.4143 | 4.4336 | 23580592.0 |
| 2009-04-22 09:40:00 | AAPL | Stock | 4.4339 | 4.4393 | 4.4136 | 4.4175 | 14867020.0 |
| 2009-04-22 09:45:00 | AAPL | Stock | 4.4164 | 4.4179 | 4.4032 | 4.405 | 12268592.0 |
| 2009-04-22 09:50:00 | AAPL | Stock | 4.4056 | 4.4311 | 4.4011 | 4.4243 | 14198716.0 |
| 2009-04-22 09:55:00 | AAPL | Stock | 4.4243 | 4.4468 | 4.42 | 4.4431 | 13447504.0 |
| 2009-04-22 10:00:00 | AAPL | Stock | 4.4429 | 4.4457 | 4.4325 | 4.4411 | 9335116.0 |
| 2009-04-22 10:05:00 | AAPL | Stock | 4.4404 | 4.4471 | 4.4386 | 4.4436 | 12239724.0 |
| 2009-04-22 10:10:00 | AAPL | Stock | 4.4432 | 4.4604 | 4.4336 | 4.4589 | 13651148.0 |
| 2009-04-22 10:15:00 | AAPL | Stock | 4.4582 | 4.4643 | 4.4569 | 4.4589 | 8801072.0 |
| 2009-04-22 10:20:00 | AAPL | Stock | 4.4596 | 4.4721 | 4.4579 | 4.4714 | 13785156.0 |
| 2009-04-22 10:25:00 | AAPL | Stock | 4.4714 | 4.4768 | 4.4607 | 4.4654 | 12193468.0 |
| 2009-04-22 10:30:00 | AAPL | Stock | 4.4657 | 4.4696 | 4.45 | 4.4532 | 7729204.0 |
| 2009-04-22 10:35:00 | AAPL | Stock | 4.4532 | 4.4686 | 4.4532 | 4.4568 | 8910328.0 |
| 2009-04-22 10:40:00 | AAPL | Stock | 4.4568 | 4.4625 | 4.4411 | 4.4439 | 7916440.0 |
| 2009-04-22 10:45:00 | AAPL | Stock | 4.4436 | 4.4468 | 4.4411 | 4.4429 | 4696300.0 |
| 2009-04-22 10:50:00 | AAPL | Stock | 4.4429 | 4.4521 | 4.4393 | 4.4504 | 8251824.0 |
| 2009-04-22 10:55:00 | AAPL | Stock | 4.4504 | 4.4589 | 4.445 | 4.4485 | 5974192.0 |
| 2009-04-22 11:00:00 | AAPL | Stock | 4.4489 | 4.4496 | 4.4311 | 4.4311 | 7440664.0 |
| 2009-04-22 11:05:00 | AAPL | Stock | 4.4325 | 4.4464 | 4.4204 | 4.4307 | 8283436.0 |
| 2009-04-22 11:10:00 | AAPL | Stock | 4.4314 | 4.4375 | 4.4268 | 4.4346 | 6004236.0 |
| 2009-04-22 11:15:00 | AAPL | Stock | 4.4345 | 4.4479 | 4.4345 | 4.4479 | 5003600.0 |
| 2009-04-22 11:20:00 | AAPL | Stock | 4.4475 | 4.4625 | 4.4446 | 4.455 | 7070812.0 |
> showing 50 of 308,531 rows — these rows as CSV