PREVIEW / stock_30min / 2006-12-19
file: by_date/stock_30min/2006/2006-12-19.parquet size: 980 KB rows: 52,974 symbols: 2,492
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-19 07:30:00 | AAPL | Stock | 3.035 | 3.0446 | 3.035 | 3.0379 | 120400.0 |
| 2006-12-19 08:00:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0268 | 3.0357 | 2216592.0 |
| 2006-12-19 08:30:00 | AAPL | Stock | 3.0329 | 3.0329 | 3.0179 | 3.0275 | 2683716.0 |
| 2006-12-19 09:00:00 | AAPL | Stock | 3.0279 | 3.0279 | 3.02 | 3.025 | 3251668.0 |
| 2006-12-19 09:30:00 | AAPL | Stock | 3.0261 | 3.03 | 2.9864 | 3.0239 | 148366372.0 |
| 2006-12-19 10:00:00 | AAPL | Stock | 3.0239 | 3.0646 | 3.0232 | 3.0525 | 118884416.0 |
| 2006-12-19 10:30:00 | AAPL | Stock | 3.0521 | 3.0589 | 3.0329 | 3.0586 | 79162552.0 |
| 2006-12-19 11:00:00 | AAPL | Stock | 3.0579 | 3.0707 | 3.04 | 3.045 | 69785156.0 |
| 2006-12-19 11:30:00 | AAPL | Stock | 3.045 | 3.0596 | 3.0429 | 3.0539 | 36546468.0 |
| 2006-12-19 12:00:00 | AAPL | Stock | 3.0539 | 3.0796 | 3.0511 | 3.0742 | 78076012.0 |
| 2006-12-19 12:30:00 | AAPL | Stock | 3.0736 | 3.0886 | 3.0686 | 3.0818 | 45967964.0 |
| 2006-12-19 13:00:00 | AAPL | Stock | 3.0818 | 3.0839 | 3.0579 | 3.0579 | 37890132.0 |
| 2006-12-19 13:30:00 | AAPL | Stock | 3.0581 | 3.07 | 3.0514 | 3.0686 | 49227024.0 |
| 2006-12-19 14:00:00 | AAPL | Stock | 3.0682 | 3.0771 | 3.0607 | 3.0607 | 45505068.0 |
| 2006-12-19 14:30:00 | AAPL | Stock | 3.0607 | 3.0718 | 3.06 | 3.0704 | 31884412.0 |
| 2006-12-19 15:00:00 | AAPL | Stock | 3.0707 | 3.0893 | 3.0699 | 3.0811 | 69932268.0 |
| 2006-12-19 15:30:00 | AAPL | Stock | 3.0807 | 3.0957 | 3.0754 | 3.0818 | 80837092.0 |
| 2006-12-19 16:00:00 | AAPL | Stock | 3.0829 | 3.0918 | 3.0814 | 3.0871 | 1317456.0 |
| 2006-12-19 16:30:00 | AAPL | Stock | 3.0871 | 3.0871 | 3.0846 | 3.0857 | 163716.0 |
| 2006-12-19 17:00:00 | AAPL | Stock | 3.0857 | 3.0889 | 3.0857 | 3.0857 | 154476.0 |
| 2006-12-19 17:30:00 | AAPL | Stock | 3.0846 | 3.0846 | 3.0846 | 3.0846 | 2800.0 |
| 2006-12-19 18:00:00 | AAPL | Stock | 3.0857 | 3.0875 | 3.085 | 3.0875 | 132356.0 |
| 2006-12-19 18:30:00 | AAPL | Stock | 3.0875 | 3.0875 | 3.0875 | 3.0875 | 31360.0 |
| 2006-12-19 19:00:00 | AAPL | Stock | 3.0875 | 3.0886 | 3.0875 | 3.0886 | 40600.0 |
| 2006-12-19 19:30:00 | AAPL | Stock | 3.085 | 3.085 | 3.0829 | 3.0846 | 133980.0 |
| 2006-12-19 08:00:00 | MSFT | Stock | 29.8 | 29.8 | 29.75 | 29.79 | 12080.0 |
| 2006-12-19 08:30:00 | MSFT | Stock | 29.79 | 29.79 | 29.75 | 29.75 | 6715.0 |
| 2006-12-19 09:00:00 | MSFT | Stock | 29.75 | 29.75 | 29.62 | 29.68 | 110035.0 |
| 2006-12-19 09:30:00 | MSFT | Stock | 29.71 | 29.74 | 29.6 | 29.71 | 4450766.0 |
| 2006-12-19 10:00:00 | MSFT | Stock | 29.71 | 29.88 | 29.68 | 29.8 | 4664093.0 |
| 2006-12-19 10:30:00 | MSFT | Stock | 29.8 | 29.88 | 29.78 | 29.84 | 2784890.0 |
| 2006-12-19 11:00:00 | MSFT | Stock | 29.83 | 29.9 | 29.53 | 29.8 | 2417061.0 |
| 2006-12-19 11:30:00 | MSFT | Stock | 29.811 | 29.87 | 29.8 | 29.83 | 1952440.0 |
| 2006-12-19 12:00:00 | MSFT | Stock | 29.821 | 29.9 | 29.74 | 29.81 | 2722914.0 |
| 2006-12-19 12:30:00 | MSFT | Stock | 29.81 | 29.887 | 29.8 | 29.847 | 1949260.0 |
| 2006-12-19 13:00:00 | MSFT | Stock | 29.845 | 29.869 | 29.76 | 29.76 | 1817195.0 |
| 2006-12-19 13:30:00 | MSFT | Stock | 29.76 | 29.94 | 29.76 | 29.93 | 3259744.0 |
| 2006-12-19 14:00:00 | MSFT | Stock | 29.93 | 30.0 | 29.91 | 29.94 | 3636527.0 |
| 2006-12-19 14:30:00 | MSFT | Stock | 29.94 | 30.17 | 29.94 | 30.07 | 3298098.0 |
| 2006-12-19 15:00:00 | MSFT | Stock | 30.07 | 30.16 | 30.0 | 30.0 | 5093037.0 |
| 2006-12-19 15:30:00 | MSFT | Stock | 30.0 | 30.03 | 29.93 | 29.99 | 6750751.0 |
| 2006-12-19 16:00:00 | MSFT | Stock | 29.99 | 29.99 | 29.88 | 29.95 | 3778129.0 |
| 2006-12-19 16:30:00 | MSFT | Stock | 29.95 | 29.95 | 29.91 | 29.92 | 10272.0 |
| 2006-12-19 17:00:00 | MSFT | Stock | 29.93 | 29.93 | 29.92 | 29.92 | 700.0 |
| 2006-12-19 17:30:00 | MSFT | Stock | 29.93 | 29.93 | 29.92 | 29.92 | 897.0 |
| 2006-12-19 18:00:00 | MSFT | Stock | 29.92 | 29.92 | 29.91 | 29.91 | 500.0 |
| 2006-12-19 18:30:00 | MSFT | Stock | 29.94 | 29.94 | 29.94 | 29.94 | 250.0 |
| 2006-12-19 19:00:00 | MSFT | Stock | 29.93 | 29.93 | 29.93 | 29.93 | 800.0 |
| 2006-12-19 19:30:00 | MSFT | Stock | 29.93 | 29.93 | 29.93 | 29.93 | 100.0 |
| 2006-12-19 08:00:00 | NVDA | Stock | 0.6333 | 0.6333 | 0.6293 | 0.6293 | 306480.0 |
> showing 50 of 52,974 rows — these rows as CSV