PREVIEW / stock_30min / 2008-11-11
file: by_date/stock_30min/2008/2008-11-11.parquet size: 1.2 MB rows: 67,386 symbols: 3,284
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-11-11 07:00:00 | AAPL | Stock | 3.3646 | 3.3646 | 3.3643 | 3.3643 | 11592.0 |
| 2008-11-11 07:30:00 | AAPL | Stock | 3.3811 | 3.3818 | 3.3679 | 3.3732 | 47880.0 |
| 2008-11-11 08:00:00 | AAPL | Stock | 3.375 | 3.3818 | 3.3632 | 3.3696 | 686168.0 |
| 2008-11-11 08:30:00 | AAPL | Stock | 3.3679 | 3.3782 | 3.3643 | 3.3714 | 1118404.0 |
| 2008-11-11 09:00:00 | AAPL | Stock | 3.3689 | 3.3929 | 3.3686 | 3.3818 | 1424080.0 |
| 2008-11-11 09:30:00 | AAPL | Stock | 3.3839 | 3.4121 | 3.295 | 3.3079 | 153497344.0 |
| 2008-11-11 10:00:00 | AAPL | Stock | 3.3071 | 3.3439 | 3.2982 | 3.3289 | 102543728.0 |
| 2008-11-11 10:30:00 | AAPL | Stock | 3.3275 | 3.3368 | 3.2979 | 3.3129 | 87883488.0 |
| 2008-11-11 11:00:00 | AAPL | Stock | 3.3125 | 3.3321 | 3.3054 | 3.3171 | 65718100.0 |
| 2008-11-11 11:30:00 | AAPL | Stock | 3.3168 | 3.3318 | 3.3036 | 3.3229 | 52987648.0 |
| 2008-11-11 12:00:00 | AAPL | Stock | 3.3221 | 3.3229 | 3.2982 | 3.3107 | 47809776.0 |
| 2008-11-11 12:30:00 | AAPL | Stock | 3.3111 | 3.3382 | 3.31 | 3.3379 | 46168248.0 |
| 2008-11-11 13:00:00 | AAPL | Stock | 3.3382 | 3.3489 | 3.3096 | 3.3171 | 59718736.0 |
| 2008-11-11 13:30:00 | AAPL | Stock | 3.3171 | 3.3736 | 3.3043 | 3.3671 | 69270376.0 |
| 2008-11-11 14:00:00 | AAPL | Stock | 3.3671 | 3.4361 | 3.3493 | 3.4332 | 122733912.0 |
| 2008-11-11 14:30:00 | AAPL | Stock | 3.4329 | 3.4704 | 3.385 | 3.3868 | 144683728.0 |
| 2008-11-11 15:00:00 | AAPL | Stock | 3.3864 | 3.4575 | 3.3832 | 3.4082 | 109731244.0 |
| 2008-11-11 15:30:00 | AAPL | Stock | 3.4071 | 3.4071 | 3.3511 | 3.3846 | 126054516.0 |
| 2008-11-11 16:00:00 | AAPL | Stock | 3.3846 | 3.3929 | 3.3597 | 3.3857 | 18098836.0 |
| 2008-11-11 16:30:00 | AAPL | Stock | 3.3846 | 3.3907 | 3.3804 | 3.3821 | 227164.0 |
| 2008-11-11 17:00:00 | AAPL | Stock | 3.3864 | 3.3896 | 3.3821 | 3.3857 | 310352.0 |
| 2008-11-11 17:30:00 | AAPL | Stock | 3.3875 | 3.3875 | 3.3821 | 3.3825 | 379988.0 |
| 2008-11-11 18:00:00 | AAPL | Stock | 3.3825 | 3.3875 | 3.3825 | 3.3857 | 180460.0 |
| 2008-11-11 18:30:00 | AAPL | Stock | 3.3846 | 3.3921 | 3.3289 | 3.3921 | 279300.0 |
| 2008-11-11 19:00:00 | AAPL | Stock | 3.3921 | 3.3982 | 3.3886 | 3.3982 | 88620.0 |
| 2008-11-11 19:30:00 | AAPL | Stock | 3.3982 | 3.3986 | 3.3936 | 3.3964 | 90440.0 |
| 2008-11-11 07:00:00 | MSFT | Stock | 21.31 | 21.31 | 21.31 | 21.31 | 100.0 |
| 2008-11-11 07:30:00 | MSFT | Stock | 21.25 | 21.25 | 21.22 | 21.22 | 893.0 |
| 2008-11-11 08:00:00 | MSFT | Stock | 21.16 | 21.2 | 21.16 | 21.18 | 16190.0 |
| 2008-11-11 08:30:00 | MSFT | Stock | 21.18 | 21.22 | 21.15 | 21.2 | 19770.0 |
| 2008-11-11 09:00:00 | MSFT | Stock | 21.18 | 21.32 | 21.15 | 21.26 | 82115.0 |
| 2008-11-11 09:30:00 | MSFT | Stock | 21.28 | 21.3 | 20.87 | 20.89 | 8793796.0 |
| 2008-11-11 10:00:00 | MSFT | Stock | 20.89 | 21.26 | 20.86 | 21.12 | 8049268.0 |
| 2008-11-11 10:30:00 | MSFT | Stock | 21.12 | 21.21 | 20.99 | 21.06 | 4359380.0 |
| 2008-11-11 11:00:00 | MSFT | Stock | 21.06 | 21.09 | 20.97 | 21.0 | 3568042.0 |
| 2008-11-11 11:30:00 | MSFT | Stock | 21.0 | 21.035 | 20.87 | 20.88 | 3390337.0 |
| 2008-11-11 12:00:00 | MSFT | Stock | 20.88 | 20.94 | 20.85 | 20.93 | 3805430.0 |
| 2008-11-11 12:30:00 | MSFT | Stock | 20.93 | 20.98 | 20.84 | 20.92 | 2640532.0 |
| 2008-11-11 13:00:00 | MSFT | Stock | 20.93 | 20.95 | 20.8 | 20.82 | 3677205.0 |
| 2008-11-11 13:30:00 | MSFT | Stock | 20.819 | 21.0 | 20.79 | 20.97 | 5156039.0 |
| 2008-11-11 14:00:00 | MSFT | Stock | 20.97 | 21.25 | 20.9 | 21.21 | 7308073.0 |
| 2008-11-11 14:30:00 | MSFT | Stock | 21.22 | 21.29 | 20.9 | 20.92 | 6728323.0 |
| 2008-11-11 15:00:00 | MSFT | Stock | 20.92 | 21.13 | 20.9 | 20.982 | 5241337.0 |
| 2008-11-11 15:30:00 | MSFT | Stock | 20.98 | 21.19 | 20.8 | 21.19 | 11311661.0 |
| 2008-11-11 16:00:00 | MSFT | Stock | 21.19 | 21.2 | 20.885 | 21.12 | 2440448.0 |
| 2008-11-11 16:30:00 | MSFT | Stock | 21.15 | 21.2 | 20.998 | 21.13 | 25090.0 |
| 2008-11-11 17:00:00 | MSFT | Stock | 21.12 | 21.15 | 21.12 | 21.13 | 8900.0 |
| 2008-11-11 17:30:00 | MSFT | Stock | 21.2 | 21.2 | 21.1 | 21.1 | 5256.0 |
| 2008-11-11 18:00:00 | MSFT | Stock | 21.11 | 21.11 | 21.1 | 21.1 | 7364.0 |
| 2008-11-11 18:30:00 | MSFT | Stock | 21.1 | 21.11 | 21.02 | 21.1 | 2860.0 |
> showing 50 of 67,386 rows — these rows as CSV