PREVIEW / stock_30min / 2008-05-15
file: by_date/stock_30min/2008/2008-05-15.parquet size: 1.2 MB rows: 68,579 symbols: 3,306
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-15 07:00:00 | AAPL | Stock | 6.6875 | 6.7071 | 6.6875 | 6.7036 | 75600.0 |
| 2008-05-15 07:30:00 | AAPL | Stock | 6.6964 | 6.7143 | 6.6911 | 6.71 | 503216.0 |
| 2008-05-15 08:00:00 | AAPL | Stock | 6.7089 | 6.7189 | 6.6982 | 6.705 | 3545724.0 |
| 2008-05-15 08:30:00 | AAPL | Stock | 6.7046 | 6.7107 | 6.6918 | 6.6989 | 2328760.0 |
| 2008-05-15 09:00:00 | AAPL | Stock | 6.6971 | 6.6996 | 6.6689 | 6.6729 | 3310384.0 |
| 2008-05-15 09:30:00 | AAPL | Stock | 6.6732 | 6.6871 | 6.5786 | 6.6639 | 167180524.0 |
| 2008-05-15 10:00:00 | AAPL | Stock | 6.6641 | 6.6814 | 6.6111 | 6.6589 | 92877036.0 |
| 2008-05-15 10:30:00 | AAPL | Stock | 6.6596 | 6.7011 | 6.6389 | 6.6794 | 70881188.0 |
| 2008-05-15 11:00:00 | AAPL | Stock | 6.68 | 6.6964 | 6.6604 | 6.6789 | 49253596.0 |
| 2008-05-15 11:30:00 | AAPL | Stock | 6.6786 | 6.6925 | 6.6543 | 6.6889 | 44523052.0 |
| 2008-05-15 12:00:00 | AAPL | Stock | 6.6893 | 6.735 | 6.6846 | 6.7296 | 59611244.0 |
| 2008-05-15 12:30:00 | AAPL | Stock | 6.7289 | 6.7586 | 6.725 | 6.7364 | 53465188.0 |
| 2008-05-15 13:00:00 | AAPL | Stock | 6.7368 | 6.7489 | 6.725 | 6.725 | 29596868.0 |
| 2008-05-15 13:30:00 | AAPL | Stock | 6.725 | 6.745 | 6.7221 | 6.7375 | 35975996.0 |
| 2008-05-15 14:00:00 | AAPL | Stock | 6.7375 | 6.7429 | 6.6825 | 6.6882 | 68512584.0 |
| 2008-05-15 14:30:00 | AAPL | Stock | 6.6886 | 6.7396 | 6.6864 | 6.7207 | 43426600.0 |
| 2008-05-15 15:00:00 | AAPL | Stock | 6.7204 | 6.7461 | 6.7161 | 6.7386 | 35502628.0 |
| 2008-05-15 15:30:00 | AAPL | Stock | 6.7382 | 6.7821 | 6.7261 | 6.7732 | 84257460.0 |
| 2008-05-15 16:00:00 | AAPL | Stock | 6.7732 | 6.7768 | 6.6933 | 6.7743 | 13580644.0 |
| 2008-05-15 16:30:00 | AAPL | Stock | 6.6946 | 6.7786 | 6.6946 | 6.7686 | 602112.0 |
| 2008-05-15 17:00:00 | AAPL | Stock | 6.77 | 6.775 | 6.7679 | 6.775 | 273896.0 |
| 2008-05-15 17:30:00 | AAPL | Stock | 6.775 | 6.7807 | 6.6948 | 6.78 | 270480.0 |
| 2008-05-15 18:00:00 | AAPL | Stock | 6.7807 | 6.7821 | 6.78 | 6.7821 | 174608.0 |
| 2008-05-15 18:30:00 | AAPL | Stock | 6.7782 | 6.7818 | 6.7771 | 6.7818 | 84056.0 |
| 2008-05-15 19:00:00 | AAPL | Stock | 6.7818 | 6.7821 | 6.7768 | 6.7775 | 98588.0 |
| 2008-05-15 19:30:00 | AAPL | Stock | 6.7786 | 6.7821 | 6.7775 | 6.7811 | 211764.0 |
| 2008-05-15 08:00:00 | MSFT | Stock | 29.83 | 30.02 | 29.83 | 29.99 | 3233.0 |
| 2008-05-15 08:30:00 | MSFT | Stock | 29.93 | 29.98 | 29.93 | 29.98 | 5200.0 |
| 2008-05-15 09:00:00 | MSFT | Stock | 29.99 | 30.03 | 29.93 | 29.95 | 79545.0 |
| 2008-05-15 09:30:00 | MSFT | Stock | 29.95 | 30.15 | 29.94 | 30.13 | 5791510.0 |
| 2008-05-15 10:00:00 | MSFT | Stock | 30.13 | 30.15 | 29.98 | 30.06 | 3554780.0 |
| 2008-05-15 10:30:00 | MSFT | Stock | 30.07 | 30.1 | 30.02 | 30.06 | 2102039.0 |
| 2008-05-15 11:00:00 | MSFT | Stock | 30.07 | 30.11 | 29.98 | 30.08 | 3066235.0 |
| 2008-05-15 11:30:00 | MSFT | Stock | 30.08 | 30.17 | 30.07 | 30.148 | 3700897.0 |
| 2008-05-15 12:00:00 | MSFT | Stock | 30.14 | 30.36 | 30.14 | 30.36 | 4840863.0 |
| 2008-05-15 12:30:00 | MSFT | Stock | 30.35 | 30.41 | 30.29 | 30.36 | 3485167.0 |
| 2008-05-15 13:00:00 | MSFT | Stock | 30.35 | 30.45 | 30.33 | 30.37 | 3342674.0 |
| 2008-05-15 13:30:00 | MSFT | Stock | 30.36 | 30.39 | 30.26 | 30.34 | 2958253.0 |
| 2008-05-15 14:00:00 | MSFT | Stock | 30.34 | 30.38 | 30.29 | 30.3 | 3084904.0 |
| 2008-05-15 14:30:00 | MSFT | Stock | 30.3 | 30.35 | 30.24 | 30.32 | 3453790.0 |
| 2008-05-15 15:00:00 | MSFT | Stock | 30.32 | 30.4 | 30.3 | 30.4 | 2886821.0 |
| 2008-05-15 15:30:00 | MSFT | Stock | 30.4 | 30.53 | 30.33 | 30.47 | 7496493.0 |
| 2008-05-15 16:00:00 | MSFT | Stock | 30.47 | 30.47 | 30.245 | 30.39 | 2356717.0 |
| 2008-05-15 16:30:00 | MSFT | Stock | 30.39 | 30.47 | 30.13 | 30.37 | 38876.0 |
| 2008-05-15 17:00:00 | MSFT | Stock | 30.39 | 30.4 | 30.39 | 30.4 | 2050.0 |
| 2008-05-15 17:30:00 | MSFT | Stock | 30.37 | 30.37 | 30.37 | 30.37 | 100.0 |
| 2008-05-15 18:00:00 | MSFT | Stock | 30.37 | 30.39 | 30.37 | 30.39 | 1200.0 |
| 2008-05-15 19:00:00 | MSFT | Stock | 30.39 | 30.41 | 30.37 | 30.37 | 1450.0 |
| 2008-05-15 19:30:00 | MSFT | Stock | 30.37 | 30.44 | 30.37 | 30.44 | 5893.0 |
| 2008-05-15 08:00:00 | NVDA | Stock | 0.5545 | 0.5582 | 0.5545 | 0.5582 | 147400.0 |
> showing 50 of 68,579 rows — these rows as CSV