PREVIEW / stock_30min / 2007-04-11
file: by_date/stock_30min/2007/2007-04-11.parquet size: 1.0 MB rows: 56,002 symbols: 2,574
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-11 08:00:00 | AAPL | Stock | 3.3711 | 3.3711 | 3.3571 | 3.3575 | 289128.0 |
| 2007-04-11 08:30:00 | AAPL | Stock | 3.3575 | 3.3575 | 3.3514 | 3.3536 | 653044.0 |
| 2007-04-11 09:00:00 | AAPL | Stock | 3.3543 | 3.3593 | 3.3482 | 3.3546 | 6852244.0 |
| 2007-04-11 09:30:00 | AAPL | Stock | 3.3536 | 3.3554 | 3.3321 | 3.3364 | 62444200.0 |
| 2007-04-11 10:00:00 | AAPL | Stock | 3.3364 | 3.3439 | 3.3225 | 3.3317 | 57420860.0 |
| 2007-04-11 10:30:00 | AAPL | Stock | 3.3314 | 3.3339 | 3.305 | 3.3106 | 76956880.0 |
| 2007-04-11 11:00:00 | AAPL | Stock | 3.3104 | 3.3179 | 3.3082 | 3.3143 | 55386520.0 |
| 2007-04-11 11:30:00 | AAPL | Stock | 3.3139 | 3.32 | 3.3125 | 3.3193 | 23307844.0 |
| 2007-04-11 12:00:00 | AAPL | Stock | 3.3193 | 3.3304 | 3.3179 | 3.3196 | 36303288.0 |
| 2007-04-11 12:30:00 | AAPL | Stock | 3.3196 | 3.3236 | 3.3186 | 3.32 | 14436940.0 |
| 2007-04-11 13:00:00 | AAPL | Stock | 3.3204 | 3.3286 | 3.3179 | 3.3214 | 23585072.0 |
| 2007-04-11 13:30:00 | AAPL | Stock | 3.3218 | 3.325 | 3.315 | 3.3157 | 20962116.0 |
| 2007-04-11 14:00:00 | AAPL | Stock | 3.3161 | 3.3161 | 3.3018 | 3.3096 | 47773740.0 |
| 2007-04-11 14:30:00 | AAPL | Stock | 3.3096 | 3.3104 | 3.2975 | 3.3068 | 39921420.0 |
| 2007-04-11 15:00:00 | AAPL | Stock | 3.3064 | 3.3186 | 3.3021 | 3.3128 | 32847388.0 |
| 2007-04-11 15:30:00 | AAPL | Stock | 3.3129 | 3.3186 | 3.3046 | 3.3046 | 39533704.0 |
| 2007-04-11 16:00:00 | AAPL | Stock | 3.3071 | 3.3071 | 3.2929 | 3.2996 | 3638404.0 |
| 2007-04-11 16:30:00 | AAPL | Stock | 3.2982 | 3.3068 | 3.2946 | 3.2986 | 1284808.0 |
| 2007-04-11 17:00:00 | AAPL | Stock | 3.2982 | 3.2982 | 3.2954 | 3.2964 | 373128.0 |
| 2007-04-11 17:30:00 | AAPL | Stock | 3.2964 | 3.2964 | 3.2932 | 3.2932 | 426440.0 |
| 2007-04-11 18:00:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2932 | 3.2943 | 248360.0 |
| 2007-04-11 18:30:00 | AAPL | Stock | 3.2943 | 3.2964 | 3.2943 | 3.2943 | 125412.0 |
| 2007-04-11 19:00:00 | AAPL | Stock | 3.2982 | 3.3029 | 3.2943 | 3.3 | 93128.0 |
| 2007-04-11 19:30:00 | AAPL | Stock | 3.2946 | 3.3 | 3.2946 | 3.3 | 36484.0 |
| 2007-04-11 07:00:00 | MSFT | Stock | 28.33 | 28.33 | 28.33 | 28.33 | 300.0 |
| 2007-04-11 07:30:00 | MSFT | Stock | 28.33 | 28.33 | 28.33 | 28.33 | 200.0 |
| 2007-04-11 08:30:00 | MSFT | Stock | 28.33 | 28.33 | 28.31 | 28.33 | 900.0 |
| 2007-04-11 09:00:00 | MSFT | Stock | 28.33 | 28.37 | 28.25 | 28.3 | 91390.0 |
| 2007-04-11 09:30:00 | MSFT | Stock | 28.3 | 28.55 | 28.28 | 28.52 | 4751496.0 |
| 2007-04-11 10:00:00 | MSFT | Stock | 28.53 | 28.57 | 28.32 | 28.4 | 3258107.0 |
| 2007-04-11 10:30:00 | MSFT | Stock | 28.405 | 28.41 | 28.2 | 28.26 | 3061443.0 |
| 2007-04-11 11:00:00 | MSFT | Stock | 28.25 | 28.27 | 28.2 | 28.23 | 2000761.0 |
| 2007-04-11 11:30:00 | MSFT | Stock | 28.23 | 28.29 | 28.18 | 28.22 | 1763793.0 |
| 2007-04-11 12:00:00 | MSFT | Stock | 28.22 | 28.26 | 28.12 | 28.14 | 2698690.0 |
| 2007-04-11 12:30:00 | MSFT | Stock | 28.13 | 28.19 | 28.1 | 28.19 | 1906036.0 |
| 2007-04-11 13:00:00 | MSFT | Stock | 28.185 | 28.25 | 28.16 | 28.201 | 1771779.0 |
| 2007-04-11 13:30:00 | MSFT | Stock | 28.2 | 28.26 | 28.17 | 28.17 | 1789400.0 |
| 2007-04-11 14:00:00 | MSFT | Stock | 28.18 | 28.18 | 28.0 | 28.01 | 5448071.0 |
| 2007-04-11 14:30:00 | MSFT | Stock | 28.02 | 28.06 | 27.99 | 28.012 | 3895796.0 |
| 2007-04-11 15:00:00 | MSFT | Stock | 28.01 | 28.1 | 27.99 | 28.05 | 3005776.0 |
| 2007-04-11 15:30:00 | MSFT | Stock | 28.05 | 28.16 | 28.0 | 28.09 | 6375588.0 |
| 2007-04-11 16:00:00 | MSFT | Stock | 28.12 | 28.123 | 28.09 | 28.11 | 502973.0 |
| 2007-04-11 16:30:00 | MSFT | Stock | 28.1 | 28.12 | 28.1 | 28.12 | 14761.0 |
| 2007-04-11 17:00:00 | MSFT | Stock | 28.12 | 28.12 | 28.08 | 28.08 | 95900.0 |
| 2007-04-11 17:30:00 | MSFT | Stock | 28.08 | 28.08 | 28.01 | 28.02 | 4200.0 |
| 2007-04-11 18:00:00 | MSFT | Stock | 28.01 | 28.12 | 28.01 | 28.01 | 2670.0 |
| 2007-04-11 18:30:00 | MSFT | Stock | 28.04 | 28.04 | 28.04 | 28.04 | 200.0 |
| 2007-04-11 19:00:00 | MSFT | Stock | 28.02 | 28.03 | 28.01 | 28.03 | 1035.0 |
| 2007-04-11 08:00:00 | NVDA | Stock | 0.5008 | 0.5008 | 0.5008 | 0.5008 | 42000.0 |
| 2007-04-11 09:00:00 | NVDA | Stock | 0.5032 | 0.5032 | 0.5015 | 0.5017 | 62400.0 |
> showing 50 of 56,002 rows — these rows as CSV