PREVIEW / stock_5min / 2004-07-09
file: by_date/stock_5min/2004/2004-07-09.parquet size: 2.3 MB rows: 169,961 symbols: 1,803
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-07-09 08:15:00 | AAPL | Stock | 0.5429 | 0.5429 | 0.5429 | 0.5429 | 39200.0 |
| 2004-07-09 08:20:00 | AAPL | Stock | 0.5405 | 0.5405 | 0.5405 | 0.5405 | 16800.0 |
| 2004-07-09 08:30:00 | AAPL | Stock | 0.5405 | 0.5405 | 0.5405 | 0.5405 | 28000.0 |
| 2004-07-09 08:35:00 | AAPL | Stock | 0.5405 | 0.5405 | 0.5405 | 0.5405 | 218400.0 |
| 2004-07-09 08:40:00 | AAPL | Stock | 0.5402 | 0.5405 | 0.5402 | 0.5405 | 22400.0 |
| 2004-07-09 08:50:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5413 | 0.5413 | 5600.0 |
| 2004-07-09 09:05:00 | AAPL | Stock | 0.5411 | 0.542 | 0.5411 | 0.5411 | 50400.0 |
| 2004-07-09 09:10:00 | AAPL | Stock | 0.5404 | 0.5404 | 0.5404 | 0.5404 | 5600.0 |
| 2004-07-09 09:20:00 | AAPL | Stock | 0.5405 | 0.542 | 0.5405 | 0.542 | 117600.0 |
| 2004-07-09 09:25:00 | AAPL | Stock | 0.5411 | 0.542 | 0.5404 | 0.5405 | 50400.0 |
| 2004-07-09 09:30:00 | AAPL | Stock | 0.5405 | 0.5446 | 0.5393 | 0.5446 | 6000120.0 |
| 2004-07-09 09:35:00 | AAPL | Stock | 0.5445 | 0.5446 | 0.5427 | 0.543 | 3733072.0 |
| 2004-07-09 09:40:00 | AAPL | Stock | 0.543 | 0.5436 | 0.5429 | 0.5429 | 1636040.0 |
| 2004-07-09 09:45:00 | AAPL | Stock | 0.5429 | 0.5432 | 0.5418 | 0.5421 | 1382584.0 |
| 2004-07-09 09:50:00 | AAPL | Stock | 0.5418 | 0.5421 | 0.5411 | 0.5419 | 2856056.0 |
| 2004-07-09 09:55:00 | AAPL | Stock | 0.5419 | 0.542 | 0.5405 | 0.5407 | 2366224.0 |
| 2004-07-09 10:00:00 | AAPL | Stock | 0.5407 | 0.5407 | 0.5386 | 0.5404 | 4299400.0 |
| 2004-07-09 10:05:00 | AAPL | Stock | 0.5404 | 0.5418 | 0.5395 | 0.5407 | 2764776.0 |
| 2004-07-09 10:10:00 | AAPL | Stock | 0.5407 | 0.542 | 0.54 | 0.5414 | 1913352.0 |
| 2004-07-09 10:15:00 | AAPL | Stock | 0.5414 | 0.5416 | 0.5411 | 0.5411 | 2176944.0 |
| 2004-07-09 10:20:00 | AAPL | Stock | 0.5411 | 0.5427 | 0.5409 | 0.5421 | 1766520.0 |
| 2004-07-09 10:25:00 | AAPL | Stock | 0.542 | 0.5421 | 0.5402 | 0.5405 | 1248688.0 |
| 2004-07-09 10:30:00 | AAPL | Stock | 0.5405 | 0.542 | 0.5405 | 0.542 | 940688.0 |
| 2004-07-09 10:35:00 | AAPL | Stock | 0.5418 | 0.542 | 0.5411 | 0.5416 | 515424.0 |
| 2004-07-09 10:40:00 | AAPL | Stock | 0.5418 | 0.5418 | 0.5391 | 0.5395 | 1596616.0 |
| 2004-07-09 10:45:00 | AAPL | Stock | 0.5391 | 0.54 | 0.5391 | 0.54 | 1105440.0 |
| 2004-07-09 10:50:00 | AAPL | Stock | 0.54 | 0.5407 | 0.5393 | 0.5402 | 1446872.0 |
| 2004-07-09 10:55:00 | AAPL | Stock | 0.5402 | 0.5402 | 0.5388 | 0.5388 | 855344.0 |
| 2004-07-09 11:00:00 | AAPL | Stock | 0.5389 | 0.5409 | 0.5388 | 0.5407 | 1731912.0 |
| 2004-07-09 11:05:00 | AAPL | Stock | 0.5411 | 0.5416 | 0.5404 | 0.5409 | 1889272.0 |
| 2004-07-09 11:10:00 | AAPL | Stock | 0.5414 | 0.5423 | 0.5413 | 0.5413 | 1115968.0 |
| 2004-07-09 11:15:00 | AAPL | Stock | 0.5413 | 0.5427 | 0.5411 | 0.5414 | 2214352.0 |
| 2004-07-09 11:20:00 | AAPL | Stock | 0.5416 | 0.5439 | 0.5414 | 0.5434 | 2577624.0 |
| 2004-07-09 11:25:00 | AAPL | Stock | 0.5434 | 0.5438 | 0.5425 | 0.5438 | 2149168.0 |
| 2004-07-09 11:30:00 | AAPL | Stock | 0.5438 | 0.5441 | 0.5436 | 0.5438 | 2027592.0 |
| 2004-07-09 11:35:00 | AAPL | Stock | 0.5438 | 0.5438 | 0.5436 | 0.5436 | 909720.0 |
| 2004-07-09 11:40:00 | AAPL | Stock | 0.5436 | 0.5439 | 0.5434 | 0.5436 | 1323000.0 |
| 2004-07-09 11:45:00 | AAPL | Stock | 0.5436 | 0.5441 | 0.543 | 0.5434 | 1585192.0 |
| 2004-07-09 11:50:00 | AAPL | Stock | 0.5434 | 0.5434 | 0.5407 | 0.5429 | 2053296.0 |
| 2004-07-09 11:55:00 | AAPL | Stock | 0.5427 | 0.5427 | 0.5421 | 0.5425 | 887040.0 |
| 2004-07-09 12:00:00 | AAPL | Stock | 0.5423 | 0.5425 | 0.5416 | 0.5416 | 654808.0 |
| 2004-07-09 12:05:00 | AAPL | Stock | 0.5418 | 0.5423 | 0.5407 | 0.5409 | 1231160.0 |
| 2004-07-09 12:10:00 | AAPL | Stock | 0.5411 | 0.5425 | 0.5409 | 0.5423 | 924504.0 |
| 2004-07-09 12:15:00 | AAPL | Stock | 0.5421 | 0.5425 | 0.542 | 0.5421 | 705320.0 |
| 2004-07-09 12:20:00 | AAPL | Stock | 0.5421 | 0.5425 | 0.5416 | 0.5416 | 539952.0 |
| 2004-07-09 12:25:00 | AAPL | Stock | 0.5416 | 0.542 | 0.5413 | 0.5418 | 589400.0 |
| 2004-07-09 12:30:00 | AAPL | Stock | 0.542 | 0.542 | 0.5418 | 0.542 | 558656.0 |
| 2004-07-09 12:35:00 | AAPL | Stock | 0.5421 | 0.5425 | 0.5411 | 0.5425 | 1548120.0 |
| 2004-07-09 12:40:00 | AAPL | Stock | 0.5421 | 0.5429 | 0.5421 | 0.5429 | 1952608.0 |
| 2004-07-09 12:45:00 | AAPL | Stock | 0.5427 | 0.5429 | 0.5425 | 0.5429 | 1036056.0 |
> showing 50 of 169,961 rows — these rows as CSV