PREVIEW / stock_30min / 2006-03-23
file: by_date/stock_30min/2006/2006-03-23.parquet size: 881 KB rows: 47,607 symbols: 2,213
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-03-23 04:00:00 | AAPL | Stock | 2.2036 | 2.2036 | 2.2036 | 2.2036 | 28000.0 |
| 2006-03-23 06:30:00 | AAPL | Stock | 2.1893 | 2.1893 | 2.1893 | 2.1893 | 2800.0 |
| 2006-03-23 07:00:00 | AAPL | Stock | 2.1929 | 2.1961 | 2.1929 | 2.1961 | 11200.0 |
| 2006-03-23 07:30:00 | AAPL | Stock | 2.1929 | 2.1964 | 2.1893 | 2.195 | 71400.0 |
| 2006-03-23 08:00:00 | AAPL | Stock | 2.1957 | 2.2043 | 2.1921 | 2.2039 | 1954092.0 |
| 2006-03-23 08:30:00 | AAPL | Stock | 2.2046 | 2.2111 | 2.1964 | 2.2036 | 2245096.0 |
| 2006-03-23 09:00:00 | AAPL | Stock | 2.2036 | 2.2089 | 2.2032 | 2.2089 | 1467648.0 |
| 2006-03-23 09:30:00 | AAPL | Stock | 2.2079 | 2.2107 | 2.1721 | 2.1771 | 154567924.0 |
| 2006-03-23 10:00:00 | AAPL | Stock | 2.1771 | 2.1861 | 2.1711 | 2.1764 | 105988288.0 |
| 2006-03-23 10:30:00 | AAPL | Stock | 2.1768 | 2.1786 | 2.1636 | 2.1729 | 93451064.0 |
| 2006-03-23 11:00:00 | AAPL | Stock | 2.1729 | 2.1771 | 2.1618 | 2.1686 | 82923456.0 |
| 2006-03-23 11:30:00 | AAPL | Stock | 2.1686 | 2.1689 | 2.1469 | 2.1507 | 125974940.0 |
| 2006-03-23 12:00:00 | AAPL | Stock | 2.1507 | 2.1536 | 2.1361 | 2.1407 | 149762312.0 |
| 2006-03-23 12:30:00 | AAPL | Stock | 2.1404 | 2.1589 | 2.1396 | 2.1454 | 101419052.0 |
| 2006-03-23 13:00:00 | AAPL | Stock | 2.145 | 2.1539 | 2.1396 | 2.1493 | 68132932.0 |
| 2006-03-23 13:30:00 | AAPL | Stock | 2.1493 | 2.15 | 2.1389 | 2.1467 | 75385072.0 |
| 2006-03-23 14:00:00 | AAPL | Stock | 2.1464 | 2.1479 | 2.1307 | 2.1364 | 91786380.0 |
| 2006-03-23 14:30:00 | AAPL | Stock | 2.1364 | 2.2036 | 2.1289 | 2.1318 | 85708140.0 |
| 2006-03-23 15:00:00 | AAPL | Stock | 2.1314 | 2.155 | 2.13 | 2.1496 | 130793320.0 |
| 2006-03-23 15:30:00 | AAPL | Stock | 2.1504 | 2.1579 | 2.1407 | 2.1479 | 137906832.0 |
| 2006-03-23 16:00:00 | AAPL | Stock | 2.1475 | 2.1489 | 2.1432 | 2.1479 | 3252564.0 |
| 2006-03-23 16:30:00 | AAPL | Stock | 2.1479 | 2.1479 | 2.1446 | 2.145 | 703836.0 |
| 2006-03-23 17:00:00 | AAPL | Stock | 2.1446 | 2.1479 | 2.1446 | 2.1464 | 420924.0 |
| 2006-03-23 17:30:00 | AAPL | Stock | 2.1464 | 2.1518 | 2.1446 | 2.15 | 1848588.0 |
| 2006-03-23 18:00:00 | AAPL | Stock | 2.15 | 2.16 | 2.15 | 2.16 | 1889860.0 |
| 2006-03-23 04:00:00 | MSFT | Stock | 27.13 | 27.13 | 27.13 | 27.13 | 100.0 |
| 2006-03-23 08:00:00 | MSFT | Stock | 27.12 | 27.2 | 27.1 | 27.12 | 9420.0 |
| 2006-03-23 08:30:00 | MSFT | Stock | 27.12 | 27.12 | 27.09 | 27.11 | 4951.0 |
| 2006-03-23 09:00:00 | MSFT | Stock | 27.11 | 27.12 | 27.08 | 27.09 | 56720.0 |
| 2006-03-23 09:30:00 | MSFT | Stock | 27.08 | 27.1 | 27.0 | 27.01 | 5823681.0 |
| 2006-03-23 10:00:00 | MSFT | Stock | 27.02 | 27.09 | 26.8 | 26.87 | 10477991.0 |
| 2006-03-23 10:30:00 | MSFT | Stock | 26.87 | 26.93 | 26.67 | 26.7 | 12064076.0 |
| 2006-03-23 11:00:00 | MSFT | Stock | 26.71 | 26.85 | 26.66 | 26.78 | 7668812.0 |
| 2006-03-23 11:30:00 | MSFT | Stock | 26.782 | 26.8 | 26.74 | 26.77 | 3367548.0 |
| 2006-03-23 12:00:00 | MSFT | Stock | 26.77 | 26.78 | 26.68 | 26.7 | 3118334.0 |
| 2006-03-23 12:30:00 | MSFT | Stock | 26.7 | 27.085 | 26.69 | 26.76 | 2970746.0 |
| 2006-03-23 13:00:00 | MSFT | Stock | 26.76 | 26.78 | 26.72 | 26.77 | 2374250.0 |
| 2006-03-23 13:30:00 | MSFT | Stock | 26.768 | 26.81 | 26.73 | 26.81 | 3242255.0 |
| 2006-03-23 14:00:00 | MSFT | Stock | 26.8 | 26.81 | 26.7 | 26.77 | 3599342.0 |
| 2006-03-23 14:30:00 | MSFT | Stock | 26.76 | 26.77 | 26.72 | 26.75 | 3075601.0 |
| 2006-03-23 15:00:00 | MSFT | Stock | 26.741 | 26.85 | 26.73 | 26.85 | 5966197.0 |
| 2006-03-23 15:30:00 | MSFT | Stock | 26.85 | 26.91 | 26.82 | 26.85 | 7444382.0 |
| 2006-03-23 16:00:00 | MSFT | Stock | 26.85 | 26.86 | 26.8 | 26.8 | 170788.0 |
| 2006-03-23 16:30:00 | MSFT | Stock | 26.87 | 26.87 | 26.82 | 26.83 | 2425.0 |
| 2006-03-23 17:00:00 | MSFT | Stock | 26.83 | 26.83 | 26.81 | 26.81 | 3923.0 |
| 2006-03-23 17:30:00 | MSFT | Stock | 26.84 | 26.85 | 26.84 | 26.84 | 5000.0 |
| 2006-03-23 18:00:00 | MSFT | Stock | 26.87 | 26.87 | 26.85 | 26.85 | 111462.0 |
| 2006-03-23 08:00:00 | NVDA | Stock | 0.4157 | 0.4157 | 0.415 | 0.4157 | 324000.0 |
| 2006-03-23 08:30:00 | NVDA | Stock | 0.4142 | 0.4148 | 0.4142 | 0.4148 | 144840.0 |
| 2006-03-23 09:00:00 | NVDA | Stock | 0.4147 | 0.4147 | 0.412 | 0.4125 | 5941440.0 |
> showing 50 of 47,607 rows — these rows as CSV