PREVIEW / stock_5min / 2005-08-04
file: by_date/stock_5min/2005/2005-08-04.parquet size: 2.7 MB rows: 202,239 symbols: 2,052
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-04 07:30:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5393 | 1.5393 | 2800.0 |
| 2005-08-04 07:40:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5286 | 1.5286 | 2800.0 |
| 2005-08-04 08:00:00 | AAPL | Stock | 1.5429 | 1.5429 | 1.5368 | 1.54 | 68880.0 |
| 2005-08-04 08:15:00 | AAPL | Stock | 1.5368 | 1.5393 | 1.5361 | 1.5393 | 43400.0 |
| 2005-08-04 08:25:00 | AAPL | Stock | 1.5389 | 1.5393 | 1.5357 | 1.5357 | 240520.0 |
| 2005-08-04 08:35:00 | AAPL | Stock | 1.5346 | 1.5354 | 1.5339 | 1.5339 | 118720.0 |
| 2005-08-04 08:50:00 | AAPL | Stock | 1.5339 | 1.5339 | 1.5339 | 1.5339 | 19600.0 |
| 2005-08-04 09:00:00 | AAPL | Stock | 1.5354 | 1.5354 | 1.5354 | 1.5354 | 9884.0 |
| 2005-08-04 09:05:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5336 | 1.5336 | 7000.0 |
| 2005-08-04 09:15:00 | AAPL | Stock | 1.5354 | 1.5354 | 1.5354 | 1.5354 | 5600.0 |
| 2005-08-04 09:20:00 | AAPL | Stock | 1.535 | 1.5354 | 1.535 | 1.5354 | 69300.0 |
| 2005-08-04 09:25:00 | AAPL | Stock | 1.5375 | 1.5375 | 1.5332 | 1.5332 | 277592.0 |
| 2005-08-04 09:30:00 | AAPL | Stock | 1.5318 | 1.5354 | 1.5286 | 1.5307 | 7226548.0 |
| 2005-08-04 09:35:00 | AAPL | Stock | 1.53 | 1.5357 | 1.5293 | 1.5336 | 4542496.0 |
| 2005-08-04 09:40:00 | AAPL | Stock | 1.5332 | 1.5339 | 1.53 | 1.5304 | 3063172.0 |
| 2005-08-04 09:45:00 | AAPL | Stock | 1.5304 | 1.5318 | 1.5282 | 1.53 | 4716152.0 |
| 2005-08-04 09:50:00 | AAPL | Stock | 1.5296 | 1.5343 | 1.5296 | 1.5311 | 3901996.0 |
| 2005-08-04 09:55:00 | AAPL | Stock | 1.5311 | 1.5318 | 1.5286 | 1.5289 | 3639160.0 |
| 2005-08-04 10:00:00 | AAPL | Stock | 1.5293 | 1.5304 | 1.5246 | 1.5246 | 7867440.0 |
| 2005-08-04 10:05:00 | AAPL | Stock | 1.5243 | 1.5271 | 1.5229 | 1.5271 | 5800452.0 |
| 2005-08-04 10:10:00 | AAPL | Stock | 1.5271 | 1.5275 | 1.5243 | 1.5261 | 4647692.0 |
| 2005-08-04 10:15:00 | AAPL | Stock | 1.5264 | 1.5289 | 1.5257 | 1.5286 | 3303720.0 |
| 2005-08-04 10:20:00 | AAPL | Stock | 1.5289 | 1.5304 | 1.5275 | 1.5296 | 4055884.0 |
| 2005-08-04 10:25:00 | AAPL | Stock | 1.5296 | 1.5304 | 1.5271 | 1.5286 | 3073028.0 |
| 2005-08-04 10:30:00 | AAPL | Stock | 1.5286 | 1.53 | 1.5275 | 1.5286 | 2258200.0 |
| 2005-08-04 10:35:00 | AAPL | Stock | 1.5286 | 1.5304 | 1.5286 | 1.53 | 2123940.0 |
| 2005-08-04 10:40:00 | AAPL | Stock | 1.5296 | 1.53 | 1.5279 | 1.5282 | 1886192.0 |
| 2005-08-04 10:45:00 | AAPL | Stock | 1.5282 | 1.53 | 1.5279 | 1.5293 | 1436316.0 |
| 2005-08-04 10:50:00 | AAPL | Stock | 1.5296 | 1.5307 | 1.5289 | 1.5304 | 1255688.0 |
| 2005-08-04 10:55:00 | AAPL | Stock | 1.5304 | 1.5318 | 1.53 | 1.5304 | 2363760.0 |
| 2005-08-04 11:00:00 | AAPL | Stock | 1.5304 | 1.5318 | 1.5296 | 1.5304 | 2961924.0 |
| 2005-08-04 11:05:00 | AAPL | Stock | 1.5304 | 1.5307 | 1.5282 | 1.5296 | 2839480.0 |
| 2005-08-04 11:10:00 | AAPL | Stock | 1.5296 | 1.5304 | 1.5286 | 1.5293 | 856520.0 |
| 2005-08-04 11:15:00 | AAPL | Stock | 1.5293 | 1.5293 | 1.5279 | 1.5282 | 1316700.0 |
| 2005-08-04 11:20:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5279 | 1.5282 | 2972116.0 |
| 2005-08-04 11:25:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5243 | 1.525 | 6158880.0 |
| 2005-08-04 11:30:00 | AAPL | Stock | 1.525 | 1.525 | 1.5221 | 1.5225 | 4543140.0 |
| 2005-08-04 11:35:00 | AAPL | Stock | 1.5225 | 1.5229 | 1.52 | 1.5229 | 3033744.0 |
| 2005-08-04 11:40:00 | AAPL | Stock | 1.5229 | 1.5229 | 1.5179 | 1.5179 | 4013968.0 |
| 2005-08-04 11:45:00 | AAPL | Stock | 1.5179 | 1.52 | 1.515 | 1.515 | 5153316.0 |
| 2005-08-04 11:50:00 | AAPL | Stock | 1.515 | 1.5204 | 1.515 | 1.5189 | 4384688.0 |
| 2005-08-04 11:55:00 | AAPL | Stock | 1.5189 | 1.5189 | 1.515 | 1.5164 | 4421928.0 |
| 2005-08-04 12:00:00 | AAPL | Stock | 1.5161 | 1.5175 | 1.5157 | 1.5161 | 2524060.0 |
| 2005-08-04 12:05:00 | AAPL | Stock | 1.5164 | 1.5175 | 1.5143 | 1.5171 | 2900072.0 |
| 2005-08-04 12:10:00 | AAPL | Stock | 1.5168 | 1.5171 | 1.515 | 1.5161 | 3726828.0 |
| 2005-08-04 12:15:00 | AAPL | Stock | 1.5161 | 1.5161 | 1.5136 | 1.5136 | 2104116.0 |
| 2005-08-04 12:20:00 | AAPL | Stock | 1.5136 | 1.5139 | 1.5104 | 1.5136 | 3944640.0 |
| 2005-08-04 12:25:00 | AAPL | Stock | 1.5139 | 1.515 | 1.5118 | 1.5143 | 3695160.0 |
| 2005-08-04 12:30:00 | AAPL | Stock | 1.5143 | 1.5157 | 1.5139 | 1.5157 | 2172464.0 |
| 2005-08-04 12:35:00 | AAPL | Stock | 1.5157 | 1.5179 | 1.5157 | 1.5171 | 3370444.0 |
> showing 50 of 202,239 rows — these rows as CSV