PREVIEW / stock_5min / 2006-08-31
file: by_date/stock_5min/2006/2006-08-31.parquet size: 3.1 MB rows: 230,355 symbols: 2,341
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-31 07:25:00 | AAPL | Stock | 2.39 | 2.3961 | 2.39 | 2.3961 | 70000.0 |
| 2006-08-31 08:00:00 | AAPL | Stock | 2.3929 | 2.3982 | 2.3929 | 2.3982 | 55860.0 |
| 2006-08-31 08:05:00 | AAPL | Stock | 2.3946 | 2.395 | 2.3946 | 2.395 | 75600.0 |
| 2006-08-31 08:10:00 | AAPL | Stock | 2.3961 | 2.3961 | 2.3921 | 2.3921 | 21560.0 |
| 2006-08-31 08:15:00 | AAPL | Stock | 2.3954 | 2.3961 | 2.3932 | 2.3961 | 70840.0 |
| 2006-08-31 08:20:00 | AAPL | Stock | 2.3961 | 2.3982 | 2.3961 | 2.3964 | 77476.0 |
| 2006-08-31 08:25:00 | AAPL | Stock | 2.3971 | 2.3971 | 2.3961 | 2.3961 | 42420.0 |
| 2006-08-31 08:30:00 | AAPL | Stock | 2.3979 | 2.4018 | 2.3964 | 2.4018 | 172200.0 |
| 2006-08-31 08:35:00 | AAPL | Stock | 2.4018 | 2.4025 | 2.4018 | 2.4021 | 135744.0 |
| 2006-08-31 08:40:00 | AAPL | Stock | 2.4025 | 2.4025 | 2.4 | 2.4 | 49700.0 |
| 2006-08-31 08:45:00 | AAPL | Stock | 2.4 | 2.4004 | 2.4 | 2.4004 | 39200.0 |
| 2006-08-31 08:50:00 | AAPL | Stock | 2.4004 | 2.4014 | 2.4004 | 2.4011 | 28000.0 |
| 2006-08-31 08:55:00 | AAPL | Stock | 2.4011 | 2.4014 | 2.4011 | 2.4011 | 30800.0 |
| 2006-08-31 09:00:00 | AAPL | Stock | 2.4011 | 2.4025 | 2.4 | 2.4025 | 114100.0 |
| 2006-08-31 09:05:00 | AAPL | Stock | 2.4025 | 2.4025 | 2.4004 | 2.4004 | 40768.0 |
| 2006-08-31 09:10:00 | AAPL | Stock | 2.4018 | 2.4018 | 2.4018 | 2.4018 | 2800.0 |
| 2006-08-31 09:15:00 | AAPL | Stock | 2.4004 | 2.4004 | 2.4 | 2.4 | 21644.0 |
| 2006-08-31 09:20:00 | AAPL | Stock | 2.3993 | 2.4 | 2.3993 | 2.4 | 49840.0 |
| 2006-08-31 09:25:00 | AAPL | Stock | 2.4 | 2.4054 | 2.3989 | 2.405 | 476644.0 |
| 2006-08-31 09:30:00 | AAPL | Stock | 2.4029 | 2.4071 | 2.395 | 2.396 | 16164316.0 |
| 2006-08-31 09:35:00 | AAPL | Stock | 2.3961 | 2.4036 | 2.3946 | 2.4032 | 10154648.0 |
| 2006-08-31 09:40:00 | AAPL | Stock | 2.4032 | 2.4061 | 2.3989 | 2.4021 | 12571888.0 |
| 2006-08-31 09:45:00 | AAPL | Stock | 2.4021 | 2.4021 | 2.3964 | 2.3979 | 7568736.0 |
| 2006-08-31 09:50:00 | AAPL | Stock | 2.3979 | 2.3986 | 2.3939 | 2.3957 | 7364700.0 |
| 2006-08-31 09:55:00 | AAPL | Stock | 2.3954 | 2.4014 | 2.3936 | 2.3993 | 8631224.0 |
| 2006-08-31 10:00:00 | AAPL | Stock | 2.3993 | 2.4054 | 2.3971 | 2.4032 | 12503540.0 |
| 2006-08-31 10:05:00 | AAPL | Stock | 2.4032 | 2.4054 | 2.4011 | 2.4046 | 8662024.0 |
| 2006-08-31 10:10:00 | AAPL | Stock | 2.4046 | 2.4048 | 2.3986 | 2.4011 | 6223756.0 |
| 2006-08-31 10:15:00 | AAPL | Stock | 2.4007 | 2.4011 | 2.3971 | 2.4011 | 5236504.0 |
| 2006-08-31 10:20:00 | AAPL | Stock | 2.4007 | 2.4018 | 2.3993 | 2.3996 | 3577196.0 |
| 2006-08-31 10:25:00 | AAPL | Stock | 2.3996 | 2.4014 | 2.3986 | 2.4 | 2362584.0 |
| 2006-08-31 10:30:00 | AAPL | Stock | 2.4004 | 2.4036 | 2.3911 | 2.3911 | 9515632.0 |
| 2006-08-31 10:35:00 | AAPL | Stock | 2.3911 | 2.3914 | 2.3807 | 2.3839 | 16236276.0 |
| 2006-08-31 10:40:00 | AAPL | Stock | 2.3839 | 2.3875 | 2.3814 | 2.3839 | 11367720.0 |
| 2006-08-31 10:45:00 | AAPL | Stock | 2.3839 | 2.39 | 2.3825 | 2.39 | 4990328.0 |
| 2006-08-31 10:50:00 | AAPL | Stock | 2.39 | 2.3982 | 2.3896 | 2.3975 | 11590908.0 |
| 2006-08-31 10:55:00 | AAPL | Stock | 2.3975 | 2.3979 | 2.3932 | 2.395 | 5717460.0 |
| 2006-08-31 11:00:00 | AAPL | Stock | 2.3946 | 2.3993 | 2.3946 | 2.3971 | 5019476.0 |
| 2006-08-31 11:05:00 | AAPL | Stock | 2.3971 | 2.3971 | 2.3943 | 2.3957 | 6135948.0 |
| 2006-08-31 11:10:00 | AAPL | Stock | 2.3957 | 2.3961 | 2.3907 | 2.3929 | 4211340.0 |
| 2006-08-31 11:15:00 | AAPL | Stock | 2.3929 | 2.395 | 2.3914 | 2.395 | 4346608.0 |
| 2006-08-31 11:20:00 | AAPL | Stock | 2.3946 | 2.3975 | 2.3932 | 2.3975 | 4446848.0 |
| 2006-08-31 11:25:00 | AAPL | Stock | 2.3975 | 2.3982 | 2.3957 | 2.3971 | 6045396.0 |
| 2006-08-31 11:30:00 | AAPL | Stock | 2.3975 | 2.4039 | 2.3975 | 2.4008 | 9572836.0 |
| 2006-08-31 11:35:00 | AAPL | Stock | 2.4011 | 2.4018 | 2.3989 | 2.3989 | 3402476.0 |
| 2006-08-31 11:40:00 | AAPL | Stock | 2.3989 | 2.4021 | 2.3975 | 2.4018 | 5321232.0 |
| 2006-08-31 11:45:00 | AAPL | Stock | 2.4021 | 2.4046 | 2.4014 | 2.4043 | 3395476.0 |
| 2006-08-31 11:50:00 | AAPL | Stock | 2.4046 | 2.4132 | 2.4039 | 2.4121 | 18220664.0 |
| 2006-08-31 11:55:00 | AAPL | Stock | 2.4121 | 2.4136 | 2.4068 | 2.4093 | 7505512.0 |
| 2006-08-31 12:00:00 | AAPL | Stock | 2.4096 | 2.4182 | 2.4096 | 2.4182 | 9194668.0 |
> showing 50 of 230,355 rows — these rows as CSV