PREVIEW / stock_5min / 2004-08-09
file: by_date/stock_5min/2004/2004-08-09.parquet size: 2.3 MB rows: 176,968 symbols: 1,815
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-09 08:55:00 | AAPL | Stock | 0.532 | 0.532 | 0.532 | 0.532 | 655200.0 |
| 2004-08-09 09:00:00 | AAPL | Stock | 0.5313 | 0.5313 | 0.5313 | 0.5313 | 5600.0 |
| 2004-08-09 09:05:00 | AAPL | Stock | 0.5313 | 0.5313 | 0.5313 | 0.5313 | 67200.0 |
| 2004-08-09 09:10:00 | AAPL | Stock | 0.5313 | 0.5313 | 0.5313 | 0.5313 | 16800.0 |
| 2004-08-09 09:15:00 | AAPL | Stock | 0.5313 | 0.5313 | 0.5313 | 0.5313 | 78400.0 |
| 2004-08-09 09:25:00 | AAPL | Stock | 0.5313 | 0.533 | 0.5313 | 0.533 | 415856.0 |
| 2004-08-09 09:30:00 | AAPL | Stock | 0.533 | 0.5434 | 0.5323 | 0.5432 | 7590856.0 |
| 2004-08-09 09:35:00 | AAPL | Stock | 0.5432 | 0.5438 | 0.5363 | 0.5386 | 7933688.0 |
| 2004-08-09 09:40:00 | AAPL | Stock | 0.5386 | 0.5398 | 0.5373 | 0.5395 | 4813312.0 |
| 2004-08-09 09:45:00 | AAPL | Stock | 0.5388 | 0.5402 | 0.5366 | 0.5373 | 5522104.0 |
| 2004-08-09 09:50:00 | AAPL | Stock | 0.5373 | 0.538 | 0.5364 | 0.5364 | 4020520.0 |
| 2004-08-09 09:55:00 | AAPL | Stock | 0.5366 | 0.5379 | 0.535 | 0.5354 | 8386616.0 |
| 2004-08-09 10:00:00 | AAPL | Stock | 0.5354 | 0.5368 | 0.5348 | 0.5359 | 5842312.0 |
| 2004-08-09 10:05:00 | AAPL | Stock | 0.5363 | 0.5364 | 0.5355 | 0.5363 | 2292976.0 |
| 2004-08-09 10:10:00 | AAPL | Stock | 0.5363 | 0.5384 | 0.5359 | 0.5384 | 3855880.0 |
| 2004-08-09 10:15:00 | AAPL | Stock | 0.5386 | 0.5407 | 0.5386 | 0.5407 | 5207552.0 |
| 2004-08-09 10:20:00 | AAPL | Stock | 0.5405 | 0.5409 | 0.5404 | 0.5409 | 3203648.0 |
| 2004-08-09 10:25:00 | AAPL | Stock | 0.5409 | 0.5418 | 0.5379 | 0.538 | 5458880.0 |
| 2004-08-09 10:30:00 | AAPL | Stock | 0.5382 | 0.5402 | 0.538 | 0.5393 | 2738736.0 |
| 2004-08-09 10:35:00 | AAPL | Stock | 0.5393 | 0.5396 | 0.5384 | 0.5389 | 1058232.0 |
| 2004-08-09 10:40:00 | AAPL | Stock | 0.5391 | 0.5391 | 0.5384 | 0.5384 | 1619688.0 |
| 2004-08-09 10:45:00 | AAPL | Stock | 0.5386 | 0.5386 | 0.5379 | 0.538 | 1155224.0 |
| 2004-08-09 10:50:00 | AAPL | Stock | 0.538 | 0.5391 | 0.5379 | 0.5388 | 2711744.0 |
| 2004-08-09 10:55:00 | AAPL | Stock | 0.5388 | 0.5404 | 0.5379 | 0.5402 | 3047240.0 |
| 2004-08-09 11:00:00 | AAPL | Stock | 0.5402 | 0.5405 | 0.5384 | 0.5384 | 3247104.0 |
| 2004-08-09 11:05:00 | AAPL | Stock | 0.5384 | 0.5386 | 0.5384 | 0.5384 | 1019704.0 |
| 2004-08-09 11:10:00 | AAPL | Stock | 0.5384 | 0.5386 | 0.5384 | 0.5386 | 739480.0 |
| 2004-08-09 11:15:00 | AAPL | Stock | 0.5386 | 0.5386 | 0.5384 | 0.5386 | 929096.0 |
| 2004-08-09 11:20:00 | AAPL | Stock | 0.5386 | 0.5393 | 0.5384 | 0.5391 | 2527000.0 |
| 2004-08-09 11:25:00 | AAPL | Stock | 0.5389 | 0.5391 | 0.5386 | 0.5388 | 713440.0 |
| 2004-08-09 11:30:00 | AAPL | Stock | 0.5388 | 0.5389 | 0.5382 | 0.5382 | 1221472.0 |
| 2004-08-09 11:35:00 | AAPL | Stock | 0.5382 | 0.5382 | 0.5375 | 0.538 | 1412936.0 |
| 2004-08-09 11:40:00 | AAPL | Stock | 0.538 | 0.538 | 0.5375 | 0.5376 | 549752.0 |
| 2004-08-09 11:45:00 | AAPL | Stock | 0.5375 | 0.5377 | 0.5375 | 0.5375 | 408016.0 |
| 2004-08-09 11:50:00 | AAPL | Stock | 0.5375 | 0.5382 | 0.5371 | 0.5382 | 2219336.0 |
| 2004-08-09 11:55:00 | AAPL | Stock | 0.5382 | 0.5382 | 0.5371 | 0.5371 | 2517144.0 |
| 2004-08-09 12:00:00 | AAPL | Stock | 0.5371 | 0.5371 | 0.5366 | 0.537 | 977200.0 |
| 2004-08-09 12:05:00 | AAPL | Stock | 0.5368 | 0.5382 | 0.5368 | 0.5373 | 2144800.0 |
| 2004-08-09 12:10:00 | AAPL | Stock | 0.5373 | 0.5373 | 0.5368 | 0.537 | 729400.0 |
| 2004-08-09 12:15:00 | AAPL | Stock | 0.5368 | 0.5371 | 0.5366 | 0.537 | 3495800.0 |
| 2004-08-09 12:20:00 | AAPL | Stock | 0.5371 | 0.5373 | 0.5368 | 0.5371 | 2949912.0 |
| 2004-08-09 12:25:00 | AAPL | Stock | 0.5371 | 0.5384 | 0.5371 | 0.5379 | 2655184.0 |
| 2004-08-09 12:30:00 | AAPL | Stock | 0.5375 | 0.5384 | 0.5375 | 0.5382 | 966560.0 |
| 2004-08-09 12:35:00 | AAPL | Stock | 0.5382 | 0.5382 | 0.5379 | 0.538 | 268800.0 |
| 2004-08-09 12:40:00 | AAPL | Stock | 0.5382 | 0.5402 | 0.538 | 0.5395 | 4290104.0 |
| 2004-08-09 12:45:00 | AAPL | Stock | 0.5395 | 0.5395 | 0.5388 | 0.5391 | 2950304.0 |
| 2004-08-09 12:50:00 | AAPL | Stock | 0.5391 | 0.5393 | 0.5386 | 0.5388 | 1649368.0 |
| 2004-08-09 12:55:00 | AAPL | Stock | 0.5388 | 0.5398 | 0.5388 | 0.5395 | 4493664.0 |
| 2004-08-09 13:00:00 | AAPL | Stock | 0.5395 | 0.5409 | 0.5395 | 0.5402 | 5863928.0 |
| 2004-08-09 13:05:00 | AAPL | Stock | 0.5402 | 0.5416 | 0.5402 | 0.5416 | 2338224.0 |
> showing 50 of 176,968 rows — these rows as CSV