PREVIEW / stock_1min / 2007-08-15
file: by_date/stock_1min/2007/2007-08-15.parquet size: 12.3 MB rows: 993,103 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-15 09:30:00 | AAPL | Stock | 4.3836 | 4.4054 | 4.3807 | 4.3889 | 5257084.0 |
| 2007-08-15 09:31:00 | AAPL | Stock | 4.3889 | 4.4025 | 4.3886 | 4.3993 | 3535868.0 |
| 2007-08-15 09:32:00 | AAPL | Stock | 4.3993 | 4.4 | 4.365 | 4.365 | 5691672.0 |
| 2007-08-15 09:33:00 | AAPL | Stock | 4.365 | 4.4007 | 4.3493 | 4.3646 | 11379088.0 |
| 2007-08-15 09:34:00 | AAPL | Stock | 4.3639 | 4.3889 | 4.3518 | 4.3754 | 6074572.0 |
| 2007-08-15 09:35:00 | AAPL | Stock | 4.3754 | 4.3854 | 4.3515 | 4.3854 | 3338384.0 |
| 2007-08-15 09:36:00 | AAPL | Stock | 4.3854 | 4.3989 | 4.3827 | 4.3964 | 6008128.0 |
| 2007-08-15 09:37:00 | AAPL | Stock | 4.3964 | 4.4018 | 4.3886 | 4.3939 | 5551532.0 |
| 2007-08-15 09:38:00 | AAPL | Stock | 4.3939 | 4.3939 | 4.3864 | 4.39 | 3171252.0 |
| 2007-08-15 09:39:00 | AAPL | Stock | 4.39 | 4.4 | 4.3879 | 4.3879 | 5319860.0 |
| 2007-08-15 09:40:00 | AAPL | Stock | 4.3886 | 4.39 | 4.3804 | 4.3854 | 3431540.0 |
| 2007-08-15 09:41:00 | AAPL | Stock | 4.3864 | 4.3864 | 4.3571 | 4.3707 | 8070636.0 |
| 2007-08-15 09:42:00 | AAPL | Stock | 4.3705 | 4.3904 | 4.3705 | 4.3843 | 5447260.0 |
| 2007-08-15 09:43:00 | AAPL | Stock | 4.3836 | 4.3889 | 4.375 | 4.3771 | 3723608.0 |
| 2007-08-15 09:44:00 | AAPL | Stock | 4.3771 | 4.3811 | 4.3714 | 4.3807 | 4241076.0 |
| 2007-08-15 09:45:00 | AAPL | Stock | 4.3807 | 4.3911 | 4.38 | 4.3911 | 4982824.0 |
| 2007-08-15 09:46:00 | AAPL | Stock | 4.3907 | 4.3964 | 4.3821 | 4.3854 | 5050416.0 |
| 2007-08-15 09:47:00 | AAPL | Stock | 4.3854 | 4.3943 | 4.3825 | 4.3943 | 4449340.0 |
| 2007-08-15 09:48:00 | AAPL | Stock | 4.3943 | 4.4161 | 4.3925 | 4.4136 | 7504476.0 |
| 2007-08-15 09:49:00 | AAPL | Stock | 4.4136 | 4.4179 | 4.3982 | 4.4018 | 4951268.0 |
| 2007-08-15 09:50:00 | AAPL | Stock | 4.4025 | 4.4093 | 4.3907 | 4.3943 | 4065600.0 |
| 2007-08-15 09:51:00 | AAPL | Stock | 4.3939 | 4.4089 | 4.3932 | 4.4068 | 3450188.0 |
| 2007-08-15 09:52:00 | AAPL | Stock | 4.4065 | 4.4196 | 4.4061 | 4.4136 | 4504612.0 |
| 2007-08-15 09:53:00 | AAPL | Stock | 4.4139 | 4.4218 | 4.4089 | 4.4214 | 2416036.0 |
| 2007-08-15 09:54:00 | AAPL | Stock | 4.4214 | 4.4286 | 4.42 | 4.4239 | 2168180.0 |
| 2007-08-15 09:55:00 | AAPL | Stock | 4.425 | 4.4493 | 4.4243 | 4.4464 | 6269480.0 |
| 2007-08-15 09:56:00 | AAPL | Stock | 4.4464 | 4.455 | 4.4393 | 4.4529 | 5911472.0 |
| 2007-08-15 09:57:00 | AAPL | Stock | 4.4529 | 4.4593 | 4.4414 | 4.4593 | 7919576.0 |
| 2007-08-15 09:58:00 | AAPL | Stock | 4.4554 | 4.4554 | 4.4357 | 4.4421 | 4167296.0 |
| 2007-08-15 09:59:00 | AAPL | Stock | 4.4418 | 4.4429 | 4.4314 | 4.4357 | 2973936.0 |
| 2007-08-15 10:00:00 | AAPL | Stock | 4.435 | 4.4426 | 4.435 | 4.4393 | 3382288.0 |
| 2007-08-15 10:01:00 | AAPL | Stock | 4.4396 | 4.4396 | 4.4293 | 4.4293 | 3062416.0 |
| 2007-08-15 10:02:00 | AAPL | Stock | 4.4296 | 4.4314 | 4.4236 | 4.4246 | 3415580.0 |
| 2007-08-15 10:03:00 | AAPL | Stock | 4.4236 | 4.4261 | 4.4118 | 4.4118 | 3663828.0 |
| 2007-08-15 10:04:00 | AAPL | Stock | 4.4118 | 4.4118 | 4.4004 | 4.4079 | 3820460.0 |
| 2007-08-15 10:05:00 | AAPL | Stock | 4.4071 | 4.4232 | 4.405 | 4.4129 | 3959452.0 |
| 2007-08-15 10:06:00 | AAPL | Stock | 4.4136 | 4.4143 | 4.4046 | 4.4132 | 2936948.0 |
| 2007-08-15 10:07:00 | AAPL | Stock | 4.4131 | 4.4286 | 4.4125 | 4.4257 | 3246600.0 |
| 2007-08-15 10:08:00 | AAPL | Stock | 4.4257 | 4.4286 | 4.4216 | 4.4275 | 1820308.0 |
| 2007-08-15 10:09:00 | AAPL | Stock | 4.4275 | 4.4296 | 4.4168 | 4.4232 | 3334828.0 |
| 2007-08-15 10:10:00 | AAPL | Stock | 4.4243 | 4.4246 | 4.4125 | 4.4146 | 2862300.0 |
| 2007-08-15 10:11:00 | AAPL | Stock | 4.4145 | 4.4171 | 4.4061 | 4.4154 | 2375688.0 |
| 2007-08-15 10:12:00 | AAPL | Stock | 4.4161 | 4.4254 | 4.41 | 4.4246 | 2501884.0 |
| 2007-08-15 10:13:00 | AAPL | Stock | 4.4257 | 4.4282 | 4.4196 | 4.4282 | 2045456.0 |
| 2007-08-15 10:14:00 | AAPL | Stock | 4.4282 | 4.4314 | 4.425 | 4.4282 | 1297072.0 |
| 2007-08-15 10:18:00 | AAPL | Stock | 4.4279 | 4.4321 | 4.425 | 4.4321 | 1630468.0 |
| 2007-08-15 10:19:00 | AAPL | Stock | 4.4321 | 4.4321 | 4.4204 | 4.4225 | 2534980.0 |
| 2007-08-15 10:20:00 | AAPL | Stock | 4.4225 | 4.4271 | 4.4089 | 4.4214 | 2813104.0 |
| 2007-08-15 10:21:00 | AAPL | Stock | 4.4204 | 4.4268 | 4.415 | 4.425 | 2181340.0 |
| 2007-08-15 10:22:00 | AAPL | Stock | 4.425 | 4.4275 | 4.4221 | 4.425 | 2041620.0 |
> showing 50 of 993,103 rows — these rows as CSV