PREVIEW / stock_30min / 2008-04-14
file: by_date/stock_30min/2008/2008-04-14.parquet size: 1.2 MB rows: 68,691 symbols: 3,308
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-04-14 06:00:00 | AAPL | Stock | 5.2418 | 5.2721 | 5.2418 | 5.2721 | 35700.0 |
| 2008-04-14 06:30:00 | AAPL | Stock | 5.2386 | 5.2386 | 5.2386 | 5.2386 | 2800.0 |
| 2008-04-14 07:00:00 | AAPL | Stock | 5.23 | 5.2475 | 5.23 | 5.2464 | 67900.0 |
| 2008-04-14 07:30:00 | AAPL | Stock | 5.2464 | 5.2464 | 5.2236 | 5.2321 | 107100.0 |
| 2008-04-14 08:00:00 | AAPL | Stock | 5.2289 | 5.2314 | 5.1989 | 5.2071 | 1400420.0 |
| 2008-04-14 08:30:00 | AAPL | Stock | 5.2068 | 5.2432 | 5.2054 | 5.2357 | 2617272.0 |
| 2008-04-14 09:00:00 | AAPL | Stock | 5.2361 | 5.2568 | 5.2214 | 5.2429 | 2454760.0 |
| 2008-04-14 09:30:00 | AAPL | Stock | 5.2414 | 5.2736 | 5.1621 | 5.1979 | 158789260.0 |
| 2008-04-14 10:00:00 | AAPL | Stock | 5.1989 | 5.2707 | 5.1893 | 5.2593 | 107865688.0 |
| 2008-04-14 10:30:00 | AAPL | Stock | 5.2604 | 5.3029 | 5.2557 | 5.2946 | 78998304.0 |
| 2008-04-14 11:00:00 | AAPL | Stock | 5.2954 | 5.3136 | 5.2718 | 5.2793 | 61574716.0 |
| 2008-04-14 11:30:00 | AAPL | Stock | 5.28 | 5.2939 | 5.2621 | 5.2929 | 43152228.0 |
| 2008-04-14 12:00:00 | AAPL | Stock | 5.2932 | 5.3193 | 5.2875 | 5.3182 | 45619504.0 |
| 2008-04-14 12:30:00 | AAPL | Stock | 5.3179 | 5.3304 | 5.3011 | 5.3193 | 44270380.0 |
| 2008-04-14 13:00:00 | AAPL | Stock | 5.3193 | 5.3214 | 5.2921 | 5.3039 | 37950332.0 |
| 2008-04-14 13:30:00 | AAPL | Stock | 5.3036 | 5.3036 | 5.2664 | 5.2744 | 43133300.0 |
| 2008-04-14 14:00:00 | AAPL | Stock | 5.2729 | 5.2982 | 5.2614 | 5.2907 | 52710252.0 |
| 2008-04-14 14:30:00 | AAPL | Stock | 5.2911 | 5.3054 | 5.2686 | 5.2704 | 40616912.0 |
| 2008-04-14 15:00:00 | AAPL | Stock | 5.27 | 5.2814 | 5.2532 | 5.2625 | 49531300.0 |
| 2008-04-14 15:30:00 | AAPL | Stock | 5.2629 | 5.2896 | 5.2589 | 5.2786 | 53529588.0 |
| 2008-04-14 16:00:00 | AAPL | Stock | 5.2789 | 5.28 | 5.2554 | 5.28 | 14020776.0 |
| 2008-04-14 16:30:00 | AAPL | Stock | 5.2804 | 5.2814 | 5.2779 | 5.2786 | 543452.0 |
| 2008-04-14 17:00:00 | AAPL | Stock | 5.2786 | 5.2804 | 5.2779 | 5.2786 | 186564.0 |
| 2008-04-14 17:30:00 | AAPL | Stock | 5.2786 | 5.2804 | 5.2771 | 5.2771 | 42252.0 |
| 2008-04-14 18:00:00 | AAPL | Stock | 5.2786 | 5.2804 | 5.275 | 5.275 | 85092.0 |
| 2008-04-14 18:30:00 | AAPL | Stock | 5.28 | 5.28 | 5.2754 | 5.2754 | 8400.0 |
| 2008-04-14 19:00:00 | AAPL | Stock | 5.2782 | 5.28 | 5.2782 | 5.28 | 30240.0 |
| 2008-04-14 19:30:00 | AAPL | Stock | 5.2782 | 5.2821 | 5.2754 | 5.2814 | 161364.0 |
| 2008-04-14 08:00:00 | MSFT | Stock | 28.35 | 28.35 | 28.25 | 28.25 | 9141.0 |
| 2008-04-14 08:30:00 | MSFT | Stock | 28.25 | 28.38 | 28.25 | 28.3 | 2771.0 |
| 2008-04-14 09:00:00 | MSFT | Stock | 28.3 | 28.3 | 28.2 | 28.22 | 22939.0 |
| 2008-04-14 09:30:00 | MSFT | Stock | 28.23 | 28.31 | 28.16 | 28.22 | 3740976.0 |
| 2008-04-14 10:00:00 | MSFT | Stock | 28.23 | 28.3 | 28.03 | 28.04 | 3069500.0 |
| 2008-04-14 10:30:00 | MSFT | Stock | 28.04 | 28.3 | 28.01 | 28.178 | 2108849.0 |
| 2008-04-14 11:00:00 | MSFT | Stock | 28.18 | 28.22 | 28.0 | 28.03 | 2900322.0 |
| 2008-04-14 11:30:00 | MSFT | Stock | 28.03 | 28.06 | 27.93 | 28.06 | 3362371.0 |
| 2008-04-14 12:00:00 | MSFT | Stock | 28.055 | 28.19 | 28.04 | 28.18 | 2038172.0 |
| 2008-04-14 12:30:00 | MSFT | Stock | 28.178 | 28.3 | 28.12 | 28.29 | 2403002.0 |
| 2008-04-14 13:00:00 | MSFT | Stock | 28.29 | 28.3 | 28.17 | 28.24 | 2084942.0 |
| 2008-04-14 13:30:00 | MSFT | Stock | 28.24 | 28.28 | 28.21 | 28.24 | 1833979.0 |
| 2008-04-14 14:00:00 | MSFT | Stock | 28.24 | 28.25 | 28.14 | 28.17 | 2593454.0 |
| 2008-04-14 14:30:00 | MSFT | Stock | 28.17 | 28.26 | 28.15 | 28.17 | 2013391.0 |
| 2008-04-14 15:00:00 | MSFT | Stock | 28.175 | 28.2 | 28.09 | 28.15 | 2623405.0 |
| 2008-04-14 15:30:00 | MSFT | Stock | 28.16 | 28.25 | 28.05 | 28.06 | 4651559.0 |
| 2008-04-14 16:00:00 | MSFT | Stock | 28.05 | 28.292 | 28.02 | 28.082 | 6450655.0 |
| 2008-04-14 16:30:00 | MSFT | Stock | 28.06 | 28.06 | 28.06 | 28.06 | 12891.0 |
| 2008-04-14 17:00:00 | MSFT | Stock | 28.08 | 28.08 | 28.06 | 28.06 | 600.0 |
| 2008-04-14 17:30:00 | MSFT | Stock | 28.06 | 28.09 | 28.06 | 28.09 | 5150.0 |
| 2008-04-14 18:00:00 | MSFT | Stock | 28.09 | 28.09 | 28.06 | 28.09 | 51218.0 |
| 2008-04-14 18:30:00 | MSFT | Stock | 28.06 | 28.06 | 28.06 | 28.06 | 2245.0 |
> showing 50 of 68,691 rows — these rows as CSV