PREVIEW / stock_30min / 2008-07-25
file: by_date/stock_30min/2008/2008-07-25.parquet size: 1.2 MB rows: 67,369 symbols: 3,322
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-25 06:30:00 | AAPL | Stock | 5.6757 | 5.6757 | 5.6757 | 5.6757 | 2800.0 |
| 2008-07-25 07:00:00 | AAPL | Stock | 5.7104 | 5.7104 | 5.6757 | 5.6929 | 25200.0 |
| 2008-07-25 07:30:00 | AAPL | Stock | 5.6825 | 5.6825 | 5.6825 | 5.6825 | 5040.0 |
| 2008-07-25 08:00:00 | AAPL | Stock | 5.7 | 5.7261 | 5.6896 | 5.7236 | 1442420.0 |
| 2008-07-25 08:30:00 | AAPL | Stock | 5.7221 | 5.7375 | 5.7214 | 5.73 | 1505448.0 |
| 2008-07-25 09:00:00 | AAPL | Stock | 5.7304 | 5.7489 | 5.7207 | 5.7279 | 1819832.0 |
| 2008-07-25 09:30:00 | AAPL | Stock | 5.7307 | 5.7414 | 5.6661 | 5.7243 | 93951928.0 |
| 2008-07-25 10:00:00 | AAPL | Stock | 5.7236 | 5.7646 | 5.7039 | 5.7193 | 81565512.0 |
| 2008-07-25 10:30:00 | AAPL | Stock | 5.7193 | 5.7564 | 5.7132 | 5.75 | 45413844.0 |
| 2008-07-25 11:00:00 | AAPL | Stock | 5.7501 | 5.7568 | 5.7343 | 5.745 | 30064216.0 |
| 2008-07-25 11:30:00 | AAPL | Stock | 5.7454 | 5.785 | 5.7454 | 5.7768 | 42304304.0 |
| 2008-07-25 12:00:00 | AAPL | Stock | 5.7764 | 5.7768 | 5.7386 | 5.7568 | 30505636.0 |
| 2008-07-25 12:30:00 | AAPL | Stock | 5.7561 | 5.7754 | 5.7536 | 5.7682 | 18772208.0 |
| 2008-07-25 13:00:00 | AAPL | Stock | 5.7693 | 5.7857 | 5.7443 | 5.7557 | 41398084.0 |
| 2008-07-25 13:30:00 | AAPL | Stock | 5.7557 | 5.77 | 5.7332 | 5.7611 | 28780752.0 |
| 2008-07-25 14:00:00 | AAPL | Stock | 5.76 | 5.8089 | 5.7579 | 5.7893 | 52435852.0 |
| 2008-07-25 14:30:00 | AAPL | Stock | 5.7893 | 5.8214 | 5.7789 | 5.8157 | 39693332.0 |
| 2008-07-25 15:00:00 | AAPL | Stock | 5.8168 | 5.8196 | 5.775 | 5.7882 | 38558968.0 |
| 2008-07-25 15:30:00 | AAPL | Stock | 5.7879 | 5.8071 | 5.7646 | 5.7875 | 55240388.0 |
| 2008-07-25 16:00:00 | AAPL | Stock | 5.7882 | 5.7942 | 5.7546 | 5.7846 | 16312212.0 |
| 2008-07-25 16:30:00 | AAPL | Stock | 5.7846 | 5.79 | 5.7846 | 5.79 | 1502480.0 |
| 2008-07-25 17:00:00 | AAPL | Stock | 5.7857 | 5.7936 | 5.7839 | 5.7936 | 73304.0 |
| 2008-07-25 17:30:00 | AAPL | Stock | 5.7904 | 5.7964 | 5.7904 | 5.7954 | 22092.0 |
| 2008-07-25 18:00:00 | AAPL | Stock | 5.7982 | 5.7982 | 5.79 | 5.79 | 641900.0 |
| 2008-07-25 18:30:00 | AAPL | Stock | 5.7946 | 5.7982 | 5.7946 | 5.7964 | 51100.0 |
| 2008-07-25 19:00:00 | AAPL | Stock | 5.795 | 5.7964 | 5.7946 | 5.7946 | 52500.0 |
| 2008-07-25 19:30:00 | AAPL | Stock | 5.7975 | 5.7975 | 5.7946 | 5.7946 | 14000.0 |
| 2008-07-25 20:00:00 | AAPL | Stock | 5.7514 | 5.7514 | 5.7514 | 5.7514 | 75600.0 |
| 2008-07-25 07:00:00 | MSFT | Stock | 25.44 | 25.44 | 25.44 | 25.44 | 100.0 |
| 2008-07-25 08:00:00 | MSFT | Stock | 25.6 | 25.6 | 25.5 | 25.51 | 7458.0 |
| 2008-07-25 08:30:00 | MSFT | Stock | 25.54 | 25.59 | 25.53 | 25.59 | 20214.0 |
| 2008-07-25 09:00:00 | MSFT | Stock | 25.58 | 25.69 | 25.54 | 25.68 | 40832.0 |
| 2008-07-25 09:30:00 | MSFT | Stock | 25.68 | 25.73 | 25.5 | 25.66 | 6096420.0 |
| 2008-07-25 10:00:00 | MSFT | Stock | 25.64 | 25.9 | 25.622 | 25.77 | 5485856.0 |
| 2008-07-25 10:30:00 | MSFT | Stock | 25.77 | 25.86 | 25.64 | 25.839 | 3209925.0 |
| 2008-07-25 11:00:00 | MSFT | Stock | 25.83 | 25.91 | 25.75 | 25.78 | 3451380.0 |
| 2008-07-25 11:30:00 | MSFT | Stock | 25.78 | 25.93 | 25.779 | 25.91 | 3280707.0 |
| 2008-07-25 12:00:00 | MSFT | Stock | 25.9 | 25.92 | 25.74 | 25.76 | 1970310.0 |
| 2008-07-25 12:30:00 | MSFT | Stock | 25.76 | 25.81 | 25.73 | 25.77 | 1468002.0 |
| 2008-07-25 13:00:00 | MSFT | Stock | 25.77 | 25.82 | 25.69 | 25.79 | 2728363.0 |
| 2008-07-25 13:30:00 | MSFT | Stock | 25.795 | 25.82 | 25.73 | 25.78 | 1903627.0 |
| 2008-07-25 14:00:00 | MSFT | Stock | 25.78 | 25.82 | 25.7 | 25.752 | 2553114.0 |
| 2008-07-25 14:30:00 | MSFT | Stock | 25.75 | 25.93 | 25.74 | 25.912 | 4071968.0 |
| 2008-07-25 15:00:00 | MSFT | Stock | 25.92 | 26.05 | 25.88 | 26.025 | 5431017.0 |
| 2008-07-25 15:30:00 | MSFT | Stock | 26.03 | 26.22 | 25.99 | 26.14 | 10096367.0 |
| 2008-07-25 16:00:00 | MSFT | Stock | 26.14 | 26.184 | 25.833 | 26.139 | 3679792.0 |
| 2008-07-25 16:30:00 | MSFT | Stock | 26.08 | 26.16 | 26.08 | 26.08 | 56677.0 |
| 2008-07-25 17:00:00 | MSFT | Stock | 26.13 | 26.15 | 26.13 | 26.15 | 20050.0 |
| 2008-07-25 17:30:00 | MSFT | Stock | 26.15 | 26.16 | 26.13 | 26.16 | 36900.0 |
| 2008-07-25 18:00:00 | MSFT | Stock | 26.15 | 26.16 | 26.15 | 26.16 | 136785.0 |
> showing 50 of 67,369 rows — these rows as CSV