PREVIEW / stock_5min / 2010-03-12
file: by_date/stock_5min/2010/2010-03-12.parquet size: 4.7 MB rows: 321,314 symbols: 3,458
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-12 04:15:00 | AAPL | Stock | 8.0779 | 8.0779 | 8.0779 | 8.0779 | 2800.0 |
| 2010-03-12 04:50:00 | AAPL | Stock | 8.0964 | 8.0964 | 8.0964 | 8.0964 | 14000.0 |
| 2010-03-12 04:55:00 | AAPL | Stock | 8.1 | 8.1 | 8.1 | 8.1 | 5600.0 |
| 2010-03-12 05:20:00 | AAPL | Stock | 8.1061 | 8.1061 | 8.1036 | 8.1036 | 20188.0 |
| 2010-03-12 05:25:00 | AAPL | Stock | 8.1043 | 8.1043 | 8.1043 | 8.1043 | 2800.0 |
| 2010-03-12 05:50:00 | AAPL | Stock | 8.0971 | 8.0971 | 8.0968 | 8.0968 | 19600.0 |
| 2010-03-12 06:15:00 | AAPL | Stock | 8.1068 | 8.1068 | 8.1068 | 8.1068 | 5600.0 |
| 2010-03-12 06:55:00 | AAPL | Stock | 8.1036 | 8.1036 | 8.1036 | 8.1036 | 5796.0 |
| 2010-03-12 07:00:00 | AAPL | Stock | 8.1025 | 8.1025 | 8.1025 | 8.1025 | 5600.0 |
| 2010-03-12 07:05:00 | AAPL | Stock | 8.1018 | 8.1032 | 8.095 | 8.1032 | 55216.0 |
| 2010-03-12 07:10:00 | AAPL | Stock | 8.1036 | 8.1036 | 8.0982 | 8.0982 | 51576.0 |
| 2010-03-12 07:15:00 | AAPL | Stock | 8.0911 | 8.0911 | 8.0843 | 8.0893 | 105000.0 |
| 2010-03-12 07:25:00 | AAPL | Stock | 8.0889 | 8.0943 | 8.0889 | 8.0943 | 76244.0 |
| 2010-03-12 07:30:00 | AAPL | Stock | 8.0929 | 8.0929 | 8.0889 | 8.0889 | 5600.0 |
| 2010-03-12 07:35:00 | AAPL | Stock | 8.0886 | 8.0893 | 8.0854 | 8.0857 | 39200.0 |
| 2010-03-12 07:40:00 | AAPL | Stock | 8.0893 | 8.0911 | 8.0893 | 8.0907 | 33600.0 |
| 2010-03-12 07:45:00 | AAPL | Stock | 8.0857 | 8.0893 | 8.0857 | 8.0893 | 5600.0 |
| 2010-03-12 07:50:00 | AAPL | Stock | 8.0893 | 8.0907 | 8.0893 | 8.0907 | 42588.0 |
| 2010-03-12 08:00:00 | AAPL | Stock | 8.0857 | 8.0989 | 8.0391 | 8.0964 | 487564.0 |
| 2010-03-12 08:05:00 | AAPL | Stock | 8.0964 | 8.1071 | 8.0946 | 8.1071 | 694568.0 |
| 2010-03-12 08:10:00 | AAPL | Stock | 8.1054 | 8.1086 | 8.0946 | 8.0946 | 785260.0 |
| 2010-03-12 08:15:00 | AAPL | Stock | 8.0946 | 8.1018 | 8.0946 | 8.0975 | 411992.0 |
| 2010-03-12 08:20:00 | AAPL | Stock | 8.0989 | 8.1018 | 8.0966 | 8.0966 | 150864.0 |
| 2010-03-12 08:25:00 | AAPL | Stock | 8.0966 | 8.1036 | 8.0929 | 8.1004 | 275492.0 |
| 2010-03-12 08:30:00 | AAPL | Stock | 8.1004 | 8.1125 | 8.1004 | 8.1125 | 527968.0 |
| 2010-03-12 08:35:00 | AAPL | Stock | 8.1139 | 8.1246 | 8.1139 | 8.1196 | 472444.0 |
| 2010-03-12 08:40:00 | AAPL | Stock | 8.1196 | 8.1229 | 8.1118 | 8.1143 | 537600.0 |
| 2010-03-12 08:45:00 | AAPL | Stock | 8.1143 | 8.1179 | 8.1089 | 8.1161 | 258720.0 |
| 2010-03-12 08:50:00 | AAPL | Stock | 8.1146 | 8.1207 | 8.1143 | 8.1204 | 276780.0 |
| 2010-03-12 08:55:00 | AAPL | Stock | 8.1214 | 8.1268 | 8.1207 | 8.1225 | 557872.0 |
| 2010-03-12 09:00:00 | AAPL | Stock | 8.1232 | 8.1246 | 8.1214 | 8.1214 | 242788.0 |
| 2010-03-12 09:05:00 | AAPL | Stock | 8.1229 | 8.1229 | 8.1179 | 8.1211 | 176988.0 |
| 2010-03-12 09:10:00 | AAPL | Stock | 8.1211 | 8.1211 | 8.1196 | 8.1196 | 216972.0 |
| 2010-03-12 09:15:00 | AAPL | Stock | 8.1196 | 8.1204 | 8.1182 | 8.12 | 118412.0 |
| 2010-03-12 09:20:00 | AAPL | Stock | 8.1182 | 8.1204 | 8.1179 | 8.1189 | 204540.0 |
| 2010-03-12 09:25:00 | AAPL | Stock | 8.1189 | 8.1207 | 8.115 | 8.12 | 430220.0 |
| 2010-03-12 09:30:00 | AAPL | Stock | 8.1196 | 8.1207 | 8.0889 | 8.1025 | 26234572.0 |
| 2010-03-12 09:35:00 | AAPL | Stock | 8.1032 | 8.1125 | 8.0889 | 8.095 | 13374620.0 |
| 2010-03-12 09:40:00 | AAPL | Stock | 8.0954 | 8.0954 | 8.0732 | 8.0751 | 14454216.0 |
| 2010-03-12 09:45:00 | AAPL | Stock | 8.075 | 8.1132 | 8.0718 | 8.1061 | 14132104.0 |
| 2010-03-12 09:50:00 | AAPL | Stock | 8.1061 | 8.1332 | 8.0986 | 8.1179 | 18913132.0 |
| 2010-03-12 09:55:00 | AAPL | Stock | 8.1196 | 8.1321 | 8.1086 | 8.1286 | 14409276.0 |
| 2010-03-12 10:00:00 | AAPL | Stock | 8.1293 | 8.1318 | 8.0871 | 8.0979 | 15853880.0 |
| 2010-03-12 10:05:00 | AAPL | Stock | 8.0981 | 8.105 | 8.0821 | 8.0968 | 12363316.0 |
| 2010-03-12 10:10:00 | AAPL | Stock | 8.0964 | 8.1043 | 8.0821 | 8.0886 | 9546320.0 |
| 2010-03-12 10:15:00 | AAPL | Stock | 8.0875 | 8.0957 | 8.0721 | 8.0754 | 9848552.0 |
| 2010-03-12 10:20:00 | AAPL | Stock | 8.075 | 8.1018 | 8.0675 | 8.0979 | 10471804.0 |
| 2010-03-12 10:25:00 | AAPL | Stock | 8.0986 | 8.1286 | 8.0843 | 8.0939 | 5200132.0 |
| 2010-03-12 10:30:00 | AAPL | Stock | 8.0943 | 8.095 | 8.0754 | 8.0854 | 5779508.0 |
| 2010-03-12 10:35:00 | AAPL | Stock | 8.0867 | 8.0964 | 8.0789 | 8.0943 | 4596676.0 |
> showing 50 of 321,314 rows — these rows as CSV