PREVIEW / stock_5min / 2008-06-23
file: by_date/stock_5min/2008/2008-06-23.parquet size: 4.4 MB rows: 317,260 symbols: 3,314
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-06-23 07:10:00 | AAPL | Stock | 6.2707 | 6.2707 | 6.2707 | 6.2707 | 6720.0 |
| 2008-06-23 07:25:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 11200.0 |
| 2008-06-23 07:30:00 | AAPL | Stock | 6.2707 | 6.2714 | 6.2696 | 6.2714 | 40880.0 |
| 2008-06-23 07:35:00 | AAPL | Stock | 6.2729 | 6.2729 | 6.2729 | 6.2729 | 2800.0 |
| 2008-06-23 07:40:00 | AAPL | Stock | 6.2732 | 6.2732 | 6.2729 | 6.2729 | 30800.0 |
| 2008-06-23 07:45:00 | AAPL | Stock | 6.2686 | 6.2686 | 6.2671 | 6.2679 | 28000.0 |
| 2008-06-23 07:50:00 | AAPL | Stock | 6.265 | 6.2679 | 6.2629 | 6.2679 | 81200.0 |
| 2008-06-23 07:55:00 | AAPL | Stock | 6.2618 | 6.2618 | 6.2475 | 6.2475 | 118888.0 |
| 2008-06-23 08:00:00 | AAPL | Stock | 6.2564 | 6.2568 | 6.2189 | 6.2411 | 353724.0 |
| 2008-06-23 08:05:00 | AAPL | Stock | 6.2357 | 6.2357 | 6.2214 | 6.2264 | 253064.0 |
| 2008-06-23 08:10:00 | AAPL | Stock | 6.2264 | 6.2411 | 6.2221 | 6.2368 | 330456.0 |
| 2008-06-23 08:15:00 | AAPL | Stock | 6.24 | 6.2536 | 6.2375 | 6.2464 | 386400.0 |
| 2008-06-23 08:20:00 | AAPL | Stock | 6.2496 | 6.2696 | 6.2496 | 6.2607 | 515200.0 |
| 2008-06-23 08:25:00 | AAPL | Stock | 6.2586 | 6.26 | 6.2557 | 6.26 | 54320.0 |
| 2008-06-23 08:30:00 | AAPL | Stock | 6.2554 | 6.2596 | 6.2539 | 6.2596 | 118216.0 |
| 2008-06-23 08:35:00 | AAPL | Stock | 6.2582 | 6.2796 | 6.2554 | 6.2768 | 329952.0 |
| 2008-06-23 08:40:00 | AAPL | Stock | 6.2718 | 6.275 | 6.2696 | 6.2739 | 186732.0 |
| 2008-06-23 08:45:00 | AAPL | Stock | 6.275 | 6.2821 | 6.2746 | 6.28 | 146440.0 |
| 2008-06-23 08:50:00 | AAPL | Stock | 6.28 | 6.28 | 6.2754 | 6.2771 | 127400.0 |
| 2008-06-23 08:55:00 | AAPL | Stock | 6.2775 | 6.2775 | 6.2639 | 6.2668 | 626332.0 |
| 2008-06-23 09:00:00 | AAPL | Stock | 6.2679 | 6.2736 | 6.255 | 6.2554 | 377580.0 |
| 2008-06-23 09:05:00 | AAPL | Stock | 6.2568 | 6.2679 | 6.2511 | 6.2625 | 271656.0 |
| 2008-06-23 09:10:00 | AAPL | Stock | 6.2625 | 6.2707 | 6.2625 | 6.2643 | 268800.0 |
| 2008-06-23 09:15:00 | AAPL | Stock | 6.2636 | 6.2675 | 6.2589 | 6.2675 | 206416.0 |
| 2008-06-23 09:20:00 | AAPL | Stock | 6.2614 | 6.2614 | 6.2411 | 6.2429 | 609280.0 |
| 2008-06-23 09:25:00 | AAPL | Stock | 6.2429 | 6.2429 | 6.2357 | 6.2393 | 283220.0 |
| 2008-06-23 09:30:00 | AAPL | Stock | 6.2393 | 6.25 | 6.1643 | 6.2036 | 27662684.0 |
| 2008-06-23 09:35:00 | AAPL | Stock | 6.2016 | 6.2287 | 6.1786 | 6.1968 | 19977860.0 |
| 2008-06-23 09:40:00 | AAPL | Stock | 6.1954 | 6.2279 | 6.1875 | 6.2168 | 15706404.0 |
| 2008-06-23 09:45:00 | AAPL | Stock | 6.2146 | 6.2429 | 6.1871 | 6.19 | 17601724.0 |
| 2008-06-23 09:50:00 | AAPL | Stock | 6.1893 | 6.2054 | 6.1529 | 6.1771 | 20647144.0 |
| 2008-06-23 09:55:00 | AAPL | Stock | 6.1761 | 6.1771 | 6.1454 | 6.1607 | 14976388.0 |
| 2008-06-23 10:00:00 | AAPL | Stock | 6.1607 | 6.1804 | 6.15 | 6.1629 | 11577888.0 |
| 2008-06-23 10:05:00 | AAPL | Stock | 6.1632 | 6.1871 | 6.1386 | 6.1743 | 14882448.0 |
| 2008-06-23 10:10:00 | AAPL | Stock | 6.1754 | 6.2086 | 6.1661 | 6.2061 | 12153232.0 |
| 2008-06-23 10:15:00 | AAPL | Stock | 6.2061 | 6.2207 | 6.195 | 6.2007 | 10907596.0 |
| 2008-06-23 10:20:00 | AAPL | Stock | 6.1989 | 6.2093 | 6.1779 | 6.2061 | 8976240.0 |
| 2008-06-23 10:25:00 | AAPL | Stock | 6.2039 | 6.2179 | 6.1954 | 6.2007 | 7675780.0 |
| 2008-06-23 10:30:00 | AAPL | Stock | 6.2004 | 6.2282 | 6.1979 | 6.2233 | 8006712.0 |
| 2008-06-23 10:35:00 | AAPL | Stock | 6.2232 | 6.2243 | 6.1996 | 6.2018 | 5937708.0 |
| 2008-06-23 10:40:00 | AAPL | Stock | 6.2025 | 6.2232 | 6.1814 | 6.1818 | 7112868.0 |
| 2008-06-23 10:45:00 | AAPL | Stock | 6.1825 | 6.1986 | 6.1786 | 6.1832 | 6591788.0 |
| 2008-06-23 10:50:00 | AAPL | Stock | 6.1836 | 6.1836 | 6.1514 | 6.1611 | 10054380.0 |
| 2008-06-23 10:55:00 | AAPL | Stock | 6.1611 | 6.1714 | 6.1564 | 6.1686 | 7278964.0 |
| 2008-06-23 11:00:00 | AAPL | Stock | 6.1687 | 6.1782 | 6.1625 | 6.1721 | 4881576.0 |
| 2008-06-23 11:05:00 | AAPL | Stock | 6.1721 | 6.1786 | 6.1625 | 6.1718 | 4735080.0 |
| 2008-06-23 11:10:00 | AAPL | Stock | 6.1734 | 6.1742 | 6.1532 | 6.16 | 6802964.0 |
| 2008-06-23 11:15:00 | AAPL | Stock | 6.1584 | 6.1661 | 6.1271 | 6.1303 | 10897628.0 |
| 2008-06-23 11:20:00 | AAPL | Stock | 6.1296 | 6.15 | 6.1286 | 6.1354 | 8504804.0 |
| 2008-06-23 11:25:00 | AAPL | Stock | 6.1343 | 6.16 | 6.1321 | 6.1571 | 6667976.0 |
> showing 50 of 317,260 rows — these rows as CSV