PREVIEW / stock_5min / 2005-03-07
file: by_date/stock_5min/2005/2005-03-07.parquet size: 2.7 MB rows: 195,403 symbols: 1,945
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-07 08:00:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5314 | 1.5357 | 240884.0 |
| 2005-03-07 08:05:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5336 | 1.5336 | 60200.0 |
| 2005-03-07 08:10:00 | AAPL | Stock | 1.5354 | 1.5354 | 1.5318 | 1.5318 | 222264.0 |
| 2005-03-07 08:15:00 | AAPL | Stock | 1.5304 | 1.5304 | 1.5289 | 1.5304 | 100576.0 |
| 2005-03-07 08:20:00 | AAPL | Stock | 1.5293 | 1.5304 | 1.5214 | 1.5268 | 266056.0 |
| 2005-03-07 08:25:00 | AAPL | Stock | 1.5264 | 1.5264 | 1.5243 | 1.5243 | 50400.0 |
| 2005-03-07 08:30:00 | AAPL | Stock | 1.5236 | 1.5236 | 1.5196 | 1.5196 | 121240.0 |
| 2005-03-07 08:35:00 | AAPL | Stock | 1.5207 | 1.5221 | 1.5143 | 1.5179 | 155344.0 |
| 2005-03-07 08:40:00 | AAPL | Stock | 1.5211 | 1.5221 | 1.5196 | 1.5221 | 68068.0 |
| 2005-03-07 08:45:00 | AAPL | Stock | 1.5221 | 1.525 | 1.5221 | 1.5232 | 91448.0 |
| 2005-03-07 08:55:00 | AAPL | Stock | 1.525 | 1.5254 | 1.525 | 1.5254 | 15400.0 |
| 2005-03-07 09:00:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 44408.0 |
| 2005-03-07 09:05:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 21000.0 |
| 2005-03-07 09:10:00 | AAPL | Stock | 1.5236 | 1.5236 | 1.5236 | 1.5236 | 75600.0 |
| 2005-03-07 09:15:00 | AAPL | Stock | 1.5236 | 1.5236 | 1.5236 | 1.5236 | 8400.0 |
| 2005-03-07 09:20:00 | AAPL | Stock | 1.52 | 1.5236 | 1.5196 | 1.5236 | 70000.0 |
| 2005-03-07 09:25:00 | AAPL | Stock | 1.5268 | 1.5296 | 1.5243 | 1.5296 | 608412.0 |
| 2005-03-07 09:30:00 | AAPL | Stock | 1.5286 | 1.5332 | 1.515 | 1.5189 | 23518488.0 |
| 2005-03-07 09:35:00 | AAPL | Stock | 1.5185 | 1.5239 | 1.5125 | 1.5214 | 13390692.0 |
| 2005-03-07 09:40:00 | AAPL | Stock | 1.5214 | 1.5357 | 1.5154 | 1.5307 | 14442008.0 |
| 2005-03-07 09:45:00 | AAPL | Stock | 1.5311 | 1.5343 | 1.5221 | 1.5246 | 12509952.0 |
| 2005-03-07 09:50:00 | AAPL | Stock | 1.5246 | 1.5354 | 1.5221 | 1.5343 | 7700448.0 |
| 2005-03-07 09:55:00 | AAPL | Stock | 1.5346 | 1.5361 | 1.5271 | 1.5286 | 12319244.0 |
| 2005-03-07 10:00:00 | AAPL | Stock | 1.5286 | 1.5393 | 1.5264 | 1.5393 | 13280456.0 |
| 2005-03-07 10:05:00 | AAPL | Stock | 1.54 | 1.5429 | 1.5379 | 1.5393 | 14696640.0 |
| 2005-03-07 10:10:00 | AAPL | Stock | 1.5393 | 1.5446 | 1.5379 | 1.5425 | 8699376.0 |
| 2005-03-07 10:15:00 | AAPL | Stock | 1.5425 | 1.5429 | 1.5375 | 1.5389 | 11232564.0 |
| 2005-03-07 10:20:00 | AAPL | Stock | 1.5393 | 1.5404 | 1.5332 | 1.5361 | 8602972.0 |
| 2005-03-07 10:25:00 | AAPL | Stock | 1.5364 | 1.5382 | 1.5296 | 1.5318 | 9812404.0 |
| 2005-03-07 10:30:00 | AAPL | Stock | 1.5321 | 1.5357 | 1.5293 | 1.5307 | 6784568.0 |
| 2005-03-07 10:35:00 | AAPL | Stock | 1.5307 | 1.5321 | 1.5293 | 1.5311 | 4956560.0 |
| 2005-03-07 10:40:00 | AAPL | Stock | 1.5314 | 1.5371 | 1.5304 | 1.5357 | 5476240.0 |
| 2005-03-07 10:45:00 | AAPL | Stock | 1.5357 | 1.5396 | 1.5343 | 1.5361 | 7875616.0 |
| 2005-03-07 10:50:00 | AAPL | Stock | 1.5357 | 1.5361 | 1.5286 | 1.5289 | 6284376.0 |
| 2005-03-07 10:55:00 | AAPL | Stock | 1.5289 | 1.5307 | 1.5264 | 1.53 | 8638868.0 |
| 2005-03-07 11:00:00 | AAPL | Stock | 1.53 | 1.5329 | 1.5275 | 1.5279 | 4621344.0 |
| 2005-03-07 11:05:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5229 | 1.5264 | 7731584.0 |
| 2005-03-07 11:10:00 | AAPL | Stock | 1.5264 | 1.5307 | 1.5246 | 1.5293 | 4617144.0 |
| 2005-03-07 11:15:00 | AAPL | Stock | 1.5289 | 1.5293 | 1.5271 | 1.5275 | 3536652.0 |
| 2005-03-07 11:20:00 | AAPL | Stock | 1.5275 | 1.5332 | 1.5271 | 1.5296 | 5567800.0 |
| 2005-03-07 11:25:00 | AAPL | Stock | 1.5296 | 1.5325 | 1.5279 | 1.5318 | 3173688.0 |
| 2005-03-07 11:30:00 | AAPL | Stock | 1.5318 | 1.5354 | 1.5304 | 1.5354 | 5249104.0 |
| 2005-03-07 11:35:00 | AAPL | Stock | 1.535 | 1.5354 | 1.5289 | 1.5293 | 4355176.0 |
| 2005-03-07 11:40:00 | AAPL | Stock | 1.5293 | 1.5307 | 1.5261 | 1.5304 | 4773412.0 |
| 2005-03-07 11:45:00 | AAPL | Stock | 1.5304 | 1.5329 | 1.5268 | 1.5279 | 3515680.0 |
| 2005-03-07 11:50:00 | AAPL | Stock | 1.5279 | 1.5282 | 1.5257 | 1.5271 | 4543364.0 |
| 2005-03-07 11:55:00 | AAPL | Stock | 1.5275 | 1.5321 | 1.5271 | 1.5282 | 4270476.0 |
| 2005-03-07 12:00:00 | AAPL | Stock | 1.5282 | 1.5311 | 1.5279 | 1.5282 | 5262992.0 |
| 2005-03-07 12:05:00 | AAPL | Stock | 1.5286 | 1.5307 | 1.5254 | 1.5286 | 4591244.0 |
| 2005-03-07 12:10:00 | AAPL | Stock | 1.5286 | 1.5314 | 1.5279 | 1.5293 | 1776852.0 |
> showing 50 of 195,403 rows — these rows as CSV