PREVIEW / stock_1hour / 2009-08-05
file: by_date/stock_1hour/2009/2009-08-05.parquet size: 884 KB rows: 42,590 symbols: 3,362
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-08-05 07:00:00 | AAPL | Stock | 5.8857 | 5.9246 | 5.8857 | 5.9018 | 15400.0 |
| 2009-08-05 08:00:00 | AAPL | Stock | 5.9107 | 5.9364 | 5.8946 | 5.9268 | 1255380.0 |
| 2009-08-05 09:00:00 | AAPL | Stock | 5.9254 | 5.9782 | 5.9107 | 5.9236 | 79094400.0 |
| 2009-08-05 10:00:00 | AAPL | Stock | 5.9236 | 5.9268 | 5.8886 | 5.8932 | 76125196.0 |
| 2009-08-05 11:00:00 | AAPL | Stock | 5.8936 | 5.9089 | 5.8786 | 5.8836 | 41729660.0 |
| 2009-08-05 12:00:00 | AAPL | Stock | 5.8836 | 5.9011 | 5.8716 | 5.8761 | 43122632.0 |
| 2009-08-05 13:00:00 | AAPL | Stock | 5.8757 | 5.8907 | 5.8646 | 5.8767 | 36653372.0 |
| 2009-08-05 14:00:00 | AAPL | Stock | 5.8761 | 5.905 | 5.8707 | 5.8993 | 40463724.0 |
| 2009-08-05 15:00:00 | AAPL | Stock | 5.8993 | 5.91 | 5.8793 | 5.8929 | 67519480.0 |
| 2009-08-05 16:00:00 | AAPL | Stock | 5.9004 | 5.9056 | 5.8786 | 5.8829 | 25724356.0 |
| 2009-08-05 17:00:00 | AAPL | Stock | 5.9074 | 5.9074 | 5.8607 | 5.8607 | 2232468.0 |
| 2009-08-05 18:00:00 | AAPL | Stock | 5.8968 | 5.8968 | 5.8504 | 5.8643 | 437556.0 |
| 2009-08-05 19:00:00 | AAPL | Stock | 5.8625 | 5.8679 | 5.8579 | 5.8607 | 93296.0 |
| 2009-08-05 08:00:00 | MSFT | Stock | 23.77 | 23.84 | 23.75 | 23.84 | 32668.0 |
| 2009-08-05 09:00:00 | MSFT | Stock | 23.84 | 24.25 | 23.73 | 23.99 | 9606693.0 |
| 2009-08-05 10:00:00 | MSFT | Stock | 24.0 | 24.14 | 23.91 | 24.06 | 9647023.0 |
| 2009-08-05 11:00:00 | MSFT | Stock | 24.06 | 24.1 | 23.95 | 23.97 | 4941062.0 |
| 2009-08-05 12:00:00 | MSFT | Stock | 23.98 | 24.04 | 23.93 | 23.95 | 4189172.0 |
| 2009-08-05 13:00:00 | MSFT | Stock | 23.96 | 23.99 | 23.89 | 23.91 | 5099263.0 |
| 2009-08-05 14:00:00 | MSFT | Stock | 23.91 | 23.95 | 23.81 | 23.93 | 4659748.0 |
| 2009-08-05 15:00:00 | MSFT | Stock | 23.93 | 24.005 | 23.79 | 23.82 | 11066157.0 |
| 2009-08-05 16:00:00 | MSFT | Stock | 23.82 | 23.995 | 23.75 | 23.77 | 3021565.0 |
| 2009-08-05 17:00:00 | MSFT | Stock | 23.75 | 23.77 | 23.7 | 23.71 | 41200.0 |
| 2009-08-05 18:00:00 | MSFT | Stock | 23.71 | 23.74 | 23.7 | 23.71 | 10701.0 |
| 2009-08-05 19:00:00 | MSFT | Stock | 23.74 | 23.85 | 23.71 | 23.75 | 27300.0 |
| 2009-08-05 08:00:00 | NVDA | Stock | 0.335 | 0.335 | 0.335 | 0.335 | 100000.0 |
| 2009-08-05 09:00:00 | NVDA | Stock | 0.3358 | 0.3375 | 0.3318 | 0.3322 | 75633200.0 |
| 2009-08-05 10:00:00 | NVDA | Stock | 0.3322 | 0.3335 | 0.3283 | 0.3335 | 121319280.0 |
| 2009-08-05 11:00:00 | NVDA | Stock | 0.3334 | 0.335 | 0.3303 | 0.3313 | 79693440.0 |
| 2009-08-05 12:00:00 | NVDA | Stock | 0.3313 | 0.3325 | 0.3298 | 0.3313 | 56569800.0 |
| 2009-08-05 13:00:00 | NVDA | Stock | 0.3315 | 0.334 | 0.33 | 0.3328 | 79406560.0 |
| 2009-08-05 14:00:00 | NVDA | Stock | 0.333 | 0.3362 | 0.3328 | 0.3358 | 65584800.0 |
| 2009-08-05 15:00:00 | NVDA | Stock | 0.3358 | 0.3373 | 0.3348 | 0.3353 | 89154080.0 |
| 2009-08-05 16:00:00 | NVDA | Stock | 0.3355 | 0.3362 | 0.332 | 0.3362 | 36929080.0 |
| 2009-08-05 17:00:00 | NVDA | Stock | 0.3342 | 0.3375 | 0.3342 | 0.3362 | 2259800.0 |
| 2009-08-05 18:00:00 | NVDA | Stock | 0.3362 | 0.3375 | 0.3348 | 0.3348 | 688000.0 |
| 2009-08-05 19:00:00 | NVDA | Stock | 0.3375 | 0.3375 | 0.335 | 0.336 | 34080.0 |
| 2009-08-05 07:00:00 | AMZN | Stock | 4.312 | 4.312 | 4.312 | 4.312 | 2000.0 |
| 2009-08-05 08:00:00 | AMZN | Stock | 4.29 | 4.2995 | 4.2845 | 4.2845 | 12000.0 |
| 2009-08-05 09:00:00 | AMZN | Stock | 4.2845 | 4.2875 | 4.171 | 4.174 | 21937320.0 |
| 2009-08-05 10:00:00 | AMZN | Stock | 4.1735 | 4.2265 | 4.151 | 4.2096 | 37177760.0 |
| 2009-08-05 11:00:00 | AMZN | Stock | 4.211 | 4.284 | 4.2025 | 4.2195 | 15832780.0 |
| 2009-08-05 12:00:00 | AMZN | Stock | 4.2193 | 4.236 | 4.21 | 4.2175 | 12224780.0 |
| 2009-08-05 13:00:00 | AMZN | Stock | 4.218 | 4.23 | 4.204 | 4.214 | 11926320.0 |
| 2009-08-05 14:00:00 | AMZN | Stock | 4.214 | 4.225 | 4.1975 | 4.2245 | 13767240.0 |
| 2009-08-05 15:00:00 | AMZN | Stock | 4.224 | 4.23 | 4.2025 | 4.2145 | 22745220.0 |
| 2009-08-05 16:00:00 | AMZN | Stock | 4.2135 | 4.2306 | 4.199 | 4.2145 | 1205980.0 |
| 2009-08-05 17:00:00 | AMZN | Stock | 4.225 | 4.2972 | 4.203 | 4.208 | 746400.0 |
| 2009-08-05 18:00:00 | AMZN | Stock | 4.2145 | 4.2145 | 4.195 | 4.195 | 380180.0 |
| 2009-08-05 19:00:00 | AMZN | Stock | 4.2065 | 4.2065 | 4.195 | 4.195 | 16260.0 |
> showing 50 of 42,590 rows — these rows as CSV