PREVIEW / stock_1min / 2010-08-05
file: by_date/stock_1min/2010/2010-08-05.parquet size: 12.1 MB rows: 924,815 symbols: 2,810
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-08-05 04:04:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 8400.0 |
| 2010-08-05 05:57:00 | AAPL | Stock | 9.4018 | 9.4018 | 9.4018 | 9.4018 | 17500.0 |
| 2010-08-05 07:01:00 | AAPL | Stock | 9.4193 | 9.4193 | 9.4193 | 9.4193 | 8400.0 |
| 2010-08-05 07:06:00 | AAPL | Stock | 9.4196 | 9.4196 | 9.4196 | 9.4196 | 5600.0 |
| 2010-08-05 07:07:00 | AAPL | Stock | 9.4196 | 9.4196 | 9.4196 | 9.4196 | 5600.0 |
| 2010-08-05 07:08:00 | AAPL | Stock | 9.4286 | 9.4286 | 9.4286 | 9.4286 | 2800.0 |
| 2010-08-05 07:14:00 | AAPL | Stock | 9.4282 | 9.4282 | 9.4282 | 9.4282 | 2800.0 |
| 2010-08-05 07:21:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4018 | 9.4018 | 14000.0 |
| 2010-08-05 07:23:00 | AAPL | Stock | 9.41 | 9.41 | 9.4018 | 9.4018 | 5600.0 |
| 2010-08-05 07:24:00 | AAPL | Stock | 9.4018 | 9.4018 | 9.4018 | 9.4018 | 100604.0 |
| 2010-08-05 07:26:00 | AAPL | Stock | 9.3964 | 9.3964 | 9.3964 | 9.3964 | 2800.0 |
| 2010-08-05 07:30:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 5600.0 |
| 2010-08-05 07:33:00 | AAPL | Stock | 9.4 | 9.4 | 9.4 | 9.4 | 2800.0 |
| 2010-08-05 07:42:00 | AAPL | Stock | 9.4246 | 9.4246 | 9.4246 | 9.4246 | 2800.0 |
| 2010-08-05 07:43:00 | AAPL | Stock | 9.4229 | 9.4229 | 9.4229 | 9.4229 | 2800.0 |
| 2010-08-05 07:54:00 | AAPL | Stock | 9.4171 | 9.4171 | 9.4171 | 9.4171 | 2800.0 |
| 2010-08-05 07:56:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 2800.0 |
| 2010-08-05 08:00:00 | AAPL | Stock | 9.3971 | 9.4186 | 9.3971 | 9.4043 | 15400.0 |
| 2010-08-05 08:01:00 | AAPL | Stock | 9.4086 | 9.4086 | 9.4018 | 9.4018 | 13860.0 |
| 2010-08-05 08:03:00 | AAPL | Stock | 9.3996 | 9.3996 | 9.3996 | 9.3996 | 2800.0 |
| 2010-08-05 08:04:00 | AAPL | Stock | 9.4036 | 9.4071 | 9.4036 | 9.4071 | 8400.0 |
| 2010-08-05 08:05:00 | AAPL | Stock | 9.4096 | 9.4096 | 9.4057 | 9.4071 | 42000.0 |
| 2010-08-05 08:06:00 | AAPL | Stock | 9.4075 | 9.4089 | 9.4057 | 9.4057 | 80724.0 |
| 2010-08-05 08:09:00 | AAPL | Stock | 9.4089 | 9.4111 | 9.4039 | 9.4039 | 130312.0 |
| 2010-08-05 08:12:00 | AAPL | Stock | 9.4036 | 9.41 | 9.4018 | 9.41 | 67200.0 |
| 2010-08-05 08:14:00 | AAPL | Stock | 9.4025 | 9.4025 | 9.4025 | 9.4025 | 34524.0 |
| 2010-08-05 08:15:00 | AAPL | Stock | 9.4071 | 9.4071 | 9.4071 | 9.4071 | 5600.0 |
| 2010-08-05 08:16:00 | AAPL | Stock | 9.4068 | 9.4068 | 9.4068 | 9.4068 | 2800.0 |
| 2010-08-05 08:17:00 | AAPL | Stock | 9.4064 | 9.4064 | 9.4036 | 9.4036 | 26600.0 |
| 2010-08-05 08:21:00 | AAPL | Stock | 9.4018 | 9.4018 | 9.3964 | 9.3964 | 189840.0 |
| 2010-08-05 08:22:00 | AAPL | Stock | 9.3964 | 9.3964 | 9.3914 | 9.3925 | 62300.0 |
| 2010-08-05 08:23:00 | AAPL | Stock | 9.3893 | 9.3936 | 9.3893 | 9.3936 | 16800.0 |
| 2010-08-05 08:25:00 | AAPL | Stock | 9.4011 | 9.4011 | 9.4011 | 9.4011 | 27580.0 |
| 2010-08-05 08:26:00 | AAPL | Stock | 9.4011 | 9.4011 | 9.4011 | 9.4011 | 16800.0 |
| 2010-08-05 08:27:00 | AAPL | Stock | 9.4007 | 9.4007 | 9.4007 | 9.4007 | 28000.0 |
| 2010-08-05 08:28:00 | AAPL | Stock | 9.3996 | 9.3996 | 9.3996 | 9.3996 | 2800.0 |
| 2010-08-05 08:30:00 | AAPL | Stock | 9.385 | 9.3929 | 9.3804 | 9.3804 | 348208.0 |
| 2010-08-05 08:31:00 | AAPL | Stock | 9.3804 | 9.3896 | 9.3796 | 9.38 | 117600.0 |
| 2010-08-05 08:32:00 | AAPL | Stock | 9.3796 | 9.3843 | 9.3754 | 9.3821 | 436100.0 |
| 2010-08-05 08:33:00 | AAPL | Stock | 9.3829 | 9.3904 | 9.3793 | 9.3893 | 75600.0 |
| 2010-08-05 08:34:00 | AAPL | Stock | 9.3893 | 9.3921 | 9.385 | 9.385 | 30800.0 |
| 2010-08-05 08:35:00 | AAPL | Stock | 9.3804 | 9.3804 | 9.3757 | 9.3757 | 163296.0 |
| 2010-08-05 08:36:00 | AAPL | Stock | 9.3764 | 9.3804 | 9.3754 | 9.3768 | 131488.0 |
| 2010-08-05 08:37:00 | AAPL | Stock | 9.3786 | 9.3786 | 9.3779 | 9.3779 | 9408.0 |
| 2010-08-05 08:39:00 | AAPL | Stock | 9.3775 | 9.3807 | 9.3768 | 9.3804 | 60368.0 |
| 2010-08-05 08:40:00 | AAPL | Stock | 9.3818 | 9.3868 | 9.3775 | 9.3807 | 82908.0 |
| 2010-08-05 08:41:00 | AAPL | Stock | 9.3814 | 9.3814 | 9.3775 | 9.3814 | 18200.0 |
| 2010-08-05 08:42:00 | AAPL | Stock | 9.3811 | 9.3811 | 9.3811 | 9.3811 | 2800.0 |
| 2010-08-05 08:43:00 | AAPL | Stock | 9.3789 | 9.3789 | 9.3789 | 9.3789 | 13692.0 |
| 2010-08-05 08:44:00 | AAPL | Stock | 9.3793 | 9.3804 | 9.3786 | 9.3786 | 84644.0 |
> showing 50 of 924,815 rows — these rows as CSV