PREVIEW / stock_1min / 2012-03-22
file: by_date/stock_1min/2012/2012-03-22.parquet size: 12.7 MB rows: 950,230 symbols: 2,824
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-03-22 04:02:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5714 | 21.5714 | 2800.0 |
| 2012-03-22 04:03:00 | AAPL | Stock | 21.5536 | 21.5536 | 21.5536 | 21.5536 | 8400.0 |
| 2012-03-22 04:05:00 | AAPL | Stock | 21.5536 | 21.5536 | 21.5357 | 21.5357 | 26600.0 |
| 2012-03-22 04:16:00 | AAPL | Stock | 21.5411 | 21.5411 | 21.5411 | 21.5411 | 5600.0 |
| 2012-03-22 04:19:00 | AAPL | Stock | 21.5407 | 21.5407 | 21.5407 | 21.5407 | 8400.0 |
| 2012-03-22 04:28:00 | AAPL | Stock | 21.5661 | 21.5718 | 21.5661 | 21.5661 | 65800.0 |
| 2012-03-22 04:32:00 | AAPL | Stock | 21.5214 | 21.5304 | 21.5214 | 21.5214 | 29540.0 |
| 2012-03-22 04:33:00 | AAPL | Stock | 21.5179 | 21.5179 | 21.5121 | 21.5121 | 17920.0 |
| 2012-03-22 04:38:00 | AAPL | Stock | 21.5054 | 21.5054 | 21.5054 | 21.5054 | 2800.0 |
| 2012-03-22 04:40:00 | AAPL | Stock | 21.5054 | 21.5071 | 21.4579 | 21.4579 | 22400.0 |
| 2012-03-22 04:54:00 | AAPL | Stock | 21.4929 | 21.4929 | 21.4929 | 21.4929 | 7700.0 |
| 2012-03-22 04:55:00 | AAPL | Stock | 21.4929 | 21.4929 | 21.4929 | 21.4929 | 5600.0 |
| 2012-03-22 05:01:00 | AAPL | Stock | 21.4986 | 21.5 | 21.4929 | 21.4929 | 22400.0 |
| 2012-03-22 05:02:00 | AAPL | Stock | 21.4821 | 21.4821 | 21.4821 | 21.4821 | 9100.0 |
| 2012-03-22 05:03:00 | AAPL | Stock | 21.4821 | 21.4821 | 21.4821 | 21.4821 | 2800.0 |
| 2012-03-22 05:04:00 | AAPL | Stock | 21.4821 | 21.4821 | 21.4821 | 21.4821 | 2800.0 |
| 2012-03-22 05:11:00 | AAPL | Stock | 21.475 | 21.475 | 21.475 | 21.475 | 8400.0 |
| 2012-03-22 05:16:00 | AAPL | Stock | 21.4561 | 21.4561 | 21.45 | 21.45 | 11200.0 |
| 2012-03-22 05:17:00 | AAPL | Stock | 21.45 | 21.45 | 21.45 | 21.45 | 2800.0 |
| 2012-03-22 05:19:00 | AAPL | Stock | 21.4357 | 21.4357 | 21.4286 | 21.4286 | 22540.0 |
| 2012-03-22 05:20:00 | AAPL | Stock | 21.43 | 21.4461 | 21.4286 | 21.4461 | 41860.0 |
| 2012-03-22 05:24:00 | AAPL | Stock | 21.4407 | 21.4407 | 21.4407 | 21.4407 | 4200.0 |
| 2012-03-22 05:25:00 | AAPL | Stock | 21.4446 | 21.4446 | 21.4446 | 21.4446 | 2800.0 |
| 2012-03-22 05:34:00 | AAPL | Stock | 21.4279 | 21.4279 | 21.4279 | 21.4279 | 4200.0 |
| 2012-03-22 05:35:00 | AAPL | Stock | 21.4279 | 21.4279 | 21.4279 | 21.4279 | 9800.0 |
| 2012-03-22 05:37:00 | AAPL | Stock | 21.4064 | 21.4064 | 21.4064 | 21.4064 | 2800.0 |
| 2012-03-22 05:42:00 | AAPL | Stock | 21.4157 | 21.4157 | 21.4139 | 21.4139 | 5600.0 |
| 2012-03-22 05:43:00 | AAPL | Stock | 21.4043 | 21.4043 | 21.3929 | 21.3929 | 9800.0 |
| 2012-03-22 05:44:00 | AAPL | Stock | 21.3936 | 21.3936 | 21.3936 | 21.3936 | 4228.0 |
| 2012-03-22 05:45:00 | AAPL | Stock | 21.3929 | 21.3929 | 21.3929 | 21.3929 | 8400.0 |
| 2012-03-22 05:46:00 | AAPL | Stock | 21.3929 | 21.3929 | 21.3929 | 21.3929 | 2800.0 |
| 2012-03-22 05:51:00 | AAPL | Stock | 21.4071 | 21.4071 | 21.4071 | 21.4071 | 16800.0 |
| 2012-03-22 05:58:00 | AAPL | Stock | 21.4018 | 21.4018 | 21.4018 | 21.4018 | 8400.0 |
| 2012-03-22 05:59:00 | AAPL | Stock | 21.3982 | 21.3982 | 21.3929 | 21.3929 | 16744.0 |
| 2012-03-22 06:03:00 | AAPL | Stock | 21.3768 | 21.3768 | 21.3764 | 21.3764 | 11200.0 |
| 2012-03-22 06:04:00 | AAPL | Stock | 21.375 | 21.375 | 21.375 | 21.375 | 22400.0 |
| 2012-03-22 06:05:00 | AAPL | Stock | 21.38 | 21.38 | 21.3796 | 21.3796 | 14000.0 |
| 2012-03-22 06:09:00 | AAPL | Stock | 21.3857 | 21.3857 | 21.3857 | 21.3857 | 11760.0 |
| 2012-03-22 06:11:00 | AAPL | Stock | 21.3893 | 21.3893 | 21.3807 | 21.3807 | 18200.0 |
| 2012-03-22 06:14:00 | AAPL | Stock | 21.3857 | 21.3893 | 21.3857 | 21.3893 | 21000.0 |
| 2012-03-22 06:15:00 | AAPL | Stock | 21.3929 | 21.3929 | 21.3857 | 21.3857 | 21000.0 |
| 2012-03-22 06:18:00 | AAPL | Stock | 21.3807 | 21.3807 | 21.3807 | 21.3807 | 2800.0 |
| 2012-03-22 06:19:00 | AAPL | Stock | 21.3857 | 21.3857 | 21.3857 | 21.3857 | 8400.0 |
| 2012-03-22 06:20:00 | AAPL | Stock | 21.3807 | 21.3807 | 21.3807 | 21.3807 | 5600.0 |
| 2012-03-22 06:21:00 | AAPL | Stock | 21.3821 | 21.3839 | 21.3821 | 21.3839 | 7000.0 |
| 2012-03-22 06:22:00 | AAPL | Stock | 21.3832 | 21.3832 | 21.3832 | 21.3832 | 3920.0 |
| 2012-03-22 06:33:00 | AAPL | Stock | 21.3821 | 21.3821 | 21.3821 | 21.3821 | 13272.0 |
| 2012-03-22 06:36:00 | AAPL | Stock | 21.375 | 21.375 | 21.375 | 21.375 | 4760.0 |
| 2012-03-22 06:40:00 | AAPL | Stock | 21.375 | 21.375 | 21.375 | 21.375 | 13272.0 |
| 2012-03-22 06:43:00 | AAPL | Stock | 21.365 | 21.365 | 21.365 | 21.365 | 13720.0 |
> showing 50 of 950,230 rows — these rows as CSV