PREVIEW / stock_30min / 2006-07-14
file: by_date/stock_30min/2006/2006-07-14.parquet size: 920 KB rows: 50,091 symbols: 2,304
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-14 07:30:00 | AAPL | Stock | 1.8643 | 1.8643 | 1.8643 | 1.8643 | 2800.0 |
| 2006-07-14 08:00:00 | AAPL | Stock | 1.8668 | 1.875 | 1.8654 | 1.8736 | 347200.0 |
| 2006-07-14 08:30:00 | AAPL | Stock | 1.8721 | 1.8796 | 1.8679 | 1.8796 | 582512.0 |
| 2006-07-14 09:00:00 | AAPL | Stock | 1.8786 | 1.8836 | 1.8757 | 1.8761 | 1434496.0 |
| 2006-07-14 09:30:00 | AAPL | Stock | 1.875 | 1.8889 | 1.8221 | 1.8364 | 154666568.0 |
| 2006-07-14 10:00:00 | AAPL | Stock | 1.8368 | 1.8443 | 1.825 | 1.8336 | 113444464.0 |
| 2006-07-14 10:30:00 | AAPL | Stock | 1.8339 | 1.8446 | 1.8275 | 1.8296 | 78725444.0 |
| 2006-07-14 11:00:00 | AAPL | Stock | 1.8296 | 1.8339 | 1.8175 | 1.8175 | 65407216.0 |
| 2006-07-14 11:30:00 | AAPL | Stock | 1.8175 | 1.8239 | 1.8057 | 1.8175 | 73096044.0 |
| 2006-07-14 12:00:00 | AAPL | Stock | 1.8175 | 1.8243 | 1.8111 | 1.8179 | 58249912.0 |
| 2006-07-14 12:30:00 | AAPL | Stock | 1.8171 | 1.835 | 1.8171 | 1.825 | 46110148.0 |
| 2006-07-14 13:00:00 | AAPL | Stock | 1.825 | 1.8257 | 1.8136 | 1.8207 | 44094260.0 |
| 2006-07-14 13:30:00 | AAPL | Stock | 1.8211 | 1.8257 | 1.8089 | 1.8096 | 41933164.0 |
| 2006-07-14 14:00:00 | AAPL | Stock | 1.8089 | 1.812 | 1.8014 | 1.8096 | 61766264.0 |
| 2006-07-14 14:30:00 | AAPL | Stock | 1.81 | 1.8132 | 1.7982 | 1.8043 | 49993748.0 |
| 2006-07-14 15:00:00 | AAPL | Stock | 1.8043 | 1.8171 | 1.8032 | 1.8071 | 80254692.0 |
| 2006-07-14 15:30:00 | AAPL | Stock | 1.8071 | 1.8125 | 1.7914 | 1.805 | 111378736.0 |
| 2006-07-14 16:00:00 | AAPL | Stock | 1.8054 | 1.8241 | 1.8 | 1.8029 | 2566620.0 |
| 2006-07-14 16:30:00 | AAPL | Stock | 1.8007 | 1.8018 | 1.7982 | 1.7982 | 661304.0 |
| 2006-07-14 17:00:00 | AAPL | Stock | 1.7982 | 1.7993 | 1.7979 | 1.7982 | 241752.0 |
| 2006-07-14 17:30:00 | AAPL | Stock | 1.7982 | 1.8021 | 1.7982 | 1.8007 | 269108.0 |
| 2006-07-14 18:00:00 | AAPL | Stock | 1.8007 | 1.8053 | 1.8 | 1.8 | 211344.0 |
| 2006-07-14 07:00:00 | MSFT | Stock | 22.28 | 22.28 | 22.28 | 22.28 | 800.0 |
| 2006-07-14 07:30:00 | MSFT | Stock | 22.26 | 22.26 | 22.26 | 22.26 | 1000.0 |
| 2006-07-14 08:00:00 | MSFT | Stock | 22.27 | 22.33 | 22.27 | 22.28 | 21820.0 |
| 2006-07-14 08:30:00 | MSFT | Stock | 22.3 | 22.3 | 22.25 | 22.3 | 40884.0 |
| 2006-07-14 09:00:00 | MSFT | Stock | 22.32 | 22.34 | 22.24 | 22.29 | 128617.0 |
| 2006-07-14 09:30:00 | MSFT | Stock | 22.28 | 22.37 | 22.23 | 22.31 | 6396520.0 |
| 2006-07-14 10:00:00 | MSFT | Stock | 22.32 | 22.44 | 22.28 | 22.37 | 5168108.0 |
| 2006-07-14 10:30:00 | MSFT | Stock | 22.36 | 22.37 | 22.27 | 22.31 | 3723198.0 |
| 2006-07-14 11:00:00 | MSFT | Stock | 22.31 | 22.48 | 22.26 | 22.41 | 6219141.0 |
| 2006-07-14 11:30:00 | MSFT | Stock | 22.41 | 22.47 | 22.36 | 22.462 | 4697724.0 |
| 2006-07-14 12:00:00 | MSFT | Stock | 22.47 | 22.5 | 22.4 | 22.45 | 3844336.0 |
| 2006-07-14 12:30:00 | MSFT | Stock | 22.45 | 22.55 | 22.45 | 22.47 | 3459157.0 |
| 2006-07-14 13:00:00 | MSFT | Stock | 22.47 | 22.47 | 22.37 | 22.41 | 6097070.0 |
| 2006-07-14 13:30:00 | MSFT | Stock | 22.41 | 22.5 | 22.31 | 22.35 | 5521696.0 |
| 2006-07-14 14:00:00 | MSFT | Stock | 22.35 | 22.38 | 22.29 | 22.33 | 4001879.0 |
| 2006-07-14 14:30:00 | MSFT | Stock | 22.33 | 22.35 | 22.27 | 22.34 | 3788816.0 |
| 2006-07-14 15:00:00 | MSFT | Stock | 22.33 | 22.4 | 22.29 | 22.33 | 4934292.0 |
| 2006-07-14 15:30:00 | MSFT | Stock | 22.33 | 22.41 | 22.29 | 22.3 | 7224619.0 |
| 2006-07-14 16:00:00 | MSFT | Stock | 22.28 | 22.32 | 22.25 | 22.27 | 483162.0 |
| 2006-07-14 16:30:00 | MSFT | Stock | 22.3 | 22.31 | 22.3 | 22.31 | 600.0 |
| 2006-07-14 17:00:00 | MSFT | Stock | 22.31 | 22.31 | 22.31 | 22.31 | 1400.0 |
| 2006-07-14 17:30:00 | MSFT | Stock | 22.31 | 22.31 | 22.31 | 22.31 | 500.0 |
| 2006-07-14 18:00:00 | MSFT | Stock | 22.29 | 22.3 | 22.29 | 22.3 | 6011.0 |
| 2006-07-14 08:00:00 | NVDA | Stock | 0.298 | 0.2982 | 0.2977 | 0.298 | 132000.0 |
| 2006-07-14 08:30:00 | NVDA | Stock | 0.2978 | 0.3 | 0.2978 | 0.3 | 115260.0 |
| 2006-07-14 09:00:00 | NVDA | Stock | 0.3 | 0.3025 | 0.2977 | 0.3025 | 1941480.0 |
| 2006-07-14 09:30:00 | NVDA | Stock | 0.3015 | 0.3032 | 0.2958 | 0.2977 | 70290060.0 |
| 2006-07-14 10:00:00 | NVDA | Stock | 0.2978 | 0.3007 | 0.2973 | 0.2987 | 45560940.0 |
> showing 50 of 50,091 rows — these rows as CSV