PREVIEW / stock_30min / 2008-07-28
file: by_date/stock_30min/2008/2008-07-28.parquet size: 1.2 MB rows: 67,330 symbols: 3,296
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-07-28 07:00:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 2800.0 |
| 2008-07-28 07:30:00 | AAPL | Stock | 5.7982 | 5.8393 | 5.7982 | 5.8232 | 207480.0 |
| 2008-07-28 08:00:00 | AAPL | Stock | 5.8232 | 5.8304 | 5.8021 | 5.8232 | 988596.0 |
| 2008-07-28 08:30:00 | AAPL | Stock | 5.8214 | 5.8232 | 5.8143 | 5.8171 | 1166200.0 |
| 2008-07-28 09:00:00 | AAPL | Stock | 5.8179 | 5.8179 | 5.7857 | 5.8 | 815780.0 |
| 2008-07-28 09:30:00 | AAPL | Stock | 5.7979 | 5.8025 | 5.7257 | 5.7411 | 71849876.0 |
| 2008-07-28 10:00:00 | AAPL | Stock | 5.7414 | 5.7496 | 5.6886 | 5.7257 | 64410780.0 |
| 2008-07-28 10:30:00 | AAPL | Stock | 5.725 | 5.7286 | 5.6814 | 5.6939 | 50035188.0 |
| 2008-07-28 11:00:00 | AAPL | Stock | 5.6932 | 5.7014 | 5.6489 | 5.6525 | 58594816.0 |
| 2008-07-28 11:30:00 | AAPL | Stock | 5.6539 | 5.6543 | 5.6014 | 5.6239 | 69202728.0 |
| 2008-07-28 12:00:00 | AAPL | Stock | 5.6236 | 5.6246 | 5.5925 | 5.5959 | 41047132.0 |
| 2008-07-28 12:30:00 | AAPL | Stock | 5.5957 | 5.6171 | 5.5407 | 5.5511 | 54841332.0 |
| 2008-07-28 13:00:00 | AAPL | Stock | 5.5511 | 5.6068 | 5.5436 | 5.5732 | 48717284.0 |
| 2008-07-28 13:30:00 | AAPL | Stock | 5.5732 | 5.6157 | 5.5671 | 5.6093 | 47456864.0 |
| 2008-07-28 14:00:00 | AAPL | Stock | 5.6082 | 5.6129 | 5.5521 | 5.5529 | 42712404.0 |
| 2008-07-28 14:30:00 | AAPL | Stock | 5.5536 | 5.5911 | 5.5507 | 5.5579 | 50263388.0 |
| 2008-07-28 15:00:00 | AAPL | Stock | 5.5582 | 5.5668 | 5.5375 | 5.5586 | 49063560.0 |
| 2008-07-28 15:30:00 | AAPL | Stock | 5.5593 | 5.5596 | 5.5007 | 5.5286 | 95586484.0 |
| 2008-07-28 16:00:00 | AAPL | Stock | 5.5261 | 5.7901 | 5.5143 | 5.5232 | 17025176.0 |
| 2008-07-28 16:30:00 | AAPL | Stock | 5.5236 | 5.5236 | 5.5143 | 5.5211 | 228256.0 |
| 2008-07-28 17:00:00 | AAPL | Stock | 5.5182 | 5.5211 | 5.5179 | 5.5179 | 480228.0 |
| 2008-07-28 17:30:00 | AAPL | Stock | 5.5146 | 5.5179 | 5.5046 | 5.5089 | 164808.0 |
| 2008-07-28 18:00:00 | AAPL | Stock | 5.5089 | 5.5193 | 5.5071 | 5.5193 | 156436.0 |
| 2008-07-28 18:30:00 | AAPL | Stock | 5.5196 | 5.5214 | 5.5143 | 5.5214 | 38248.0 |
| 2008-07-28 19:00:00 | AAPL | Stock | 5.515 | 5.5236 | 5.5143 | 5.5196 | 98700.0 |
| 2008-07-28 19:30:00 | AAPL | Stock | 5.5211 | 5.5282 | 5.5196 | 5.5282 | 105700.0 |
| 2008-07-28 08:00:00 | MSFT | Stock | 26.1 | 26.15 | 26.1 | 26.15 | 900.0 |
| 2008-07-28 08:30:00 | MSFT | Stock | 26.1 | 26.14 | 26.1 | 26.14 | 500.0 |
| 2008-07-28 09:00:00 | MSFT | Stock | 26.13 | 26.14 | 25.93 | 26.06 | 39206.0 |
| 2008-07-28 09:30:00 | MSFT | Stock | 26.06 | 26.13 | 25.85 | 25.85 | 4747778.0 |
| 2008-07-28 10:00:00 | MSFT | Stock | 25.85 | 26.05 | 25.84 | 26.02 | 3199612.0 |
| 2008-07-28 10:30:00 | MSFT | Stock | 26.01 | 26.09 | 25.942 | 26.0 | 2493217.0 |
| 2008-07-28 11:00:00 | MSFT | Stock | 26.0 | 26.01 | 25.79 | 25.79 | 2497561.0 |
| 2008-07-28 11:30:00 | MSFT | Stock | 25.79 | 25.86 | 25.68 | 25.791 | 4731098.0 |
| 2008-07-28 12:00:00 | MSFT | Stock | 25.79 | 25.85 | 25.74 | 25.788 | 3657077.0 |
| 2008-07-28 12:30:00 | MSFT | Stock | 25.785 | 25.82 | 25.58 | 25.62 | 3536406.0 |
| 2008-07-28 13:00:00 | MSFT | Stock | 25.62 | 25.68 | 25.56 | 25.66 | 2758039.0 |
| 2008-07-28 13:30:00 | MSFT | Stock | 25.66 | 25.68 | 25.57 | 25.63 | 3071469.0 |
| 2008-07-28 14:00:00 | MSFT | Stock | 25.635 | 25.65 | 25.5 | 25.51 | 4077083.0 |
| 2008-07-28 14:30:00 | MSFT | Stock | 25.515 | 25.61 | 25.5 | 25.51 | 4202391.0 |
| 2008-07-28 15:00:00 | MSFT | Stock | 25.51 | 25.611 | 25.48 | 25.52 | 5528364.0 |
| 2008-07-28 15:30:00 | MSFT | Stock | 25.53 | 25.572 | 25.34 | 25.5 | 9659987.0 |
| 2008-07-28 16:00:00 | MSFT | Stock | 25.5 | 25.686 | 25.47 | 25.538 | 3467835.0 |
| 2008-07-28 16:30:00 | MSFT | Stock | 25.53 | 25.54 | 25.49 | 25.49 | 325399.0 |
| 2008-07-28 17:00:00 | MSFT | Stock | 25.5 | 25.5 | 25.48 | 25.49 | 8252.0 |
| 2008-07-28 17:30:00 | MSFT | Stock | 25.46 | 25.5 | 25.46 | 25.5 | 1400.0 |
| 2008-07-28 18:00:00 | MSFT | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 13300.0 |
| 2008-07-28 18:30:00 | MSFT | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 400.0 |
| 2008-07-28 19:00:00 | MSFT | Stock | 25.5 | 25.5 | 25.48 | 25.48 | 430.0 |
| 2008-07-28 19:30:00 | MSFT | Stock | 25.5 | 25.5 | 25.48 | 25.48 | 2600.0 |
> showing 50 of 67,330 rows — these rows as CSV