PREVIEW / stock_1min / 2010-01-04
file: by_date/stock_1min/2010/2010-01-04.parquet size: 12.9 MB rows: 976,144 symbols: 2,804
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-01-04 04:15:00 | AAPL | Stock | 7.5707 | 7.5707 | 7.5707 | 7.5707 | 2800.0 |
| 2010-01-04 04:37:00 | AAPL | Stock | 7.5886 | 7.5886 | 7.5886 | 7.5886 | 2800.0 |
| 2010-01-04 04:46:00 | AAPL | Stock | 7.5886 | 7.5886 | 7.5886 | 7.5886 | 2800.0 |
| 2010-01-04 05:06:00 | AAPL | Stock | 7.595 | 7.595 | 7.595 | 7.595 | 2800.0 |
| 2010-01-04 05:12:00 | AAPL | Stock | 7.5954 | 7.5954 | 7.5954 | 7.5954 | 2800.0 |
| 2010-01-04 05:16:00 | AAPL | Stock | 7.6 | 7.6 | 7.6 | 7.6 | 2800.0 |
| 2010-01-04 05:46:00 | AAPL | Stock | 7.5921 | 7.5921 | 7.5921 | 7.5921 | 2800.0 |
| 2010-01-04 06:01:00 | AAPL | Stock | 7.5964 | 7.5964 | 7.5964 | 7.5964 | 2800.0 |
| 2010-01-04 07:00:00 | AAPL | Stock | 7.5818 | 7.5818 | 7.5818 | 7.5818 | 2800.0 |
| 2010-01-04 07:02:00 | AAPL | Stock | 7.6029 | 7.6068 | 7.6029 | 7.6068 | 22652.0 |
| 2010-01-04 07:06:00 | AAPL | Stock | 7.6064 | 7.6068 | 7.6064 | 7.6068 | 11200.0 |
| 2010-01-04 07:07:00 | AAPL | Stock | 7.6071 | 7.6071 | 7.6071 | 7.6071 | 13440.0 |
| 2010-01-04 07:09:00 | AAPL | Stock | 7.6204 | 7.6204 | 7.6071 | 7.6071 | 16800.0 |
| 2010-01-04 07:17:00 | AAPL | Stock | 7.6071 | 7.6071 | 7.6071 | 7.6071 | 7168.0 |
| 2010-01-04 07:26:00 | AAPL | Stock | 7.6 | 7.6 | 7.6 | 7.6 | 28000.0 |
| 2010-01-04 07:27:00 | AAPL | Stock | 7.5946 | 7.6014 | 7.5936 | 7.6014 | 81200.0 |
| 2010-01-04 07:31:00 | AAPL | Stock | 7.595 | 7.595 | 7.595 | 7.595 | 5600.0 |
| 2010-01-04 07:32:00 | AAPL | Stock | 7.595 | 7.6021 | 7.595 | 7.6021 | 35000.0 |
| 2010-01-04 07:33:00 | AAPL | Stock | 7.6 | 7.6 | 7.6 | 7.6 | 25200.0 |
| 2010-01-04 07:34:00 | AAPL | Stock | 7.6 | 7.6 | 7.6 | 7.6 | 28000.0 |
| 2010-01-04 07:35:00 | AAPL | Stock | 7.6036 | 7.6036 | 7.6036 | 7.6036 | 8064.0 |
| 2010-01-04 07:36:00 | AAPL | Stock | 7.605 | 7.605 | 7.605 | 7.605 | 5600.0 |
| 2010-01-04 07:39:00 | AAPL | Stock | 7.6 | 7.6 | 7.6 | 7.6 | 25676.0 |
| 2010-01-04 07:42:00 | AAPL | Stock | 7.6004 | 7.6018 | 7.6004 | 7.6018 | 22400.0 |
| 2010-01-04 07:43:00 | AAPL | Stock | 7.6004 | 7.6004 | 7.6004 | 7.6004 | 5600.0 |
| 2010-01-04 07:46:00 | AAPL | Stock | 7.6018 | 7.6018 | 7.6018 | 7.6018 | 8400.0 |
| 2010-01-04 07:49:00 | AAPL | Stock | 7.6036 | 7.6036 | 7.6032 | 7.6036 | 40320.0 |
| 2010-01-04 07:50:00 | AAPL | Stock | 7.6036 | 7.6036 | 7.6036 | 7.6036 | 28000.0 |
| 2010-01-04 07:51:00 | AAPL | Stock | 7.6036 | 7.6036 | 7.6036 | 7.6036 | 2800.0 |
| 2010-01-04 07:52:00 | AAPL | Stock | 7.6036 | 7.6036 | 7.6036 | 7.6036 | 5600.0 |
| 2010-01-04 07:53:00 | AAPL | Stock | 7.605 | 7.6054 | 7.605 | 7.6054 | 18200.0 |
| 2010-01-04 07:54:00 | AAPL | Stock | 7.6054 | 7.6068 | 7.6054 | 7.6061 | 47600.0 |
| 2010-01-04 07:55:00 | AAPL | Stock | 7.6057 | 7.6071 | 7.6054 | 7.6071 | 59192.0 |
| 2010-01-04 07:57:00 | AAPL | Stock | 7.6071 | 7.6071 | 7.6071 | 7.6071 | 8400.0 |
| 2010-01-04 08:00:00 | AAPL | Stock | 7.6054 | 7.6104 | 7.5307 | 7.6025 | 1368556.0 |
| 2010-01-04 08:01:00 | AAPL | Stock | 7.6036 | 7.6071 | 7.6018 | 7.6054 | 207648.0 |
| 2010-01-04 08:02:00 | AAPL | Stock | 7.6043 | 7.6061 | 7.6025 | 7.6057 | 53368.0 |
| 2010-01-04 08:03:00 | AAPL | Stock | 7.6025 | 7.6029 | 7.6 | 7.6029 | 109984.0 |
| 2010-01-04 08:04:00 | AAPL | Stock | 7.6036 | 7.6036 | 7.6 | 7.6021 | 31696.0 |
| 2010-01-04 08:05:00 | AAPL | Stock | 7.6018 | 7.6036 | 7.6 | 7.6 | 65604.0 |
| 2010-01-04 08:06:00 | AAPL | Stock | 7.6018 | 7.6018 | 7.5964 | 7.5964 | 77392.0 |
| 2010-01-04 08:07:00 | AAPL | Stock | 7.5964 | 7.6071 | 7.5964 | 7.6021 | 217056.0 |
| 2010-01-04 08:08:00 | AAPL | Stock | 7.6018 | 7.6036 | 7.6018 | 7.6029 | 152600.0 |
| 2010-01-04 08:09:00 | AAPL | Stock | 7.6018 | 7.6018 | 7.6018 | 7.6018 | 4200.0 |
| 2010-01-04 08:10:00 | AAPL | Stock | 7.6018 | 7.6025 | 7.6018 | 7.6025 | 39200.0 |
| 2010-01-04 08:11:00 | AAPL | Stock | 7.6029 | 7.6032 | 7.6018 | 7.6032 | 72408.0 |
| 2010-01-04 08:12:00 | AAPL | Stock | 7.6018 | 7.6029 | 7.5982 | 7.6 | 41720.0 |
| 2010-01-04 08:13:00 | AAPL | Stock | 7.6029 | 7.6029 | 7.6 | 7.6 | 7000.0 |
| 2010-01-04 08:14:00 | AAPL | Stock | 7.6018 | 7.6018 | 7.5982 | 7.5982 | 33600.0 |
| 2010-01-04 08:15:00 | AAPL | Stock | 7.5986 | 7.5996 | 7.5961 | 7.5961 | 46200.0 |
> showing 50 of 976,144 rows — these rows as CSV