PREVIEW / stock_30min / 2008-04-09
file: by_date/stock_30min/2008/2008-04-09.parquet size: 1.2 MB rows: 66,983 symbols: 3,289
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-09 04:00:00 | AAPL | Stock | 5.4518 | 5.4518 | 5.4518 | 5.4518 | 3948.0 |
| 2008-04-09 04:30:00 | AAPL | Stock | 5.4332 | 5.4332 | 5.4332 | 5.4332 | 2800.0 |
| 2008-04-09 06:30:00 | AAPL | Stock | 5.4536 | 5.4686 | 5.4536 | 5.4686 | 5600.0 |
| 2008-04-09 07:00:00 | AAPL | Stock | 5.4696 | 5.4929 | 5.4696 | 5.4929 | 33600.0 |
| 2008-04-09 07:30:00 | AAPL | Stock | 5.4921 | 5.4921 | 5.4664 | 5.4664 | 49112.0 |
| 2008-04-09 08:00:00 | AAPL | Stock | 5.4675 | 5.4821 | 5.4611 | 5.4671 | 1080016.0 |
| 2008-04-09 08:30:00 | AAPL | Stock | 5.4679 | 5.4893 | 5.4679 | 5.4868 | 1323756.0 |
| 2008-04-09 09:00:00 | AAPL | Stock | 5.4875 | 5.4889 | 5.4786 | 5.4789 | 1137472.0 |
| 2008-04-09 09:30:00 | AAPL | Stock | 5.4768 | 5.4961 | 5.4004 | 5.4304 | 138198648.0 |
| 2008-04-09 10:00:00 | AAPL | Stock | 5.4296 | 5.4821 | 5.4064 | 5.4639 | 95251408.0 |
| 2008-04-09 10:30:00 | AAPL | Stock | 5.4643 | 5.4664 | 5.4268 | 5.4554 | 65327948.0 |
| 2008-04-09 11:00:00 | AAPL | Stock | 5.4564 | 5.4564 | 5.4225 | 5.4246 | 40108712.0 |
| 2008-04-09 11:30:00 | AAPL | Stock | 5.4257 | 5.4282 | 5.375 | 5.3836 | 72302748.0 |
| 2008-04-09 12:00:00 | AAPL | Stock | 5.3839 | 5.3982 | 5.3736 | 5.3886 | 44731764.0 |
| 2008-04-09 12:30:00 | AAPL | Stock | 5.3889 | 5.3996 | 5.375 | 5.3875 | 44888088.0 |
| 2008-04-09 13:00:00 | AAPL | Stock | 5.3868 | 5.4286 | 5.3825 | 5.4075 | 71490384.0 |
| 2008-04-09 13:30:00 | AAPL | Stock | 5.4075 | 5.4393 | 5.4046 | 5.4271 | 40730452.0 |
| 2008-04-09 14:00:00 | AAPL | Stock | 5.4282 | 5.4361 | 5.3832 | 5.3939 | 55954724.0 |
| 2008-04-09 14:30:00 | AAPL | Stock | 5.3939 | 5.4107 | 5.3836 | 5.3875 | 49205464.0 |
| 2008-04-09 15:00:00 | AAPL | Stock | 5.3879 | 5.4164 | 5.3746 | 5.4021 | 61034568.0 |
| 2008-04-09 15:30:00 | AAPL | Stock | 5.4021 | 5.4207 | 5.3868 | 5.4086 | 68408704.0 |
| 2008-04-09 16:00:00 | AAPL | Stock | 5.4089 | 5.43 | 5.4057 | 5.4064 | 7084840.0 |
| 2008-04-09 16:30:00 | AAPL | Stock | 5.4161 | 5.4211 | 5.4081 | 5.4211 | 608272.0 |
| 2008-04-09 17:00:00 | AAPL | Stock | 5.4189 | 5.4196 | 5.415 | 5.4161 | 83104.0 |
| 2008-04-09 17:30:00 | AAPL | Stock | 5.4161 | 5.4193 | 5.4136 | 5.4164 | 356580.0 |
| 2008-04-09 18:00:00 | AAPL | Stock | 5.4189 | 5.4229 | 5.4139 | 5.4139 | 152124.0 |
| 2008-04-09 19:00:00 | AAPL | Stock | 5.4146 | 5.4207 | 5.4146 | 5.4207 | 106372.0 |
| 2008-04-09 19:30:00 | AAPL | Stock | 5.4207 | 5.4211 | 5.4154 | 5.42 | 192640.0 |
| 2008-04-09 07:30:00 | MSFT | Stock | 28.9 | 28.9 | 28.8 | 28.8 | 1100.0 |
| 2008-04-09 08:00:00 | MSFT | Stock | 28.78 | 28.85 | 28.78 | 28.8 | 10618.0 |
| 2008-04-09 08:30:00 | MSFT | Stock | 28.8 | 28.83 | 28.8 | 28.8 | 3200.0 |
| 2008-04-09 09:00:00 | MSFT | Stock | 28.8 | 28.81 | 28.67 | 28.67 | 23300.0 |
| 2008-04-09 09:30:00 | MSFT | Stock | 28.69 | 28.87 | 28.68 | 28.76 | 3656420.0 |
| 2008-04-09 10:00:00 | MSFT | Stock | 28.76 | 28.945 | 28.69 | 28.88 | 3046130.0 |
| 2008-04-09 10:30:00 | MSFT | Stock | 28.88 | 28.89 | 28.74 | 28.788 | 3274641.0 |
| 2008-04-09 11:00:00 | MSFT | Stock | 28.79 | 28.9 | 28.71 | 28.76 | 2071597.0 |
| 2008-04-09 11:30:00 | MSFT | Stock | 28.77 | 28.8 | 28.61 | 28.632 | 2771080.0 |
| 2008-04-09 12:00:00 | MSFT | Stock | 28.635 | 28.8 | 28.62 | 28.77 | 1697475.0 |
| 2008-04-09 12:30:00 | MSFT | Stock | 28.775 | 28.8 | 28.6 | 28.61 | 1971651.0 |
| 2008-04-09 13:00:00 | MSFT | Stock | 28.61 | 28.76 | 28.6 | 28.68 | 1340903.0 |
| 2008-04-09 13:30:00 | MSFT | Stock | 28.69 | 28.7 | 28.65 | 28.69 | 1149938.0 |
| 2008-04-09 14:00:00 | MSFT | Stock | 28.68 | 28.72 | 28.59 | 28.63 | 2316721.0 |
| 2008-04-09 14:30:00 | MSFT | Stock | 28.62 | 28.65 | 28.54 | 28.563 | 2930387.0 |
| 2008-04-09 15:00:00 | MSFT | Stock | 28.57 | 29.027 | 28.55 | 28.72 | 4489169.0 |
| 2008-04-09 15:30:00 | MSFT | Stock | 28.72 | 29.04 | 28.7 | 28.92 | 7788639.0 |
| 2008-04-09 16:00:00 | MSFT | Stock | 28.92 | 28.95 | 28.706 | 28.95 | 5874871.0 |
| 2008-04-09 16:30:00 | MSFT | Stock | 28.95 | 28.95 | 28.89 | 28.91 | 1007400.0 |
| 2008-04-09 17:00:00 | MSFT | Stock | 28.93 | 28.95 | 28.91 | 28.95 | 9915.0 |
| 2008-04-09 17:30:00 | MSFT | Stock | 28.92 | 28.93 | 28.91 | 28.92 | 4200.0 |
| 2008-04-09 18:00:00 | MSFT | Stock | 28.92 | 28.93 | 28.92 | 28.92 | 3500.0 |
> showing 50 of 66,983 rows — these rows as CSV