PREVIEW / stock_5min / 2005-11-23
file: by_date/stock_5min/2005/2005-11-23.parquet size: 2.8 MB rows: 201,780 symbols: 2,119
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-23 08:00:00 | AAPL | Stock | 2.39 | 2.3914 | 2.3764 | 2.3864 | 408184.0 |
| 2005-11-23 08:05:00 | AAPL | Stock | 2.3871 | 2.3896 | 2.3871 | 2.3893 | 26600.0 |
| 2005-11-23 08:10:00 | AAPL | Stock | 2.3871 | 2.3886 | 2.3864 | 2.3871 | 176400.0 |
| 2005-11-23 08:15:00 | AAPL | Stock | 2.3879 | 2.3886 | 2.3879 | 2.3886 | 112000.0 |
| 2005-11-23 08:20:00 | AAPL | Stock | 2.3889 | 2.3911 | 2.3889 | 2.3893 | 230384.0 |
| 2005-11-23 08:25:00 | AAPL | Stock | 2.3911 | 2.3911 | 2.39 | 2.3907 | 72800.0 |
| 2005-11-23 08:30:00 | AAPL | Stock | 2.3896 | 2.3911 | 2.3893 | 2.3911 | 431284.0 |
| 2005-11-23 08:35:00 | AAPL | Stock | 2.3911 | 2.3925 | 2.3904 | 2.3925 | 120372.0 |
| 2005-11-23 08:40:00 | AAPL | Stock | 2.3911 | 2.3939 | 2.3907 | 2.3929 | 289940.0 |
| 2005-11-23 08:45:00 | AAPL | Stock | 2.3929 | 2.3946 | 2.3911 | 2.3911 | 194180.0 |
| 2005-11-23 08:50:00 | AAPL | Stock | 2.3911 | 2.3911 | 2.3896 | 2.3904 | 79408.0 |
| 2005-11-23 08:55:00 | AAPL | Stock | 2.3893 | 2.3896 | 2.3886 | 2.3896 | 59416.0 |
| 2005-11-23 09:00:00 | AAPL | Stock | 2.3886 | 2.3886 | 2.3857 | 2.3857 | 103600.0 |
| 2005-11-23 09:05:00 | AAPL | Stock | 2.3857 | 2.3861 | 2.3846 | 2.3846 | 154280.0 |
| 2005-11-23 09:10:00 | AAPL | Stock | 2.3846 | 2.3857 | 2.3846 | 2.3857 | 112000.0 |
| 2005-11-23 09:15:00 | AAPL | Stock | 2.385 | 2.3854 | 2.385 | 2.3854 | 98000.0 |
| 2005-11-23 09:20:00 | AAPL | Stock | 2.3846 | 2.3857 | 2.3829 | 2.3829 | 134456.0 |
| 2005-11-23 09:25:00 | AAPL | Stock | 2.3857 | 2.39 | 2.3811 | 2.3811 | 632072.0 |
| 2005-11-23 09:30:00 | AAPL | Stock | 2.3886 | 2.3936 | 2.3818 | 2.3911 | 21476896.0 |
| 2005-11-23 09:35:00 | AAPL | Stock | 2.3904 | 2.4054 | 2.39 | 2.405 | 18096288.0 |
| 2005-11-23 09:40:00 | AAPL | Stock | 2.405 | 2.4089 | 2.4 | 2.405 | 15405040.0 |
| 2005-11-23 09:45:00 | AAPL | Stock | 2.405 | 2.4071 | 2.4 | 2.4032 | 11480784.0 |
| 2005-11-23 09:50:00 | AAPL | Stock | 2.4029 | 2.4064 | 2.3982 | 2.4029 | 10528476.0 |
| 2005-11-23 09:55:00 | AAPL | Stock | 2.4036 | 2.4071 | 2.4018 | 2.4018 | 8507548.0 |
| 2005-11-23 10:00:00 | AAPL | Stock | 2.4018 | 2.4071 | 2.3979 | 2.4057 | 10413928.0 |
| 2005-11-23 10:05:00 | AAPL | Stock | 2.4054 | 2.4154 | 2.3982 | 2.4096 | 16380644.0 |
| 2005-11-23 10:10:00 | AAPL | Stock | 2.4096 | 2.4196 | 2.4068 | 2.4182 | 13262676.0 |
| 2005-11-23 10:15:00 | AAPL | Stock | 2.4189 | 2.425 | 2.4175 | 2.4196 | 17470628.0 |
| 2005-11-23 10:20:00 | AAPL | Stock | 2.4202 | 2.4243 | 2.4161 | 2.4186 | 11695516.0 |
| 2005-11-23 10:25:00 | AAPL | Stock | 2.4186 | 2.4193 | 2.4143 | 2.4171 | 6696200.0 |
| 2005-11-23 10:30:00 | AAPL | Stock | 2.4171 | 2.4239 | 2.4168 | 2.4211 | 10727892.0 |
| 2005-11-23 10:35:00 | AAPL | Stock | 2.4214 | 2.4246 | 2.4182 | 2.4196 | 7107128.0 |
| 2005-11-23 10:40:00 | AAPL | Stock | 2.4196 | 2.4279 | 2.4179 | 2.4279 | 8642284.0 |
| 2005-11-23 10:45:00 | AAPL | Stock | 2.4275 | 2.4279 | 2.4214 | 2.4225 | 7937272.0 |
| 2005-11-23 10:50:00 | AAPL | Stock | 2.4225 | 2.4269 | 2.4179 | 2.4204 | 7464968.0 |
| 2005-11-23 10:55:00 | AAPL | Stock | 2.4204 | 2.4211 | 2.4179 | 2.4196 | 5799612.0 |
| 2005-11-23 11:00:00 | AAPL | Stock | 2.4193 | 2.4225 | 2.4179 | 2.4211 | 4452532.0 |
| 2005-11-23 11:05:00 | AAPL | Stock | 2.4211 | 2.4214 | 2.4079 | 2.415 | 12416880.0 |
| 2005-11-23 11:10:00 | AAPL | Stock | 2.415 | 2.4161 | 2.4107 | 2.415 | 5895708.0 |
| 2005-11-23 11:15:00 | AAPL | Stock | 2.4154 | 2.4189 | 2.415 | 2.4157 | 5063856.0 |
| 2005-11-23 11:20:00 | AAPL | Stock | 2.4154 | 2.4225 | 2.415 | 2.4196 | 3936212.0 |
| 2005-11-23 11:25:00 | AAPL | Stock | 2.4196 | 2.4232 | 2.4182 | 2.4214 | 4505844.0 |
| 2005-11-23 11:30:00 | AAPL | Stock | 2.4214 | 2.4214 | 2.4164 | 2.4164 | 3473960.0 |
| 2005-11-23 11:35:00 | AAPL | Stock | 2.4164 | 2.4175 | 2.415 | 2.4161 | 3978828.0 |
| 2005-11-23 11:40:00 | AAPL | Stock | 2.4157 | 2.4161 | 2.4129 | 2.4143 | 4426408.0 |
| 2005-11-23 11:45:00 | AAPL | Stock | 2.4139 | 2.4161 | 2.4139 | 2.4157 | 2806888.0 |
| 2005-11-23 11:50:00 | AAPL | Stock | 2.4157 | 2.4161 | 2.4107 | 2.4139 | 6006196.0 |
| 2005-11-23 11:55:00 | AAPL | Stock | 2.4139 | 2.4143 | 2.4111 | 2.4139 | 3544632.0 |
| 2005-11-23 12:00:00 | AAPL | Stock | 2.4136 | 2.4139 | 2.411 | 2.4136 | 2563428.0 |
| 2005-11-23 12:05:00 | AAPL | Stock | 2.4132 | 2.4139 | 2.4121 | 2.4129 | 2951256.0 |
> showing 50 of 201,780 rows — these rows as CSV