PREVIEW / stock_30min / 2004-01-14
file: by_date/stock_30min/2004/2004-01-14.parquet size: 769 KB rows: 40,224 symbols: 1,709
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-01-14 08:00:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4348 | 0.4357 | 229600.0 |
| 2004-01-14 08:30:00 | AAPL | Stock | 0.4357 | 0.4373 | 0.4341 | 0.4373 | 464800.0 |
| 2004-01-14 09:00:00 | AAPL | Stock | 0.4373 | 0.4375 | 0.4334 | 0.4357 | 2788800.0 |
| 2004-01-14 09:30:00 | AAPL | Stock | 0.4357 | 0.4382 | 0.4343 | 0.4347 | 81155088.0 |
| 2004-01-14 10:00:00 | AAPL | Stock | 0.4347 | 0.4352 | 0.4318 | 0.4327 | 44802016.0 |
| 2004-01-14 10:30:00 | AAPL | Stock | 0.4327 | 0.4332 | 0.4293 | 0.4296 | 28306600.0 |
| 2004-01-14 11:00:00 | AAPL | Stock | 0.4295 | 0.4325 | 0.4295 | 0.4307 | 37653952.0 |
| 2004-01-14 11:30:00 | AAPL | Stock | 0.4307 | 0.4309 | 0.428 | 0.4284 | 28351064.0 |
| 2004-01-14 12:00:00 | AAPL | Stock | 0.4284 | 0.4289 | 0.4254 | 0.4259 | 26313784.0 |
| 2004-01-14 12:30:00 | AAPL | Stock | 0.4261 | 0.4282 | 0.4246 | 0.4268 | 27569528.0 |
| 2004-01-14 13:00:00 | AAPL | Stock | 0.4268 | 0.4293 | 0.4254 | 0.4284 | 25179840.0 |
| 2004-01-14 13:30:00 | AAPL | Stock | 0.4284 | 0.4295 | 0.428 | 0.4284 | 17401272.0 |
| 2004-01-14 14:00:00 | AAPL | Stock | 0.4286 | 0.4309 | 0.4281 | 0.4309 | 28943712.0 |
| 2004-01-14 14:30:00 | AAPL | Stock | 0.4305 | 0.433 | 0.4305 | 0.4321 | 39741968.0 |
| 2004-01-14 15:00:00 | AAPL | Stock | 0.4321 | 0.4339 | 0.4318 | 0.4332 | 60073552.0 |
| 2004-01-14 15:30:00 | AAPL | Stock | 0.4332 | 0.4336 | 0.4314 | 0.4314 | 79024288.0 |
| 2004-01-14 16:00:00 | AAPL | Stock | 0.4314 | 0.4334 | 0.4259 | 0.4318 | 5739552.0 |
| 2004-01-14 16:30:00 | AAPL | Stock | 0.4318 | 0.4371 | 0.393 | 0.4093 | 49616056.0 |
| 2004-01-14 17:00:00 | AAPL | Stock | 0.4089 | 0.4325 | 0.4071 | 0.4116 | 5538960.0 |
| 2004-01-14 17:30:00 | AAPL | Stock | 0.4111 | 0.4118 | 0.4071 | 0.4093 | 4897200.0 |
| 2004-01-14 18:00:00 | AAPL | Stock | 0.4093 | 0.4098 | 0.408 | 0.408 | 890400.0 |
| 2004-01-14 08:00:00 | MSFT | Stock | 27.57 | 27.57 | 27.5 | 27.51 | 4000.0 |
| 2004-01-14 08:30:00 | MSFT | Stock | 27.5 | 27.58 | 27.5 | 27.58 | 27310.0 |
| 2004-01-14 09:00:00 | MSFT | Stock | 27.58 | 27.58 | 27.43 | 27.52 | 101528.0 |
| 2004-01-14 09:30:00 | MSFT | Stock | 27.51 | 27.56 | 27.47 | 27.5 | 4464302.0 |
| 2004-01-14 10:00:00 | MSFT | Stock | 27.5 | 27.59 | 27.49 | 27.58 | 2716462.0 |
| 2004-01-14 10:30:00 | MSFT | Stock | 27.57 | 27.6 | 27.53 | 27.55 | 2655203.0 |
| 2004-01-14 11:00:00 | MSFT | Stock | 27.56 | 27.61 | 27.51 | 27.57 | 3843802.0 |
| 2004-01-14 11:30:00 | MSFT | Stock | 27.57 | 27.62 | 27.55 | 27.56 | 2503943.0 |
| 2004-01-14 12:00:00 | MSFT | Stock | 27.55 | 27.61 | 27.54 | 27.58 | 1954504.0 |
| 2004-01-14 12:30:00 | MSFT | Stock | 27.59 | 27.61 | 27.54 | 27.57 | 1977390.0 |
| 2004-01-14 13:00:00 | MSFT | Stock | 27.56 | 27.61 | 27.53 | 27.59 | 1639308.0 |
| 2004-01-14 13:30:00 | MSFT | Stock | 27.59 | 27.61 | 27.57 | 27.57 | 1348346.0 |
| 2004-01-14 14:00:00 | MSFT | Stock | 27.57 | 27.62 | 27.55 | 27.61 | 2479590.0 |
| 2004-01-14 14:30:00 | MSFT | Stock | 27.61 | 27.65 | 27.59 | 27.63 | 3138838.0 |
| 2004-01-14 15:00:00 | MSFT | Stock | 27.62 | 27.65 | 27.6 | 27.65 | 3488379.0 |
| 2004-01-14 15:30:00 | MSFT | Stock | 27.65 | 27.73 | 27.61 | 27.7 | 8027079.0 |
| 2004-01-14 16:00:00 | MSFT | Stock | 27.7 | 27.78 | 27.5 | 27.6 | 1367327.0 |
| 2004-01-14 16:30:00 | MSFT | Stock | 27.6 | 27.6 | 27.4 | 27.4 | 395569.0 |
| 2004-01-14 17:00:00 | MSFT | Stock | 27.4 | 27.7 | 27.35 | 27.47 | 153772.0 |
| 2004-01-14 17:30:00 | MSFT | Stock | 27.48 | 27.5 | 27.44 | 27.44 | 32965.0 |
| 2004-01-14 18:00:00 | MSFT | Stock | 27.44 | 27.48 | 27.43 | 27.45 | 12695.0 |
| 2004-01-14 08:00:00 | NVDA | Stock | 0.2044 | 0.2044 | 0.2042 | 0.2042 | 649680.0 |
| 2004-01-14 08:30:00 | NVDA | Stock | 0.2054 | 0.2054 | 0.204 | 0.2042 | 564000.0 |
| 2004-01-14 09:00:00 | NVDA | Stock | 0.2052 | 0.2052 | 0.2042 | 0.2046 | 2315160.0 |
| 2004-01-14 09:30:00 | NVDA | Stock | 0.205 | 0.2075 | 0.2037 | 0.2057 | 96044400.0 |
| 2004-01-14 10:00:00 | NVDA | Stock | 0.2057 | 0.2073 | 0.2052 | 0.2053 | 55945680.0 |
| 2004-01-14 10:30:00 | NVDA | Stock | 0.2053 | 0.2058 | 0.2033 | 0.2041 | 46848480.0 |
| 2004-01-14 11:00:00 | NVDA | Stock | 0.2041 | 0.2058 | 0.2038 | 0.2047 | 25380960.0 |
| 2004-01-14 11:30:00 | NVDA | Stock | 0.2048 | 0.2057 | 0.2047 | 0.2049 | 14095560.0 |
> showing 50 of 40,224 rows — these rows as CSV