PREVIEW / stock_30min / 2010-11-08
file: by_date/stock_30min/2010/2010-11-08.parquet size: 1.4 MB rows: 75,690 symbols: 3,514
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-08 04:00:00 | AAPL | Stock | 11.3364 | 11.3364 | 11.2857 | 11.2857 | 27860.0 |
| 2010-11-08 04:30:00 | AAPL | Stock | 11.2857 | 11.2946 | 11.2839 | 11.2839 | 32368.0 |
| 2010-11-08 05:00:00 | AAPL | Stock | 11.2946 | 11.2946 | 11.2946 | 11.2946 | 2800.0 |
| 2010-11-08 05:30:00 | AAPL | Stock | 11.2857 | 11.3132 | 11.2857 | 11.2929 | 25200.0 |
| 2010-11-08 06:00:00 | AAPL | Stock | 11.2868 | 11.2868 | 11.2868 | 11.2868 | 5600.0 |
| 2010-11-08 07:00:00 | AAPL | Stock | 11.29 | 11.3175 | 11.29 | 11.3054 | 61572.0 |
| 2010-11-08 07:30:00 | AAPL | Stock | 11.3043 | 11.3179 | 11.3018 | 11.3179 | 68040.0 |
| 2010-11-08 08:00:00 | AAPL | Stock | 11.3121 | 11.3325 | 11.3075 | 11.3286 | 849240.0 |
| 2010-11-08 08:30:00 | AAPL | Stock | 11.3286 | 11.355 | 11.3254 | 11.3504 | 982492.0 |
| 2010-11-08 09:00:00 | AAPL | Stock | 11.35 | 11.3554 | 11.3364 | 11.3364 | 925120.0 |
| 2010-11-08 09:30:00 | AAPL | Stock | 11.3382 | 11.4014 | 11.3129 | 11.3582 | 61115488.0 |
| 2010-11-08 10:00:00 | AAPL | Stock | 11.3575 | 11.4107 | 11.3421 | 11.3964 | 40746188.0 |
| 2010-11-08 10:30:00 | AAPL | Stock | 11.3968 | 11.415 | 11.3857 | 11.3932 | 21988484.0 |
| 2010-11-08 11:00:00 | AAPL | Stock | 11.3929 | 11.3992 | 11.3779 | 11.3914 | 17304336.0 |
| 2010-11-08 11:30:00 | AAPL | Stock | 11.391 | 11.3982 | 11.3839 | 11.39 | 8002260.0 |
| 2010-11-08 12:00:00 | AAPL | Stock | 11.3907 | 11.4018 | 11.3821 | 11.3982 | 9189096.0 |
| 2010-11-08 12:30:00 | AAPL | Stock | 11.3975 | 11.3996 | 11.3864 | 11.3939 | 7528332.0 |
| 2010-11-08 13:00:00 | AAPL | Stock | 11.3916 | 11.4018 | 11.3879 | 11.3925 | 8281028.0 |
| 2010-11-08 13:30:00 | AAPL | Stock | 11.3929 | 11.4 | 11.3821 | 11.3876 | 8864184.0 |
| 2010-11-08 14:00:00 | AAPL | Stock | 11.3868 | 11.3954 | 11.385 | 11.3886 | 7573384.0 |
| 2010-11-08 14:30:00 | AAPL | Stock | 11.3893 | 11.3914 | 11.3768 | 11.3786 | 9718352.0 |
| 2010-11-08 15:00:00 | AAPL | Stock | 11.38 | 11.3961 | 11.3764 | 11.3925 | 12159896.0 |
| 2010-11-08 15:30:00 | AAPL | Stock | 11.3918 | 11.4089 | 11.3696 | 11.3857 | 41045144.0 |
| 2010-11-08 16:00:00 | AAPL | Stock | 11.3861 | 11.3936 | 11.3442 | 11.3821 | 16653560.0 |
| 2010-11-08 16:30:00 | AAPL | Stock | 11.3804 | 11.3807 | 11.3261 | 11.3761 | 100632.0 |
| 2010-11-08 17:00:00 | AAPL | Stock | 11.3861 | 11.3861 | 11.3743 | 11.3789 | 504952.0 |
| 2010-11-08 17:30:00 | AAPL | Stock | 11.3743 | 11.375 | 11.3679 | 11.3696 | 114772.0 |
| 2010-11-08 18:00:00 | AAPL | Stock | 11.3682 | 11.3793 | 11.3679 | 11.3679 | 300608.0 |
| 2010-11-08 18:30:00 | AAPL | Stock | 11.3679 | 11.3679 | 11.3629 | 11.3629 | 240632.0 |
| 2010-11-08 19:00:00 | AAPL | Stock | 11.3643 | 11.3643 | 11.3429 | 11.3486 | 603624.0 |
| 2010-11-08 19:30:00 | AAPL | Stock | 11.3493 | 11.3571 | 11.3464 | 11.3571 | 533232.0 |
| 2010-11-08 04:00:00 | MSFT | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 300.0 |
| 2010-11-08 05:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.89 | 26.89 | 400.0 |
| 2010-11-08 06:30:00 | MSFT | Stock | 26.69 | 26.69 | 26.65 | 26.69 | 10100.0 |
| 2010-11-08 07:00:00 | MSFT | Stock | 26.69 | 26.78 | 26.69 | 26.74 | 3800.0 |
| 2010-11-08 07:30:00 | MSFT | Stock | 26.72 | 26.78 | 26.72 | 26.74 | 8477.0 |
| 2010-11-08 08:00:00 | MSFT | Stock | 26.75 | 26.75 | 26.68 | 26.69 | 25380.0 |
| 2010-11-08 08:30:00 | MSFT | Stock | 26.69 | 26.74 | 26.67 | 26.73 | 62678.0 |
| 2010-11-08 09:00:00 | MSFT | Stock | 26.72 | 26.78 | 26.67 | 26.68 | 177994.0 |
| 2010-11-08 09:30:00 | MSFT | Stock | 26.71 | 26.83 | 26.58 | 26.79 | 6949871.0 |
| 2010-11-08 10:00:00 | MSFT | Stock | 26.79 | 26.97 | 26.77 | 26.91 | 5909000.0 |
| 2010-11-08 10:30:00 | MSFT | Stock | 26.911 | 26.98 | 26.89 | 26.95 | 3545333.0 |
| 2010-11-08 11:00:00 | MSFT | Stock | 26.945 | 27.05 | 26.9 | 27.01 | 4245197.0 |
| 2010-11-08 11:30:00 | MSFT | Stock | 27.007 | 27.04 | 27.0 | 27.02 | 1907360.0 |
| 2010-11-08 12:00:00 | MSFT | Stock | 27.029 | 27.03 | 26.9 | 26.935 | 2723299.0 |
| 2010-11-08 12:30:00 | MSFT | Stock | 26.935 | 26.96 | 26.9 | 26.9 | 2137801.0 |
| 2010-11-08 13:00:00 | MSFT | Stock | 26.9 | 26.94 | 26.87 | 26.898 | 2655043.0 |
| 2010-11-08 13:30:00 | MSFT | Stock | 26.9 | 26.92 | 26.89 | 26.9 | 2579594.0 |
| 2010-11-08 14:00:00 | MSFT | Stock | 26.89 | 26.93 | 26.85 | 26.852 | 3994844.0 |
| 2010-11-08 14:30:00 | MSFT | Stock | 26.86 | 26.89 | 26.81 | 26.85 | 2893790.0 |
> showing 50 of 75,690 rows — these rows as CSV