PREVIEW / stock_30min / 2008-09-29
file: by_date/stock_30min/2008/2008-09-29.parquet size: 1.4 MB rows: 77,215 symbols: 3,378
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-09-29 06:00:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4464 | 4.4464 | 22400.0 |
| 2008-09-29 06:30:00 | AAPL | Stock | 4.4171 | 4.4171 | 4.3571 | 4.3571 | 76832.0 |
| 2008-09-29 07:00:00 | AAPL | Stock | 4.3396 | 4.3418 | 4.2854 | 4.3179 | 1435056.0 |
| 2008-09-29 07:30:00 | AAPL | Stock | 4.3196 | 4.3396 | 4.2854 | 4.3 | 1055992.0 |
| 2008-09-29 08:00:00 | AAPL | Stock | 4.3054 | 4.3571 | 4.2857 | 4.3218 | 4723824.0 |
| 2008-09-29 08:30:00 | AAPL | Stock | 4.3221 | 4.3482 | 4.3071 | 4.3161 | 3622668.0 |
| 2008-09-29 09:00:00 | AAPL | Stock | 4.3182 | 4.3304 | 4.2321 | 4.275 | 12134892.0 |
| 2008-09-29 09:30:00 | AAPL | Stock | 4.275 | 4.275 | 3.8929 | 3.9911 | 402143532.0 |
| 2008-09-29 10:00:00 | AAPL | Stock | 3.9907 | 4.0193 | 3.8043 | 3.8193 | 331423988.0 |
| 2008-09-29 10:30:00 | AAPL | Stock | 3.8186 | 3.9363 | 3.7775 | 3.9179 | 220511452.0 |
| 2008-09-29 11:00:00 | AAPL | Stock | 3.9141 | 4.0 | 3.8875 | 3.9921 | 177180612.0 |
| 2008-09-29 11:30:00 | AAPL | Stock | 3.9925 | 3.9982 | 3.9214 | 3.9314 | 132997928.0 |
| 2008-09-29 12:00:00 | AAPL | Stock | 3.9314 | 3.9707 | 3.9068 | 3.9554 | 109950988.0 |
| 2008-09-29 12:30:00 | AAPL | Stock | 3.955 | 3.9807 | 3.9214 | 3.9643 | 88263756.0 |
| 2008-09-29 13:00:00 | AAPL | Stock | 3.9643 | 4.0 | 3.9286 | 3.9882 | 70388332.0 |
| 2008-09-29 13:30:00 | AAPL | Stock | 3.9875 | 4.0121 | 3.5925 | 3.7946 | 271728296.0 |
| 2008-09-29 14:00:00 | AAPL | Stock | 3.7946 | 3.9068 | 3.7118 | 3.8186 | 207904508.0 |
| 2008-09-29 14:30:00 | AAPL | Stock | 3.8194 | 3.8407 | 3.7489 | 3.7521 | 118964412.0 |
| 2008-09-29 15:00:00 | AAPL | Stock | 3.7518 | 3.7929 | 3.6814 | 3.7036 | 152109076.0 |
| 2008-09-29 15:30:00 | AAPL | Stock | 3.7046 | 3.8575 | 3.67 | 3.7814 | 214124680.0 |
| 2008-09-29 16:00:00 | AAPL | Stock | 3.7821 | 3.9002 | 3.7593 | 3.7736 | 51722944.0 |
| 2008-09-29 16:30:00 | AAPL | Stock | 3.7593 | 3.9067 | 3.75 | 3.75 | 2525628.0 |
| 2008-09-29 17:00:00 | AAPL | Stock | 3.7593 | 3.7593 | 3.7139 | 3.7304 | 9139760.0 |
| 2008-09-29 17:30:00 | AAPL | Stock | 3.7318 | 3.7593 | 3.7218 | 3.725 | 490140.0 |
| 2008-09-29 18:00:00 | AAPL | Stock | 3.725 | 3.7339 | 3.7143 | 3.7286 | 764344.0 |
| 2008-09-29 18:30:00 | AAPL | Stock | 3.7214 | 3.7279 | 3.7143 | 3.7143 | 356832.0 |
| 2008-09-29 19:00:00 | AAPL | Stock | 3.7143 | 3.7225 | 3.6964 | 3.7007 | 385616.0 |
| 2008-09-29 19:30:00 | AAPL | Stock | 3.7071 | 3.715 | 3.6929 | 3.6929 | 521920.0 |
| 2008-09-29 07:00:00 | MSFT | Stock | 26.95 | 27.1 | 26.77 | 26.77 | 2900.0 |
| 2008-09-29 07:30:00 | MSFT | Stock | 27.0 | 27.0 | 26.8 | 27.0 | 5050.0 |
| 2008-09-29 08:00:00 | MSFT | Stock | 26.93 | 27.05 | 26.91 | 26.97 | 14310.0 |
| 2008-09-29 08:30:00 | MSFT | Stock | 26.96 | 27.04 | 26.95 | 27.0 | 7029.0 |
| 2008-09-29 09:00:00 | MSFT | Stock | 27.0 | 27.4 | 26.82 | 26.88 | 91054.0 |
| 2008-09-29 09:30:00 | MSFT | Stock | 26.87 | 27.66 | 26.75 | 26.88 | 10154111.0 |
| 2008-09-29 10:00:00 | MSFT | Stock | 26.87 | 26.95 | 26.47 | 26.871 | 11062207.0 |
| 2008-09-29 10:30:00 | MSFT | Stock | 26.88 | 26.95 | 26.65 | 26.882 | 5806156.0 |
| 2008-09-29 11:00:00 | MSFT | Stock | 26.88 | 26.91 | 26.71 | 26.725 | 5469175.0 |
| 2008-09-29 11:30:00 | MSFT | Stock | 26.74 | 26.79 | 26.6 | 26.71 | 5148564.0 |
| 2008-09-29 12:00:00 | MSFT | Stock | 26.71 | 26.79 | 26.65 | 26.71 | 5057625.0 |
| 2008-09-29 12:30:00 | MSFT | Stock | 26.71 | 26.86 | 26.6 | 26.72 | 5109598.0 |
| 2008-09-29 13:00:00 | MSFT | Stock | 26.73 | 26.92 | 26.6 | 26.87 | 4343373.0 |
| 2008-09-29 13:30:00 | MSFT | Stock | 26.86 | 26.875 | 25.66 | 26.16 | 14389622.0 |
| 2008-09-29 14:00:00 | MSFT | Stock | 26.17 | 26.52 | 25.5 | 26.12 | 14440101.0 |
| 2008-09-29 14:30:00 | MSFT | Stock | 26.13 | 26.21 | 25.5 | 25.88 | 9411502.0 |
| 2008-09-29 15:00:00 | MSFT | Stock | 25.88 | 26.07 | 25.6 | 25.69 | 7540204.0 |
| 2008-09-29 15:30:00 | MSFT | Stock | 25.67 | 26.55 | 25.61 | 25.85 | 18406085.0 |
| 2008-09-29 16:00:00 | MSFT | Stock | 25.84 | 26.4 | 25.0 | 26.135 | 15569416.0 |
| 2008-09-29 16:30:00 | MSFT | Stock | 25.23 | 25.3 | 25.01 | 25.01 | 878997.0 |
| 2008-09-29 17:00:00 | MSFT | Stock | 25.25 | 26.172 | 25.01 | 25.3 | 63009.0 |
| 2008-09-29 17:30:00 | MSFT | Stock | 25.2 | 25.4 | 25.01 | 25.29 | 11343.0 |
> showing 50 of 77,215 rows — these rows as CSV