PREVIEW / stock_30min / 2004-11-18
file: by_date/stock_30min/2004/2004-11-18.parquet size: 789 KB rows: 42,680 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-18 08:00:00 | AAPL | Stock | 0.9784 | 0.9786 | 0.9777 | 0.9777 | 25200.0 |
| 2004-11-18 08:30:00 | AAPL | Stock | 0.9804 | 0.9804 | 0.9768 | 0.9768 | 57064.0 |
| 2004-11-18 09:00:00 | AAPL | Stock | 0.9782 | 0.9795 | 0.9696 | 0.9696 | 1330336.0 |
| 2004-11-18 09:30:00 | AAPL | Stock | 0.9696 | 0.9873 | 0.9695 | 0.9827 | 68346992.0 |
| 2004-11-18 10:00:00 | AAPL | Stock | 0.9829 | 0.9902 | 0.9811 | 0.9895 | 77230776.0 |
| 2004-11-18 10:30:00 | AAPL | Stock | 0.9896 | 0.9902 | 0.9863 | 0.9875 | 44911944.0 |
| 2004-11-18 11:00:00 | AAPL | Stock | 0.9875 | 0.9888 | 0.9846 | 0.9877 | 29866480.0 |
| 2004-11-18 11:30:00 | AAPL | Stock | 0.9879 | 0.9902 | 0.9866 | 0.9875 | 35527968.0 |
| 2004-11-18 12:00:00 | AAPL | Stock | 0.9877 | 0.9884 | 0.9848 | 0.9873 | 14306096.0 |
| 2004-11-18 12:30:00 | AAPL | Stock | 0.9873 | 0.9888 | 0.9863 | 0.9868 | 13791512.0 |
| 2004-11-18 13:00:00 | AAPL | Stock | 0.9866 | 0.9886 | 0.9836 | 0.987 | 21874440.0 |
| 2004-11-18 13:30:00 | AAPL | Stock | 0.987 | 0.9896 | 0.9859 | 0.9891 | 18031944.0 |
| 2004-11-18 14:00:00 | AAPL | Stock | 0.9891 | 0.9902 | 0.9864 | 0.9875 | 15925168.0 |
| 2004-11-18 14:30:00 | AAPL | Stock | 0.9879 | 0.9891 | 0.9864 | 0.988 | 17306856.0 |
| 2004-11-18 15:00:00 | AAPL | Stock | 0.9879 | 0.99 | 0.987 | 0.9882 | 31382512.0 |
| 2004-11-18 15:30:00 | AAPL | Stock | 0.9882 | 0.9895 | 0.987 | 0.9893 | 42263872.0 |
| 2004-11-18 16:00:00 | AAPL | Stock | 0.9893 | 0.99 | 0.987 | 0.9895 | 4300800.0 |
| 2004-11-18 16:30:00 | AAPL | Stock | 0.9895 | 0.9898 | 0.9895 | 0.9895 | 84000.0 |
| 2004-11-18 17:00:00 | AAPL | Stock | 0.9891 | 0.9911 | 0.9891 | 0.9911 | 853160.0 |
| 2004-11-18 17:30:00 | AAPL | Stock | 0.9885 | 0.9911 | 0.9884 | 0.9911 | 1405040.0 |
| 2004-11-18 18:00:00 | AAPL | Stock | 0.9913 | 0.9916 | 0.9913 | 0.9916 | 17360.0 |
| 2004-11-18 08:00:00 | MSFT | Stock | 27.15 | 27.17 | 27.08 | 27.1 | 14240.0 |
| 2004-11-18 08:30:00 | MSFT | Stock | 27.1 | 27.18 | 27.1 | 27.11 | 18274.0 |
| 2004-11-18 09:00:00 | MSFT | Stock | 27.11 | 27.13 | 27.08 | 27.12 | 70632.0 |
| 2004-11-18 09:30:00 | MSFT | Stock | 27.13 | 27.17 | 27.06 | 27.09 | 6870798.0 |
| 2004-11-18 10:00:00 | MSFT | Stock | 27.09 | 27.11 | 27.0198 | 27.07 | 6649689.0 |
| 2004-11-18 10:30:00 | MSFT | Stock | 27.07 | 27.12 | 27.05 | 27.11 | 3655677.0 |
| 2004-11-18 11:00:00 | MSFT | Stock | 27.12 | 27.13 | 27.04 | 27.06 | 3099973.0 |
| 2004-11-18 11:30:00 | MSFT | Stock | 27.05 | 27.09 | 27.02 | 27.03 | 5674693.0 |
| 2004-11-18 12:00:00 | MSFT | Stock | 27.03 | 27.06 | 27.02 | 27.03 | 2966291.0 |
| 2004-11-18 12:30:00 | MSFT | Stock | 27.03 | 27.05 | 27.03 | 27.03 | 1515451.0 |
| 2004-11-18 13:00:00 | MSFT | Stock | 27.04 | 27.05 | 27.03 | 27.03 | 1717652.0 |
| 2004-11-18 13:30:00 | MSFT | Stock | 27.03 | 27.06 | 27.03 | 27.05 | 1843750.0 |
| 2004-11-18 14:00:00 | MSFT | Stock | 27.05 | 27.07 | 27.03 | 27.05 | 3477092.0 |
| 2004-11-18 14:30:00 | MSFT | Stock | 27.05 | 27.1 | 27.02 | 27.08 | 3509541.0 |
| 2004-11-18 15:00:00 | MSFT | Stock | 27.09 | 27.09 | 27.03 | 27.04 | 3135553.0 |
| 2004-11-18 15:30:00 | MSFT | Stock | 27.04 | 27.11 | 27.04 | 27.06 | 4755241.0 |
| 2004-11-18 16:00:00 | MSFT | Stock | 27.07 | 27.083 | 27.04 | 27.07 | 958178.0 |
| 2004-11-18 16:30:00 | MSFT | Stock | 27.06 | 27.07 | 27.04 | 27.04 | 27635.0 |
| 2004-11-18 17:00:00 | MSFT | Stock | 27.07 | 27.18 | 27.04 | 27.05 | 2030471.0 |
| 2004-11-18 17:30:00 | MSFT | Stock | 27.07 | 27.09 | 27.04 | 27.04 | 105994.0 |
| 2004-11-18 18:00:00 | MSFT | Stock | 27.05 | 27.06 | 27.04 | 27.04 | 3975.0 |
| 2004-11-18 08:00:00 | NVDA | Stock | 0.155 | 0.155 | 0.1542 | 0.1542 | 237000.0 |
| 2004-11-18 08:30:00 | NVDA | Stock | 0.1547 | 0.1547 | 0.1537 | 0.1537 | 144000.0 |
| 2004-11-18 09:00:00 | NVDA | Stock | 0.1546 | 0.1564 | 0.1537 | 0.1564 | 1695720.0 |
| 2004-11-18 09:30:00 | NVDA | Stock | 0.1564 | 0.1565 | 0.1532 | 0.1553 | 98436720.0 |
| 2004-11-18 10:00:00 | NVDA | Stock | 0.1553 | 0.1563 | 0.1546 | 0.1558 | 59209800.0 |
| 2004-11-18 10:30:00 | NVDA | Stock | 0.1558 | 0.1579 | 0.1557 | 0.1578 | 37623840.0 |
| 2004-11-18 11:00:00 | NVDA | Stock | 0.1579 | 0.1582 | 0.1567 | 0.157 | 44378040.0 |
| 2004-11-18 11:30:00 | NVDA | Stock | 0.157 | 0.158 | 0.1569 | 0.1574 | 18926040.0 |
> showing 50 of 42,680 rows — these rows as CSV