PREVIEW / stock_5min / 2012-09-11
file: by_date/stock_5min/2012/2012-09-11.parquet size: 4.6 MB rows: 311,604 symbols: 3,470
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-11 04:00:00 | AAPL | Stock | 23.6261 | 23.6357 | 23.6261 | 23.6357 | 56840.0 |
| 2012-09-11 04:05:00 | AAPL | Stock | 23.6357 | 23.6429 | 23.6357 | 23.6429 | 46116.0 |
| 2012-09-11 04:10:00 | AAPL | Stock | 23.6393 | 23.6393 | 23.6393 | 23.6393 | 8400.0 |
| 2012-09-11 04:15:00 | AAPL | Stock | 23.6393 | 23.6393 | 23.6393 | 23.6393 | 5600.0 |
| 2012-09-11 04:30:00 | AAPL | Stock | 23.6554 | 23.6554 | 23.6554 | 23.6554 | 2800.0 |
| 2012-09-11 04:45:00 | AAPL | Stock | 23.6743 | 23.6743 | 23.6743 | 23.6743 | 19600.0 |
| 2012-09-11 04:50:00 | AAPL | Stock | 23.6743 | 23.6743 | 23.6743 | 23.6743 | 22288.0 |
| 2012-09-11 04:55:00 | AAPL | Stock | 23.6786 | 23.6786 | 23.6786 | 23.6786 | 19600.0 |
| 2012-09-11 05:15:00 | AAPL | Stock | 23.6964 | 23.6964 | 23.6964 | 23.6964 | 9520.0 |
| 2012-09-11 05:20:00 | AAPL | Stock | 23.6986 | 23.6986 | 23.6986 | 23.6986 | 2800.0 |
| 2012-09-11 05:25:00 | AAPL | Stock | 23.6789 | 23.7196 | 23.6789 | 23.7196 | 26600.0 |
| 2012-09-11 05:35:00 | AAPL | Stock | 23.7107 | 23.7107 | 23.7071 | 23.7071 | 28000.0 |
| 2012-09-11 05:45:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 2800.0 |
| 2012-09-11 05:55:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 2800.0 |
| 2012-09-11 06:00:00 | AAPL | Stock | 23.6893 | 23.6893 | 23.6893 | 23.6893 | 5600.0 |
| 2012-09-11 06:05:00 | AAPL | Stock | 23.6893 | 23.6893 | 23.6786 | 23.6786 | 29596.0 |
| 2012-09-11 06:10:00 | AAPL | Stock | 23.6786 | 23.6786 | 23.6786 | 23.6786 | 2800.0 |
| 2012-09-11 06:25:00 | AAPL | Stock | 23.7143 | 23.7279 | 23.7143 | 23.7279 | 19600.0 |
| 2012-09-11 06:30:00 | AAPL | Stock | 23.7411 | 23.7411 | 23.7411 | 23.7411 | 2800.0 |
| 2012-09-11 06:35:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7143 | 23.7321 | 27160.0 |
| 2012-09-11 06:40:00 | AAPL | Stock | 23.7321 | 23.745 | 23.7321 | 23.745 | 11200.0 |
| 2012-09-11 06:45:00 | AAPL | Stock | 23.75 | 23.75 | 23.7411 | 23.7411 | 8400.0 |
| 2012-09-11 06:50:00 | AAPL | Stock | 23.7321 | 23.7321 | 23.7321 | 23.7321 | 2800.0 |
| 2012-09-11 06:55:00 | AAPL | Stock | 23.7446 | 23.7446 | 23.7446 | 23.7446 | 5600.0 |
| 2012-09-11 07:00:00 | AAPL | Stock | 23.7464 | 23.7693 | 23.7321 | 23.75 | 90160.0 |
| 2012-09-11 07:05:00 | AAPL | Stock | 23.7504 | 23.7604 | 23.7339 | 23.7339 | 57400.0 |
| 2012-09-11 07:10:00 | AAPL | Stock | 23.7393 | 23.7393 | 23.7143 | 23.7232 | 33796.0 |
| 2012-09-11 07:15:00 | AAPL | Stock | 23.7214 | 23.7304 | 23.7214 | 23.7304 | 9240.0 |
| 2012-09-11 07:20:00 | AAPL | Stock | 23.7325 | 23.75 | 23.7293 | 23.75 | 56420.0 |
| 2012-09-11 07:25:00 | AAPL | Stock | 23.7439 | 23.7439 | 23.7314 | 23.7379 | 105560.0 |
| 2012-09-11 07:30:00 | AAPL | Stock | 23.7321 | 23.7414 | 23.7314 | 23.7329 | 91308.0 |
| 2012-09-11 07:35:00 | AAPL | Stock | 23.7407 | 23.75 | 23.7361 | 23.75 | 85372.0 |
| 2012-09-11 07:40:00 | AAPL | Stock | 23.75 | 23.7568 | 23.7446 | 23.7454 | 146720.0 |
| 2012-09-11 07:45:00 | AAPL | Stock | 23.7496 | 23.7675 | 23.7496 | 23.7539 | 169064.0 |
| 2012-09-11 07:50:00 | AAPL | Stock | 23.7539 | 23.785 | 23.7529 | 23.785 | 204876.0 |
| 2012-09-11 07:55:00 | AAPL | Stock | 23.7811 | 23.7946 | 23.7768 | 23.7936 | 169820.0 |
| 2012-09-11 08:00:00 | AAPL | Stock | 23.7921 | 23.8375 | 23.7314 | 23.8304 | 1226456.0 |
| 2012-09-11 08:05:00 | AAPL | Stock | 23.8304 | 23.8714 | 23.825 | 23.8268 | 913472.0 |
| 2012-09-11 08:10:00 | AAPL | Stock | 23.8268 | 23.8393 | 23.8211 | 23.8304 | 408408.0 |
| 2012-09-11 08:15:00 | AAPL | Stock | 23.8232 | 23.8304 | 23.8136 | 23.8218 | 259420.0 |
| 2012-09-11 08:20:00 | AAPL | Stock | 23.8214 | 23.8214 | 23.8036 | 23.8125 | 280364.0 |
| 2012-09-11 08:25:00 | AAPL | Stock | 23.8093 | 23.8125 | 23.7911 | 23.8018 | 300524.0 |
| 2012-09-11 08:30:00 | AAPL | Stock | 23.7936 | 23.7986 | 23.7654 | 23.7682 | 466032.0 |
| 2012-09-11 08:35:00 | AAPL | Stock | 23.78 | 23.7854 | 23.775 | 23.7854 | 94388.0 |
| 2012-09-11 08:40:00 | AAPL | Stock | 23.7854 | 23.7854 | 23.7543 | 23.7571 | 215292.0 |
| 2012-09-11 08:45:00 | AAPL | Stock | 23.7571 | 23.7582 | 23.7325 | 23.7393 | 762468.0 |
| 2012-09-11 08:50:00 | AAPL | Stock | 23.7429 | 23.7675 | 23.7375 | 23.7643 | 247016.0 |
| 2012-09-11 08:55:00 | AAPL | Stock | 23.7718 | 23.775 | 23.7339 | 23.7679 | 361256.0 |
| 2012-09-11 09:00:00 | AAPL | Stock | 23.7711 | 23.7711 | 23.7464 | 23.76 | 172396.0 |
| 2012-09-11 09:05:00 | AAPL | Stock | 23.7607 | 23.775 | 23.7607 | 23.7611 | 84840.0 |
> showing 50 of 311,604 rows — these rows as CSV