PREVIEW / stock_30min / 2009-09-25
file: by_date/stock_30min/2009/2009-09-25.parquet size: 1.3 MB rows: 71,181 symbols: 3,390
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-09-25 06:30:00 | AAPL | Stock | 6.4996 | 6.4996 | 6.4996 | 6.4996 | 2800.0 |
| 2009-09-25 07:00:00 | AAPL | Stock | 6.4661 | 6.4786 | 6.4643 | 6.4786 | 233464.0 |
| 2009-09-25 07:30:00 | AAPL | Stock | 6.4786 | 6.5 | 6.4786 | 6.4932 | 299320.0 |
| 2009-09-25 08:00:00 | AAPL | Stock | 6.4864 | 6.5179 | 6.4857 | 6.5179 | 756168.0 |
| 2009-09-25 08:30:00 | AAPL | Stock | 6.5132 | 6.5132 | 6.475 | 6.4929 | 1855504.0 |
| 2009-09-25 09:00:00 | AAPL | Stock | 6.4929 | 6.5054 | 6.4821 | 6.5 | 2050664.0 |
| 2009-09-25 09:30:00 | AAPL | Stock | 6.5004 | 6.6193 | 6.4907 | 6.5914 | 110969124.0 |
| 2009-09-25 10:00:00 | AAPL | Stock | 6.5907 | 6.625 | 6.5739 | 6.5975 | 50055236.0 |
| 2009-09-25 10:30:00 | AAPL | Stock | 6.5986 | 6.6093 | 6.5718 | 6.5971 | 26312020.0 |
| 2009-09-25 11:00:00 | AAPL | Stock | 6.5972 | 6.6036 | 6.5782 | 6.5861 | 20196008.0 |
| 2009-09-25 11:30:00 | AAPL | Stock | 6.5857 | 6.5875 | 6.5411 | 6.545 | 26581772.0 |
| 2009-09-25 12:00:00 | AAPL | Stock | 6.5446 | 6.5643 | 6.5289 | 6.5394 | 25657772.0 |
| 2009-09-25 12:30:00 | AAPL | Stock | 6.54 | 6.54 | 6.5225 | 6.5327 | 13849584.0 |
| 2009-09-25 13:00:00 | AAPL | Stock | 6.5325 | 6.5379 | 6.5 | 6.5261 | 23175740.0 |
| 2009-09-25 13:30:00 | AAPL | Stock | 6.5261 | 6.5714 | 6.5236 | 6.5707 | 19353768.0 |
| 2009-09-25 14:00:00 | AAPL | Stock | 6.5711 | 6.5864 | 6.5571 | 6.5589 | 25077276.0 |
| 2009-09-25 14:30:00 | AAPL | Stock | 6.5589 | 6.5725 | 6.5468 | 6.5672 | 16960300.0 |
| 2009-09-25 15:00:00 | AAPL | Stock | 6.5693 | 6.5714 | 6.5336 | 6.5419 | 21832776.0 |
| 2009-09-25 15:30:00 | AAPL | Stock | 6.5425 | 6.5471 | 6.48 | 6.5064 | 45510780.0 |
| 2009-09-25 16:00:00 | AAPL | Stock | 6.52 | 6.5608 | 6.5046 | 6.5564 | 9236864.0 |
| 2009-09-25 16:30:00 | AAPL | Stock | 6.5046 | 6.5289 | 6.5046 | 6.5286 | 123816.0 |
| 2009-09-25 17:00:00 | AAPL | Stock | 6.565 | 6.565 | 6.5225 | 6.5271 | 95200.0 |
| 2009-09-25 17:30:00 | AAPL | Stock | 6.5232 | 6.525 | 6.5214 | 6.5214 | 49756.0 |
| 2009-09-25 18:00:00 | AAPL | Stock | 6.5214 | 6.5214 | 6.5125 | 6.5146 | 347704.0 |
| 2009-09-25 18:30:00 | AAPL | Stock | 6.5146 | 6.5146 | 6.5129 | 6.5129 | 25760.0 |
| 2009-09-25 19:00:00 | AAPL | Stock | 6.5125 | 6.5143 | 6.5125 | 6.5143 | 5600.0 |
| 2009-09-25 19:30:00 | AAPL | Stock | 6.5146 | 6.5179 | 6.5129 | 6.5129 | 25200.0 |
| 2009-09-25 07:00:00 | MSFT | Stock | 25.99 | 25.99 | 25.83 | 25.83 | 1300.0 |
| 2009-09-25 07:30:00 | MSFT | Stock | 25.84 | 25.84 | 25.8 | 25.8 | 3200.0 |
| 2009-09-25 08:00:00 | MSFT | Stock | 25.8 | 25.8 | 25.75 | 25.77 | 6200.0 |
| 2009-09-25 08:30:00 | MSFT | Stock | 25.77 | 25.94 | 25.7 | 25.75 | 293342.0 |
| 2009-09-25 09:00:00 | MSFT | Stock | 25.75 | 25.79 | 25.6 | 25.69 | 108479.0 |
| 2009-09-25 09:30:00 | MSFT | Stock | 25.69 | 25.82 | 25.6 | 25.69 | 4772690.0 |
| 2009-09-25 10:00:00 | MSFT | Stock | 25.68 | 25.82 | 25.6 | 25.73 | 4145059.0 |
| 2009-09-25 10:30:00 | MSFT | Stock | 25.73 | 25.74 | 25.6 | 25.633 | 2906034.0 |
| 2009-09-25 11:00:00 | MSFT | Stock | 25.64 | 25.71 | 25.61 | 25.71 | 2525357.0 |
| 2009-09-25 11:30:00 | MSFT | Stock | 25.71 | 25.73 | 25.65 | 25.67 | 2623742.0 |
| 2009-09-25 12:00:00 | MSFT | Stock | 25.67 | 25.7 | 25.56 | 25.61 | 2651984.0 |
| 2009-09-25 12:30:00 | MSFT | Stock | 25.613 | 25.66 | 25.55 | 25.56 | 2048670.0 |
| 2009-09-25 13:00:00 | MSFT | Stock | 25.55 | 25.62 | 25.52 | 25.61 | 3147306.0 |
| 2009-09-25 13:30:00 | MSFT | Stock | 25.6 | 25.67 | 25.57 | 25.65 | 2739114.0 |
| 2009-09-25 14:00:00 | MSFT | Stock | 25.648 | 25.69 | 25.6 | 25.65 | 3724076.0 |
| 2009-09-25 14:30:00 | MSFT | Stock | 25.65 | 25.68 | 25.59 | 25.65 | 2383478.0 |
| 2009-09-25 15:00:00 | MSFT | Stock | 25.66 | 25.68 | 25.6 | 25.641 | 2098993.0 |
| 2009-09-25 15:30:00 | MSFT | Stock | 25.64 | 25.65 | 25.53 | 25.57 | 6365479.0 |
| 2009-09-25 16:00:00 | MSFT | Stock | 25.57 | 25.644 | 25.45 | 25.635 | 2458861.0 |
| 2009-09-25 16:30:00 | MSFT | Stock | 25.645 | 25.7 | 25.49 | 25.5 | 101347.0 |
| 2009-09-25 17:00:00 | MSFT | Stock | 25.94 | 25.94 | 25.49 | 25.5 | 1700.0 |
| 2009-09-25 17:30:00 | MSFT | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 1300.0 |
| 2009-09-25 18:00:00 | MSFT | Stock | 25.5 | 25.55 | 25.5 | 25.5 | 50954.0 |
> showing 50 of 71,181 rows — these rows as CSV