PREVIEW / stock_5min / 2010-03-31
file: by_date/stock_5min/2010/2010-03-31.parquet size: 4.8 MB rows: 331,301 symbols: 3,479
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-03-31 04:15:00 | AAPL | Stock | 8.4446 | 8.4446 | 8.4446 | 8.4446 | 2800.0 |
| 2010-03-31 04:25:00 | AAPL | Stock | 8.4546 | 8.4546 | 8.4546 | 8.4546 | 5600.0 |
| 2010-03-31 04:30:00 | AAPL | Stock | 8.4543 | 8.4543 | 8.4543 | 8.4543 | 2800.0 |
| 2010-03-31 04:35:00 | AAPL | Stock | 8.4471 | 8.4543 | 8.4471 | 8.4543 | 6720.0 |
| 2010-03-31 04:40:00 | AAPL | Stock | 8.4546 | 8.4546 | 8.4546 | 8.4546 | 2800.0 |
| 2010-03-31 04:45:00 | AAPL | Stock | 8.4546 | 8.4546 | 8.4546 | 8.4546 | 2800.0 |
| 2010-03-31 04:55:00 | AAPL | Stock | 8.4518 | 8.4518 | 8.4518 | 8.4518 | 2800.0 |
| 2010-03-31 05:00:00 | AAPL | Stock | 8.4546 | 8.4618 | 8.4546 | 8.4618 | 27160.0 |
| 2010-03-31 05:40:00 | AAPL | Stock | 8.4618 | 8.4618 | 8.4618 | 8.4618 | 3220.0 |
| 2010-03-31 06:40:00 | AAPL | Stock | 8.445 | 8.4618 | 8.4396 | 8.445 | 17724.0 |
| 2010-03-31 06:55:00 | AAPL | Stock | 8.4568 | 8.4568 | 8.4568 | 8.4568 | 11956.0 |
| 2010-03-31 07:00:00 | AAPL | Stock | 8.4611 | 8.4614 | 8.4411 | 8.4411 | 16800.0 |
| 2010-03-31 07:10:00 | AAPL | Stock | 8.4418 | 8.4418 | 8.4418 | 8.4418 | 2800.0 |
| 2010-03-31 07:15:00 | AAPL | Stock | 8.4421 | 8.4432 | 8.4421 | 8.4429 | 39200.0 |
| 2010-03-31 07:20:00 | AAPL | Stock | 8.4411 | 8.4411 | 8.44 | 8.44 | 16800.0 |
| 2010-03-31 07:25:00 | AAPL | Stock | 8.4407 | 8.4407 | 8.4407 | 8.4407 | 8792.0 |
| 2010-03-31 07:45:00 | AAPL | Stock | 8.4393 | 8.45 | 8.4393 | 8.45 | 19600.0 |
| 2010-03-31 07:50:00 | AAPL | Stock | 8.4393 | 8.4496 | 8.4393 | 8.4496 | 9800.0 |
| 2010-03-31 08:00:00 | AAPL | Stock | 8.4475 | 8.4475 | 8.4236 | 8.4236 | 244916.0 |
| 2010-03-31 08:05:00 | AAPL | Stock | 8.4296 | 8.4382 | 8.4286 | 8.4339 | 83160.0 |
| 2010-03-31 08:10:00 | AAPL | Stock | 8.4346 | 8.4379 | 8.4339 | 8.4357 | 106400.0 |
| 2010-03-31 08:15:00 | AAPL | Stock | 8.4357 | 8.4357 | 8.3929 | 8.4018 | 631344.0 |
| 2010-03-31 08:20:00 | AAPL | Stock | 8.4036 | 8.4093 | 8.4011 | 8.4018 | 203588.0 |
| 2010-03-31 08:25:00 | AAPL | Stock | 8.4018 | 8.4018 | 8.3879 | 8.3929 | 369320.0 |
| 2010-03-31 08:30:00 | AAPL | Stock | 8.3925 | 8.3925 | 8.385 | 8.385 | 125860.0 |
| 2010-03-31 08:35:00 | AAPL | Stock | 8.3807 | 8.3839 | 8.3764 | 8.3818 | 231784.0 |
| 2010-03-31 08:40:00 | AAPL | Stock | 8.3814 | 8.3875 | 8.3814 | 8.3854 | 118748.0 |
| 2010-03-31 08:45:00 | AAPL | Stock | 8.3857 | 8.3857 | 8.3814 | 8.3836 | 169288.0 |
| 2010-03-31 08:50:00 | AAPL | Stock | 8.3832 | 8.3882 | 8.3832 | 8.3882 | 108780.0 |
| 2010-03-31 08:55:00 | AAPL | Stock | 8.3889 | 8.3968 | 8.3889 | 8.3968 | 260064.0 |
| 2010-03-31 09:00:00 | AAPL | Stock | 8.3964 | 8.3982 | 8.3939 | 8.3982 | 207200.0 |
| 2010-03-31 09:05:00 | AAPL | Stock | 8.3968 | 8.4004 | 8.3954 | 8.4004 | 89936.0 |
| 2010-03-31 09:10:00 | AAPL | Stock | 8.3993 | 8.3993 | 8.3936 | 8.3936 | 63560.0 |
| 2010-03-31 09:15:00 | AAPL | Stock | 8.3936 | 8.4018 | 8.3929 | 8.3954 | 172060.0 |
| 2010-03-31 09:20:00 | AAPL | Stock | 8.3954 | 8.3982 | 8.3954 | 8.3982 | 40796.0 |
| 2010-03-31 09:25:00 | AAPL | Stock | 8.3982 | 8.4175 | 8.3971 | 8.4125 | 439824.0 |
| 2010-03-31 09:30:00 | AAPL | Stock | 8.4104 | 8.4232 | 8.3946 | 8.3974 | 15050112.0 |
| 2010-03-31 09:35:00 | AAPL | Stock | 8.3968 | 8.4268 | 8.3968 | 8.4236 | 8890616.0 |
| 2010-03-31 09:40:00 | AAPL | Stock | 8.4239 | 8.4504 | 8.4171 | 8.4236 | 17275244.0 |
| 2010-03-31 09:45:00 | AAPL | Stock | 8.4232 | 8.4304 | 8.4093 | 8.4129 | 12982340.0 |
| 2010-03-31 09:50:00 | AAPL | Stock | 8.4118 | 8.4304 | 8.4018 | 8.415 | 9905224.0 |
| 2010-03-31 09:55:00 | AAPL | Stock | 8.4154 | 8.4282 | 8.4029 | 8.42 | 9149196.0 |
| 2010-03-31 10:00:00 | AAPL | Stock | 8.4196 | 8.4268 | 8.4068 | 8.4104 | 7190680.0 |
| 2010-03-31 10:05:00 | AAPL | Stock | 8.41 | 8.4236 | 8.4086 | 8.4196 | 6246016.0 |
| 2010-03-31 10:10:00 | AAPL | Stock | 8.42 | 8.4221 | 8.4018 | 8.4118 | 5963132.0 |
| 2010-03-31 10:15:00 | AAPL | Stock | 8.4118 | 8.4171 | 8.405 | 8.4107 | 5118736.0 |
| 2010-03-31 10:20:00 | AAPL | Stock | 8.4118 | 8.4211 | 8.4104 | 8.415 | 4876956.0 |
| 2010-03-31 10:25:00 | AAPL | Stock | 8.4164 | 8.4253 | 8.3986 | 8.4211 | 10424456.0 |
| 2010-03-31 10:30:00 | AAPL | Stock | 8.42 | 8.4346 | 8.4175 | 8.4343 | 7054488.0 |
| 2010-03-31 10:35:00 | AAPL | Stock | 8.4343 | 8.4361 | 8.4161 | 8.4183 | 9480128.0 |
> showing 50 of 331,301 rows — these rows as CSV