PREVIEW / stock_30min / 2006-03-28
file: by_date/stock_30min/2006/2006-03-28.parquet size: 896 KB rows: 48,147 symbols: 2,222
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-28 06:30:00 | AAPL | Stock | 2.125 | 2.1357 | 2.1021 | 2.1357 | 104720.0 |
| 2006-03-28 07:00:00 | AAPL | Stock | 2.1411 | 2.1411 | 2.1296 | 2.1296 | 16800.0 |
| 2006-03-28 07:30:00 | AAPL | Stock | 2.1268 | 2.1332 | 2.1268 | 2.1332 | 70000.0 |
| 2006-03-28 08:00:00 | AAPL | Stock | 2.1332 | 2.1386 | 2.1304 | 2.1329 | 1004248.0 |
| 2006-03-28 08:30:00 | AAPL | Stock | 2.1329 | 2.1357 | 2.1321 | 2.1354 | 1213240.0 |
| 2006-03-28 09:00:00 | AAPL | Stock | 2.1357 | 2.1357 | 2.1293 | 2.1304 | 1787352.0 |
| 2006-03-28 09:30:00 | AAPL | Stock | 2.1296 | 2.1479 | 2.1221 | 2.1325 | 158847612.0 |
| 2006-03-28 10:00:00 | AAPL | Stock | 2.1321 | 2.1375 | 2.1232 | 2.125 | 128647568.0 |
| 2006-03-28 10:30:00 | AAPL | Stock | 2.1246 | 2.1339 | 2.1114 | 2.1282 | 163270492.0 |
| 2006-03-28 11:00:00 | AAPL | Stock | 2.1279 | 2.1282 | 2.115 | 2.1229 | 80563308.0 |
| 2006-03-28 11:30:00 | AAPL | Stock | 2.1229 | 2.1314 | 2.1221 | 2.1275 | 68246304.0 |
| 2006-03-28 12:00:00 | AAPL | Stock | 2.1279 | 2.1386 | 2.1271 | 2.1318 | 59016524.0 |
| 2006-03-28 12:30:00 | AAPL | Stock | 2.1321 | 2.1371 | 2.1164 | 2.1211 | 66654308.0 |
| 2006-03-28 13:00:00 | AAPL | Stock | 2.1211 | 2.1271 | 2.1161 | 2.1232 | 38157056.0 |
| 2006-03-28 13:30:00 | AAPL | Stock | 2.1232 | 2.1236 | 2.1089 | 2.1143 | 74587632.0 |
| 2006-03-28 14:00:00 | AAPL | Stock | 2.1143 | 2.1211 | 2.0989 | 2.1082 | 117175016.0 |
| 2006-03-28 14:30:00 | AAPL | Stock | 2.1086 | 2.1118 | 2.0914 | 2.0971 | 121335872.0 |
| 2006-03-28 15:00:00 | AAPL | Stock | 2.0971 | 2.1161 | 2.0804 | 2.0993 | 163170084.0 |
| 2006-03-28 15:30:00 | AAPL | Stock | 2.0993 | 2.1057 | 2.0893 | 2.095 | 110134808.0 |
| 2006-03-28 16:00:00 | AAPL | Stock | 2.0964 | 2.1 | 2.0954 | 2.0975 | 3057040.0 |
| 2006-03-28 16:30:00 | AAPL | Stock | 2.0965 | 2.0982 | 2.0964 | 2.0968 | 846440.0 |
| 2006-03-28 17:00:00 | AAPL | Stock | 2.0968 | 2.0982 | 2.0968 | 2.0979 | 154056.0 |
| 2006-03-28 17:30:00 | AAPL | Stock | 2.0971 | 2.1 | 2.0971 | 2.0989 | 307048.0 |
| 2006-03-28 18:00:00 | AAPL | Stock | 2.0986 | 2.0986 | 2.0971 | 2.0982 | 136444.0 |
| 2006-03-28 07:00:00 | MSFT | Stock | 27.01 | 27.01 | 27.01 | 27.01 | 1000.0 |
| 2006-03-28 08:00:00 | MSFT | Stock | 27.02 | 27.02 | 27.0 | 27.0 | 14795.0 |
| 2006-03-28 08:30:00 | MSFT | Stock | 27.0 | 27.02 | 27.0 | 27.01 | 21675.0 |
| 2006-03-28 09:00:00 | MSFT | Stock | 27.02 | 27.02 | 27.0 | 27.02 | 88548.0 |
| 2006-03-28 09:30:00 | MSFT | Stock | 27.01 | 27.12 | 26.96 | 27.02 | 4718722.0 |
| 2006-03-28 10:00:00 | MSFT | Stock | 27.02 | 27.06 | 26.96 | 27.05 | 3502856.0 |
| 2006-03-28 10:30:00 | MSFT | Stock | 27.05 | 27.05 | 27.0 | 27.03 | 1884988.0 |
| 2006-03-28 11:00:00 | MSFT | Stock | 27.03 | 27.04 | 26.95 | 27.03 | 2846496.0 |
| 2006-03-28 11:30:00 | MSFT | Stock | 27.03 | 27.06 | 27.0 | 27.06 | 2948259.0 |
| 2006-03-28 12:00:00 | MSFT | Stock | 27.06 | 27.15 | 27.03 | 27.1 | 3349489.0 |
| 2006-03-28 12:30:00 | MSFT | Stock | 27.1 | 27.21 | 27.1 | 27.16 | 3397122.0 |
| 2006-03-28 13:00:00 | MSFT | Stock | 27.16 | 27.19 | 27.14 | 27.17 | 1600225.0 |
| 2006-03-28 13:30:00 | MSFT | Stock | 27.18 | 27.19 | 27.15 | 27.17 | 1625261.0 |
| 2006-03-28 14:00:00 | MSFT | Stock | 27.16 | 27.2 | 27.0 | 27.02 | 5144612.0 |
| 2006-03-28 14:30:00 | MSFT | Stock | 27.02 | 27.03 | 26.93 | 26.961 | 4714903.0 |
| 2006-03-28 15:00:00 | MSFT | Stock | 26.961 | 26.97 | 26.81 | 26.94 | 7846712.0 |
| 2006-03-28 15:30:00 | MSFT | Stock | 26.94 | 26.97 | 26.82 | 26.93 | 13284343.0 |
| 2006-03-28 16:00:00 | MSFT | Stock | 26.92 | 26.94 | 26.87 | 26.9 | 65087.0 |
| 2006-03-28 16:30:00 | MSFT | Stock | 26.9 | 26.91 | 26.9 | 26.91 | 1900.0 |
| 2006-03-28 17:00:00 | MSFT | Stock | 26.91 | 26.91 | 26.91 | 26.91 | 1000.0 |
| 2006-03-28 17:30:00 | MSFT | Stock | 26.91 | 26.92 | 26.88 | 26.92 | 1478.0 |
| 2006-03-28 08:30:00 | NVDA | Stock | 0.4418 | 0.4434 | 0.4354 | 0.4434 | 432000.0 |
| 2006-03-28 09:00:00 | NVDA | Stock | 0.4433 | 0.4438 | 0.4423 | 0.4425 | 2291880.0 |
| 2006-03-28 09:30:00 | NVDA | Stock | 0.4426 | 0.4454 | 0.4417 | 0.4449 | 70436160.0 |
| 2006-03-28 10:00:00 | NVDA | Stock | 0.445 | 0.452 | 0.4444 | 0.4515 | 101503440.0 |
| 2006-03-28 10:30:00 | NVDA | Stock | 0.4515 | 0.4527 | 0.4488 | 0.4519 | 60936480.0 |
> showing 50 of 48,147 rows — these rows as CSV