PREVIEW / stock_1min / 2010-03-16
file: by_date/stock_1min/2010/2010-03-16.parquet size: 12.6 MB rows: 950,852 symbols: 2,829
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-16 04:26:00 | AAPL | Stock | 7.98 | 7.98 | 7.98 | 7.98 | 3416.0 |
| 2010-03-16 05:47:00 | AAPL | Stock | 7.99 | 7.99 | 7.99 | 7.99 | 15120.0 |
| 2010-03-16 06:56:00 | AAPL | Stock | 8.0279 | 8.0279 | 8.0279 | 8.0279 | 11228.0 |
| 2010-03-16 06:57:00 | AAPL | Stock | 8.0304 | 8.0304 | 8.0304 | 8.0304 | 14000.0 |
| 2010-03-16 06:58:00 | AAPL | Stock | 8.0304 | 8.0304 | 8.0304 | 8.0304 | 16800.0 |
| 2010-03-16 06:59:00 | AAPL | Stock | 8.0304 | 8.0304 | 8.0304 | 8.0304 | 12936.0 |
| 2010-03-16 07:00:00 | AAPL | Stock | 8.03 | 8.03 | 8.03 | 8.03 | 4760.0 |
| 2010-03-16 07:05:00 | AAPL | Stock | 8.0282 | 8.0282 | 8.0282 | 8.0282 | 28000.0 |
| 2010-03-16 07:20:00 | AAPL | Stock | 8.0268 | 8.0268 | 8.0268 | 8.0268 | 14000.0 |
| 2010-03-16 07:22:00 | AAPL | Stock | 8.0311 | 8.0314 | 8.0311 | 8.0314 | 25788.0 |
| 2010-03-16 07:23:00 | AAPL | Stock | 8.0286 | 8.0321 | 8.0286 | 8.0321 | 56000.0 |
| 2010-03-16 07:44:00 | AAPL | Stock | 8.0336 | 8.0336 | 8.0336 | 8.0336 | 8400.0 |
| 2010-03-16 07:45:00 | AAPL | Stock | 8.0336 | 8.0336 | 8.0336 | 8.0336 | 28000.0 |
| 2010-03-16 07:47:00 | AAPL | Stock | 8.0314 | 8.0314 | 8.0314 | 8.0314 | 2800.0 |
| 2010-03-16 07:48:00 | AAPL | Stock | 8.0314 | 8.0314 | 8.0314 | 8.0314 | 2800.0 |
| 2010-03-16 07:51:00 | AAPL | Stock | 8.0332 | 8.0354 | 8.0332 | 8.0354 | 33600.0 |
| 2010-03-16 07:59:00 | AAPL | Stock | 8.0389 | 8.0389 | 8.0389 | 8.0389 | 5600.0 |
| 2010-03-16 08:00:00 | AAPL | Stock | 8.0325 | 8.0357 | 8.0282 | 8.0282 | 273896.0 |
| 2010-03-16 08:01:00 | AAPL | Stock | 8.0214 | 8.025 | 8.0214 | 8.025 | 26740.0 |
| 2010-03-16 08:02:00 | AAPL | Stock | 8.0268 | 8.0268 | 8.0196 | 8.0214 | 19628.0 |
| 2010-03-16 08:03:00 | AAPL | Stock | 8.0196 | 8.0196 | 8.0196 | 8.0196 | 8400.0 |
| 2010-03-16 08:04:00 | AAPL | Stock | 8.02 | 8.02 | 8.0179 | 8.0179 | 128800.0 |
| 2010-03-16 08:05:00 | AAPL | Stock | 8.0089 | 8.0089 | 8.0021 | 8.0079 | 27888.0 |
| 2010-03-16 08:06:00 | AAPL | Stock | 8.0168 | 8.0171 | 8.0168 | 8.0171 | 11480.0 |
| 2010-03-16 08:07:00 | AAPL | Stock | 8.015 | 8.0171 | 8.0139 | 8.0171 | 30492.0 |
| 2010-03-16 08:08:00 | AAPL | Stock | 8.0143 | 8.0143 | 8.0143 | 8.0143 | 14000.0 |
| 2010-03-16 08:09:00 | AAPL | Stock | 8.0143 | 8.0143 | 8.0121 | 8.0125 | 10360.0 |
| 2010-03-16 08:10:00 | AAPL | Stock | 8.0139 | 8.0143 | 8.0107 | 8.0107 | 61068.0 |
| 2010-03-16 08:11:00 | AAPL | Stock | 8.0107 | 8.0107 | 8.0096 | 8.0096 | 22400.0 |
| 2010-03-16 08:12:00 | AAPL | Stock | 8.0089 | 8.0089 | 8.0021 | 8.0021 | 54320.0 |
| 2010-03-16 08:13:00 | AAPL | Stock | 8.0071 | 8.0086 | 8.0071 | 8.0086 | 9800.0 |
| 2010-03-16 08:14:00 | AAPL | Stock | 8.0089 | 8.0089 | 7.9979 | 7.9979 | 123760.0 |
| 2010-03-16 08:15:00 | AAPL | Stock | 7.9979 | 7.9979 | 7.9964 | 7.9964 | 15344.0 |
| 2010-03-16 08:16:00 | AAPL | Stock | 7.9979 | 8.0 | 7.9979 | 8.0 | 28000.0 |
| 2010-03-16 08:17:00 | AAPL | Stock | 8.0 | 8.007 | 8.0 | 8.007 | 36540.0 |
| 2010-03-16 08:18:00 | AAPL | Stock | 8.0036 | 8.0036 | 8.0029 | 8.0029 | 7280.0 |
| 2010-03-16 08:19:00 | AAPL | Stock | 8.0 | 8.0036 | 8.0 | 8.0 | 63840.0 |
| 2010-03-16 08:20:00 | AAPL | Stock | 8.0 | 8.0 | 7.9982 | 7.9996 | 147000.0 |
| 2010-03-16 08:21:00 | AAPL | Stock | 7.9979 | 7.9979 | 7.9964 | 7.9964 | 16800.0 |
| 2010-03-16 08:22:00 | AAPL | Stock | 7.9964 | 7.9964 | 7.9936 | 7.9936 | 36120.0 |
| 2010-03-16 08:23:00 | AAPL | Stock | 7.9939 | 7.9964 | 7.9932 | 7.9954 | 42280.0 |
| 2010-03-16 08:24:00 | AAPL | Stock | 7.995 | 7.995 | 7.995 | 7.995 | 8400.0 |
| 2010-03-16 08:25:00 | AAPL | Stock | 7.9989 | 7.9989 | 7.9911 | 7.9914 | 43820.0 |
| 2010-03-16 08:26:00 | AAPL | Stock | 7.9914 | 7.9914 | 7.9861 | 7.9861 | 42000.0 |
| 2010-03-16 08:28:00 | AAPL | Stock | 7.9864 | 7.9891 | 7.9864 | 7.9889 | 14000.0 |
| 2010-03-16 08:29:00 | AAPL | Stock | 7.9889 | 7.9936 | 7.9889 | 7.9936 | 16100.0 |
| 2010-03-16 08:30:00 | AAPL | Stock | 7.9914 | 8.0 | 7.9914 | 8.0 | 51800.0 |
| 2010-03-16 08:31:00 | AAPL | Stock | 8.0 | 8.0061 | 7.9964 | 7.9964 | 77840.0 |
| 2010-03-16 08:32:00 | AAPL | Stock | 7.9996 | 7.9996 | 7.9896 | 7.9964 | 52080.0 |
| 2010-03-16 08:33:00 | AAPL | Stock | 7.9932 | 7.9932 | 7.9896 | 7.9929 | 17640.0 |
> showing 50 of 950,852 rows — these rows as CSV