PREVIEW / stock_5min / 2010-01-26
file: by_date/stock_5min/2010/2010-01-26.parquet size: 4.7 MB rows: 323,607 symbols: 3,444
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-01-26 04:15:00 | AAPL | Stock | 7.3554 | 7.36 | 7.3375 | 7.3571 | 38304.0 |
| 2010-01-26 04:20:00 | AAPL | Stock | 7.3636 | 7.3636 | 7.3636 | 7.3636 | 5600.0 |
| 2010-01-26 04:30:00 | AAPL | Stock | 7.3636 | 7.3636 | 7.3636 | 7.3636 | 8400.0 |
| 2010-01-26 04:45:00 | AAPL | Stock | 7.39 | 7.39 | 7.39 | 7.39 | 2800.0 |
| 2010-01-26 04:50:00 | AAPL | Stock | 7.3754 | 7.3754 | 7.375 | 7.375 | 28000.0 |
| 2010-01-26 04:55:00 | AAPL | Stock | 7.3932 | 7.3932 | 7.3932 | 7.3932 | 9240.0 |
| 2010-01-26 05:10:00 | AAPL | Stock | 7.3914 | 7.3946 | 7.3914 | 7.3946 | 5600.0 |
| 2010-01-26 05:20:00 | AAPL | Stock | 7.3929 | 7.3929 | 7.3929 | 7.3929 | 5600.0 |
| 2010-01-26 05:25:00 | AAPL | Stock | 7.3889 | 7.3929 | 7.375 | 7.375 | 19600.0 |
| 2010-01-26 05:40:00 | AAPL | Stock | 7.3714 | 7.3714 | 7.37 | 7.37 | 19600.0 |
| 2010-01-26 05:45:00 | AAPL | Stock | 7.3682 | 7.3718 | 7.3682 | 7.3718 | 14000.0 |
| 2010-01-26 06:00:00 | AAPL | Stock | 7.3714 | 7.3714 | 7.3714 | 7.3714 | 3500.0 |
| 2010-01-26 06:05:00 | AAPL | Stock | 7.37 | 7.37 | 7.3614 | 7.3664 | 33040.0 |
| 2010-01-26 06:10:00 | AAPL | Stock | 7.3629 | 7.3629 | 7.3629 | 7.3629 | 14000.0 |
| 2010-01-26 06:15:00 | AAPL | Stock | 7.3604 | 7.3604 | 7.3543 | 7.3589 | 39536.0 |
| 2010-01-26 06:20:00 | AAPL | Stock | 7.3543 | 7.3543 | 7.3543 | 7.3543 | 7784.0 |
| 2010-01-26 06:25:00 | AAPL | Stock | 7.3604 | 7.3604 | 7.3604 | 7.3604 | 25676.0 |
| 2010-01-26 06:30:00 | AAPL | Stock | 7.3625 | 7.3625 | 7.3543 | 7.3543 | 21028.0 |
| 2010-01-26 06:35:00 | AAPL | Stock | 7.3625 | 7.3629 | 7.3561 | 7.3607 | 45612.0 |
| 2010-01-26 06:40:00 | AAPL | Stock | 7.3661 | 7.3661 | 7.3661 | 7.3661 | 8400.0 |
| 2010-01-26 06:45:00 | AAPL | Stock | 7.3632 | 7.3736 | 7.3632 | 7.3736 | 12796.0 |
| 2010-01-26 06:50:00 | AAPL | Stock | 7.3736 | 7.3736 | 7.3736 | 7.3736 | 2800.0 |
| 2010-01-26 06:55:00 | AAPL | Stock | 7.3611 | 7.3611 | 7.3521 | 7.3521 | 50512.0 |
| 2010-01-26 07:00:00 | AAPL | Stock | 7.3618 | 7.3679 | 7.3521 | 7.3607 | 165620.0 |
| 2010-01-26 07:05:00 | AAPL | Stock | 7.3625 | 7.3643 | 7.3575 | 7.3575 | 37800.0 |
| 2010-01-26 07:10:00 | AAPL | Stock | 7.3607 | 7.3718 | 7.3607 | 7.3718 | 22232.0 |
| 2010-01-26 07:15:00 | AAPL | Stock | 7.3704 | 7.3929 | 7.3704 | 7.3925 | 101640.0 |
| 2010-01-26 07:20:00 | AAPL | Stock | 7.3836 | 7.3857 | 7.3793 | 7.3839 | 64092.0 |
| 2010-01-26 07:25:00 | AAPL | Stock | 7.3893 | 7.4029 | 7.3821 | 7.3929 | 364336.0 |
| 2010-01-26 07:30:00 | AAPL | Stock | 7.3925 | 7.4432 | 7.3918 | 7.4293 | 497028.0 |
| 2010-01-26 07:35:00 | AAPL | Stock | 7.4289 | 7.4404 | 7.4079 | 7.4221 | 969780.0 |
| 2010-01-26 07:40:00 | AAPL | Stock | 7.4261 | 7.4375 | 7.4239 | 7.4261 | 355488.0 |
| 2010-01-26 07:45:00 | AAPL | Stock | 7.4246 | 7.4304 | 7.4196 | 7.4196 | 211120.0 |
| 2010-01-26 07:50:00 | AAPL | Stock | 7.4232 | 7.4711 | 7.4232 | 7.4643 | 1261484.0 |
| 2010-01-26 07:55:00 | AAPL | Stock | 7.4657 | 7.4764 | 7.44 | 7.4496 | 804888.0 |
| 2010-01-26 08:00:00 | AAPL | Stock | 7.4343 | 7.4375 | 7.4 | 7.4004 | 2901864.0 |
| 2010-01-26 08:05:00 | AAPL | Stock | 7.4036 | 7.4107 | 7.3771 | 7.3964 | 1656704.0 |
| 2010-01-26 08:10:00 | AAPL | Stock | 7.3964 | 7.4464 | 7.3939 | 7.4214 | 2675148.0 |
| 2010-01-26 08:15:00 | AAPL | Stock | 7.4207 | 7.4286 | 7.4107 | 7.4107 | 1060388.0 |
| 2010-01-26 08:20:00 | AAPL | Stock | 7.4107 | 7.4371 | 7.4107 | 7.425 | 1627724.0 |
| 2010-01-26 08:25:00 | AAPL | Stock | 7.425 | 7.4279 | 7.3993 | 7.4079 | 1343440.0 |
| 2010-01-26 08:30:00 | AAPL | Stock | 7.4093 | 7.4093 | 7.3893 | 7.4061 | 1197280.0 |
| 2010-01-26 08:35:00 | AAPL | Stock | 7.4086 | 7.4232 | 7.4057 | 7.4079 | 690676.0 |
| 2010-01-26 08:40:00 | AAPL | Stock | 7.4093 | 7.4264 | 7.4054 | 7.4186 | 1408988.0 |
| 2010-01-26 08:45:00 | AAPL | Stock | 7.4157 | 7.4229 | 7.4107 | 7.4168 | 1394568.0 |
| 2010-01-26 08:50:00 | AAPL | Stock | 7.4146 | 7.4321 | 7.4143 | 7.4161 | 2139956.0 |
| 2010-01-26 08:55:00 | AAPL | Stock | 7.4175 | 7.4211 | 7.3975 | 7.4039 | 3142356.0 |
| 2010-01-26 09:00:00 | AAPL | Stock | 7.4043 | 7.4068 | 7.38 | 7.3929 | 2117024.0 |
| 2010-01-26 09:05:00 | AAPL | Stock | 7.3929 | 7.3932 | 7.3429 | 7.35 | 3099012.0 |
| 2010-01-26 09:10:00 | AAPL | Stock | 7.3507 | 7.3661 | 7.3339 | 7.3511 | 3045896.0 |
> showing 50 of 323,607 rows — these rows as CSV