PREVIEW / stock_5min / 2011-03-24
file: by_date/stock_5min/2011/2011-03-24.parquet size: 4.8 MB rows: 329,349 symbols: 3,510
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-24 04:20:00 | AAPL | Stock | 12.1139 | 12.1139 | 12.1139 | 12.1139 | 2800.0 |
| 2011-03-24 05:25:00 | AAPL | Stock | 12.1475 | 12.1475 | 12.1475 | 12.1475 | 8400.0 |
| 2011-03-24 06:10:00 | AAPL | Stock | 12.1707 | 12.1707 | 12.1707 | 12.1707 | 2800.0 |
| 2011-03-24 06:15:00 | AAPL | Stock | 12.1821 | 12.1821 | 12.1821 | 12.1821 | 2800.0 |
| 2011-03-24 07:10:00 | AAPL | Stock | 12.1768 | 12.2007 | 12.1768 | 12.2007 | 14196.0 |
| 2011-03-24 07:15:00 | AAPL | Stock | 12.2018 | 12.2039 | 12.2007 | 12.2039 | 42000.0 |
| 2011-03-24 07:20:00 | AAPL | Stock | 12.1896 | 12.1896 | 12.185 | 12.185 | 25200.0 |
| 2011-03-24 07:25:00 | AAPL | Stock | 12.1786 | 12.1786 | 12.1786 | 12.1786 | 2800.0 |
| 2011-03-24 07:30:00 | AAPL | Stock | 12.1893 | 12.1893 | 12.1786 | 12.1786 | 32200.0 |
| 2011-03-24 07:35:00 | AAPL | Stock | 12.1857 | 12.1907 | 12.1857 | 12.1907 | 41160.0 |
| 2011-03-24 07:40:00 | AAPL | Stock | 12.1832 | 12.1832 | 12.18 | 12.18 | 45024.0 |
| 2011-03-24 07:45:00 | AAPL | Stock | 12.1843 | 12.1868 | 12.1843 | 12.1868 | 5600.0 |
| 2011-03-24 07:55:00 | AAPL | Stock | 12.1854 | 12.1886 | 12.1854 | 12.1886 | 11200.0 |
| 2011-03-24 08:00:00 | AAPL | Stock | 12.1879 | 12.2143 | 12.1786 | 12.2143 | 424396.0 |
| 2011-03-24 08:05:00 | AAPL | Stock | 12.2143 | 12.2314 | 12.2143 | 12.2211 | 374780.0 |
| 2011-03-24 08:10:00 | AAPL | Stock | 12.2211 | 12.2243 | 12.2107 | 12.2182 | 135436.0 |
| 2011-03-24 08:15:00 | AAPL | Stock | 12.2211 | 12.225 | 12.2143 | 12.2214 | 65268.0 |
| 2011-03-24 08:20:00 | AAPL | Stock | 12.2182 | 12.2182 | 12.1964 | 12.2 | 111188.0 |
| 2011-03-24 08:25:00 | AAPL | Stock | 12.2025 | 12.2032 | 12.1929 | 12.1964 | 334348.0 |
| 2011-03-24 08:30:00 | AAPL | Stock | 12.1971 | 12.205 | 12.1911 | 12.1971 | 295540.0 |
| 2011-03-24 08:35:00 | AAPL | Stock | 12.1964 | 12.205 | 12.1964 | 12.1982 | 548940.0 |
| 2011-03-24 08:40:00 | AAPL | Stock | 12.1946 | 12.2036 | 12.1936 | 12.1986 | 65240.0 |
| 2011-03-24 08:45:00 | AAPL | Stock | 12.2025 | 12.2025 | 12.1939 | 12.1939 | 42756.0 |
| 2011-03-24 08:50:00 | AAPL | Stock | 12.1964 | 12.2029 | 12.1961 | 12.1961 | 80416.0 |
| 2011-03-24 08:55:00 | AAPL | Stock | 12.1939 | 12.1968 | 12.1932 | 12.1968 | 40236.0 |
| 2011-03-24 09:00:00 | AAPL | Stock | 12.1986 | 12.2029 | 12.1943 | 12.1964 | 160384.0 |
| 2011-03-24 09:05:00 | AAPL | Stock | 12.2 | 12.2054 | 12.2 | 12.2054 | 211708.0 |
| 2011-03-24 09:10:00 | AAPL | Stock | 12.2068 | 12.2068 | 12.2004 | 12.2004 | 71400.0 |
| 2011-03-24 09:15:00 | AAPL | Stock | 12.2014 | 12.2068 | 12.2014 | 12.2068 | 14000.0 |
| 2011-03-24 09:20:00 | AAPL | Stock | 12.2046 | 12.2057 | 12.1989 | 12.1989 | 33600.0 |
| 2011-03-24 09:25:00 | AAPL | Stock | 12.1986 | 12.2136 | 12.1964 | 12.2111 | 408240.0 |
| 2011-03-24 09:30:00 | AAPL | Stock | 12.21 | 12.2132 | 12.1793 | 12.1865 | 11803736.0 |
| 2011-03-24 09:35:00 | AAPL | Stock | 12.1864 | 12.1914 | 12.1611 | 12.1711 | 8526700.0 |
| 2011-03-24 09:40:00 | AAPL | Stock | 12.1668 | 12.1982 | 12.1621 | 12.185 | 8467088.0 |
| 2011-03-24 09:45:00 | AAPL | Stock | 12.1843 | 12.1871 | 12.1625 | 12.1668 | 6426364.0 |
| 2011-03-24 09:50:00 | AAPL | Stock | 12.1689 | 12.1689 | 12.1021 | 12.1393 | 14217028.0 |
| 2011-03-24 09:55:00 | AAPL | Stock | 12.1418 | 12.1518 | 12.118 | 12.1436 | 7599004.0 |
| 2011-03-24 10:00:00 | AAPL | Stock | 12.1439 | 12.1575 | 12.1229 | 12.1575 | 7538636.0 |
| 2011-03-24 10:05:00 | AAPL | Stock | 12.1554 | 12.1696 | 12.1486 | 12.16 | 4895184.0 |
| 2011-03-24 10:10:00 | AAPL | Stock | 12.1614 | 12.1614 | 12.1218 | 12.1446 | 5128396.0 |
| 2011-03-24 10:15:00 | AAPL | Stock | 12.1446 | 12.1679 | 12.1375 | 12.1653 | 4578140.0 |
| 2011-03-24 10:20:00 | AAPL | Stock | 12.1655 | 12.1843 | 12.165 | 12.1782 | 5393472.0 |
| 2011-03-24 10:25:00 | AAPL | Stock | 12.1775 | 12.1836 | 12.1646 | 12.17 | 3327240.0 |
| 2011-03-24 10:30:00 | AAPL | Stock | 12.1682 | 12.195 | 12.1682 | 12.195 | 7478632.0 |
| 2011-03-24 10:35:00 | AAPL | Stock | 12.195 | 12.2096 | 12.1854 | 12.1936 | 6434064.0 |
| 2011-03-24 10:40:00 | AAPL | Stock | 12.1954 | 12.2032 | 12.1875 | 12.1961 | 4275908.0 |
| 2011-03-24 10:45:00 | AAPL | Stock | 12.1957 | 12.1968 | 12.1811 | 12.1811 | 3215856.0 |
| 2011-03-24 10:50:00 | AAPL | Stock | 12.1811 | 12.2084 | 12.1811 | 12.1982 | 3615052.0 |
| 2011-03-24 10:55:00 | AAPL | Stock | 12.2003 | 12.2293 | 12.1986 | 12.2257 | 9443672.0 |
| 2011-03-24 11:00:00 | AAPL | Stock | 12.2236 | 12.2446 | 12.2212 | 12.2376 | 9909508.0 |
> showing 50 of 329,349 rows — these rows as CSV