PREVIEW / stock_30min / 2007-11-30
file: by_date/stock_30min/2007/2007-11-30.parquet size: 1.3 MB rows: 71,599 symbols: 3,229
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-30 04:00:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 2800.0 |
| 2007-11-30 04:30:00 | AAPL | Stock | 6.6871 | 6.7029 | 6.665 | 6.7029 | 14000.0 |
| 2007-11-30 05:00:00 | AAPL | Stock | 6.7036 | 6.7036 | 6.6975 | 6.6975 | 5600.0 |
| 2007-11-30 05:30:00 | AAPL | Stock | 6.6975 | 6.7086 | 6.6579 | 6.6579 | 96852.0 |
| 2007-11-30 06:00:00 | AAPL | Stock | 6.6704 | 6.6704 | 6.6704 | 6.6704 | 11200.0 |
| 2007-11-30 06:30:00 | AAPL | Stock | 6.6704 | 6.6704 | 6.6521 | 6.6521 | 64792.0 |
| 2007-11-30 07:00:00 | AAPL | Stock | 6.6554 | 6.7139 | 6.6554 | 6.6979 | 1144192.0 |
| 2007-11-30 07:30:00 | AAPL | Stock | 6.6896 | 6.725 | 6.6821 | 6.6971 | 1178072.0 |
| 2007-11-30 08:00:00 | AAPL | Stock | 6.6964 | 6.7089 | 6.6718 | 6.6968 | 6079920.0 |
| 2007-11-30 08:30:00 | AAPL | Stock | 6.6896 | 6.7036 | 6.6893 | 6.6964 | 3368624.0 |
| 2007-11-30 09:00:00 | AAPL | Stock | 6.6964 | 6.7018 | 6.6771 | 6.6939 | 3799460.0 |
| 2007-11-30 09:30:00 | AAPL | Stock | 6.6921 | 6.7036 | 6.6607 | 6.6846 | 169552236.0 |
| 2007-11-30 10:00:00 | AAPL | Stock | 6.685 | 6.6975 | 6.5804 | 6.62 | 160457500.0 |
| 2007-11-30 10:30:00 | AAPL | Stock | 6.6204 | 6.6543 | 6.5893 | 6.6111 | 84403956.0 |
| 2007-11-30 11:00:00 | AAPL | Stock | 6.6121 | 6.6139 | 6.4557 | 6.4857 | 144089428.0 |
| 2007-11-30 11:30:00 | AAPL | Stock | 6.4857 | 6.5271 | 6.4393 | 6.5254 | 98018564.0 |
| 2007-11-30 12:00:00 | AAPL | Stock | 6.5257 | 6.5268 | 6.4582 | 6.4868 | 55423676.0 |
| 2007-11-30 12:30:00 | AAPL | Stock | 6.4864 | 6.5429 | 6.4821 | 6.5386 | 46465048.0 |
| 2007-11-30 13:00:00 | AAPL | Stock | 6.5393 | 6.5429 | 6.4825 | 6.5154 | 46515588.0 |
| 2007-11-30 13:30:00 | AAPL | Stock | 6.5143 | 6.5464 | 6.505 | 6.5218 | 36823976.0 |
| 2007-11-30 14:00:00 | AAPL | Stock | 6.5193 | 6.535 | 6.4968 | 6.5174 | 39675048.0 |
| 2007-11-30 14:30:00 | AAPL | Stock | 6.5161 | 6.5239 | 6.4829 | 6.5004 | 51602824.0 |
| 2007-11-30 15:00:00 | AAPL | Stock | 6.4989 | 6.505 | 6.4179 | 6.4686 | 107735992.0 |
| 2007-11-30 15:30:00 | AAPL | Stock | 6.4686 | 6.5071 | 6.4529 | 6.5054 | 100265340.0 |
| 2007-11-30 16:00:00 | AAPL | Stock | 6.5021 | 6.5529 | 6.4964 | 6.5143 | 24142356.0 |
| 2007-11-30 16:30:00 | AAPL | Stock | 6.5079 | 6.5555 | 6.5066 | 6.5204 | 5081692.0 |
| 2007-11-30 17:00:00 | AAPL | Stock | 6.5196 | 6.5818 | 6.5079 | 6.5139 | 2187836.0 |
| 2007-11-30 17:30:00 | AAPL | Stock | 6.5096 | 6.5232 | 6.5096 | 6.5171 | 225260.0 |
| 2007-11-30 18:00:00 | AAPL | Stock | 6.5168 | 6.5196 | 6.5079 | 6.5179 | 312368.0 |
| 2007-11-30 18:30:00 | AAPL | Stock | 6.5164 | 6.5164 | 6.5089 | 6.5143 | 31976.0 |
| 2007-11-30 19:00:00 | AAPL | Stock | 6.5143 | 6.5225 | 6.5143 | 6.5161 | 64764.0 |
| 2007-11-30 19:30:00 | AAPL | Stock | 6.5211 | 6.5225 | 6.5143 | 6.5143 | 178584.0 |
| 2007-11-30 05:00:00 | MSFT | Stock | 33.77 | 33.77 | 33.77 | 33.77 | 100.0 |
| 2007-11-30 07:00:00 | MSFT | Stock | 33.87 | 33.91 | 33.84 | 33.91 | 10050.0 |
| 2007-11-30 07:30:00 | MSFT | Stock | 33.88 | 33.9 | 33.84 | 33.9 | 10550.0 |
| 2007-11-30 08:00:00 | MSFT | Stock | 33.91 | 33.99 | 33.82 | 33.9 | 30030.0 |
| 2007-11-30 08:30:00 | MSFT | Stock | 33.92 | 33.92 | 33.59 | 33.9 | 159718.0 |
| 2007-11-30 09:00:00 | MSFT | Stock | 33.91 | 34.0 | 33.88 | 33.9 | 167360.0 |
| 2007-11-30 09:30:00 | MSFT | Stock | 33.88 | 34.12 | 33.74 | 33.85 | 9293596.0 |
| 2007-11-30 10:00:00 | MSFT | Stock | 33.84 | 33.91 | 33.73 | 33.91 | 4096430.0 |
| 2007-11-30 10:30:00 | MSFT | Stock | 33.91 | 33.93 | 33.75 | 33.75 | 3901854.0 |
| 2007-11-30 11:00:00 | MSFT | Stock | 33.75 | 33.95 | 33.55 | 33.65 | 5314691.0 |
| 2007-11-30 11:30:00 | MSFT | Stock | 33.65 | 33.8 | 33.54 | 33.69 | 3130127.0 |
| 2007-11-30 12:00:00 | MSFT | Stock | 33.69 | 33.8 | 33.46 | 33.57 | 2128723.0 |
| 2007-11-30 12:30:00 | MSFT | Stock | 33.57 | 33.8 | 33.55 | 33.61 | 2279934.0 |
| 2007-11-30 13:00:00 | MSFT | Stock | 33.6 | 33.62 | 33.4 | 33.51 | 2734674.0 |
| 2007-11-30 13:30:00 | MSFT | Stock | 33.51 | 33.58 | 33.41 | 33.42 | 1826785.0 |
| 2007-11-30 14:00:00 | MSFT | Stock | 33.41 | 33.46 | 33.35 | 33.45 | 2642809.0 |
| 2007-11-30 14:30:00 | MSFT | Stock | 33.45 | 33.58 | 33.43 | 33.51 | 3280433.0 |
| 2007-11-30 15:00:00 | MSFT | Stock | 33.5 | 33.52 | 33.19 | 33.48 | 5014322.0 |
> showing 50 of 71,599 rows — these rows as CSV