PREVIEW / stock_5min / 2005-03-24
file: by_date/stock_5min/2005/2005-03-24.parquet size: 2.6 MB rows: 191,113 symbols: 1,950
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-24 08:00:00 | AAPL | Stock | 1.5214 | 1.5336 | 1.5214 | 1.5336 | 1576792.0 |
| 2005-03-24 08:05:00 | AAPL | Stock | 1.5307 | 1.5339 | 1.5296 | 1.5339 | 120400.0 |
| 2005-03-24 08:10:00 | AAPL | Stock | 1.5296 | 1.5318 | 1.5296 | 1.5318 | 8400.0 |
| 2005-03-24 08:15:00 | AAPL | Stock | 1.5318 | 1.5318 | 1.5286 | 1.5286 | 78400.0 |
| 2005-03-24 08:20:00 | AAPL | Stock | 1.5332 | 1.5332 | 1.5264 | 1.5264 | 43400.0 |
| 2005-03-24 08:25:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5282 | 1.5282 | 2800.0 |
| 2005-03-24 08:35:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 30800.0 |
| 2005-03-24 08:45:00 | AAPL | Stock | 1.5275 | 1.5286 | 1.5275 | 1.5286 | 66444.0 |
| 2005-03-24 08:50:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5282 | 1.5286 | 131600.0 |
| 2005-03-24 08:55:00 | AAPL | Stock | 1.5282 | 1.5293 | 1.5268 | 1.5293 | 94192.0 |
| 2005-03-24 09:00:00 | AAPL | Stock | 1.5293 | 1.5293 | 1.5293 | 1.5293 | 117600.0 |
| 2005-03-24 09:05:00 | AAPL | Stock | 1.53 | 1.5321 | 1.53 | 1.53 | 92764.0 |
| 2005-03-24 09:10:00 | AAPL | Stock | 1.53 | 1.5311 | 1.5293 | 1.5296 | 247240.0 |
| 2005-03-24 09:15:00 | AAPL | Stock | 1.53 | 1.5332 | 1.53 | 1.5332 | 64400.0 |
| 2005-03-24 09:20:00 | AAPL | Stock | 1.5332 | 1.5339 | 1.5332 | 1.5339 | 215600.0 |
| 2005-03-24 09:25:00 | AAPL | Stock | 1.5246 | 1.5357 | 1.5246 | 1.5336 | 336784.0 |
| 2005-03-24 09:30:00 | AAPL | Stock | 1.5325 | 1.535 | 1.5193 | 1.5289 | 16503172.0 |
| 2005-03-24 09:35:00 | AAPL | Stock | 1.5293 | 1.5296 | 1.5246 | 1.5286 | 8627080.0 |
| 2005-03-24 09:40:00 | AAPL | Stock | 1.5286 | 1.5304 | 1.5268 | 1.5286 | 8349208.0 |
| 2005-03-24 09:45:00 | AAPL | Stock | 1.5289 | 1.5336 | 1.5229 | 1.5261 | 12231884.0 |
| 2005-03-24 09:50:00 | AAPL | Stock | 1.5261 | 1.5304 | 1.5257 | 1.5275 | 5802160.0 |
| 2005-03-24 09:55:00 | AAPL | Stock | 1.5271 | 1.5286 | 1.5257 | 1.5268 | 4843216.0 |
| 2005-03-24 10:00:00 | AAPL | Stock | 1.5271 | 1.5318 | 1.5264 | 1.5314 | 8706964.0 |
| 2005-03-24 10:05:00 | AAPL | Stock | 1.5314 | 1.5321 | 1.5275 | 1.5296 | 6414604.0 |
| 2005-03-24 10:10:00 | AAPL | Stock | 1.53 | 1.5314 | 1.5286 | 1.5314 | 3290308.0 |
| 2005-03-24 10:15:00 | AAPL | Stock | 1.5314 | 1.5318 | 1.5275 | 1.5296 | 10588172.0 |
| 2005-03-24 10:20:00 | AAPL | Stock | 1.5296 | 1.5311 | 1.5254 | 1.5279 | 6629504.0 |
| 2005-03-24 10:25:00 | AAPL | Stock | 1.5282 | 1.5314 | 1.5264 | 1.5307 | 6230084.0 |
| 2005-03-24 10:30:00 | AAPL | Stock | 1.5311 | 1.5346 | 1.53 | 1.5311 | 9462628.0 |
| 2005-03-24 10:35:00 | AAPL | Stock | 1.5318 | 1.5357 | 1.5304 | 1.5325 | 9683464.0 |
| 2005-03-24 10:40:00 | AAPL | Stock | 1.5325 | 1.535 | 1.5325 | 1.5336 | 8106812.0 |
| 2005-03-24 10:45:00 | AAPL | Stock | 1.5336 | 1.535 | 1.5321 | 1.5336 | 3769556.0 |
| 2005-03-24 10:50:00 | AAPL | Stock | 1.5339 | 1.5343 | 1.5325 | 1.5332 | 3666068.0 |
| 2005-03-24 10:55:00 | AAPL | Stock | 1.5332 | 1.5343 | 1.5318 | 1.5329 | 2410884.0 |
| 2005-03-24 11:00:00 | AAPL | Stock | 1.5332 | 1.5332 | 1.5296 | 1.5321 | 3049256.0 |
| 2005-03-24 11:05:00 | AAPL | Stock | 1.532 | 1.532 | 1.5236 | 1.5254 | 12121228.0 |
| 2005-03-24 11:10:00 | AAPL | Stock | 1.5254 | 1.5279 | 1.5243 | 1.5257 | 6594616.0 |
| 2005-03-24 11:15:00 | AAPL | Stock | 1.5257 | 1.5268 | 1.5232 | 1.5239 | 3645768.0 |
| 2005-03-24 11:20:00 | AAPL | Stock | 1.5239 | 1.5279 | 1.5239 | 1.5271 | 3092320.0 |
| 2005-03-24 11:25:00 | AAPL | Stock | 1.5275 | 1.5282 | 1.5254 | 1.5268 | 2263576.0 |
| 2005-03-24 11:30:00 | AAPL | Stock | 1.5268 | 1.5289 | 1.5262 | 1.5282 | 2574964.0 |
| 2005-03-24 11:35:00 | AAPL | Stock | 1.5282 | 1.5286 | 1.5261 | 1.5264 | 2544332.0 |
| 2005-03-24 11:40:00 | AAPL | Stock | 1.5261 | 1.5278 | 1.5254 | 1.5268 | 1922760.0 |
| 2005-03-24 11:45:00 | AAPL | Stock | 1.5269 | 1.5307 | 1.5239 | 1.5264 | 4571588.0 |
| 2005-03-24 11:50:00 | AAPL | Stock | 1.5264 | 1.5279 | 1.525 | 1.5275 | 1640044.0 |
| 2005-03-24 11:55:00 | AAPL | Stock | 1.5271 | 1.5293 | 1.5261 | 1.5293 | 1678012.0 |
| 2005-03-24 12:00:00 | AAPL | Stock | 1.5293 | 1.5296 | 1.5275 | 1.5293 | 1585136.0 |
| 2005-03-24 12:05:00 | AAPL | Stock | 1.5293 | 1.5304 | 1.5286 | 1.5289 | 2010708.0 |
| 2005-03-24 12:10:00 | AAPL | Stock | 1.5289 | 1.5311 | 1.5286 | 1.5304 | 3915212.0 |
| 2005-03-24 12:15:00 | AAPL | Stock | 1.53 | 1.5311 | 1.5293 | 1.5307 | 2882992.0 |
> showing 50 of 191,113 rows — these rows as CSV