PREVIEW / stock_5min / 2010-10-01
file: by_date/stock_5min/2010/2010-10-01.parquet size: 4.7 MB rows: 326,370 symbols: 3,468
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-10-01 06:15:00 | AAPL | Stock | 10.1964 | 10.1964 | 10.1964 | 10.1964 | 2800.0 |
| 2010-10-01 07:00:00 | AAPL | Stock | 10.1893 | 10.1893 | 10.1836 | 10.1836 | 5600.0 |
| 2010-10-01 07:05:00 | AAPL | Stock | 10.1889 | 10.1889 | 10.1539 | 10.1539 | 5600.0 |
| 2010-10-01 07:10:00 | AAPL | Stock | 10.1786 | 10.1786 | 10.1786 | 10.1786 | 14000.0 |
| 2010-10-01 07:15:00 | AAPL | Stock | 10.1879 | 10.1879 | 10.1879 | 10.1879 | 2800.0 |
| 2010-10-01 07:20:00 | AAPL | Stock | 10.1821 | 10.1821 | 10.1821 | 10.1821 | 2800.0 |
| 2010-10-01 07:25:00 | AAPL | Stock | 10.1889 | 10.1889 | 10.1889 | 10.1889 | 2800.0 |
| 2010-10-01 07:30:00 | AAPL | Stock | 10.1886 | 10.1961 | 10.1886 | 10.1961 | 16800.0 |
| 2010-10-01 07:35:00 | AAPL | Stock | 10.1961 | 10.1968 | 10.1861 | 10.1896 | 39200.0 |
| 2010-10-01 07:40:00 | AAPL | Stock | 10.1893 | 10.1893 | 10.1893 | 10.1893 | 8120.0 |
| 2010-10-01 07:50:00 | AAPL | Stock | 10.1889 | 10.1889 | 10.1786 | 10.1875 | 27300.0 |
| 2010-10-01 07:55:00 | AAPL | Stock | 10.1793 | 10.1961 | 10.1786 | 10.1961 | 41720.0 |
| 2010-10-01 08:00:00 | AAPL | Stock | 10.1964 | 10.2107 | 10.1339 | 10.2061 | 288344.0 |
| 2010-10-01 08:05:00 | AAPL | Stock | 10.2036 | 10.2096 | 10.1339 | 10.2043 | 343392.0 |
| 2010-10-01 08:10:00 | AAPL | Stock | 10.2054 | 10.2079 | 10.2018 | 10.2036 | 100800.0 |
| 2010-10-01 08:15:00 | AAPL | Stock | 10.2 | 10.2054 | 10.1946 | 10.1964 | 69496.0 |
| 2010-10-01 08:20:00 | AAPL | Stock | 10.1946 | 10.1996 | 10.1946 | 10.1964 | 63616.0 |
| 2010-10-01 08:25:00 | AAPL | Stock | 10.1964 | 10.2071 | 10.1954 | 10.2071 | 100800.0 |
| 2010-10-01 08:30:00 | AAPL | Stock | 10.2071 | 10.215 | 10.1339 | 10.1979 | 693196.0 |
| 2010-10-01 08:35:00 | AAPL | Stock | 10.2032 | 10.2036 | 10.1339 | 10.2029 | 277088.0 |
| 2010-10-01 08:40:00 | AAPL | Stock | 10.2025 | 10.2143 | 10.2025 | 10.2057 | 193984.0 |
| 2010-10-01 08:45:00 | AAPL | Stock | 10.2054 | 10.2104 | 10.2054 | 10.2104 | 46200.0 |
| 2010-10-01 08:50:00 | AAPL | Stock | 10.2107 | 10.2139 | 10.2054 | 10.2054 | 226240.0 |
| 2010-10-01 08:55:00 | AAPL | Stock | 10.2057 | 10.2204 | 10.2018 | 10.2171 | 368900.0 |
| 2010-10-01 09:00:00 | AAPL | Stock | 10.2157 | 10.2211 | 10.1339 | 10.2186 | 278852.0 |
| 2010-10-01 09:05:00 | AAPL | Stock | 10.2186 | 10.2196 | 10.2143 | 10.2179 | 176260.0 |
| 2010-10-01 09:10:00 | AAPL | Stock | 10.2157 | 10.2168 | 10.2121 | 10.2136 | 267680.0 |
| 2010-10-01 09:15:00 | AAPL | Stock | 10.2139 | 10.2154 | 10.2096 | 10.2154 | 201992.0 |
| 2010-10-01 09:20:00 | AAPL | Stock | 10.215 | 10.2161 | 10.1904 | 10.1986 | 839916.0 |
| 2010-10-01 09:25:00 | AAPL | Stock | 10.1993 | 10.2275 | 10.1957 | 10.225 | 1581860.0 |
| 2010-10-01 09:30:00 | AAPL | Stock | 10.2286 | 10.235 | 10.1861 | 10.2025 | 19540556.0 |
| 2010-10-01 09:35:00 | AAPL | Stock | 10.2029 | 10.2311 | 10.1818 | 10.1875 | 12528796.0 |
| 2010-10-01 09:40:00 | AAPL | Stock | 10.1871 | 10.1996 | 10.1518 | 10.1557 | 11632012.0 |
| 2010-10-01 09:45:00 | AAPL | Stock | 10.1557 | 10.1607 | 10.1361 | 10.1454 | 14323708.0 |
| 2010-10-01 09:50:00 | AAPL | Stock | 10.1489 | 10.175 | 10.1429 | 10.1704 | 8809556.0 |
| 2010-10-01 09:55:00 | AAPL | Stock | 10.1732 | 10.1907 | 10.1568 | 10.1822 | 9405284.0 |
| 2010-10-01 10:00:00 | AAPL | Stock | 10.1832 | 10.1964 | 10.1268 | 10.1468 | 17058888.0 |
| 2010-10-01 10:05:00 | AAPL | Stock | 10.1426 | 10.1646 | 10.1304 | 10.1575 | 7942816.0 |
| 2010-10-01 10:10:00 | AAPL | Stock | 10.1582 | 10.1882 | 10.1575 | 10.1714 | 9458736.0 |
| 2010-10-01 10:15:00 | AAPL | Stock | 10.1714 | 10.1754 | 10.1446 | 10.1446 | 7732396.0 |
| 2010-10-01 10:20:00 | AAPL | Stock | 10.145 | 10.1532 | 10.1018 | 10.1071 | 12829152.0 |
| 2010-10-01 10:25:00 | AAPL | Stock | 10.1086 | 10.1091 | 10.0482 | 10.0768 | 23182348.0 |
| 2010-10-01 10:30:00 | AAPL | Stock | 10.0768 | 10.0911 | 10.0618 | 10.0854 | 12942104.0 |
| 2010-10-01 10:35:00 | AAPL | Stock | 10.0875 | 10.0911 | 10.0525 | 10.0779 | 12780376.0 |
| 2010-10-01 10:40:00 | AAPL | Stock | 10.0771 | 10.0993 | 10.0646 | 10.0968 | 6363224.0 |
| 2010-10-01 10:45:00 | AAPL | Stock | 10.095 | 10.1214 | 10.0932 | 10.1086 | 9799692.0 |
| 2010-10-01 10:50:00 | AAPL | Stock | 10.1089 | 10.1136 | 10.0929 | 10.1021 | 3843980.0 |
| 2010-10-01 10:55:00 | AAPL | Stock | 10.1039 | 10.1211 | 10.0911 | 10.105 | 3390912.0 |
| 2010-10-01 11:00:00 | AAPL | Stock | 10.1056 | 10.1154 | 10.0893 | 10.1 | 3707928.0 |
| 2010-10-01 11:05:00 | AAPL | Stock | 10.1004 | 10.1207 | 10.0818 | 10.1125 | 4309816.0 |
> showing 50 of 326,370 rows — these rows as CSV