PREVIEW / stock_5min / 2009-11-10
file: by_date/stock_5min/2009/2009-11-10.parquet size: 4.6 MB rows: 318,320 symbols: 3,411
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-11-10 05:25:00 | AAPL | Stock | 7.1918 | 7.1918 | 7.1811 | 7.1811 | 5600.0 |
| 2009-11-10 07:00:00 | AAPL | Stock | 7.1825 | 7.1825 | 7.1825 | 7.1825 | 8400.0 |
| 2009-11-10 07:15:00 | AAPL | Stock | 7.1811 | 7.1811 | 7.1811 | 7.1811 | 2800.0 |
| 2009-11-10 07:25:00 | AAPL | Stock | 7.1925 | 7.1925 | 7.1893 | 7.1925 | 14000.0 |
| 2009-11-10 07:30:00 | AAPL | Stock | 7.1982 | 7.1982 | 7.1982 | 7.1982 | 11844.0 |
| 2009-11-10 07:50:00 | AAPL | Stock | 7.1946 | 7.1946 | 7.1811 | 7.1811 | 31192.0 |
| 2009-11-10 07:55:00 | AAPL | Stock | 7.1807 | 7.1807 | 7.1807 | 7.1807 | 2800.0 |
| 2009-11-10 08:00:00 | AAPL | Stock | 7.1929 | 7.1946 | 7.1807 | 7.1857 | 86520.0 |
| 2009-11-10 08:05:00 | AAPL | Stock | 7.1857 | 7.1893 | 7.1768 | 7.1768 | 122584.0 |
| 2009-11-10 08:10:00 | AAPL | Stock | 7.1786 | 7.1786 | 7.1721 | 7.1739 | 113204.0 |
| 2009-11-10 08:15:00 | AAPL | Stock | 7.175 | 7.1804 | 7.1725 | 7.1804 | 192696.0 |
| 2009-11-10 08:20:00 | AAPL | Stock | 7.1821 | 7.1929 | 7.1789 | 7.1929 | 47124.0 |
| 2009-11-10 08:25:00 | AAPL | Stock | 7.1882 | 7.1948 | 7.1857 | 7.1925 | 44380.0 |
| 2009-11-10 08:30:00 | AAPL | Stock | 7.1832 | 7.1843 | 7.18 | 7.18 | 28000.0 |
| 2009-11-10 08:35:00 | AAPL | Stock | 7.1911 | 7.1911 | 7.1911 | 7.1911 | 19600.0 |
| 2009-11-10 08:40:00 | AAPL | Stock | 7.1864 | 7.1907 | 7.1857 | 7.1875 | 50400.0 |
| 2009-11-10 08:45:00 | AAPL | Stock | 7.1861 | 7.1875 | 7.1857 | 7.1861 | 103600.0 |
| 2009-11-10 08:50:00 | AAPL | Stock | 7.19 | 7.1911 | 7.1857 | 7.1857 | 74480.0 |
| 2009-11-10 08:55:00 | AAPL | Stock | 7.1861 | 7.19 | 7.1829 | 7.1829 | 86296.0 |
| 2009-11-10 09:00:00 | AAPL | Stock | 7.1829 | 7.1857 | 7.1789 | 7.1796 | 83272.0 |
| 2009-11-10 09:05:00 | AAPL | Stock | 7.1821 | 7.1839 | 7.1786 | 7.1786 | 220304.0 |
| 2009-11-10 09:10:00 | AAPL | Stock | 7.1832 | 7.1857 | 7.1821 | 7.1857 | 104972.0 |
| 2009-11-10 09:15:00 | AAPL | Stock | 7.1868 | 7.1943 | 7.1868 | 7.1943 | 78960.0 |
| 2009-11-10 09:20:00 | AAPL | Stock | 7.1893 | 7.1893 | 7.1789 | 7.1793 | 95200.0 |
| 2009-11-10 09:25:00 | AAPL | Stock | 7.1793 | 7.1829 | 7.175 | 7.1811 | 199808.0 |
| 2009-11-10 09:30:00 | AAPL | Stock | 7.1818 | 7.2429 | 7.1789 | 7.24 | 20066760.0 |
| 2009-11-10 09:35:00 | AAPL | Stock | 7.2404 | 7.3207 | 7.2389 | 7.2779 | 23258676.0 |
| 2009-11-10 09:40:00 | AAPL | Stock | 7.2779 | 7.2793 | 7.2589 | 7.2661 | 13941032.0 |
| 2009-11-10 09:45:00 | AAPL | Stock | 7.2664 | 7.2771 | 7.2443 | 7.2607 | 16650900.0 |
| 2009-11-10 09:50:00 | AAPL | Stock | 7.2602 | 7.2679 | 7.2461 | 7.2475 | 9713844.0 |
| 2009-11-10 09:55:00 | AAPL | Stock | 7.2475 | 7.2629 | 7.2475 | 7.2539 | 7174048.0 |
| 2009-11-10 10:00:00 | AAPL | Stock | 7.2532 | 7.2618 | 7.2454 | 7.2557 | 9302160.0 |
| 2009-11-10 10:05:00 | AAPL | Stock | 7.2557 | 7.2596 | 7.2329 | 7.2346 | 9448936.0 |
| 2009-11-10 10:10:00 | AAPL | Stock | 7.2343 | 7.2532 | 7.2279 | 7.2496 | 7085232.0 |
| 2009-11-10 10:15:00 | AAPL | Stock | 7.2496 | 7.2564 | 7.2443 | 7.2507 | 5040784.0 |
| 2009-11-10 10:20:00 | AAPL | Stock | 7.2514 | 7.2586 | 7.2464 | 7.2554 | 4321296.0 |
| 2009-11-10 10:25:00 | AAPL | Stock | 7.2552 | 7.2668 | 7.2514 | 7.2643 | 4304188.0 |
| 2009-11-10 10:30:00 | AAPL | Stock | 7.2654 | 7.2679 | 7.2571 | 7.2571 | 5721520.0 |
| 2009-11-10 10:35:00 | AAPL | Stock | 7.2579 | 7.2579 | 7.235 | 7.2357 | 7943712.0 |
| 2009-11-10 10:40:00 | AAPL | Stock | 7.235 | 7.2361 | 7.2082 | 7.2109 | 12218836.0 |
| 2009-11-10 10:45:00 | AAPL | Stock | 7.2118 | 7.2143 | 7.1986 | 7.2107 | 8266944.0 |
| 2009-11-10 10:50:00 | AAPL | Stock | 7.21 | 7.2118 | 7.1982 | 7.21 | 6234788.0 |
| 2009-11-10 10:55:00 | AAPL | Stock | 7.2093 | 7.2161 | 7.2041 | 7.2129 | 4660628.0 |
| 2009-11-10 11:00:00 | AAPL | Stock | 7.2126 | 7.2211 | 7.2114 | 7.2175 | 4426296.0 |
| 2009-11-10 11:05:00 | AAPL | Stock | 7.2162 | 7.2221 | 7.1868 | 7.1943 | 7859712.0 |
| 2009-11-10 11:10:00 | AAPL | Stock | 7.1921 | 7.2053 | 7.1911 | 7.2046 | 5376700.0 |
| 2009-11-10 11:15:00 | AAPL | Stock | 7.2036 | 7.2061 | 7.1789 | 7.1821 | 5767020.0 |
| 2009-11-10 11:20:00 | AAPL | Stock | 7.1816 | 7.1935 | 7.18 | 7.1929 | 4428536.0 |
| 2009-11-10 11:25:00 | AAPL | Stock | 7.1943 | 7.205 | 7.1918 | 7.205 | 3552920.0 |
| 2009-11-10 11:30:00 | AAPL | Stock | 7.2036 | 7.2071 | 7.1836 | 7.1854 | 3260040.0 |
> showing 50 of 318,320 rows — these rows as CSV