PREVIEW / stock_30min / 2006-06-09
file: by_date/stock_30min/2006/2006-06-09.parquet size: 890 KB rows: 48,365 symbols: 2,271
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-09 07:00:00 | AAPL | Stock | 2.1821 | 2.1839 | 2.1521 | 2.1839 | 78400.0 |
| 2006-06-09 07:30:00 | AAPL | Stock | 2.1857 | 2.1879 | 2.1839 | 2.1839 | 81760.0 |
| 2006-06-09 08:00:00 | AAPL | Stock | 2.1864 | 2.1964 | 2.18 | 2.1875 | 3754296.0 |
| 2006-06-09 08:30:00 | AAPL | Stock | 2.1857 | 2.1882 | 2.1729 | 2.1832 | 1375808.0 |
| 2006-06-09 09:00:00 | AAPL | Stock | 2.1821 | 2.1857 | 2.1786 | 2.1857 | 2060464.0 |
| 2006-06-09 09:30:00 | AAPL | Stock | 2.185 | 2.1986 | 2.1632 | 2.165 | 157730272.0 |
| 2006-06-09 10:00:00 | AAPL | Stock | 2.165 | 2.1675 | 2.1443 | 2.1671 | 94301452.0 |
| 2006-06-09 10:30:00 | AAPL | Stock | 2.1671 | 2.17 | 2.1271 | 2.135 | 93966376.0 |
| 2006-06-09 11:00:00 | AAPL | Stock | 2.135 | 2.1475 | 2.1311 | 2.1475 | 54284356.0 |
| 2006-06-09 11:30:00 | AAPL | Stock | 2.1475 | 2.1554 | 2.1354 | 2.1407 | 46393984.0 |
| 2006-06-09 12:00:00 | AAPL | Stock | 2.1407 | 2.145 | 2.1339 | 2.1379 | 21470988.0 |
| 2006-06-09 12:30:00 | AAPL | Stock | 2.1379 | 2.1425 | 2.1257 | 2.13 | 26357520.0 |
| 2006-06-09 13:00:00 | AAPL | Stock | 2.13 | 2.1318 | 2.1118 | 2.1146 | 42104888.0 |
| 2006-06-09 13:30:00 | AAPL | Stock | 2.1146 | 2.1332 | 2.1121 | 2.1282 | 32651444.0 |
| 2006-06-09 14:00:00 | AAPL | Stock | 2.1282 | 2.145 | 2.1196 | 2.14 | 37449412.0 |
| 2006-06-09 14:30:00 | AAPL | Stock | 2.1404 | 2.1432 | 2.1304 | 2.1304 | 38176040.0 |
| 2006-06-09 15:00:00 | AAPL | Stock | 2.1307 | 2.1332 | 2.1186 | 2.1257 | 45607100.0 |
| 2006-06-09 15:30:00 | AAPL | Stock | 2.1257 | 2.1271 | 2.1107 | 2.1154 | 67505928.0 |
| 2006-06-09 16:00:00 | AAPL | Stock | 2.1161 | 2.1339 | 2.1107 | 2.1129 | 3736376.0 |
| 2006-06-09 16:30:00 | AAPL | Stock | 2.1139 | 2.1139 | 2.1118 | 2.1132 | 159796.0 |
| 2006-06-09 17:00:00 | AAPL | Stock | 2.1132 | 2.1157 | 2.1132 | 2.1157 | 55664.0 |
| 2006-06-09 17:30:00 | AAPL | Stock | 2.1154 | 2.1154 | 2.1125 | 2.1125 | 50400.0 |
| 2006-06-09 18:00:00 | AAPL | Stock | 2.1136 | 2.1136 | 2.1118 | 2.1118 | 121436.0 |
| 2006-06-09 07:30:00 | MSFT | Stock | 22.2 | 22.2 | 22.14 | 22.16 | 5400.0 |
| 2006-06-09 08:00:00 | MSFT | Stock | 22.16 | 22.2 | 22.16 | 22.18 | 34170.0 |
| 2006-06-09 08:30:00 | MSFT | Stock | 22.18 | 22.18 | 22.14 | 22.17 | 47006.0 |
| 2006-06-09 09:00:00 | MSFT | Stock | 22.16 | 22.18 | 22.14 | 22.15 | 73361.0 |
| 2006-06-09 09:30:00 | MSFT | Stock | 22.15 | 22.19 | 22.04 | 22.09 | 7629366.0 |
| 2006-06-09 10:00:00 | MSFT | Stock | 22.1 | 22.11 | 22.02 | 22.088 | 5162658.0 |
| 2006-06-09 10:30:00 | MSFT | Stock | 22.08 | 22.11 | 22.059 | 22.08 | 4131130.0 |
| 2006-06-09 11:00:00 | MSFT | Stock | 22.08 | 22.09 | 22.049 | 22.07 | 3911573.0 |
| 2006-06-09 11:30:00 | MSFT | Stock | 22.07 | 22.08 | 22.02 | 22.05 | 3842050.0 |
| 2006-06-09 12:00:00 | MSFT | Stock | 22.04 | 22.06 | 22.03 | 22.04 | 1245926.0 |
| 2006-06-09 12:30:00 | MSFT | Stock | 22.03 | 22.06 | 22.0 | 22.01 | 2637276.0 |
| 2006-06-09 13:00:00 | MSFT | Stock | 22.01 | 22.03 | 22.0 | 22.01 | 2303771.0 |
| 2006-06-09 13:30:00 | MSFT | Stock | 22.01 | 22.1 | 22.0 | 22.0 | 2129878.0 |
| 2006-06-09 14:00:00 | MSFT | Stock | 22.0 | 22.08 | 21.97 | 22.07 | 3849327.0 |
| 2006-06-09 14:30:00 | MSFT | Stock | 22.07 | 22.08 | 22.05 | 22.067 | 2002786.0 |
| 2006-06-09 15:00:00 | MSFT | Stock | 22.06 | 22.08 | 22.02 | 22.03 | 3135308.0 |
| 2006-06-09 15:30:00 | MSFT | Stock | 22.03 | 22.06 | 21.89 | 21.93 | 8127363.0 |
| 2006-06-09 16:00:00 | MSFT | Stock | 21.93 | 22.02 | 21.88 | 21.93 | 1222241.0 |
| 2006-06-09 16:30:00 | MSFT | Stock | 21.93 | 21.93 | 21.9 | 21.9 | 16305.0 |
| 2006-06-09 17:00:00 | MSFT | Stock | 21.92 | 21.94 | 21.92 | 21.92 | 2900.0 |
| 2006-06-09 17:30:00 | MSFT | Stock | 21.92 | 21.94 | 21.92 | 21.93 | 13951.0 |
| 2006-06-09 18:00:00 | MSFT | Stock | 21.93 | 21.93 | 21.906 | 21.92 | 1937.0 |
| 2006-06-09 08:00:00 | NVDA | Stock | 0.3632 | 0.364 | 0.3632 | 0.3633 | 126000.0 |
| 2006-06-09 08:30:00 | NVDA | Stock | 0.3632 | 0.3632 | 0.3617 | 0.3617 | 54000.0 |
| 2006-06-09 09:00:00 | NVDA | Stock | 0.363 | 0.3632 | 0.3605 | 0.3628 | 216000.0 |
| 2006-06-09 09:30:00 | NVDA | Stock | 0.3617 | 0.3678 | 0.3602 | 0.3635 | 59055660.0 |
| 2006-06-09 10:00:00 | NVDA | Stock | 0.3635 | 0.3645 | 0.3603 | 0.3637 | 42771540.0 |
> showing 50 of 48,365 rows — these rows as CSV