PREVIEW / stock_30min / 2005-06-29
file: by_date/stock_30min/2005/2005-06-29.parquet size: 828 KB rows: 45,093 symbols: 2,015
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-29 08:00:00 | AAPL | Stock | 1.3268 | 1.3286 | 1.3268 | 1.3268 | 61656.0 |
| 2005-06-29 08:30:00 | AAPL | Stock | 1.3261 | 1.3321 | 1.3229 | 1.3296 | 595000.0 |
| 2005-06-29 09:00:00 | AAPL | Stock | 1.3296 | 1.3336 | 1.3286 | 1.3293 | 1118320.0 |
| 2005-06-29 09:30:00 | AAPL | Stock | 1.3296 | 1.3318 | 1.2986 | 1.3036 | 78800148.0 |
| 2005-06-29 10:00:00 | AAPL | Stock | 1.3036 | 1.3089 | 1.295 | 1.2982 | 47526332.0 |
| 2005-06-29 10:30:00 | AAPL | Stock | 1.2982 | 1.3018 | 1.2957 | 1.2993 | 50511356.0 |
| 2005-06-29 11:00:00 | AAPL | Stock | 1.2989 | 1.3046 | 1.2971 | 1.3021 | 33277384.0 |
| 2005-06-29 11:30:00 | AAPL | Stock | 1.3021 | 1.3079 | 1.3 | 1.305 | 26692036.0 |
| 2005-06-29 12:00:00 | AAPL | Stock | 1.305 | 1.3061 | 1.3014 | 1.3018 | 18251884.0 |
| 2005-06-29 12:30:00 | AAPL | Stock | 1.3018 | 1.3018 | 1.2989 | 1.3 | 18810764.0 |
| 2005-06-29 13:00:00 | AAPL | Stock | 1.3 | 1.3025 | 1.2982 | 1.2982 | 10264156.0 |
| 2005-06-29 13:30:00 | AAPL | Stock | 1.2982 | 1.2989 | 1.2911 | 1.2929 | 36552124.0 |
| 2005-06-29 14:00:00 | AAPL | Stock | 1.2925 | 1.2982 | 1.2911 | 1.2946 | 23415308.0 |
| 2005-06-29 14:30:00 | AAPL | Stock | 1.2946 | 1.2971 | 1.2929 | 1.2954 | 20164676.0 |
| 2005-06-29 15:00:00 | AAPL | Stock | 1.295 | 1.2954 | 1.2907 | 1.2932 | 28789628.0 |
| 2005-06-29 15:30:00 | AAPL | Stock | 1.2936 | 1.2989 | 1.29 | 1.2989 | 46257904.0 |
| 2005-06-29 16:00:00 | AAPL | Stock | 1.2975 | 1.2989 | 1.2911 | 1.2911 | 1268176.0 |
| 2005-06-29 16:30:00 | AAPL | Stock | 1.2911 | 1.2989 | 1.2911 | 1.2946 | 637868.0 |
| 2005-06-29 17:00:00 | AAPL | Stock | 1.3097 | 1.3097 | 1.2929 | 1.2929 | 5716900.0 |
| 2005-06-29 17:30:00 | AAPL | Stock | 1.2939 | 1.2984 | 1.2914 | 1.2984 | 529200.0 |
| 2005-06-29 18:00:00 | AAPL | Stock | 1.2964 | 1.2982 | 1.2946 | 1.2946 | 70000.0 |
| 2005-06-29 07:00:00 | MSFT | Stock | 25.17 | 25.17 | 25.17 | 25.17 | 100.0 |
| 2005-06-29 07:30:00 | MSFT | Stock | 25.16 | 25.18 | 25.16 | 25.18 | 10645.0 |
| 2005-06-29 08:00:00 | MSFT | Stock | 25.18 | 25.25 | 25.1 | 25.17 | 151560.0 |
| 2005-06-29 08:30:00 | MSFT | Stock | 25.2 | 25.23 | 25.17 | 25.18 | 48564.0 |
| 2005-06-29 09:00:00 | MSFT | Stock | 25.2 | 25.29 | 25.17 | 25.22 | 1359787.0 |
| 2005-06-29 09:30:00 | MSFT | Stock | 25.22 | 25.32 | 25.19 | 25.22 | 11507623.0 |
| 2005-06-29 10:00:00 | MSFT | Stock | 25.22 | 25.25 | 25.13 | 25.18 | 6309480.0 |
| 2005-06-29 10:30:00 | MSFT | Stock | 25.18 | 25.26 | 25.18 | 25.23 | 4123872.0 |
| 2005-06-29 11:00:00 | MSFT | Stock | 25.23 | 25.24 | 25.153 | 25.19 | 2967998.0 |
| 2005-06-29 11:30:00 | MSFT | Stock | 25.2 | 25.23 | 25.145 | 25.2 | 2874943.0 |
| 2005-06-29 12:00:00 | MSFT | Stock | 25.2 | 25.21 | 25.17 | 25.19 | 2803657.0 |
| 2005-06-29 12:30:00 | MSFT | Stock | 25.19 | 25.22 | 25.18 | 25.19 | 2410372.0 |
| 2005-06-29 13:00:00 | MSFT | Stock | 25.19 | 25.19 | 25.15 | 25.15 | 1938439.0 |
| 2005-06-29 13:30:00 | MSFT | Stock | 25.15 | 25.2 | 25.15 | 25.19 | 3592503.0 |
| 2005-06-29 14:00:00 | MSFT | Stock | 25.2 | 25.24 | 25.17 | 25.19 | 3332429.0 |
| 2005-06-29 14:30:00 | MSFT | Stock | 25.19 | 25.23 | 25.13 | 25.17 | 3242164.0 |
| 2005-06-29 15:00:00 | MSFT | Stock | 25.17 | 25.2 | 25.1 | 25.1 | 3144671.0 |
| 2005-06-29 15:30:00 | MSFT | Stock | 25.1 | 25.14 | 25.0 | 25.1 | 4383168.0 |
| 2005-06-29 16:00:00 | MSFT | Stock | 25.09 | 25.31 | 25.05 | 25.09 | 275205.0 |
| 2005-06-29 16:30:00 | MSFT | Stock | 25.08 | 25.09 | 25.07 | 25.07 | 340944.0 |
| 2005-06-29 17:00:00 | MSFT | Stock | 25.09 | 25.09 | 25.09 | 25.09 | 300.0 |
| 2005-06-29 17:30:00 | MSFT | Stock | 25.09 | 25.11 | 25.09 | 25.1 | 11500.0 |
| 2005-06-29 18:00:00 | MSFT | Stock | 25.1 | 25.12 | 25.1 | 25.1 | 5420.0 |
| 2005-06-29 08:30:00 | NVDA | Stock | 0.2257 | 0.2257 | 0.2257 | 0.2257 | 36000.0 |
| 2005-06-29 09:00:00 | NVDA | Stock | 0.2257 | 0.2257 | 0.2249 | 0.2249 | 60000.0 |
| 2005-06-29 09:30:00 | NVDA | Stock | 0.2254 | 0.2258 | 0.2225 | 0.2227 | 37125240.0 |
| 2005-06-29 10:00:00 | NVDA | Stock | 0.2228 | 0.2233 | 0.2214 | 0.222 | 29221200.0 |
| 2005-06-29 10:30:00 | NVDA | Stock | 0.222 | 0.2237 | 0.2218 | 0.2236 | 47305080.0 |
| 2005-06-29 11:00:00 | NVDA | Stock | 0.2236 | 0.2237 | 0.2229 | 0.2232 | 17885160.0 |
> showing 50 of 45,093 rows — these rows as CSV