PREVIEW / stock_1hour / 2009-08-13
file: by_date/stock_1hour/2009/2009-08-13.parquet size: 865 KB rows: 42,023 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-13 05:00:00 | AAPL | Stock | 5.9446 | 5.9607 | 5.9429 | 5.9464 | 25760.0 |
| 2009-08-13 06:00:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 42000.0 |
| 2009-08-13 07:00:00 | AAPL | Stock | 5.9643 | 5.9718 | 5.9589 | 5.9639 | 318528.0 |
| 2009-08-13 08:00:00 | AAPL | Stock | 5.9539 | 5.9736 | 5.9296 | 5.9521 | 3423224.0 |
| 2009-08-13 09:00:00 | AAPL | Stock | 5.9489 | 5.9975 | 5.9464 | 5.9754 | 99770188.0 |
| 2009-08-13 10:00:00 | AAPL | Stock | 5.9754 | 6.0239 | 5.9621 | 6.01 | 87918040.0 |
| 2009-08-13 11:00:00 | AAPL | Stock | 6.01 | 6.0175 | 5.9996 | 6.0168 | 44246860.0 |
| 2009-08-13 12:00:00 | AAPL | Stock | 6.0168 | 6.0179 | 5.9946 | 5.9982 | 35054964.0 |
| 2009-08-13 13:00:00 | AAPL | Stock | 5.9989 | 6.0125 | 5.9757 | 5.9836 | 40004412.0 |
| 2009-08-13 14:00:00 | AAPL | Stock | 5.9832 | 5.9957 | 5.9493 | 5.9779 | 57278144.0 |
| 2009-08-13 15:00:00 | AAPL | Stock | 5.9782 | 6.0157 | 5.9771 | 6.015 | 58382884.0 |
| 2009-08-13 16:00:00 | AAPL | Stock | 6.015 | 6.0196 | 5.9895 | 6.0179 | 11288368.0 |
| 2009-08-13 17:00:00 | AAPL | Stock | 6.015 | 6.0182 | 6.0107 | 6.0125 | 208824.0 |
| 2009-08-13 18:00:00 | AAPL | Stock | 6.015 | 6.015 | 6.0111 | 6.0136 | 327628.0 |
| 2009-08-13 19:00:00 | AAPL | Stock | 6.0139 | 6.0164 | 6.0114 | 6.0161 | 90832.0 |
| 2009-08-13 07:00:00 | MSFT | Stock | 23.81 | 23.84 | 23.8 | 23.8 | 6100.0 |
| 2009-08-13 08:00:00 | MSFT | Stock | 23.8 | 23.95 | 23.65 | 23.85 | 98822.0 |
| 2009-08-13 09:00:00 | MSFT | Stock | 23.82 | 23.87 | 23.4 | 23.466 | 5600895.0 |
| 2009-08-13 10:00:00 | MSFT | Stock | 23.46 | 23.81 | 23.43 | 23.71 | 7834669.0 |
| 2009-08-13 11:00:00 | MSFT | Stock | 23.718 | 23.85 | 23.68 | 23.81 | 4562387.0 |
| 2009-08-13 12:00:00 | MSFT | Stock | 23.82 | 23.83 | 23.66 | 23.67 | 2827776.0 |
| 2009-08-13 13:00:00 | MSFT | Stock | 23.671 | 23.77 | 23.59 | 23.593 | 3016279.0 |
| 2009-08-13 14:00:00 | MSFT | Stock | 23.599 | 23.6 | 23.5 | 23.525 | 3739328.0 |
| 2009-08-13 15:00:00 | MSFT | Stock | 23.528 | 23.66 | 23.51 | 23.63 | 8100120.0 |
| 2009-08-13 16:00:00 | MSFT | Stock | 23.63 | 23.68 | 23.605 | 23.64 | 2197248.0 |
| 2009-08-13 17:00:00 | MSFT | Stock | 23.65 | 23.68 | 23.63 | 23.68 | 2813.0 |
| 2009-08-13 18:00:00 | MSFT | Stock | 23.6 | 23.62 | 23.6 | 23.62 | 270.0 |
| 2009-08-13 19:00:00 | MSFT | Stock | 23.57 | 23.63 | 23.52 | 23.63 | 1130.0 |
| 2009-08-13 08:00:00 | NVDA | Stock | 0.3375 | 0.3425 | 0.3375 | 0.338 | 197000.0 |
| 2009-08-13 09:00:00 | NVDA | Stock | 0.34 | 0.341 | 0.3322 | 0.3353 | 85978560.0 |
| 2009-08-13 10:00:00 | NVDA | Stock | 0.3355 | 0.3425 | 0.3348 | 0.3418 | 91185320.0 |
| 2009-08-13 11:00:00 | NVDA | Stock | 0.3418 | 0.3422 | 0.3375 | 0.34 | 58636600.0 |
| 2009-08-13 12:00:00 | NVDA | Stock | 0.3402 | 0.3413 | 0.3393 | 0.3402 | 24768880.0 |
| 2009-08-13 13:00:00 | NVDA | Stock | 0.3402 | 0.3435 | 0.3402 | 0.3435 | 49192680.0 |
| 2009-08-13 14:00:00 | NVDA | Stock | 0.3433 | 0.3438 | 0.3408 | 0.3421 | 76733120.0 |
| 2009-08-13 15:00:00 | NVDA | Stock | 0.3418 | 0.347 | 0.3418 | 0.3465 | 163719040.0 |
| 2009-08-13 16:00:00 | NVDA | Stock | 0.3458 | 0.347 | 0.3414 | 0.3458 | 11365200.0 |
| 2009-08-13 17:00:00 | NVDA | Stock | 0.345 | 0.3465 | 0.345 | 0.3465 | 96080.0 |
| 2009-08-13 18:00:00 | NVDA | Stock | 0.3462 | 0.3462 | 0.3462 | 0.3462 | 26400.0 |
| 2009-08-13 19:00:00 | NVDA | Stock | 0.3458 | 0.3458 | 0.3458 | 0.3458 | 40000.0 |
| 2009-08-13 07:00:00 | AMZN | Stock | 4.3365 | 4.3375 | 4.3365 | 4.3375 | 8000.0 |
| 2009-08-13 08:00:00 | AMZN | Stock | 4.33 | 4.3385 | 4.311 | 4.3225 | 302760.0 |
| 2009-08-13 09:00:00 | AMZN | Stock | 4.3235 | 4.3355 | 4.2035 | 4.2115 | 20951380.0 |
| 2009-08-13 10:00:00 | AMZN | Stock | 4.21 | 4.265 | 4.2055 | 4.2515 | 22333860.0 |
| 2009-08-13 11:00:00 | AMZN | Stock | 4.252 | 4.261 | 4.212 | 4.216 | 12943420.0 |
| 2009-08-13 12:00:00 | AMZN | Stock | 4.2165 | 4.2345 | 4.2035 | 4.227 | 10747200.0 |
| 2009-08-13 13:00:00 | AMZN | Stock | 4.2265 | 4.242 | 4.2225 | 4.23 | 9599900.0 |
| 2009-08-13 14:00:00 | AMZN | Stock | 4.231 | 4.231 | 4.208 | 4.213 | 9411440.0 |
| 2009-08-13 15:00:00 | AMZN | Stock | 4.213 | 4.2375 | 4.2105 | 4.229 | 20575720.0 |
| 2009-08-13 16:00:00 | AMZN | Stock | 4.229 | 4.2313 | 4.2238 | 4.225 | 3474600.0 |
> showing 50 of 42,023 rows — these rows as CSV