PREVIEW / stock_5min / 2010-06-15
file: by_date/stock_5min/2010/2010-06-15.parquet size: 4.9 MB rows: 335,444 symbols: 3,476
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-06-15 04:15:00 | AAPL | Stock | 9.0814 | 9.0814 | 9.0814 | 9.0814 | 11200.0 |
| 2010-06-15 04:20:00 | AAPL | Stock | 9.0821 | 9.0821 | 9.0821 | 9.0821 | 2800.0 |
| 2010-06-15 04:50:00 | AAPL | Stock | 9.0936 | 9.0936 | 9.0936 | 9.0936 | 2800.0 |
| 2010-06-15 04:55:00 | AAPL | Stock | 9.0986 | 9.1 | 9.0789 | 9.0961 | 58800.0 |
| 2010-06-15 05:05:00 | AAPL | Stock | 9.0961 | 9.1143 | 9.0961 | 9.1143 | 18200.0 |
| 2010-06-15 06:35:00 | AAPL | Stock | 9.1461 | 9.1461 | 9.1461 | 9.1461 | 2800.0 |
| 2010-06-15 07:05:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 8400.0 |
| 2010-06-15 07:10:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 34020.0 |
| 2010-06-15 07:20:00 | AAPL | Stock | 9.1464 | 9.1464 | 9.1414 | 9.1414 | 17920.0 |
| 2010-06-15 07:30:00 | AAPL | Stock | 9.1382 | 9.1396 | 9.1346 | 9.1396 | 11200.0 |
| 2010-06-15 07:35:00 | AAPL | Stock | 9.1496 | 9.15 | 9.1496 | 9.15 | 21000.0 |
| 2010-06-15 07:40:00 | AAPL | Stock | 9.1461 | 9.15 | 9.1461 | 9.15 | 12600.0 |
| 2010-06-15 07:45:00 | AAPL | Stock | 9.1411 | 9.1411 | 9.1411 | 9.1411 | 22400.0 |
| 2010-06-15 07:50:00 | AAPL | Stock | 9.1411 | 9.1411 | 9.1411 | 9.1411 | 2800.0 |
| 2010-06-15 08:00:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.0982 | 9.1075 | 659176.0 |
| 2010-06-15 08:05:00 | AAPL | Stock | 9.1043 | 9.1357 | 9.0971 | 9.1161 | 356608.0 |
| 2010-06-15 08:10:00 | AAPL | Stock | 9.1161 | 9.1211 | 9.1114 | 9.1211 | 175000.0 |
| 2010-06-15 08:15:00 | AAPL | Stock | 9.1229 | 9.1239 | 9.1146 | 9.1229 | 227108.0 |
| 2010-06-15 08:20:00 | AAPL | Stock | 9.1214 | 9.1304 | 9.1214 | 9.1286 | 218540.0 |
| 2010-06-15 08:25:00 | AAPL | Stock | 9.1293 | 9.1321 | 9.125 | 9.125 | 114604.0 |
| 2010-06-15 08:30:00 | AAPL | Stock | 9.1246 | 9.1393 | 9.1246 | 9.1339 | 172200.0 |
| 2010-06-15 08:35:00 | AAPL | Stock | 9.1339 | 9.1343 | 9.1271 | 9.1336 | 88368.0 |
| 2010-06-15 08:40:00 | AAPL | Stock | 9.1329 | 9.1329 | 9.125 | 9.1311 | 62720.0 |
| 2010-06-15 08:45:00 | AAPL | Stock | 9.1257 | 9.1261 | 9.1225 | 9.1257 | 44800.0 |
| 2010-06-15 08:50:00 | AAPL | Stock | 9.1243 | 9.1246 | 9.1193 | 9.1243 | 134960.0 |
| 2010-06-15 08:55:00 | AAPL | Stock | 9.1243 | 9.1246 | 9.1143 | 9.1193 | 215460.0 |
| 2010-06-15 09:00:00 | AAPL | Stock | 9.1182 | 9.1311 | 9.1182 | 9.1311 | 175560.0 |
| 2010-06-15 09:05:00 | AAPL | Stock | 9.1325 | 9.1368 | 9.1304 | 9.1314 | 53200.0 |
| 2010-06-15 09:10:00 | AAPL | Stock | 9.1325 | 9.1375 | 9.1314 | 9.1314 | 197372.0 |
| 2010-06-15 09:15:00 | AAPL | Stock | 9.1307 | 9.1371 | 9.1307 | 9.1332 | 134120.0 |
| 2010-06-15 09:20:00 | AAPL | Stock | 9.1364 | 9.1364 | 9.1329 | 9.1332 | 70000.0 |
| 2010-06-15 09:25:00 | AAPL | Stock | 9.1332 | 9.1346 | 9.1232 | 9.13 | 210560.0 |
| 2010-06-15 09:30:00 | AAPL | Stock | 9.13 | 9.1679 | 9.125 | 9.1668 | 16957080.0 |
| 2010-06-15 09:35:00 | AAPL | Stock | 9.167 | 9.1919 | 9.15 | 9.1779 | 16733080.0 |
| 2010-06-15 09:40:00 | AAPL | Stock | 9.1779 | 9.1961 | 9.1736 | 9.1839 | 12429368.0 |
| 2010-06-15 09:45:00 | AAPL | Stock | 9.1837 | 9.1957 | 9.1693 | 9.1839 | 7726348.0 |
| 2010-06-15 09:50:00 | AAPL | Stock | 9.1846 | 9.2036 | 9.1836 | 9.1974 | 10521560.0 |
| 2010-06-15 09:55:00 | AAPL | Stock | 9.1986 | 9.2321 | 9.1982 | 9.2239 | 13390552.0 |
| 2010-06-15 10:00:00 | AAPL | Stock | 9.2218 | 9.2261 | 9.2007 | 9.212 | 12841500.0 |
| 2010-06-15 10:05:00 | AAPL | Stock | 9.2125 | 9.2282 | 9.2064 | 9.21 | 10605028.0 |
| 2010-06-15 10:10:00 | AAPL | Stock | 9.2104 | 9.2157 | 9.1875 | 9.1935 | 9122708.0 |
| 2010-06-15 10:15:00 | AAPL | Stock | 9.1954 | 9.2014 | 9.1843 | 9.197 | 6541724.0 |
| 2010-06-15 10:20:00 | AAPL | Stock | 9.1964 | 9.2121 | 9.1964 | 9.2071 | 5013876.0 |
| 2010-06-15 10:25:00 | AAPL | Stock | 9.2071 | 9.2179 | 9.2043 | 9.2054 | 6240612.0 |
| 2010-06-15 10:30:00 | AAPL | Stock | 9.2054 | 9.2143 | 9.1989 | 9.2011 | 4099816.0 |
| 2010-06-15 10:35:00 | AAPL | Stock | 9.2018 | 9.2122 | 9.1996 | 9.205 | 3790192.0 |
| 2010-06-15 10:40:00 | AAPL | Stock | 9.2046 | 9.2118 | 9.1889 | 9.2093 | 6304872.0 |
| 2010-06-15 10:45:00 | AAPL | Stock | 9.2104 | 9.2168 | 9.2039 | 9.2079 | 4771676.0 |
| 2010-06-15 10:50:00 | AAPL | Stock | 9.2068 | 9.2204 | 9.1968 | 9.2204 | 5642308.0 |
| 2010-06-15 10:55:00 | AAPL | Stock | 9.2196 | 9.2214 | 9.2079 | 9.2175 | 6605228.0 |
> showing 50 of 335,444 rows — these rows as CSV