PREVIEW / stock_1hour / 2001-02-02
file: by_date/stock_1hour/2001/2001-02-02.parquet size: 357 KB rows: 16,399 symbols: 1,260
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 |
|---|---|---|---|---|---|---|---|
| 2001-02-02 08:00:00 | AAPL | Stock | 0.3783 | 0.3884 | 0.3783 | 0.3828 | 1461600.0 |
| 2001-02-02 09:00:00 | AAPL | Stock | 0.3828 | 0.3895 | 0.3772 | 0.3884 | 51441600.0 |
| 2001-02-02 10:00:00 | AAPL | Stock | 0.3895 | 0.3917 | 0.3806 | 0.3806 | 93587200.0 |
| 2001-02-02 11:00:00 | AAPL | Stock | 0.3806 | 0.3884 | 0.3717 | 0.3717 | 59074400.0 |
| 2001-02-02 12:00:00 | AAPL | Stock | 0.3717 | 0.3761 | 0.3705 | 0.3739 | 29444800.0 |
| 2001-02-02 13:00:00 | AAPL | Stock | 0.3739 | 0.3806 | 0.3717 | 0.3772 | 32356800.0 |
| 2001-02-02 14:00:00 | AAPL | Stock | 0.3783 | 0.3862 | 0.3761 | 0.3772 | 69255200.0 |
| 2001-02-02 15:00:00 | AAPL | Stock | 0.3772 | 0.3806 | 0.3661 | 0.3694 | 60569600.0 |
| 2001-02-02 16:00:00 | AAPL | Stock | 0.3683 | 0.3711 | 0.3638 | 0.3661 | 8327200.0 |
| 2001-02-02 18:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 16800.0 |
| 2001-02-02 08:00:00 | MSFT | Stock | 31.125 | 31.5625 | 31.125 | 31.3125 | 98800.0 |
| 2001-02-02 09:00:00 | MSFT | Stock | 31.375 | 31.6875 | 31.2188 | 31.4688 | 9725200.0 |
| 2001-02-02 10:00:00 | MSFT | Stock | 31.5 | 31.6875 | 31.1875 | 31.4688 | 11048600.0 |
| 2001-02-02 11:00:00 | MSFT | Stock | 31.4375 | 31.5 | 30.75 | 30.8438 | 11388000.0 |
| 2001-02-02 12:00:00 | MSFT | Stock | 30.8125 | 31.1875 | 30.6875 | 30.6875 | 8354200.0 |
| 2001-02-02 13:00:00 | MSFT | Stock | 30.6875 | 31.1875 | 30.5938 | 30.9375 | 6769800.0 |
| 2001-02-02 14:00:00 | MSFT | Stock | 30.9375 | 31.0 | 30.5625 | 30.75 | 5089200.0 |
| 2001-02-02 15:00:00 | MSFT | Stock | 30.7812 | 30.7812 | 30.375 | 30.4062 | 11168200.0 |
| 2001-02-02 16:00:00 | MSFT | Stock | 30.4375 | 30.6875 | 30.375 | 30.5625 | 3101600.0 |
| 2001-02-02 17:00:00 | MSFT | Stock | 30.5625 | 30.5625 | 30.4062 | 30.4375 | 10000.0 |
| 2001-02-02 18:00:00 | MSFT | Stock | 30.5 | 30.5 | 30.4062 | 30.5 | 2200.0 |
| 2001-02-02 08:00:00 | NVDA | Stock | 0.2167 | 0.2167 | 0.2167 | 0.2167 | 24000.0 |
| 2001-02-02 09:00:00 | NVDA | Stock | 0.2168 | 0.2214 | 0.2156 | 0.2193 | 29184000.0 |
| 2001-02-02 10:00:00 | NVDA | Stock | 0.2195 | 0.2198 | 0.2135 | 0.2135 | 49560000.0 |
| 2001-02-02 11:00:00 | NVDA | Stock | 0.2135 | 0.2146 | 0.2089 | 0.212 | 43224000.0 |
| 2001-02-02 12:00:00 | NVDA | Stock | 0.212 | 0.2128 | 0.2117 | 0.212 | 22536000.0 |
| 2001-02-02 13:00:00 | NVDA | Stock | 0.212 | 0.2128 | 0.2104 | 0.2122 | 27456000.0 |
| 2001-02-02 14:00:00 | NVDA | Stock | 0.2115 | 0.2122 | 0.2094 | 0.2094 | 35712000.0 |
| 2001-02-02 15:00:00 | NVDA | Stock | 0.2094 | 0.2099 | 0.1938 | 0.1951 | 80952000.0 |
| 2001-02-02 16:00:00 | NVDA | Stock | 0.1951 | 0.1969 | 0.1943 | 0.1964 | 4488000.0 |
| 2001-02-02 17:00:00 | NVDA | Stock | 0.196 | 0.196 | 0.1958 | 0.1958 | 96000.0 |
| 2001-02-02 18:00:00 | NVDA | Stock | 0.1958 | 0.1958 | 0.1958 | 0.1958 | 96000.0 |
| 2001-02-02 08:00:00 | AMZN | Stock | 0.8234 | 0.8375 | 0.8125 | 0.8188 | 2560000.0 |
| 2001-02-02 09:00:00 | AMZN | Stock | 0.8125 | 0.825 | 0.7625 | 0.7688 | 32258000.0 |
| 2001-02-02 10:00:00 | AMZN | Stock | 0.775 | 0.7812 | 0.7313 | 0.7469 | 67022000.0 |
| 2001-02-02 11:00:00 | AMZN | Stock | 0.75 | 0.7625 | 0.7375 | 0.7406 | 43654000.0 |
| 2001-02-02 12:00:00 | AMZN | Stock | 0.7375 | 0.7531 | 0.7375 | 0.7438 | 11134000.0 |
| 2001-02-02 13:00:00 | AMZN | Stock | 0.7438 | 0.7469 | 0.7344 | 0.7438 | 16612000.0 |
| 2001-02-02 14:00:00 | AMZN | Stock | 0.7406 | 0.7469 | 0.7375 | 0.7453 | 13644000.0 |
| 2001-02-02 15:00:00 | AMZN | Stock | 0.7469 | 0.7469 | 0.7125 | 0.7156 | 39862000.0 |
| 2001-02-02 16:00:00 | AMZN | Stock | 0.7156 | 0.75 | 0.7125 | 0.725 | 7574000.0 |
| 2001-02-02 17:00:00 | AMZN | Stock | 0.7281 | 0.7344 | 0.7188 | 0.7281 | 544000.0 |
| 2001-02-02 18:00:00 | AMZN | Stock | 0.7281 | 0.7313 | 0.7281 | 0.7313 | 38000.0 |
| 2001-02-02 09:00:00 | CL | Stock | 30.575 | 30.875 | 30.2 | 30.3 | 520600.0 |
| 2001-02-02 10:00:00 | CL | Stock | 30.3 | 30.6 | 30.175 | 30.18 | 585600.0 |
| 2001-02-02 11:00:00 | CL | Stock | 30.18 | 30.225 | 29.955 | 30.16 | 609400.0 |
| 2001-02-02 12:00:00 | CL | Stock | 30.15 | 30.345 | 30.15 | 30.245 | 371600.0 |
| 2001-02-02 13:00:00 | CL | Stock | 30.225 | 30.5 | 30.2 | 30.4 | 436800.0 |
| 2001-02-02 14:00:00 | CL | Stock | 30.45 | 30.575 | 30.425 | 30.47 | 249200.0 |
| 2001-02-02 15:00:00 | CL | Stock | 30.46 | 30.5 | 30.35 | 30.38 | 437000.0 |
> showing 50 of 16,399 rows — these rows as CSV