PREVIEW / stock_30min / 2009-02-26
file: by_date/stock_30min/2009/2009-02-26.parquet size: 1.2 MB rows: 68,275 symbols: 3,304
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-26 06:30:00 | AAPL | Stock | 3.2918 | 3.2918 | 3.2918 | 3.2918 | 16800.0 |
| 2009-02-26 07:00:00 | AAPL | Stock | 3.2936 | 3.2936 | 3.2857 | 3.2857 | 50400.0 |
| 2009-02-26 07:30:00 | AAPL | Stock | 3.2854 | 3.2946 | 3.2854 | 3.2946 | 148260.0 |
| 2009-02-26 08:00:00 | AAPL | Stock | 3.2946 | 3.2964 | 3.2814 | 3.285 | 240268.0 |
| 2009-02-26 08:30:00 | AAPL | Stock | 3.285 | 3.2932 | 3.2718 | 3.2843 | 285124.0 |
| 2009-02-26 09:00:00 | AAPL | Stock | 3.2857 | 3.2932 | 3.2679 | 3.2857 | 729736.0 |
| 2009-02-26 09:30:00 | AAPL | Stock | 3.2821 | 3.2975 | 3.2343 | 3.2564 | 70699804.0 |
| 2009-02-26 10:00:00 | AAPL | Stock | 3.2571 | 3.2921 | 3.25 | 3.2821 | 49812196.0 |
| 2009-02-26 10:30:00 | AAPL | Stock | 3.2818 | 3.3186 | 3.2701 | 3.3161 | 49496972.0 |
| 2009-02-26 11:00:00 | AAPL | Stock | 3.3157 | 3.3186 | 3.2786 | 3.28 | 46449312.0 |
| 2009-02-26 11:30:00 | AAPL | Stock | 3.2793 | 3.2882 | 3.2568 | 3.2807 | 29195796.0 |
| 2009-02-26 12:00:00 | AAPL | Stock | 3.2807 | 3.2918 | 3.2529 | 3.2582 | 25060672.0 |
| 2009-02-26 12:30:00 | AAPL | Stock | 3.2589 | 3.2668 | 3.2429 | 3.2471 | 29233428.0 |
| 2009-02-26 13:00:00 | AAPL | Stock | 3.2471 | 3.25 | 3.2171 | 3.245 | 43647100.0 |
| 2009-02-26 13:30:00 | AAPL | Stock | 3.2454 | 3.2557 | 3.23 | 3.2421 | 34486900.0 |
| 2009-02-26 14:00:00 | AAPL | Stock | 3.2418 | 3.2554 | 3.2304 | 3.2529 | 28728448.0 |
| 2009-02-26 14:30:00 | AAPL | Stock | 3.2529 | 3.2532 | 3.2036 | 3.2114 | 42426692.0 |
| 2009-02-26 15:00:00 | AAPL | Stock | 3.2121 | 3.2139 | 3.1771 | 3.1975 | 64844136.0 |
| 2009-02-26 15:30:00 | AAPL | Stock | 3.1975 | 3.2164 | 3.1793 | 3.1793 | 71248996.0 |
| 2009-02-26 16:00:00 | AAPL | Stock | 3.1804 | 3.2492 | 3.1429 | 3.1864 | 15996204.0 |
| 2009-02-26 16:30:00 | AAPL | Stock | 3.1854 | 3.2374 | 3.1807 | 3.1854 | 12769260.0 |
| 2009-02-26 17:00:00 | AAPL | Stock | 3.1857 | 3.2526 | 3.1854 | 3.2526 | 29260.0 |
| 2009-02-26 17:30:00 | AAPL | Stock | 3.2646 | 3.2646 | 3.1818 | 3.1821 | 170772.0 |
| 2009-02-26 18:00:00 | AAPL | Stock | 3.1854 | 3.1854 | 3.1786 | 3.1786 | 12645276.0 |
| 2009-02-26 18:30:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1714 | 3.1714 | 31248.0 |
| 2009-02-26 19:00:00 | AAPL | Stock | 3.1807 | 3.1807 | 3.1721 | 3.1721 | 46200.0 |
| 2009-02-26 19:30:00 | AAPL | Stock | 3.1725 | 3.1775 | 3.1725 | 3.1732 | 110992.0 |
| 2009-02-26 08:00:00 | MSFT | Stock | 17.1 | 17.15 | 17.1 | 17.1 | 17660.0 |
| 2009-02-26 08:30:00 | MSFT | Stock | 17.07 | 17.09 | 17.03 | 17.08 | 37476.0 |
| 2009-02-26 09:00:00 | MSFT | Stock | 17.08 | 17.15 | 16.82 | 17.05 | 76484.0 |
| 2009-02-26 09:30:00 | MSFT | Stock | 17.05 | 17.08 | 16.63 | 16.725 | 7252364.0 |
| 2009-02-26 10:00:00 | MSFT | Stock | 16.72 | 16.77 | 16.65 | 16.74 | 5487131.0 |
| 2009-02-26 10:30:00 | MSFT | Stock | 16.75 | 16.96 | 16.72 | 16.79 | 6527283.0 |
| 2009-02-26 11:00:00 | MSFT | Stock | 16.79 | 16.8 | 16.58 | 16.592 | 4223242.0 |
| 2009-02-26 11:30:00 | MSFT | Stock | 16.59 | 16.63 | 16.52 | 16.63 | 3985326.0 |
| 2009-02-26 12:00:00 | MSFT | Stock | 16.63 | 16.69 | 16.52 | 16.57 | 3045340.0 |
| 2009-02-26 12:30:00 | MSFT | Stock | 16.57 | 16.657 | 16.55 | 16.59 | 2468513.0 |
| 2009-02-26 13:00:00 | MSFT | Stock | 16.59 | 16.69 | 16.53 | 16.67 | 3851966.0 |
| 2009-02-26 13:30:00 | MSFT | Stock | 16.67 | 16.77 | 16.66 | 16.683 | 3050300.0 |
| 2009-02-26 14:00:00 | MSFT | Stock | 16.68 | 16.82 | 16.65 | 16.791 | 6126278.0 |
| 2009-02-26 14:30:00 | MSFT | Stock | 16.79 | 16.88 | 16.62 | 16.63 | 10383030.0 |
| 2009-02-26 15:00:00 | MSFT | Stock | 16.63 | 16.68 | 16.55 | 16.572 | 10566769.0 |
| 2009-02-26 15:30:00 | MSFT | Stock | 16.57 | 16.63 | 16.43 | 16.43 | 11654923.0 |
| 2009-02-26 16:00:00 | MSFT | Stock | 16.43 | 16.712 | 16.39 | 16.39 | 2775115.0 |
| 2009-02-26 16:30:00 | MSFT | Stock | 16.4 | 16.637 | 16.4 | 16.42 | 281989.0 |
| 2009-02-26 17:00:00 | MSFT | Stock | 16.41 | 16.621 | 16.4 | 16.45 | 25110.0 |
| 2009-02-26 17:30:00 | MSFT | Stock | 16.45 | 16.46 | 16.45 | 16.45 | 6700.0 |
| 2009-02-26 18:00:00 | MSFT | Stock | 16.45 | 16.45 | 16.42 | 16.42 | 5560.0 |
| 2009-02-26 18:30:00 | MSFT | Stock | 16.45 | 16.48 | 16.43 | 16.43 | 4602.0 |
| 2009-02-26 19:00:00 | MSFT | Stock | 16.43 | 16.48 | 16.43 | 16.45 | 3602.0 |
> showing 50 of 68,275 rows — these rows as CSV