PREVIEW / stock_5min / 2008-02-26
file: by_date/stock_5min/2008/2008-02-26.parquet size: 4.4 MB rows: 319,084 symbols: 3,256
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-26 04:20:00 | AAPL | Stock | 4.2843 | 4.285 | 4.2843 | 4.285 | 14000.0 |
| 2008-02-26 04:25:00 | AAPL | Stock | 4.285 | 4.2893 | 4.285 | 4.2893 | 30800.0 |
| 2008-02-26 04:50:00 | AAPL | Stock | 4.2946 | 4.2946 | 4.2946 | 4.2946 | 4340.0 |
| 2008-02-26 05:25:00 | AAPL | Stock | 4.29 | 4.2907 | 4.29 | 4.2907 | 16800.0 |
| 2008-02-26 05:35:00 | AAPL | Stock | 4.2854 | 4.2871 | 4.2854 | 4.2871 | 22400.0 |
| 2008-02-26 05:55:00 | AAPL | Stock | 4.2879 | 4.2911 | 4.2879 | 4.2911 | 53312.0 |
| 2008-02-26 06:00:00 | AAPL | Stock | 4.2886 | 4.2886 | 4.2886 | 4.2886 | 5600.0 |
| 2008-02-26 06:10:00 | AAPL | Stock | 4.2957 | 4.2957 | 4.2925 | 4.2925 | 5600.0 |
| 2008-02-26 06:15:00 | AAPL | Stock | 4.2821 | 4.2821 | 4.2821 | 4.2821 | 28000.0 |
| 2008-02-26 06:55:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 16800.0 |
| 2008-02-26 07:00:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2857 | 4.2857 | 9520.0 |
| 2008-02-26 07:05:00 | AAPL | Stock | 4.2861 | 4.2861 | 4.2861 | 4.2861 | 4200.0 |
| 2008-02-26 07:10:00 | AAPL | Stock | 4.2946 | 4.2964 | 4.2946 | 4.2964 | 30800.0 |
| 2008-02-26 07:15:00 | AAPL | Stock | 4.3 | 4.3 | 4.3 | 4.3 | 5600.0 |
| 2008-02-26 07:20:00 | AAPL | Stock | 4.2896 | 4.2929 | 4.2857 | 4.2929 | 43568.0 |
| 2008-02-26 07:25:00 | AAPL | Stock | 4.2929 | 4.2964 | 4.2929 | 4.2929 | 8400.0 |
| 2008-02-26 07:30:00 | AAPL | Stock | 4.2929 | 4.2929 | 4.2911 | 4.2911 | 39088.0 |
| 2008-02-26 07:35:00 | AAPL | Stock | 4.2875 | 4.2879 | 4.2864 | 4.2864 | 151200.0 |
| 2008-02-26 07:40:00 | AAPL | Stock | 4.2921 | 4.2979 | 4.2921 | 4.2979 | 18200.0 |
| 2008-02-26 07:45:00 | AAPL | Stock | 4.2864 | 4.2893 | 4.2864 | 4.2871 | 54600.0 |
| 2008-02-26 07:50:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2864 | 4.2864 | 103600.0 |
| 2008-02-26 07:55:00 | AAPL | Stock | 4.2821 | 4.2821 | 4.28 | 4.2807 | 46200.0 |
| 2008-02-26 08:00:00 | AAPL | Stock | 4.2764 | 4.2807 | 4.2668 | 4.2679 | 295064.0 |
| 2008-02-26 08:05:00 | AAPL | Stock | 4.2618 | 4.2632 | 4.2539 | 4.2618 | 294364.0 |
| 2008-02-26 08:10:00 | AAPL | Stock | 4.2618 | 4.2625 | 4.2543 | 4.2607 | 205100.0 |
| 2008-02-26 08:15:00 | AAPL | Stock | 4.2604 | 4.2607 | 4.25 | 4.2571 | 188664.0 |
| 2008-02-26 08:20:00 | AAPL | Stock | 4.2543 | 4.2579 | 4.25 | 4.25 | 107968.0 |
| 2008-02-26 08:25:00 | AAPL | Stock | 4.2464 | 4.2464 | 4.2375 | 4.2411 | 302484.0 |
| 2008-02-26 08:30:00 | AAPL | Stock | 4.2411 | 4.2536 | 4.2236 | 4.2346 | 1503964.0 |
| 2008-02-26 08:35:00 | AAPL | Stock | 4.2346 | 4.2525 | 4.2339 | 4.2414 | 487424.0 |
| 2008-02-26 08:40:00 | AAPL | Stock | 4.2436 | 4.2496 | 4.2411 | 4.2496 | 342272.0 |
| 2008-02-26 08:45:00 | AAPL | Stock | 4.2436 | 4.25 | 4.2436 | 4.2479 | 186228.0 |
| 2008-02-26 08:50:00 | AAPL | Stock | 4.2457 | 4.25 | 4.2429 | 4.2429 | 135800.0 |
| 2008-02-26 08:55:00 | AAPL | Stock | 4.2411 | 4.2457 | 4.2407 | 4.2436 | 200620.0 |
| 2008-02-26 09:00:00 | AAPL | Stock | 4.245 | 4.2482 | 4.235 | 4.2357 | 347480.0 |
| 2008-02-26 09:05:00 | AAPL | Stock | 4.235 | 4.2368 | 4.2107 | 4.2182 | 1236060.0 |
| 2008-02-26 09:10:00 | AAPL | Stock | 4.2193 | 4.2193 | 4.2036 | 4.2093 | 1488816.0 |
| 2008-02-26 09:15:00 | AAPL | Stock | 4.2093 | 4.2168 | 4.2089 | 4.2161 | 307972.0 |
| 2008-02-26 09:20:00 | AAPL | Stock | 4.2146 | 4.2175 | 4.1968 | 4.2139 | 486612.0 |
| 2008-02-26 09:25:00 | AAPL | Stock | 4.2143 | 4.2146 | 4.1968 | 4.2018 | 1426880.0 |
| 2008-02-26 09:30:00 | AAPL | Stock | 4.2014 | 4.2389 | 4.2007 | 4.2354 | 37120916.0 |
| 2008-02-26 09:35:00 | AAPL | Stock | 4.2354 | 4.24 | 4.2036 | 4.2071 | 26448688.0 |
| 2008-02-26 09:40:00 | AAPL | Stock | 4.2068 | 4.2246 | 4.2032 | 4.2139 | 20343568.0 |
| 2008-02-26 09:45:00 | AAPL | Stock | 4.2137 | 4.2289 | 4.1986 | 4.2154 | 23191560.0 |
| 2008-02-26 09:50:00 | AAPL | Stock | 4.2154 | 4.2179 | 4.185 | 4.1971 | 26122740.0 |
| 2008-02-26 09:55:00 | AAPL | Stock | 4.1975 | 4.1989 | 4.1696 | 4.1739 | 23164680.0 |
| 2008-02-26 10:00:00 | AAPL | Stock | 4.1743 | 4.1925 | 4.1657 | 4.1875 | 33959184.0 |
| 2008-02-26 10:05:00 | AAPL | Stock | 4.1879 | 4.1964 | 4.1704 | 4.1911 | 20203792.0 |
| 2008-02-26 10:10:00 | AAPL | Stock | 4.1904 | 4.1929 | 4.1679 | 4.1689 | 20069168.0 |
| 2008-02-26 10:15:00 | AAPL | Stock | 4.1693 | 4.1911 | 4.1679 | 4.1789 | 19298328.0 |
> showing 50 of 319,084 rows — these rows as CSV