PREVIEW / stock_5min / 2010-08-16
file: by_date/stock_5min/2010/2010-08-16.parquet size: 4.6 MB rows: 320,240 symbols: 3,482
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-08-16 06:10:00 | AAPL | Stock | 8.8964 | 8.8964 | 8.8964 | 8.8964 | 2800.0 |
| 2010-08-16 06:35:00 | AAPL | Stock | 8.9107 | 8.9107 | 8.9107 | 8.9107 | 2800.0 |
| 2010-08-16 07:00:00 | AAPL | Stock | 8.9107 | 8.9107 | 8.9107 | 8.9107 | 2800.0 |
| 2010-08-16 07:05:00 | AAPL | Stock | 8.9079 | 8.9079 | 8.9079 | 8.9079 | 2800.0 |
| 2010-08-16 07:10:00 | AAPL | Stock | 8.8821 | 8.8821 | 8.8821 | 8.8821 | 5600.0 |
| 2010-08-16 07:20:00 | AAPL | Stock | 8.8679 | 8.8821 | 8.8679 | 8.8821 | 8400.0 |
| 2010-08-16 07:40:00 | AAPL | Stock | 8.8711 | 8.8711 | 8.8575 | 8.8679 | 11284.0 |
| 2010-08-16 07:45:00 | AAPL | Stock | 8.8636 | 8.8636 | 8.8571 | 8.8571 | 43568.0 |
| 2010-08-16 07:50:00 | AAPL | Stock | 8.8564 | 8.8571 | 8.8564 | 8.8571 | 15484.0 |
| 2010-08-16 07:55:00 | AAPL | Stock | 8.8486 | 8.8486 | 8.8486 | 8.8486 | 2800.0 |
| 2010-08-16 08:00:00 | AAPL | Stock | 8.8396 | 8.8568 | 8.8393 | 8.8568 | 84560.0 |
| 2010-08-16 08:05:00 | AAPL | Stock | 8.8489 | 8.8629 | 8.8489 | 8.8621 | 43400.0 |
| 2010-08-16 08:10:00 | AAPL | Stock | 8.8579 | 8.8579 | 8.8568 | 8.8571 | 69720.0 |
| 2010-08-16 08:15:00 | AAPL | Stock | 8.8586 | 8.8589 | 8.8482 | 8.8518 | 60760.0 |
| 2010-08-16 08:20:00 | AAPL | Stock | 8.8482 | 8.8518 | 8.8482 | 8.8518 | 22400.0 |
| 2010-08-16 08:25:00 | AAPL | Stock | 8.85 | 8.8564 | 8.85 | 8.8564 | 17920.0 |
| 2010-08-16 08:30:00 | AAPL | Stock | 8.8464 | 8.8571 | 8.845 | 8.8568 | 41972.0 |
| 2010-08-16 08:35:00 | AAPL | Stock | 8.8607 | 8.8671 | 8.86 | 8.8661 | 89068.0 |
| 2010-08-16 08:40:00 | AAPL | Stock | 8.8657 | 8.8679 | 8.8636 | 8.8636 | 50400.0 |
| 2010-08-16 08:45:00 | AAPL | Stock | 8.8618 | 8.8743 | 8.8614 | 8.87 | 125720.0 |
| 2010-08-16 08:50:00 | AAPL | Stock | 8.8668 | 8.8693 | 8.8643 | 8.8661 | 74200.0 |
| 2010-08-16 08:55:00 | AAPL | Stock | 8.8661 | 8.8686 | 8.8643 | 8.8643 | 226240.0 |
| 2010-08-16 09:00:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8439 | 8.845 | 164780.0 |
| 2010-08-16 09:05:00 | AAPL | Stock | 8.845 | 8.8518 | 8.8393 | 8.8429 | 249844.0 |
| 2010-08-16 09:10:00 | AAPL | Stock | 8.8432 | 8.8571 | 8.8429 | 8.85 | 66836.0 |
| 2010-08-16 09:15:00 | AAPL | Stock | 8.85 | 8.85 | 8.8421 | 8.8482 | 16800.0 |
| 2010-08-16 09:20:00 | AAPL | Stock | 8.845 | 8.845 | 8.8254 | 8.8318 | 286104.0 |
| 2010-08-16 09:25:00 | AAPL | Stock | 8.8307 | 8.8457 | 8.8271 | 8.8443 | 474348.0 |
| 2010-08-16 09:30:00 | AAPL | Stock | 8.8439 | 8.8536 | 8.8214 | 8.835 | 14714392.0 |
| 2010-08-16 09:35:00 | AAPL | Stock | 8.8348 | 8.8518 | 8.8296 | 8.8468 | 9014992.0 |
| 2010-08-16 09:40:00 | AAPL | Stock | 8.8436 | 8.8775 | 8.8436 | 8.875 | 11434444.0 |
| 2010-08-16 09:45:00 | AAPL | Stock | 8.875 | 8.9232 | 8.8736 | 8.9055 | 11828096.0 |
| 2010-08-16 09:50:00 | AAPL | Stock | 8.9054 | 8.9129 | 8.8839 | 8.9004 | 6180776.0 |
| 2010-08-16 09:55:00 | AAPL | Stock | 8.9011 | 8.9014 | 8.8789 | 8.8868 | 4737488.0 |
| 2010-08-16 10:00:00 | AAPL | Stock | 8.8864 | 8.8893 | 8.8607 | 8.8829 | 9761724.0 |
| 2010-08-16 10:05:00 | AAPL | Stock | 8.8839 | 8.9036 | 8.8819 | 8.8889 | 6349616.0 |
| 2010-08-16 10:10:00 | AAPL | Stock | 8.8896 | 8.905 | 8.8769 | 8.8771 | 5402992.0 |
| 2010-08-16 10:15:00 | AAPL | Stock | 8.8775 | 8.89 | 8.8618 | 8.887 | 7027328.0 |
| 2010-08-16 10:20:00 | AAPL | Stock | 8.8868 | 8.8893 | 8.8727 | 8.8794 | 3398584.0 |
| 2010-08-16 10:25:00 | AAPL | Stock | 8.8802 | 8.8925 | 8.875 | 8.8893 | 3980032.0 |
| 2010-08-16 10:30:00 | AAPL | Stock | 8.8875 | 8.9029 | 8.8875 | 8.8946 | 4730740.0 |
| 2010-08-16 10:35:00 | AAPL | Stock | 8.8936 | 8.9107 | 8.875 | 8.9107 | 7848876.0 |
| 2010-08-16 10:40:00 | AAPL | Stock | 8.9107 | 8.9168 | 8.8936 | 8.8964 | 5188176.0 |
| 2010-08-16 10:45:00 | AAPL | Stock | 8.8993 | 8.9071 | 8.8929 | 8.9057 | 3726380.0 |
| 2010-08-16 10:50:00 | AAPL | Stock | 8.9057 | 8.9096 | 8.9011 | 8.9075 | 2406964.0 |
| 2010-08-16 10:55:00 | AAPL | Stock | 8.9082 | 8.9196 | 8.9036 | 8.9193 | 3833788.0 |
| 2010-08-16 11:00:00 | AAPL | Stock | 8.9193 | 8.9196 | 8.9011 | 8.9018 | 4527796.0 |
| 2010-08-16 11:05:00 | AAPL | Stock | 8.9018 | 8.91 | 8.8929 | 8.8929 | 2787596.0 |
| 2010-08-16 11:10:00 | AAPL | Stock | 8.893 | 8.9039 | 8.893 | 8.9029 | 1730624.0 |
| 2010-08-16 11:15:00 | AAPL | Stock | 8.9036 | 8.9036 | 8.8886 | 8.8932 | 1937628.0 |
> showing 50 of 320,240 rows — these rows as CSV