PREVIEW / stock_5min / 2009-02-17
file: by_date/stock_5min/2009/2009-02-17.parquet size: 4.4 MB rows: 307,577 symbols: 3,303
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-02-17 04:15:00 | AAPL | Stock | 3.5182 | 3.5182 | 3.5182 | 3.5182 | 2800.0 |
| 2009-02-17 05:30:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 2800.0 |
| 2009-02-17 07:30:00 | AAPL | Stock | 3.4714 | 3.4714 | 3.4714 | 3.4714 | 5600.0 |
| 2009-02-17 07:35:00 | AAPL | Stock | 3.4707 | 3.4714 | 3.4696 | 3.4696 | 22400.0 |
| 2009-02-17 07:40:00 | AAPL | Stock | 3.4682 | 3.4682 | 3.4643 | 3.4643 | 11144.0 |
| 2009-02-17 07:50:00 | AAPL | Stock | 3.4571 | 3.4571 | 3.4571 | 3.4571 | 2800.0 |
| 2009-02-17 07:55:00 | AAPL | Stock | 3.4639 | 3.4643 | 3.4639 | 3.4643 | 11200.0 |
| 2009-02-17 08:00:00 | AAPL | Stock | 3.4696 | 3.4818 | 3.4575 | 3.4714 | 102340.0 |
| 2009-02-17 08:05:00 | AAPL | Stock | 3.4732 | 3.475 | 3.4732 | 3.4736 | 22400.0 |
| 2009-02-17 08:10:00 | AAPL | Stock | 3.4746 | 3.4786 | 3.4746 | 3.4768 | 61320.0 |
| 2009-02-17 08:15:00 | AAPL | Stock | 3.4796 | 3.4821 | 3.4732 | 3.4732 | 108388.0 |
| 2009-02-17 08:20:00 | AAPL | Stock | 3.4714 | 3.4786 | 3.4714 | 3.4732 | 33236.0 |
| 2009-02-17 08:25:00 | AAPL | Stock | 3.475 | 3.4779 | 3.4732 | 3.475 | 25200.0 |
| 2009-02-17 08:30:00 | AAPL | Stock | 3.4764 | 3.4779 | 3.4571 | 3.4571 | 243824.0 |
| 2009-02-17 08:35:00 | AAPL | Stock | 3.4571 | 3.465 | 3.4571 | 3.4596 | 482300.0 |
| 2009-02-17 08:40:00 | AAPL | Stock | 3.46 | 3.4611 | 3.4589 | 3.4611 | 252000.0 |
| 2009-02-17 08:45:00 | AAPL | Stock | 3.4654 | 3.4675 | 3.4621 | 3.4621 | 36400.0 |
| 2009-02-17 08:50:00 | AAPL | Stock | 3.4636 | 3.4668 | 3.4607 | 3.4607 | 51800.0 |
| 2009-02-17 08:55:00 | AAPL | Stock | 3.4611 | 3.4636 | 3.4454 | 3.4582 | 433804.0 |
| 2009-02-17 09:00:00 | AAPL | Stock | 3.4582 | 3.4602 | 3.4396 | 3.4396 | 1335264.0 |
| 2009-02-17 09:05:00 | AAPL | Stock | 3.4443 | 3.45 | 3.4396 | 3.4464 | 412524.0 |
| 2009-02-17 09:10:00 | AAPL | Stock | 3.445 | 3.4493 | 3.4393 | 3.4446 | 170128.0 |
| 2009-02-17 09:15:00 | AAPL | Stock | 3.4446 | 3.4514 | 3.4446 | 3.4496 | 320320.0 |
| 2009-02-17 09:20:00 | AAPL | Stock | 3.45 | 3.4568 | 3.4464 | 3.4568 | 476000.0 |
| 2009-02-17 09:25:00 | AAPL | Stock | 3.4543 | 3.47 | 3.4529 | 3.4629 | 292656.0 |
| 2009-02-17 09:30:00 | AAPL | Stock | 3.4596 | 3.4657 | 3.4357 | 3.4586 | 20749568.0 |
| 2009-02-17 09:35:00 | AAPL | Stock | 3.4589 | 3.4643 | 3.4332 | 3.4332 | 16904160.0 |
| 2009-02-17 09:40:00 | AAPL | Stock | 3.4332 | 3.4411 | 3.425 | 3.4357 | 15581888.0 |
| 2009-02-17 09:45:00 | AAPL | Stock | 3.4357 | 3.4393 | 3.3825 | 3.3871 | 25003776.0 |
| 2009-02-17 09:50:00 | AAPL | Stock | 3.3868 | 3.4093 | 3.3764 | 3.4064 | 22220716.0 |
| 2009-02-17 09:55:00 | AAPL | Stock | 3.4068 | 3.4099 | 3.3975 | 3.4071 | 11734352.0 |
| 2009-02-17 10:00:00 | AAPL | Stock | 3.4071 | 3.4186 | 3.3954 | 3.4057 | 8878884.0 |
| 2009-02-17 10:05:00 | AAPL | Stock | 3.4054 | 3.4182 | 3.3993 | 3.4061 | 8932140.0 |
| 2009-02-17 10:10:00 | AAPL | Stock | 3.4057 | 3.4118 | 3.3989 | 3.4043 | 6894804.0 |
| 2009-02-17 10:15:00 | AAPL | Stock | 3.4039 | 3.405 | 3.3896 | 3.3936 | 8978480.0 |
| 2009-02-17 10:20:00 | AAPL | Stock | 3.3929 | 3.4079 | 3.3929 | 3.4029 | 7203084.0 |
| 2009-02-17 10:25:00 | AAPL | Stock | 3.4029 | 3.4054 | 3.395 | 3.405 | 5840828.0 |
| 2009-02-17 10:30:00 | AAPL | Stock | 3.405 | 3.4157 | 3.4043 | 3.4118 | 8443288.0 |
| 2009-02-17 10:35:00 | AAPL | Stock | 3.4125 | 3.4154 | 3.4021 | 3.4086 | 6473572.0 |
| 2009-02-17 10:40:00 | AAPL | Stock | 3.4096 | 3.4161 | 3.4036 | 3.4161 | 8656340.0 |
| 2009-02-17 10:45:00 | AAPL | Stock | 3.4161 | 3.4239 | 3.4129 | 3.4143 | 10652516.0 |
| 2009-02-17 10:50:00 | AAPL | Stock | 3.4132 | 3.4286 | 3.4125 | 3.4239 | 9508464.0 |
| 2009-02-17 10:55:00 | AAPL | Stock | 3.4232 | 3.4332 | 3.4218 | 3.4236 | 12329240.0 |
| 2009-02-17 11:00:00 | AAPL | Stock | 3.4232 | 3.4236 | 3.4121 | 3.4182 | 9691192.0 |
| 2009-02-17 11:05:00 | AAPL | Stock | 3.4175 | 3.4179 | 3.3993 | 3.4082 | 9496368.0 |
| 2009-02-17 11:10:00 | AAPL | Stock | 3.4069 | 3.4097 | 3.3979 | 3.4014 | 6136732.0 |
| 2009-02-17 11:15:00 | AAPL | Stock | 3.4014 | 3.41 | 3.4 | 3.4054 | 4446848.0 |
| 2009-02-17 11:20:00 | AAPL | Stock | 3.4064 | 3.4136 | 3.4007 | 3.4039 | 4990664.0 |
| 2009-02-17 11:25:00 | AAPL | Stock | 3.4039 | 3.4061 | 3.3989 | 3.4018 | 3690064.0 |
| 2009-02-17 11:30:00 | AAPL | Stock | 3.4021 | 3.4021 | 3.3939 | 3.395 | 6194692.0 |
> showing 50 of 307,577 rows — these rows as CSV