PREVIEW / stock_1min / 2012-04-09
file: by_date/stock_1min/2012/2012-04-09.parquet size: 12.7 MB rows: 954,166 symbols: 2,851
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-09 04:15:00 | AAPL | Stock | 22.4286 | 22.4286 | 22.4286 | 22.4286 | 4480.0 |
| 2012-04-09 04:58:00 | AAPL | Stock | 22.4357 | 22.4357 | 22.4357 | 22.4357 | 8400.0 |
| 2012-04-09 05:21:00 | AAPL | Stock | 22.5 | 22.5 | 22.5 | 22.5 | 2800.0 |
| 2012-04-09 05:22:00 | AAPL | Stock | 22.5104 | 22.5104 | 22.5104 | 22.5104 | 2800.0 |
| 2012-04-09 05:38:00 | AAPL | Stock | 22.5104 | 22.5104 | 22.5104 | 22.5104 | 4200.0 |
| 2012-04-09 06:10:00 | AAPL | Stock | 22.4714 | 22.4714 | 22.4643 | 22.4643 | 8400.0 |
| 2012-04-09 06:29:00 | AAPL | Stock | 22.4286 | 22.4286 | 22.4286 | 22.4286 | 3640.0 |
| 2012-04-09 06:42:00 | AAPL | Stock | 22.4293 | 22.4293 | 22.4289 | 22.4289 | 8400.0 |
| 2012-04-09 06:43:00 | AAPL | Stock | 22.4143 | 22.4143 | 22.4143 | 22.4143 | 2800.0 |
| 2012-04-09 06:45:00 | AAPL | Stock | 22.4054 | 22.4054 | 22.4054 | 22.4054 | 5460.0 |
| 2012-04-09 06:50:00 | AAPL | Stock | 22.3929 | 22.3929 | 22.3929 | 22.3929 | 2800.0 |
| 2012-04-09 06:51:00 | AAPL | Stock | 22.3929 | 22.4021 | 22.3696 | 22.3696 | 26320.0 |
| 2012-04-09 06:52:00 | AAPL | Stock | 22.3575 | 22.3575 | 22.35 | 22.35 | 58016.0 |
| 2012-04-09 06:53:00 | AAPL | Stock | 22.3293 | 22.3293 | 22.3286 | 22.3286 | 14000.0 |
| 2012-04-09 06:54:00 | AAPL | Stock | 22.3289 | 22.3289 | 22.3214 | 22.3214 | 33880.0 |
| 2012-04-09 06:55:00 | AAPL | Stock | 22.3218 | 22.3218 | 22.3179 | 22.3179 | 33600.0 |
| 2012-04-09 06:56:00 | AAPL | Stock | 22.3179 | 22.3179 | 22.3179 | 22.3179 | 2800.0 |
| 2012-04-09 06:57:00 | AAPL | Stock | 22.3036 | 22.3036 | 22.2839 | 22.2839 | 39200.0 |
| 2012-04-09 06:58:00 | AAPL | Stock | 22.2857 | 22.2857 | 22.2854 | 22.2857 | 24500.0 |
| 2012-04-09 06:59:00 | AAPL | Stock | 22.2857 | 22.2857 | 22.2857 | 22.2857 | 8400.0 |
| 2012-04-09 07:00:00 | AAPL | Stock | 22.2839 | 22.2946 | 22.2696 | 22.2946 | 103908.0 |
| 2012-04-09 07:01:00 | AAPL | Stock | 22.2857 | 22.3214 | 22.2857 | 22.3214 | 87500.0 |
| 2012-04-09 07:02:00 | AAPL | Stock | 22.3196 | 22.32 | 22.3043 | 22.3143 | 25200.0 |
| 2012-04-09 07:03:00 | AAPL | Stock | 22.3211 | 22.3286 | 22.3043 | 22.3286 | 52640.0 |
| 2012-04-09 07:04:00 | AAPL | Stock | 22.3354 | 22.3354 | 22.3218 | 22.3218 | 12600.0 |
| 2012-04-09 07:05:00 | AAPL | Stock | 22.3214 | 22.3214 | 22.3214 | 22.3214 | 6944.0 |
| 2012-04-09 07:06:00 | AAPL | Stock | 22.3096 | 22.3214 | 22.3096 | 22.3214 | 24808.0 |
| 2012-04-09 07:07:00 | AAPL | Stock | 22.33 | 22.3464 | 22.33 | 22.3393 | 57176.0 |
| 2012-04-09 07:08:00 | AAPL | Stock | 22.3393 | 22.3639 | 22.3393 | 22.3571 | 95368.0 |
| 2012-04-09 07:09:00 | AAPL | Stock | 22.3607 | 22.3804 | 22.3604 | 22.375 | 183288.0 |
| 2012-04-09 07:10:00 | AAPL | Stock | 22.375 | 22.375 | 22.3696 | 22.3696 | 8400.0 |
| 2012-04-09 07:11:00 | AAPL | Stock | 22.3696 | 22.3707 | 22.3696 | 22.3696 | 23800.0 |
| 2012-04-09 07:12:00 | AAPL | Stock | 22.3679 | 22.3854 | 22.3679 | 22.3854 | 8232.0 |
| 2012-04-09 07:13:00 | AAPL | Stock | 22.3821 | 22.3821 | 22.3821 | 22.3821 | 2800.0 |
| 2012-04-09 07:14:00 | AAPL | Stock | 22.3875 | 22.3925 | 22.3654 | 22.3664 | 48048.0 |
| 2012-04-09 07:15:00 | AAPL | Stock | 22.3754 | 22.3754 | 22.3754 | 22.3754 | 2800.0 |
| 2012-04-09 07:16:00 | AAPL | Stock | 22.375 | 22.3825 | 22.375 | 22.3825 | 15120.0 |
| 2012-04-09 07:17:00 | AAPL | Stock | 22.3804 | 22.3804 | 22.3661 | 22.3661 | 16436.0 |
| 2012-04-09 07:18:00 | AAPL | Stock | 22.3643 | 22.3643 | 22.3643 | 22.3643 | 28000.0 |
| 2012-04-09 07:19:00 | AAPL | Stock | 22.3804 | 22.3925 | 22.3761 | 22.3764 | 22736.0 |
| 2012-04-09 07:21:00 | AAPL | Stock | 22.3818 | 22.3893 | 22.3818 | 22.3893 | 5600.0 |
| 2012-04-09 07:22:00 | AAPL | Stock | 22.3886 | 22.3929 | 22.3886 | 22.3929 | 34888.0 |
| 2012-04-09 07:23:00 | AAPL | Stock | 22.3929 | 22.3982 | 22.3893 | 22.3929 | 72800.0 |
| 2012-04-09 07:24:00 | AAPL | Stock | 22.3846 | 22.3846 | 22.3846 | 22.3846 | 2800.0 |
| 2012-04-09 07:25:00 | AAPL | Stock | 22.38 | 22.38 | 22.3607 | 22.3607 | 71400.0 |
| 2012-04-09 07:26:00 | AAPL | Stock | 22.38 | 22.3821 | 22.38 | 22.3821 | 30800.0 |
| 2012-04-09 07:27:00 | AAPL | Stock | 22.3875 | 22.3893 | 22.3875 | 22.3893 | 5600.0 |
| 2012-04-09 07:28:00 | AAPL | Stock | 22.3893 | 22.3893 | 22.3893 | 22.3893 | 2828.0 |
| 2012-04-09 07:29:00 | AAPL | Stock | 22.3893 | 22.3893 | 22.3893 | 22.3893 | 2800.0 |
| 2012-04-09 07:31:00 | AAPL | Stock | 22.405 | 22.4054 | 22.4 | 22.4054 | 33628.0 |
> showing 50 of 954,166 rows — these rows as CSV