PREVIEW / stock_1min / 2010-03-31
file: by_date/stock_1min/2010/2010-03-31.parquet size: 12.8 MB rows: 969,273 symbols: 2,829
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:34: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:41:00 | AAPL | Stock | 8.4546 | 8.4546 | 8.4546 | 8.4546 | 2800.0 |
| 2010-03-31 04:46:00 | AAPL | Stock | 8.4546 | 8.4546 | 8.4546 | 8.4546 | 2800.0 |
| 2010-03-31 04:59:00 | AAPL | Stock | 8.4518 | 8.4518 | 8.4518 | 8.4518 | 2800.0 |
| 2010-03-31 05:00:00 | AAPL | Stock | 8.4546 | 8.455 | 8.4546 | 8.455 | 17640.0 |
| 2010-03-31 05:01:00 | AAPL | Stock | 8.4596 | 8.4596 | 8.4596 | 8.4596 | 3164.0 |
| 2010-03-31 05:02:00 | AAPL | Stock | 8.4618 | 8.4618 | 8.4618 | 8.4618 | 3164.0 |
| 2010-03-31 05:04:00 | AAPL | Stock | 8.4618 | 8.4618 | 8.4618 | 8.4618 | 3192.0 |
| 2010-03-31 05:40:00 | AAPL | Stock | 8.4618 | 8.4618 | 8.4618 | 8.4618 | 3220.0 |
| 2010-03-31 06:42:00 | AAPL | Stock | 8.445 | 8.4618 | 8.4396 | 8.4396 | 14924.0 |
| 2010-03-31 06:43:00 | AAPL | Stock | 8.445 | 8.445 | 8.445 | 8.445 | 2800.0 |
| 2010-03-31 06:58: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.4611 | 8.4614 | 14000.0 |
| 2010-03-31 07:04:00 | AAPL | Stock | 8.4411 | 8.4411 | 8.4411 | 8.4411 | 2800.0 |
| 2010-03-31 07:11:00 | AAPL | Stock | 8.4418 | 8.4418 | 8.4418 | 8.4418 | 2800.0 |
| 2010-03-31 07:16:00 | AAPL | Stock | 8.4421 | 8.4421 | 8.4421 | 8.4421 | 2800.0 |
| 2010-03-31 07:17:00 | AAPL | Stock | 8.4421 | 8.4421 | 8.4421 | 8.4421 | 2800.0 |
| 2010-03-31 07:19:00 | AAPL | Stock | 8.4432 | 8.4432 | 8.4429 | 8.4429 | 33600.0 |
| 2010-03-31 07:20:00 | AAPL | Stock | 8.4411 | 8.4411 | 8.4411 | 8.4411 | 2800.0 |
| 2010-03-31 07:23:00 | AAPL | Stock | 8.44 | 8.44 | 8.44 | 8.44 | 3640.0 |
| 2010-03-31 07:24:00 | AAPL | Stock | 8.44 | 8.44 | 8.44 | 8.44 | 10360.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.4393 | 8.4393 | 8.4393 | 14000.0 |
| 2010-03-31 07:47:00 | AAPL | Stock | 8.4393 | 8.45 | 8.4393 | 8.45 | 5600.0 |
| 2010-03-31 07:50:00 | AAPL | Stock | 8.4393 | 8.4393 | 8.4393 | 8.4393 | 7000.0 |
| 2010-03-31 07:51:00 | AAPL | Stock | 8.4496 | 8.4496 | 8.4496 | 8.4496 | 2800.0 |
| 2010-03-31 08:00:00 | AAPL | Stock | 8.4475 | 8.4475 | 8.4286 | 8.4296 | 56028.0 |
| 2010-03-31 08:01:00 | AAPL | Stock | 8.435 | 8.4357 | 8.4264 | 8.4293 | 153048.0 |
| 2010-03-31 08:02:00 | AAPL | Stock | 8.4293 | 8.4293 | 8.4293 | 8.4293 | 30240.0 |
| 2010-03-31 08:03:00 | AAPL | Stock | 8.4293 | 8.4293 | 8.4236 | 8.4236 | 5600.0 |
| 2010-03-31 08:05:00 | AAPL | Stock | 8.4296 | 8.4296 | 8.4296 | 8.4296 | 8400.0 |
| 2010-03-31 08:06:00 | AAPL | Stock | 8.4286 | 8.4318 | 8.4286 | 8.4318 | 29960.0 |
| 2010-03-31 08:07:00 | AAPL | Stock | 8.4318 | 8.4339 | 8.4318 | 8.4339 | 12040.0 |
| 2010-03-31 08:08:00 | AAPL | Stock | 8.4382 | 8.4382 | 8.4382 | 8.4382 | 2800.0 |
| 2010-03-31 08:09:00 | AAPL | Stock | 8.4357 | 8.4357 | 8.4339 | 8.4339 | 29960.0 |
| 2010-03-31 08:10:00 | AAPL | Stock | 8.4346 | 8.4346 | 8.4346 | 8.4346 | 2800.0 |
| 2010-03-31 08:11:00 | AAPL | Stock | 8.4339 | 8.4368 | 8.4339 | 8.4368 | 47600.0 |
| 2010-03-31 08:12:00 | AAPL | Stock | 8.435 | 8.4361 | 8.435 | 8.4361 | 22400.0 |
| 2010-03-31 08:13:00 | AAPL | Stock | 8.4375 | 8.4379 | 8.4357 | 8.4357 | 33600.0 |
| 2010-03-31 08:15:00 | AAPL | Stock | 8.4357 | 8.4357 | 8.4093 | 8.4093 | 232596.0 |
| 2010-03-31 08:16:00 | AAPL | Stock | 8.4093 | 8.4104 | 8.3929 | 8.4018 | 115724.0 |
| 2010-03-31 08:17:00 | AAPL | Stock | 8.3982 | 8.4107 | 8.3929 | 8.3996 | 161364.0 |
| 2010-03-31 08:18:00 | AAPL | Stock | 8.3989 | 8.4 | 8.3964 | 8.3993 | 88480.0 |
| 2010-03-31 08:19:00 | AAPL | Stock | 8.4014 | 8.4036 | 8.4 | 8.4018 | 33180.0 |
| 2010-03-31 08:20:00 | AAPL | Stock | 8.4036 | 8.4036 | 8.4018 | 8.4018 | 64400.0 |
| 2010-03-31 08:21:00 | AAPL | Stock | 8.4021 | 8.4046 | 8.4018 | 8.4043 | 21140.0 |
| 2010-03-31 08:22:00 | AAPL | Stock | 8.4057 | 8.4093 | 8.4043 | 8.4089 | 50260.0 |
> showing 50 of 969,273 rows — these rows as CSV