PREVIEW / stock_30min / 2008-05-02
file: by_date/stock_30min/2008/2008-05-02.parquet size: 1.2 MB rows: 68,162 symbols: 3,283
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-05-02 05:00:00 | AAPL | Stock | 6.4693 | 6.4714 | 6.4693 | 6.4714 | 25200.0 |
| 2008-05-02 05:30:00 | AAPL | Stock | 6.4582 | 6.4582 | 6.4582 | 6.4582 | 2800.0 |
| 2008-05-02 06:00:00 | AAPL | Stock | 6.4536 | 6.4536 | 6.4536 | 6.4536 | 2800.0 |
| 2008-05-02 07:00:00 | AAPL | Stock | 6.4429 | 6.4518 | 6.4325 | 6.4339 | 89992.0 |
| 2008-05-02 07:30:00 | AAPL | Stock | 6.4393 | 6.4393 | 6.4061 | 6.4071 | 315140.0 |
| 2008-05-02 08:00:00 | AAPL | Stock | 6.4129 | 6.4246 | 6.3939 | 6.4004 | 3639076.0 |
| 2008-05-02 08:30:00 | AAPL | Stock | 6.3979 | 6.5 | 6.395 | 6.4643 | 17683708.0 |
| 2008-05-02 09:00:00 | AAPL | Stock | 6.4704 | 6.4725 | 6.4329 | 6.4329 | 6361348.0 |
| 2008-05-02 09:30:00 | AAPL | Stock | 6.4329 | 6.4821 | 6.3929 | 6.4318 | 180775700.0 |
| 2008-05-02 10:00:00 | AAPL | Stock | 6.4315 | 6.4971 | 6.4304 | 6.4407 | 131399296.0 |
| 2008-05-02 10:30:00 | AAPL | Stock | 6.4404 | 6.4532 | 6.3768 | 6.3921 | 120928360.0 |
| 2008-05-02 11:00:00 | AAPL | Stock | 6.3907 | 6.4593 | 6.39 | 6.3996 | 78021496.0 |
| 2008-05-02 11:30:00 | AAPL | Stock | 6.3989 | 6.4464 | 6.3989 | 6.4222 | 43735832.0 |
| 2008-05-02 12:00:00 | AAPL | Stock | 6.4214 | 6.4421 | 6.3929 | 6.4204 | 45432240.0 |
| 2008-05-02 12:30:00 | AAPL | Stock | 6.42 | 6.4429 | 6.4096 | 6.4339 | 43069740.0 |
| 2008-05-02 13:00:00 | AAPL | Stock | 6.4336 | 6.4429 | 6.4018 | 6.4325 | 48276508.0 |
| 2008-05-02 13:30:00 | AAPL | Stock | 6.4314 | 6.4554 | 6.4179 | 6.4341 | 41857480.0 |
| 2008-05-02 14:00:00 | AAPL | Stock | 6.4343 | 6.45 | 6.4107 | 6.4236 | 46904256.0 |
| 2008-05-02 14:30:00 | AAPL | Stock | 6.4239 | 6.4339 | 6.4032 | 6.4061 | 43172752.0 |
| 2008-05-02 15:00:00 | AAPL | Stock | 6.4064 | 6.4457 | 6.3986 | 6.4393 | 51738456.0 |
| 2008-05-02 15:30:00 | AAPL | Stock | 6.4396 | 6.4732 | 6.4314 | 6.4643 | 67414200.0 |
| 2008-05-02 16:00:00 | AAPL | Stock | 6.4657 | 6.4706 | 6.4104 | 6.4614 | 7894824.0 |
| 2008-05-02 16:30:00 | AAPL | Stock | 6.4614 | 6.4625 | 6.4557 | 6.4557 | 556220.0 |
| 2008-05-02 17:00:00 | AAPL | Stock | 6.46 | 6.4643 | 6.4571 | 6.4639 | 371840.0 |
| 2008-05-02 17:30:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4614 | 6.4621 | 9724848.0 |
| 2008-05-02 18:00:00 | AAPL | Stock | 6.4614 | 6.4661 | 6.4571 | 6.4632 | 155456.0 |
| 2008-05-02 18:30:00 | AAPL | Stock | 6.4629 | 6.4671 | 6.4543 | 6.4671 | 96124.0 |
| 2008-05-02 19:00:00 | AAPL | Stock | 6.4646 | 6.4675 | 6.4643 | 6.4661 | 146972.0 |
| 2008-05-02 19:30:00 | AAPL | Stock | 6.4643 | 6.4675 | 6.4643 | 6.4671 | 135072.0 |
| 2008-05-02 06:00:00 | MSFT | Stock | 29.35 | 29.35 | 29.28 | 29.28 | 3093.0 |
| 2008-05-02 06:30:00 | MSFT | Stock | 29.22 | 29.22 | 29.16 | 29.16 | 200.0 |
| 2008-05-02 07:00:00 | MSFT | Stock | 29.2 | 29.24 | 29.1 | 29.24 | 900.0 |
| 2008-05-02 07:30:00 | MSFT | Stock | 29.1 | 29.3 | 29.1 | 29.22 | 36831.0 |
| 2008-05-02 08:00:00 | MSFT | Stock | 29.22 | 29.3 | 29.15 | 29.25 | 111008.0 |
| 2008-05-02 08:30:00 | MSFT | Stock | 29.25 | 29.6 | 29.25 | 29.54 | 181429.0 |
| 2008-05-02 09:00:00 | MSFT | Stock | 29.55 | 29.6 | 29.51 | 29.58 | 96138.0 |
| 2008-05-02 09:30:00 | MSFT | Stock | 29.59 | 29.62 | 29.2 | 29.43 | 6847872.0 |
| 2008-05-02 10:00:00 | MSFT | Stock | 29.43 | 29.5 | 29.07 | 29.09 | 6509298.0 |
| 2008-05-02 10:30:00 | MSFT | Stock | 29.09 | 29.4 | 29.08 | 29.36 | 7272566.0 |
| 2008-05-02 11:00:00 | MSFT | Stock | 29.36 | 29.44 | 29.27 | 29.3 | 5278685.0 |
| 2008-05-02 11:30:00 | MSFT | Stock | 29.29 | 29.35 | 29.21 | 29.24 | 2779464.0 |
| 2008-05-02 12:00:00 | MSFT | Stock | 29.25 | 29.25 | 29.138 | 29.195 | 3502400.0 |
| 2008-05-02 12:30:00 | MSFT | Stock | 29.2 | 29.21 | 29.15 | 29.18 | 1840061.0 |
| 2008-05-02 13:00:00 | MSFT | Stock | 29.19 | 29.21 | 29.06 | 29.078 | 2899684.0 |
| 2008-05-02 13:30:00 | MSFT | Stock | 29.08 | 29.19 | 29.03 | 29.13 | 2999699.0 |
| 2008-05-02 14:00:00 | MSFT | Stock | 29.13 | 29.18 | 28.93 | 28.98 | 4446992.0 |
| 2008-05-02 14:30:00 | MSFT | Stock | 28.98 | 29.06 | 28.86 | 28.87 | 5494244.0 |
| 2008-05-02 15:00:00 | MSFT | Stock | 28.87 | 29.08 | 28.86 | 28.985 | 4542621.0 |
| 2008-05-02 15:30:00 | MSFT | Stock | 28.99 | 29.24 | 28.97 | 29.23 | 6775085.0 |
| 2008-05-02 16:00:00 | MSFT | Stock | 29.207 | 29.24 | 29.005 | 29.066 | 2204201.0 |
> showing 50 of 68,162 rows — these rows as CSV