PREVIEW / stock_30min / 2010-12-21
file: by_date/stock_30min/2010/2010-12-21.parquet size: 1.4 MB rows: 76,269 symbols: 3,546
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-21 04:00:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 2800.0 |
| 2010-12-21 06:00:00 | AAPL | Stock | 11.5139 | 11.5139 | 11.5139 | 11.5139 | 2800.0 |
| 2010-12-21 07:00:00 | AAPL | Stock | 11.5243 | 11.5589 | 11.5243 | 11.5589 | 155400.0 |
| 2010-12-21 07:30:00 | AAPL | Stock | 11.555 | 11.5639 | 11.5482 | 11.5632 | 283864.0 |
| 2010-12-21 08:00:00 | AAPL | Stock | 11.5575 | 11.5589 | 11.5357 | 11.5546 | 1576456.0 |
| 2010-12-21 08:30:00 | AAPL | Stock | 11.5554 | 11.5568 | 11.5261 | 11.5339 | 1481928.0 |
| 2010-12-21 09:00:00 | AAPL | Stock | 11.5336 | 11.5429 | 11.5257 | 11.5357 | 814576.0 |
| 2010-12-21 09:30:00 | AAPL | Stock | 11.5361 | 11.5671 | 11.5018 | 11.5289 | 50675240.0 |
| 2010-12-21 10:00:00 | AAPL | Stock | 11.5304 | 11.5714 | 11.5286 | 11.5643 | 25338936.0 |
| 2010-12-21 10:30:00 | AAPL | Stock | 11.5661 | 11.5804 | 11.5579 | 11.5639 | 21223076.0 |
| 2010-12-21 11:00:00 | AAPL | Stock | 11.5654 | 11.5854 | 11.5504 | 11.5818 | 15672748.0 |
| 2010-12-21 11:30:00 | AAPL | Stock | 11.5811 | 11.5846 | 11.5596 | 11.5632 | 11311608.0 |
| 2010-12-21 12:00:00 | AAPL | Stock | 11.563 | 11.5725 | 11.5589 | 11.5696 | 8867376.0 |
| 2010-12-21 12:30:00 | AAPL | Stock | 11.5679 | 11.5828 | 11.5639 | 11.5796 | 10261216.0 |
| 2010-12-21 13:00:00 | AAPL | Stock | 11.5796 | 11.5796 | 11.5618 | 11.5693 | 9150428.0 |
| 2010-12-21 13:30:00 | AAPL | Stock | 11.5696 | 11.5768 | 11.5661 | 11.575 | 6889008.0 |
| 2010-12-21 14:00:00 | AAPL | Stock | 11.5736 | 11.58 | 11.5679 | 11.5704 | 7402024.0 |
| 2010-12-21 14:30:00 | AAPL | Stock | 11.57 | 11.5746 | 11.5625 | 11.5675 | 7665420.0 |
| 2010-12-21 15:00:00 | AAPL | Stock | 11.5679 | 11.5707 | 11.5536 | 11.5684 | 16890244.0 |
| 2010-12-21 15:30:00 | AAPL | Stock | 11.5682 | 11.5825 | 11.5671 | 11.5789 | 32004504.0 |
| 2010-12-21 16:00:00 | AAPL | Stock | 11.5787 | 11.5793 | 11.5469 | 11.5725 | 6912360.0 |
| 2010-12-21 16:30:00 | AAPL | Stock | 11.5725 | 11.5764 | 11.5628 | 11.5718 | 1296316.0 |
| 2010-12-21 17:00:00 | AAPL | Stock | 11.5714 | 11.575 | 11.5679 | 11.575 | 328720.0 |
| 2010-12-21 17:30:00 | AAPL | Stock | 11.5714 | 11.575 | 11.5714 | 11.575 | 105980.0 |
| 2010-12-21 18:00:00 | AAPL | Stock | 11.5729 | 11.5786 | 11.5714 | 11.5732 | 90356.0 |
| 2010-12-21 18:30:00 | AAPL | Stock | 11.5746 | 11.5782 | 11.5714 | 11.5782 | 141624.0 |
| 2010-12-21 19:00:00 | AAPL | Stock | 11.5796 | 11.5796 | 11.5761 | 11.5761 | 30800.0 |
| 2010-12-21 19:30:00 | AAPL | Stock | 11.5761 | 11.5804 | 11.575 | 11.5771 | 218680.0 |
| 2010-12-21 07:00:00 | MSFT | Stock | 27.99 | 27.99 | 27.9 | 27.9 | 4000.0 |
| 2010-12-21 08:00:00 | MSFT | Stock | 27.9 | 27.95 | 27.9 | 27.95 | 6200.0 |
| 2010-12-21 08:30:00 | MSFT | Stock | 27.95 | 27.98 | 27.93 | 27.96 | 7032.0 |
| 2010-12-21 09:00:00 | MSFT | Stock | 27.96 | 27.96 | 27.82 | 27.83 | 59662.0 |
| 2010-12-21 09:30:00 | MSFT | Stock | 27.83 | 27.95 | 27.76 | 27.92 | 4237511.0 |
| 2010-12-21 10:00:00 | MSFT | Stock | 27.915 | 28.0 | 27.87 | 27.998 | 3100221.0 |
| 2010-12-21 10:30:00 | MSFT | Stock | 27.994 | 28.06 | 27.97 | 28.06 | 3802794.0 |
| 2010-12-21 11:00:00 | MSFT | Stock | 28.05 | 28.07 | 28.01 | 28.025 | 1600850.0 |
| 2010-12-21 11:30:00 | MSFT | Stock | 28.028 | 28.03 | 27.95 | 27.958 | 1976736.0 |
| 2010-12-21 12:00:00 | MSFT | Stock | 27.95 | 28.0 | 27.95 | 27.97 | 951624.0 |
| 2010-12-21 12:30:00 | MSFT | Stock | 27.972 | 27.99 | 27.95 | 27.975 | 1139016.0 |
| 2010-12-21 13:00:00 | MSFT | Stock | 27.98 | 28.0 | 27.91 | 27.99 | 1975504.0 |
| 2010-12-21 13:30:00 | MSFT | Stock | 27.99 | 28.08 | 27.97 | 28.08 | 3699088.0 |
| 2010-12-21 14:00:00 | MSFT | Stock | 28.08 | 28.085 | 28.02 | 28.024 | 1856789.0 |
| 2010-12-21 14:30:00 | MSFT | Stock | 28.022 | 28.03 | 27.97 | 28.025 | 1469560.0 |
| 2010-12-21 15:00:00 | MSFT | Stock | 28.02 | 28.1 | 28.015 | 28.088 | 3270379.0 |
| 2010-12-21 15:30:00 | MSFT | Stock | 28.085 | 28.14 | 28.065 | 28.07 | 5706885.0 |
| 2010-12-21 16:00:00 | MSFT | Stock | 28.07 | 28.15 | 27.924 | 28.08 | 1947974.0 |
| 2010-12-21 16:30:00 | MSFT | Stock | 28.14 | 28.14 | 28.006 | 28.1 | 111963.0 |
| 2010-12-21 17:00:00 | MSFT | Stock | 28.1 | 28.24 | 28.1 | 28.24 | 39115.0 |
| 2010-12-21 17:30:00 | MSFT | Stock | 28.23 | 28.24 | 28.2 | 28.22 | 10407.0 |
| 2010-12-21 18:00:00 | MSFT | Stock | 28.22 | 28.26 | 28.07 | 28.22 | 20830.0 |
> showing 50 of 76,269 rows — these rows as CSV