PREVIEW / stock_30min / 2006-06-15
file: by_date/stock_30min/2006/2006-06-15.parquet size: 921 KB rows: 49,911 symbols: 2,289
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-15 05:30:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 98000.0 |
| 2006-06-15 06:00:00 | AAPL | Stock | 2.0589 | 2.0589 | 2.0571 | 2.0571 | 27888.0 |
| 2006-06-15 06:30:00 | AAPL | Stock | 2.0571 | 2.0643 | 2.0571 | 2.0643 | 46200.0 |
| 2006-06-15 07:00:00 | AAPL | Stock | 2.0643 | 2.0643 | 2.0571 | 2.0571 | 47600.0 |
| 2006-06-15 07:30:00 | AAPL | Stock | 2.0636 | 2.0661 | 2.0518 | 2.0518 | 184800.0 |
| 2006-06-15 08:00:00 | AAPL | Stock | 2.0571 | 2.0768 | 2.0471 | 2.0732 | 3129812.0 |
| 2006-06-15 08:30:00 | AAPL | Stock | 2.0714 | 2.0732 | 2.0632 | 2.0646 | 1773772.0 |
| 2006-06-15 09:00:00 | AAPL | Stock | 2.0632 | 2.0661 | 2.0446 | 2.0471 | 5442192.0 |
| 2006-06-15 09:30:00 | AAPL | Stock | 2.0464 | 2.0529 | 2.0268 | 2.0361 | 158441080.0 |
| 2006-06-15 10:00:00 | AAPL | Stock | 2.0357 | 2.0821 | 2.035 | 2.0625 | 148223404.0 |
| 2006-06-15 10:30:00 | AAPL | Stock | 2.0625 | 2.0714 | 2.0532 | 2.0604 | 95797016.0 |
| 2006-06-15 11:00:00 | AAPL | Stock | 2.0604 | 2.0679 | 2.0586 | 2.0586 | 54619180.0 |
| 2006-06-15 11:30:00 | AAPL | Stock | 2.0582 | 2.0589 | 2.0504 | 2.0571 | 44139900.0 |
| 2006-06-15 12:00:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0471 | 2.0511 | 31950380.0 |
| 2006-06-15 12:30:00 | AAPL | Stock | 2.0507 | 2.0571 | 2.0446 | 2.0507 | 33340020.0 |
| 2006-06-15 13:00:00 | AAPL | Stock | 2.0507 | 2.0525 | 2.0446 | 2.0507 | 27928208.0 |
| 2006-06-15 13:30:00 | AAPL | Stock | 2.0507 | 2.0804 | 2.045 | 2.0779 | 80729992.0 |
| 2006-06-15 14:00:00 | AAPL | Stock | 2.0779 | 2.1096 | 2.0768 | 2.1057 | 138121816.0 |
| 2006-06-15 14:30:00 | AAPL | Stock | 2.1057 | 2.1243 | 2.1007 | 2.1229 | 121007824.0 |
| 2006-06-15 15:00:00 | AAPL | Stock | 2.1232 | 2.1336 | 2.12 | 2.1275 | 110300624.0 |
| 2006-06-15 15:30:00 | AAPL | Stock | 2.1275 | 2.1329 | 2.1132 | 2.1211 | 117310452.0 |
| 2006-06-15 16:00:00 | AAPL | Stock | 2.12 | 2.125 | 2.1171 | 2.1196 | 2011884.0 |
| 2006-06-15 16:30:00 | AAPL | Stock | 2.1211 | 2.1232 | 2.1179 | 2.1211 | 616644.0 |
| 2006-06-15 17:00:00 | AAPL | Stock | 2.1211 | 2.1221 | 2.1164 | 2.1164 | 97244.0 |
| 2006-06-15 17:30:00 | AAPL | Stock | 2.1189 | 2.1214 | 2.1146 | 2.1214 | 1636292.0 |
| 2006-06-15 18:00:00 | AAPL | Stock | 2.1211 | 2.1232 | 2.1211 | 2.1232 | 112084.0 |
| 2006-06-15 07:00:00 | MSFT | Stock | 22.01 | 22.1 | 22.01 | 22.1 | 4900.0 |
| 2006-06-15 07:30:00 | MSFT | Stock | 22.05 | 22.05 | 22.05 | 22.05 | 20041.0 |
| 2006-06-15 08:00:00 | MSFT | Stock | 22.05 | 22.09 | 22.05 | 22.06 | 195809.0 |
| 2006-06-15 08:30:00 | MSFT | Stock | 22.06 | 22.07 | 21.88 | 22.01 | 10078461.0 |
| 2006-06-15 09:00:00 | MSFT | Stock | 22.02 | 22.05 | 21.88 | 22.0 | 296975.0 |
| 2006-06-15 09:30:00 | MSFT | Stock | 22.01 | 22.05 | 21.85 | 21.929 | 9920477.0 |
| 2006-06-15 10:00:00 | MSFT | Stock | 21.92 | 22.04 | 21.91 | 22.02 | 9578371.0 |
| 2006-06-15 10:30:00 | MSFT | Stock | 22.03 | 22.05 | 21.91 | 22.04 | 8007899.0 |
| 2006-06-15 11:00:00 | MSFT | Stock | 22.04 | 22.13 | 22.02 | 22.03 | 9592346.0 |
| 2006-06-15 11:30:00 | MSFT | Stock | 22.04 | 22.1 | 21.96 | 21.98 | 3933741.0 |
| 2006-06-15 12:00:00 | MSFT | Stock | 21.98 | 22.05 | 21.87 | 21.89 | 3855272.0 |
| 2006-06-15 12:30:00 | MSFT | Stock | 21.89 | 21.91 | 21.85 | 21.88 | 4581420.0 |
| 2006-06-15 13:00:00 | MSFT | Stock | 21.88 | 21.89 | 21.85 | 21.85 | 2971430.0 |
| 2006-06-15 13:30:00 | MSFT | Stock | 21.84 | 21.89 | 21.8 | 21.86 | 3878350.0 |
| 2006-06-15 14:00:00 | MSFT | Stock | 21.86 | 21.91 | 21.8 | 21.86 | 4932578.0 |
| 2006-06-15 14:30:00 | MSFT | Stock | 21.86 | 21.99 | 21.85 | 21.96 | 7460915.0 |
| 2006-06-15 15:00:00 | MSFT | Stock | 21.95 | 21.97 | 21.86 | 21.96 | 7531525.0 |
| 2006-06-15 15:30:00 | MSFT | Stock | 21.96 | 22.09 | 21.95 | 22.09 | 16217883.0 |
| 2006-06-15 16:00:00 | MSFT | Stock | 22.04 | 22.7 | 22.02 | 22.53 | 6255448.0 |
| 2006-06-15 16:30:00 | MSFT | Stock | 22.56 | 22.67 | 21.5 | 21.98 | 7664812.0 |
| 2006-06-15 17:00:00 | MSFT | Stock | 21.97 | 22.0 | 21.94 | 21.96 | 872461.0 |
| 2006-06-15 17:30:00 | MSFT | Stock | 21.96 | 22.07 | 21.93 | 21.96 | 415184.0 |
| 2006-06-15 18:00:00 | MSFT | Stock | 21.96 | 22.05 | 21.96 | 21.98 | 76855.0 |
| 2006-06-15 04:00:00 | NVDA | Stock | 0.3472 | 0.3472 | 0.3472 | 0.3472 | 54000.0 |
> showing 50 of 49,911 rows — these rows as CSV