PREVIEW / stock_5min / 2014-04-01
file: by_date/stock_5min/2014/2014-04-01.parquet size: 5.6 MB rows: 373,546 symbols: 3,566
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-01 04:50:00 | AAPL | Stock | 19.1854 | 19.1889 | 19.1854 | 19.1889 | 5600.0 |
| 2014-04-01 05:00:00 | AAPL | Stock | 19.1786 | 19.1786 | 19.1786 | 19.1786 | 2800.0 |
| 2014-04-01 06:30:00 | AAPL | Stock | 19.1786 | 19.1786 | 19.1786 | 19.1786 | 2800.0 |
| 2014-04-01 06:35:00 | AAPL | Stock | 19.1871 | 19.1893 | 19.1871 | 19.1893 | 8960.0 |
| 2014-04-01 07:00:00 | AAPL | Stock | 19.1968 | 19.1968 | 19.1968 | 19.1968 | 2800.0 |
| 2014-04-01 07:05:00 | AAPL | Stock | 19.2014 | 19.2054 | 19.2014 | 19.2054 | 8400.0 |
| 2014-04-01 07:10:00 | AAPL | Stock | 19.2143 | 19.2143 | 19.1964 | 19.1964 | 20804.0 |
| 2014-04-01 07:15:00 | AAPL | Stock | 19.1971 | 19.1971 | 19.1964 | 19.1964 | 28000.0 |
| 2014-04-01 07:20:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 5600.0 |
| 2014-04-01 07:25:00 | AAPL | Stock | 19.1971 | 19.1971 | 19.1964 | 19.1964 | 47600.0 |
| 2014-04-01 07:30:00 | AAPL | Stock | 19.2014 | 19.2086 | 19.1964 | 19.1964 | 25900.0 |
| 2014-04-01 07:40:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 2800.0 |
| 2014-04-01 07:50:00 | AAPL | Stock | 19.2043 | 19.2071 | 19.2043 | 19.2054 | 19600.0 |
| 2014-04-01 08:00:00 | AAPL | Stock | 19.2057 | 19.2057 | 19.1964 | 19.2054 | 23800.0 |
| 2014-04-01 08:05:00 | AAPL | Stock | 19.2089 | 19.2089 | 19.2089 | 19.2089 | 2800.0 |
| 2014-04-01 08:10:00 | AAPL | Stock | 19.21 | 19.21 | 19.2054 | 19.2057 | 53200.0 |
| 2014-04-01 08:15:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 2800.0 |
| 2014-04-01 08:20:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.1968 | 19.2029 | 99540.0 |
| 2014-04-01 08:25:00 | AAPL | Stock | 19.2029 | 19.2029 | 19.2029 | 19.2029 | 2800.0 |
| 2014-04-01 08:30:00 | AAPL | Stock | 19.2018 | 19.2018 | 19.2 | 19.2 | 8400.0 |
| 2014-04-01 08:35:00 | AAPL | Stock | 19.1989 | 19.2032 | 19.1989 | 19.2032 | 16800.0 |
| 2014-04-01 08:40:00 | AAPL | Stock | 19.2032 | 19.205 | 19.2029 | 19.2029 | 22400.0 |
| 2014-04-01 08:45:00 | AAPL | Stock | 19.2071 | 19.2071 | 19.1693 | 19.1693 | 48244.0 |
| 2014-04-01 08:50:00 | AAPL | Stock | 19.2071 | 19.2321 | 19.2064 | 19.2321 | 164472.0 |
| 2014-04-01 09:00:00 | AAPL | Stock | 19.2257 | 19.2257 | 19.2218 | 19.2236 | 16800.0 |
| 2014-04-01 09:05:00 | AAPL | Stock | 19.2232 | 19.2232 | 19.2196 | 19.2196 | 37492.0 |
| 2014-04-01 09:10:00 | AAPL | Stock | 19.2161 | 19.2218 | 19.2161 | 19.2218 | 11200.0 |
| 2014-04-01 09:15:00 | AAPL | Stock | 19.2221 | 19.2221 | 19.2207 | 19.2214 | 30800.0 |
| 2014-04-01 09:20:00 | AAPL | Stock | 19.2111 | 19.2111 | 19.2089 | 19.2096 | 33572.0 |
| 2014-04-01 09:25:00 | AAPL | Stock | 19.2036 | 19.2321 | 19.1968 | 19.23 | 313040.0 |
| 2014-04-01 09:30:00 | AAPL | Stock | 19.2136 | 19.2604 | 19.1954 | 19.2418 | 8482488.0 |
| 2014-04-01 09:35:00 | AAPL | Stock | 19.2432 | 19.2571 | 19.2193 | 19.2475 | 4071256.0 |
| 2014-04-01 09:40:00 | AAPL | Stock | 19.2471 | 19.2471 | 19.2108 | 19.2108 | 2632224.0 |
| 2014-04-01 09:45:00 | AAPL | Stock | 19.2107 | 19.2407 | 19.1843 | 19.1918 | 4005792.0 |
| 2014-04-01 09:50:00 | AAPL | Stock | 19.1943 | 19.2139 | 19.1804 | 19.1946 | 2844968.0 |
| 2014-04-01 09:55:00 | AAPL | Stock | 19.1914 | 19.2339 | 19.1907 | 19.1929 | 2348556.0 |
| 2014-04-01 10:00:00 | AAPL | Stock | 19.1893 | 19.2154 | 19.1746 | 19.1968 | 3142692.0 |
| 2014-04-01 10:05:00 | AAPL | Stock | 19.1968 | 19.2089 | 19.1761 | 19.1927 | 1863344.0 |
| 2014-04-01 10:10:00 | AAPL | Stock | 19.1929 | 19.2004 | 19.1718 | 19.1718 | 1875832.0 |
| 2014-04-01 10:15:00 | AAPL | Stock | 19.1714 | 19.1986 | 19.1704 | 19.1889 | 2931180.0 |
| 2014-04-01 10:20:00 | AAPL | Stock | 19.185 | 19.2054 | 19.1793 | 19.1943 | 1358392.0 |
| 2014-04-01 10:25:00 | AAPL | Stock | 19.1896 | 19.2061 | 19.1879 | 19.1968 | 1511720.0 |
| 2014-04-01 10:30:00 | AAPL | Stock | 19.195 | 19.22 | 19.195 | 19.2011 | 2163252.0 |
| 2014-04-01 10:35:00 | AAPL | Stock | 19.2025 | 19.2129 | 19.1968 | 19.1968 | 1379700.0 |
| 2014-04-01 10:40:00 | AAPL | Stock | 19.1971 | 19.2107 | 19.1968 | 19.1968 | 1223152.0 |
| 2014-04-01 10:45:00 | AAPL | Stock | 19.1964 | 19.2193 | 19.1939 | 19.2164 | 1781388.0 |
| 2014-04-01 10:50:00 | AAPL | Stock | 19.2164 | 19.2368 | 19.2129 | 19.225 | 2235856.0 |
| 2014-04-01 10:55:00 | AAPL | Stock | 19.2261 | 19.2379 | 19.2187 | 19.2296 | 1530172.0 |
| 2014-04-01 11:00:00 | AAPL | Stock | 19.2321 | 19.2429 | 19.2264 | 19.2354 | 3048444.0 |
| 2014-04-01 11:05:00 | AAPL | Stock | 19.2368 | 19.2425 | 19.2314 | 19.2375 | 3653888.0 |
> showing 50 of 373,546 rows — these rows as CSV