PREVIEW / stock_5min / 2009-03-04
file: by_date/stock_5min/2009/2009-03-04.parquet size: 4.5 MB rows: 311,204 symbols: 3,331
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-04 05:10:00 | AAPL | Stock | 3.19 | 3.19 | 3.19 | 3.19 | 2800.0 |
| 2009-03-04 07:00:00 | AAPL | Stock | 3.1925 | 3.1925 | 3.1925 | 3.1925 | 5600.0 |
| 2009-03-04 07:10:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1911 | 3.1911 | 8400.0 |
| 2009-03-04 07:20:00 | AAPL | Stock | 3.1911 | 3.1911 | 3.1911 | 3.1911 | 2800.0 |
| 2009-03-04 07:30:00 | AAPL | Stock | 3.1982 | 3.1982 | 3.1857 | 3.1982 | 14000.0 |
| 2009-03-04 07:35:00 | AAPL | Stock | 3.2054 | 3.2054 | 3.1982 | 3.2054 | 19600.0 |
| 2009-03-04 07:50:00 | AAPL | Stock | 3.1921 | 3.1921 | 3.1893 | 3.1893 | 11200.0 |
| 2009-03-04 07:55:00 | AAPL | Stock | 3.1861 | 3.1861 | 3.1789 | 3.1789 | 19152.0 |
| 2009-03-04 08:00:00 | AAPL | Stock | 3.1786 | 3.1857 | 3.1786 | 3.1839 | 171696.0 |
| 2009-03-04 08:05:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1707 | 3.1714 | 95620.0 |
| 2009-03-04 08:10:00 | AAPL | Stock | 3.1782 | 3.1786 | 3.1779 | 3.1782 | 61040.0 |
| 2009-03-04 08:15:00 | AAPL | Stock | 3.1786 | 3.185 | 3.1775 | 3.1818 | 168000.0 |
| 2009-03-04 08:20:00 | AAPL | Stock | 3.1825 | 3.1857 | 3.1825 | 3.1839 | 74900.0 |
| 2009-03-04 08:25:00 | AAPL | Stock | 3.1821 | 3.1821 | 3.1764 | 3.1764 | 69580.0 |
| 2009-03-04 08:30:00 | AAPL | Stock | 3.1786 | 3.1914 | 3.1786 | 3.1889 | 281848.0 |
| 2009-03-04 08:35:00 | AAPL | Stock | 3.1875 | 3.1982 | 3.1875 | 3.1975 | 274988.0 |
| 2009-03-04 08:40:00 | AAPL | Stock | 3.1939 | 3.1971 | 3.1936 | 3.1939 | 108360.0 |
| 2009-03-04 08:45:00 | AAPL | Stock | 3.1946 | 3.1986 | 3.1929 | 3.1943 | 81340.0 |
| 2009-03-04 08:50:00 | AAPL | Stock | 3.1964 | 3.2 | 3.1932 | 3.1993 | 94528.0 |
| 2009-03-04 08:55:00 | AAPL | Stock | 3.2 | 3.2086 | 3.1993 | 3.2054 | 336000.0 |
| 2009-03-04 09:00:00 | AAPL | Stock | 3.2054 | 3.2125 | 3.2036 | 3.2121 | 339780.0 |
| 2009-03-04 09:05:00 | AAPL | Stock | 3.2118 | 3.2125 | 3.2086 | 3.2107 | 106428.0 |
| 2009-03-04 09:10:00 | AAPL | Stock | 3.2093 | 3.2121 | 3.2082 | 3.2114 | 211932.0 |
| 2009-03-04 09:15:00 | AAPL | Stock | 3.2107 | 3.2143 | 3.21 | 3.2143 | 261268.0 |
| 2009-03-04 09:20:00 | AAPL | Stock | 3.2143 | 3.2229 | 3.2132 | 3.2146 | 388640.0 |
| 2009-03-04 09:25:00 | AAPL | Stock | 3.2146 | 3.2225 | 3.2082 | 3.215 | 484400.0 |
| 2009-03-04 09:30:00 | AAPL | Stock | 3.2182 | 3.2314 | 3.1971 | 3.2007 | 19777352.0 |
| 2009-03-04 09:35:00 | AAPL | Stock | 3.2007 | 3.225 | 3.1946 | 3.2064 | 15815604.0 |
| 2009-03-04 09:40:00 | AAPL | Stock | 3.2064 | 3.225 | 3.2004 | 3.2207 | 11928084.0 |
| 2009-03-04 09:45:00 | AAPL | Stock | 3.2214 | 3.2329 | 3.2168 | 3.2232 | 13469904.0 |
| 2009-03-04 09:50:00 | AAPL | Stock | 3.2232 | 3.2236 | 3.2104 | 3.2221 | 12223428.0 |
| 2009-03-04 09:55:00 | AAPL | Stock | 3.2211 | 3.2321 | 3.2196 | 3.2225 | 10828776.0 |
| 2009-03-04 10:00:00 | AAPL | Stock | 3.2229 | 3.2418 | 3.2225 | 3.2311 | 13280176.0 |
| 2009-03-04 10:05:00 | AAPL | Stock | 3.2314 | 3.2404 | 3.2271 | 3.2282 | 9656472.0 |
| 2009-03-04 10:10:00 | AAPL | Stock | 3.2279 | 3.2286 | 3.2086 | 3.2175 | 11630304.0 |
| 2009-03-04 10:15:00 | AAPL | Stock | 3.2175 | 3.23 | 3.2154 | 3.2239 | 8923124.0 |
| 2009-03-04 10:20:00 | AAPL | Stock | 3.2246 | 3.2268 | 3.2143 | 3.2193 | 8044288.0 |
| 2009-03-04 10:25:00 | AAPL | Stock | 3.2193 | 3.2386 | 3.2182 | 3.2336 | 9046744.0 |
| 2009-03-04 10:30:00 | AAPL | Stock | 3.235 | 3.2396 | 3.2304 | 3.2318 | 7305620.0 |
| 2009-03-04 10:35:00 | AAPL | Stock | 3.2321 | 3.2368 | 3.2225 | 3.2357 | 6370896.0 |
| 2009-03-04 10:40:00 | AAPL | Stock | 3.2339 | 3.25 | 3.2325 | 3.2464 | 13433840.0 |
| 2009-03-04 10:45:00 | AAPL | Stock | 3.2464 | 3.2546 | 3.2414 | 3.2457 | 9316076.0 |
| 2009-03-04 10:50:00 | AAPL | Stock | 3.2454 | 3.2579 | 3.2414 | 3.2514 | 7158928.0 |
| 2009-03-04 10:55:00 | AAPL | Stock | 3.2511 | 3.2607 | 3.2489 | 3.2545 | 9637740.0 |
| 2009-03-04 11:00:00 | AAPL | Stock | 3.2543 | 3.2768 | 3.2539 | 3.2696 | 11368812.0 |
| 2009-03-04 11:05:00 | AAPL | Stock | 3.27 | 3.2761 | 3.2654 | 3.2682 | 8744176.0 |
| 2009-03-04 11:10:00 | AAPL | Stock | 3.2686 | 3.2768 | 3.2611 | 3.2639 | 9265900.0 |
| 2009-03-04 11:15:00 | AAPL | Stock | 3.2639 | 3.2704 | 3.2632 | 3.2696 | 5462072.0 |
| 2009-03-04 11:20:00 | AAPL | Stock | 3.2693 | 3.2764 | 3.2643 | 3.2758 | 6754496.0 |
| 2009-03-04 11:25:00 | AAPL | Stock | 3.2764 | 3.2814 | 3.2721 | 3.2775 | 7995176.0 |
> showing 50 of 311,204 rows — these rows as CSV