PREVIEW / stock_1hour / 2009-02-11
file: by_date/stock_1hour/2009/2009-02-11.parquet size: 785 KB rows: 38,892 symbols: 3,285
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-02-11 04:00:00 | AAPL | Stock | 3.5007 | 3.5036 | 3.5007 | 3.5036 | 28000.0 |
| 2009-02-11 07:00:00 | AAPL | Stock | 3.5089 | 3.5089 | 3.4218 | 3.4286 | 1108940.0 |
| 2009-02-11 08:00:00 | AAPL | Stock | 3.4218 | 3.4389 | 3.4036 | 3.4179 | 5082840.0 |
| 2009-02-11 09:00:00 | AAPL | Stock | 3.4161 | 3.5071 | 3.4143 | 3.4939 | 109169172.0 |
| 2009-02-11 10:00:00 | AAPL | Stock | 3.4939 | 3.5071 | 3.4439 | 3.4673 | 123642596.0 |
| 2009-02-11 11:00:00 | AAPL | Stock | 3.4668 | 3.5111 | 3.4554 | 3.4929 | 76232492.0 |
| 2009-02-11 12:00:00 | AAPL | Stock | 3.4921 | 3.5046 | 3.4757 | 3.4864 | 54227320.0 |
| 2009-02-11 13:00:00 | AAPL | Stock | 3.4864 | 3.4946 | 3.4421 | 3.4511 | 67766244.0 |
| 2009-02-11 14:00:00 | AAPL | Stock | 3.4504 | 3.4789 | 3.4204 | 3.4696 | 110554360.0 |
| 2009-02-11 15:00:00 | AAPL | Stock | 3.4696 | 3.4904 | 3.4496 | 3.4582 | 111838552.0 |
| 2009-02-11 16:00:00 | AAPL | Stock | 3.4575 | 3.4809 | 3.45 | 3.4571 | 5252996.0 |
| 2009-02-11 17:00:00 | AAPL | Stock | 3.4554 | 3.4554 | 3.4475 | 3.4475 | 118860.0 |
| 2009-02-11 18:00:00 | AAPL | Stock | 3.45 | 3.4579 | 3.4475 | 3.4557 | 3972444.0 |
| 2009-02-11 19:00:00 | AAPL | Stock | 3.4507 | 3.455 | 3.4468 | 3.4482 | 67928.0 |
| 2009-02-11 07:00:00 | MSFT | Stock | 19.05 | 19.05 | 18.75 | 18.75 | 5300.0 |
| 2009-02-11 08:00:00 | MSFT | Stock | 18.88 | 18.99 | 18.82 | 18.93 | 10750.0 |
| 2009-02-11 09:00:00 | MSFT | Stock | 18.93 | 19.29 | 18.92 | 19.24 | 6371485.0 |
| 2009-02-11 10:00:00 | MSFT | Stock | 19.23 | 19.37 | 19.1 | 19.3 | 13008058.0 |
| 2009-02-11 11:00:00 | MSFT | Stock | 19.3 | 19.35 | 19.21 | 19.25 | 5215381.0 |
| 2009-02-11 12:00:00 | MSFT | Stock | 19.245 | 19.37 | 19.13 | 19.15 | 5897738.0 |
| 2009-02-11 13:00:00 | MSFT | Stock | 19.15 | 19.23 | 19.01 | 19.02 | 5479247.0 |
| 2009-02-11 14:00:00 | MSFT | Stock | 19.03 | 19.44 | 18.99 | 19.41 | 8458117.0 |
| 2009-02-11 15:00:00 | MSFT | Stock | 19.42 | 19.49 | 19.21 | 19.21 | 11881010.0 |
| 2009-02-11 16:00:00 | MSFT | Stock | 19.22 | 19.36 | 19.16 | 19.28 | 1320352.0 |
| 2009-02-11 17:00:00 | MSFT | Stock | 19.25 | 19.25 | 19.22 | 19.25 | 15300.0 |
| 2009-02-11 18:00:00 | MSFT | Stock | 19.27 | 19.27 | 19.27 | 19.27 | 200.0 |
| 2009-02-11 19:00:00 | MSFT | Stock | 19.27 | 19.27 | 19.27 | 19.27 | 300.0 |
| 2009-02-11 07:00:00 | NVDA | Stock | 0.2188 | 0.2188 | 0.2188 | 0.2188 | 8000.0 |
| 2009-02-11 08:00:00 | NVDA | Stock | 0.2188 | 0.2263 | 0.2175 | 0.2188 | 1287200.0 |
| 2009-02-11 09:00:00 | NVDA | Stock | 0.219 | 0.2225 | 0.2128 | 0.2175 | 409165320.0 |
| 2009-02-11 10:00:00 | NVDA | Stock | 0.2175 | 0.2192 | 0.1998 | 0.2013 | 549856640.0 |
| 2009-02-11 11:00:00 | NVDA | Stock | 0.2013 | 0.2062 | 0.1965 | 0.2033 | 226320960.0 |
| 2009-02-11 12:00:00 | NVDA | Stock | 0.2033 | 0.2068 | 0.2002 | 0.2053 | 142155640.0 |
| 2009-02-11 13:00:00 | NVDA | Stock | 0.205 | 0.2058 | 0.2 | 0.2002 | 155308200.0 |
| 2009-02-11 14:00:00 | NVDA | Stock | 0.2002 | 0.2072 | 0.1985 | 0.205 | 166782120.0 |
| 2009-02-11 15:00:00 | NVDA | Stock | 0.205 | 0.2053 | 0.1995 | 0.2035 | 291691520.0 |
| 2009-02-11 16:00:00 | NVDA | Stock | 0.2033 | 0.2075 | 0.2022 | 0.2038 | 19254400.0 |
| 2009-02-11 17:00:00 | NVDA | Stock | 0.2043 | 0.2062 | 0.2043 | 0.2062 | 212000.0 |
| 2009-02-11 18:00:00 | NVDA | Stock | 0.2062 | 0.2062 | 0.2062 | 0.2062 | 40000.0 |
| 2009-02-11 19:00:00 | NVDA | Stock | 0.2043 | 0.2053 | 0.2043 | 0.2053 | 96000.0 |
| 2009-02-11 07:00:00 | AMZN | Stock | 3.159 | 3.159 | 3.15 | 3.15 | 22000.0 |
| 2009-02-11 08:00:00 | AMZN | Stock | 3.1495 | 3.1505 | 3.125 | 3.1275 | 346680.0 |
| 2009-02-11 09:00:00 | AMZN | Stock | 3.1305 | 3.189 | 3.125 | 3.1545 | 18199020.0 |
| 2009-02-11 10:00:00 | AMZN | Stock | 3.154 | 3.1885 | 3.1125 | 3.1815 | 31153620.0 |
| 2009-02-11 11:00:00 | AMZN | Stock | 3.181 | 3.218 | 3.1635 | 3.1995 | 19920800.0 |
| 2009-02-11 12:00:00 | AMZN | Stock | 3.2 | 3.216 | 3.1705 | 3.1995 | 13814680.0 |
| 2009-02-11 13:00:00 | AMZN | Stock | 3.199 | 3.2105 | 3.161 | 3.1785 | 19592400.0 |
| 2009-02-11 14:00:00 | AMZN | Stock | 3.179 | 3.24 | 3.164 | 3.2325 | 22881260.0 |
| 2009-02-11 15:00:00 | AMZN | Stock | 3.234 | 3.245 | 3.205 | 3.2175 | 34369940.0 |
| 2009-02-11 16:00:00 | AMZN | Stock | 3.2105 | 3.2208 | 3.1855 | 3.2125 | 1898820.0 |
> showing 50 of 38,892 rows — these rows as CSV