PREVIEW / stock_1hour / 2009-09-03
file: by_date/stock_1hour/2009/2009-09-03.parquet size: 854 KB rows: 41,575 symbols: 3,358
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-09-03 07:00:00 | AAPL | Stock | 5.9464 | 5.9825 | 5.9464 | 5.9711 | 292824.0 |
| 2009-09-03 08:00:00 | AAPL | Stock | 5.9664 | 5.9818 | 5.9504 | 5.9614 | 1285928.0 |
| 2009-09-03 09:00:00 | AAPL | Stock | 5.9571 | 5.9732 | 5.9121 | 5.9175 | 57121204.0 |
| 2009-09-03 10:00:00 | AAPL | Stock | 5.9161 | 5.9321 | 5.8929 | 5.9302 | 59425576.0 |
| 2009-09-03 11:00:00 | AAPL | Stock | 5.9293 | 5.9603 | 5.9293 | 5.9564 | 37979284.0 |
| 2009-09-03 12:00:00 | AAPL | Stock | 5.9564 | 5.9679 | 5.9414 | 5.9457 | 24535112.0 |
| 2009-09-03 13:00:00 | AAPL | Stock | 5.9461 | 5.9632 | 5.94 | 5.9439 | 25476584.0 |
| 2009-09-03 14:00:00 | AAPL | Stock | 5.9443 | 5.9482 | 5.9229 | 5.9357 | 24183208.0 |
| 2009-09-03 15:00:00 | AAPL | Stock | 5.9364 | 5.9589 | 5.9268 | 5.9482 | 45618356.0 |
| 2009-09-03 16:00:00 | AAPL | Stock | 5.9479 | 5.9543 | 5.9359 | 5.9518 | 12124280.0 |
| 2009-09-03 17:00:00 | AAPL | Stock | 5.9543 | 5.9643 | 5.9475 | 5.9604 | 174440.0 |
| 2009-09-03 18:00:00 | AAPL | Stock | 5.9571 | 5.9621 | 5.9482 | 5.9611 | 204652.0 |
| 2009-09-03 19:00:00 | AAPL | Stock | 5.9607 | 5.9607 | 5.9554 | 5.9571 | 75404.0 |
| 2009-09-03 06:00:00 | MSFT | Stock | 23.9 | 23.9 | 23.9 | 23.9 | 300.0 |
| 2009-09-03 07:00:00 | MSFT | Stock | 23.89 | 23.9 | 23.89 | 23.9 | 300.0 |
| 2009-09-03 08:00:00 | MSFT | Stock | 24.0 | 24.0 | 23.86 | 23.99 | 103490.0 |
| 2009-09-03 09:00:00 | MSFT | Stock | 23.98 | 23.99 | 23.81 | 23.88 | 3140515.0 |
| 2009-09-03 10:00:00 | MSFT | Stock | 23.87 | 23.932 | 23.76 | 23.9 | 5813158.0 |
| 2009-09-03 11:00:00 | MSFT | Stock | 23.91 | 23.97 | 23.82 | 23.93 | 3249349.0 |
| 2009-09-03 12:00:00 | MSFT | Stock | 23.93 | 24.04 | 23.9 | 23.952 | 3558208.0 |
| 2009-09-03 13:00:00 | MSFT | Stock | 23.96 | 24.06 | 23.95 | 24.035 | 3351584.0 |
| 2009-09-03 14:00:00 | MSFT | Stock | 24.03 | 24.06 | 23.98 | 24.05 | 5287829.0 |
| 2009-09-03 15:00:00 | MSFT | Stock | 24.05 | 24.14 | 24.0 | 24.11 | 6442034.0 |
| 2009-09-03 16:00:00 | MSFT | Stock | 24.11 | 24.12 | 23.958 | 24.09 | 2504891.0 |
| 2009-09-03 17:00:00 | MSFT | Stock | 23.917 | 24.11 | 23.917 | 24.11 | 1700.0 |
| 2009-09-03 18:00:00 | MSFT | Stock | 24.15 | 24.16 | 24.07 | 24.07 | 9275.0 |
| 2009-09-03 19:00:00 | MSFT | Stock | 24.07 | 24.07 | 24.07 | 24.07 | 287.0 |
| 2009-09-03 08:00:00 | NVDA | Stock | 0.3562 | 0.359 | 0.3562 | 0.359 | 60000.0 |
| 2009-09-03 09:00:00 | NVDA | Stock | 0.3588 | 0.3625 | 0.3548 | 0.362 | 70029080.0 |
| 2009-09-03 10:00:00 | NVDA | Stock | 0.3621 | 0.3628 | 0.3553 | 0.3568 | 103598240.0 |
| 2009-09-03 11:00:00 | NVDA | Stock | 0.357 | 0.3585 | 0.3555 | 0.3578 | 49835080.0 |
| 2009-09-03 12:00:00 | NVDA | Stock | 0.358 | 0.3609 | 0.3575 | 0.3588 | 44807040.0 |
| 2009-09-03 13:00:00 | NVDA | Stock | 0.3588 | 0.3608 | 0.3585 | 0.36 | 37309360.0 |
| 2009-09-03 14:00:00 | NVDA | Stock | 0.36 | 0.3625 | 0.3598 | 0.362 | 90041400.0 |
| 2009-09-03 15:00:00 | NVDA | Stock | 0.362 | 0.3648 | 0.3612 | 0.3645 | 120724000.0 |
| 2009-09-03 16:00:00 | NVDA | Stock | 0.364 | 0.3643 | 0.3601 | 0.3642 | 2915400.0 |
| 2009-09-03 04:00:00 | AMZN | Stock | 3.936 | 3.936 | 3.936 | 3.936 | 2000.0 |
| 2009-09-03 08:00:00 | AMZN | Stock | 3.931 | 3.937 | 3.9275 | 3.9355 | 41000.0 |
| 2009-09-03 09:00:00 | AMZN | Stock | 3.937 | 3.941 | 3.8755 | 3.9285 | 18511900.0 |
| 2009-09-03 10:00:00 | AMZN | Stock | 3.928 | 3.945 | 3.9 | 3.9439 | 17064620.0 |
| 2009-09-03 11:00:00 | AMZN | Stock | 3.9445 | 3.948 | 3.926 | 3.933 | 7583020.0 |
| 2009-09-03 12:00:00 | AMZN | Stock | 3.9325 | 3.935 | 3.9115 | 3.9155 | 6944300.0 |
| 2009-09-03 13:00:00 | AMZN | Stock | 3.9151 | 3.9319 | 3.9135 | 3.923 | 7299640.0 |
| 2009-09-03 14:00:00 | AMZN | Stock | 3.9235 | 3.93 | 3.901 | 3.914 | 7197440.0 |
| 2009-09-03 15:00:00 | AMZN | Stock | 3.9136 | 3.9255 | 3.9075 | 3.9225 | 13788840.0 |
| 2009-09-03 16:00:00 | AMZN | Stock | 3.921 | 3.9238 | 3.9178 | 3.9195 | 763860.0 |
| 2009-09-03 17:00:00 | AMZN | Stock | 3.921 | 3.93 | 3.921 | 3.93 | 18000.0 |
| 2009-09-03 18:00:00 | AMZN | Stock | 3.936 | 3.936 | 3.936 | 3.936 | 12000.0 |
| 2009-09-03 19:00:00 | AMZN | Stock | 3.944 | 3.944 | 3.94 | 3.94 | 6000.0 |
| 2009-09-03 07:00:00 | TLT | Stock | 97.15 | 97.15 | 96.97 | 96.97 | 400.0 |
> showing 50 of 41,575 rows — these rows as CSV