PREVIEW / stock_30min / 2009-01-22
file: by_date/stock_30min/2009/2009-01-22.parquet size: 1.2 MB rows: 66,810 symbols: 3,281
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-01-22 04:30:00 | AAPL | Stock | 3.2136 | 3.2136 | 3.2136 | 3.2136 | 4200.0 |
| 2009-01-22 05:00:00 | AAPL | Stock | 3.2129 | 3.2129 | 3.2129 | 3.2129 | 6888.0 |
| 2009-01-22 05:30:00 | AAPL | Stock | 3.2354 | 3.2354 | 3.2354 | 3.2354 | 2800.0 |
| 2009-01-22 06:00:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.2125 | 3.2125 | 8400.0 |
| 2009-01-22 06:30:00 | AAPL | Stock | 3.2193 | 3.2193 | 3.1804 | 3.1804 | 7420.0 |
| 2009-01-22 07:00:00 | AAPL | Stock | 3.1789 | 3.2286 | 3.1786 | 3.2054 | 1376200.0 |
| 2009-01-22 07:30:00 | AAPL | Stock | 3.2004 | 3.2107 | 3.1857 | 3.1964 | 1220296.0 |
| 2009-01-22 08:00:00 | AAPL | Stock | 3.1964 | 3.2361 | 3.1786 | 3.2254 | 10968132.0 |
| 2009-01-22 08:30:00 | AAPL | Stock | 3.225 | 3.2275 | 3.1736 | 3.1821 | 15811488.0 |
| 2009-01-22 09:00:00 | AAPL | Stock | 3.1821 | 3.1907 | 3.1357 | 3.1471 | 29452360.0 |
| 2009-01-22 09:30:00 | AAPL | Stock | 3.1468 | 3.1907 | 3.065 | 3.1821 | 343004508.0 |
| 2009-01-22 10:00:00 | AAPL | Stock | 3.1818 | 3.2089 | 3.1489 | 3.1686 | 152838924.0 |
| 2009-01-22 10:30:00 | AAPL | Stock | 3.1689 | 3.1689 | 3.1225 | 3.1482 | 100166780.0 |
| 2009-01-22 11:00:00 | AAPL | Stock | 3.1479 | 3.1582 | 3.1325 | 3.1468 | 58130072.0 |
| 2009-01-22 11:30:00 | AAPL | Stock | 3.1468 | 3.1564 | 3.1239 | 3.1264 | 57499680.0 |
| 2009-01-22 12:00:00 | AAPL | Stock | 3.1261 | 3.1568 | 3.125 | 3.1557 | 43759828.0 |
| 2009-01-22 12:30:00 | AAPL | Stock | 3.1564 | 3.1925 | 3.1496 | 3.1911 | 48966064.0 |
| 2009-01-22 13:00:00 | AAPL | Stock | 3.1911 | 3.2021 | 3.1782 | 3.1868 | 59231480.0 |
| 2009-01-22 13:30:00 | AAPL | Stock | 3.1864 | 3.2 | 3.1664 | 3.1936 | 57527372.0 |
| 2009-01-22 14:00:00 | AAPL | Stock | 3.1939 | 3.2143 | 3.1846 | 3.2046 | 90746404.0 |
| 2009-01-22 14:30:00 | AAPL | Stock | 3.2046 | 3.2114 | 3.1618 | 3.1732 | 82214832.0 |
| 2009-01-22 15:00:00 | AAPL | Stock | 3.1732 | 3.1854 | 3.1614 | 3.1764 | 71653064.0 |
| 2009-01-22 15:30:00 | AAPL | Stock | 3.1768 | 3.1964 | 3.1557 | 3.1607 | 113309868.0 |
| 2009-01-22 16:00:00 | AAPL | Stock | 3.1629 | 3.1911 | 3.1537 | 3.1571 | 23573872.0 |
| 2009-01-22 16:30:00 | AAPL | Stock | 3.1579 | 3.1768 | 3.1546 | 3.1625 | 272720.0 |
| 2009-01-22 17:00:00 | AAPL | Stock | 3.1621 | 3.1629 | 3.1557 | 3.1589 | 225372.0 |
| 2009-01-22 17:30:00 | AAPL | Stock | 3.1611 | 3.1611 | 3.1554 | 3.1582 | 100576.0 |
| 2009-01-22 18:00:00 | AAPL | Stock | 3.1557 | 3.1586 | 3.1554 | 3.1586 | 21499940.0 |
| 2009-01-22 18:30:00 | AAPL | Stock | 3.1554 | 3.1586 | 3.1536 | 3.1539 | 56588.0 |
| 2009-01-22 19:00:00 | AAPL | Stock | 3.1539 | 3.1607 | 3.1432 | 3.1518 | 124236.0 |
| 2009-01-22 19:30:00 | AAPL | Stock | 3.1464 | 3.1504 | 3.1429 | 3.1504 | 208768.0 |
| 2009-01-22 20:00:00 | AAPL | Stock | 3.1407 | 3.1407 | 3.1407 | 3.1407 | 72800.0 |
| 2009-01-22 07:00:00 | MSFT | Stock | 19.18 | 19.19 | 19.18 | 19.19 | 1270.0 |
| 2009-01-22 07:30:00 | MSFT | Stock | 19.38 | 19.38 | 19.38 | 19.38 | 100.0 |
| 2009-01-22 08:00:00 | MSFT | Stock | 19.36 | 19.4 | 19.2 | 19.26 | 9863.0 |
| 2009-01-22 08:30:00 | MSFT | Stock | 19.26 | 19.26 | 19.18 | 19.19 | 17305.0 |
| 2009-01-22 09:00:00 | MSFT | Stock | 19.19 | 19.2 | 17.61 | 18.04 | 5681682.0 |
| 2009-01-22 09:30:00 | MSFT | Stock | 18.05 | 18.18 | 17.75 | 17.75 | 28870192.0 |
| 2009-01-22 10:00:00 | MSFT | Stock | 17.76 | 18.0 | 17.71 | 17.86 | 19145748.0 |
| 2009-01-22 10:30:00 | MSFT | Stock | 17.857 | 17.86 | 17.63 | 17.66 | 19362813.0 |
| 2009-01-22 11:00:00 | MSFT | Stock | 17.66 | 17.92 | 17.6 | 17.73 | 14968148.0 |
| 2009-01-22 11:30:00 | MSFT | Stock | 17.73 | 17.75 | 17.39 | 17.39 | 14268219.0 |
| 2009-01-22 12:00:00 | MSFT | Stock | 17.4 | 17.49 | 17.19 | 17.35 | 16074361.0 |
| 2009-01-22 12:30:00 | MSFT | Stock | 17.35 | 17.5 | 17.27 | 17.48 | 12016856.0 |
| 2009-01-22 13:00:00 | MSFT | Stock | 17.47 | 17.57 | 17.42 | 17.45 | 11234224.0 |
| 2009-01-22 13:30:00 | MSFT | Stock | 17.46 | 17.48 | 17.32 | 17.42 | 12504619.0 |
| 2009-01-22 14:00:00 | MSFT | Stock | 17.41 | 17.66 | 17.4 | 17.57 | 14038183.0 |
| 2009-01-22 14:30:00 | MSFT | Stock | 17.56 | 17.61 | 17.43 | 17.45 | 8171170.0 |
| 2009-01-22 15:00:00 | MSFT | Stock | 17.46 | 17.49 | 17.17 | 17.308 | 12817945.0 |
| 2009-01-22 15:30:00 | MSFT | Stock | 17.3 | 17.36 | 17.07 | 17.11 | 25207681.0 |
> showing 50 of 66,810 rows — these rows as CSV