PREVIEW / stock_1hour / 2009-03-11
file: by_date/stock_1hour/2009/2009-03-11.parquet size: 825 KB rows: 40,843 symbols: 3,331
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-03-11 06:00:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1964 | 3.1964 | 8400.0 |
| 2009-03-11 07:00:00 | AAPL | Stock | 3.2004 | 3.2107 | 3.1868 | 3.1868 | 186200.0 |
| 2009-03-11 08:00:00 | AAPL | Stock | 3.205 | 3.2093 | 3.1839 | 3.2071 | 1764112.0 |
| 2009-03-11 09:00:00 | AAPL | Stock | 3.2093 | 3.2982 | 3.1993 | 3.2903 | 143770620.0 |
| 2009-03-11 10:00:00 | AAPL | Stock | 3.2907 | 3.3286 | 3.2775 | 3.3179 | 158110932.0 |
| 2009-03-11 11:00:00 | AAPL | Stock | 3.3179 | 3.3386 | 3.2957 | 3.315 | 94987984.0 |
| 2009-03-11 12:00:00 | AAPL | Stock | 3.3154 | 3.3236 | 3.2943 | 3.2968 | 58289672.0 |
| 2009-03-11 13:00:00 | AAPL | Stock | 3.2964 | 3.3529 | 3.2957 | 3.3518 | 89088916.0 |
| 2009-03-11 14:00:00 | AAPL | Stock | 3.3521 | 3.3596 | 3.3118 | 3.3283 | 115704624.0 |
| 2009-03-11 15:00:00 | AAPL | Stock | 3.3282 | 3.3543 | 3.3075 | 3.31 | 154569492.0 |
| 2009-03-11 16:00:00 | AAPL | Stock | 3.3096 | 3.3328 | 3.3092 | 3.3279 | 20917876.0 |
| 2009-03-11 17:00:00 | AAPL | Stock | 3.3214 | 3.3307 | 3.3214 | 3.3304 | 222040.0 |
| 2009-03-11 18:00:00 | AAPL | Stock | 3.3304 | 3.3357 | 3.31 | 3.3354 | 1206996.0 |
| 2009-03-11 19:00:00 | AAPL | Stock | 3.3286 | 3.3382 | 3.3189 | 3.325 | 356888.0 |
| 2009-03-11 08:00:00 | MSFT | Stock | 16.57 | 16.67 | 16.57 | 16.58 | 21983.0 |
| 2009-03-11 09:00:00 | MSFT | Stock | 16.59 | 16.95 | 16.43 | 16.781 | 10754900.0 |
| 2009-03-11 10:00:00 | MSFT | Stock | 16.78 | 17.06 | 16.66 | 16.94 | 13605590.0 |
| 2009-03-11 11:00:00 | MSFT | Stock | 16.95 | 16.99 | 16.73 | 16.8 | 8941236.0 |
| 2009-03-11 12:00:00 | MSFT | Stock | 16.806 | 16.91 | 16.67 | 16.7 | 6356964.0 |
| 2009-03-11 13:00:00 | MSFT | Stock | 16.7 | 16.96 | 16.68 | 16.898 | 9229451.0 |
| 2009-03-11 14:00:00 | MSFT | Stock | 16.91 | 16.95 | 16.68 | 16.835 | 6580434.0 |
| 2009-03-11 15:00:00 | MSFT | Stock | 16.82 | 17.2 | 16.82 | 17.13 | 21986459.0 |
| 2009-03-11 16:00:00 | MSFT | Stock | 17.12 | 17.13 | 16.877 | 17.08 | 2717125.0 |
| 2009-03-11 17:00:00 | MSFT | Stock | 17.11 | 17.11 | 16.827 | 17.08 | 276333.0 |
| 2009-03-11 18:00:00 | MSFT | Stock | 17.11 | 17.11 | 17.05 | 17.05 | 181734.0 |
| 2009-03-11 19:00:00 | MSFT | Stock | 17.04 | 17.08 | 17.0 | 17.0 | 28439.0 |
| 2009-03-11 20:00:00 | MSFT | Stock | 16.83 | 16.83 | 16.83 | 16.83 | 18100.0 |
| 2009-03-11 08:00:00 | NVDA | Stock | 0.2265 | 0.2265 | 0.225 | 0.2263 | 242600.0 |
| 2009-03-11 09:00:00 | NVDA | Stock | 0.2268 | 0.2305 | 0.2225 | 0.2278 | 116383280.0 |
| 2009-03-11 10:00:00 | NVDA | Stock | 0.228 | 0.2325 | 0.2263 | 0.2313 | 180397080.0 |
| 2009-03-11 11:00:00 | NVDA | Stock | 0.2316 | 0.2338 | 0.23 | 0.2312 | 129696920.0 |
| 2009-03-11 12:00:00 | NVDA | Stock | 0.231 | 0.232 | 0.229 | 0.229 | 74719000.0 |
| 2009-03-11 13:00:00 | NVDA | Stock | 0.2292 | 0.2312 | 0.2285 | 0.2303 | 72586120.0 |
| 2009-03-11 14:00:00 | NVDA | Stock | 0.2304 | 0.2318 | 0.2272 | 0.2299 | 85746200.0 |
| 2009-03-11 15:00:00 | NVDA | Stock | 0.2298 | 0.2338 | 0.2295 | 0.2322 | 187933600.0 |
| 2009-03-11 16:00:00 | NVDA | Stock | 0.2322 | 0.2325 | 0.23 | 0.2325 | 13898280.0 |
| 2009-03-11 18:00:00 | NVDA | Stock | 0.2335 | 0.2335 | 0.2335 | 0.2335 | 100000.0 |
| 2009-03-11 20:00:00 | NVDA | Stock | 0.232 | 0.232 | 0.232 | 0.232 | 200000.0 |
| 2009-03-11 05:00:00 | AMZN | Stock | 3.2895 | 3.3 | 3.2895 | 3.3 | 4700.0 |
| 2009-03-11 06:00:00 | AMZN | Stock | 3.3165 | 3.333 | 3.3165 | 3.333 | 30000.0 |
| 2009-03-11 07:00:00 | AMZN | Stock | 3.2905 | 3.3125 | 3.29 | 3.3125 | 12000.0 |
| 2009-03-11 08:00:00 | AMZN | Stock | 3.2765 | 3.3165 | 3.271 | 3.315 | 255500.0 |
| 2009-03-11 09:00:00 | AMZN | Stock | 3.308 | 3.3585 | 3.2635 | 3.347 | 41895040.0 |
| 2009-03-11 10:00:00 | AMZN | Stock | 3.3475 | 3.3875 | 3.3285 | 3.3703 | 47101700.0 |
| 2009-03-11 11:00:00 | AMZN | Stock | 3.3715 | 3.3785 | 3.341 | 3.375 | 27839640.0 |
| 2009-03-11 12:00:00 | AMZN | Stock | 3.3738 | 3.3765 | 3.355 | 3.3605 | 20806780.0 |
| 2009-03-11 13:00:00 | AMZN | Stock | 3.3565 | 3.41 | 3.3565 | 3.4015 | 33924300.0 |
| 2009-03-11 14:00:00 | AMZN | Stock | 3.402 | 3.42 | 3.3535 | 3.3946 | 34604940.0 |
| 2009-03-11 15:00:00 | AMZN | Stock | 3.3955 | 3.4685 | 3.3955 | 3.432 | 62815640.0 |
| 2009-03-11 16:00:00 | AMZN | Stock | 3.4295 | 3.4374 | 3.2855 | 3.4275 | 2691360.0 |
> showing 50 of 40,843 rows — these rows as CSV