PREVIEW / stock_30min / 2004-10-28
file: by_date/stock_30min/2004/2004-10-28.parquet size: 774 KB rows: 40,971 symbols: 1,853
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-28 08:00:00 | AAPL | Stock | 0.8955 | 0.8955 | 0.8936 | 0.8946 | 151088.0 |
| 2004-10-28 08:30:00 | AAPL | Stock | 0.8945 | 0.8957 | 0.8938 | 0.895 | 257600.0 |
| 2004-10-28 09:00:00 | AAPL | Stock | 0.8961 | 0.898 | 0.8905 | 0.8916 | 2561328.0 |
| 2004-10-28 09:30:00 | AAPL | Stock | 0.8925 | 0.9 | 0.8839 | 0.8996 | 96827864.0 |
| 2004-10-28 10:00:00 | AAPL | Stock | 0.8996 | 0.9041 | 0.8952 | 0.8993 | 67962720.0 |
| 2004-10-28 10:30:00 | AAPL | Stock | 0.8993 | 0.8996 | 0.8927 | 0.8971 | 48454616.0 |
| 2004-10-28 11:00:00 | AAPL | Stock | 0.8971 | 0.9018 | 0.8966 | 0.9018 | 40259072.0 |
| 2004-10-28 11:30:00 | AAPL | Stock | 0.9013 | 0.907 | 0.8989 | 0.9048 | 60441696.0 |
| 2004-10-28 12:00:00 | AAPL | Stock | 0.905 | 0.9075 | 0.903 | 0.9043 | 45710448.0 |
| 2004-10-28 12:30:00 | AAPL | Stock | 0.9043 | 0.9093 | 0.9041 | 0.9088 | 33077464.0 |
| 2004-10-28 13:00:00 | AAPL | Stock | 0.9086 | 0.9159 | 0.908 | 0.9159 | 55173776.0 |
| 2004-10-28 13:30:00 | AAPL | Stock | 0.9159 | 0.9222 | 0.9154 | 0.9173 | 74702376.0 |
| 2004-10-28 14:00:00 | AAPL | Stock | 0.9173 | 0.927 | 0.9164 | 0.9254 | 72950584.0 |
| 2004-10-28 14:30:00 | AAPL | Stock | 0.9254 | 0.9293 | 0.9238 | 0.9254 | 79852696.0 |
| 2004-10-28 15:00:00 | AAPL | Stock | 0.9252 | 0.9309 | 0.9248 | 0.9257 | 74995592.0 |
| 2004-10-28 15:30:00 | AAPL | Stock | 0.9255 | 0.9325 | 0.9221 | 0.9316 | 84482888.0 |
| 2004-10-28 16:00:00 | AAPL | Stock | 0.9316 | 0.9323 | 0.928 | 0.9323 | 4127200.0 |
| 2004-10-28 16:30:00 | AAPL | Stock | 0.932 | 0.9321 | 0.932 | 0.9321 | 1751232.0 |
| 2004-10-28 17:00:00 | AAPL | Stock | 0.9305 | 0.9305 | 0.9291 | 0.9298 | 82264.0 |
| 2004-10-28 17:30:00 | AAPL | Stock | 0.9321 | 0.9321 | 0.9295 | 0.9295 | 22400.0 |
| 2004-10-28 18:00:00 | AAPL | Stock | 0.9291 | 0.9291 | 0.9291 | 0.9291 | 11200.0 |
| 2004-10-28 08:00:00 | MSFT | Stock | 28.15 | 28.15 | 28.11 | 28.11 | 21100.0 |
| 2004-10-28 08:30:00 | MSFT | Stock | 28.11 | 28.15 | 28.11 | 28.14 | 24900.0 |
| 2004-10-28 09:00:00 | MSFT | Stock | 28.14 | 28.2 | 28.1 | 28.12 | 125640.0 |
| 2004-10-28 09:30:00 | MSFT | Stock | 28.11 | 28.19 | 28.01 | 28.16 | 4748052.0 |
| 2004-10-28 10:00:00 | MSFT | Stock | 28.15 | 28.18 | 28.09 | 28.12 | 4879937.0 |
| 2004-10-28 10:30:00 | MSFT | Stock | 28.13 | 28.14 | 28.07 | 28.12 | 3991026.0 |
| 2004-10-28 11:00:00 | MSFT | Stock | 28.12 | 28.13 | 28.01 | 28.07 | 4884049.0 |
| 2004-10-28 11:30:00 | MSFT | Stock | 28.06 | 28.0939 | 27.99 | 28.01 | 3087672.0 |
| 2004-10-28 12:00:00 | MSFT | Stock | 28.01 | 28.03 | 27.9 | 27.92 | 3504705.0 |
| 2004-10-28 12:30:00 | MSFT | Stock | 27.92 | 28.03 | 27.92 | 28.01 | 1950695.0 |
| 2004-10-28 13:00:00 | MSFT | Stock | 28.01 | 28.06 | 27.99 | 28.02 | 3045104.0 |
| 2004-10-28 13:30:00 | MSFT | Stock | 28.03 | 28.05 | 27.98 | 28.02 | 3829015.0 |
| 2004-10-28 14:00:00 | MSFT | Stock | 28.01 | 28.15 | 28.01 | 28.1 | 4177829.0 |
| 2004-10-28 14:30:00 | MSFT | Stock | 28.1 | 28.14 | 28.06 | 28.079 | 3679631.0 |
| 2004-10-28 15:00:00 | MSFT | Stock | 28.07 | 28.1 | 28.0 | 28.02 | 3592572.0 |
| 2004-10-28 15:30:00 | MSFT | Stock | 28.03 | 28.13 | 27.99 | 28.05 | 9431033.0 |
| 2004-10-28 16:00:00 | MSFT | Stock | 28.05 | 28.14 | 28.01 | 28.07 | 5264618.0 |
| 2004-10-28 16:30:00 | MSFT | Stock | 28.04 | 28.08 | 28.04 | 28.08 | 67500.0 |
| 2004-10-28 17:00:00 | MSFT | Stock | 28.08 | 28.08 | 28.08 | 28.08 | 115.0 |
| 2004-10-28 17:30:00 | MSFT | Stock | 28.0 | 28.06 | 28.0 | 28.06 | 25133.0 |
| 2004-10-28 18:00:00 | MSFT | Stock | 28.08 | 28.08 | 28.07 | 28.08 | 4700.0 |
| 2004-10-28 08:00:00 | NVDA | Stock | 0.1228 | 0.1228 | 0.1228 | 0.1228 | 120000.0 |
| 2004-10-28 08:30:00 | NVDA | Stock | 0.1236 | 0.1237 | 0.1236 | 0.1236 | 312000.0 |
| 2004-10-28 09:00:00 | NVDA | Stock | 0.1229 | 0.1234 | 0.1227 | 0.1227 | 1362240.0 |
| 2004-10-28 09:30:00 | NVDA | Stock | 0.1224 | 0.125 | 0.1224 | 0.1241 | 95564760.0 |
| 2004-10-28 10:00:00 | NVDA | Stock | 0.1243 | 0.1246 | 0.1227 | 0.1228 | 53427120.0 |
| 2004-10-28 10:30:00 | NVDA | Stock | 0.1227 | 0.1237 | 0.1222 | 0.1236 | 43092240.0 |
| 2004-10-28 11:00:00 | NVDA | Stock | 0.1236 | 0.1237 | 0.1228 | 0.1236 | 27031440.0 |
| 2004-10-28 11:30:00 | NVDA | Stock | 0.1237 | 0.1238 | 0.1227 | 0.1227 | 32121960.0 |
> showing 50 of 40,971 rows — these rows as CSV