PREVIEW / stock_30min / 2009-08-21
file: by_date/stock_30min/2009/2009-08-21.parquet size: 1.3 MB rows: 71,453 symbols: 3,383
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-21 07:00:00 | AAPL | Stock | 5.9643 | 5.9821 | 5.9643 | 5.9821 | 431508.0 |
| 2009-08-21 07:30:00 | AAPL | Stock | 5.9718 | 5.9736 | 5.9643 | 5.9714 | 458584.0 |
| 2009-08-21 08:00:00 | AAPL | Stock | 5.9643 | 5.9732 | 5.9625 | 5.9729 | 359744.0 |
| 2009-08-21 08:30:00 | AAPL | Stock | 5.9746 | 5.975 | 5.9679 | 5.9714 | 428540.0 |
| 2009-08-21 09:00:00 | AAPL | Stock | 5.9714 | 5.9964 | 5.9682 | 5.99 | 2800644.0 |
| 2009-08-21 09:30:00 | AAPL | Stock | 5.99 | 5.9932 | 5.9571 | 5.975 | 82051704.0 |
| 2009-08-21 10:00:00 | AAPL | Stock | 5.975 | 6.0279 | 5.975 | 6.0136 | 58838612.0 |
| 2009-08-21 10:30:00 | AAPL | Stock | 6.0136 | 6.0286 | 6.0096 | 6.0139 | 29361780.0 |
| 2009-08-21 11:00:00 | AAPL | Stock | 6.0136 | 6.0286 | 6.0118 | 6.0225 | 21793156.0 |
| 2009-08-21 11:30:00 | AAPL | Stock | 6.0225 | 6.0296 | 6.0175 | 6.0196 | 17778124.0 |
| 2009-08-21 12:00:00 | AAPL | Stock | 6.019 | 6.0264 | 6.0164 | 6.0257 | 16634632.0 |
| 2009-08-21 12:30:00 | AAPL | Stock | 6.0257 | 6.0261 | 6.0136 | 6.0164 | 11328884.0 |
| 2009-08-21 13:00:00 | AAPL | Stock | 6.0161 | 6.0211 | 6.0136 | 6.0154 | 11798836.0 |
| 2009-08-21 13:30:00 | AAPL | Stock | 6.0157 | 6.0179 | 6.0061 | 6.0075 | 16794484.0 |
| 2009-08-21 14:00:00 | AAPL | Stock | 6.0075 | 6.0271 | 6.0057 | 6.0254 | 19695844.0 |
| 2009-08-21 14:30:00 | AAPL | Stock | 6.025 | 6.0279 | 6.0204 | 6.0264 | 16732436.0 |
| 2009-08-21 15:00:00 | AAPL | Stock | 6.0264 | 6.0393 | 6.0246 | 6.0364 | 31598756.0 |
| 2009-08-21 15:30:00 | AAPL | Stock | 6.0364 | 6.0489 | 6.0304 | 6.0429 | 51420740.0 |
| 2009-08-21 16:00:00 | AAPL | Stock | 6.0421 | 6.0475 | 6.0156 | 6.0446 | 17810352.0 |
| 2009-08-21 16:30:00 | AAPL | Stock | 6.0446 | 6.065 | 6.0446 | 6.0571 | 1085476.0 |
| 2009-08-21 17:00:00 | AAPL | Stock | 6.0539 | 6.0539 | 6.0468 | 6.05 | 226156.0 |
| 2009-08-21 17:30:00 | AAPL | Stock | 6.0446 | 6.0493 | 6.0432 | 6.0479 | 82404.0 |
| 2009-08-21 18:00:00 | AAPL | Stock | 6.0464 | 6.0464 | 6.0436 | 6.0439 | 103656.0 |
| 2009-08-21 18:30:00 | AAPL | Stock | 6.0432 | 6.0446 | 6.0364 | 6.0375 | 301616.0 |
| 2009-08-21 19:00:00 | AAPL | Stock | 6.0368 | 6.0375 | 6.0357 | 6.0357 | 178500.0 |
| 2009-08-21 19:30:00 | AAPL | Stock | 6.0357 | 6.0361 | 6.0357 | 6.0357 | 198240.0 |
| 2009-08-21 05:30:00 | MSFT | Stock | 23.74 | 23.74 | 23.74 | 23.74 | 100.0 |
| 2009-08-21 07:00:00 | MSFT | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 1800.0 |
| 2009-08-21 07:30:00 | MSFT | Stock | 23.74 | 23.74 | 23.74 | 23.74 | 300.0 |
| 2009-08-21 08:00:00 | MSFT | Stock | 23.7 | 23.78 | 23.7 | 23.77 | 8334.0 |
| 2009-08-21 08:30:00 | MSFT | Stock | 23.74 | 23.77 | 23.74 | 23.75 | 4000.0 |
| 2009-08-21 09:00:00 | MSFT | Stock | 23.76 | 23.93 | 23.72 | 23.93 | 301687.0 |
| 2009-08-21 09:30:00 | MSFT | Stock | 23.93 | 23.93 | 23.77 | 23.84 | 5358535.0 |
| 2009-08-21 10:00:00 | MSFT | Stock | 23.85 | 24.1 | 23.848 | 24.0 | 7072283.0 |
| 2009-08-21 10:30:00 | MSFT | Stock | 24.0 | 24.05 | 23.98 | 24.01 | 2939744.0 |
| 2009-08-21 11:00:00 | MSFT | Stock | 24.01 | 24.04 | 24.0 | 24.02 | 2004498.0 |
| 2009-08-21 11:30:00 | MSFT | Stock | 24.03 | 24.05 | 24.0 | 24.01 | 1749799.0 |
| 2009-08-21 12:00:00 | MSFT | Stock | 24.01 | 24.03 | 23.98 | 24.0 | 1930361.0 |
| 2009-08-21 12:30:00 | MSFT | Stock | 23.993 | 24.06 | 23.96 | 24.03 | 2343189.0 |
| 2009-08-21 13:00:00 | MSFT | Stock | 24.03 | 24.09 | 24.025 | 24.071 | 1692602.0 |
| 2009-08-21 13:30:00 | MSFT | Stock | 24.07 | 24.13 | 24.07 | 24.13 | 2482157.0 |
| 2009-08-21 14:00:00 | MSFT | Stock | 24.125 | 24.19 | 24.11 | 24.17 | 4200780.0 |
| 2009-08-21 14:30:00 | MSFT | Stock | 24.17 | 24.29 | 24.17 | 24.28 | 4873414.0 |
| 2009-08-21 15:00:00 | MSFT | Stock | 24.29 | 24.42 | 24.26 | 24.389 | 8903189.0 |
| 2009-08-21 15:30:00 | MSFT | Stock | 24.39 | 24.42 | 24.36 | 24.41 | 11490639.0 |
| 2009-08-21 16:00:00 | MSFT | Stock | 24.4 | 24.45 | 24.11 | 24.38 | 3164242.0 |
| 2009-08-21 16:30:00 | MSFT | Stock | 24.38 | 24.41 | 24.38 | 24.41 | 8776.0 |
| 2009-08-21 17:00:00 | MSFT | Stock | 24.39 | 24.39 | 24.37 | 24.37 | 1520.0 |
| 2009-08-21 17:30:00 | MSFT | Stock | 24.37 | 24.37 | 24.36 | 24.37 | 10963.0 |
| 2009-08-21 18:00:00 | MSFT | Stock | 24.41 | 24.41 | 24.38 | 24.4 | 5551.0 |
> showing 50 of 71,453 rows — these rows as CSV