PREVIEW / stock_5min / 2010-05-04
file: by_date/stock_5min/2010/2010-05-04.parquet size: 5.1 MB rows: 345,921 symbols: 3,488
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-05-04 04:30:00 | AAPL | Stock | 9.5018 | 9.5018 | 9.5018 | 9.5018 | 5600.0 |
| 2010-05-04 04:35:00 | AAPL | Stock | 9.4911 | 9.4911 | 9.4911 | 9.4911 | 14000.0 |
| 2010-05-04 05:30:00 | AAPL | Stock | 9.4771 | 9.4771 | 9.4771 | 9.4771 | 2800.0 |
| 2010-05-04 05:35:00 | AAPL | Stock | 9.4793 | 9.4793 | 9.4793 | 9.4793 | 14000.0 |
| 2010-05-04 05:40:00 | AAPL | Stock | 9.4643 | 9.4643 | 9.4643 | 9.4643 | 16800.0 |
| 2010-05-04 06:10:00 | AAPL | Stock | 9.4679 | 9.4679 | 9.4661 | 9.4661 | 8400.0 |
| 2010-05-04 06:20:00 | AAPL | Stock | 9.4657 | 9.4768 | 9.4657 | 9.4768 | 22400.0 |
| 2010-05-04 06:30:00 | AAPL | Stock | 9.4661 | 9.4696 | 9.4661 | 9.4696 | 5600.0 |
| 2010-05-04 06:45:00 | AAPL | Stock | 9.4661 | 9.4661 | 9.4661 | 9.4661 | 2800.0 |
| 2010-05-04 06:50:00 | AAPL | Stock | 9.4543 | 9.4643 | 9.4543 | 9.4643 | 11200.0 |
| 2010-05-04 06:55:00 | AAPL | Stock | 9.4543 | 9.4543 | 9.4539 | 9.4539 | 16800.0 |
| 2010-05-04 07:00:00 | AAPL | Stock | 9.4643 | 9.4643 | 9.4464 | 9.4482 | 23800.0 |
| 2010-05-04 07:05:00 | AAPL | Stock | 9.4471 | 9.4732 | 9.4471 | 9.4479 | 42000.0 |
| 2010-05-04 07:10:00 | AAPL | Stock | 9.4368 | 9.4464 | 9.4368 | 9.4464 | 7000.0 |
| 2010-05-04 07:15:00 | AAPL | Stock | 9.4371 | 9.4371 | 9.4361 | 9.4361 | 25200.0 |
| 2010-05-04 07:20:00 | AAPL | Stock | 9.4557 | 9.4557 | 9.4557 | 9.4557 | 2800.0 |
| 2010-05-04 07:25:00 | AAPL | Stock | 9.4532 | 9.4532 | 9.4532 | 9.4532 | 2800.0 |
| 2010-05-04 07:30:00 | AAPL | Stock | 9.4386 | 9.44 | 9.4386 | 9.44 | 5600.0 |
| 2010-05-04 07:40:00 | AAPL | Stock | 9.4468 | 9.45 | 9.4429 | 9.45 | 19180.0 |
| 2010-05-04 07:45:00 | AAPL | Stock | 9.4457 | 9.4457 | 9.4068 | 9.4068 | 151060.0 |
| 2010-05-04 07:50:00 | AAPL | Stock | 9.41 | 9.4314 | 9.4096 | 9.4314 | 19600.0 |
| 2010-05-04 07:55:00 | AAPL | Stock | 9.4171 | 9.4196 | 9.4107 | 9.4114 | 187068.0 |
| 2010-05-04 08:00:00 | AAPL | Stock | 9.4139 | 9.4193 | 9.3839 | 9.3936 | 1303064.0 |
| 2010-05-04 08:05:00 | AAPL | Stock | 9.4 | 9.4018 | 9.3914 | 9.3932 | 254632.0 |
| 2010-05-04 08:10:00 | AAPL | Stock | 9.3932 | 9.4043 | 9.3932 | 9.4 | 111524.0 |
| 2010-05-04 08:15:00 | AAPL | Stock | 9.4061 | 9.4164 | 9.4061 | 9.4107 | 189840.0 |
| 2010-05-04 08:20:00 | AAPL | Stock | 9.4098 | 9.4157 | 9.4079 | 9.4157 | 177100.0 |
| 2010-05-04 08:25:00 | AAPL | Stock | 9.4139 | 9.4157 | 9.4086 | 9.4089 | 33600.0 |
| 2010-05-04 08:30:00 | AAPL | Stock | 9.4107 | 9.4129 | 9.4089 | 9.4089 | 93100.0 |
| 2010-05-04 08:35:00 | AAPL | Stock | 9.41 | 9.4236 | 9.41 | 9.4236 | 326816.0 |
| 2010-05-04 08:40:00 | AAPL | Stock | 9.4218 | 9.425 | 9.4196 | 9.4214 | 222880.0 |
| 2010-05-04 08:45:00 | AAPL | Stock | 9.4214 | 9.4236 | 9.4196 | 9.4196 | 168756.0 |
| 2010-05-04 08:50:00 | AAPL | Stock | 9.4207 | 9.4214 | 9.4146 | 9.4146 | 132804.0 |
| 2010-05-04 08:55:00 | AAPL | Stock | 9.4136 | 9.4204 | 9.4136 | 9.4143 | 421260.0 |
| 2010-05-04 09:00:00 | AAPL | Stock | 9.4168 | 9.4168 | 9.405 | 9.4064 | 245000.0 |
| 2010-05-04 09:05:00 | AAPL | Stock | 9.4054 | 9.4089 | 9.3968 | 9.3996 | 90216.0 |
| 2010-05-04 09:10:00 | AAPL | Stock | 9.4 | 9.4075 | 9.3796 | 9.38 | 707224.0 |
| 2010-05-04 09:15:00 | AAPL | Stock | 9.3807 | 9.3929 | 9.38 | 9.3875 | 308644.0 |
| 2010-05-04 09:20:00 | AAPL | Stock | 9.3857 | 9.4075 | 9.3825 | 9.3982 | 446516.0 |
| 2010-05-04 09:25:00 | AAPL | Stock | 9.3986 | 9.4107 | 9.3893 | 9.3929 | 382368.0 |
| 2010-05-04 09:30:00 | AAPL | Stock | 9.3932 | 9.4032 | 9.3214 | 9.3429 | 26648356.0 |
| 2010-05-04 09:35:00 | AAPL | Stock | 9.3405 | 9.3554 | 9.2954 | 9.3232 | 19983992.0 |
| 2010-05-04 09:40:00 | AAPL | Stock | 9.3254 | 9.3443 | 9.3068 | 9.3229 | 11190592.0 |
| 2010-05-04 09:45:00 | AAPL | Stock | 9.3221 | 9.3429 | 9.3089 | 9.3339 | 9099356.0 |
| 2010-05-04 09:50:00 | AAPL | Stock | 9.3311 | 9.3429 | 9.3164 | 9.3361 | 9215360.0 |
| 2010-05-04 09:55:00 | AAPL | Stock | 9.3378 | 9.3425 | 9.3196 | 9.3264 | 12571440.0 |
| 2010-05-04 10:00:00 | AAPL | Stock | 9.3293 | 9.3332 | 9.2825 | 9.2864 | 24629444.0 |
| 2010-05-04 10:05:00 | AAPL | Stock | 9.2861 | 9.3193 | 9.2729 | 9.2879 | 20298936.0 |
| 2010-05-04 10:10:00 | AAPL | Stock | 9.2915 | 9.3111 | 9.2821 | 9.2975 | 8325940.0 |
| 2010-05-04 10:15:00 | AAPL | Stock | 9.3029 | 9.3029 | 9.2718 | 9.2856 | 11174968.0 |
> showing 50 of 345,921 rows — these rows as CSV