PREVIEW / stock_30min / 2006-06-08
file: by_date/stock_30min/2006/2006-06-08.parquet size: 940 KB rows: 50,179 symbols: 2,288
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-06-08 04:00:00 | AAPL | Stock | 2.0696 | 2.0696 | 2.0696 | 2.0696 | 5600.0 |
| 2006-06-08 05:00:00 | AAPL | Stock | 2.0679 | 2.0679 | 2.0679 | 2.0679 | 5600.0 |
| 2006-06-08 07:00:00 | AAPL | Stock | 2.0693 | 2.0714 | 2.0671 | 2.0714 | 11200.0 |
| 2006-06-08 07:30:00 | AAPL | Stock | 2.0696 | 2.075 | 2.0696 | 2.0714 | 294000.0 |
| 2006-06-08 08:00:00 | AAPL | Stock | 2.0714 | 2.0814 | 2.0714 | 2.0804 | 950488.0 |
| 2006-06-08 08:30:00 | AAPL | Stock | 2.0811 | 2.1 | 2.0714 | 2.0964 | 3081428.0 |
| 2006-06-08 09:00:00 | AAPL | Stock | 2.0964 | 2.0989 | 2.0843 | 2.0854 | 2023364.0 |
| 2006-06-08 09:30:00 | AAPL | Stock | 2.0871 | 2.1196 | 2.0843 | 2.1014 | 128360400.0 |
| 2006-06-08 10:00:00 | AAPL | Stock | 2.1011 | 2.1125 | 2.065 | 2.0686 | 121576728.0 |
| 2006-06-08 10:30:00 | AAPL | Stock | 2.0682 | 2.0732 | 2.0411 | 2.0689 | 128837352.0 |
| 2006-06-08 11:00:00 | AAPL | Stock | 2.0689 | 2.088 | 2.0518 | 2.0693 | 111167672.0 |
| 2006-06-08 11:30:00 | AAPL | Stock | 2.0693 | 2.0843 | 2.0611 | 2.0818 | 91485772.0 |
| 2006-06-08 12:00:00 | AAPL | Stock | 2.0818 | 2.1025 | 2.0814 | 2.0957 | 106934828.0 |
| 2006-06-08 12:30:00 | AAPL | Stock | 2.0961 | 2.1139 | 2.0868 | 2.1071 | 66409644.0 |
| 2006-06-08 13:00:00 | AAPL | Stock | 2.1075 | 2.1125 | 2.0864 | 2.0979 | 69511652.0 |
| 2006-06-08 13:30:00 | AAPL | Stock | 2.0979 | 2.1161 | 2.0907 | 2.1161 | 77265664.0 |
| 2006-06-08 14:00:00 | AAPL | Stock | 2.1161 | 2.13 | 2.1061 | 2.1296 | 81534068.0 |
| 2006-06-08 14:30:00 | AAPL | Stock | 2.1293 | 2.1475 | 2.1243 | 2.1386 | 119256480.0 |
| 2006-06-08 15:00:00 | AAPL | Stock | 2.1386 | 2.1686 | 2.1361 | 2.1589 | 143693312.0 |
| 2006-06-08 15:30:00 | AAPL | Stock | 2.1589 | 2.1761 | 2.1586 | 2.1707 | 131510428.0 |
| 2006-06-08 16:00:00 | AAPL | Stock | 2.1704 | 2.175 | 2.1607 | 2.1671 | 3978632.0 |
| 2006-06-08 16:30:00 | AAPL | Stock | 2.1671 | 2.1704 | 2.1646 | 2.1696 | 429604.0 |
| 2006-06-08 17:00:00 | AAPL | Stock | 2.1704 | 2.1721 | 2.1664 | 2.1721 | 253960.0 |
| 2006-06-08 17:30:00 | AAPL | Stock | 2.1721 | 2.175 | 2.1714 | 2.175 | 379680.0 |
| 2006-06-08 18:00:00 | AAPL | Stock | 2.1757 | 2.1768 | 2.1699 | 2.1746 | 293468.0 |
| 2006-06-08 04:00:00 | MSFT | Stock | 21.88 | 21.88 | 21.85 | 21.85 | 200.0 |
| 2006-06-08 05:00:00 | MSFT | Stock | 21.91 | 21.91 | 21.91 | 21.91 | 100.0 |
| 2006-06-08 05:30:00 | MSFT | Stock | 21.9 | 21.9 | 21.9 | 21.9 | 200.0 |
| 2006-06-08 06:30:00 | MSFT | Stock | 21.9 | 21.9 | 21.89 | 21.89 | 1250.0 |
| 2006-06-08 07:00:00 | MSFT | Stock | 21.9 | 21.9 | 21.86 | 21.9 | 1450.0 |
| 2006-06-08 07:30:00 | MSFT | Stock | 21.93 | 21.94 | 21.9 | 21.94 | 13671.0 |
| 2006-06-08 08:00:00 | MSFT | Stock | 21.99 | 22.03 | 21.93 | 22.0 | 50756.0 |
| 2006-06-08 08:30:00 | MSFT | Stock | 22.03 | 22.03 | 21.98 | 22.0 | 25544.0 |
| 2006-06-08 09:00:00 | MSFT | Stock | 22.03 | 22.04 | 22.0 | 22.04 | 132578.0 |
| 2006-06-08 09:30:00 | MSFT | Stock | 22.03 | 22.17 | 21.98 | 22.11 | 11147320.0 |
| 2006-06-08 10:00:00 | MSFT | Stock | 22.11 | 22.18 | 22.05 | 22.08 | 8762317.0 |
| 2006-06-08 10:30:00 | MSFT | Stock | 22.08 | 22.14 | 22.04 | 22.1 | 10671963.0 |
| 2006-06-08 11:00:00 | MSFT | Stock | 22.1 | 22.16 | 22.03 | 22.04 | 10013779.0 |
| 2006-06-08 11:30:00 | MSFT | Stock | 22.05 | 22.1 | 21.97 | 22.02 | 10839900.0 |
| 2006-06-08 12:00:00 | MSFT | Stock | 22.02 | 22.07 | 22.0 | 22.02 | 5935006.0 |
| 2006-06-08 12:30:00 | MSFT | Stock | 22.029 | 22.13 | 22.0 | 22.07 | 5170528.0 |
| 2006-06-08 13:00:00 | MSFT | Stock | 22.07 | 22.07 | 22.0 | 22.02 | 5034112.0 |
| 2006-06-08 13:30:00 | MSFT | Stock | 22.02 | 22.14 | 22.0 | 22.12 | 4974149.0 |
| 2006-06-08 14:00:00 | MSFT | Stock | 22.12 | 22.14 | 22.03 | 22.08 | 4346943.0 |
| 2006-06-08 14:30:00 | MSFT | Stock | 22.08 | 22.15 | 22.05 | 22.09 | 5751854.0 |
| 2006-06-08 15:00:00 | MSFT | Stock | 22.09 | 22.16 | 22.08 | 22.14 | 7908974.0 |
| 2006-06-08 15:30:00 | MSFT | Stock | 22.14 | 22.21 | 22.11 | 22.12 | 10315772.0 |
| 2006-06-08 16:00:00 | MSFT | Stock | 22.1 | 22.193 | 22.08 | 22.13 | 551356.0 |
| 2006-06-08 16:30:00 | MSFT | Stock | 22.13 | 22.13 | 22.08 | 22.11 | 945121.0 |
| 2006-06-08 17:00:00 | MSFT | Stock | 22.1 | 22.11 | 22.09 | 22.11 | 67424.0 |
> showing 50 of 50,179 rows — these rows as CSV