PREVIEW / stock_5min / 2010-05-28
file: by_date/stock_5min/2010/2010-05-28.parquet size: 4.8 MB rows: 329,740 symbols: 3,462
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-05-28 04:25:00 | AAPL | Stock | 9.1468 | 9.1468 | 9.1468 | 9.1468 | 14000.0 |
| 2010-05-28 04:30:00 | AAPL | Stock | 9.1618 | 9.1618 | 9.1618 | 9.1618 | 2800.0 |
| 2010-05-28 04:40:00 | AAPL | Stock | 9.1879 | 9.1879 | 9.1879 | 9.1879 | 2800.0 |
| 2010-05-28 04:45:00 | AAPL | Stock | 9.1857 | 9.1857 | 9.1857 | 9.1857 | 2800.0 |
| 2010-05-28 06:15:00 | AAPL | Stock | 9.1857 | 9.1857 | 9.1786 | 9.1786 | 5600.0 |
| 2010-05-28 06:20:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 2800.0 |
| 2010-05-28 06:25:00 | AAPL | Stock | 9.2075 | 9.2075 | 9.1821 | 9.1821 | 44800.0 |
| 2010-05-28 06:30:00 | AAPL | Stock | 9.1821 | 9.1821 | 9.175 | 9.1786 | 71876.0 |
| 2010-05-28 06:35:00 | AAPL | Stock | 9.1714 | 9.1714 | 9.1714 | 9.1714 | 11200.0 |
| 2010-05-28 06:45:00 | AAPL | Stock | 9.1704 | 9.1704 | 9.1704 | 9.1704 | 2800.0 |
| 2010-05-28 06:50:00 | AAPL | Stock | 9.1696 | 9.1696 | 9.1696 | 9.1696 | 2800.0 |
| 2010-05-28 06:55:00 | AAPL | Stock | 9.1689 | 9.1689 | 9.1689 | 9.1689 | 9520.0 |
| 2010-05-28 07:00:00 | AAPL | Stock | 9.1693 | 9.1857 | 9.1693 | 9.1786 | 293636.0 |
| 2010-05-28 07:05:00 | AAPL | Stock | 9.1857 | 9.1925 | 9.175 | 9.175 | 124152.0 |
| 2010-05-28 07:10:00 | AAPL | Stock | 9.1786 | 9.2129 | 9.1786 | 9.2114 | 137900.0 |
| 2010-05-28 07:15:00 | AAPL | Stock | 9.2132 | 9.2132 | 9.2 | 9.2107 | 50400.0 |
| 2010-05-28 07:20:00 | AAPL | Stock | 9.1971 | 9.2129 | 9.1971 | 9.2129 | 11200.0 |
| 2010-05-28 07:25:00 | AAPL | Stock | 9.2104 | 9.2104 | 9.1946 | 9.2036 | 23800.0 |
| 2010-05-28 07:30:00 | AAPL | Stock | 9.1939 | 9.21 | 9.1796 | 9.2096 | 95480.0 |
| 2010-05-28 07:35:00 | AAPL | Stock | 9.1968 | 9.2071 | 9.1968 | 9.2064 | 21000.0 |
| 2010-05-28 07:40:00 | AAPL | Stock | 9.1986 | 9.2086 | 9.1986 | 9.2057 | 55720.0 |
| 2010-05-28 07:45:00 | AAPL | Stock | 9.2107 | 9.225 | 9.2071 | 9.2196 | 235200.0 |
| 2010-05-28 07:50:00 | AAPL | Stock | 9.2243 | 9.2243 | 9.2139 | 9.22 | 62160.0 |
| 2010-05-28 07:55:00 | AAPL | Stock | 9.2121 | 9.2143 | 9.1964 | 9.2075 | 140700.0 |
| 2010-05-28 08:00:00 | AAPL | Stock | 9.2125 | 9.2357 | 9.1996 | 9.2357 | 1056748.0 |
| 2010-05-28 08:05:00 | AAPL | Stock | 9.2354 | 9.2561 | 9.2354 | 9.2507 | 1771840.0 |
| 2010-05-28 08:10:00 | AAPL | Stock | 9.2518 | 9.2546 | 9.245 | 9.2536 | 1109080.0 |
| 2010-05-28 08:15:00 | AAPL | Stock | 9.2539 | 9.2639 | 9.2514 | 9.2604 | 1544564.0 |
| 2010-05-28 08:20:00 | AAPL | Stock | 9.2611 | 9.2768 | 9.2582 | 9.2711 | 1438948.0 |
| 2010-05-28 08:25:00 | AAPL | Stock | 9.2696 | 9.275 | 9.2557 | 9.2679 | 1119692.0 |
| 2010-05-28 08:30:00 | AAPL | Stock | 9.2636 | 9.2636 | 9.2436 | 9.2511 | 999628.0 |
| 2010-05-28 08:35:00 | AAPL | Stock | 9.2554 | 9.2618 | 9.2432 | 9.25 | 807548.0 |
| 2010-05-28 08:40:00 | AAPL | Stock | 9.25 | 9.2539 | 9.2321 | 9.2421 | 851228.0 |
| 2010-05-28 08:45:00 | AAPL | Stock | 9.2418 | 9.2418 | 9.2321 | 9.2371 | 780920.0 |
| 2010-05-28 08:50:00 | AAPL | Stock | 9.24 | 9.2464 | 9.2382 | 9.2446 | 821240.0 |
| 2010-05-28 08:55:00 | AAPL | Stock | 9.2457 | 9.25 | 9.2443 | 9.2461 | 568792.0 |
| 2010-05-28 09:00:00 | AAPL | Stock | 9.2479 | 9.2554 | 9.2411 | 9.2446 | 911176.0 |
| 2010-05-28 09:05:00 | AAPL | Stock | 9.2443 | 9.2443 | 9.2357 | 9.2393 | 467600.0 |
| 2010-05-28 09:10:00 | AAPL | Stock | 9.2382 | 9.2457 | 9.2364 | 9.2457 | 417844.0 |
| 2010-05-28 09:15:00 | AAPL | Stock | 9.2432 | 9.2486 | 9.2429 | 9.2464 | 494256.0 |
| 2010-05-28 09:20:00 | AAPL | Stock | 9.2471 | 9.2571 | 9.2414 | 9.2464 | 889672.0 |
| 2010-05-28 09:25:00 | AAPL | Stock | 9.2468 | 9.2632 | 9.2464 | 9.2625 | 918764.0 |
| 2010-05-28 09:30:00 | AAPL | Stock | 9.26 | 9.2643 | 9.2025 | 9.2032 | 38325728.0 |
| 2010-05-28 09:35:00 | AAPL | Stock | 9.2032 | 9.2143 | 9.1571 | 9.1914 | 29543248.0 |
| 2010-05-28 09:40:00 | AAPL | Stock | 9.1904 | 9.2032 | 9.1575 | 9.1599 | 18488092.0 |
| 2010-05-28 09:45:00 | AAPL | Stock | 9.1596 | 9.2046 | 9.15 | 9.195 | 18331740.0 |
| 2010-05-28 09:50:00 | AAPL | Stock | 9.1964 | 9.2007 | 9.1857 | 9.1995 | 10968412.0 |
| 2010-05-28 09:55:00 | AAPL | Stock | 9.2011 | 9.2193 | 9.1861 | 9.208 | 14328048.0 |
| 2010-05-28 10:00:00 | AAPL | Stock | 9.2107 | 9.2196 | 9.2018 | 9.2071 | 12159336.0 |
| 2010-05-28 10:05:00 | AAPL | Stock | 9.2071 | 9.2318 | 9.2007 | 9.2204 | 11826444.0 |
> showing 50 of 329,740 rows — these rows as CSV