PREVIEW / stock_1hour / 2022-12-16
file: by_date/stock_1hour/2022/2022-12-16.parquet size: 1.4 MB rows: 61,881 symbols: 1,986
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-16 04:00:00 | AAPL | Stock | 136.42 | 136.42 | 134.9 | 135.5 | 82591.0 |
| 2022-12-16 05:00:00 | AAPL | Stock | 135.52 | 135.68 | 135.2 | 135.38 | 23994.0 |
| 2022-12-16 06:00:00 | AAPL | Stock | 135.37 | 136.12 | 135.31 | 135.81 | 41711.0 |
| 2022-12-16 07:00:00 | AAPL | Stock | 135.9 | 136.7 | 135.89 | 136.7 | 131396.0 |
| 2022-12-16 08:00:00 | AAPL | Stock | 136.0716 | 136.91 | 134.9215 | 136.47 | 353272.0 |
| 2022-12-16 09:00:00 | AAPL | Stock | 136.42 | 137.65 | 135.51 | 136.635 | 21378441.0 |
| 2022-12-16 10:00:00 | AAPL | Stock | 136.6318 | 136.6631 | 134.682 | 135.14 | 11722393.0 |
| 2022-12-16 11:00:00 | AAPL | Stock | 135.145 | 135.23 | 134.36 | 134.535 | 7802781.0 |
| 2022-12-16 12:00:00 | AAPL | Stock | 134.53 | 135.3399 | 134.26 | 134.311 | 6209540.0 |
| 2022-12-16 13:00:00 | AAPL | Stock | 134.31 | 134.42 | 133.94 | 134.305 | 6969972.0 |
| 2022-12-16 14:00:00 | AAPL | Stock | 134.308 | 134.54 | 133.73 | 134.37 | 7499340.0 |
| 2022-12-16 15:00:00 | AAPL | Stock | 134.36 | 135.45 | 134.13 | 134.52 | 16267677.0 |
| 2022-12-16 16:00:00 | AAPL | Stock | 134.52 | 135.09 | 134.25 | 134.39 | 52524925.0 |
| 2022-12-16 17:00:00 | AAPL | Stock | 134.39 | 134.52 | 134.29 | 134.4463 | 188097.0 |
| 2022-12-16 18:00:00 | AAPL | Stock | 134.46 | 134.52 | 134.43 | 134.43 | 41514.0 |
| 2022-12-16 19:00:00 | AAPL | Stock | 134.43 | 134.51 | 134.41 | 134.42 | 24221.0 |
| 2022-12-16 04:00:00 | MSFT | Stock | 246.88 | 247.0 | 245.42 | 246.38 | 15460.0 |
| 2022-12-16 05:00:00 | MSFT | Stock | 246.32 | 247.0 | 245.79 | 246.77 | 7199.0 |
| 2022-12-16 06:00:00 | MSFT | Stock | 246.7 | 247.74 | 246.53 | 247.2 | 2841.0 |
| 2022-12-16 07:00:00 | MSFT | Stock | 247.26 | 247.95 | 246.66 | 247.94 | 13657.0 |
| 2022-12-16 08:00:00 | MSFT | Stock | 247.0008 | 247.85 | 246.3297 | 247.198 | 36484.0 |
| 2022-12-16 09:00:00 | MSFT | Stock | 247.34 | 249.84 | 245.99 | 248.59 | 8596555.0 |
| 2022-12-16 10:00:00 | MSFT | Stock | 248.5907 | 248.5907 | 244.81 | 245.49 | 2594468.0 |
| 2022-12-16 11:00:00 | MSFT | Stock | 245.48 | 245.6 | 243.59 | 243.78 | 2572004.0 |
| 2022-12-16 12:00:00 | MSFT | Stock | 243.79 | 245.1 | 243.55 | 243.88 | 1968639.0 |
| 2022-12-16 13:00:00 | MSFT | Stock | 243.88 | 244.64 | 243.67 | 244.185 | 1689383.0 |
| 2022-12-16 14:00:00 | MSFT | Stock | 244.17 | 245.48 | 243.79 | 245.08 | 2060211.0 |
| 2022-12-16 15:00:00 | MSFT | Stock | 245.08 | 247.5 | 243.51 | 243.85 | 9237753.0 |
| 2022-12-16 16:00:00 | MSFT | Stock | 243.86 | 244.8868 | 243.84 | 244.65 | 32479802.0 |
| 2022-12-16 17:00:00 | MSFT | Stock | 244.76 | 245.4999 | 244.65 | 245.36 | 19948.0 |
| 2022-12-16 18:00:00 | MSFT | Stock | 245.3 | 245.39 | 245.05 | 245.06 | 2425.0 |
| 2022-12-16 19:00:00 | MSFT | Stock | 245.05 | 245.19 | 244.93 | 245.19 | 6464.0 |
| 2022-12-16 04:00:00 | NVDA | Stock | 16.675 | 16.715 | 16.6 | 16.63 | 129390.0 |
| 2022-12-16 05:00:00 | NVDA | Stock | 16.64 | 16.667 | 16.624 | 16.659 | 66740.0 |
| 2022-12-16 06:00:00 | NVDA | Stock | 16.649 | 16.746 | 16.649 | 16.691 | 83850.0 |
| 2022-12-16 07:00:00 | NVDA | Stock | 16.702 | 16.8 | 16.7 | 16.8 | 293130.0 |
| 2022-12-16 08:00:00 | NVDA | Stock | 16.7697 | 16.95 | 16.6703 | 16.742 | 968080.0 |
| 2022-12-16 09:00:00 | NVDA | Stock | 16.75 | 17.041 | 16.65 | 16.895 | 57266210.0 |
| 2022-12-16 10:00:00 | NVDA | Stock | 16.892 | 16.892 | 16.41 | 16.59 | 66018690.0 |
| 2022-12-16 11:00:00 | NVDA | Stock | 16.59 | 16.669 | 16.507 | 16.525 | 44123880.0 |
| 2022-12-16 12:00:00 | NVDA | Stock | 16.5255 | 16.61 | 16.475 | 16.488 | 30989010.0 |
| 2022-12-16 13:00:00 | NVDA | Stock | 16.489 | 16.58 | 16.457 | 16.5649 | 26663210.0 |
| 2022-12-16 14:00:00 | NVDA | Stock | 16.562 | 16.657 | 16.529 | 16.635 | 27301780.0 |
| 2022-12-16 15:00:00 | NVDA | Stock | 16.633 | 16.735 | 16.564 | 16.577 | 60492960.0 |
| 2022-12-16 16:00:00 | NVDA | Stock | 16.579 | 16.587 | 16.5 | 16.5225 | 74985910.0 |
| 2022-12-16 17:00:00 | NVDA | Stock | 16.535 | 16.545 | 16.52 | 16.536 | 135250.0 |
| 2022-12-16 18:00:00 | NVDA | Stock | 16.533 | 16.535 | 16.51 | 16.52 | 210860.0 |
| 2022-12-16 19:00:00 | NVDA | Stock | 16.513 | 16.537 | 16.5 | 16.5 | 135000.0 |
| 2022-12-16 04:00:00 | AMZN | Stock | 87.26 | 87.94 | 87.15 | 87.45 | 52686.0 |
| 2022-12-16 05:00:00 | AMZN | Stock | 87.47 | 87.55 | 87.31 | 87.5 | 24133.0 |
> showing 50 of 61,881 rows — these rows as CSV