PREVIEW / stock_1min / 2007-08-20
file: by_date/stock_1min/2007/2007-08-20.parquet size: 11.7 MB rows: 950,654 symbols: 2,559
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-20 09:29:00 | AAPL | Stock | 4.4271 | 4.4271 | 4.4271 | 4.4271 | 2800.0 |
| 2007-08-20 09:30:00 | AAPL | Stock | 4.4282 | 4.4286 | 4.405 | 4.4243 | 14768656.0 |
| 2007-08-20 09:31:00 | AAPL | Stock | 4.4218 | 4.4336 | 4.4186 | 4.4275 | 4893952.0 |
| 2007-08-20 09:32:00 | AAPL | Stock | 4.4279 | 4.4464 | 4.425 | 4.4429 | 5318348.0 |
| 2007-08-20 09:33:00 | AAPL | Stock | 4.4429 | 4.4436 | 4.4343 | 4.4343 | 3355296.0 |
| 2007-08-20 09:34:00 | AAPL | Stock | 4.435 | 4.4411 | 4.4293 | 4.4304 | 4277364.0 |
| 2007-08-20 09:35:00 | AAPL | Stock | 4.4311 | 4.439 | 4.4143 | 4.4366 | 3889536.0 |
| 2007-08-20 09:36:00 | AAPL | Stock | 4.4196 | 4.4346 | 4.4054 | 4.4082 | 5719252.0 |
| 2007-08-20 09:37:00 | AAPL | Stock | 4.4079 | 4.4182 | 4.4039 | 4.4096 | 4250512.0 |
| 2007-08-20 09:38:00 | AAPL | Stock | 4.4096 | 4.4171 | 4.4057 | 4.4143 | 3297140.0 |
| 2007-08-20 09:39:00 | AAPL | Stock | 4.4125 | 4.4168 | 4.4071 | 4.4071 | 3281320.0 |
| 2007-08-20 09:40:00 | AAPL | Stock | 4.4079 | 4.4154 | 4.4071 | 4.4118 | 3699108.0 |
| 2007-08-20 09:41:00 | AAPL | Stock | 4.4114 | 4.4136 | 4.4021 | 4.405 | 4825828.0 |
| 2007-08-20 09:42:00 | AAPL | Stock | 4.405 | 4.41 | 4.4018 | 4.4064 | 4854360.0 |
| 2007-08-20 09:43:00 | AAPL | Stock | 4.4064 | 4.4146 | 4.4061 | 4.4125 | 3135804.0 |
| 2007-08-20 09:44:00 | AAPL | Stock | 4.4125 | 4.4286 | 4.4111 | 4.4146 | 2842336.0 |
| 2007-08-20 09:45:00 | AAPL | Stock | 4.4146 | 4.4286 | 4.4036 | 4.4104 | 3497144.0 |
| 2007-08-20 09:46:00 | AAPL | Stock | 4.4104 | 4.4137 | 4.4086 | 4.41 | 3189452.0 |
| 2007-08-20 09:47:00 | AAPL | Stock | 4.41 | 4.4125 | 4.4039 | 4.4054 | 3416224.0 |
| 2007-08-20 09:48:00 | AAPL | Stock | 4.4054 | 4.4089 | 4.4036 | 4.4079 | 3292072.0 |
| 2007-08-20 09:49:00 | AAPL | Stock | 4.4064 | 4.4096 | 4.3968 | 4.3971 | 5294632.0 |
| 2007-08-20 09:50:00 | AAPL | Stock | 4.3971 | 4.4032 | 4.3961 | 4.3979 | 5300512.0 |
| 2007-08-20 09:51:00 | AAPL | Stock | 4.3986 | 4.4046 | 4.3968 | 4.3996 | 3555412.0 |
| 2007-08-20 09:52:00 | AAPL | Stock | 4.4004 | 4.4018 | 4.3982 | 4.4007 | 3204936.0 |
| 2007-08-20 09:53:00 | AAPL | Stock | 4.4004 | 4.4036 | 4.3986 | 4.3993 | 2356956.0 |
| 2007-08-20 09:54:00 | AAPL | Stock | 4.3996 | 4.4036 | 4.3893 | 4.3921 | 4406500.0 |
| 2007-08-20 09:55:00 | AAPL | Stock | 4.3911 | 4.3925 | 4.3836 | 4.3868 | 4626748.0 |
| 2007-08-20 09:56:00 | AAPL | Stock | 4.3868 | 4.4107 | 4.3839 | 4.3929 | 3257436.0 |
| 2007-08-20 09:57:00 | AAPL | Stock | 4.3918 | 4.3957 | 4.385 | 4.3914 | 4015956.0 |
| 2007-08-20 09:58:00 | AAPL | Stock | 4.3914 | 4.3989 | 4.3907 | 4.3979 | 3235064.0 |
| 2007-08-20 09:59:00 | AAPL | Stock | 4.3979 | 4.4018 | 4.3957 | 4.3978 | 2342956.0 |
| 2007-08-20 10:00:00 | AAPL | Stock | 4.3979 | 4.41 | 4.3971 | 4.4096 | 3596264.0 |
| 2007-08-20 10:01:00 | AAPL | Stock | 4.4082 | 4.4107 | 4.4018 | 4.4046 | 3144680.0 |
| 2007-08-20 10:02:00 | AAPL | Stock | 4.405 | 4.4068 | 4.3979 | 4.4011 | 2657564.0 |
| 2007-08-20 10:03:00 | AAPL | Stock | 4.4007 | 4.4054 | 4.3993 | 4.4036 | 1849288.0 |
| 2007-08-20 10:04:00 | AAPL | Stock | 4.4036 | 4.4054 | 4.4014 | 4.405 | 1632428.0 |
| 2007-08-20 10:05:00 | AAPL | Stock | 4.405 | 4.4143 | 4.4046 | 4.4121 | 2643088.0 |
| 2007-08-20 10:06:00 | AAPL | Stock | 4.4121 | 4.4136 | 4.4075 | 4.4111 | 2880332.0 |
| 2007-08-20 10:07:00 | AAPL | Stock | 4.4114 | 4.4143 | 4.4075 | 4.4104 | 2361912.0 |
| 2007-08-20 10:08:00 | AAPL | Stock | 4.4111 | 4.4161 | 4.4107 | 4.4132 | 1786904.0 |
| 2007-08-20 10:09:00 | AAPL | Stock | 4.4136 | 4.4139 | 4.4086 | 4.4104 | 3102148.0 |
| 2007-08-20 10:10:00 | AAPL | Stock | 4.41 | 4.4118 | 4.4004 | 4.4114 | 2125228.0 |
| 2007-08-20 10:11:00 | AAPL | Stock | 4.4114 | 4.4154 | 4.4071 | 4.4071 | 2833068.0 |
| 2007-08-20 10:12:00 | AAPL | Stock | 4.4075 | 4.4136 | 4.4068 | 4.41 | 1996988.0 |
| 2007-08-20 10:13:00 | AAPL | Stock | 4.41 | 4.4104 | 4.4004 | 4.4009 | 1869784.0 |
| 2007-08-20 10:14:00 | AAPL | Stock | 4.4014 | 4.4107 | 4.4011 | 4.4032 | 1505560.0 |
| 2007-08-20 10:15:00 | AAPL | Stock | 4.4032 | 4.4086 | 4.3986 | 4.4064 | 1937012.0 |
| 2007-08-20 10:16:00 | AAPL | Stock | 4.4064 | 4.4093 | 4.4036 | 4.4068 | 1236704.0 |
| 2007-08-20 10:17:00 | AAPL | Stock | 4.4055 | 4.4079 | 4.4007 | 4.4039 | 1391880.0 |
| 2007-08-20 10:18:00 | AAPL | Stock | 4.4041 | 4.4093 | 4.4039 | 4.4075 | 1194284.0 |
> showing 50 of 950,654 rows — these rows as CSV