PREVIEW / stock_5min / 2011-03-22
file: by_date/stock_5min/2011/2011-03-22.parquet size: 4.7 MB rows: 320,919 symbols: 3,498
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-03-22 04:00:00 | AAPL | Stock | 12.1429 | 12.1429 | 12.1429 | 12.1429 | 2800.0 |
| 2011-03-22 04:10:00 | AAPL | Stock | 12.15 | 12.1536 | 12.15 | 12.1536 | 16800.0 |
| 2011-03-22 04:25:00 | AAPL | Stock | 12.15 | 12.15 | 12.15 | 12.15 | 2800.0 |
| 2011-03-22 04:30:00 | AAPL | Stock | 12.15 | 12.1607 | 12.15 | 12.1607 | 16800.0 |
| 2011-03-22 04:35:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 14000.0 |
| 2011-03-22 04:45:00 | AAPL | Stock | 12.1607 | 12.1675 | 12.1607 | 12.1675 | 8400.0 |
| 2011-03-22 06:15:00 | AAPL | Stock | 12.1818 | 12.1818 | 12.1818 | 12.1818 | 2800.0 |
| 2011-03-22 06:20:00 | AAPL | Stock | 12.1786 | 12.1786 | 12.1786 | 12.1786 | 14000.0 |
| 2011-03-22 06:30:00 | AAPL | Stock | 12.1768 | 12.1786 | 12.1768 | 12.1786 | 5600.0 |
| 2011-03-22 06:50:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 2800.0 |
| 2011-03-22 06:55:00 | AAPL | Stock | 12.1607 | 12.1607 | 12.1607 | 12.1607 | 8820.0 |
| 2011-03-22 07:00:00 | AAPL | Stock | 12.1507 | 12.1507 | 12.1429 | 12.1429 | 16380.0 |
| 2011-03-22 07:05:00 | AAPL | Stock | 12.1429 | 12.1736 | 12.1429 | 12.1732 | 67200.0 |
| 2011-03-22 07:10:00 | AAPL | Stock | 12.1732 | 12.1786 | 12.1732 | 12.1786 | 22400.0 |
| 2011-03-22 07:15:00 | AAPL | Stock | 12.1821 | 12.1857 | 12.1821 | 12.1857 | 6720.0 |
| 2011-03-22 07:20:00 | AAPL | Stock | 12.1893 | 12.1893 | 12.185 | 12.1857 | 56000.0 |
| 2011-03-22 07:25:00 | AAPL | Stock | 12.1818 | 12.1818 | 12.1714 | 12.1714 | 35280.0 |
| 2011-03-22 07:30:00 | AAPL | Stock | 12.1696 | 12.1696 | 12.1696 | 12.1696 | 5600.0 |
| 2011-03-22 07:35:00 | AAPL | Stock | 12.1714 | 12.1746 | 12.1714 | 12.1714 | 19600.0 |
| 2011-03-22 07:40:00 | AAPL | Stock | 12.1818 | 12.2007 | 12.1818 | 12.1939 | 71008.0 |
| 2011-03-22 07:45:00 | AAPL | Stock | 12.1936 | 12.1968 | 12.1821 | 12.1889 | 86800.0 |
| 2011-03-22 07:50:00 | AAPL | Stock | 12.1714 | 12.1714 | 12.1714 | 12.1714 | 13720.0 |
| 2011-03-22 07:55:00 | AAPL | Stock | 12.1714 | 12.1761 | 12.1643 | 12.1761 | 61600.0 |
| 2011-03-22 08:00:00 | AAPL | Stock | 12.1768 | 12.1782 | 12.1607 | 12.1607 | 254548.0 |
| 2011-03-22 08:05:00 | AAPL | Stock | 12.1629 | 12.1629 | 12.1543 | 12.1625 | 169680.0 |
| 2011-03-22 08:10:00 | AAPL | Stock | 12.1643 | 12.1643 | 12.1536 | 12.1539 | 112840.0 |
| 2011-03-22 08:15:00 | AAPL | Stock | 12.1589 | 12.1589 | 12.1525 | 12.1554 | 127344.0 |
| 2011-03-22 08:20:00 | AAPL | Stock | 12.1536 | 12.1557 | 12.1432 | 12.1521 | 122192.0 |
| 2011-03-22 08:25:00 | AAPL | Stock | 12.1525 | 12.1643 | 12.1525 | 12.1643 | 92904.0 |
| 2011-03-22 08:30:00 | AAPL | Stock | 12.1607 | 12.1964 | 12.16 | 12.1929 | 591920.0 |
| 2011-03-22 08:35:00 | AAPL | Stock | 12.1979 | 12.2625 | 12.1979 | 12.2607 | 1408148.0 |
| 2011-03-22 08:40:00 | AAPL | Stock | 12.2604 | 12.2654 | 12.2254 | 12.2386 | 496412.0 |
| 2011-03-22 08:45:00 | AAPL | Stock | 12.2404 | 12.2404 | 12.2296 | 12.2393 | 138824.0 |
| 2011-03-22 08:50:00 | AAPL | Stock | 12.2393 | 12.2421 | 12.2289 | 12.2289 | 233380.0 |
| 2011-03-22 08:55:00 | AAPL | Stock | 12.2357 | 12.2375 | 12.2289 | 12.2357 | 170800.0 |
| 2011-03-22 09:00:00 | AAPL | Stock | 12.2339 | 12.2357 | 12.2211 | 12.2232 | 161168.0 |
| 2011-03-22 09:05:00 | AAPL | Stock | 12.2221 | 12.2289 | 12.2182 | 12.2182 | 181160.0 |
| 2011-03-22 09:10:00 | AAPL | Stock | 12.2171 | 12.2289 | 12.2125 | 12.225 | 400596.0 |
| 2011-03-22 09:15:00 | AAPL | Stock | 12.2286 | 12.2321 | 12.2268 | 12.2286 | 151032.0 |
| 2011-03-22 09:20:00 | AAPL | Stock | 12.2275 | 12.2275 | 12.22 | 12.225 | 66920.0 |
| 2011-03-22 09:25:00 | AAPL | Stock | 12.2254 | 12.2411 | 12.2246 | 12.2361 | 466004.0 |
| 2011-03-22 09:30:00 | AAPL | Stock | 12.2361 | 12.2364 | 12.1121 | 12.2104 | 12231884.0 |
| 2011-03-22 09:35:00 | AAPL | Stock | 12.2114 | 12.2289 | 12.1568 | 12.175 | 16678004.0 |
| 2011-03-22 09:40:00 | AAPL | Stock | 12.1757 | 12.1789 | 12.1357 | 12.16 | 13663832.0 |
| 2011-03-22 09:45:00 | AAPL | Stock | 12.1516 | 12.1736 | 12.1329 | 12.1675 | 10922128.0 |
| 2011-03-22 09:50:00 | AAPL | Stock | 12.1661 | 12.1836 | 12.1639 | 12.1764 | 9678984.0 |
| 2011-03-22 09:55:00 | AAPL | Stock | 12.1779 | 12.2018 | 12.1743 | 12.1786 | 8452668.0 |
| 2011-03-22 10:00:00 | AAPL | Stock | 12.1786 | 12.1982 | 12.1632 | 12.1796 | 6607300.0 |
| 2011-03-22 10:05:00 | AAPL | Stock | 12.1793 | 12.1957 | 12.1743 | 12.1892 | 5115628.0 |
| 2011-03-22 10:10:00 | AAPL | Stock | 12.19 | 12.1929 | 12.1689 | 12.1709 | 6139056.0 |
> showing 50 of 320,919 rows — these rows as CSV