PREVIEW / stock_30min / 2006-07-19
file: by_date/stock_30min/2006/2006-07-19.parquet size: 921 KB rows: 49,776 symbols: 2,316
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-19 08:00:00 | AAPL | Stock | 1.8979 | 1.9107 | 1.8929 | 1.91 | 2133320.0 |
| 2006-07-19 08:30:00 | AAPL | Stock | 1.9075 | 1.9089 | 1.8964 | 1.9 | 2367176.0 |
| 2006-07-19 09:00:00 | AAPL | Stock | 1.8989 | 1.9 | 1.89 | 1.89 | 2360456.0 |
| 2006-07-19 09:30:00 | AAPL | Stock | 1.8914 | 1.9086 | 1.87 | 1.8982 | 100873388.0 |
| 2006-07-19 10:00:00 | AAPL | Stock | 1.8979 | 1.9125 | 1.8804 | 1.8911 | 114137856.0 |
| 2006-07-19 10:30:00 | AAPL | Stock | 1.8911 | 1.8964 | 1.8796 | 1.8918 | 74261096.0 |
| 2006-07-19 11:00:00 | AAPL | Stock | 1.8914 | 1.905 | 1.885 | 1.8857 | 54603528.0 |
| 2006-07-19 11:30:00 | AAPL | Stock | 1.8857 | 1.8993 | 1.8807 | 1.8971 | 45760344.0 |
| 2006-07-19 12:00:00 | AAPL | Stock | 1.8971 | 1.9104 | 1.8911 | 1.91 | 56077476.0 |
| 2006-07-19 12:30:00 | AAPL | Stock | 1.9102 | 1.9239 | 1.9036 | 1.9236 | 68117420.0 |
| 2006-07-19 13:00:00 | AAPL | Stock | 1.9236 | 1.9564 | 1.9182 | 1.9543 | 156123576.0 |
| 2006-07-19 13:30:00 | AAPL | Stock | 1.9539 | 1.9671 | 1.9511 | 1.9546 | 102281648.0 |
| 2006-07-19 14:00:00 | AAPL | Stock | 1.9546 | 1.9571 | 1.9375 | 1.9514 | 82909736.0 |
| 2006-07-19 14:30:00 | AAPL | Stock | 1.9518 | 1.9546 | 1.9421 | 1.945 | 62048784.0 |
| 2006-07-19 15:00:00 | AAPL | Stock | 1.9446 | 1.9536 | 1.9407 | 1.9464 | 81849712.0 |
| 2006-07-19 15:30:00 | AAPL | Stock | 1.9464 | 1.9525 | 1.9304 | 1.9325 | 107840264.0 |
| 2006-07-19 16:00:00 | AAPL | Stock | 1.9329 | 1.9571 | 1.8714 | 1.8918 | 7295596.0 |
| 2006-07-19 16:30:00 | AAPL | Stock | 1.8721 | 2.0886 | 1.8404 | 2.0793 | 196465164.0 |
| 2006-07-19 17:00:00 | AAPL | Stock | 2.0804 | 2.1 | 2.0139 | 2.0743 | 54025832.0 |
| 2006-07-19 17:30:00 | AAPL | Stock | 2.075 | 2.1011 | 2.075 | 2.1011 | 17888892.0 |
| 2006-07-19 18:00:00 | AAPL | Stock | 2.0964 | 2.0996 | 2.0893 | 2.095 | 5949944.0 |
| 2006-07-19 07:30:00 | MSFT | Stock | 22.71 | 22.71 | 22.71 | 22.71 | 100.0 |
| 2006-07-19 08:00:00 | MSFT | Stock | 22.69 | 22.75 | 22.69 | 22.72 | 11798.0 |
| 2006-07-19 08:30:00 | MSFT | Stock | 22.68 | 22.74 | 22.65 | 22.74 | 45691.0 |
| 2006-07-19 09:00:00 | MSFT | Stock | 22.68 | 22.82 | 22.62 | 22.82 | 101109.0 |
| 2006-07-19 09:30:00 | MSFT | Stock | 22.82 | 23.2 | 22.72 | 23.09 | 10264658.0 |
| 2006-07-19 10:00:00 | MSFT | Stock | 23.09 | 23.18 | 22.99 | 23.02 | 9226962.0 |
| 2006-07-19 10:30:00 | MSFT | Stock | 23.01 | 23.15 | 22.98 | 23.08 | 5635556.0 |
| 2006-07-19 11:00:00 | MSFT | Stock | 23.07 | 23.17 | 23.07 | 23.11 | 3244685.0 |
| 2006-07-19 11:30:00 | MSFT | Stock | 23.12 | 23.2 | 23.04 | 23.103 | 2482625.0 |
| 2006-07-19 12:00:00 | MSFT | Stock | 23.1 | 23.12 | 23.05 | 23.12 | 1450123.0 |
| 2006-07-19 12:30:00 | MSFT | Stock | 23.12 | 23.23 | 23.11 | 23.22 | 2997378.0 |
| 2006-07-19 13:00:00 | MSFT | Stock | 23.22 | 23.32 | 23.21 | 23.29 | 3943917.0 |
| 2006-07-19 13:30:00 | MSFT | Stock | 23.3 | 23.3 | 23.16 | 23.16 | 3169592.0 |
| 2006-07-19 14:00:00 | MSFT | Stock | 23.16 | 23.35 | 23.16 | 23.33 | 5258366.0 |
| 2006-07-19 14:30:00 | MSFT | Stock | 23.34 | 23.37 | 23.25 | 23.36 | 5486899.0 |
| 2006-07-19 15:00:00 | MSFT | Stock | 23.37 | 23.43 | 23.34 | 23.4 | 7766018.0 |
| 2006-07-19 15:30:00 | MSFT | Stock | 23.4 | 23.46 | 23.3 | 23.44 | 10224537.0 |
| 2006-07-19 16:00:00 | MSFT | Stock | 23.42 | 23.46 | 23.34 | 23.34 | 216510.0 |
| 2006-07-19 16:30:00 | MSFT | Stock | 23.34 | 23.45 | 23.33 | 23.39 | 825785.0 |
| 2006-07-19 17:00:00 | MSFT | Stock | 23.39 | 23.39 | 23.35 | 23.35 | 1400.0 |
| 2006-07-19 17:30:00 | MSFT | Stock | 23.38 | 23.39 | 23.35 | 23.39 | 7999.0 |
| 2006-07-19 18:00:00 | MSFT | Stock | 23.4 | 23.45 | 23.39 | 23.42 | 4268.0 |
| 2006-07-19 08:00:00 | NVDA | Stock | 0.3133 | 0.3133 | 0.3133 | 0.3133 | 6000.0 |
| 2006-07-19 08:30:00 | NVDA | Stock | 0.3133 | 0.3133 | 0.3125 | 0.3125 | 90000.0 |
| 2006-07-19 09:00:00 | NVDA | Stock | 0.3102 | 0.3132 | 0.3085 | 0.3112 | 1488600.0 |
| 2006-07-19 09:30:00 | NVDA | Stock | 0.3117 | 0.3158 | 0.3093 | 0.3142 | 77990340.0 |
| 2006-07-19 10:00:00 | NVDA | Stock | 0.3142 | 0.3232 | 0.3123 | 0.3198 | 118902240.0 |
| 2006-07-19 10:30:00 | NVDA | Stock | 0.3198 | 0.326 | 0.3142 | 0.324 | 132294480.0 |
| 2006-07-19 11:00:00 | NVDA | Stock | 0.3242 | 0.3258 | 0.3142 | 0.3245 | 64283880.0 |
> showing 50 of 49,776 rows — these rows as CSV