PREVIEW / stock_1min / 2011-03-31
file: by_date/stock_1min/2011/2011-03-31.parquet size: 13.1 MB rows: 980,206 symbols: 2,865
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-31 04:00:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 2800.0 |
| 2011-03-31 04:11:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 2800.0 |
| 2011-03-31 04:55:00 | AAPL | Stock | 12.4639 | 12.4639 | 12.4639 | 12.4639 | 2800.0 |
| 2011-03-31 05:02:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 5600.0 |
| 2011-03-31 05:09:00 | AAPL | Stock | 12.4607 | 12.4607 | 12.4607 | 12.4607 | 2800.0 |
| 2011-03-31 05:23:00 | AAPL | Stock | 12.4429 | 12.4429 | 12.4429 | 12.4429 | 2800.0 |
| 2011-03-31 05:56:00 | AAPL | Stock | 12.4607 | 12.4639 | 12.4607 | 12.4639 | 5600.0 |
| 2011-03-31 06:31:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4393 | 12.4393 | 2800.0 |
| 2011-03-31 06:55:00 | AAPL | Stock | 12.4314 | 12.4314 | 12.4314 | 12.4314 | 2800.0 |
| 2011-03-31 07:02:00 | AAPL | Stock | 12.4143 | 12.4143 | 12.4107 | 12.4107 | 27048.0 |
| 2011-03-31 07:03:00 | AAPL | Stock | 12.4104 | 12.4104 | 12.4104 | 12.4104 | 2800.0 |
| 2011-03-31 07:04:00 | AAPL | Stock | 12.4104 | 12.4107 | 12.4104 | 12.4107 | 8400.0 |
| 2011-03-31 07:16:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4107 | 12.4107 | 2800.0 |
| 2011-03-31 07:17:00 | AAPL | Stock | 12.4279 | 12.4279 | 12.4279 | 12.4279 | 2800.0 |
| 2011-03-31 07:19:00 | AAPL | Stock | 12.4275 | 12.4275 | 12.4275 | 12.4275 | 2800.0 |
| 2011-03-31 07:21:00 | AAPL | Stock | 12.4111 | 12.4111 | 12.4089 | 12.4089 | 22400.0 |
| 2011-03-31 07:28:00 | AAPL | Stock | 12.4168 | 12.4168 | 12.4168 | 12.4168 | 5600.0 |
| 2011-03-31 07:33:00 | AAPL | Stock | 12.4143 | 12.4171 | 12.4143 | 12.4171 | 8400.0 |
| 2011-03-31 07:34:00 | AAPL | Stock | 12.4154 | 12.4171 | 12.4143 | 12.4171 | 9268.0 |
| 2011-03-31 07:35:00 | AAPL | Stock | 12.4171 | 12.4171 | 12.4171 | 12.4171 | 2800.0 |
| 2011-03-31 07:37:00 | AAPL | Stock | 12.4071 | 12.4079 | 12.4068 | 12.4079 | 41944.0 |
| 2011-03-31 07:51:00 | AAPL | Stock | 12.4061 | 12.4068 | 12.4032 | 12.4032 | 17584.0 |
| 2011-03-31 07:55:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4107 | 12.4107 | 11200.0 |
| 2011-03-31 07:58:00 | AAPL | Stock | 12.4132 | 12.4132 | 12.4132 | 12.4132 | 5600.0 |
| 2011-03-31 08:00:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4107 | 12.4107 | 30800.0 |
| 2011-03-31 08:01:00 | AAPL | Stock | 12.4104 | 12.4107 | 12.4071 | 12.4107 | 19432.0 |
| 2011-03-31 08:02:00 | AAPL | Stock | 12.4082 | 12.4082 | 12.405 | 12.4071 | 32760.0 |
| 2011-03-31 08:03:00 | AAPL | Stock | 12.4021 | 12.4021 | 12.4021 | 12.4021 | 5600.0 |
| 2011-03-31 08:04:00 | AAPL | Stock | 12.4 | 12.4018 | 12.3968 | 12.3968 | 23100.0 |
| 2011-03-31 08:05:00 | AAPL | Stock | 12.3968 | 12.3968 | 12.3946 | 12.3946 | 30800.0 |
| 2011-03-31 08:06:00 | AAPL | Stock | 12.3939 | 12.3964 | 12.3939 | 12.3964 | 40320.0 |
| 2011-03-31 08:07:00 | AAPL | Stock | 12.3968 | 12.3971 | 12.3968 | 12.3968 | 14000.0 |
| 2011-03-31 08:08:00 | AAPL | Stock | 12.3968 | 12.3968 | 12.3939 | 12.3939 | 39200.0 |
| 2011-03-31 08:09:00 | AAPL | Stock | 12.3946 | 12.3964 | 12.3939 | 12.3939 | 30800.0 |
| 2011-03-31 08:10:00 | AAPL | Stock | 12.3939 | 12.3939 | 12.3843 | 12.3889 | 114576.0 |
| 2011-03-31 08:11:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3918 | 12.3918 | 5600.0 |
| 2011-03-31 08:12:00 | AAPL | Stock | 12.3904 | 12.3929 | 12.3904 | 12.3929 | 27832.0 |
| 2011-03-31 08:13:00 | AAPL | Stock | 12.3929 | 12.3932 | 12.3929 | 12.3932 | 19600.0 |
| 2011-03-31 08:14:00 | AAPL | Stock | 12.3964 | 12.3964 | 12.3964 | 12.3964 | 72240.0 |
| 2011-03-31 08:15:00 | AAPL | Stock | 12.3993 | 12.3993 | 12.3893 | 12.3893 | 42000.0 |
| 2011-03-31 08:16:00 | AAPL | Stock | 12.385 | 12.385 | 12.3746 | 12.3746 | 116676.0 |
| 2011-03-31 08:17:00 | AAPL | Stock | 12.375 | 12.3768 | 12.375 | 12.3768 | 59948.0 |
| 2011-03-31 08:18:00 | AAPL | Stock | 12.3746 | 12.375 | 12.3746 | 12.375 | 35700.0 |
| 2011-03-31 08:19:00 | AAPL | Stock | 12.375 | 12.375 | 12.3632 | 12.3632 | 210700.0 |
| 2011-03-31 08:20:00 | AAPL | Stock | 12.3664 | 12.3664 | 12.3664 | 12.3664 | 8400.0 |
| 2011-03-31 08:21:00 | AAPL | Stock | 12.3743 | 12.375 | 12.3743 | 12.375 | 14000.0 |
| 2011-03-31 08:22:00 | AAPL | Stock | 12.3696 | 12.3746 | 12.3696 | 12.3739 | 14000.0 |
| 2011-03-31 08:23:00 | AAPL | Stock | 12.3696 | 12.375 | 12.3696 | 12.375 | 78736.0 |
| 2011-03-31 08:24:00 | AAPL | Stock | 12.3786 | 12.3786 | 12.3786 | 12.3786 | 2800.0 |
| 2011-03-31 08:25:00 | AAPL | Stock | 12.3857 | 12.3886 | 12.3857 | 12.3886 | 18900.0 |
> showing 50 of 980,206 rows — these rows as CSV