PREVIEW / stock_30min / 2004-11-17
file: by_date/stock_30min/2004/2004-11-17.parquet size: 794 KB rows: 42,722 symbols: 1,880
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-17 08:00:00 | AAPL | Stock | 0.9864 | 0.9864 | 0.9857 | 0.9857 | 36960.0 |
| 2004-11-17 08:30:00 | AAPL | Stock | 0.9821 | 0.9893 | 0.9821 | 0.9893 | 398720.0 |
| 2004-11-17 09:00:00 | AAPL | Stock | 0.9893 | 0.9911 | 0.9829 | 0.9863 | 950880.0 |
| 2004-11-17 09:30:00 | AAPL | Stock | 0.9855 | 0.9902 | 0.9796 | 0.9814 | 47844832.0 |
| 2004-11-17 10:00:00 | AAPL | Stock | 0.9814 | 0.9896 | 0.9804 | 0.9875 | 46341008.0 |
| 2004-11-17 10:30:00 | AAPL | Stock | 0.9873 | 0.9893 | 0.9829 | 0.9857 | 34821752.0 |
| 2004-11-17 11:00:00 | AAPL | Stock | 0.9861 | 0.9884 | 0.985 | 0.9882 | 21149688.0 |
| 2004-11-17 11:30:00 | AAPL | Stock | 0.9884 | 0.9902 | 0.9857 | 0.9886 | 26791520.0 |
| 2004-11-17 12:00:00 | AAPL | Stock | 0.9886 | 0.99 | 0.9866 | 0.9871 | 18704728.0 |
| 2004-11-17 12:30:00 | AAPL | Stock | 0.9875 | 0.988 | 0.9861 | 0.9877 | 14662760.0 |
| 2004-11-17 13:00:00 | AAPL | Stock | 0.9879 | 0.9889 | 0.9866 | 0.9875 | 13278104.0 |
| 2004-11-17 13:30:00 | AAPL | Stock | 0.9875 | 0.9875 | 0.98 | 0.98 | 23588824.0 |
| 2004-11-17 14:00:00 | AAPL | Stock | 0.9802 | 0.9802 | 0.9716 | 0.973 | 35189896.0 |
| 2004-11-17 14:30:00 | AAPL | Stock | 0.9732 | 0.9798 | 0.9682 | 0.9791 | 39894848.0 |
| 2004-11-17 15:00:00 | AAPL | Stock | 0.9795 | 0.9821 | 0.9746 | 0.9755 | 29098944.0 |
| 2004-11-17 15:30:00 | AAPL | Stock | 0.9755 | 0.9805 | 0.9718 | 0.9804 | 30059288.0 |
| 2004-11-17 16:00:00 | AAPL | Stock | 0.9805 | 0.9805 | 0.9782 | 0.9802 | 1942920.0 |
| 2004-11-17 16:30:00 | AAPL | Stock | 0.9802 | 0.9804 | 0.9802 | 0.9804 | 337456.0 |
| 2004-11-17 17:00:00 | AAPL | Stock | 0.9752 | 0.9803 | 0.9752 | 0.9803 | 967008.0 |
| 2004-11-17 17:30:00 | AAPL | Stock | 0.9804 | 0.9811 | 0.9804 | 0.9811 | 16800.0 |
| 2004-11-17 18:00:00 | AAPL | Stock | 0.978 | 0.978 | 0.9779 | 0.9779 | 36960.0 |
| 2004-11-17 08:00:00 | MSFT | Stock | 27.27 | 27.31 | 27.21 | 27.3 | 126329.0 |
| 2004-11-17 08:30:00 | MSFT | Stock | 27.39 | 27.39 | 27.28 | 27.28 | 230066.0 |
| 2004-11-17 09:00:00 | MSFT | Stock | 27.28 | 27.33 | 27.13 | 27.24 | 312962.0 |
| 2004-11-17 09:30:00 | MSFT | Stock | 27.25 | 27.36 | 27.16 | 27.18 | 8523826.0 |
| 2004-11-17 10:00:00 | MSFT | Stock | 27.18 | 27.341 | 27.16 | 27.31 | 6276239.0 |
| 2004-11-17 10:30:00 | MSFT | Stock | 27.3 | 27.34 | 27.23 | 27.25 | 4739810.0 |
| 2004-11-17 11:00:00 | MSFT | Stock | 27.25 | 27.33 | 27.23 | 27.31 | 3679304.0 |
| 2004-11-17 11:30:00 | MSFT | Stock | 27.32 | 27.32 | 27.25 | 27.25 | 3476198.0 |
| 2004-11-17 12:00:00 | MSFT | Stock | 27.261 | 27.2902 | 27.25 | 27.29 | 2989236.0 |
| 2004-11-17 12:30:00 | MSFT | Stock | 27.29 | 27.3 | 27.25 | 27.28 | 2403026.0 |
| 2004-11-17 13:00:00 | MSFT | Stock | 27.285 | 27.29 | 27.25 | 27.27 | 1713487.0 |
| 2004-11-17 13:30:00 | MSFT | Stock | 27.265 | 27.27 | 27.22 | 27.23 | 2555080.0 |
| 2004-11-17 14:00:00 | MSFT | Stock | 27.225 | 27.23 | 27.11 | 27.12 | 5449912.0 |
| 2004-11-17 14:30:00 | MSFT | Stock | 27.13 | 27.16 | 27.06 | 27.15 | 5336513.0 |
| 2004-11-17 15:00:00 | MSFT | Stock | 27.15 | 27.18 | 27.11 | 27.12 | 3244839.0 |
| 2004-11-17 15:30:00 | MSFT | Stock | 27.11 | 27.16 | 27.09 | 27.15 | 4914174.0 |
| 2004-11-17 16:00:00 | MSFT | Stock | 27.16 | 27.2 | 27.13 | 27.14 | 734601.0 |
| 2004-11-17 16:30:00 | MSFT | Stock | 27.17 | 27.18 | 27.13 | 27.14 | 55487.0 |
| 2004-11-17 17:00:00 | MSFT | Stock | 27.18 | 27.18 | 27.12 | 27.174 | 141373.0 |
| 2004-11-17 17:30:00 | MSFT | Stock | 27.13 | 27.2363 | 27.12 | 27.15 | 116980.0 |
| 2004-11-17 18:00:00 | MSFT | Stock | 27.14 | 27.15 | 27.13 | 27.15 | 3743.0 |
| 2004-11-17 18:30:00 | MSFT | Stock | 27.12 | 27.12 | 27.12 | 27.12 | 595.0 |
| 2004-11-17 08:00:00 | NVDA | Stock | 0.1538 | 0.154 | 0.1538 | 0.154 | 432000.0 |
| 2004-11-17 08:30:00 | NVDA | Stock | 0.154 | 0.1546 | 0.154 | 0.1546 | 612000.0 |
| 2004-11-17 09:00:00 | NVDA | Stock | 0.1542 | 0.1551 | 0.1534 | 0.1549 | 970560.0 |
| 2004-11-17 09:30:00 | NVDA | Stock | 0.1544 | 0.1554 | 0.1537 | 0.1551 | 71850120.0 |
| 2004-11-17 10:00:00 | NVDA | Stock | 0.1552 | 0.1567 | 0.1549 | 0.1567 | 54624360.0 |
| 2004-11-17 10:30:00 | NVDA | Stock | 0.1567 | 0.1571 | 0.1556 | 0.157 | 56004360.0 |
| 2004-11-17 11:00:00 | NVDA | Stock | 0.1571 | 0.1574 | 0.1568 | 0.1573 | 30156600.0 |
> showing 50 of 42,722 rows — these rows as CSV