PREVIEW / stock_5min / 2010-04-29
file: by_date/stock_5min/2010/2010-04-29.parquet size: 5.0 MB rows: 341,198 symbols: 3,498
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-29 04:15:00 | AAPL | Stock | 9.3679 | 9.3679 | 9.3679 | 9.3679 | 5600.0 |
| 2010-04-29 04:30:00 | AAPL | Stock | 9.3714 | 9.3714 | 9.3714 | 9.3714 | 3220.0 |
| 2010-04-29 05:30:00 | AAPL | Stock | 9.3746 | 9.3746 | 9.3746 | 9.3746 | 2800.0 |
| 2010-04-29 05:40:00 | AAPL | Stock | 9.3507 | 9.3507 | 9.3507 | 9.3507 | 2800.0 |
| 2010-04-29 05:50:00 | AAPL | Stock | 9.3746 | 9.3893 | 9.3746 | 9.3893 | 31024.0 |
| 2010-04-29 05:55:00 | AAPL | Stock | 9.4 | 9.4 | 9.4 | 9.4 | 16800.0 |
| 2010-04-29 06:00:00 | AAPL | Stock | 9.4 | 9.4 | 9.4 | 9.4 | 3388.0 |
| 2010-04-29 06:10:00 | AAPL | Stock | 9.4071 | 9.4107 | 9.4071 | 9.4107 | 13020.0 |
| 2010-04-29 06:20:00 | AAPL | Stock | 9.4039 | 9.4039 | 9.4039 | 9.4039 | 28000.0 |
| 2010-04-29 06:25:00 | AAPL | Stock | 9.4036 | 9.4036 | 9.4036 | 9.4036 | 2800.0 |
| 2010-04-29 06:45:00 | AAPL | Stock | 9.4029 | 9.4029 | 9.4029 | 9.4029 | 5600.0 |
| 2010-04-29 06:50:00 | AAPL | Stock | 9.4036 | 9.4036 | 9.4036 | 9.4036 | 2800.0 |
| 2010-04-29 06:55:00 | AAPL | Stock | 9.3936 | 9.4032 | 9.3936 | 9.4029 | 56000.0 |
| 2010-04-29 07:00:00 | AAPL | Stock | 9.4036 | 9.4104 | 9.4036 | 9.4104 | 21560.0 |
| 2010-04-29 07:05:00 | AAPL | Stock | 9.4104 | 9.4161 | 9.4104 | 9.4161 | 46480.0 |
| 2010-04-29 07:10:00 | AAPL | Stock | 9.4161 | 9.4214 | 9.4161 | 9.4179 | 95340.0 |
| 2010-04-29 07:20:00 | AAPL | Stock | 9.4179 | 9.4179 | 9.4179 | 9.4179 | 40880.0 |
| 2010-04-29 07:25:00 | AAPL | Stock | 9.4179 | 9.4179 | 9.4179 | 9.4179 | 2800.0 |
| 2010-04-29 07:30:00 | AAPL | Stock | 9.4079 | 9.4079 | 9.4079 | 9.4079 | 8400.0 |
| 2010-04-29 07:35:00 | AAPL | Stock | 9.4079 | 9.4107 | 9.4075 | 9.4075 | 26460.0 |
| 2010-04-29 07:40:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4068 | 9.4068 | 11900.0 |
| 2010-04-29 07:45:00 | AAPL | Stock | 9.4029 | 9.4029 | 9.4029 | 9.4029 | 2800.0 |
| 2010-04-29 07:50:00 | AAPL | Stock | 9.4029 | 9.4071 | 9.4029 | 9.4071 | 35700.0 |
| 2010-04-29 07:55:00 | AAPL | Stock | 9.4071 | 9.4121 | 9.4071 | 9.4107 | 121520.0 |
| 2010-04-29 08:00:00 | AAPL | Stock | 9.4032 | 9.4121 | 9.375 | 9.3911 | 473368.0 |
| 2010-04-29 08:05:00 | AAPL | Stock | 9.3929 | 9.395 | 9.3893 | 9.3921 | 159768.0 |
| 2010-04-29 08:10:00 | AAPL | Stock | 9.3929 | 9.4071 | 9.3882 | 9.4071 | 144004.0 |
| 2010-04-29 08:15:00 | AAPL | Stock | 9.4075 | 9.4114 | 9.4054 | 9.4075 | 295148.0 |
| 2010-04-29 08:20:00 | AAPL | Stock | 9.4025 | 9.4054 | 9.4018 | 9.4054 | 327964.0 |
| 2010-04-29 08:25:00 | AAPL | Stock | 9.4036 | 9.4129 | 9.4036 | 9.4086 | 229180.0 |
| 2010-04-29 08:30:00 | AAPL | Stock | 9.4075 | 9.4096 | 9.3937 | 9.4071 | 147504.0 |
| 2010-04-29 08:35:00 | AAPL | Stock | 9.4007 | 9.4054 | 9.3968 | 9.4036 | 111972.0 |
| 2010-04-29 08:40:00 | AAPL | Stock | 9.4025 | 9.4043 | 9.4025 | 9.4043 | 22400.0 |
| 2010-04-29 08:45:00 | AAPL | Stock | 9.4057 | 9.4057 | 9.3868 | 9.3868 | 367192.0 |
| 2010-04-29 08:50:00 | AAPL | Stock | 9.3854 | 9.3936 | 9.3839 | 9.3932 | 184940.0 |
| 2010-04-29 08:55:00 | AAPL | Stock | 9.3932 | 9.3932 | 9.3886 | 9.3886 | 49700.0 |
| 2010-04-29 09:00:00 | AAPL | Stock | 9.3857 | 9.3921 | 9.3857 | 9.3921 | 53200.0 |
| 2010-04-29 09:05:00 | AAPL | Stock | 9.3921 | 9.3925 | 9.3871 | 9.3904 | 62160.0 |
| 2010-04-29 09:10:00 | AAPL | Stock | 9.39 | 9.3961 | 9.3893 | 9.3893 | 358232.0 |
| 2010-04-29 09:15:00 | AAPL | Stock | 9.3918 | 9.3982 | 9.3918 | 9.3975 | 198660.0 |
| 2010-04-29 09:20:00 | AAPL | Stock | 9.3975 | 9.3982 | 9.3921 | 9.3936 | 257516.0 |
| 2010-04-29 09:25:00 | AAPL | Stock | 9.395 | 9.3964 | 9.3889 | 9.3946 | 265804.0 |
| 2010-04-29 09:30:00 | AAPL | Stock | 9.3946 | 9.4039 | 9.3575 | 9.385 | 22919652.0 |
| 2010-04-29 09:35:00 | AAPL | Stock | 9.3868 | 9.4357 | 9.3643 | 9.4336 | 17166100.0 |
| 2010-04-29 09:40:00 | AAPL | Stock | 9.4336 | 9.4536 | 9.4293 | 9.4411 | 15197840.0 |
| 2010-04-29 09:45:00 | AAPL | Stock | 9.4446 | 9.4482 | 9.4214 | 9.4332 | 11119192.0 |
| 2010-04-29 09:50:00 | AAPL | Stock | 9.4314 | 9.4593 | 9.4307 | 9.4507 | 9168852.0 |
| 2010-04-29 09:55:00 | AAPL | Stock | 9.4525 | 9.4961 | 9.4479 | 9.4961 | 18518052.0 |
| 2010-04-29 10:00:00 | AAPL | Stock | 9.496 | 9.5093 | 9.4821 | 9.5039 | 14275632.0 |
| 2010-04-29 10:05:00 | AAPL | Stock | 9.5054 | 9.5075 | 9.4707 | 9.4864 | 11750256.0 |
> showing 50 of 341,198 rows — these rows as CSV