PREVIEW / stock_30min / 2006-04-12
file: by_date/stock_30min/2006/2006-04-12.parquet size: 880 KB rows: 48,079 symbols: 2,228
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-04-12 06:00:00 | AAPL | Stock | 2.4232 | 2.4232 | 2.4232 | 2.4232 | 5600.0 |
| 2006-04-12 07:00:00 | AAPL | Stock | 2.4232 | 2.4232 | 2.4232 | 2.4232 | 11200.0 |
| 2006-04-12 08:00:00 | AAPL | Stock | 2.4268 | 2.4429 | 2.4232 | 2.4425 | 401800.0 |
| 2006-04-12 08:30:00 | AAPL | Stock | 2.4368 | 2.4446 | 2.4282 | 2.4382 | 2714040.0 |
| 2006-04-12 09:00:00 | AAPL | Stock | 2.4382 | 2.4425 | 2.4304 | 2.4304 | 2305324.0 |
| 2006-04-12 09:30:00 | AAPL | Stock | 2.4289 | 2.4348 | 2.4082 | 2.4139 | 96148808.0 |
| 2006-04-12 10:00:00 | AAPL | Stock | 2.4143 | 2.4243 | 2.4054 | 2.4154 | 64545432.0 |
| 2006-04-12 10:30:00 | AAPL | Stock | 2.4157 | 2.4239 | 2.4068 | 2.4175 | 49597380.0 |
| 2006-04-12 11:00:00 | AAPL | Stock | 2.4171 | 2.4289 | 2.4111 | 2.4254 | 49724780.0 |
| 2006-04-12 11:30:00 | AAPL | Stock | 2.4254 | 2.4304 | 2.4089 | 2.4114 | 48804728.0 |
| 2006-04-12 12:00:00 | AAPL | Stock | 2.4114 | 2.4125 | 2.4029 | 2.4061 | 43020376.0 |
| 2006-04-12 12:30:00 | AAPL | Stock | 2.4064 | 2.4186 | 2.4061 | 2.4175 | 22191288.0 |
| 2006-04-12 13:00:00 | AAPL | Stock | 2.4175 | 2.4196 | 2.4039 | 2.4054 | 23856896.0 |
| 2006-04-12 13:30:00 | AAPL | Stock | 2.4054 | 2.4136 | 2.4032 | 2.4054 | 25398128.0 |
| 2006-04-12 14:00:00 | AAPL | Stock | 2.4054 | 2.4086 | 2.3786 | 2.3825 | 83763316.0 |
| 2006-04-12 14:30:00 | AAPL | Stock | 2.3829 | 2.3879 | 2.3754 | 2.3771 | 63218036.0 |
| 2006-04-12 15:00:00 | AAPL | Stock | 2.3775 | 2.3868 | 2.3679 | 2.3836 | 74019540.0 |
| 2006-04-12 15:30:00 | AAPL | Stock | 2.3839 | 2.3864 | 2.3714 | 2.3836 | 80007732.0 |
| 2006-04-12 16:00:00 | AAPL | Stock | 2.3843 | 2.3843 | 2.3793 | 2.3796 | 1255464.0 |
| 2006-04-12 16:30:00 | AAPL | Stock | 2.38 | 2.3818 | 2.3796 | 2.3804 | 354704.0 |
| 2006-04-12 17:00:00 | AAPL | Stock | 2.3804 | 2.3836 | 2.3786 | 2.3836 | 453516.0 |
| 2006-04-12 17:30:00 | AAPL | Stock | 2.3829 | 2.3839 | 2.3804 | 2.3825 | 481124.0 |
| 2006-04-12 18:00:00 | AAPL | Stock | 2.3821 | 2.3839 | 2.3804 | 2.3804 | 433944.0 |
| 2006-04-12 04:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.1 | 27.1 | 100.0 |
| 2006-04-12 07:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.1 | 27.1 | 1000.0 |
| 2006-04-12 08:00:00 | MSFT | Stock | 27.1 | 27.11 | 27.1 | 27.11 | 2990.0 |
| 2006-04-12 08:30:00 | MSFT | Stock | 27.12 | 27.12 | 27.1 | 27.1 | 2900.0 |
| 2006-04-12 09:00:00 | MSFT | Stock | 27.09 | 27.11 | 27.09 | 27.11 | 4690.0 |
| 2006-04-12 09:30:00 | MSFT | Stock | 27.1 | 27.2 | 27.05 | 27.11 | 2773505.0 |
| 2006-04-12 10:00:00 | MSFT | Stock | 27.119 | 27.13 | 27.02 | 27.04 | 3356002.0 |
| 2006-04-12 10:30:00 | MSFT | Stock | 27.03 | 27.04 | 26.97 | 27.04 | 2933034.0 |
| 2006-04-12 11:00:00 | MSFT | Stock | 27.05 | 27.06 | 27.03 | 27.039 | 784359.0 |
| 2006-04-12 11:30:00 | MSFT | Stock | 27.03 | 27.13 | 27.02 | 27.1 | 2231791.0 |
| 2006-04-12 12:00:00 | MSFT | Stock | 27.1 | 27.15 | 27.09 | 27.1 | 1122557.0 |
| 2006-04-12 12:30:00 | MSFT | Stock | 27.1 | 27.19 | 27.1 | 27.18 | 1625599.0 |
| 2006-04-12 13:00:00 | MSFT | Stock | 27.18 | 27.19 | 27.12 | 27.13 | 1253861.0 |
| 2006-04-12 13:30:00 | MSFT | Stock | 27.13 | 27.14 | 27.1 | 27.11 | 1513657.0 |
| 2006-04-12 14:00:00 | MSFT | Stock | 27.11 | 27.13 | 27.095 | 27.12 | 2149612.0 |
| 2006-04-12 14:30:00 | MSFT | Stock | 27.12 | 27.12 | 27.08 | 27.11 | 1458531.0 |
| 2006-04-12 15:00:00 | MSFT | Stock | 27.112 | 27.17 | 27.11 | 27.11 | 2548372.0 |
| 2006-04-12 15:30:00 | MSFT | Stock | 27.11 | 27.13 | 27.02 | 27.07 | 5008841.0 |
| 2006-04-12 16:00:00 | MSFT | Stock | 27.08 | 27.2 | 27.06 | 27.1 | 1015476.0 |
| 2006-04-12 16:30:00 | MSFT | Stock | 27.09 | 27.1 | 27.09 | 27.09 | 3100.0 |
| 2006-04-12 17:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.1 | 27.1 | 500.0 |
| 2006-04-12 17:30:00 | MSFT | Stock | 27.09 | 27.09 | 27.09 | 27.09 | 1774.0 |
| 2006-04-12 18:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.1 | 27.1 | 500.0 |
| 2006-04-12 08:30:00 | NVDA | Stock | 0.4875 | 0.4893 | 0.4875 | 0.4893 | 42000.0 |
| 2006-04-12 09:00:00 | NVDA | Stock | 0.49 | 0.492 | 0.4887 | 0.492 | 425580.0 |
| 2006-04-12 09:30:00 | NVDA | Stock | 0.491 | 0.4975 | 0.4883 | 0.4943 | 42850260.0 |
| 2006-04-12 10:00:00 | NVDA | Stock | 0.4946 | 0.5007 | 0.4938 | 0.498 | 43313400.0 |
> showing 50 of 48,079 rows — these rows as CSV