PREVIEW / stock_5min / 2013-01-08
file: by_date/stock_5min/2013/2013-01-08.parquet size: 4.9 MB rows: 330,457 symbols: 3,448
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-08 04:55:00 | AAPL | Stock | 18.6743 | 18.6743 | 18.6743 | 18.6743 | 2800.0 |
| 2013-01-08 05:00:00 | AAPL | Stock | 18.6864 | 18.6864 | 18.6864 | 18.6864 | 2800.0 |
| 2013-01-08 05:35:00 | AAPL | Stock | 18.6911 | 18.6911 | 18.6911 | 18.6911 | 12600.0 |
| 2013-01-08 05:45:00 | AAPL | Stock | 18.7139 | 18.7139 | 18.7139 | 18.7139 | 5600.0 |
| 2013-01-08 05:55:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 27468.0 |
| 2013-01-08 06:10:00 | AAPL | Stock | 18.7325 | 18.7325 | 18.7325 | 18.7325 | 8400.0 |
| 2013-01-08 06:20:00 | AAPL | Stock | 18.7393 | 18.7393 | 18.7393 | 18.7393 | 2800.0 |
| 2013-01-08 06:25:00 | AAPL | Stock | 18.7386 | 18.7493 | 18.7386 | 18.7493 | 18200.0 |
| 2013-01-08 06:45:00 | AAPL | Stock | 18.7514 | 18.7514 | 18.7514 | 18.7514 | 2800.0 |
| 2013-01-08 06:50:00 | AAPL | Stock | 18.765 | 18.8214 | 18.765 | 18.8214 | 43036.0 |
| 2013-01-08 06:55:00 | AAPL | Stock | 18.8161 | 18.8161 | 18.7929 | 18.7929 | 5600.0 |
| 2013-01-08 07:00:00 | AAPL | Stock | 18.7846 | 18.8107 | 18.7839 | 18.7839 | 156212.0 |
| 2013-01-08 07:05:00 | AAPL | Stock | 18.7775 | 18.7775 | 18.7321 | 18.7321 | 69664.0 |
| 2013-01-08 07:10:00 | AAPL | Stock | 18.7343 | 18.75 | 18.7343 | 18.7371 | 36400.0 |
| 2013-01-08 07:15:00 | AAPL | Stock | 18.7371 | 18.7429 | 18.7143 | 18.7429 | 53200.0 |
| 2013-01-08 07:20:00 | AAPL | Stock | 18.7321 | 18.7496 | 18.7321 | 18.7493 | 28084.0 |
| 2013-01-08 07:25:00 | AAPL | Stock | 18.7343 | 18.7704 | 18.7343 | 18.75 | 98000.0 |
| 2013-01-08 07:30:00 | AAPL | Stock | 18.7386 | 18.7489 | 18.7386 | 18.7411 | 24500.0 |
| 2013-01-08 07:35:00 | AAPL | Stock | 18.7411 | 18.75 | 18.7411 | 18.7496 | 44800.0 |
| 2013-01-08 07:40:00 | AAPL | Stock | 18.7504 | 18.7625 | 18.7504 | 18.7625 | 19040.0 |
| 2013-01-08 07:45:00 | AAPL | Stock | 18.7618 | 18.77 | 18.7539 | 18.7632 | 110768.0 |
| 2013-01-08 07:50:00 | AAPL | Stock | 18.7586 | 18.7621 | 18.7575 | 18.7575 | 8960.0 |
| 2013-01-08 07:55:00 | AAPL | Stock | 18.7589 | 18.7589 | 18.7543 | 18.7543 | 5600.0 |
| 2013-01-08 08:00:00 | AAPL | Stock | 18.7539 | 18.8025 | 18.725 | 18.7646 | 87780.0 |
| 2013-01-08 08:05:00 | AAPL | Stock | 18.7654 | 18.7696 | 18.7629 | 18.7629 | 42420.0 |
| 2013-01-08 08:10:00 | AAPL | Stock | 18.7661 | 18.7679 | 18.7629 | 18.7679 | 39200.0 |
| 2013-01-08 08:15:00 | AAPL | Stock | 18.7675 | 18.7679 | 18.75 | 18.755 | 62720.0 |
| 2013-01-08 08:20:00 | AAPL | Stock | 18.7539 | 18.7671 | 18.7539 | 18.7539 | 29512.0 |
| 2013-01-08 08:25:00 | AAPL | Stock | 18.7671 | 18.7771 | 18.7625 | 18.775 | 50400.0 |
| 2013-01-08 08:30:00 | AAPL | Stock | 18.7679 | 18.955 | 18.7679 | 18.9446 | 1999564.0 |
| 2013-01-08 08:35:00 | AAPL | Stock | 18.9364 | 18.9911 | 18.9061 | 18.9604 | 1643544.0 |
| 2013-01-08 08:40:00 | AAPL | Stock | 18.9536 | 18.9629 | 18.9039 | 18.9186 | 651504.0 |
| 2013-01-08 08:45:00 | AAPL | Stock | 18.9136 | 18.9286 | 18.8839 | 18.8968 | 709632.0 |
| 2013-01-08 08:50:00 | AAPL | Stock | 18.9036 | 18.9171 | 18.8921 | 18.8921 | 451668.0 |
| 2013-01-08 08:55:00 | AAPL | Stock | 18.8864 | 18.9054 | 18.8754 | 18.9054 | 462728.0 |
| 2013-01-08 09:00:00 | AAPL | Stock | 18.9054 | 18.9054 | 18.8643 | 18.8786 | 378308.0 |
| 2013-01-08 09:05:00 | AAPL | Stock | 18.8821 | 18.8825 | 18.8393 | 18.8393 | 382900.0 |
| 2013-01-08 09:10:00 | AAPL | Stock | 18.8393 | 18.8746 | 18.835 | 18.8668 | 362740.0 |
| 2013-01-08 09:15:00 | AAPL | Stock | 18.8686 | 18.8921 | 18.8614 | 18.875 | 449260.0 |
| 2013-01-08 09:20:00 | AAPL | Stock | 18.8754 | 18.8929 | 18.875 | 18.8839 | 284480.0 |
| 2013-01-08 09:25:00 | AAPL | Stock | 18.8775 | 18.9054 | 18.8418 | 18.9014 | 691488.0 |
| 2013-01-08 09:30:00 | AAPL | Stock | 18.9 | 18.9232 | 18.8089 | 18.92 | 20048196.0 |
| 2013-01-08 09:35:00 | AAPL | Stock | 18.9207 | 18.9961 | 18.8825 | 18.9768 | 20173720.0 |
| 2013-01-08 09:40:00 | AAPL | Stock | 18.9725 | 18.9861 | 18.8836 | 18.9311 | 11386788.0 |
| 2013-01-08 09:45:00 | AAPL | Stock | 18.9332 | 18.9381 | 18.8404 | 18.875 | 10366608.0 |
| 2013-01-08 09:50:00 | AAPL | Stock | 18.8711 | 18.8879 | 18.8057 | 18.8643 | 10769024.0 |
| 2013-01-08 09:55:00 | AAPL | Stock | 18.8657 | 18.8696 | 18.7657 | 18.7905 | 10564036.0 |
| 2013-01-08 10:00:00 | AAPL | Stock | 18.7864 | 18.8318 | 18.7643 | 18.8039 | 9283372.0 |
| 2013-01-08 10:05:00 | AAPL | Stock | 18.8111 | 18.8525 | 18.7879 | 18.8496 | 7572208.0 |
| 2013-01-08 10:10:00 | AAPL | Stock | 18.8471 | 18.85 | 18.7321 | 18.7343 | 9314228.0 |
> showing 50 of 330,457 rows — these rows as CSV