PREVIEW / stock_1min / 2010-05-04
file: by_date/stock_1min/2010/2010-05-04.parquet size: 14.4 MB rows: 1,076,117 symbols: 2,835
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:31: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:32:00 | AAPL | Stock | 9.4771 | 9.4771 | 9.4771 | 9.4771 | 2800.0 |
| 2010-05-04 05:37:00 | AAPL | Stock | 9.4793 | 9.4793 | 9.4793 | 9.4793 | 14000.0 |
| 2010-05-04 05:42:00 | AAPL | Stock | 9.4643 | 9.4643 | 9.4643 | 9.4643 | 16800.0 |
| 2010-05-04 06:11:00 | AAPL | Stock | 9.4679 | 9.4679 | 9.4679 | 9.4679 | 5600.0 |
| 2010-05-04 06:13:00 | AAPL | Stock | 9.4661 | 9.4661 | 9.4661 | 9.4661 | 2800.0 |
| 2010-05-04 06:21:00 | AAPL | Stock | 9.4657 | 9.4768 | 9.4657 | 9.4768 | 22400.0 |
| 2010-05-04 06:31: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:54: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.4643 | 9.4643 | 4200.0 |
| 2010-05-04 07:01:00 | AAPL | Stock | 9.4482 | 9.4482 | 9.4464 | 9.4464 | 14000.0 |
| 2010-05-04 07:04:00 | AAPL | Stock | 9.4482 | 9.4482 | 9.4482 | 9.4482 | 5600.0 |
| 2010-05-04 07:05:00 | AAPL | Stock | 9.4471 | 9.4732 | 9.4471 | 9.4629 | 19600.0 |
| 2010-05-04 07:06:00 | AAPL | Stock | 9.4486 | 9.4486 | 9.4482 | 9.4482 | 8400.0 |
| 2010-05-04 07:08:00 | AAPL | Stock | 9.4479 | 9.4479 | 9.4479 | 9.4479 | 14000.0 |
| 2010-05-04 07:10:00 | AAPL | Stock | 9.4368 | 9.4368 | 9.4368 | 9.4368 | 4200.0 |
| 2010-05-04 07:12:00 | AAPL | Stock | 9.4464 | 9.4464 | 9.4464 | 9.4464 | 2800.0 |
| 2010-05-04 07:18:00 | AAPL | Stock | 9.4371 | 9.4371 | 9.4361 | 9.4361 | 25200.0 |
| 2010-05-04 07:21:00 | AAPL | Stock | 9.4557 | 9.4557 | 9.4557 | 9.4557 | 2800.0 |
| 2010-05-04 07:29:00 | AAPL | Stock | 9.4532 | 9.4532 | 9.4532 | 9.4532 | 2800.0 |
| 2010-05-04 07:34:00 | AAPL | Stock | 9.4386 | 9.44 | 9.4386 | 9.44 | 5600.0 |
| 2010-05-04 07:41:00 | AAPL | Stock | 9.4468 | 9.4468 | 9.4429 | 9.4429 | 10080.0 |
| 2010-05-04 07:43:00 | AAPL | Stock | 9.4464 | 9.45 | 9.4464 | 9.45 | 9100.0 |
| 2010-05-04 07:45:00 | AAPL | Stock | 9.4457 | 9.4457 | 9.4325 | 9.4325 | 20916.0 |
| 2010-05-04 07:46:00 | AAPL | Stock | 9.4325 | 9.4329 | 9.4325 | 9.4329 | 8400.0 |
| 2010-05-04 07:47:00 | AAPL | Stock | 9.4325 | 9.4325 | 9.4325 | 9.4325 | 6720.0 |
| 2010-05-04 07:48:00 | AAPL | Stock | 9.4296 | 9.4296 | 9.4068 | 9.4068 | 115024.0 |
| 2010-05-04 07:50:00 | AAPL | Stock | 9.41 | 9.41 | 9.41 | 9.41 | 5600.0 |
| 2010-05-04 07:51:00 | AAPL | Stock | 9.4096 | 9.41 | 9.4096 | 9.41 | 5600.0 |
| 2010-05-04 07:54:00 | AAPL | Stock | 9.4314 | 9.4314 | 9.4314 | 9.4314 | 8400.0 |
| 2010-05-04 07:58:00 | AAPL | Stock | 9.4171 | 9.4171 | 9.4121 | 9.4121 | 30268.0 |
| 2010-05-04 07:59:00 | AAPL | Stock | 9.4125 | 9.4196 | 9.4107 | 9.4114 | 156800.0 |
| 2010-05-04 08:00:00 | AAPL | Stock | 9.4139 | 9.4193 | 9.3979 | 9.4107 | 320684.0 |
| 2010-05-04 08:01:00 | AAPL | Stock | 9.4107 | 9.4157 | 9.41 | 9.4154 | 634116.0 |
| 2010-05-04 08:02:00 | AAPL | Stock | 9.4111 | 9.4118 | 9.4007 | 9.4007 | 60088.0 |
| 2010-05-04 08:03:00 | AAPL | Stock | 9.4039 | 9.4039 | 9.4 | 9.4036 | 32116.0 |
| 2010-05-04 08:04:00 | AAPL | Stock | 9.4029 | 9.4029 | 9.3839 | 9.3936 | 256060.0 |
| 2010-05-04 08:05:00 | AAPL | Stock | 9.4 | 9.4018 | 9.3932 | 9.4 | 87780.0 |
| 2010-05-04 08:06:00 | AAPL | Stock | 9.4 | 9.4007 | 9.3986 | 9.4 | 28000.0 |
| 2010-05-04 08:07:00 | AAPL | Stock | 9.4 | 9.4018 | 9.3929 | 9.3929 | 46368.0 |
| 2010-05-04 08:08:00 | AAPL | Stock | 9.3929 | 9.3932 | 9.3914 | 9.3929 | 56084.0 |
| 2010-05-04 08:09:00 | AAPL | Stock | 9.3936 | 9.3936 | 9.3929 | 9.3932 | 36400.0 |
| 2010-05-04 08:10:00 | AAPL | Stock | 9.3932 | 9.4 | 9.3932 | 9.4 | 58324.0 |
| 2010-05-04 08:11:00 | AAPL | Stock | 9.3964 | 9.4 | 9.3964 | 9.4 | 14000.0 |
| 2010-05-04 08:12:00 | AAPL | Stock | 9.4014 | 9.4032 | 9.4014 | 9.4018 | 19600.0 |
| 2010-05-04 08:13:00 | AAPL | Stock | 9.4032 | 9.4043 | 9.4 | 9.4 | 14000.0 |
| 2010-05-04 08:14:00 | AAPL | Stock | 9.3968 | 9.4 | 9.3968 | 9.4 | 5600.0 |
> showing 50 of 1,076,117 rows — these rows as CSV