PREVIEW / stock_5min / 2010-10-13
file: by_date/stock_5min/2010/2010-10-13.parquet size: 4.9 MB rows: 334,607 symbols: 3,502
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-13 04:25:00 | AAPL | Stock | 10.7257 | 10.7257 | 10.7257 | 10.7257 | 4340.0 |
| 2010-10-13 04:30:00 | AAPL | Stock | 10.7339 | 10.7339 | 10.7339 | 10.7339 | 5600.0 |
| 2010-10-13 05:15:00 | AAPL | Stock | 10.7679 | 10.7679 | 10.7679 | 10.7679 | 4200.0 |
| 2010-10-13 06:10:00 | AAPL | Stock | 10.7621 | 10.7621 | 10.7621 | 10.7621 | 9884.0 |
| 2010-10-13 07:00:00 | AAPL | Stock | 10.7596 | 10.7596 | 10.7286 | 10.7321 | 18760.0 |
| 2010-10-13 07:05:00 | AAPL | Stock | 10.7332 | 10.7332 | 10.7254 | 10.7254 | 38640.0 |
| 2010-10-13 07:10:00 | AAPL | Stock | 10.7218 | 10.725 | 10.7143 | 10.715 | 26544.0 |
| 2010-10-13 07:15:00 | AAPL | Stock | 10.725 | 10.725 | 10.725 | 10.725 | 47600.0 |
| 2010-10-13 07:20:00 | AAPL | Stock | 10.725 | 10.725 | 10.7179 | 10.725 | 50120.0 |
| 2010-10-13 07:25:00 | AAPL | Stock | 10.7268 | 10.7304 | 10.7268 | 10.7304 | 15680.0 |
| 2010-10-13 07:30:00 | AAPL | Stock | 10.7354 | 10.75 | 10.7321 | 10.7357 | 105812.0 |
| 2010-10-13 07:35:00 | AAPL | Stock | 10.7321 | 10.7357 | 10.7268 | 10.7268 | 88256.0 |
| 2010-10-13 07:40:00 | AAPL | Stock | 10.7268 | 10.7357 | 10.7268 | 10.7357 | 61964.0 |
| 2010-10-13 07:45:00 | AAPL | Stock | 10.7357 | 10.7639 | 10.7314 | 10.7639 | 341600.0 |
| 2010-10-13 07:50:00 | AAPL | Stock | 10.7639 | 10.7743 | 10.7618 | 10.7679 | 426888.0 |
| 2010-10-13 07:55:00 | AAPL | Stock | 10.7625 | 10.7625 | 10.7468 | 10.7468 | 261324.0 |
| 2010-10-13 08:00:00 | AAPL | Stock | 10.7468 | 10.7714 | 10.725 | 10.7654 | 1365140.0 |
| 2010-10-13 08:05:00 | AAPL | Stock | 10.7607 | 10.7643 | 10.755 | 10.7625 | 1017100.0 |
| 2010-10-13 08:10:00 | AAPL | Stock | 10.7625 | 10.7679 | 10.7604 | 10.7604 | 334628.0 |
| 2010-10-13 08:15:00 | AAPL | Stock | 10.7607 | 10.7618 | 10.7571 | 10.7604 | 283612.0 |
| 2010-10-13 08:20:00 | AAPL | Stock | 10.76 | 10.7621 | 10.7536 | 10.755 | 446628.0 |
| 2010-10-13 08:25:00 | AAPL | Stock | 10.7557 | 10.7604 | 10.7496 | 10.7571 | 372540.0 |
| 2010-10-13 08:30:00 | AAPL | Stock | 10.7571 | 10.7604 | 10.7536 | 10.7586 | 276500.0 |
| 2010-10-13 08:35:00 | AAPL | Stock | 10.7579 | 10.7596 | 10.7546 | 10.7568 | 282016.0 |
| 2010-10-13 08:40:00 | AAPL | Stock | 10.7571 | 10.7607 | 10.7554 | 10.7596 | 264040.0 |
| 2010-10-13 08:45:00 | AAPL | Stock | 10.7596 | 10.7596 | 10.7525 | 10.7554 | 307300.0 |
| 2010-10-13 08:50:00 | AAPL | Stock | 10.7575 | 10.7607 | 10.7429 | 10.7429 | 799568.0 |
| 2010-10-13 08:55:00 | AAPL | Stock | 10.7482 | 10.7486 | 10.7371 | 10.7486 | 428876.0 |
| 2010-10-13 09:00:00 | AAPL | Stock | 10.7482 | 10.7482 | 10.7429 | 10.7429 | 225400.0 |
| 2010-10-13 09:05:00 | AAPL | Stock | 10.7429 | 10.7446 | 10.7336 | 10.7357 | 604352.0 |
| 2010-10-13 09:10:00 | AAPL | Stock | 10.7371 | 10.7429 | 10.7357 | 10.7411 | 501228.0 |
| 2010-10-13 09:15:00 | AAPL | Stock | 10.7418 | 10.7418 | 10.7286 | 10.7361 | 300720.0 |
| 2010-10-13 09:20:00 | AAPL | Stock | 10.7357 | 10.7464 | 10.7339 | 10.7429 | 405244.0 |
| 2010-10-13 09:25:00 | AAPL | Stock | 10.7425 | 10.7425 | 10.7143 | 10.7179 | 1583596.0 |
| 2010-10-13 09:30:00 | AAPL | Stock | 10.7214 | 10.7425 | 10.7143 | 10.7264 | 28932624.0 |
| 2010-10-13 09:35:00 | AAPL | Stock | 10.7271 | 10.7485 | 10.7196 | 10.7296 | 18579372.0 |
| 2010-10-13 09:40:00 | AAPL | Stock | 10.7293 | 10.7411 | 10.7239 | 10.7396 | 13558608.0 |
| 2010-10-13 09:45:00 | AAPL | Stock | 10.7392 | 10.7757 | 10.7368 | 10.775 | 21024612.0 |
| 2010-10-13 09:50:00 | AAPL | Stock | 10.775 | 10.7757 | 10.7589 | 10.7625 | 14450604.0 |
| 2010-10-13 09:55:00 | AAPL | Stock | 10.7625 | 10.77 | 10.7571 | 10.7586 | 9509052.0 |
| 2010-10-13 10:00:00 | AAPL | Stock | 10.7589 | 10.7711 | 10.7554 | 10.7668 | 11890284.0 |
| 2010-10-13 10:05:00 | AAPL | Stock | 10.7675 | 10.7693 | 10.7589 | 10.7646 | 8454824.0 |
| 2010-10-13 10:10:00 | AAPL | Stock | 10.7651 | 10.7693 | 10.7575 | 10.7654 | 8908788.0 |
| 2010-10-13 10:15:00 | AAPL | Stock | 10.7654 | 10.7779 | 10.7375 | 10.7439 | 16155748.0 |
| 2010-10-13 10:20:00 | AAPL | Stock | 10.7439 | 10.7561 | 10.7325 | 10.7518 | 10439408.0 |
| 2010-10-13 10:25:00 | AAPL | Stock | 10.7518 | 10.7618 | 10.7489 | 10.7536 | 6267744.0 |
| 2010-10-13 10:30:00 | AAPL | Stock | 10.7529 | 10.7571 | 10.7411 | 10.7532 | 4909408.0 |
| 2010-10-13 10:35:00 | AAPL | Stock | 10.7516 | 10.7604 | 10.75 | 10.7546 | 5771976.0 |
| 2010-10-13 10:40:00 | AAPL | Stock | 10.7557 | 10.7587 | 10.7475 | 10.7496 | 4386340.0 |
| 2010-10-13 10:45:00 | AAPL | Stock | 10.75 | 10.7529 | 10.7386 | 10.7404 | 5107004.0 |
> showing 50 of 334,607 rows — these rows as CSV