PREVIEW / stock_30min / 2005-10-03
file: by_date/stock_30min/2005/2005-10-03.parquet size: 856 KB rows: 46,203 symbols: 2,094
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-03 07:00:00 | AAPL | Stock | 1.9089 | 1.9089 | 1.9089 | 1.9089 | 5600.0 |
| 2005-10-03 07:30:00 | AAPL | Stock | 1.9161 | 1.9214 | 1.9161 | 1.9214 | 50400.0 |
| 2005-10-03 08:00:00 | AAPL | Stock | 1.9268 | 1.9339 | 1.9146 | 1.9286 | 1392412.0 |
| 2005-10-03 08:30:00 | AAPL | Stock | 1.9261 | 1.9321 | 1.9146 | 1.9286 | 526512.0 |
| 2005-10-03 09:00:00 | AAPL | Stock | 1.9304 | 1.9368 | 1.9261 | 1.9339 | 2281496.0 |
| 2005-10-03 09:30:00 | AAPL | Stock | 1.9343 | 1.94 | 1.9279 | 1.9336 | 91606928.0 |
| 2005-10-03 10:00:00 | AAPL | Stock | 1.9339 | 1.9368 | 1.92 | 1.9282 | 52658844.0 |
| 2005-10-03 10:30:00 | AAPL | Stock | 1.9282 | 1.9318 | 1.9171 | 1.9279 | 47802720.0 |
| 2005-10-03 11:00:00 | AAPL | Stock | 1.9279 | 1.9343 | 1.9257 | 1.9328 | 37251732.0 |
| 2005-10-03 11:30:00 | AAPL | Stock | 1.9325 | 1.9343 | 1.9275 | 1.9282 | 19593588.0 |
| 2005-10-03 12:00:00 | AAPL | Stock | 1.9282 | 1.9318 | 1.9264 | 1.9282 | 16388064.0 |
| 2005-10-03 12:30:00 | AAPL | Stock | 1.9282 | 1.9286 | 1.9214 | 1.9271 | 17195360.0 |
| 2005-10-03 13:00:00 | AAPL | Stock | 1.9271 | 1.9339 | 1.9268 | 1.9289 | 23959628.0 |
| 2005-10-03 13:30:00 | AAPL | Stock | 1.9289 | 1.9371 | 1.9286 | 1.935 | 22485400.0 |
| 2005-10-03 14:00:00 | AAPL | Stock | 1.935 | 1.935 | 1.9271 | 1.9318 | 24774764.0 |
| 2005-10-03 14:30:00 | AAPL | Stock | 1.9314 | 1.9425 | 1.9296 | 1.935 | 33104400.0 |
| 2005-10-03 15:00:00 | AAPL | Stock | 1.9357 | 1.9432 | 1.9321 | 1.9411 | 33384120.0 |
| 2005-10-03 15:30:00 | AAPL | Stock | 1.9407 | 1.9479 | 1.9389 | 1.9439 | 61993260.0 |
| 2005-10-03 16:00:00 | AAPL | Stock | 1.9443 | 1.9443 | 1.9326 | 1.9331 | 1645084.0 |
| 2005-10-03 16:30:00 | AAPL | Stock | 1.9421 | 1.9439 | 1.9418 | 1.9429 | 64400.0 |
| 2005-10-03 17:00:00 | AAPL | Stock | 1.9421 | 1.9443 | 1.9374 | 1.9374 | 236236.0 |
| 2005-10-03 17:30:00 | AAPL | Stock | 1.9436 | 1.9439 | 1.9418 | 1.9439 | 102480.0 |
| 2005-10-03 18:00:00 | AAPL | Stock | 1.9429 | 1.9518 | 1.9429 | 1.9482 | 951160.0 |
| 2005-10-03 08:00:00 | MSFT | Stock | 25.73 | 25.78 | 25.73 | 25.76 | 18942.0 |
| 2005-10-03 08:30:00 | MSFT | Stock | 25.76 | 25.77 | 25.73 | 25.77 | 38792.0 |
| 2005-10-03 09:00:00 | MSFT | Stock | 25.77 | 25.78 | 25.7 | 25.71 | 95786.0 |
| 2005-10-03 09:30:00 | MSFT | Stock | 25.71 | 25.733 | 25.58 | 25.63 | 5188885.0 |
| 2005-10-03 10:00:00 | MSFT | Stock | 25.63 | 25.66 | 25.55 | 25.58 | 5174237.0 |
| 2005-10-03 10:30:00 | MSFT | Stock | 25.58 | 25.6 | 25.54 | 25.56 | 3555094.0 |
| 2005-10-03 11:00:00 | MSFT | Stock | 25.57 | 25.59 | 25.55 | 25.59 | 2449368.0 |
| 2005-10-03 11:30:00 | MSFT | Stock | 25.59 | 25.63 | 25.52 | 25.53 | 2371897.0 |
| 2005-10-03 12:00:00 | MSFT | Stock | 25.54 | 25.58 | 25.46 | 25.47 | 2733680.0 |
| 2005-10-03 12:30:00 | MSFT | Stock | 25.47 | 25.6 | 25.47 | 25.57 | 3835029.0 |
| 2005-10-03 13:00:00 | MSFT | Stock | 25.58 | 25.61 | 25.48 | 25.49 | 3374184.0 |
| 2005-10-03 13:30:00 | MSFT | Stock | 25.49 | 25.6 | 25.48 | 25.53 | 1942838.0 |
| 2005-10-03 14:00:00 | MSFT | Stock | 25.53 | 25.55 | 25.479 | 25.53 | 2876959.0 |
| 2005-10-03 14:30:00 | MSFT | Stock | 25.53 | 25.59 | 25.5 | 25.53 | 3872090.0 |
| 2005-10-03 15:00:00 | MSFT | Stock | 25.54 | 25.57 | 25.44 | 25.47 | 5349274.0 |
| 2005-10-03 15:30:00 | MSFT | Stock | 25.47 | 25.551 | 25.47 | 25.499 | 7178118.0 |
| 2005-10-03 16:00:00 | MSFT | Stock | 25.5 | 25.55 | 25.45 | 25.47 | 1388406.0 |
| 2005-10-03 16:30:00 | MSFT | Stock | 25.47 | 25.49 | 25.41 | 25.46 | 32900.0 |
| 2005-10-03 17:00:00 | MSFT | Stock | 25.5 | 25.52 | 25.43 | 25.43 | 56183.0 |
| 2005-10-03 17:30:00 | MSFT | Stock | 25.44 | 25.47 | 25.41 | 25.43 | 24550.0 |
| 2005-10-03 18:00:00 | MSFT | Stock | 25.43 | 25.44 | 25.41 | 25.44 | 11987.0 |
| 2005-10-03 08:30:00 | NVDA | Stock | 0.2857 | 0.2907 | 0.2857 | 0.2888 | 1774560.0 |
| 2005-10-03 09:00:00 | NVDA | Stock | 0.2891 | 0.2892 | 0.2857 | 0.2872 | 1835160.0 |
| 2005-10-03 09:30:00 | NVDA | Stock | 0.289 | 0.2907 | 0.2867 | 0.2906 | 70558200.0 |
| 2005-10-03 10:00:00 | NVDA | Stock | 0.2906 | 0.2922 | 0.2904 | 0.2922 | 54543600.0 |
| 2005-10-03 10:30:00 | NVDA | Stock | 0.2922 | 0.2955 | 0.2915 | 0.2942 | 82241040.0 |
| 2005-10-03 11:00:00 | NVDA | Stock | 0.2942 | 0.2956 | 0.2937 | 0.2954 | 49906680.0 |
> showing 50 of 46,203 rows — these rows as CSV