PREVIEW / stock_30min / 2006-05-31
file: by_date/stock_30min/2006/2006-05-31.parquet size: 938 KB rows: 50,466 symbols: 2,279
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-05-31 05:00:00 | AAPL | Stock | 2.1804 | 2.1804 | 2.1804 | 2.1804 | 28000.0 |
| 2006-05-31 07:00:00 | AAPL | Stock | 2.1839 | 2.1854 | 2.1839 | 2.1854 | 5600.0 |
| 2006-05-31 07:30:00 | AAPL | Stock | 2.1893 | 2.1929 | 2.1893 | 2.1929 | 75600.0 |
| 2006-05-31 08:00:00 | AAPL | Stock | 2.1929 | 2.2014 | 2.1893 | 2.1982 | 859768.0 |
| 2006-05-31 08:30:00 | AAPL | Stock | 2.1982 | 2.2061 | 2.1968 | 2.205 | 1073604.0 |
| 2006-05-31 09:00:00 | AAPL | Stock | 2.2043 | 2.2107 | 2.1968 | 2.2004 | 2537864.0 |
| 2006-05-31 09:30:00 | AAPL | Stock | 2.2055 | 2.2068 | 2.1596 | 2.1821 | 129126564.0 |
| 2006-05-31 10:00:00 | AAPL | Stock | 2.1819 | 2.1861 | 2.1554 | 2.1657 | 83612872.0 |
| 2006-05-31 10:30:00 | AAPL | Stock | 2.1654 | 2.1736 | 2.1625 | 2.165 | 63067816.0 |
| 2006-05-31 11:00:00 | AAPL | Stock | 2.1643 | 2.17 | 2.1582 | 2.1696 | 47938324.0 |
| 2006-05-31 11:30:00 | AAPL | Stock | 2.1696 | 2.1714 | 2.1646 | 2.1661 | 28434000.0 |
| 2006-05-31 12:00:00 | AAPL | Stock | 2.1661 | 2.1679 | 2.1543 | 2.1561 | 48373976.0 |
| 2006-05-31 12:30:00 | AAPL | Stock | 2.1561 | 2.1568 | 2.145 | 2.1493 | 67912656.0 |
| 2006-05-31 13:00:00 | AAPL | Stock | 2.1493 | 2.1496 | 2.1343 | 2.1407 | 86211860.0 |
| 2006-05-31 13:30:00 | AAPL | Stock | 2.1411 | 2.1482 | 2.1286 | 2.1411 | 91152236.0 |
| 2006-05-31 14:00:00 | AAPL | Stock | 2.1411 | 2.1414 | 2.1093 | 2.1132 | 180950476.0 |
| 2006-05-31 14:30:00 | AAPL | Stock | 2.1129 | 2.1246 | 2.1104 | 2.1146 | 105357392.0 |
| 2006-05-31 15:00:00 | AAPL | Stock | 2.115 | 2.1179 | 2.0971 | 2.1032 | 126180852.0 |
| 2006-05-31 15:30:00 | AAPL | Stock | 2.1032 | 2.1714 | 2.0961 | 2.1271 | 174992524.0 |
| 2006-05-31 16:00:00 | AAPL | Stock | 2.1268 | 2.1857 | 2.1264 | 2.1346 | 3399200.0 |
| 2006-05-31 16:30:00 | AAPL | Stock | 2.1364 | 2.1375 | 2.1332 | 2.1357 | 421372.0 |
| 2006-05-31 17:00:00 | AAPL | Stock | 2.1346 | 2.1368 | 2.1346 | 2.1368 | 6857760.0 |
| 2006-05-31 17:30:00 | AAPL | Stock | 2.1368 | 2.1386 | 2.1089 | 2.1386 | 487088.0 |
| 2006-05-31 18:00:00 | AAPL | Stock | 2.1368 | 2.1386 | 2.1368 | 2.1368 | 239680.0 |
| 2006-05-31 05:30:00 | MSFT | Stock | 23.25 | 23.25 | 23.24 | 23.25 | 3000.0 |
| 2006-05-31 07:00:00 | MSFT | Stock | 23.26 | 23.26 | 23.26 | 23.26 | 900.0 |
| 2006-05-31 07:30:00 | MSFT | Stock | 23.26 | 23.26 | 23.26 | 23.26 | 615.0 |
| 2006-05-31 08:00:00 | MSFT | Stock | 23.27 | 23.29 | 23.25 | 23.25 | 17005.0 |
| 2006-05-31 08:30:00 | MSFT | Stock | 23.25 | 23.26 | 23.2 | 23.25 | 62627.0 |
| 2006-05-31 09:00:00 | MSFT | Stock | 23.24 | 23.32 | 23.21 | 23.26 | 251071.0 |
| 2006-05-31 09:30:00 | MSFT | Stock | 23.26 | 23.35 | 23.21 | 23.269 | 9752400.0 |
| 2006-05-31 10:00:00 | MSFT | Stock | 23.27 | 23.28 | 23.07 | 23.16 | 6617317.0 |
| 2006-05-31 10:30:00 | MSFT | Stock | 23.16 | 23.24 | 23.1 | 23.13 | 4941788.0 |
| 2006-05-31 11:00:00 | MSFT | Stock | 23.13 | 23.2 | 23.11 | 23.16 | 4694410.0 |
| 2006-05-31 11:30:00 | MSFT | Stock | 23.16 | 23.19 | 23.13 | 23.15 | 4055354.0 |
| 2006-05-31 12:00:00 | MSFT | Stock | 23.159 | 23.3 | 23.11 | 23.17 | 2461991.0 |
| 2006-05-31 12:30:00 | MSFT | Stock | 23.17 | 23.18 | 23.13 | 23.14 | 1915831.0 |
| 2006-05-31 13:00:00 | MSFT | Stock | 23.14 | 23.14 | 23.04 | 23.05 | 3315391.0 |
| 2006-05-31 13:30:00 | MSFT | Stock | 23.04 | 23.13 | 23.01 | 23.04 | 4901332.0 |
| 2006-05-31 14:00:00 | MSFT | Stock | 23.04 | 23.09 | 22.86 | 22.91 | 10389516.0 |
| 2006-05-31 14:30:00 | MSFT | Stock | 22.9 | 23.13 | 22.8 | 22.84 | 9752449.0 |
| 2006-05-31 15:00:00 | MSFT | Stock | 22.84 | 22.88 | 22.79 | 22.8 | 10390525.0 |
| 2006-05-31 15:30:00 | MSFT | Stock | 22.79 | 22.84 | 22.69 | 22.7 | 21131079.0 |
| 2006-05-31 16:00:00 | MSFT | Stock | 22.7 | 22.75 | 22.65 | 22.73 | 2069190.0 |
| 2006-05-31 16:30:00 | MSFT | Stock | 22.73 | 22.75 | 22.65 | 22.75 | 699927.0 |
| 2006-05-31 17:00:00 | MSFT | Stock | 22.75 | 22.75 | 22.73 | 22.74 | 9225.0 |
| 2006-05-31 17:30:00 | MSFT | Stock | 22.73 | 22.74 | 22.65 | 22.7 | 583181.0 |
| 2006-05-31 18:00:00 | MSFT | Stock | 22.7 | 22.73 | 22.69 | 22.73 | 40720.0 |
| 2006-05-31 08:00:00 | NVDA | Stock | 0.3833 | 0.388 | 0.3833 | 0.388 | 24000.0 |
| 2006-05-31 08:30:00 | NVDA | Stock | 0.3875 | 0.3875 | 0.3873 | 0.3875 | 129000.0 |
> showing 50 of 50,466 rows — these rows as CSV