PREVIEW / stock_1min / 2008-04-22
file: by_date/stock_1min/2008/2008-04-22.parquet size: 12.1 MB rows: 978,164 symbols: 2,673
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-04-22 05:02:00 | AAPL | Stock | 5.9857 | 5.9857 | 5.9857 | 5.9857 | 2800.0 |
| 2008-04-22 05:40:00 | AAPL | Stock | 5.9789 | 5.9789 | 5.9789 | 5.9789 | 2800.0 |
| 2008-04-22 05:47:00 | AAPL | Stock | 5.9936 | 5.9936 | 5.9936 | 5.9936 | 2800.0 |
| 2008-04-22 05:52:00 | AAPL | Stock | 6.0129 | 6.0129 | 6.0129 | 6.0129 | 2800.0 |
| 2008-04-22 06:01:00 | AAPL | Stock | 6.0125 | 6.0125 | 6.0125 | 6.0125 | 2800.0 |
| 2008-04-22 06:09:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0179 | 6.0179 | 5600.0 |
| 2008-04-22 06:37:00 | AAPL | Stock | 6.0071 | 6.0071 | 6.0071 | 6.0071 | 26124.0 |
| 2008-04-22 06:49:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 5600.0 |
| 2008-04-22 06:50:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 5600.0 |
| 2008-04-22 06:59:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 27384.0 |
| 2008-04-22 07:00:00 | AAPL | Stock | 5.9993 | 5.9993 | 5.9993 | 5.9993 | 2800.0 |
| 2008-04-22 07:02:00 | AAPL | Stock | 6.0007 | 6.0007 | 6.0007 | 6.0007 | 14000.0 |
| 2008-04-22 07:03:00 | AAPL | Stock | 6.0004 | 6.0004 | 6.0004 | 6.0004 | 3276.0 |
| 2008-04-22 07:04:00 | AAPL | Stock | 6.0004 | 6.0004 | 6.0004 | 6.0004 | 8400.0 |
| 2008-04-22 07:06:00 | AAPL | Stock | 6.0004 | 6.0004 | 6.0004 | 6.0004 | 3584.0 |
| 2008-04-22 07:10:00 | AAPL | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 12600.0 |
| 2008-04-22 07:15:00 | AAPL | Stock | 5.9932 | 5.9932 | 5.9929 | 5.9929 | 10360.0 |
| 2008-04-22 07:17:00 | AAPL | Stock | 5.9929 | 5.9929 | 5.9929 | 5.9929 | 38640.0 |
| 2008-04-22 07:18:00 | AAPL | Stock | 5.9929 | 5.9929 | 5.9929 | 5.9929 | 45360.0 |
| 2008-04-22 07:19:00 | AAPL | Stock | 5.9964 | 5.9964 | 5.9964 | 5.9964 | 14000.0 |
| 2008-04-22 07:20:00 | AAPL | Stock | 5.9918 | 5.9918 | 5.9918 | 5.9918 | 4900.0 |
| 2008-04-22 07:30:00 | AAPL | Stock | 5.9964 | 5.9964 | 5.9964 | 5.9964 | 2800.0 |
| 2008-04-22 07:33:00 | AAPL | Stock | 5.9964 | 5.9964 | 5.9964 | 5.9964 | 11200.0 |
| 2008-04-22 07:34:00 | AAPL | Stock | 5.9964 | 5.9964 | 5.9964 | 5.9964 | 28000.0 |
| 2008-04-22 07:37:00 | AAPL | Stock | 5.9921 | 5.9921 | 5.9918 | 5.9918 | 13440.0 |
| 2008-04-22 07:38:00 | AAPL | Stock | 5.9964 | 5.9964 | 5.9964 | 5.9964 | 14000.0 |
| 2008-04-22 07:39:00 | AAPL | Stock | 5.9964 | 5.9964 | 5.9964 | 5.9964 | 11900.0 |
| 2008-04-22 07:40:00 | AAPL | Stock | 6.0036 | 6.0036 | 6.0036 | 6.0036 | 24360.0 |
| 2008-04-22 07:44:00 | AAPL | Stock | 5.9996 | 5.9996 | 5.9996 | 5.9996 | 14000.0 |
| 2008-04-22 07:50:00 | AAPL | Stock | 5.9996 | 5.9996 | 5.9996 | 5.9996 | 2800.0 |
| 2008-04-22 07:59:00 | AAPL | Stock | 5.9911 | 5.9911 | 5.9893 | 5.9893 | 25200.0 |
| 2008-04-22 08:00:00 | AAPL | Stock | 5.9893 | 5.9979 | 5.9893 | 5.9961 | 88340.0 |
| 2008-04-22 08:01:00 | AAPL | Stock | 5.9925 | 5.9925 | 5.99 | 5.9911 | 75600.0 |
| 2008-04-22 08:02:00 | AAPL | Stock | 5.9911 | 5.9911 | 5.9861 | 5.9879 | 42000.0 |
| 2008-04-22 08:03:00 | AAPL | Stock | 5.9904 | 5.9904 | 5.9886 | 5.9889 | 14000.0 |
| 2008-04-22 08:04:00 | AAPL | Stock | 5.9875 | 5.9886 | 5.9875 | 5.9886 | 11200.0 |
| 2008-04-22 08:05:00 | AAPL | Stock | 5.9889 | 5.9889 | 5.9875 | 5.9875 | 17472.0 |
| 2008-04-22 08:06:00 | AAPL | Stock | 5.9889 | 5.9893 | 5.9889 | 5.9893 | 60536.0 |
| 2008-04-22 08:07:00 | AAPL | Stock | 5.9943 | 5.9957 | 5.9896 | 5.9957 | 60004.0 |
| 2008-04-22 08:08:00 | AAPL | Stock | 5.995 | 5.995 | 5.9946 | 5.9946 | 5600.0 |
| 2008-04-22 08:09:00 | AAPL | Stock | 5.9957 | 5.9979 | 5.9957 | 5.9964 | 32872.0 |
| 2008-04-22 08:10:00 | AAPL | Stock | 5.9979 | 6.0036 | 5.9979 | 6.0 | 117628.0 |
| 2008-04-22 08:11:00 | AAPL | Stock | 6.0057 | 6.01 | 6.0057 | 6.01 | 95200.0 |
| 2008-04-22 08:12:00 | AAPL | Stock | 6.0089 | 6.0089 | 6.0014 | 6.0043 | 180348.0 |
| 2008-04-22 08:13:00 | AAPL | Stock | 6.005 | 6.0057 | 6.0021 | 6.005 | 47600.0 |
| 2008-04-22 08:14:00 | AAPL | Stock | 6.0054 | 6.0089 | 6.0054 | 6.0089 | 53844.0 |
| 2008-04-22 08:15:00 | AAPL | Stock | 6.01 | 6.0129 | 6.0075 | 6.0107 | 109424.0 |
| 2008-04-22 08:16:00 | AAPL | Stock | 6.0125 | 6.0125 | 6.0071 | 6.0096 | 119756.0 |
| 2008-04-22 08:17:00 | AAPL | Stock | 6.0075 | 6.0096 | 6.0071 | 6.0071 | 131880.0 |
| 2008-04-22 08:18:00 | AAPL | Stock | 6.0068 | 6.0068 | 6.005 | 6.0061 | 23800.0 |
> showing 50 of 978,164 rows — these rows as CSV