PREVIEW / stock_1min / 2007-11-09
file: by_date/stock_1min/2007/2007-11-09.parquet size: 13.0 MB rows: 1,048,373 symbols: 2,607
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-11-09 04:04:00 | AAPL | Stock | 6.4371 | 6.4371 | 6.4371 | 6.4371 | 2800.0 |
| 2007-11-09 04:15:00 | AAPL | Stock | 6.415 | 6.415 | 6.4132 | 6.4146 | 8400.0 |
| 2007-11-09 04:16:00 | AAPL | Stock | 6.4482 | 6.4482 | 6.4461 | 6.4461 | 11200.0 |
| 2007-11-09 04:17:00 | AAPL | Stock | 6.4429 | 6.4429 | 6.4429 | 6.4429 | 11200.0 |
| 2007-11-09 04:20:00 | AAPL | Stock | 6.4418 | 6.4418 | 6.4418 | 6.4418 | 2800.0 |
| 2007-11-09 04:21:00 | AAPL | Stock | 6.4407 | 6.4407 | 6.4393 | 6.4393 | 11200.0 |
| 2007-11-09 04:25:00 | AAPL | Stock | 6.4136 | 6.4136 | 6.4107 | 6.4107 | 27244.0 |
| 2007-11-09 04:26:00 | AAPL | Stock | 6.4118 | 6.4118 | 6.4107 | 6.4107 | 39200.0 |
| 2007-11-09 04:30:00 | AAPL | Stock | 6.4032 | 6.4032 | 6.4032 | 6.4032 | 36400.0 |
| 2007-11-09 04:31:00 | AAPL | Stock | 6.4032 | 6.4032 | 6.4032 | 6.4032 | 8960.0 |
| 2007-11-09 04:33:00 | AAPL | Stock | 6.4057 | 6.4057 | 6.4036 | 6.4036 | 25200.0 |
| 2007-11-09 04:44:00 | AAPL | Stock | 6.4014 | 6.4014 | 6.4 | 6.4 | 47600.0 |
| 2007-11-09 04:46:00 | AAPL | Stock | 6.3996 | 6.3996 | 6.3996 | 6.3996 | 25396.0 |
| 2007-11-09 04:49:00 | AAPL | Stock | 6.4114 | 6.4114 | 6.4114 | 6.4114 | 2800.0 |
| 2007-11-09 05:03:00 | AAPL | Stock | 6.4079 | 6.4079 | 6.4079 | 6.4079 | 2800.0 |
| 2007-11-09 05:04:00 | AAPL | Stock | 6.4 | 6.4011 | 6.4 | 6.4 | 19600.0 |
| 2007-11-09 05:06:00 | AAPL | Stock | 6.3843 | 6.3843 | 6.3843 | 6.3843 | 2800.0 |
| 2007-11-09 05:09:00 | AAPL | Stock | 6.3825 | 6.3825 | 6.3825 | 6.3825 | 5600.0 |
| 2007-11-09 05:13:00 | AAPL | Stock | 6.3971 | 6.3971 | 6.3971 | 6.3971 | 2800.0 |
| 2007-11-09 05:15:00 | AAPL | Stock | 6.3882 | 6.3964 | 6.3882 | 6.3964 | 19600.0 |
| 2007-11-09 05:16:00 | AAPL | Stock | 6.3882 | 6.3882 | 6.3882 | 6.3882 | 2800.0 |
| 2007-11-09 05:17:00 | AAPL | Stock | 6.375 | 6.375 | 6.375 | 6.375 | 5600.0 |
| 2007-11-09 05:23:00 | AAPL | Stock | 6.3839 | 6.3839 | 6.3839 | 6.3839 | 2800.0 |
| 2007-11-09 05:24:00 | AAPL | Stock | 6.375 | 6.375 | 6.375 | 6.375 | 5600.0 |
| 2007-11-09 05:26:00 | AAPL | Stock | 6.365 | 6.365 | 6.365 | 6.365 | 8400.0 |
| 2007-11-09 05:29:00 | AAPL | Stock | 6.3607 | 6.3607 | 6.3607 | 6.3607 | 2800.0 |
| 2007-11-09 05:32:00 | AAPL | Stock | 6.3696 | 6.3696 | 6.3696 | 6.3696 | 2800.0 |
| 2007-11-09 05:43:00 | AAPL | Stock | 6.3604 | 6.3604 | 6.3604 | 6.3604 | 2800.0 |
| 2007-11-09 05:49:00 | AAPL | Stock | 6.345 | 6.345 | 6.3393 | 6.3393 | 44800.0 |
| 2007-11-09 05:54:00 | AAPL | Stock | 6.3293 | 6.3293 | 6.3293 | 6.3293 | 2800.0 |
| 2007-11-09 05:55:00 | AAPL | Stock | 6.3293 | 6.3293 | 6.3293 | 6.3293 | 28000.0 |
| 2007-11-09 05:56:00 | AAPL | Stock | 6.33 | 6.3304 | 6.33 | 6.3304 | 5600.0 |
| 2007-11-09 06:03:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 11228.0 |
| 2007-11-09 06:10:00 | AAPL | Stock | 6.3443 | 6.3482 | 6.3443 | 6.3482 | 28336.0 |
| 2007-11-09 06:11:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.3482 | 6.3482 | 8400.0 |
| 2007-11-09 06:24:00 | AAPL | Stock | 6.3321 | 6.3321 | 6.3243 | 6.3243 | 42000.0 |
| 2007-11-09 06:25:00 | AAPL | Stock | 6.3286 | 6.3286 | 6.3286 | 6.3286 | 14000.0 |
| 2007-11-09 06:28:00 | AAPL | Stock | 6.3486 | 6.3486 | 6.3486 | 6.3486 | 5600.0 |
| 2007-11-09 06:32:00 | AAPL | Stock | 6.3532 | 6.3532 | 6.3532 | 6.3532 | 28000.0 |
| 2007-11-09 06:42:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 14000.0 |
| 2007-11-09 06:51:00 | AAPL | Stock | 6.3304 | 6.3304 | 6.3304 | 6.3304 | 14000.0 |
| 2007-11-09 06:52:00 | AAPL | Stock | 6.3214 | 6.3214 | 6.3071 | 6.3071 | 42000.0 |
| 2007-11-09 06:57:00 | AAPL | Stock | 6.3039 | 6.3039 | 6.3039 | 6.3039 | 5600.0 |
| 2007-11-09 07:00:00 | AAPL | Stock | 6.3125 | 6.3125 | 6.2579 | 6.2579 | 84000.0 |
| 2007-11-09 07:01:00 | AAPL | Stock | 6.2579 | 6.2614 | 6.2575 | 6.2611 | 67200.0 |
| 2007-11-09 07:03:00 | AAPL | Stock | 6.2696 | 6.2696 | 6.2611 | 6.2611 | 61600.0 |
| 2007-11-09 07:09:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 28000.0 |
| 2007-11-09 07:11:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 5600.0 |
| 2007-11-09 07:12:00 | AAPL | Stock | 6.2679 | 6.2679 | 6.2679 | 6.2679 | 8400.0 |
| 2007-11-09 07:13:00 | AAPL | Stock | 6.2889 | 6.3161 | 6.2889 | 6.3161 | 27720.0 |
> showing 50 of 1,048,373 rows — these rows as CSV