PREVIEW / stock_30min / 2005-09-07
file: by_date/stock_30min/2005/2005-09-07.parquet size: 835 KB rows: 45,554 symbols: 2,069
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-09-07 08:00:00 | AAPL | Stock | 1.7518 | 1.7575 | 1.7411 | 1.755 | 1591884.0 |
| 2005-09-07 08:30:00 | AAPL | Stock | 1.755 | 1.7575 | 1.7507 | 1.7507 | 1819272.0 |
| 2005-09-07 09:00:00 | AAPL | Stock | 1.7518 | 1.7568 | 1.7429 | 1.7529 | 2278332.0 |
| 2005-09-07 09:30:00 | AAPL | Stock | 1.7518 | 1.7643 | 1.7261 | 1.7364 | 153542088.0 |
| 2005-09-07 10:00:00 | AAPL | Stock | 1.7364 | 1.7443 | 1.73 | 1.7389 | 69859300.0 |
| 2005-09-07 10:30:00 | AAPL | Stock | 1.7389 | 1.7482 | 1.7325 | 1.7379 | 56717136.0 |
| 2005-09-07 11:00:00 | AAPL | Stock | 1.7382 | 1.7414 | 1.7346 | 1.7375 | 29599780.0 |
| 2005-09-07 11:30:00 | AAPL | Stock | 1.7382 | 1.7396 | 1.7339 | 1.7343 | 22445668.0 |
| 2005-09-07 12:00:00 | AAPL | Stock | 1.7343 | 1.7354 | 1.7114 | 1.7175 | 86769928.0 |
| 2005-09-07 12:30:00 | AAPL | Stock | 1.7175 | 1.7275 | 1.7171 | 1.7225 | 43391516.0 |
| 2005-09-07 13:00:00 | AAPL | Stock | 1.7225 | 1.7343 | 1.7189 | 1.7246 | 65692032.0 |
| 2005-09-07 13:30:00 | AAPL | Stock | 1.725 | 1.73 | 1.7175 | 1.7264 | 48024256.0 |
| 2005-09-07 14:00:00 | AAPL | Stock | 1.7264 | 1.76 | 1.7232 | 1.7443 | 133024136.0 |
| 2005-09-07 14:30:00 | AAPL | Stock | 1.7446 | 1.7614 | 1.74 | 1.7496 | 100113272.0 |
| 2005-09-07 15:00:00 | AAPL | Stock | 1.7496 | 1.7554 | 1.7414 | 1.7439 | 66309936.0 |
| 2005-09-07 15:30:00 | AAPL | Stock | 1.7439 | 1.7457 | 1.7329 | 1.7371 | 67774392.0 |
| 2005-09-07 16:00:00 | AAPL | Stock | 1.7379 | 1.7396 | 1.7304 | 1.7339 | 3214204.0 |
| 2005-09-07 16:30:00 | AAPL | Stock | 1.7346 | 1.7386 | 1.7339 | 1.7361 | 320208.0 |
| 2005-09-07 17:00:00 | AAPL | Stock | 1.7346 | 1.7389 | 1.7336 | 1.7336 | 123900.0 |
| 2005-09-07 17:30:00 | AAPL | Stock | 1.7343 | 1.7429 | 1.7343 | 1.7429 | 679140.0 |
| 2005-09-07 18:00:00 | AAPL | Stock | 1.7429 | 1.7446 | 1.7371 | 1.7443 | 257600.0 |
| 2005-09-07 08:00:00 | MSFT | Stock | 27.05 | 27.05 | 26.95 | 26.98 | 11399.0 |
| 2005-09-07 08:30:00 | MSFT | Stock | 26.97 | 26.97 | 26.92 | 26.96 | 24513.0 |
| 2005-09-07 09:00:00 | MSFT | Stock | 26.94 | 27.0 | 26.93 | 26.94 | 73243.0 |
| 2005-09-07 09:30:00 | MSFT | Stock | 26.94 | 27.11 | 26.91 | 26.91 | 6569924.0 |
| 2005-09-07 10:00:00 | MSFT | Stock | 26.91 | 26.92 | 26.82 | 26.89 | 4872312.0 |
| 2005-09-07 10:30:00 | MSFT | Stock | 26.88 | 26.93 | 26.86 | 26.93 | 2572148.0 |
| 2005-09-07 11:00:00 | MSFT | Stock | 26.93 | 26.975 | 26.85 | 26.89 | 2598731.0 |
| 2005-09-07 11:30:00 | MSFT | Stock | 26.88 | 26.92 | 26.86 | 26.91 | 1189135.0 |
| 2005-09-07 12:00:00 | MSFT | Stock | 26.92 | 26.92 | 26.86 | 26.89 | 1182615.0 |
| 2005-09-07 12:30:00 | MSFT | Stock | 26.89 | 26.94 | 26.87 | 26.92 | 2613176.0 |
| 2005-09-07 13:00:00 | MSFT | Stock | 26.92 | 26.97 | 26.88 | 26.88 | 2434821.0 |
| 2005-09-07 13:30:00 | MSFT | Stock | 26.882 | 26.9 | 26.83 | 26.861 | 2954769.0 |
| 2005-09-07 14:00:00 | MSFT | Stock | 26.86 | 26.91 | 26.82 | 26.83 | 3549509.0 |
| 2005-09-07 14:30:00 | MSFT | Stock | 26.83 | 26.91 | 26.83 | 26.892 | 2348442.0 |
| 2005-09-07 15:00:00 | MSFT | Stock | 26.89 | 26.93 | 26.85 | 26.86 | 3285267.0 |
| 2005-09-07 15:30:00 | MSFT | Stock | 26.86 | 26.9 | 26.83 | 26.85 | 5956020.0 |
| 2005-09-07 16:00:00 | MSFT | Stock | 26.85 | 26.88 | 26.82 | 26.87 | 1379279.0 |
| 2005-09-07 16:30:00 | MSFT | Stock | 26.87 | 26.88 | 26.86 | 26.86 | 7934.0 |
| 2005-09-07 17:00:00 | MSFT | Stock | 26.86 | 26.86 | 26.83 | 26.83 | 130163.0 |
| 2005-09-07 17:30:00 | MSFT | Stock | 26.86 | 26.86 | 26.85 | 26.85 | 1768.0 |
| 2005-09-07 18:00:00 | MSFT | Stock | 26.85 | 26.85 | 26.85 | 26.85 | 28100.0 |
| 2005-09-07 09:00:00 | NVDA | Stock | 0.2537 | 0.2537 | 0.2532 | 0.2532 | 88800.0 |
| 2005-09-07 09:30:00 | NVDA | Stock | 0.2533 | 0.257 | 0.253 | 0.254 | 50485920.0 |
| 2005-09-07 10:00:00 | NVDA | Stock | 0.254 | 0.2546 | 0.2527 | 0.2537 | 23257680.0 |
| 2005-09-07 10:30:00 | NVDA | Stock | 0.2537 | 0.2578 | 0.2534 | 0.2576 | 55780320.0 |
| 2005-09-07 11:00:00 | NVDA | Stock | 0.2576 | 0.2579 | 0.2559 | 0.257 | 25428480.0 |
| 2005-09-07 11:30:00 | NVDA | Stock | 0.2569 | 0.2582 | 0.2569 | 0.2578 | 18256200.0 |
| 2005-09-07 12:00:00 | NVDA | Stock | 0.2579 | 0.2594 | 0.2577 | 0.2589 | 59228040.0 |
| 2005-09-07 12:30:00 | NVDA | Stock | 0.2588 | 0.2589 | 0.2575 | 0.2582 | 19425360.0 |
> showing 50 of 45,554 rows — these rows as CSV