PREVIEW / stock_30min / 2005-07-05
file: by_date/stock_30min/2005/2005-07-05.parquet size: 839 KB rows: 45,597 symbols: 2,024
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-07-05 07:30:00 | AAPL | Stock | 1.3054 | 1.3089 | 1.3054 | 1.3082 | 210000.0 |
| 2005-07-05 08:00:00 | AAPL | Stock | 1.3143 | 1.3275 | 1.3125 | 1.3214 | 2029496.0 |
| 2005-07-05 08:30:00 | AAPL | Stock | 1.3214 | 1.3225 | 1.3186 | 1.3196 | 448420.0 |
| 2005-07-05 09:00:00 | AAPL | Stock | 1.3207 | 1.3207 | 1.3036 | 1.3054 | 1752856.0 |
| 2005-07-05 09:30:00 | AAPL | Stock | 1.3054 | 1.3346 | 1.3036 | 1.3332 | 62976284.0 |
| 2005-07-05 10:00:00 | AAPL | Stock | 1.3332 | 1.3479 | 1.3304 | 1.3479 | 63458304.0 |
| 2005-07-05 10:30:00 | AAPL | Stock | 1.3479 | 1.3543 | 1.3436 | 1.3536 | 57029056.0 |
| 2005-07-05 11:00:00 | AAPL | Stock | 1.3536 | 1.355 | 1.3425 | 1.3496 | 38115336.0 |
| 2005-07-05 11:30:00 | AAPL | Stock | 1.3496 | 1.3521 | 1.3454 | 1.3504 | 19838252.0 |
| 2005-07-05 12:00:00 | AAPL | Stock | 1.35 | 1.3546 | 1.3496 | 1.3525 | 19278700.0 |
| 2005-07-05 12:30:00 | AAPL | Stock | 1.3532 | 1.3557 | 1.3514 | 1.3525 | 17173828.0 |
| 2005-07-05 13:00:00 | AAPL | Stock | 1.3518 | 1.3536 | 1.3479 | 1.3504 | 13662348.0 |
| 2005-07-05 13:30:00 | AAPL | Stock | 1.3504 | 1.3571 | 1.3486 | 1.355 | 22881236.0 |
| 2005-07-05 14:00:00 | AAPL | Stock | 1.3554 | 1.3564 | 1.3514 | 1.3536 | 15354080.0 |
| 2005-07-05 14:30:00 | AAPL | Stock | 1.3536 | 1.3571 | 1.3518 | 1.355 | 18258436.0 |
| 2005-07-05 15:00:00 | AAPL | Stock | 1.3546 | 1.3625 | 1.3543 | 1.3561 | 20199620.0 |
| 2005-07-05 15:30:00 | AAPL | Stock | 1.3561 | 1.3621 | 1.355 | 1.3561 | 73800944.0 |
| 2005-07-05 16:00:00 | AAPL | Stock | 1.3571 | 1.3575 | 1.3543 | 1.3557 | 1350160.0 |
| 2005-07-05 16:30:00 | AAPL | Stock | 1.3554 | 1.3564 | 1.3554 | 1.3554 | 52612.0 |
| 2005-07-05 17:00:00 | AAPL | Stock | 1.3554 | 1.3621 | 1.346 | 1.346 | 296268.0 |
| 2005-07-05 17:30:00 | AAPL | Stock | 1.3571 | 1.3607 | 1.35 | 1.3607 | 1628004.0 |
| 2005-07-05 18:00:00 | AAPL | Stock | 1.3607 | 1.3607 | 1.3607 | 1.3607 | 2800.0 |
| 2005-07-05 08:00:00 | MSFT | Stock | 24.65 | 24.65 | 24.61 | 24.64 | 16855.0 |
| 2005-07-05 08:30:00 | MSFT | Stock | 24.64 | 24.65 | 24.62 | 24.62 | 4667.0 |
| 2005-07-05 09:00:00 | MSFT | Stock | 24.64 | 24.7 | 24.62 | 24.63 | 232991.0 |
| 2005-07-05 09:30:00 | MSFT | Stock | 24.66 | 24.74 | 24.62 | 24.74 | 7551260.0 |
| 2005-07-05 10:00:00 | MSFT | Stock | 24.74 | 24.98 | 24.73 | 24.94 | 8378053.0 |
| 2005-07-05 10:30:00 | MSFT | Stock | 24.93 | 25.01 | 24.66 | 24.93 | 4681437.0 |
| 2005-07-05 11:00:00 | MSFT | Stock | 24.92 | 24.94 | 24.849 | 24.9 | 3781242.0 |
| 2005-07-05 11:30:00 | MSFT | Stock | 24.9 | 24.91 | 24.82 | 24.88 | 2777043.0 |
| 2005-07-05 12:00:00 | MSFT | Stock | 24.87 | 24.92 | 24.87 | 24.9 | 2299692.0 |
| 2005-07-05 12:30:00 | MSFT | Stock | 24.9 | 24.93 | 24.87 | 24.87 | 2622878.0 |
| 2005-07-05 13:00:00 | MSFT | Stock | 24.88 | 24.9 | 24.85 | 24.85 | 4055093.0 |
| 2005-07-05 13:30:00 | MSFT | Stock | 24.86 | 24.91 | 24.84 | 24.86 | 3934599.0 |
| 2005-07-05 14:00:00 | MSFT | Stock | 24.87 | 24.98 | 24.86 | 24.92 | 4821639.0 |
| 2005-07-05 14:30:00 | MSFT | Stock | 24.92 | 25.0 | 24.882 | 24.98 | 2848871.0 |
| 2005-07-05 15:00:00 | MSFT | Stock | 24.98 | 25.19 | 24.864 | 24.95 | 4500531.0 |
| 2005-07-05 15:30:00 | MSFT | Stock | 24.95 | 25.051 | 24.878 | 24.98 | 7469130.0 |
| 2005-07-05 16:00:00 | MSFT | Stock | 24.98 | 24.98 | 24.91 | 24.98 | 386621.0 |
| 2005-07-05 16:30:00 | MSFT | Stock | 24.98 | 24.98 | 24.96 | 24.97 | 7480.0 |
| 2005-07-05 17:00:00 | MSFT | Stock | 24.98 | 24.98 | 24.899 | 24.899 | 74345.0 |
| 2005-07-05 17:30:00 | MSFT | Stock | 24.869 | 24.98 | 24.869 | 24.97 | 230032.0 |
| 2005-07-05 18:00:00 | MSFT | Stock | 24.97 | 24.97 | 24.97 | 24.97 | 500.0 |
| 2005-07-05 08:00:00 | NVDA | Stock | 0.2237 | 0.2252 | 0.2237 | 0.2252 | 322800.0 |
| 2005-07-05 09:00:00 | NVDA | Stock | 0.2236 | 0.2236 | 0.2236 | 0.2236 | 12000.0 |
| 2005-07-05 09:30:00 | NVDA | Stock | 0.2245 | 0.2258 | 0.2223 | 0.225 | 74620920.0 |
| 2005-07-05 10:00:00 | NVDA | Stock | 0.225 | 0.2262 | 0.2245 | 0.226 | 43674240.0 |
| 2005-07-05 10:30:00 | NVDA | Stock | 0.226 | 0.2273 | 0.226 | 0.2265 | 27313200.0 |
| 2005-07-05 11:00:00 | NVDA | Stock | 0.2266 | 0.2267 | 0.2257 | 0.2264 | 10871880.0 |
| 2005-07-05 11:30:00 | NVDA | Stock | 0.2264 | 0.2265 | 0.225 | 0.2255 | 11161080.0 |
> showing 50 of 45,597 rows — these rows as CSV