PREVIEW / stock_30min / 2010-06-10
file: by_date/stock_30min/2010/2010-06-10.parquet size: 1.3 MB rows: 72,582 symbols: 3,460
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-06-10 04:30:00 | AAPL | Stock | 8.7746 | 8.7746 | 8.7746 | 8.7746 | 2800.0 |
| 2010-06-10 05:00:00 | AAPL | Stock | 8.8114 | 8.8114 | 8.7979 | 8.8018 | 25200.0 |
| 2010-06-10 05:30:00 | AAPL | Stock | 8.7911 | 8.8018 | 8.7911 | 8.8018 | 8400.0 |
| 2010-06-10 06:00:00 | AAPL | Stock | 8.7857 | 8.7857 | 8.7857 | 8.7857 | 42000.0 |
| 2010-06-10 07:00:00 | AAPL | Stock | 8.7857 | 8.7929 | 8.7407 | 8.7821 | 220052.0 |
| 2010-06-10 07:30:00 | AAPL | Stock | 8.7814 | 8.7857 | 8.6929 | 8.7179 | 710388.0 |
| 2010-06-10 08:00:00 | AAPL | Stock | 8.7143 | 8.7511 | 8.7064 | 8.75 | 2326296.0 |
| 2010-06-10 08:30:00 | AAPL | Stock | 8.75 | 8.7655 | 8.7036 | 8.7221 | 2137576.0 |
| 2010-06-10 09:00:00 | AAPL | Stock | 8.7189 | 8.7679 | 8.7189 | 8.7379 | 3575432.0 |
| 2010-06-10 09:30:00 | AAPL | Stock | 8.7382 | 8.7857 | 8.65 | 8.7546 | 127044316.0 |
| 2010-06-10 10:00:00 | AAPL | Stock | 8.7539 | 8.8161 | 8.75 | 8.7804 | 90915748.0 |
| 2010-06-10 10:30:00 | AAPL | Stock | 8.78 | 8.85 | 8.7796 | 8.8246 | 62081152.0 |
| 2010-06-10 11:00:00 | AAPL | Stock | 8.8229 | 8.8511 | 8.8164 | 8.8279 | 42504728.0 |
| 2010-06-10 11:30:00 | AAPL | Stock | 8.8271 | 8.8346 | 8.7789 | 8.8075 | 37283764.0 |
| 2010-06-10 12:00:00 | AAPL | Stock | 8.808 | 8.8179 | 8.775 | 8.8145 | 34189736.0 |
| 2010-06-10 12:30:00 | AAPL | Stock | 8.815 | 8.8232 | 8.7429 | 8.7839 | 39167828.0 |
| 2010-06-10 13:00:00 | AAPL | Stock | 8.7854 | 8.8304 | 8.7632 | 8.825 | 33289760.0 |
| 2010-06-10 13:30:00 | AAPL | Stock | 8.8254 | 8.8386 | 8.8121 | 8.8236 | 28350476.0 |
| 2010-06-10 14:00:00 | AAPL | Stock | 8.8229 | 8.8529 | 8.7961 | 8.8375 | 27674780.0 |
| 2010-06-10 14:30:00 | AAPL | Stock | 8.8375 | 8.9236 | 8.8375 | 8.9111 | 68294324.0 |
| 2010-06-10 15:00:00 | AAPL | Stock | 8.9111 | 8.9593 | 8.895 | 8.9343 | 65679992.0 |
| 2010-06-10 15:30:00 | AAPL | Stock | 8.9343 | 8.9636 | 8.9182 | 8.955 | 82407696.0 |
| 2010-06-10 16:00:00 | AAPL | Stock | 8.955 | 8.9593 | 8.9457 | 8.9529 | 18907196.0 |
| 2010-06-10 16:30:00 | AAPL | Stock | 8.9518 | 8.9643 | 8.9332 | 8.9625 | 895608.0 |
| 2010-06-10 17:00:00 | AAPL | Stock | 8.9625 | 8.9632 | 8.9486 | 8.9545 | 283080.0 |
| 2010-06-10 17:30:00 | AAPL | Stock | 8.9589 | 8.9618 | 8.9536 | 8.9557 | 240156.0 |
| 2010-06-10 18:00:00 | AAPL | Stock | 8.9557 | 8.9589 | 8.9468 | 8.9568 | 165508.0 |
| 2010-06-10 18:30:00 | AAPL | Stock | 8.9539 | 8.9571 | 8.9536 | 8.9571 | 102088.0 |
| 2010-06-10 19:00:00 | AAPL | Stock | 8.96 | 8.9643 | 8.9523 | 8.9571 | 354788.0 |
| 2010-06-10 19:30:00 | AAPL | Stock | 8.9571 | 8.9643 | 8.9571 | 8.9618 | 406308.0 |
| 2010-06-10 07:00:00 | MSFT | Stock | 25.22 | 25.22 | 25.22 | 25.22 | 200.0 |
| 2010-06-10 07:30:00 | MSFT | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 300.0 |
| 2010-06-10 08:00:00 | MSFT | Stock | 24.98 | 25.02 | 24.95 | 25.0 | 199300.0 |
| 2010-06-10 08:30:00 | MSFT | Stock | 24.99 | 25.01 | 24.96 | 25.0 | 287257.0 |
| 2010-06-10 09:00:00 | MSFT | Stock | 25.01 | 25.14 | 25.01 | 25.13 | 197161.0 |
| 2010-06-10 09:30:00 | MSFT | Stock | 25.13 | 25.15 | 24.97 | 25.065 | 7635772.0 |
| 2010-06-10 10:00:00 | MSFT | Stock | 25.068 | 25.13 | 25.02 | 25.08 | 5934335.0 |
| 2010-06-10 10:30:00 | MSFT | Stock | 25.07 | 25.12 | 25.03 | 25.035 | 3873470.0 |
| 2010-06-10 11:00:00 | MSFT | Stock | 25.04 | 25.045 | 24.99 | 25.03 | 2604657.0 |
| 2010-06-10 11:30:00 | MSFT | Stock | 25.025 | 25.03 | 24.91 | 25.01 | 4454237.0 |
| 2010-06-10 12:00:00 | MSFT | Stock | 25.01 | 25.08 | 24.95 | 24.995 | 3861482.0 |
| 2010-06-10 12:30:00 | MSFT | Stock | 24.995 | 25.0 | 24.82 | 24.855 | 3658281.0 |
| 2010-06-10 13:00:00 | MSFT | Stock | 24.86 | 24.87 | 24.78 | 24.845 | 2909508.0 |
| 2010-06-10 13:30:00 | MSFT | Stock | 24.85 | 24.96 | 24.842 | 24.93 | 2717696.0 |
| 2010-06-10 14:00:00 | MSFT | Stock | 24.94 | 24.99 | 24.85 | 24.95 | 1884293.0 |
| 2010-06-10 14:30:00 | MSFT | Stock | 24.95 | 25.05 | 24.92 | 25.032 | 4518974.0 |
| 2010-06-10 15:00:00 | MSFT | Stock | 25.04 | 25.1 | 24.98 | 25.032 | 9646600.0 |
| 2010-06-10 15:30:00 | MSFT | Stock | 25.035 | 25.08 | 24.89 | 25.0 | 18246195.0 |
| 2010-06-10 16:00:00 | MSFT | Stock | 25.0 | 25.02 | 24.825 | 24.95 | 4566797.0 |
| 2010-06-10 16:30:00 | MSFT | Stock | 24.93 | 25.045 | 24.92 | 24.92 | 40530.0 |
> showing 50 of 72,582 rows — these rows as CSV