PREVIEW / stock_5min / 2010-02-18
file: by_date/stock_5min/2010/2010-02-18.parquet size: 4.6 MB rows: 316,123 symbols: 3,451
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-02-18 04:45:00 | AAPL | Stock | 7.21 | 7.21 | 7.21 | 7.21 | 5600.0 |
| 2010-02-18 04:50:00 | AAPL | Stock | 7.2143 | 7.2143 | 7.2143 | 7.2143 | 2800.0 |
| 2010-02-18 07:45:00 | AAPL | Stock | 7.2279 | 7.2279 | 7.2279 | 7.2279 | 5600.0 |
| 2010-02-18 08:00:00 | AAPL | Stock | 7.2118 | 7.2214 | 7.2118 | 7.2214 | 19684.0 |
| 2010-02-18 08:05:00 | AAPL | Stock | 7.2268 | 7.2268 | 7.2143 | 7.2179 | 14000.0 |
| 2010-02-18 08:10:00 | AAPL | Stock | 7.2179 | 7.225 | 7.2179 | 7.225 | 36400.0 |
| 2010-02-18 08:15:00 | AAPL | Stock | 7.22 | 7.2232 | 7.2196 | 7.2232 | 36680.0 |
| 2010-02-18 08:20:00 | AAPL | Stock | 7.2214 | 7.2214 | 7.2214 | 7.2214 | 5600.0 |
| 2010-02-18 08:25:00 | AAPL | Stock | 7.2236 | 7.225 | 7.2232 | 7.2232 | 35000.0 |
| 2010-02-18 08:30:00 | AAPL | Stock | 7.2204 | 7.2204 | 7.1864 | 7.1896 | 419944.0 |
| 2010-02-18 08:35:00 | AAPL | Stock | 7.1911 | 7.1979 | 7.175 | 7.175 | 447804.0 |
| 2010-02-18 08:40:00 | AAPL | Stock | 7.1789 | 7.1857 | 7.1714 | 7.175 | 607236.0 |
| 2010-02-18 08:45:00 | AAPL | Stock | 7.1721 | 7.175 | 7.1646 | 7.1714 | 499772.0 |
| 2010-02-18 08:50:00 | AAPL | Stock | 7.1714 | 7.1732 | 7.1654 | 7.1714 | 439068.0 |
| 2010-02-18 08:55:00 | AAPL | Stock | 7.1714 | 7.1714 | 7.1696 | 7.1714 | 233212.0 |
| 2010-02-18 09:00:00 | AAPL | Stock | 7.1743 | 7.1875 | 7.1743 | 7.1857 | 320180.0 |
| 2010-02-18 09:05:00 | AAPL | Stock | 7.1857 | 7.1936 | 7.185 | 7.1914 | 277732.0 |
| 2010-02-18 09:10:00 | AAPL | Stock | 7.1943 | 7.1996 | 7.1907 | 7.1989 | 235480.0 |
| 2010-02-18 09:15:00 | AAPL | Stock | 7.1986 | 7.1986 | 7.1911 | 7.1957 | 288260.0 |
| 2010-02-18 09:20:00 | AAPL | Stock | 7.1961 | 7.1968 | 7.1925 | 7.1929 | 100520.0 |
| 2010-02-18 09:25:00 | AAPL | Stock | 7.1964 | 7.2029 | 7.1932 | 7.2029 | 193480.0 |
| 2010-02-18 09:30:00 | AAPL | Stock | 7.2004 | 7.2136 | 7.1814 | 7.2018 | 10993528.0 |
| 2010-02-18 09:35:00 | AAPL | Stock | 7.2029 | 7.2193 | 7.2014 | 7.2128 | 8876868.0 |
| 2010-02-18 09:40:00 | AAPL | Stock | 7.2125 | 7.2182 | 7.1921 | 7.1936 | 8792644.0 |
| 2010-02-18 09:45:00 | AAPL | Stock | 7.1939 | 7.1993 | 7.1757 | 7.1871 | 11993632.0 |
| 2010-02-18 09:50:00 | AAPL | Stock | 7.1868 | 7.2114 | 7.1857 | 7.2068 | 10417456.0 |
| 2010-02-18 09:55:00 | AAPL | Stock | 7.2061 | 7.215 | 7.2011 | 7.2071 | 6871536.0 |
| 2010-02-18 10:00:00 | AAPL | Stock | 7.2079 | 7.2179 | 7.2 | 7.2089 | 8967896.0 |
| 2010-02-18 10:05:00 | AAPL | Stock | 7.2082 | 7.2143 | 7.1964 | 7.2118 | 6743660.0 |
| 2010-02-18 10:10:00 | AAPL | Stock | 7.2111 | 7.2161 | 7.2021 | 7.2036 | 7651140.0 |
| 2010-02-18 10:15:00 | AAPL | Stock | 7.2039 | 7.2093 | 7.1946 | 7.1954 | 6872096.0 |
| 2010-02-18 10:20:00 | AAPL | Stock | 7.1961 | 7.1979 | 7.1879 | 7.1896 | 6440168.0 |
| 2010-02-18 10:25:00 | AAPL | Stock | 7.19 | 7.1979 | 7.1889 | 7.1979 | 4702012.0 |
| 2010-02-18 10:30:00 | AAPL | Stock | 7.1979 | 7.1986 | 7.1893 | 7.1925 | 5078668.0 |
| 2010-02-18 10:35:00 | AAPL | Stock | 7.1932 | 7.2029 | 7.1918 | 7.1986 | 4726036.0 |
| 2010-02-18 10:40:00 | AAPL | Stock | 7.1986 | 7.2179 | 7.195 | 7.2179 | 6857228.0 |
| 2010-02-18 10:45:00 | AAPL | Stock | 7.2171 | 7.2411 | 7.2136 | 7.2354 | 10885196.0 |
| 2010-02-18 10:50:00 | AAPL | Stock | 7.2346 | 7.2446 | 7.2321 | 7.2446 | 5957476.0 |
| 2010-02-18 10:55:00 | AAPL | Stock | 7.2446 | 7.2639 | 7.2436 | 7.2529 | 12380200.0 |
| 2010-02-18 11:00:00 | AAPL | Stock | 7.2532 | 7.2689 | 7.2507 | 7.266 | 9269008.0 |
| 2010-02-18 11:05:00 | AAPL | Stock | 7.2661 | 7.2768 | 7.2596 | 7.2682 | 11484368.0 |
| 2010-02-18 11:10:00 | AAPL | Stock | 7.2686 | 7.2818 | 7.2668 | 7.2735 | 6853812.0 |
| 2010-02-18 11:15:00 | AAPL | Stock | 7.2743 | 7.2761 | 7.26 | 7.2623 | 5139064.0 |
| 2010-02-18 11:20:00 | AAPL | Stock | 7.2631 | 7.2711 | 7.2621 | 7.2689 | 3355408.0 |
| 2010-02-18 11:25:00 | AAPL | Stock | 7.2696 | 7.2711 | 7.2557 | 7.2561 | 5352536.0 |
| 2010-02-18 11:30:00 | AAPL | Stock | 7.2564 | 7.2604 | 7.25 | 7.2525 | 5932248.0 |
| 2010-02-18 11:35:00 | AAPL | Stock | 7.2511 | 7.2536 | 7.2429 | 7.2521 | 6460692.0 |
| 2010-02-18 11:40:00 | AAPL | Stock | 7.2521 | 7.2657 | 7.2507 | 7.2639 | 4829440.0 |
| 2010-02-18 11:45:00 | AAPL | Stock | 7.2636 | 7.2657 | 7.2532 | 7.2536 | 2584792.0 |
| 2010-02-18 11:50:00 | AAPL | Stock | 7.2543 | 7.26 | 7.2525 | 7.2536 | 2572024.0 |
> showing 50 of 316,123 rows — these rows as CSV