PREVIEW / stock_5min / 2010-05-18
file: by_date/stock_5min/2010/2010-05-18.parquet size: 5.0 MB rows: 341,655 symbols: 3,478
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-05-18 04:15:00 | AAPL | Stock | 9.1293 | 9.1293 | 9.1293 | 9.1293 | 2800.0 |
| 2010-05-18 04:45:00 | AAPL | Stock | 9.1357 | 9.1357 | 9.1357 | 9.1357 | 2800.0 |
| 2010-05-18 04:55:00 | AAPL | Stock | 9.0982 | 9.1061 | 9.0982 | 9.1061 | 28000.0 |
| 2010-05-18 05:25:00 | AAPL | Stock | 9.1075 | 9.1161 | 9.1075 | 9.1161 | 11284.0 |
| 2010-05-18 05:30:00 | AAPL | Stock | 9.1161 | 9.1161 | 9.1161 | 9.1161 | 5600.0 |
| 2010-05-18 05:40:00 | AAPL | Stock | 9.1161 | 9.1161 | 9.1161 | 9.1161 | 2800.0 |
| 2010-05-18 05:45:00 | AAPL | Stock | 9.1161 | 9.1161 | 9.1161 | 9.1161 | 25200.0 |
| 2010-05-18 05:50:00 | AAPL | Stock | 9.1071 | 9.1071 | 9.1071 | 9.1071 | 2800.0 |
| 2010-05-18 07:00:00 | AAPL | Stock | 9.1375 | 9.1429 | 9.1375 | 9.1429 | 34720.0 |
| 2010-05-18 07:05:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1382 | 9.1425 | 27076.0 |
| 2010-05-18 07:10:00 | AAPL | Stock | 9.1404 | 9.1429 | 9.125 | 9.1354 | 55076.0 |
| 2010-05-18 07:15:00 | AAPL | Stock | 9.1389 | 9.1482 | 9.1389 | 9.1429 | 112000.0 |
| 2010-05-18 07:20:00 | AAPL | Stock | 9.1375 | 9.1429 | 9.1289 | 9.1425 | 61600.0 |
| 2010-05-18 07:25:00 | AAPL | Stock | 9.1318 | 9.1318 | 9.1318 | 9.1318 | 14000.0 |
| 2010-05-18 07:30:00 | AAPL | Stock | 9.1371 | 9.1411 | 9.1371 | 9.1393 | 28000.0 |
| 2010-05-18 07:35:00 | AAPL | Stock | 9.135 | 9.1407 | 9.135 | 9.1393 | 33600.0 |
| 2010-05-18 07:40:00 | AAPL | Stock | 9.1404 | 9.1432 | 9.1404 | 9.1425 | 144928.0 |
| 2010-05-18 07:45:00 | AAPL | Stock | 9.14 | 9.14 | 9.14 | 9.14 | 11844.0 |
| 2010-05-18 07:50:00 | AAPL | Stock | 9.1425 | 9.1429 | 9.1346 | 9.14 | 53760.0 |
| 2010-05-18 07:55:00 | AAPL | Stock | 9.1429 | 9.1461 | 9.1389 | 9.1389 | 22400.0 |
| 2010-05-18 08:00:00 | AAPL | Stock | 9.1429 | 9.1475 | 9.1357 | 9.1461 | 523180.0 |
| 2010-05-18 08:05:00 | AAPL | Stock | 9.1461 | 9.1496 | 9.1357 | 9.1364 | 438592.0 |
| 2010-05-18 08:10:00 | AAPL | Stock | 9.1386 | 9.1386 | 9.1311 | 9.1321 | 343420.0 |
| 2010-05-18 08:15:00 | AAPL | Stock | 9.1311 | 9.1346 | 9.12 | 9.1254 | 318892.0 |
| 2010-05-18 08:20:00 | AAPL | Stock | 9.1271 | 9.1393 | 9.1271 | 9.1393 | 216104.0 |
| 2010-05-18 08:25:00 | AAPL | Stock | 9.1393 | 9.1407 | 9.1279 | 9.1279 | 248920.0 |
| 2010-05-18 08:30:00 | AAPL | Stock | 9.1343 | 9.1357 | 9.1082 | 9.1193 | 606928.0 |
| 2010-05-18 08:35:00 | AAPL | Stock | 9.1154 | 9.135 | 9.1143 | 9.1314 | 443884.0 |
| 2010-05-18 08:40:00 | AAPL | Stock | 9.1314 | 9.1414 | 9.1293 | 9.1396 | 225232.0 |
| 2010-05-18 08:45:00 | AAPL | Stock | 9.1382 | 9.1504 | 9.1375 | 9.1457 | 516320.0 |
| 2010-05-18 08:50:00 | AAPL | Stock | 9.1482 | 9.1571 | 9.1429 | 9.1521 | 597100.0 |
| 2010-05-18 08:55:00 | AAPL | Stock | 9.1507 | 9.1607 | 9.1504 | 9.1571 | 591640.0 |
| 2010-05-18 09:00:00 | AAPL | Stock | 9.1557 | 9.1661 | 9.1536 | 9.1571 | 842380.0 |
| 2010-05-18 09:05:00 | AAPL | Stock | 9.1589 | 9.175 | 9.1589 | 9.1732 | 408380.0 |
| 2010-05-18 09:10:00 | AAPL | Stock | 9.1714 | 9.1911 | 9.1704 | 9.1893 | 1610252.0 |
| 2010-05-18 09:15:00 | AAPL | Stock | 9.1875 | 9.1946 | 9.1793 | 9.1946 | 361200.0 |
| 2010-05-18 09:20:00 | AAPL | Stock | 9.1927 | 9.1927 | 9.1821 | 9.1911 | 654920.0 |
| 2010-05-18 09:25:00 | AAPL | Stock | 9.1896 | 9.1914 | 9.1746 | 9.1771 | 576408.0 |
| 2010-05-18 09:30:00 | AAPL | Stock | 9.1775 | 9.2196 | 9.1757 | 9.1871 | 26278168.0 |
| 2010-05-18 09:35:00 | AAPL | Stock | 9.1868 | 9.2125 | 9.1771 | 9.2016 | 13973372.0 |
| 2010-05-18 09:40:00 | AAPL | Stock | 9.2043 | 9.2264 | 9.1971 | 9.2139 | 15104936.0 |
| 2010-05-18 09:45:00 | AAPL | Stock | 9.2136 | 9.2339 | 9.2118 | 9.2143 | 15521716.0 |
| 2010-05-18 09:50:00 | AAPL | Stock | 9.2171 | 9.2171 | 9.1929 | 9.2032 | 12577852.0 |
| 2010-05-18 09:55:00 | AAPL | Stock | 9.2015 | 9.2093 | 9.1804 | 9.1868 | 9776872.0 |
| 2010-05-18 10:00:00 | AAPL | Stock | 9.1868 | 9.2032 | 9.1675 | 9.1725 | 16500596.0 |
| 2010-05-18 10:05:00 | AAPL | Stock | 9.1693 | 9.1975 | 9.1664 | 9.1861 | 10509688.0 |
| 2010-05-18 10:10:00 | AAPL | Stock | 9.1849 | 9.1911 | 9.1737 | 9.1846 | 7619136.0 |
| 2010-05-18 10:15:00 | AAPL | Stock | 9.1861 | 9.2028 | 9.1857 | 9.1974 | 6305852.0 |
| 2010-05-18 10:20:00 | AAPL | Stock | 9.1977 | 9.2014 | 9.1821 | 9.1925 | 5526724.0 |
| 2010-05-18 10:25:00 | AAPL | Stock | 9.1932 | 9.1961 | 9.1271 | 9.1364 | 17469928.0 |
> showing 50 of 341,655 rows — these rows as CSV