PREVIEW / stock_5min / 2005-08-03
file: by_date/stock_5min/2005/2005-08-03.parquet size: 2.7 MB rows: 202,130 symbols: 2,053
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-03 08:05:00 | AAPL | Stock | 1.5425 | 1.5436 | 1.5425 | 1.5436 | 39200.0 |
| 2005-08-03 08:10:00 | AAPL | Stock | 1.5464 | 1.5464 | 1.5464 | 1.5464 | 28000.0 |
| 2005-08-03 08:15:00 | AAPL | Stock | 1.5436 | 1.5436 | 1.5436 | 1.5436 | 28000.0 |
| 2005-08-03 08:40:00 | AAPL | Stock | 1.5389 | 1.5389 | 1.5389 | 1.5389 | 2800.0 |
| 2005-08-03 08:55:00 | AAPL | Stock | 1.5429 | 1.5461 | 1.5429 | 1.5461 | 84000.0 |
| 2005-08-03 09:00:00 | AAPL | Stock | 1.5436 | 1.5436 | 1.5436 | 1.5436 | 2800.0 |
| 2005-08-03 09:05:00 | AAPL | Stock | 1.5396 | 1.5396 | 1.5365 | 1.5389 | 1970724.0 |
| 2005-08-03 09:10:00 | AAPL | Stock | 1.5389 | 1.5389 | 1.5389 | 1.5389 | 49868.0 |
| 2005-08-03 09:20:00 | AAPL | Stock | 1.5418 | 1.5425 | 1.5418 | 1.5425 | 84000.0 |
| 2005-08-03 09:25:00 | AAPL | Stock | 1.5411 | 1.5446 | 1.5379 | 1.5429 | 287000.0 |
| 2005-08-03 09:30:00 | AAPL | Stock | 1.5425 | 1.5436 | 1.5321 | 1.5336 | 7800296.0 |
| 2005-08-03 09:35:00 | AAPL | Stock | 1.5339 | 1.5389 | 1.5321 | 1.5361 | 6954836.0 |
| 2005-08-03 09:40:00 | AAPL | Stock | 1.5361 | 1.5368 | 1.5336 | 1.5346 | 5905956.0 |
| 2005-08-03 09:45:00 | AAPL | Stock | 1.5346 | 1.5375 | 1.5339 | 1.5375 | 2354268.0 |
| 2005-08-03 09:50:00 | AAPL | Stock | 1.5375 | 1.5393 | 1.5357 | 1.5375 | 3646972.0 |
| 2005-08-03 09:55:00 | AAPL | Stock | 1.5375 | 1.5375 | 1.5293 | 1.5296 | 4518892.0 |
| 2005-08-03 10:00:00 | AAPL | Stock | 1.5296 | 1.5346 | 1.5275 | 1.5307 | 6487544.0 |
| 2005-08-03 10:05:00 | AAPL | Stock | 1.5304 | 1.5361 | 1.53 | 1.5361 | 5109440.0 |
| 2005-08-03 10:10:00 | AAPL | Stock | 1.5364 | 1.5404 | 1.5343 | 1.5396 | 5704552.0 |
| 2005-08-03 10:15:00 | AAPL | Stock | 1.5396 | 1.5446 | 1.5386 | 1.5439 | 7100856.0 |
| 2005-08-03 10:20:00 | AAPL | Stock | 1.5443 | 1.5468 | 1.5404 | 1.5414 | 6844320.0 |
| 2005-08-03 10:25:00 | AAPL | Stock | 1.5414 | 1.5418 | 1.5386 | 1.5407 | 2995496.0 |
| 2005-08-03 10:30:00 | AAPL | Stock | 1.54 | 1.5411 | 1.5325 | 1.5354 | 5496848.0 |
| 2005-08-03 10:35:00 | AAPL | Stock | 1.5354 | 1.5393 | 1.5354 | 1.5371 | 1534736.0 |
| 2005-08-03 10:40:00 | AAPL | Stock | 1.5375 | 1.5411 | 1.5361 | 1.5411 | 3257576.0 |
| 2005-08-03 10:45:00 | AAPL | Stock | 1.5414 | 1.5429 | 1.5386 | 1.5411 | 5948684.0 |
| 2005-08-03 10:50:00 | AAPL | Stock | 1.5411 | 1.5421 | 1.5379 | 1.5386 | 3806292.0 |
| 2005-08-03 10:55:00 | AAPL | Stock | 1.5389 | 1.5396 | 1.5364 | 1.5379 | 4910640.0 |
| 2005-08-03 11:00:00 | AAPL | Stock | 1.5379 | 1.5407 | 1.5375 | 1.5386 | 2879128.0 |
| 2005-08-03 11:05:00 | AAPL | Stock | 1.5389 | 1.5389 | 1.5368 | 1.5368 | 2631328.0 |
| 2005-08-03 11:10:00 | AAPL | Stock | 1.5368 | 1.5386 | 1.5357 | 1.5371 | 2224264.0 |
| 2005-08-03 11:15:00 | AAPL | Stock | 1.5375 | 1.5389 | 1.5364 | 1.5379 | 2862356.0 |
| 2005-08-03 11:20:00 | AAPL | Stock | 1.5375 | 1.5379 | 1.5357 | 1.5379 | 1926652.0 |
| 2005-08-03 11:25:00 | AAPL | Stock | 1.5382 | 1.5386 | 1.5361 | 1.5375 | 1656396.0 |
| 2005-08-03 11:30:00 | AAPL | Stock | 1.5376 | 1.5389 | 1.5364 | 1.5371 | 1208620.0 |
| 2005-08-03 11:35:00 | AAPL | Stock | 1.5368 | 1.5382 | 1.5361 | 1.5382 | 1166900.0 |
| 2005-08-03 11:40:00 | AAPL | Stock | 1.5382 | 1.5382 | 1.5346 | 1.5346 | 2350460.0 |
| 2005-08-03 11:45:00 | AAPL | Stock | 1.5346 | 1.5357 | 1.5339 | 1.535 | 499464.0 |
| 2005-08-03 11:50:00 | AAPL | Stock | 1.5346 | 1.5361 | 1.5343 | 1.5361 | 693280.0 |
| 2005-08-03 11:55:00 | AAPL | Stock | 1.5357 | 1.5361 | 1.5332 | 1.5354 | 1894732.0 |
| 2005-08-03 12:00:00 | AAPL | Stock | 1.535 | 1.5375 | 1.535 | 1.5368 | 1082368.0 |
| 2005-08-03 12:05:00 | AAPL | Stock | 1.5368 | 1.5396 | 1.5368 | 1.5393 | 1817620.0 |
| 2005-08-03 12:10:00 | AAPL | Stock | 1.5396 | 1.5396 | 1.5375 | 1.5375 | 1046472.0 |
| 2005-08-03 12:15:00 | AAPL | Stock | 1.5379 | 1.5389 | 1.5375 | 1.5389 | 437584.0 |
| 2005-08-03 12:20:00 | AAPL | Stock | 1.5389 | 1.5429 | 1.5389 | 1.5421 | 2218132.0 |
| 2005-08-03 12:25:00 | AAPL | Stock | 1.5425 | 1.5425 | 1.54 | 1.5411 | 2266292.0 |
| 2005-08-03 12:30:00 | AAPL | Stock | 1.5407 | 1.5414 | 1.5404 | 1.5411 | 839608.0 |
| 2005-08-03 12:35:00 | AAPL | Stock | 1.5411 | 1.5411 | 1.5393 | 1.5393 | 787920.0 |
| 2005-08-03 12:40:00 | AAPL | Stock | 1.5393 | 1.5407 | 1.5371 | 1.54 | 1535660.0 |
| 2005-08-03 12:45:00 | AAPL | Stock | 1.54 | 1.5407 | 1.54 | 1.5404 | 812364.0 |
> showing 50 of 202,130 rows — these rows as CSV