PREVIEW / stock_30min / 2008-11-10
file: by_date/stock_30min/2008/2008-11-10.parquet size: 1.2 MB rows: 69,085 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-11-10 07:00:00 | AAPL | Stock | 3.5839 | 3.6429 | 3.5839 | 3.6071 | 129528.0 |
| 2008-11-10 07:30:00 | AAPL | Stock | 3.6036 | 3.6036 | 3.6 | 3.6014 | 119896.0 |
| 2008-11-10 08:00:00 | AAPL | Stock | 3.6014 | 3.6214 | 3.5857 | 3.5893 | 1699740.0 |
| 2008-11-10 08:30:00 | AAPL | Stock | 3.5889 | 3.5975 | 3.5846 | 3.5871 | 1049776.0 |
| 2008-11-10 09:00:00 | AAPL | Stock | 3.5875 | 3.5889 | 3.5675 | 3.5814 | 2882040.0 |
| 2008-11-10 09:30:00 | AAPL | Stock | 3.5814 | 3.5857 | 3.495 | 3.5311 | 136717560.0 |
| 2008-11-10 10:00:00 | AAPL | Stock | 3.5325 | 3.5714 | 3.5186 | 3.5375 | 85391684.0 |
| 2008-11-10 10:30:00 | AAPL | Stock | 3.5379 | 3.5611 | 3.5125 | 3.5236 | 65255512.0 |
| 2008-11-10 11:00:00 | AAPL | Stock | 3.5239 | 3.5243 | 3.4432 | 3.4732 | 97177052.0 |
| 2008-11-10 11:30:00 | AAPL | Stock | 3.4725 | 3.4821 | 3.3975 | 3.4114 | 78443736.0 |
| 2008-11-10 12:00:00 | AAPL | Stock | 3.4118 | 3.4607 | 3.4075 | 3.4218 | 73290084.0 |
| 2008-11-10 12:30:00 | AAPL | Stock | 3.4218 | 3.4389 | 3.3929 | 3.4046 | 73032428.0 |
| 2008-11-10 13:00:00 | AAPL | Stock | 3.4057 | 3.4421 | 3.3939 | 3.4314 | 61250028.0 |
| 2008-11-10 13:30:00 | AAPL | Stock | 3.4325 | 3.4536 | 3.4025 | 3.4445 | 62716052.0 |
| 2008-11-10 14:00:00 | AAPL | Stock | 3.4446 | 3.445 | 3.4018 | 3.4157 | 65321284.0 |
| 2008-11-10 14:30:00 | AAPL | Stock | 3.4161 | 3.4214 | 3.3786 | 3.4014 | 74728332.0 |
| 2008-11-10 15:00:00 | AAPL | Stock | 3.4011 | 3.4311 | 3.375 | 3.3782 | 95796736.0 |
| 2008-11-10 15:30:00 | AAPL | Stock | 3.3793 | 3.4321 | 3.375 | 3.4221 | 122301368.0 |
| 2008-11-10 16:00:00 | AAPL | Stock | 3.425 | 3.4541 | 3.4006 | 3.4179 | 13542648.0 |
| 2008-11-10 16:30:00 | AAPL | Stock | 3.4161 | 3.4243 | 3.4121 | 3.4243 | 7918820.0 |
| 2008-11-10 17:00:00 | AAPL | Stock | 3.4154 | 3.4243 | 3.4136 | 3.4179 | 211064.0 |
| 2008-11-10 17:30:00 | AAPL | Stock | 3.4179 | 3.4245 | 3.4071 | 3.4089 | 344316.0 |
| 2008-11-10 18:00:00 | AAPL | Stock | 3.4071 | 3.4104 | 3.4021 | 3.4036 | 95256.0 |
| 2008-11-10 18:30:00 | AAPL | Stock | 3.4054 | 3.4243 | 3.4018 | 3.4018 | 1821988.0 |
| 2008-11-10 19:00:00 | AAPL | Stock | 3.4007 | 3.4036 | 3.4007 | 3.4007 | 86268.0 |
| 2008-11-10 19:30:00 | AAPL | Stock | 3.4018 | 3.4107 | 3.3964 | 3.4107 | 64624.0 |
| 2008-11-10 04:00:00 | MSFT | Stock | 21.88 | 21.88 | 21.88 | 21.88 | 200.0 |
| 2008-11-10 05:00:00 | MSFT | Stock | 21.96 | 21.96 | 21.96 | 21.96 | 100.0 |
| 2008-11-10 05:30:00 | MSFT | Stock | 21.96 | 21.96 | 21.96 | 21.96 | 100.0 |
| 2008-11-10 08:00:00 | MSFT | Stock | 21.93 | 21.95 | 21.5 | 21.91 | 86638.0 |
| 2008-11-10 08:30:00 | MSFT | Stock | 21.91 | 21.96 | 21.8 | 21.9 | 30470.0 |
| 2008-11-10 09:00:00 | MSFT | Stock | 21.9 | 21.94 | 21.78 | 21.78 | 92111.0 |
| 2008-11-10 09:30:00 | MSFT | Stock | 21.82 | 21.97 | 21.66 | 21.8 | 5557493.0 |
| 2008-11-10 10:00:00 | MSFT | Stock | 21.8 | 21.95 | 21.72 | 21.84 | 4687299.0 |
| 2008-11-10 10:30:00 | MSFT | Stock | 21.85 | 21.92 | 21.7 | 21.758 | 5438689.0 |
| 2008-11-10 11:00:00 | MSFT | Stock | 21.76 | 21.84 | 21.67 | 21.68 | 3387625.0 |
| 2008-11-10 11:30:00 | MSFT | Stock | 21.69 | 21.71 | 21.47 | 21.51 | 3132939.0 |
| 2008-11-10 12:00:00 | MSFT | Stock | 21.512 | 21.65 | 21.43 | 21.44 | 2569053.0 |
| 2008-11-10 12:30:00 | MSFT | Stock | 21.44 | 21.45 | 21.3 | 21.38 | 2725371.0 |
| 2008-11-10 13:00:00 | MSFT | Stock | 21.37 | 21.45 | 21.28 | 21.39 | 2467253.0 |
| 2008-11-10 13:30:00 | MSFT | Stock | 21.39 | 21.63 | 21.31 | 21.58 | 2733585.0 |
| 2008-11-10 14:00:00 | MSFT | Stock | 21.58 | 21.7 | 21.42 | 21.45 | 3705857.0 |
| 2008-11-10 14:30:00 | MSFT | Stock | 21.44 | 21.5 | 21.25 | 21.32 | 3577259.0 |
| 2008-11-10 15:00:00 | MSFT | Stock | 21.31 | 21.43 | 21.19 | 21.23 | 5365029.0 |
| 2008-11-10 15:30:00 | MSFT | Stock | 21.22 | 21.47 | 21.2 | 21.3 | 8367163.0 |
| 2008-11-10 16:00:00 | MSFT | Stock | 21.31 | 21.5 | 21.296 | 21.45 | 10667505.0 |
| 2008-11-10 16:30:00 | MSFT | Stock | 21.45 | 21.495 | 21.3 | 21.3 | 1758469.0 |
| 2008-11-10 17:00:00 | MSFT | Stock | 21.45 | 21.45 | 21.3 | 21.42 | 8490.0 |
| 2008-11-10 17:30:00 | MSFT | Stock | 21.299 | 21.42 | 21.299 | 21.42 | 17548.0 |
| 2008-11-10 18:00:00 | MSFT | Stock | 21.37 | 21.38 | 21.35 | 21.35 | 12514.0 |
> showing 50 of 69,085 rows — these rows as CSV