PREVIEW / stock_5min / 2005-03-10
file: by_date/stock_5min/2005/2005-03-10.parquet size: 2.7 MB rows: 194,507 symbols: 1,943
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-03-10 08:00:00 | AAPL | Stock | 1.4014 | 1.4046 | 1.3932 | 1.3996 | 631540.0 |
| 2005-03-10 08:05:00 | AAPL | Stock | 1.3989 | 1.405 | 1.3975 | 1.3975 | 207200.0 |
| 2005-03-10 08:10:00 | AAPL | Stock | 1.3982 | 1.4014 | 1.3982 | 1.4 | 78400.0 |
| 2005-03-10 08:15:00 | AAPL | Stock | 1.4 | 1.4 | 1.3996 | 1.4 | 56000.0 |
| 2005-03-10 08:20:00 | AAPL | Stock | 1.4 | 1.4 | 1.4 | 1.4 | 52472.0 |
| 2005-03-10 08:25:00 | AAPL | Stock | 1.4029 | 1.4036 | 1.4018 | 1.4032 | 47600.0 |
| 2005-03-10 08:30:00 | AAPL | Stock | 1.4014 | 1.4036 | 1.4014 | 1.4025 | 134400.0 |
| 2005-03-10 08:35:00 | AAPL | Stock | 1.4032 | 1.4032 | 1.3989 | 1.3996 | 114800.0 |
| 2005-03-10 08:40:00 | AAPL | Stock | 1.3961 | 1.4029 | 1.3961 | 1.4018 | 36400.0 |
| 2005-03-10 08:45:00 | AAPL | Stock | 1.4018 | 1.4018 | 1.4018 | 1.4018 | 11760.0 |
| 2005-03-10 08:50:00 | AAPL | Stock | 1.4018 | 1.4043 | 1.4018 | 1.4036 | 168000.0 |
| 2005-03-10 08:55:00 | AAPL | Stock | 1.4032 | 1.4093 | 1.4029 | 1.4093 | 554904.0 |
| 2005-03-10 09:00:00 | AAPL | Stock | 1.4089 | 1.4143 | 1.4082 | 1.41 | 921508.0 |
| 2005-03-10 09:05:00 | AAPL | Stock | 1.4096 | 1.4161 | 1.4089 | 1.4161 | 264180.0 |
| 2005-03-10 09:10:00 | AAPL | Stock | 1.4121 | 1.4179 | 1.4107 | 1.4154 | 423920.0 |
| 2005-03-10 09:15:00 | AAPL | Stock | 1.4146 | 1.4175 | 1.4143 | 1.4175 | 506660.0 |
| 2005-03-10 09:20:00 | AAPL | Stock | 1.4179 | 1.4207 | 1.4171 | 1.4171 | 359800.0 |
| 2005-03-10 09:25:00 | AAPL | Stock | 1.4168 | 1.4214 | 1.4104 | 1.4111 | 2220316.0 |
| 2005-03-10 09:30:00 | AAPL | Stock | 1.4118 | 1.435 | 1.4107 | 1.4332 | 45695636.0 |
| 2005-03-10 09:35:00 | AAPL | Stock | 1.4332 | 1.4379 | 1.4243 | 1.4282 | 31803268.0 |
| 2005-03-10 09:40:00 | AAPL | Stock | 1.4282 | 1.4314 | 1.4236 | 1.4264 | 21739116.0 |
| 2005-03-10 09:45:00 | AAPL | Stock | 1.4264 | 1.4282 | 1.4196 | 1.42 | 16183356.0 |
| 2005-03-10 09:50:00 | AAPL | Stock | 1.42 | 1.4293 | 1.4179 | 1.4275 | 15902992.0 |
| 2005-03-10 09:55:00 | AAPL | Stock | 1.4275 | 1.4321 | 1.4257 | 1.4307 | 15922872.0 |
| 2005-03-10 10:00:00 | AAPL | Stock | 1.4307 | 1.4339 | 1.4268 | 1.4268 | 14668388.0 |
| 2005-03-10 10:05:00 | AAPL | Stock | 1.4271 | 1.4286 | 1.4118 | 1.4218 | 19171684.0 |
| 2005-03-10 10:10:00 | AAPL | Stock | 1.4214 | 1.425 | 1.4114 | 1.4121 | 11324880.0 |
| 2005-03-10 10:15:00 | AAPL | Stock | 1.4121 | 1.4268 | 1.4118 | 1.4218 | 14009296.0 |
| 2005-03-10 10:20:00 | AAPL | Stock | 1.4214 | 1.4214 | 1.4161 | 1.4171 | 10171532.0 |
| 2005-03-10 10:25:00 | AAPL | Stock | 1.4168 | 1.4175 | 1.4079 | 1.4118 | 19786116.0 |
| 2005-03-10 10:30:00 | AAPL | Stock | 1.4118 | 1.4155 | 1.4046 | 1.4057 | 17925432.0 |
| 2005-03-10 10:35:00 | AAPL | Stock | 1.4057 | 1.4136 | 1.4054 | 1.4121 | 12196128.0 |
| 2005-03-10 10:40:00 | AAPL | Stock | 1.4125 | 1.4143 | 1.41 | 1.4118 | 11112444.0 |
| 2005-03-10 10:45:00 | AAPL | Stock | 1.4118 | 1.4143 | 1.4093 | 1.4111 | 8260420.0 |
| 2005-03-10 10:50:00 | AAPL | Stock | 1.4104 | 1.4143 | 1.41 | 1.4139 | 5467252.0 |
| 2005-03-10 10:55:00 | AAPL | Stock | 1.4136 | 1.4157 | 1.4104 | 1.4104 | 6676376.0 |
| 2005-03-10 11:00:00 | AAPL | Stock | 1.4104 | 1.4111 | 1.4093 | 1.4104 | 6164060.0 |
| 2005-03-10 11:05:00 | AAPL | Stock | 1.4104 | 1.4107 | 1.3982 | 1.3986 | 16138444.0 |
| 2005-03-10 11:10:00 | AAPL | Stock | 1.3986 | 1.4032 | 1.3964 | 1.4014 | 14496972.0 |
| 2005-03-10 11:15:00 | AAPL | Stock | 1.4014 | 1.4071 | 1.4011 | 1.4057 | 12744928.0 |
| 2005-03-10 11:20:00 | AAPL | Stock | 1.4061 | 1.4086 | 1.4043 | 1.4079 | 9577092.0 |
| 2005-03-10 11:25:00 | AAPL | Stock | 1.4079 | 1.4107 | 1.4061 | 1.4086 | 10023888.0 |
| 2005-03-10 11:30:00 | AAPL | Stock | 1.4089 | 1.4104 | 1.4071 | 1.4079 | 4795672.0 |
| 2005-03-10 11:35:00 | AAPL | Stock | 1.4086 | 1.4089 | 1.4057 | 1.4068 | 4340056.0 |
| 2005-03-10 11:40:00 | AAPL | Stock | 1.4068 | 1.4082 | 1.4046 | 1.4075 | 5578832.0 |
| 2005-03-10 11:45:00 | AAPL | Stock | 1.4075 | 1.4107 | 1.4032 | 1.4104 | 11798388.0 |
| 2005-03-10 11:50:00 | AAPL | Stock | 1.4104 | 1.4143 | 1.4096 | 1.4136 | 11911984.0 |
| 2005-03-10 11:55:00 | AAPL | Stock | 1.4139 | 1.4196 | 1.4132 | 1.4196 | 13927396.0 |
| 2005-03-10 12:00:00 | AAPL | Stock | 1.4193 | 1.4211 | 1.415 | 1.4171 | 9452016.0 |
| 2005-03-10 12:05:00 | AAPL | Stock | 1.4175 | 1.4179 | 1.415 | 1.4151 | 3651200.0 |
> showing 50 of 194,507 rows — these rows as CSV