PREVIEW / stock_30min / 2010-11-10
file: by_date/stock_30min/2010/2010-11-10.parquet size: 1.4 MB rows: 75,063 symbols: 3,510
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-10 05:00:00 | AAPL | Stock | 11.3018 | 11.3368 | 11.3018 | 11.3368 | 16800.0 |
| 2010-11-10 05:30:00 | AAPL | Stock | 11.3036 | 11.3036 | 11.3036 | 11.3036 | 2800.0 |
| 2010-11-10 06:00:00 | AAPL | Stock | 11.3025 | 11.3189 | 11.3025 | 11.3054 | 61600.0 |
| 2010-11-10 06:30:00 | AAPL | Stock | 11.3054 | 11.3189 | 11.3054 | 11.3114 | 25116.0 |
| 2010-11-10 07:00:00 | AAPL | Stock | 11.3054 | 11.3425 | 11.3025 | 11.3025 | 113540.0 |
| 2010-11-10 07:30:00 | AAPL | Stock | 11.3182 | 11.3182 | 11.2793 | 11.2993 | 154000.0 |
| 2010-11-10 08:00:00 | AAPL | Stock | 11.2857 | 11.3111 | 11.2786 | 11.3089 | 1173704.0 |
| 2010-11-10 08:30:00 | AAPL | Stock | 11.3132 | 11.3304 | 11.2979 | 11.3057 | 1703604.0 |
| 2010-11-10 09:00:00 | AAPL | Stock | 11.3104 | 11.3311 | 11.3071 | 11.3096 | 697536.0 |
| 2010-11-10 09:30:00 | AAPL | Stock | 11.31 | 11.3389 | 11.2193 | 11.2586 | 72500400.0 |
| 2010-11-10 10:00:00 | AAPL | Stock | 11.2571 | 11.2589 | 11.1982 | 11.2343 | 46698428.0 |
| 2010-11-10 10:30:00 | AAPL | Stock | 11.235 | 11.2826 | 11.2325 | 11.2821 | 27808424.0 |
| 2010-11-10 11:00:00 | AAPL | Stock | 11.2811 | 11.3282 | 11.2804 | 11.3261 | 29498280.0 |
| 2010-11-10 11:30:00 | AAPL | Stock | 11.3261 | 11.3561 | 11.3125 | 11.3493 | 24188976.0 |
| 2010-11-10 12:00:00 | AAPL | Stock | 11.3493 | 11.3568 | 11.3232 | 11.3339 | 14907088.0 |
| 2010-11-10 12:30:00 | AAPL | Stock | 11.3343 | 11.3529 | 11.3261 | 11.3404 | 11496996.0 |
| 2010-11-10 13:00:00 | AAPL | Stock | 11.3404 | 11.3579 | 11.3139 | 11.3496 | 24779244.0 |
| 2010-11-10 13:30:00 | AAPL | Stock | 11.3496 | 11.3564 | 11.33 | 11.3436 | 16646168.0 |
| 2010-11-10 14:00:00 | AAPL | Stock | 11.3425 | 11.3846 | 11.3425 | 11.375 | 30765784.0 |
| 2010-11-10 14:30:00 | AAPL | Stock | 11.375 | 11.3779 | 11.3575 | 11.3668 | 14345016.0 |
| 2010-11-10 15:00:00 | AAPL | Stock | 11.3668 | 11.3714 | 11.3393 | 11.3639 | 20797224.0 |
| 2010-11-10 15:30:00 | AAPL | Stock | 11.3636 | 11.3732 | 11.3443 | 11.3604 | 28069076.0 |
| 2010-11-10 16:00:00 | AAPL | Stock | 11.3625 | 11.3625 | 11.2886 | 11.3357 | 6983564.0 |
| 2010-11-10 16:30:00 | AAPL | Stock | 11.3382 | 11.3582 | 11.3097 | 11.3232 | 769048.0 |
| 2010-11-10 17:00:00 | AAPL | Stock | 11.3225 | 11.3225 | 11.2518 | 11.2536 | 1682744.0 |
| 2010-11-10 17:30:00 | AAPL | Stock | 11.255 | 11.2693 | 11.2411 | 11.2679 | 1362088.0 |
| 2010-11-10 18:00:00 | AAPL | Stock | 11.2679 | 11.3582 | 11.2618 | 11.2779 | 456904.0 |
| 2010-11-10 18:30:00 | AAPL | Stock | 11.2775 | 11.2946 | 11.275 | 11.2946 | 368844.0 |
| 2010-11-10 19:00:00 | AAPL | Stock | 11.2996 | 11.3032 | 11.2807 | 11.2857 | 247968.0 |
| 2010-11-10 19:30:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2543 | 11.2625 | 1052436.0 |
| 2010-11-10 06:00:00 | MSFT | Stock | 26.95 | 26.95 | 26.95 | 26.95 | 300.0 |
| 2010-11-10 07:00:00 | MSFT | Stock | 26.94 | 26.95 | 26.94 | 26.95 | 1400.0 |
| 2010-11-10 07:30:00 | MSFT | Stock | 26.95 | 26.95 | 26.95 | 26.95 | 1400.0 |
| 2010-11-10 08:00:00 | MSFT | Stock | 26.99 | 26.99 | 26.95 | 26.97 | 5818.0 |
| 2010-11-10 08:30:00 | MSFT | Stock | 26.96 | 27.03 | 26.96 | 27.02 | 10940.0 |
| 2010-11-10 09:00:00 | MSFT | Stock | 27.02 | 27.03 | 26.98 | 27.0 | 78095.0 |
| 2010-11-10 09:30:00 | MSFT | Stock | 27.0 | 27.05 | 26.92 | 26.96 | 7514459.0 |
| 2010-11-10 10:00:00 | MSFT | Stock | 26.95 | 26.98 | 26.84 | 26.862 | 7098648.0 |
| 2010-11-10 10:30:00 | MSFT | Stock | 26.86 | 26.98 | 26.81 | 26.95 | 4979365.0 |
| 2010-11-10 11:00:00 | MSFT | Stock | 26.945 | 26.97 | 26.85 | 26.925 | 2777292.0 |
| 2010-11-10 11:30:00 | MSFT | Stock | 26.92 | 27.0 | 26.91 | 26.98 | 2551186.0 |
| 2010-11-10 12:00:00 | MSFT | Stock | 26.975 | 26.995 | 26.958 | 26.98 | 1691070.0 |
| 2010-11-10 12:30:00 | MSFT | Stock | 26.97 | 26.98 | 26.91 | 26.95 | 1915363.0 |
| 2010-11-10 13:00:00 | MSFT | Stock | 26.942 | 27.05 | 26.92 | 27.04 | 3820528.0 |
| 2010-11-10 13:30:00 | MSFT | Stock | 27.04 | 27.08 | 26.95 | 26.956 | 2888524.0 |
| 2010-11-10 14:00:00 | MSFT | Stock | 26.955 | 27.02 | 26.95 | 27.0 | 3548877.0 |
| 2010-11-10 14:30:00 | MSFT | Stock | 26.99 | 27.002 | 26.95 | 26.975 | 1427427.0 |
| 2010-11-10 15:00:00 | MSFT | Stock | 26.975 | 26.99 | 26.93 | 26.932 | 2482162.0 |
| 2010-11-10 15:30:00 | MSFT | Stock | 26.94 | 26.99 | 26.93 | 26.96 | 4298676.0 |
| 2010-11-10 16:00:00 | MSFT | Stock | 26.94 | 26.984 | 26.76 | 26.79 | 2105587.0 |
> showing 50 of 75,063 rows — these rows as CSV