PREVIEW / stock_30min / 2009-09-24
file: by_date/stock_30min/2009/2009-09-24.parquet size: 1.4 MB rows: 74,719 symbols: 3,394
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-24 04:00:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 8400.0 |
| 2009-09-24 05:00:00 | AAPL | Stock | 6.6786 | 6.6879 | 6.6786 | 6.6879 | 5600.0 |
| 2009-09-24 07:00:00 | AAPL | Stock | 6.6675 | 6.6736 | 6.6675 | 6.6711 | 60200.0 |
| 2009-09-24 07:30:00 | AAPL | Stock | 6.6679 | 6.6804 | 6.6679 | 6.6804 | 114800.0 |
| 2009-09-24 08:00:00 | AAPL | Stock | 6.6911 | 6.6964 | 6.6679 | 6.69 | 1575000.0 |
| 2009-09-24 08:30:00 | AAPL | Stock | 6.6893 | 6.7139 | 6.6882 | 6.7029 | 2053996.0 |
| 2009-09-24 09:00:00 | AAPL | Stock | 6.7036 | 6.7143 | 6.6836 | 6.6861 | 1881348.0 |
| 2009-09-24 09:30:00 | AAPL | Stock | 6.6889 | 6.7036 | 6.6193 | 6.6429 | 103646172.0 |
| 2009-09-24 10:00:00 | AAPL | Stock | 6.6321 | 6.6446 | 6.5539 | 6.5939 | 86514848.0 |
| 2009-09-24 10:30:00 | AAPL | Stock | 6.5932 | 6.5953 | 6.5304 | 6.5786 | 65211132.0 |
| 2009-09-24 11:00:00 | AAPL | Stock | 6.5792 | 6.5993 | 6.5679 | 6.5863 | 21962248.0 |
| 2009-09-24 11:30:00 | AAPL | Stock | 6.5857 | 6.5929 | 6.555 | 6.5571 | 21577892.0 |
| 2009-09-24 12:00:00 | AAPL | Stock | 6.5575 | 6.5779 | 6.5536 | 6.5614 | 21588504.0 |
| 2009-09-24 12:30:00 | AAPL | Stock | 6.5614 | 6.5664 | 6.5371 | 6.543 | 20461532.0 |
| 2009-09-24 13:00:00 | AAPL | Stock | 6.5425 | 6.5664 | 6.5425 | 6.5555 | 18860044.0 |
| 2009-09-24 13:30:00 | AAPL | Stock | 6.5545 | 6.5546 | 6.5286 | 6.5461 | 25817848.0 |
| 2009-09-24 14:00:00 | AAPL | Stock | 6.5446 | 6.5496 | 6.5275 | 6.5379 | 23699004.0 |
| 2009-09-24 14:30:00 | AAPL | Stock | 6.5379 | 6.5589 | 6.5361 | 6.5561 | 27972672.0 |
| 2009-09-24 15:00:00 | AAPL | Stock | 6.5567 | 6.5782 | 6.5482 | 6.5671 | 35769020.0 |
| 2009-09-24 15:30:00 | AAPL | Stock | 6.5657 | 6.5786 | 6.5554 | 6.565 | 43704472.0 |
| 2009-09-24 16:00:00 | AAPL | Stock | 6.565 | 6.588 | 6.4546 | 6.5061 | 19021352.0 |
| 2009-09-24 16:30:00 | AAPL | Stock | 6.505 | 6.565 | 6.4889 | 6.4943 | 1335068.0 |
| 2009-09-24 17:00:00 | AAPL | Stock | 6.4946 | 6.5043 | 6.4646 | 6.4743 | 2364880.0 |
| 2009-09-24 17:30:00 | AAPL | Stock | 6.475 | 6.565 | 6.4671 | 6.4882 | 1062152.0 |
| 2009-09-24 18:00:00 | AAPL | Stock | 6.4875 | 6.565 | 6.4821 | 6.4925 | 390068.0 |
| 2009-09-24 18:30:00 | AAPL | Stock | 6.4929 | 6.4936 | 6.4875 | 6.4875 | 237496.0 |
| 2009-09-24 19:00:00 | AAPL | Stock | 6.4875 | 6.4911 | 6.4857 | 6.4882 | 113736.0 |
| 2009-09-24 19:30:00 | AAPL | Stock | 6.4882 | 6.4911 | 6.4821 | 6.4857 | 297724.0 |
| 2009-09-24 08:00:00 | MSFT | Stock | 25.71 | 25.75 | 25.69 | 25.75 | 3535.0 |
| 2009-09-24 08:30:00 | MSFT | Stock | 25.81 | 25.98 | 25.81 | 25.96 | 16375.0 |
| 2009-09-24 09:00:00 | MSFT | Stock | 25.91 | 25.97 | 25.82 | 25.91 | 81105.0 |
| 2009-09-24 09:30:00 | MSFT | Stock | 25.92 | 26.11 | 25.87 | 26.06 | 5174735.0 |
| 2009-09-24 10:00:00 | MSFT | Stock | 26.09 | 26.1 | 25.78 | 25.809 | 6205196.0 |
| 2009-09-24 10:30:00 | MSFT | Stock | 25.8 | 25.82 | 25.67 | 25.77 | 5308871.0 |
| 2009-09-24 11:00:00 | MSFT | Stock | 25.77 | 25.87 | 25.75 | 25.77 | 2731226.0 |
| 2009-09-24 11:30:00 | MSFT | Stock | 25.77 | 25.83 | 25.66 | 25.74 | 4144189.0 |
| 2009-09-24 12:00:00 | MSFT | Stock | 25.73 | 25.79 | 25.7 | 25.765 | 2119425.0 |
| 2009-09-24 12:30:00 | MSFT | Stock | 25.77 | 25.79 | 25.68 | 25.72 | 1958971.0 |
| 2009-09-24 13:00:00 | MSFT | Stock | 25.72 | 25.83 | 25.71 | 25.81 | 2352035.0 |
| 2009-09-24 13:30:00 | MSFT | Stock | 25.81 | 25.81 | 25.68 | 25.762 | 3238557.0 |
| 2009-09-24 14:00:00 | MSFT | Stock | 25.76 | 25.84 | 25.75 | 25.81 | 3207050.0 |
| 2009-09-24 14:30:00 | MSFT | Stock | 25.803 | 25.94 | 25.8 | 25.891 | 3346658.0 |
| 2009-09-24 15:00:00 | MSFT | Stock | 25.9 | 25.95 | 25.83 | 25.9 | 4554125.0 |
| 2009-09-24 15:30:00 | MSFT | Stock | 25.9 | 26.02 | 25.87 | 25.93 | 7424131.0 |
| 2009-09-24 16:00:00 | MSFT | Stock | 25.94 | 25.96 | 25.66 | 25.78 | 3126926.0 |
| 2009-09-24 16:30:00 | MSFT | Stock | 25.8 | 25.963 | 25.75 | 25.75 | 128656.0 |
| 2009-09-24 17:00:00 | MSFT | Stock | 25.8 | 25.966 | 25.73 | 25.73 | 11559.0 |
| 2009-09-24 17:30:00 | MSFT | Stock | 25.73 | 25.76 | 25.7 | 25.7 | 13799.0 |
| 2009-09-24 18:00:00 | MSFT | Stock | 25.94 | 25.94 | 25.72 | 25.73 | 29846.0 |
| 2009-09-24 18:30:00 | MSFT | Stock | 25.73 | 25.73 | 25.73 | 25.73 | 2100.0 |
> showing 50 of 74,719 rows — these rows as CSV