PREVIEW / stock_5min / 2005-08-01
file: by_date/stock_5min/2005/2005-08-01.parquet size: 2.8 MB rows: 205,527 symbols: 2,063
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-08-01 08:00:00 | AAPL | Stock | 1.5232 | 1.5232 | 1.5179 | 1.5189 | 145572.0 |
| 2005-08-01 08:05:00 | AAPL | Stock | 1.5189 | 1.5189 | 1.5179 | 1.5179 | 11200.0 |
| 2005-08-01 08:10:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.5143 | 1.5143 | 14000.0 |
| 2005-08-01 08:15:00 | AAPL | Stock | 1.5125 | 1.5125 | 1.5125 | 1.5125 | 37548.0 |
| 2005-08-01 08:20:00 | AAPL | Stock | 1.5125 | 1.5129 | 1.5111 | 1.5125 | 80220.0 |
| 2005-08-01 08:25:00 | AAPL | Stock | 1.5125 | 1.5214 | 1.5125 | 1.5214 | 123032.0 |
| 2005-08-01 08:30:00 | AAPL | Stock | 1.5232 | 1.5232 | 1.5214 | 1.5232 | 41776.0 |
| 2005-08-01 08:35:00 | AAPL | Stock | 1.5211 | 1.5211 | 1.5211 | 1.5211 | 11200.0 |
| 2005-08-01 08:40:00 | AAPL | Stock | 1.5196 | 1.5246 | 1.5196 | 1.5246 | 25200.0 |
| 2005-08-01 08:45:00 | AAPL | Stock | 1.5225 | 1.525 | 1.5225 | 1.525 | 176400.0 |
| 2005-08-01 08:50:00 | AAPL | Stock | 1.5243 | 1.5243 | 1.5196 | 1.5196 | 125776.0 |
| 2005-08-01 08:55:00 | AAPL | Stock | 1.5214 | 1.5214 | 1.5214 | 1.5214 | 2800.0 |
| 2005-08-01 09:00:00 | AAPL | Stock | 1.5214 | 1.5214 | 1.5214 | 1.5214 | 33124.0 |
| 2005-08-01 09:05:00 | AAPL | Stock | 1.5232 | 1.525 | 1.5232 | 1.5239 | 282828.0 |
| 2005-08-01 09:10:00 | AAPL | Stock | 1.5246 | 1.5264 | 1.5239 | 1.5264 | 138600.0 |
| 2005-08-01 09:15:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 28000.0 |
| 2005-08-01 09:20:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5243 | 1.5243 | 8400.0 |
| 2005-08-01 09:25:00 | AAPL | Stock | 1.5243 | 1.525 | 1.5214 | 1.5214 | 513800.0 |
| 2005-08-01 09:30:00 | AAPL | Stock | 1.5204 | 1.5357 | 1.5161 | 1.5357 | 10773980.0 |
| 2005-08-01 09:35:00 | AAPL | Stock | 1.5354 | 1.5361 | 1.525 | 1.53 | 5670224.0 |
| 2005-08-01 09:40:00 | AAPL | Stock | 1.5304 | 1.5307 | 1.5243 | 1.525 | 4948832.0 |
| 2005-08-01 09:45:00 | AAPL | Stock | 1.5254 | 1.5321 | 1.525 | 1.5257 | 4971008.0 |
| 2005-08-01 09:50:00 | AAPL | Stock | 1.5261 | 1.5286 | 1.5179 | 1.5182 | 7260596.0 |
| 2005-08-01 09:55:00 | AAPL | Stock | 1.5182 | 1.5275 | 1.515 | 1.5268 | 11037852.0 |
| 2005-08-01 10:00:00 | AAPL | Stock | 1.5268 | 1.5275 | 1.5079 | 1.5079 | 13530104.0 |
| 2005-08-01 10:05:00 | AAPL | Stock | 1.5082 | 1.5179 | 1.5029 | 1.5111 | 10665144.0 |
| 2005-08-01 10:10:00 | AAPL | Stock | 1.5114 | 1.5125 | 1.5057 | 1.5118 | 5595520.0 |
| 2005-08-01 10:15:00 | AAPL | Stock | 1.5121 | 1.5196 | 1.5118 | 1.5139 | 8864800.0 |
| 2005-08-01 10:20:00 | AAPL | Stock | 1.5143 | 1.5225 | 1.5143 | 1.5171 | 4634364.0 |
| 2005-08-01 10:25:00 | AAPL | Stock | 1.5175 | 1.5189 | 1.5143 | 1.5164 | 3204796.0 |
| 2005-08-01 10:30:00 | AAPL | Stock | 1.5171 | 1.5196 | 1.5154 | 1.5157 | 1793568.0 |
| 2005-08-01 10:35:00 | AAPL | Stock | 1.5157 | 1.5164 | 1.5121 | 1.5132 | 3898300.0 |
| 2005-08-01 10:40:00 | AAPL | Stock | 1.5132 | 1.5154 | 1.5111 | 1.5125 | 6064044.0 |
| 2005-08-01 10:45:00 | AAPL | Stock | 1.5125 | 1.5157 | 1.5118 | 1.5143 | 4746084.0 |
| 2005-08-01 10:50:00 | AAPL | Stock | 1.5146 | 1.5189 | 1.5143 | 1.5182 | 3132192.0 |
| 2005-08-01 10:55:00 | AAPL | Stock | 1.5186 | 1.5196 | 1.5164 | 1.5182 | 4128740.0 |
| 2005-08-01 11:00:00 | AAPL | Stock | 1.5186 | 1.5196 | 1.5164 | 1.5168 | 3408888.0 |
| 2005-08-01 11:05:00 | AAPL | Stock | 1.5164 | 1.5179 | 1.5157 | 1.5164 | 3918992.0 |
| 2005-08-01 11:10:00 | AAPL | Stock | 1.5164 | 1.5186 | 1.5143 | 1.515 | 2572388.0 |
| 2005-08-01 11:15:00 | AAPL | Stock | 1.515 | 1.5193 | 1.5139 | 1.5186 | 3063900.0 |
| 2005-08-01 11:20:00 | AAPL | Stock | 1.5186 | 1.5225 | 1.5182 | 1.5214 | 4464684.0 |
| 2005-08-01 11:25:00 | AAPL | Stock | 1.5214 | 1.5218 | 1.5196 | 1.5218 | 1571472.0 |
| 2005-08-01 11:30:00 | AAPL | Stock | 1.5218 | 1.525 | 1.5214 | 1.5218 | 4656652.0 |
| 2005-08-01 11:35:00 | AAPL | Stock | 1.5218 | 1.5304 | 1.5218 | 1.5264 | 9772252.0 |
| 2005-08-01 11:40:00 | AAPL | Stock | 1.5261 | 1.5286 | 1.5261 | 1.5286 | 4000472.0 |
| 2005-08-01 11:45:00 | AAPL | Stock | 1.5282 | 1.5307 | 1.5261 | 1.5268 | 4914448.0 |
| 2005-08-01 11:50:00 | AAPL | Stock | 1.5271 | 1.5304 | 1.5271 | 1.53 | 1561868.0 |
| 2005-08-01 11:55:00 | AAPL | Stock | 1.5296 | 1.5307 | 1.5268 | 1.5293 | 3113600.0 |
| 2005-08-01 12:00:00 | AAPL | Stock | 1.5293 | 1.5321 | 1.5289 | 1.5296 | 2367540.0 |
| 2005-08-01 12:05:00 | AAPL | Stock | 1.5296 | 1.5296 | 1.5282 | 1.5282 | 2746324.0 |
> showing 50 of 205,527 rows — these rows as CSV