PREVIEW / stock_1hour / 2009-01-22
file: by_date/stock_1hour/2009/2009-01-22.parquet size: 784 KB rows: 38,866 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:00:00 | AAPL | Stock | 3.2136 | 3.2136 | 3.2136 | 3.2136 | 4200.0 |
| 2009-01-22 05:00:00 | AAPL | Stock | 3.2129 | 3.2354 | 3.2129 | 3.2354 | 9688.0 |
| 2009-01-22 06:00:00 | AAPL | Stock | 3.2125 | 3.2193 | 3.1804 | 3.1804 | 15820.0 |
| 2009-01-22 07:00:00 | AAPL | Stock | 3.1789 | 3.2286 | 3.1786 | 3.1964 | 2596496.0 |
| 2009-01-22 08:00:00 | AAPL | Stock | 3.1964 | 3.2361 | 3.1736 | 3.1821 | 26779620.0 |
| 2009-01-22 09:00:00 | AAPL | Stock | 3.1821 | 3.1907 | 3.065 | 3.1821 | 372456868.0 |
| 2009-01-22 10:00:00 | AAPL | Stock | 3.1818 | 3.2089 | 3.1225 | 3.1482 | 253005704.0 |
| 2009-01-22 11:00:00 | AAPL | Stock | 3.1479 | 3.1582 | 3.1239 | 3.1264 | 115629752.0 |
| 2009-01-22 12:00:00 | AAPL | Stock | 3.1261 | 3.1925 | 3.125 | 3.1911 | 92725892.0 |
| 2009-01-22 13:00:00 | AAPL | Stock | 3.1911 | 3.2021 | 3.1664 | 3.1936 | 116758852.0 |
| 2009-01-22 14:00:00 | AAPL | Stock | 3.1939 | 3.2143 | 3.1618 | 3.1732 | 172961236.0 |
| 2009-01-22 15:00:00 | AAPL | Stock | 3.1732 | 3.1964 | 3.1557 | 3.1607 | 184962932.0 |
| 2009-01-22 16:00:00 | AAPL | Stock | 3.1629 | 3.1911 | 3.1537 | 3.1625 | 23846592.0 |
| 2009-01-22 17:00:00 | AAPL | Stock | 3.1621 | 3.1629 | 3.1554 | 3.1582 | 325948.0 |
| 2009-01-22 18:00:00 | AAPL | Stock | 3.1557 | 3.1586 | 3.1536 | 3.1539 | 21556528.0 |
| 2009-01-22 19:00:00 | AAPL | Stock | 3.1539 | 3.1607 | 3.1429 | 3.1504 | 333004.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.38 | 19.18 | 19.38 | 1370.0 |
| 2009-01-22 08:00:00 | MSFT | Stock | 19.36 | 19.4 | 19.18 | 19.19 | 27168.0 |
| 2009-01-22 09:00:00 | MSFT | Stock | 19.19 | 19.2 | 17.61 | 17.75 | 34551874.0 |
| 2009-01-22 10:00:00 | MSFT | Stock | 17.76 | 18.0 | 17.63 | 17.66 | 38508561.0 |
| 2009-01-22 11:00:00 | MSFT | Stock | 17.66 | 17.92 | 17.39 | 17.39 | 29236367.0 |
| 2009-01-22 12:00:00 | MSFT | Stock | 17.4 | 17.5 | 17.19 | 17.48 | 28091217.0 |
| 2009-01-22 13:00:00 | MSFT | Stock | 17.47 | 17.57 | 17.32 | 17.42 | 23738843.0 |
| 2009-01-22 14:00:00 | MSFT | Stock | 17.41 | 17.66 | 17.4 | 17.45 | 22209353.0 |
| 2009-01-22 15:00:00 | MSFT | Stock | 17.46 | 17.49 | 17.07 | 17.11 | 38025626.0 |
| 2009-01-22 16:00:00 | MSFT | Stock | 17.11 | 17.411 | 17.09 | 17.18 | 5109676.0 |
| 2009-01-22 17:00:00 | MSFT | Stock | 17.18 | 17.24 | 17.11 | 17.22 | 60565.0 |
| 2009-01-22 18:00:00 | MSFT | Stock | 17.22 | 17.24 | 17.11 | 17.23 | 40306.0 |
| 2009-01-22 19:00:00 | MSFT | Stock | 17.23 | 17.23 | 17.12 | 17.23 | 34746.0 |
| 2009-01-22 20:00:00 | MSFT | Stock | 17.52 | 17.52 | 17.52 | 17.52 | 1900.0 |
| 2009-01-22 08:00:00 | NVDA | Stock | 0.1875 | 0.19 | 0.1853 | 0.1853 | 104000.0 |
| 2009-01-22 09:00:00 | NVDA | Stock | 0.1853 | 0.1853 | 0.1788 | 0.1818 | 65231560.0 |
| 2009-01-22 10:00:00 | NVDA | Stock | 0.1815 | 0.1843 | 0.1795 | 0.1808 | 86207840.0 |
| 2009-01-22 11:00:00 | NVDA | Stock | 0.1805 | 0.1818 | 0.1793 | 0.1796 | 62229760.0 |
| 2009-01-22 12:00:00 | NVDA | Stock | 0.1795 | 0.183 | 0.1793 | 0.182 | 56527560.0 |
| 2009-01-22 13:00:00 | NVDA | Stock | 0.1818 | 0.186 | 0.1808 | 0.186 | 47687840.0 |
| 2009-01-22 14:00:00 | NVDA | Stock | 0.1858 | 0.1905 | 0.1848 | 0.1868 | 109643720.0 |
| 2009-01-22 15:00:00 | NVDA | Stock | 0.1868 | 0.1875 | 0.183 | 0.1853 | 98863240.0 |
| 2009-01-22 16:00:00 | NVDA | Stock | 0.1855 | 0.1858 | 0.1836 | 0.1838 | 3732200.0 |
| 2009-01-22 17:00:00 | NVDA | Stock | 0.1838 | 0.1838 | 0.1828 | 0.1828 | 16000.0 |
| 2009-01-22 18:00:00 | NVDA | Stock | 0.1838 | 0.1838 | 0.1838 | 0.1838 | 80000.0 |
| 2009-01-22 07:00:00 | AMZN | Stock | 2.5 | 2.5 | 2.496 | 2.5 | 24000.0 |
| 2009-01-22 08:00:00 | AMZN | Stock | 2.51 | 2.51 | 2.4975 | 2.4975 | 55200.0 |
| 2009-01-22 09:00:00 | AMZN | Stock | 2.497 | 2.497 | 2.425 | 2.4275 | 18324980.0 |
| 2009-01-22 10:00:00 | AMZN | Stock | 2.4285 | 2.49 | 2.4285 | 2.448 | 21419940.0 |
| 2009-01-22 11:00:00 | AMZN | Stock | 2.4465 | 2.47 | 2.4175 | 2.4238 | 15159580.0 |
| 2009-01-22 12:00:00 | AMZN | Stock | 2.4225 | 2.4645 | 2.413 | 2.4505 | 14769920.0 |
| 2009-01-22 13:00:00 | AMZN | Stock | 2.45 | 2.488 | 2.4465 | 2.4875 | 13232980.0 |
| 2009-01-22 14:00:00 | AMZN | Stock | 2.487 | 2.544 | 2.485 | 2.5115 | 26826520.0 |
> showing 50 of 38,866 rows — these rows as CSV