PREVIEW / stock_30min / 2006-12-15
file: by_date/stock_30min/2006/2006-12-15.parquet size: 1.0 MB rows: 56,176 symbols: 2,478
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-12-15 06:00:00 | AAPL | Stock | 3.1686 | 3.1686 | 3.1607 | 3.1607 | 16800.0 |
| 2006-12-15 07:00:00 | AAPL | Stock | 3.1743 | 3.1789 | 3.1718 | 3.1718 | 38080.0 |
| 2006-12-15 07:30:00 | AAPL | Stock | 3.1718 | 3.1732 | 3.1639 | 3.1661 | 56000.0 |
| 2006-12-15 08:00:00 | AAPL | Stock | 3.1679 | 3.1714 | 3.1611 | 3.1696 | 1483216.0 |
| 2006-12-15 08:30:00 | AAPL | Stock | 3.1696 | 3.1889 | 3.1696 | 3.1857 | 3721172.0 |
| 2006-12-15 09:00:00 | AAPL | Stock | 3.1857 | 3.1882 | 3.1714 | 3.1771 | 5702228.0 |
| 2006-12-15 09:30:00 | AAPL | Stock | 3.1768 | 3.1864 | 3.1382 | 3.1564 | 236424440.0 |
| 2006-12-15 10:00:00 | AAPL | Stock | 3.1564 | 3.1829 | 3.1504 | 3.16 | 47980632.0 |
| 2006-12-15 10:30:00 | AAPL | Stock | 3.1597 | 3.1821 | 3.1571 | 3.1664 | 43024436.0 |
| 2006-12-15 11:00:00 | AAPL | Stock | 3.1668 | 3.1821 | 3.1575 | 3.1614 | 28112504.0 |
| 2006-12-15 11:30:00 | AAPL | Stock | 3.1607 | 3.1796 | 3.1561 | 3.1589 | 25918956.0 |
| 2006-12-15 12:00:00 | AAPL | Stock | 3.1586 | 3.1743 | 3.1339 | 3.1396 | 44674504.0 |
| 2006-12-15 12:30:00 | AAPL | Stock | 3.1396 | 3.1804 | 3.1304 | 3.1329 | 36915256.0 |
| 2006-12-15 13:00:00 | AAPL | Stock | 3.1329 | 3.1811 | 3.13 | 3.1339 | 28567672.0 |
| 2006-12-15 13:30:00 | AAPL | Stock | 3.1339 | 3.1793 | 3.1271 | 3.1389 | 29227744.0 |
| 2006-12-15 14:00:00 | AAPL | Stock | 3.1386 | 3.1814 | 3.1339 | 3.1407 | 21519008.0 |
| 2006-12-15 14:30:00 | AAPL | Stock | 3.1404 | 3.18 | 3.1339 | 3.1421 | 25085452.0 |
| 2006-12-15 15:00:00 | AAPL | Stock | 3.1418 | 3.1425 | 3.1325 | 3.1336 | 27730752.0 |
| 2006-12-15 15:30:00 | AAPL | Stock | 3.1336 | 3.145 | 3.1189 | 3.1339 | 83654872.0 |
| 2006-12-15 16:00:00 | AAPL | Stock | 3.1279 | 3.147 | 3.1264 | 3.1336 | 5675376.0 |
| 2006-12-15 16:30:00 | AAPL | Stock | 3.1336 | 3.1361 | 3.1327 | 3.1343 | 2906988.0 |
| 2006-12-15 17:00:00 | AAPL | Stock | 3.1327 | 3.1343 | 3.1327 | 3.1339 | 141120.0 |
| 2006-12-15 17:30:00 | AAPL | Stock | 3.1329 | 3.1339 | 3.1321 | 3.1339 | 272832.0 |
| 2006-12-15 18:00:00 | AAPL | Stock | 3.1339 | 3.1357 | 3.1321 | 3.1346 | 101248.0 |
| 2006-12-15 18:30:00 | AAPL | Stock | 3.1346 | 3.1346 | 3.1326 | 3.1339 | 76804.0 |
| 2006-12-15 19:00:00 | AAPL | Stock | 3.1332 | 3.135 | 3.1325 | 3.135 | 66640.0 |
| 2006-12-15 19:30:00 | AAPL | Stock | 3.1357 | 3.1357 | 3.1325 | 3.1325 | 56980.0 |
| 2006-12-15 07:00:00 | MSFT | Stock | 30.07 | 30.07 | 30.07 | 30.07 | 2000.0 |
| 2006-12-15 07:30:00 | MSFT | Stock | 30.07 | 30.08 | 30.07 | 30.07 | 1300.0 |
| 2006-12-15 08:00:00 | MSFT | Stock | 30.06 | 30.1 | 30.05 | 30.1 | 17270.0 |
| 2006-12-15 08:30:00 | MSFT | Stock | 30.12 | 30.21 | 30.03 | 30.14 | 75971.0 |
| 2006-12-15 09:00:00 | MSFT | Stock | 30.18 | 30.24 | 30.07 | 30.14 | 592587.0 |
| 2006-12-15 09:30:00 | MSFT | Stock | 30.14 | 30.23 | 30.08 | 30.15 | 24935006.0 |
| 2006-12-15 10:00:00 | MSFT | Stock | 30.14 | 30.23 | 30.08 | 30.1 | 4841614.0 |
| 2006-12-15 10:30:00 | MSFT | Stock | 30.1 | 30.2 | 30.07 | 30.11 | 4883409.0 |
| 2006-12-15 11:00:00 | MSFT | Stock | 30.11 | 30.22 | 30.08 | 30.1 | 2792654.0 |
| 2006-12-15 11:30:00 | MSFT | Stock | 30.09 | 30.16 | 30.08 | 30.13 | 3779069.0 |
| 2006-12-15 12:00:00 | MSFT | Stock | 30.13 | 30.15 | 30.07 | 30.08 | 3515192.0 |
| 2006-12-15 12:30:00 | MSFT | Stock | 30.08 | 30.15 | 30.08 | 30.09 | 2973291.0 |
| 2006-12-15 13:00:00 | MSFT | Stock | 30.091 | 30.15 | 30.07 | 30.09 | 3668811.0 |
| 2006-12-15 13:30:00 | MSFT | Stock | 30.09 | 30.16 | 30.03 | 30.09 | 3471083.0 |
| 2006-12-15 14:00:00 | MSFT | Stock | 30.1 | 30.2 | 30.09 | 30.12 | 2586195.0 |
| 2006-12-15 14:30:00 | MSFT | Stock | 30.13 | 30.2 | 30.1 | 30.14 | 4157869.0 |
| 2006-12-15 15:00:00 | MSFT | Stock | 30.13 | 30.14 | 30.09 | 30.1 | 3596454.0 |
| 2006-12-15 15:30:00 | MSFT | Stock | 30.1 | 30.2 | 30.05 | 30.19 | 11841306.0 |
| 2006-12-15 16:00:00 | MSFT | Stock | 30.18 | 30.2 | 30.05 | 30.15 | 4865832.0 |
| 2006-12-15 16:30:00 | MSFT | Stock | 30.19 | 30.195 | 30.18 | 30.185 | 4700259.0 |
| 2006-12-15 17:00:00 | MSFT | Stock | 30.185 | 30.19 | 30.18 | 30.19 | 173707.0 |
| 2006-12-15 17:30:00 | MSFT | Stock | 30.19 | 30.19 | 30.187 | 30.187 | 69072.0 |
| 2006-12-15 18:00:00 | MSFT | Stock | 30.18 | 30.18 | 30.18 | 30.18 | 85200.0 |
> showing 50 of 56,176 rows — these rows as CSV