PREVIEW / stock_30min / 2010-04-15
file: by_date/stock_30min/2010/2010-04-15.parquet size: 1.4 MB rows: 74,733 symbols: 3,496
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-04-15 04:00:00 | AAPL | Stock | 8.7454 | 8.7454 | 8.745 | 8.745 | 16800.0 |
| 2010-04-15 04:30:00 | AAPL | Stock | 8.75 | 8.75 | 8.75 | 8.75 | 14000.0 |
| 2010-04-15 05:30:00 | AAPL | Stock | 8.7411 | 8.7411 | 8.7393 | 8.7393 | 16100.0 |
| 2010-04-15 06:00:00 | AAPL | Stock | 8.7393 | 8.7393 | 8.7393 | 8.7393 | 7280.0 |
| 2010-04-15 07:00:00 | AAPL | Stock | 8.75 | 8.7589 | 8.75 | 8.7507 | 60200.0 |
| 2010-04-15 07:30:00 | AAPL | Stock | 8.7536 | 8.7589 | 8.7536 | 8.7571 | 47544.0 |
| 2010-04-15 08:00:00 | AAPL | Stock | 8.7586 | 8.7664 | 8.7536 | 8.7664 | 863968.0 |
| 2010-04-15 08:30:00 | AAPL | Stock | 8.7664 | 8.7682 | 8.7546 | 8.7668 | 980000.0 |
| 2010-04-15 09:00:00 | AAPL | Stock | 8.7679 | 8.7836 | 8.7604 | 8.7804 | 1589896.0 |
| 2010-04-15 09:30:00 | AAPL | Stock | 8.7775 | 8.8107 | 8.7682 | 8.797 | 48659212.0 |
| 2010-04-15 10:00:00 | AAPL | Stock | 8.7971 | 8.8086 | 8.7918 | 8.8039 | 28548940.0 |
| 2010-04-15 10:30:00 | AAPL | Stock | 8.8039 | 8.8229 | 8.8004 | 8.8214 | 28454580.0 |
| 2010-04-15 11:00:00 | AAPL | Stock | 8.8218 | 8.85 | 8.8189 | 8.8304 | 35539756.0 |
| 2010-04-15 11:30:00 | AAPL | Stock | 8.8311 | 8.8414 | 8.8168 | 8.8257 | 32430440.0 |
| 2010-04-15 12:00:00 | AAPL | Stock | 8.8271 | 8.8554 | 8.8214 | 8.8304 | 26456724.0 |
| 2010-04-15 12:30:00 | AAPL | Stock | 8.8318 | 8.8439 | 8.8293 | 8.8439 | 14239456.0 |
| 2010-04-15 13:00:00 | AAPL | Stock | 8.8432 | 8.8536 | 8.8357 | 8.8536 | 13211996.0 |
| 2010-04-15 13:30:00 | AAPL | Stock | 8.8543 | 8.8557 | 8.8464 | 8.8518 | 10925320.0 |
| 2010-04-15 14:00:00 | AAPL | Stock | 8.8521 | 8.8786 | 8.8514 | 8.8729 | 25625824.0 |
| 2010-04-15 14:30:00 | AAPL | Stock | 8.8729 | 8.8832 | 8.8643 | 8.8811 | 18028360.0 |
| 2010-04-15 15:00:00 | AAPL | Stock | 8.8811 | 8.8814 | 8.8661 | 8.8729 | 24251556.0 |
| 2010-04-15 15:30:00 | AAPL | Stock | 8.8729 | 8.8939 | 8.8596 | 8.89 | 51449188.0 |
| 2010-04-15 16:00:00 | AAPL | Stock | 8.89 | 8.8975 | 8.7704 | 8.875 | 8067360.0 |
| 2010-04-15 16:30:00 | AAPL | Stock | 8.8757 | 8.8804 | 8.7698 | 8.8621 | 865396.0 |
| 2010-04-15 17:00:00 | AAPL | Stock | 8.8621 | 8.8679 | 8.8611 | 8.8629 | 307748.0 |
| 2010-04-15 17:30:00 | AAPL | Stock | 8.8629 | 8.8639 | 8.8471 | 8.8518 | 419244.0 |
| 2010-04-15 18:00:00 | AAPL | Stock | 8.85 | 8.89 | 8.85 | 8.855 | 184716.0 |
| 2010-04-15 18:30:00 | AAPL | Stock | 8.8536 | 8.8536 | 8.8475 | 8.85 | 248052.0 |
| 2010-04-15 19:00:00 | AAPL | Stock | 8.85 | 8.85 | 8.8464 | 8.8475 | 120148.0 |
| 2010-04-15 19:30:00 | AAPL | Stock | 8.8475 | 8.8596 | 8.8464 | 8.8536 | 256984.0 |
| 2010-04-15 07:00:00 | MSFT | Stock | 30.68 | 30.68 | 30.68 | 30.68 | 1900.0 |
| 2010-04-15 07:30:00 | MSFT | Stock | 30.68 | 30.75 | 30.68 | 30.75 | 2700.0 |
| 2010-04-15 08:00:00 | MSFT | Stock | 30.76 | 30.96 | 30.76 | 30.92 | 14853.0 |
| 2010-04-15 08:30:00 | MSFT | Stock | 30.92 | 30.95 | 30.86 | 30.9 | 14365.0 |
| 2010-04-15 09:00:00 | MSFT | Stock | 30.9 | 30.95 | 30.81 | 30.81 | 28804.0 |
| 2010-04-15 09:30:00 | MSFT | Stock | 30.82 | 30.87 | 30.71 | 30.792 | 5365719.0 |
| 2010-04-15 10:00:00 | MSFT | Stock | 30.795 | 30.86 | 30.76 | 30.843 | 4641026.0 |
| 2010-04-15 10:30:00 | MSFT | Stock | 30.842 | 30.95 | 30.8 | 30.835 | 4554314.0 |
| 2010-04-15 11:00:00 | MSFT | Stock | 30.84 | 30.92 | 30.82 | 30.88 | 3803649.0 |
| 2010-04-15 11:30:00 | MSFT | Stock | 30.88 | 30.91 | 30.81 | 30.84 | 4029505.0 |
| 2010-04-15 12:00:00 | MSFT | Stock | 30.84 | 30.91 | 30.83 | 30.86 | 3571097.0 |
| 2010-04-15 12:30:00 | MSFT | Stock | 30.85 | 30.89 | 30.84 | 30.885 | 1457223.0 |
| 2010-04-15 13:00:00 | MSFT | Stock | 30.89 | 30.95 | 30.85 | 30.95 | 1947584.0 |
| 2010-04-15 13:30:00 | MSFT | Stock | 30.95 | 30.95 | 30.88 | 30.884 | 2009491.0 |
| 2010-04-15 14:00:00 | MSFT | Stock | 30.88 | 30.89 | 30.85 | 30.85 | 1769005.0 |
| 2010-04-15 14:30:00 | MSFT | Stock | 30.85 | 30.91 | 30.85 | 30.893 | 2316556.0 |
| 2010-04-15 15:00:00 | MSFT | Stock | 30.895 | 30.9 | 30.79 | 30.79 | 3103345.0 |
| 2010-04-15 15:30:00 | MSFT | Stock | 30.79 | 30.9 | 30.75 | 30.87 | 7282872.0 |
| 2010-04-15 16:00:00 | MSFT | Stock | 30.87 | 30.89 | 30.75 | 30.78 | 5521915.0 |
| 2010-04-15 16:30:00 | MSFT | Stock | 30.817 | 30.88 | 30.772 | 30.78 | 844121.0 |
> showing 50 of 74,733 rows — these rows as CSV