PREVIEW / stock_30min / 2009-09-11
file: by_date/stock_30min/2009/2009-09-11.parquet size: 1.3 MB rows: 73,080 symbols: 3,364
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-11 06:00:00 | AAPL | Stock | 6.1764 | 6.1764 | 6.1764 | 6.1764 | 2800.0 |
| 2009-09-11 06:30:00 | AAPL | Stock | 6.1764 | 6.1786 | 6.1764 | 6.1786 | 6720.0 |
| 2009-09-11 07:00:00 | AAPL | Stock | 6.1796 | 6.1796 | 6.1786 | 6.1786 | 41860.0 |
| 2009-09-11 07:30:00 | AAPL | Stock | 6.1782 | 6.1939 | 6.1782 | 6.1857 | 91000.0 |
| 2009-09-11 08:00:00 | AAPL | Stock | 6.1875 | 6.1964 | 6.1807 | 6.1871 | 590604.0 |
| 2009-09-11 08:30:00 | AAPL | Stock | 6.1843 | 6.1904 | 6.1643 | 6.1796 | 2250836.0 |
| 2009-09-11 09:00:00 | AAPL | Stock | 6.1804 | 6.1882 | 6.1725 | 6.1729 | 1490188.0 |
| 2009-09-11 09:30:00 | AAPL | Stock | 6.1754 | 6.185 | 6.1025 | 6.1271 | 73752728.0 |
| 2009-09-11 10:00:00 | AAPL | Stock | 6.1279 | 6.1643 | 6.1089 | 6.1536 | 47583648.0 |
| 2009-09-11 10:30:00 | AAPL | Stock | 6.1543 | 6.1743 | 6.145 | 6.1464 | 25695684.0 |
| 2009-09-11 11:00:00 | AAPL | Stock | 6.1468 | 6.1643 | 6.1429 | 6.144 | 18024832.0 |
| 2009-09-11 11:30:00 | AAPL | Stock | 6.145 | 6.1518 | 6.1439 | 6.1511 | 17130316.0 |
| 2009-09-11 12:00:00 | AAPL | Stock | 6.1507 | 6.155 | 6.125 | 6.1268 | 18133640.0 |
| 2009-09-11 12:30:00 | AAPL | Stock | 6.1264 | 6.1382 | 6.1107 | 6.1357 | 21867300.0 |
| 2009-09-11 13:00:00 | AAPL | Stock | 6.1357 | 6.1429 | 6.1268 | 6.1376 | 12996480.0 |
| 2009-09-11 13:30:00 | AAPL | Stock | 6.1379 | 6.1418 | 6.1225 | 6.1236 | 14278740.0 |
| 2009-09-11 14:00:00 | AAPL | Stock | 6.1243 | 6.1368 | 6.1218 | 6.1354 | 15404452.0 |
| 2009-09-11 14:30:00 | AAPL | Stock | 6.1361 | 6.1511 | 6.1339 | 6.1418 | 16368576.0 |
| 2009-09-11 15:00:00 | AAPL | Stock | 6.1411 | 6.1511 | 6.1361 | 6.1493 | 13300336.0 |
| 2009-09-11 15:30:00 | AAPL | Stock | 6.1496 | 6.155 | 6.14 | 6.1486 | 28287588.0 |
| 2009-09-11 16:00:00 | AAPL | Stock | 6.1486 | 6.15 | 6.1375 | 6.1446 | 4179448.0 |
| 2009-09-11 16:30:00 | AAPL | Stock | 6.1486 | 6.1496 | 6.1318 | 6.1496 | 334992.0 |
| 2009-09-11 17:00:00 | AAPL | Stock | 6.1393 | 6.1393 | 6.1393 | 6.1393 | 2800.0 |
| 2009-09-11 17:30:00 | AAPL | Stock | 6.1393 | 6.1393 | 6.1393 | 6.1393 | 2800.0 |
| 2009-09-11 18:00:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1393 | 6.1393 | 11928.0 |
| 2009-09-11 18:30:00 | AAPL | Stock | 6.1375 | 6.1482 | 6.1375 | 6.1375 | 45948.0 |
| 2009-09-11 19:00:00 | AAPL | Stock | 6.1446 | 6.1446 | 6.1393 | 6.1393 | 14000.0 |
| 2009-09-11 19:30:00 | AAPL | Stock | 6.1393 | 6.1443 | 6.1386 | 6.1443 | 118104.0 |
| 2009-09-11 07:30:00 | MSFT | Stock | 25.05 | 25.05 | 25.05 | 25.05 | 100.0 |
| 2009-09-11 08:00:00 | MSFT | Stock | 24.91 | 24.98 | 24.91 | 24.91 | 1000.0 |
| 2009-09-11 08:30:00 | MSFT | Stock | 24.87 | 25.0 | 24.87 | 25.0 | 159854.0 |
| 2009-09-11 09:00:00 | MSFT | Stock | 24.99 | 24.99 | 24.95 | 24.95 | 800.0 |
| 2009-09-11 09:30:00 | MSFT | Stock | 24.94 | 25.11 | 24.89 | 25.01 | 5587893.0 |
| 2009-09-11 10:00:00 | MSFT | Stock | 25.0 | 25.06 | 24.91 | 24.96 | 3274464.0 |
| 2009-09-11 10:30:00 | MSFT | Stock | 24.95 | 25.025 | 24.94 | 25.01 | 3002085.0 |
| 2009-09-11 11:00:00 | MSFT | Stock | 25.01 | 25.17 | 24.99 | 25.01 | 4721500.0 |
| 2009-09-11 11:30:00 | MSFT | Stock | 25.01 | 25.03 | 24.95 | 25.02 | 1768044.0 |
| 2009-09-11 12:00:00 | MSFT | Stock | 25.01 | 25.03 | 24.93 | 24.95 | 2057663.0 |
| 2009-09-11 12:30:00 | MSFT | Stock | 24.96 | 24.99 | 24.94 | 24.962 | 4081285.0 |
| 2009-09-11 13:00:00 | MSFT | Stock | 24.967 | 25.041 | 24.94 | 24.98 | 1725951.0 |
| 2009-09-11 13:30:00 | MSFT | Stock | 24.97 | 25.0 | 24.95 | 24.95 | 1415471.0 |
| 2009-09-11 14:00:00 | MSFT | Stock | 24.95 | 25.053 | 24.95 | 24.991 | 1244168.0 |
| 2009-09-11 14:30:00 | MSFT | Stock | 25.0 | 25.01 | 24.93 | 24.96 | 2857769.0 |
| 2009-09-11 15:00:00 | MSFT | Stock | 24.96 | 24.96 | 24.81 | 24.85 | 12511947.0 |
| 2009-09-11 15:30:00 | MSFT | Stock | 24.84 | 24.91 | 24.83 | 24.84 | 5830387.0 |
| 2009-09-11 16:00:00 | MSFT | Stock | 24.85 | 24.952 | 24.83 | 24.952 | 1368998.0 |
| 2009-09-11 16:30:00 | MSFT | Stock | 24.86 | 24.86 | 24.86 | 24.86 | 49551.0 |
| 2009-09-11 17:00:00 | MSFT | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 200.0 |
| 2009-09-11 17:30:00 | MSFT | Stock | 24.82 | 24.85 | 24.82 | 24.84 | 1100.0 |
| 2009-09-11 18:00:00 | MSFT | Stock | 24.83 | 24.83 | 24.83 | 24.83 | 100.0 |
> showing 50 of 73,080 rows — these rows as CSV