PREVIEW / stock_5min / 2008-11-28
file: by_date/stock_5min/2008/2008-11-28.parquet size: 2.4 MB rows: 169,598 symbols: 3,234
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-28 04:40:00 | AAPL | Stock | 3.3843 | 3.3843 | 3.3839 | 3.3839 | 15400.0 |
| 2008-11-28 07:30:00 | AAPL | Stock | 3.3661 | 3.3661 | 3.3661 | 3.3661 | 18816.0 |
| 2008-11-28 07:35:00 | AAPL | Stock | 3.3661 | 3.3661 | 3.3661 | 3.3661 | 2800.0 |
| 2008-11-28 07:40:00 | AAPL | Stock | 3.3664 | 3.3664 | 3.3664 | 3.3664 | 2800.0 |
| 2008-11-28 07:45:00 | AAPL | Stock | 3.3664 | 3.3664 | 3.3664 | 3.3664 | 14000.0 |
| 2008-11-28 07:50:00 | AAPL | Stock | 3.3664 | 3.3664 | 3.3664 | 3.3664 | 14000.0 |
| 2008-11-28 08:00:00 | AAPL | Stock | 3.3843 | 3.3843 | 3.375 | 3.375 | 52080.0 |
| 2008-11-28 08:05:00 | AAPL | Stock | 3.375 | 3.3843 | 3.375 | 3.3843 | 16800.0 |
| 2008-11-28 08:10:00 | AAPL | Stock | 3.375 | 3.375 | 3.375 | 3.375 | 6720.0 |
| 2008-11-28 08:15:00 | AAPL | Stock | 3.3839 | 3.3839 | 3.3746 | 3.3746 | 87836.0 |
| 2008-11-28 08:20:00 | AAPL | Stock | 3.3729 | 3.3754 | 3.3729 | 3.375 | 55720.0 |
| 2008-11-28 08:25:00 | AAPL | Stock | 3.3775 | 3.3775 | 3.3739 | 3.3739 | 50400.0 |
| 2008-11-28 08:30:00 | AAPL | Stock | 3.3743 | 3.375 | 3.3743 | 3.375 | 9800.0 |
| 2008-11-28 08:35:00 | AAPL | Stock | 3.3779 | 3.3836 | 3.3779 | 3.3786 | 85876.0 |
| 2008-11-28 08:40:00 | AAPL | Stock | 3.3793 | 3.3793 | 3.3786 | 3.3786 | 5600.0 |
| 2008-11-28 08:45:00 | AAPL | Stock | 3.3786 | 3.3829 | 3.3786 | 3.3786 | 56000.0 |
| 2008-11-28 08:50:00 | AAPL | Stock | 3.3793 | 3.3925 | 3.3793 | 3.3821 | 75208.0 |
| 2008-11-28 08:55:00 | AAPL | Stock | 3.385 | 3.3857 | 3.3832 | 3.3857 | 297920.0 |
| 2008-11-28 09:00:00 | AAPL | Stock | 3.3857 | 3.3925 | 3.3857 | 3.3857 | 35000.0 |
| 2008-11-28 09:05:00 | AAPL | Stock | 3.3914 | 3.3914 | 3.3857 | 3.3893 | 61600.0 |
| 2008-11-28 09:10:00 | AAPL | Stock | 3.3925 | 3.3925 | 3.3857 | 3.3857 | 61460.0 |
| 2008-11-28 09:15:00 | AAPL | Stock | 3.3861 | 3.3861 | 3.385 | 3.385 | 33600.0 |
| 2008-11-28 09:20:00 | AAPL | Stock | 3.3857 | 3.3857 | 3.3857 | 3.3857 | 42000.0 |
| 2008-11-28 09:25:00 | AAPL | Stock | 3.3857 | 3.3911 | 3.3811 | 3.3821 | 152040.0 |
| 2008-11-28 09:30:00 | AAPL | Stock | 3.3821 | 3.3886 | 3.3568 | 3.3593 | 10948616.0 |
| 2008-11-28 09:35:00 | AAPL | Stock | 3.3593 | 3.3643 | 3.3357 | 3.3536 | 12879916.0 |
| 2008-11-28 09:40:00 | AAPL | Stock | 3.3539 | 3.3568 | 3.3268 | 3.3339 | 10530296.0 |
| 2008-11-28 09:45:00 | AAPL | Stock | 3.3354 | 3.3454 | 3.3218 | 3.3275 | 7073192.0 |
| 2008-11-28 09:50:00 | AAPL | Stock | 3.3275 | 3.3286 | 3.3075 | 3.3121 | 11749864.0 |
| 2008-11-28 09:55:00 | AAPL | Stock | 3.3121 | 3.3321 | 3.31 | 3.3161 | 7578508.0 |
| 2008-11-28 10:00:00 | AAPL | Stock | 3.3146 | 3.3296 | 3.3111 | 3.3207 | 7552524.0 |
| 2008-11-28 10:05:00 | AAPL | Stock | 3.3214 | 3.33 | 3.3061 | 3.3132 | 6663720.0 |
| 2008-11-28 10:10:00 | AAPL | Stock | 3.313 | 3.3268 | 3.3064 | 3.3064 | 7378980.0 |
| 2008-11-28 10:15:00 | AAPL | Stock | 3.3064 | 3.32 | 3.3 | 3.3175 | 8580712.0 |
| 2008-11-28 10:20:00 | AAPL | Stock | 3.3179 | 3.3214 | 3.3129 | 3.3167 | 5190556.0 |
| 2008-11-28 10:25:00 | AAPL | Stock | 3.3166 | 3.325 | 3.3089 | 3.3136 | 9386020.0 |
| 2008-11-28 10:30:00 | AAPL | Stock | 3.3139 | 3.3157 | 3.2964 | 3.3034 | 9004128.0 |
| 2008-11-28 10:35:00 | AAPL | Stock | 3.3036 | 3.3064 | 3.2929 | 3.2939 | 7177968.0 |
| 2008-11-28 10:40:00 | AAPL | Stock | 3.2936 | 3.2968 | 3.2857 | 3.2948 | 6523412.0 |
| 2008-11-28 10:45:00 | AAPL | Stock | 3.2946 | 3.3021 | 3.2907 | 3.2907 | 4579120.0 |
| 2008-11-28 10:50:00 | AAPL | Stock | 3.2911 | 3.2929 | 3.2807 | 3.2893 | 7693840.0 |
| 2008-11-28 10:55:00 | AAPL | Stock | 3.2893 | 3.3007 | 3.2879 | 3.2975 | 4997216.0 |
| 2008-11-28 11:00:00 | AAPL | Stock | 3.2978 | 3.2978 | 3.2864 | 3.2871 | 4824204.0 |
| 2008-11-28 11:05:00 | AAPL | Stock | 3.2879 | 3.2964 | 3.2871 | 3.2946 | 4421648.0 |
| 2008-11-28 11:10:00 | AAPL | Stock | 3.2939 | 3.3043 | 3.2925 | 3.3011 | 5545204.0 |
| 2008-11-28 11:15:00 | AAPL | Stock | 3.3018 | 3.3018 | 3.2936 | 3.295 | 2718100.0 |
| 2008-11-28 11:20:00 | AAPL | Stock | 3.295 | 3.3082 | 3.2943 | 3.3068 | 4022564.0 |
| 2008-11-28 11:25:00 | AAPL | Stock | 3.3068 | 3.3161 | 3.3068 | 3.3125 | 5400220.0 |
| 2008-11-28 11:30:00 | AAPL | Stock | 3.3139 | 3.3146 | 3.3043 | 3.3068 | 4565008.0 |
| 2008-11-28 11:35:00 | AAPL | Stock | 3.3057 | 3.3118 | 3.2961 | 3.3104 | 5577992.0 |
> showing 50 of 169,598 rows — these rows as CSV