PREVIEW / stock_1min / 2008-09-17
file: by_date/stock_1min/2008/2008-09-17.parquet size: 14.7 MB rows: 1,139,034 symbols: 2,741
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-17 06:11:00 | AAPL | Stock | 5.02 | 5.02 | 5.02 | 5.02 | 2800.0 |
| 2008-09-17 06:14:00 | AAPL | Stock | 5.0157 | 5.0157 | 5.0157 | 5.0157 | 5600.0 |
| 2008-09-17 06:31:00 | AAPL | Stock | 5.0132 | 5.0132 | 5.0132 | 5.0132 | 2800.0 |
| 2008-09-17 06:32:00 | AAPL | Stock | 5.0132 | 5.0132 | 5.0132 | 5.0132 | 5600.0 |
| 2008-09-17 07:08:00 | AAPL | Stock | 5.0357 | 5.0357 | 5.0357 | 5.0357 | 2800.0 |
| 2008-09-17 07:17:00 | AAPL | Stock | 5.0057 | 5.0057 | 5.0057 | 5.0057 | 2800.0 |
| 2008-09-17 07:25:00 | AAPL | Stock | 5.0132 | 5.0132 | 4.9957 | 4.9957 | 75600.0 |
| 2008-09-17 07:26:00 | AAPL | Stock | 4.9925 | 4.9943 | 4.9904 | 4.9943 | 19600.0 |
| 2008-09-17 07:27:00 | AAPL | Stock | 4.9964 | 5.0036 | 4.9925 | 5.0036 | 43400.0 |
| 2008-09-17 07:29:00 | AAPL | Stock | 5.0036 | 5.0036 | 5.0036 | 5.0036 | 5600.0 |
| 2008-09-17 07:31:00 | AAPL | Stock | 4.9875 | 4.9875 | 4.9875 | 4.9875 | 2800.0 |
| 2008-09-17 07:32:00 | AAPL | Stock | 4.9996 | 5.0 | 4.9996 | 5.0 | 27748.0 |
| 2008-09-17 07:33:00 | AAPL | Stock | 4.9875 | 4.9875 | 4.9875 | 4.9875 | 2800.0 |
| 2008-09-17 07:39:00 | AAPL | Stock | 5.025 | 5.025 | 5.025 | 5.025 | 2800.0 |
| 2008-09-17 07:54:00 | AAPL | Stock | 5.0107 | 5.0107 | 5.0107 | 5.0107 | 2800.0 |
| 2008-09-17 07:57:00 | AAPL | Stock | 5.0107 | 5.0107 | 5.0107 | 5.0107 | 2800.0 |
| 2008-09-17 08:00:00 | AAPL | Stock | 5.0007 | 5.0161 | 5.0007 | 5.0161 | 34580.0 |
| 2008-09-17 08:01:00 | AAPL | Stock | 5.0125 | 5.0179 | 5.0125 | 5.0179 | 33600.0 |
| 2008-09-17 08:02:00 | AAPL | Stock | 5.0179 | 5.0179 | 5.0179 | 5.0179 | 5600.0 |
| 2008-09-17 08:04:00 | AAPL | Stock | 5.0214 | 5.0239 | 5.0214 | 5.0239 | 5600.0 |
| 2008-09-17 08:05:00 | AAPL | Stock | 5.0239 | 5.0239 | 5.0179 | 5.0179 | 63700.0 |
| 2008-09-17 08:06:00 | AAPL | Stock | 5.0239 | 5.025 | 5.0239 | 5.0239 | 16800.0 |
| 2008-09-17 08:08:00 | AAPL | Stock | 5.0179 | 5.0179 | 5.0179 | 5.0179 | 26600.0 |
| 2008-09-17 08:09:00 | AAPL | Stock | 5.0107 | 5.0107 | 5.0107 | 5.0107 | 2800.0 |
| 2008-09-17 08:10:00 | AAPL | Stock | 5.0171 | 5.0236 | 5.0171 | 5.0236 | 89600.0 |
| 2008-09-17 08:11:00 | AAPL | Stock | 5.0243 | 5.0243 | 5.0243 | 5.0243 | 2800.0 |
| 2008-09-17 08:13:00 | AAPL | Stock | 5.0125 | 5.0125 | 5.0125 | 5.0125 | 5600.0 |
| 2008-09-17 08:15:00 | AAPL | Stock | 5.01 | 5.01 | 5.01 | 5.01 | 14000.0 |
| 2008-09-17 08:16:00 | AAPL | Stock | 5.0107 | 5.0107 | 5.0107 | 5.0107 | 19600.0 |
| 2008-09-17 08:17:00 | AAPL | Stock | 5.0161 | 5.0161 | 5.0107 | 5.0161 | 14000.0 |
| 2008-09-17 08:18:00 | AAPL | Stock | 5.0046 | 5.0046 | 5.0046 | 5.0046 | 2800.0 |
| 2008-09-17 08:19:00 | AAPL | Stock | 5.0036 | 5.0036 | 4.9896 | 4.9896 | 99652.0 |
| 2008-09-17 08:20:00 | AAPL | Stock | 4.9961 | 4.9982 | 4.9961 | 4.9971 | 141960.0 |
| 2008-09-17 08:21:00 | AAPL | Stock | 4.9964 | 5.0 | 4.9929 | 5.0 | 19600.0 |
| 2008-09-17 08:22:00 | AAPL | Stock | 5.0 | 5.0054 | 5.0 | 5.0054 | 116480.0 |
| 2008-09-17 08:23:00 | AAPL | Stock | 5.0068 | 5.0068 | 5.0068 | 5.0068 | 5600.0 |
| 2008-09-17 08:24:00 | AAPL | Stock | 5.0121 | 5.0171 | 5.0121 | 5.0171 | 56000.0 |
| 2008-09-17 08:25:00 | AAPL | Stock | 5.0143 | 5.0143 | 5.0089 | 5.0089 | 125076.0 |
| 2008-09-17 08:26:00 | AAPL | Stock | 5.0025 | 5.0089 | 5.0 | 5.0089 | 76720.0 |
| 2008-09-17 08:27:00 | AAPL | Stock | 5.0071 | 5.0089 | 5.0071 | 5.0071 | 142800.0 |
| 2008-09-17 08:29:00 | AAPL | Stock | 5.0021 | 5.0021 | 5.0014 | 5.0014 | 8400.0 |
| 2008-09-17 08:30:00 | AAPL | Stock | 5.0014 | 5.0125 | 5.0011 | 5.0014 | 104020.0 |
| 2008-09-17 08:32:00 | AAPL | Stock | 5.0107 | 5.0107 | 5.0004 | 5.0018 | 63000.0 |
| 2008-09-17 08:33:00 | AAPL | Stock | 5.0018 | 5.0018 | 4.9893 | 4.9946 | 175868.0 |
| 2008-09-17 08:34:00 | AAPL | Stock | 4.9893 | 4.9893 | 4.9779 | 4.9821 | 99372.0 |
| 2008-09-17 08:35:00 | AAPL | Stock | 4.9725 | 4.9732 | 4.9639 | 4.9732 | 324744.0 |
| 2008-09-17 08:36:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9821 | 4.9821 | 13384.0 |
| 2008-09-17 08:40:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9821 | 4.9821 | 61600.0 |
| 2008-09-17 08:41:00 | AAPL | Stock | 4.9821 | 4.9821 | 4.9821 | 4.9821 | 5600.0 |
| 2008-09-17 08:43:00 | AAPL | Stock | 4.9857 | 4.9857 | 4.9857 | 4.9857 | 5040.0 |
> showing 50 of 1,139,034 rows — these rows as CSV