PREVIEW / stock_5min / 2005-08-08
file: by_date/stock_5min/2005/2005-08-08.parquet size: 2.7 MB rows: 200,615 symbols: 2,050
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-08 08:00:00 | AAPL | Stock | 1.5346 | 1.5393 | 1.5346 | 1.5393 | 11200.0 |
| 2005-08-08 08:05:00 | AAPL | Stock | 1.54 | 1.5454 | 1.54 | 1.5454 | 48468.0 |
| 2005-08-08 08:10:00 | AAPL | Stock | 1.5464 | 1.5464 | 1.5429 | 1.5429 | 239932.0 |
| 2005-08-08 08:15:00 | AAPL | Stock | 1.5411 | 1.5411 | 1.5411 | 1.5411 | 5600.0 |
| 2005-08-08 08:20:00 | AAPL | Stock | 1.54 | 1.54 | 1.5357 | 1.5357 | 64680.0 |
| 2005-08-08 08:25:00 | AAPL | Stock | 1.5346 | 1.5354 | 1.5346 | 1.5354 | 8400.0 |
| 2005-08-08 08:30:00 | AAPL | Stock | 1.5332 | 1.5357 | 1.5332 | 1.5357 | 11200.0 |
| 2005-08-08 08:35:00 | AAPL | Stock | 1.5357 | 1.5357 | 1.5357 | 1.5357 | 28000.0 |
| 2005-08-08 08:45:00 | AAPL | Stock | 1.5361 | 1.5361 | 1.5361 | 1.5361 | 2800.0 |
| 2005-08-08 08:55:00 | AAPL | Stock | 1.5418 | 1.5425 | 1.5418 | 1.5425 | 33600.0 |
| 2005-08-08 09:05:00 | AAPL | Stock | 1.5421 | 1.5421 | 1.5421 | 1.5421 | 28000.0 |
| 2005-08-08 09:10:00 | AAPL | Stock | 1.5421 | 1.5425 | 1.5379 | 1.5379 | 29820.0 |
| 2005-08-08 09:15:00 | AAPL | Stock | 1.5379 | 1.5382 | 1.5368 | 1.5382 | 80472.0 |
| 2005-08-08 09:20:00 | AAPL | Stock | 1.5386 | 1.5393 | 1.5386 | 1.5386 | 42000.0 |
| 2005-08-08 09:25:00 | AAPL | Stock | 1.5386 | 1.5393 | 1.5357 | 1.5357 | 179200.0 |
| 2005-08-08 09:30:00 | AAPL | Stock | 1.5357 | 1.5361 | 1.5232 | 1.5286 | 8748964.0 |
| 2005-08-08 09:35:00 | AAPL | Stock | 1.5275 | 1.54 | 1.5275 | 1.5336 | 8190112.0 |
| 2005-08-08 09:40:00 | AAPL | Stock | 1.5336 | 1.5357 | 1.5321 | 1.5332 | 4059076.0 |
| 2005-08-08 09:45:00 | AAPL | Stock | 1.5329 | 1.5402 | 1.5329 | 1.5386 | 4409720.0 |
| 2005-08-08 09:50:00 | AAPL | Stock | 1.5389 | 1.5429 | 1.5379 | 1.5421 | 3525060.0 |
| 2005-08-08 09:55:00 | AAPL | Stock | 1.5421 | 1.5425 | 1.5382 | 1.5407 | 2363368.0 |
| 2005-08-08 10:00:00 | AAPL | Stock | 1.5407 | 1.5446 | 1.5393 | 1.5421 | 4061848.0 |
| 2005-08-08 10:05:00 | AAPL | Stock | 1.5418 | 1.5425 | 1.5386 | 1.5386 | 1373120.0 |
| 2005-08-08 10:10:00 | AAPL | Stock | 1.5386 | 1.5386 | 1.5329 | 1.5332 | 3024812.0 |
| 2005-08-08 10:15:00 | AAPL | Stock | 1.5332 | 1.5346 | 1.5314 | 1.5336 | 4188212.0 |
| 2005-08-08 10:20:00 | AAPL | Stock | 1.5336 | 1.5357 | 1.5332 | 1.5354 | 2710876.0 |
| 2005-08-08 10:25:00 | AAPL | Stock | 1.535 | 1.5357 | 1.5325 | 1.5329 | 2002224.0 |
| 2005-08-08 10:30:00 | AAPL | Stock | 1.5329 | 1.5339 | 1.5314 | 1.5329 | 1956248.0 |
| 2005-08-08 10:35:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5282 | 1.5283 | 2501884.0 |
| 2005-08-08 10:40:00 | AAPL | Stock | 1.5282 | 1.5311 | 1.5271 | 1.5275 | 3165344.0 |
| 2005-08-08 10:45:00 | AAPL | Stock | 1.5268 | 1.5293 | 1.5254 | 1.529 | 3444840.0 |
| 2005-08-08 10:50:00 | AAPL | Stock | 1.5293 | 1.5304 | 1.5264 | 1.5268 | 1663032.0 |
| 2005-08-08 10:55:00 | AAPL | Stock | 1.5268 | 1.5293 | 1.5268 | 1.5293 | 2084992.0 |
| 2005-08-08 11:00:00 | AAPL | Stock | 1.5296 | 1.5296 | 1.5279 | 1.5293 | 2466184.0 |
| 2005-08-08 11:05:00 | AAPL | Stock | 1.5289 | 1.5332 | 1.5289 | 1.5314 | 2196768.0 |
| 2005-08-08 11:10:00 | AAPL | Stock | 1.5314 | 1.5321 | 1.5304 | 1.5304 | 1331288.0 |
| 2005-08-08 11:15:00 | AAPL | Stock | 1.5307 | 1.5325 | 1.5296 | 1.5321 | 1060612.0 |
| 2005-08-08 11:20:00 | AAPL | Stock | 1.5321 | 1.5357 | 1.5279 | 1.5336 | 2690016.0 |
| 2005-08-08 11:25:00 | AAPL | Stock | 1.5332 | 1.5343 | 1.5325 | 1.5343 | 1011220.0 |
| 2005-08-08 11:30:00 | AAPL | Stock | 1.5343 | 1.5354 | 1.5314 | 1.5318 | 894824.0 |
| 2005-08-08 11:35:00 | AAPL | Stock | 1.5314 | 1.5343 | 1.5304 | 1.5332 | 1264228.0 |
| 2005-08-08 11:40:00 | AAPL | Stock | 1.5332 | 1.5339 | 1.5314 | 1.5321 | 1129856.0 |
| 2005-08-08 11:45:00 | AAPL | Stock | 1.5318 | 1.5336 | 1.5311 | 1.5336 | 2203208.0 |
| 2005-08-08 11:50:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5314 | 1.5332 | 1146096.0 |
| 2005-08-08 11:55:00 | AAPL | Stock | 1.5336 | 1.5339 | 1.5314 | 1.5336 | 1146376.0 |
| 2005-08-08 12:00:00 | AAPL | Stock | 1.5329 | 1.5332 | 1.5321 | 1.5329 | 305396.0 |
| 2005-08-08 12:05:00 | AAPL | Stock | 1.5329 | 1.5336 | 1.5329 | 1.5332 | 1286964.0 |
| 2005-08-08 12:10:00 | AAPL | Stock | 1.5329 | 1.5339 | 1.5329 | 1.5339 | 810040.0 |
| 2005-08-08 12:15:00 | AAPL | Stock | 1.5336 | 1.5343 | 1.5329 | 1.5339 | 774200.0 |
| 2005-08-08 12:20:00 | AAPL | Stock | 1.5343 | 1.5354 | 1.5319 | 1.5325 | 1213716.0 |
> showing 50 of 200,615 rows — these rows as CSV