PREVIEW / stock_5min / 2011-01-10
file: by_date/stock_5min/2011/2011-01-10.parquet size: 4.9 MB rows: 331,902 symbols: 3,521
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-10 04:05:00 | AAPL | Stock | 12.0786 | 12.0786 | 12.0786 | 12.0786 | 14000.0 |
| 2011-01-10 04:20:00 | AAPL | Stock | 12.0879 | 12.0889 | 12.0879 | 12.0889 | 5600.0 |
| 2011-01-10 04:55:00 | AAPL | Stock | 12.1093 | 12.1093 | 12.1093 | 12.1093 | 2800.0 |
| 2011-01-10 05:15:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 05:35:00 | AAPL | Stock | 12.1179 | 12.1179 | 12.1179 | 12.1179 | 2800.0 |
| 2011-01-10 05:40:00 | AAPL | Stock | 12.1157 | 12.1157 | 12.1071 | 12.1071 | 14000.0 |
| 2011-01-10 05:45:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 2800.0 |
| 2011-01-10 05:55:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 28000.0 |
| 2011-01-10 06:00:00 | AAPL | Stock | 12.1157 | 12.1157 | 12.1157 | 12.1157 | 2800.0 |
| 2011-01-10 06:05:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1071 | 12.1071 | 11200.0 |
| 2011-01-10 06:10:00 | AAPL | Stock | 12.1157 | 12.1157 | 12.1075 | 12.1157 | 12516.0 |
| 2011-01-10 06:20:00 | AAPL | Stock | 12.12 | 12.1357 | 12.12 | 12.1357 | 14000.0 |
| 2011-01-10 06:30:00 | AAPL | Stock | 12.1268 | 12.1268 | 12.1268 | 12.1268 | 16800.0 |
| 2011-01-10 06:35:00 | AAPL | Stock | 12.125 | 12.125 | 12.1071 | 12.1071 | 16688.0 |
| 2011-01-10 06:40:00 | AAPL | Stock | 12.1268 | 12.1268 | 12.1268 | 12.1268 | 2800.0 |
| 2011-01-10 06:50:00 | AAPL | Stock | 12.1161 | 12.1161 | 12.1161 | 12.1161 | 14000.0 |
| 2011-01-10 06:55:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1046 | 12.1071 | 26600.0 |
| 2011-01-10 07:00:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.1 | 12.1071 | 22400.0 |
| 2011-01-10 07:05:00 | AAPL | Stock | 12.1071 | 12.1071 | 12.0986 | 12.0986 | 8400.0 |
| 2011-01-10 07:10:00 | AAPL | Stock | 12.1 | 12.1071 | 12.1 | 12.1061 | 11200.0 |
| 2011-01-10 07:15:00 | AAPL | Stock | 12.0843 | 12.0939 | 12.0843 | 12.0939 | 50400.0 |
| 2011-01-10 07:20:00 | AAPL | Stock | 12.0893 | 12.1018 | 12.0893 | 12.1018 | 21000.0 |
| 2011-01-10 07:25:00 | AAPL | Stock | 12.0964 | 12.1 | 12.0954 | 12.1 | 26964.0 |
| 2011-01-10 07:30:00 | AAPL | Stock | 12.0961 | 12.0964 | 12.0896 | 12.0896 | 30968.0 |
| 2011-01-10 07:35:00 | AAPL | Stock | 12.0929 | 12.1032 | 12.0929 | 12.0986 | 66808.0 |
| 2011-01-10 07:40:00 | AAPL | Stock | 12.0989 | 12.1018 | 12.0989 | 12.1018 | 11200.0 |
| 2011-01-10 07:45:00 | AAPL | Stock | 12.0964 | 12.0968 | 12.0889 | 12.0889 | 81200.0 |
| 2011-01-10 07:50:00 | AAPL | Stock | 12.0821 | 12.0821 | 12.0536 | 12.0714 | 455644.0 |
| 2011-01-10 07:55:00 | AAPL | Stock | 12.0696 | 12.0714 | 12.0539 | 12.0539 | 64260.0 |
| 2011-01-10 08:00:00 | AAPL | Stock | 12.0618 | 12.0921 | 12.0589 | 12.0721 | 668640.0 |
| 2011-01-10 08:05:00 | AAPL | Stock | 12.0721 | 12.0732 | 12.0625 | 12.0679 | 1023568.0 |
| 2011-01-10 08:10:00 | AAPL | Stock | 12.0679 | 12.0714 | 12.0643 | 12.0679 | 195664.0 |
| 2011-01-10 08:15:00 | AAPL | Stock | 12.0661 | 12.0711 | 12.0643 | 12.0707 | 206164.0 |
| 2011-01-10 08:20:00 | AAPL | Stock | 12.0707 | 12.0707 | 12.0643 | 12.0679 | 160524.0 |
| 2011-01-10 08:25:00 | AAPL | Stock | 12.0679 | 12.0936 | 12.0679 | 12.0936 | 293048.0 |
| 2011-01-10 08:30:00 | AAPL | Stock | 12.0946 | 12.1082 | 12.0929 | 12.1036 | 750428.0 |
| 2011-01-10 08:35:00 | AAPL | Stock | 12.1054 | 12.1071 | 12.1 | 12.1064 | 409696.0 |
| 2011-01-10 08:40:00 | AAPL | Stock | 12.1068 | 12.1114 | 12.1018 | 12.1093 | 426916.0 |
| 2011-01-10 08:45:00 | AAPL | Stock | 12.1086 | 12.1086 | 12.1018 | 12.1039 | 271572.0 |
| 2011-01-10 08:50:00 | AAPL | Stock | 12.1039 | 12.1061 | 12.1 | 12.1004 | 278180.0 |
| 2011-01-10 08:55:00 | AAPL | Stock | 12.1 | 12.1014 | 12.0821 | 12.0893 | 350840.0 |
| 2011-01-10 09:00:00 | AAPL | Stock | 12.0929 | 12.0929 | 12.0857 | 12.0861 | 284760.0 |
| 2011-01-10 09:05:00 | AAPL | Stock | 12.0889 | 12.09 | 12.0804 | 12.0804 | 202020.0 |
| 2011-01-10 09:10:00 | AAPL | Stock | 12.0818 | 12.0886 | 12.0814 | 12.0857 | 120400.0 |
| 2011-01-10 09:15:00 | AAPL | Stock | 12.0839 | 12.0868 | 12.0811 | 12.0839 | 61264.0 |
| 2011-01-10 09:20:00 | AAPL | Stock | 12.0807 | 12.0857 | 12.08 | 12.08 | 73080.0 |
| 2011-01-10 09:25:00 | AAPL | Stock | 12.0793 | 12.0946 | 12.0679 | 12.0946 | 860860.0 |
| 2011-01-10 09:30:00 | AAPL | Stock | 12.0968 | 12.1121 | 12.0561 | 12.0579 | 17293472.0 |
| 2011-01-10 09:35:00 | AAPL | Stock | 12.0593 | 12.0804 | 12.0418 | 12.0739 | 12909120.0 |
| 2011-01-10 09:40:00 | AAPL | Stock | 12.0739 | 12.1393 | 12.0718 | 12.1368 | 15783096.0 |
> showing 50 of 331,902 rows — these rows as CSV