PREVIEW / stock_5min / 2010-02-16
file: by_date/stock_5min/2010/2010-02-16.parquet size: 4.6 MB rows: 320,398 symbols: 3,469
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-16 04:30:00 | AAPL | Stock | 7.2107 | 7.2107 | 7.2107 | 7.2107 | 14532.0 |
| 2010-02-16 04:35:00 | AAPL | Stock | 7.2143 | 7.2143 | 7.2107 | 7.2107 | 16800.0 |
| 2010-02-16 06:40:00 | AAPL | Stock | 7.1946 | 7.1946 | 7.1929 | 7.1929 | 5600.0 |
| 2010-02-16 07:05:00 | AAPL | Stock | 7.1757 | 7.1757 | 7.1757 | 7.1757 | 5040.0 |
| 2010-02-16 07:20:00 | AAPL | Stock | 7.1821 | 7.1821 | 7.1821 | 7.1821 | 5600.0 |
| 2010-02-16 07:35:00 | AAPL | Stock | 7.1829 | 7.2054 | 7.1829 | 7.2054 | 6104.0 |
| 2010-02-16 07:40:00 | AAPL | Stock | 7.1825 | 7.1825 | 7.1825 | 7.1825 | 5600.0 |
| 2010-02-16 07:45:00 | AAPL | Stock | 7.1893 | 7.1893 | 7.1893 | 7.1893 | 14000.0 |
| 2010-02-16 08:00:00 | AAPL | Stock | 7.1854 | 7.1929 | 7.1846 | 7.1893 | 132804.0 |
| 2010-02-16 08:05:00 | AAPL | Stock | 7.1857 | 7.1925 | 7.1857 | 7.1896 | 84756.0 |
| 2010-02-16 08:10:00 | AAPL | Stock | 7.1879 | 7.1879 | 7.1846 | 7.1846 | 80192.0 |
| 2010-02-16 08:15:00 | AAPL | Stock | 7.1861 | 7.1961 | 7.1861 | 7.1929 | 306040.0 |
| 2010-02-16 08:20:00 | AAPL | Stock | 7.1932 | 7.1996 | 7.1911 | 7.1918 | 236936.0 |
| 2010-02-16 08:25:00 | AAPL | Stock | 7.1925 | 7.1975 | 7.1925 | 7.1936 | 97356.0 |
| 2010-02-16 08:30:00 | AAPL | Stock | 7.1936 | 7.2 | 7.1936 | 7.2 | 84000.0 |
| 2010-02-16 08:35:00 | AAPL | Stock | 7.1996 | 7.1996 | 7.1946 | 7.1964 | 104300.0 |
| 2010-02-16 08:40:00 | AAPL | Stock | 7.1964 | 7.2018 | 7.195 | 7.2018 | 83440.0 |
| 2010-02-16 08:45:00 | AAPL | Stock | 7.2021 | 7.2029 | 7.1993 | 7.2029 | 101136.0 |
| 2010-02-16 08:50:00 | AAPL | Stock | 7.2018 | 7.2036 | 7.1986 | 7.2007 | 129360.0 |
| 2010-02-16 08:55:00 | AAPL | Stock | 7.2 | 7.2064 | 7.2 | 7.2064 | 137900.0 |
| 2010-02-16 09:00:00 | AAPL | Stock | 7.2064 | 7.2089 | 7.2039 | 7.2071 | 302540.0 |
| 2010-02-16 09:05:00 | AAPL | Stock | 7.2075 | 7.2204 | 7.2071 | 7.2154 | 443296.0 |
| 2010-02-16 09:10:00 | AAPL | Stock | 7.215 | 7.2218 | 7.2129 | 7.2204 | 649796.0 |
| 2010-02-16 09:15:00 | AAPL | Stock | 7.2196 | 7.2196 | 7.2121 | 7.2143 | 216272.0 |
| 2010-02-16 09:20:00 | AAPL | Stock | 7.2136 | 7.2143 | 7.2114 | 7.2118 | 110936.0 |
| 2010-02-16 09:25:00 | AAPL | Stock | 7.2111 | 7.22 | 7.2093 | 7.2125 | 704032.0 |
| 2010-02-16 09:30:00 | AAPL | Stock | 7.2125 | 7.2407 | 7.1971 | 7.2342 | 21937944.0 |
| 2010-02-16 09:35:00 | AAPL | Stock | 7.2343 | 7.2374 | 7.2107 | 7.2211 | 16448908.0 |
| 2010-02-16 09:40:00 | AAPL | Stock | 7.2198 | 7.225 | 7.2082 | 7.2161 | 10224508.0 |
| 2010-02-16 09:45:00 | AAPL | Stock | 7.215 | 7.2314 | 7.2089 | 7.2229 | 13050688.0 |
| 2010-02-16 09:50:00 | AAPL | Stock | 7.2243 | 7.2346 | 7.2189 | 7.231 | 8122408.0 |
| 2010-02-16 09:55:00 | AAPL | Stock | 7.2314 | 7.2357 | 7.2214 | 7.2279 | 7189336.0 |
| 2010-02-16 10:00:00 | AAPL | Stock | 7.2279 | 7.2375 | 7.2275 | 7.2311 | 9283260.0 |
| 2010-02-16 10:05:00 | AAPL | Stock | 7.2327 | 7.2375 | 7.23 | 7.2311 | 7172956.0 |
| 2010-02-16 10:10:00 | AAPL | Stock | 7.23 | 7.2332 | 7.2189 | 7.2221 | 7276556.0 |
| 2010-02-16 10:15:00 | AAPL | Stock | 7.2221 | 7.2339 | 7.2143 | 7.2304 | 6868568.0 |
| 2010-02-16 10:20:00 | AAPL | Stock | 7.2304 | 7.2336 | 7.2279 | 7.2304 | 5934628.0 |
| 2010-02-16 10:25:00 | AAPL | Stock | 7.2307 | 7.2361 | 7.2279 | 7.2339 | 5996592.0 |
| 2010-02-16 10:30:00 | AAPL | Stock | 7.2337 | 7.2421 | 7.2304 | 7.2386 | 9445380.0 |
| 2010-02-16 10:35:00 | AAPL | Stock | 7.2389 | 7.2625 | 7.2375 | 7.2607 | 12962544.0 |
| 2010-02-16 10:40:00 | AAPL | Stock | 7.2607 | 7.2668 | 7.2557 | 7.2571 | 9479540.0 |
| 2010-02-16 10:45:00 | AAPL | Stock | 7.2571 | 7.2607 | 7.2536 | 7.2554 | 5186272.0 |
| 2010-02-16 10:50:00 | AAPL | Stock | 7.2557 | 7.2575 | 7.2429 | 7.245 | 7138096.0 |
| 2010-02-16 10:55:00 | AAPL | Stock | 7.245 | 7.2518 | 7.2411 | 7.2436 | 5150152.0 |
| 2010-02-16 11:00:00 | AAPL | Stock | 7.2443 | 7.2482 | 7.2411 | 7.2471 | 4052244.0 |
| 2010-02-16 11:05:00 | AAPL | Stock | 7.2475 | 7.25 | 7.2379 | 7.2425 | 4184320.0 |
| 2010-02-16 11:10:00 | AAPL | Stock | 7.2436 | 7.2461 | 7.2396 | 7.2429 | 3569244.0 |
| 2010-02-16 11:15:00 | AAPL | Stock | 7.2425 | 7.2561 | 7.2421 | 7.255 | 4154500.0 |
| 2010-02-16 11:20:00 | AAPL | Stock | 7.2556 | 7.2607 | 7.2532 | 7.2561 | 5372052.0 |
| 2010-02-16 11:25:00 | AAPL | Stock | 7.2557 | 7.2585 | 7.2514 | 7.2564 | 2931908.0 |
> showing 50 of 320,398 rows — these rows as CSV