PREVIEW / stock_1hour / 2009-08-18
file: by_date/stock_1hour/2009/2009-08-18.parquet size: 874 KB rows: 42,124 symbols: 3,369
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-18 04:00:00 | AAPL | Stock | 5.7389 | 5.7389 | 5.7389 | 5.7389 | 25200.0 |
| 2009-08-18 05:00:00 | AAPL | Stock | 5.7357 | 5.7357 | 5.7357 | 5.7357 | 5600.0 |
| 2009-08-18 06:00:00 | AAPL | Stock | 5.7482 | 5.7711 | 5.7429 | 5.7429 | 119896.0 |
| 2009-08-18 07:00:00 | AAPL | Stock | 5.7429 | 5.79 | 5.7393 | 5.7746 | 1064280.0 |
| 2009-08-18 08:00:00 | AAPL | Stock | 5.775 | 5.7839 | 5.7593 | 5.7789 | 4430664.0 |
| 2009-08-18 09:00:00 | AAPL | Stock | 5.7789 | 5.8089 | 5.7646 | 5.7943 | 86113496.0 |
| 2009-08-18 10:00:00 | AAPL | Stock | 5.7943 | 5.8143 | 5.7875 | 5.7968 | 69668984.0 |
| 2009-08-18 11:00:00 | AAPL | Stock | 5.7971 | 5.8396 | 5.7936 | 5.8318 | 60217304.0 |
| 2009-08-18 12:00:00 | AAPL | Stock | 5.8311 | 5.8457 | 5.8034 | 5.8414 | 31489864.0 |
| 2009-08-18 13:00:00 | AAPL | Stock | 5.8414 | 5.8461 | 5.8286 | 5.8321 | 36878268.0 |
| 2009-08-18 14:00:00 | AAPL | Stock | 5.8318 | 5.8564 | 5.8293 | 5.8475 | 43953812.0 |
| 2009-08-18 15:00:00 | AAPL | Stock | 5.8475 | 5.8657 | 5.8471 | 5.8571 | 74137308.0 |
| 2009-08-18 16:00:00 | AAPL | Stock | 5.8525 | 5.8643 | 5.8221 | 5.8464 | 11807348.0 |
| 2009-08-18 17:00:00 | AAPL | Stock | 5.85 | 5.8582 | 5.8393 | 5.8475 | 783216.0 |
| 2009-08-18 18:00:00 | AAPL | Stock | 5.8482 | 5.8582 | 5.8482 | 5.8518 | 5763968.0 |
| 2009-08-18 19:00:00 | AAPL | Stock | 5.8511 | 5.8514 | 5.8404 | 5.8407 | 614572.0 |
| 2009-08-18 04:00:00 | MSFT | Stock | 23.34 | 23.34 | 23.34 | 23.34 | 200.0 |
| 2009-08-18 06:00:00 | MSFT | Stock | 23.52 | 23.55 | 23.52 | 23.55 | 2100.0 |
| 2009-08-18 07:00:00 | MSFT | Stock | 23.5 | 23.5 | 23.38 | 23.39 | 3000.0 |
| 2009-08-18 08:00:00 | MSFT | Stock | 23.4 | 23.42 | 23.35 | 23.37 | 69033.0 |
| 2009-08-18 09:00:00 | MSFT | Stock | 23.35 | 23.42 | 23.21 | 23.34 | 5046708.0 |
| 2009-08-18 10:00:00 | MSFT | Stock | 23.34 | 23.39 | 23.29 | 23.29 | 5121561.0 |
| 2009-08-18 11:00:00 | MSFT | Stock | 23.298 | 23.5 | 23.285 | 23.37 | 4169306.0 |
| 2009-08-18 12:00:00 | MSFT | Stock | 23.375 | 23.52 | 23.35 | 23.486 | 3557363.0 |
| 2009-08-18 13:00:00 | MSFT | Stock | 23.48 | 23.6 | 23.47 | 23.56 | 4716875.0 |
| 2009-08-18 14:00:00 | MSFT | Stock | 23.57 | 23.65 | 23.56 | 23.6 | 4012146.0 |
| 2009-08-18 15:00:00 | MSFT | Stock | 23.59 | 23.65 | 23.53 | 23.58 | 8820721.0 |
| 2009-08-18 16:00:00 | MSFT | Stock | 23.58 | 23.6 | 23.48 | 23.482 | 2433170.0 |
| 2009-08-18 17:00:00 | MSFT | Stock | 23.51 | 23.58 | 23.48 | 23.57 | 85105.0 |
| 2009-08-18 18:00:00 | MSFT | Stock | 23.58 | 23.58 | 23.43 | 23.43 | 26986.0 |
| 2009-08-18 19:00:00 | MSFT | Stock | 23.43 | 23.47 | 23.39 | 23.39 | 15721.0 |
| 2009-08-18 20:00:00 | MSFT | Stock | 23.25 | 23.25 | 23.25 | 23.25 | 200.0 |
| 2009-08-18 08:00:00 | NVDA | Stock | 0.3253 | 0.3253 | 0.3253 | 0.3253 | 8000.0 |
| 2009-08-18 09:00:00 | NVDA | Stock | 0.3238 | 0.3273 | 0.3213 | 0.3243 | 43646880.0 |
| 2009-08-18 10:00:00 | NVDA | Stock | 0.3245 | 0.329 | 0.3243 | 0.3283 | 97332640.0 |
| 2009-08-18 11:00:00 | NVDA | Stock | 0.328 | 0.3322 | 0.328 | 0.3318 | 74810480.0 |
| 2009-08-18 12:00:00 | NVDA | Stock | 0.3318 | 0.334 | 0.3315 | 0.3335 | 55883240.0 |
| 2009-08-18 13:00:00 | NVDA | Stock | 0.3335 | 0.3348 | 0.333 | 0.3348 | 69571480.0 |
| 2009-08-18 14:00:00 | NVDA | Stock | 0.3348 | 0.337 | 0.3345 | 0.3358 | 88361360.0 |
| 2009-08-18 15:00:00 | NVDA | Stock | 0.3355 | 0.3358 | 0.3325 | 0.3333 | 187304920.0 |
| 2009-08-18 16:00:00 | NVDA | Stock | 0.3328 | 0.3338 | 0.322 | 0.3338 | 5372080.0 |
| 2009-08-18 17:00:00 | NVDA | Stock | 0.3333 | 0.3333 | 0.3333 | 0.3333 | 782160.0 |
| 2009-08-18 18:00:00 | NVDA | Stock | 0.332 | 0.332 | 0.3315 | 0.3315 | 40000.0 |
| 2009-08-18 20:00:00 | NVDA | Stock | 0.3215 | 0.3215 | 0.3215 | 0.3215 | 4000.0 |
| 2009-08-18 08:00:00 | AMZN | Stock | 4.0855 | 4.0855 | 4.075 | 4.085 | 51000.0 |
| 2009-08-18 09:00:00 | AMZN | Stock | 4.0815 | 4.0835 | 4.0395 | 4.0425 | 13072320.0 |
| 2009-08-18 10:00:00 | AMZN | Stock | 4.044 | 4.111 | 4.0438 | 4.1055 | 23318280.0 |
| 2009-08-18 11:00:00 | AMZN | Stock | 4.106 | 4.1335 | 4.095 | 4.118 | 19064960.0 |
| 2009-08-18 12:00:00 | AMZN | Stock | 4.1175 | 4.1345 | 4.1125 | 4.1235 | 5589760.0 |
| 2009-08-18 13:00:00 | AMZN | Stock | 4.123 | 4.133 | 4.0875 | 4.0895 | 19097580.0 |
> showing 50 of 42,124 rows — these rows as CSV