PREVIEW / stock_30min / 2006-04-21
file: by_date/stock_30min/2006/2006-04-21.parquet size: 911 KB rows: 49,213 symbols: 2,237
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-21 06:00:00 | AAPL | Stock | 2.4304 | 2.4304 | 2.4304 | 2.4304 | 2800.0 |
| 2006-04-21 07:30:00 | AAPL | Stock | 2.4268 | 2.4332 | 2.4268 | 2.4282 | 103600.0 |
| 2006-04-21 08:00:00 | AAPL | Stock | 2.4282 | 2.4332 | 2.4232 | 2.4268 | 1263192.0 |
| 2006-04-21 08:30:00 | AAPL | Stock | 2.4286 | 2.4321 | 2.4268 | 2.4304 | 1775256.0 |
| 2006-04-21 09:00:00 | AAPL | Stock | 2.4307 | 2.4496 | 2.4286 | 2.4343 | 4952360.0 |
| 2006-04-21 09:30:00 | AAPL | Stock | 2.4354 | 2.4514 | 2.4164 | 2.4254 | 125478360.0 |
| 2006-04-21 10:00:00 | AAPL | Stock | 2.425 | 2.4357 | 2.4107 | 2.4118 | 73413676.0 |
| 2006-04-21 10:30:00 | AAPL | Stock | 2.4121 | 2.4193 | 2.4018 | 2.4189 | 78715084.0 |
| 2006-04-21 11:00:00 | AAPL | Stock | 2.4189 | 2.4243 | 2.4136 | 2.42 | 40159112.0 |
| 2006-04-21 11:30:00 | AAPL | Stock | 2.4196 | 2.4211 | 2.4132 | 2.4188 | 26153680.0 |
| 2006-04-21 12:00:00 | AAPL | Stock | 2.4189 | 2.4196 | 2.4021 | 2.4132 | 46258240.0 |
| 2006-04-21 12:30:00 | AAPL | Stock | 2.4136 | 2.4225 | 2.4118 | 2.4186 | 42305172.0 |
| 2006-04-21 13:00:00 | AAPL | Stock | 2.4189 | 2.4193 | 2.4082 | 2.4093 | 24375876.0 |
| 2006-04-21 13:30:00 | AAPL | Stock | 2.4093 | 2.4143 | 2.4089 | 2.4104 | 18440380.0 |
| 2006-04-21 14:00:00 | AAPL | Stock | 2.4107 | 2.4118 | 2.3946 | 2.4004 | 50799028.0 |
| 2006-04-21 14:30:00 | AAPL | Stock | 2.4007 | 2.4011 | 2.3821 | 2.3857 | 73902472.0 |
| 2006-04-21 15:00:00 | AAPL | Stock | 2.3864 | 2.3914 | 2.3739 | 2.3914 | 73027472.0 |
| 2006-04-21 15:30:00 | AAPL | Stock | 2.3914 | 2.4071 | 2.39 | 2.3921 | 87371536.0 |
| 2006-04-21 16:00:00 | AAPL | Stock | 2.3921 | 2.4221 | 2.3861 | 2.3925 | 1507576.0 |
| 2006-04-21 16:30:00 | AAPL | Stock | 2.3918 | 2.3975 | 2.3857 | 2.3857 | 2123240.0 |
| 2006-04-21 17:00:00 | AAPL | Stock | 2.385 | 2.3879 | 2.3786 | 2.3821 | 1915256.0 |
| 2006-04-21 17:30:00 | AAPL | Stock | 2.3854 | 2.3857 | 2.3821 | 2.3839 | 191436.0 |
| 2006-04-21 18:00:00 | AAPL | Stock | 2.3825 | 2.385 | 2.3818 | 2.385 | 189700.0 |
| 2006-04-21 08:00:00 | MSFT | Stock | 27.05 | 27.08 | 27.05 | 27.06 | 12070.0 |
| 2006-04-21 08:30:00 | MSFT | Stock | 27.06 | 27.08 | 27.05 | 27.06 | 17099.0 |
| 2006-04-21 09:00:00 | MSFT | Stock | 27.06 | 27.17 | 27.05 | 27.06 | 521736.0 |
| 2006-04-21 09:30:00 | MSFT | Stock | 27.05 | 27.17 | 27.0 | 27.1 | 12354966.0 |
| 2006-04-21 10:00:00 | MSFT | Stock | 27.1 | 27.19 | 27.09 | 27.149 | 3138963.0 |
| 2006-04-21 10:30:00 | MSFT | Stock | 27.14 | 27.2 | 27.11 | 27.14 | 4019067.0 |
| 2006-04-21 11:00:00 | MSFT | Stock | 27.131 | 27.2 | 27.09 | 27.18 | 3380472.0 |
| 2006-04-21 11:30:00 | MSFT | Stock | 27.18 | 27.3 | 27.15 | 27.27 | 5476793.0 |
| 2006-04-21 12:00:00 | MSFT | Stock | 27.27 | 27.37 | 27.27 | 27.32 | 3271638.0 |
| 2006-04-21 12:30:00 | MSFT | Stock | 27.32 | 27.39 | 27.32 | 27.32 | 2257802.0 |
| 2006-04-21 13:00:00 | MSFT | Stock | 27.32 | 27.35 | 27.29 | 27.32 | 1737050.0 |
| 2006-04-21 13:30:00 | MSFT | Stock | 27.33 | 27.34 | 27.25 | 27.28 | 1452606.0 |
| 2006-04-21 14:00:00 | MSFT | Stock | 27.29 | 27.31 | 27.21 | 27.24 | 4694630.0 |
| 2006-04-21 14:30:00 | MSFT | Stock | 27.24 | 27.26 | 27.11 | 27.14 | 4660163.0 |
| 2006-04-21 15:00:00 | MSFT | Stock | 27.14 | 27.17 | 27.09 | 27.11 | 3295037.0 |
| 2006-04-21 15:30:00 | MSFT | Stock | 27.11 | 27.2 | 27.1 | 27.13 | 6437608.0 |
| 2006-04-21 16:00:00 | MSFT | Stock | 27.13 | 27.187 | 27.13 | 27.14 | 107737.0 |
| 2006-04-21 16:30:00 | MSFT | Stock | 27.15 | 27.15 | 27.14 | 27.14 | 19400.0 |
| 2006-04-21 17:00:00 | MSFT | Stock | 27.14 | 27.16 | 27.14 | 27.16 | 1585.0 |
| 2006-04-21 17:30:00 | MSFT | Stock | 27.17 | 27.17 | 27.15 | 27.17 | 2804.0 |
| 2006-04-21 18:00:00 | MSFT | Stock | 27.14 | 27.14 | 27.14 | 27.14 | 465.0 |
| 2006-04-21 08:00:00 | NVDA | Stock | 0.4853 | 0.4853 | 0.4822 | 0.4822 | 226500.0 |
| 2006-04-21 09:00:00 | NVDA | Stock | 0.485 | 0.488 | 0.4842 | 0.4868 | 1819440.0 |
| 2006-04-21 09:30:00 | NVDA | Stock | 0.4868 | 0.4888 | 0.4758 | 0.4785 | 67560720.0 |
| 2006-04-21 10:00:00 | NVDA | Stock | 0.4783 | 0.4802 | 0.4757 | 0.4777 | 43446360.0 |
| 2006-04-21 10:30:00 | NVDA | Stock | 0.4773 | 0.482 | 0.4762 | 0.478 | 49833000.0 |
| 2006-04-21 11:00:00 | NVDA | Stock | 0.478 | 0.4785 | 0.4752 | 0.4753 | 34955460.0 |
> showing 50 of 49,213 rows — these rows as CSV