PREVIEW / stock_5min / 2014-01-02
file: by_date/stock_5min/2014/2014-01-02.parquet size: 5.5 MB rows: 361,383 symbols: 3,515
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-02 04:00:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7679 | 19.7679 | 5264.0 |
| 2014-01-02 04:05:00 | AAPL | Stock | 19.8632 | 19.8632 | 19.8596 | 19.8596 | 8400.0 |
| 2014-01-02 04:10:00 | AAPL | Stock | 19.8471 | 19.8579 | 19.8471 | 19.8579 | 95116.0 |
| 2014-01-02 04:15:00 | AAPL | Stock | 19.8611 | 19.8611 | 19.8607 | 19.8607 | 8400.0 |
| 2014-01-02 04:25:00 | AAPL | Stock | 19.8614 | 19.8679 | 19.8568 | 19.8586 | 17892.0 |
| 2014-01-02 04:35:00 | AAPL | Stock | 19.8571 | 19.8575 | 19.8571 | 19.8575 | 8400.0 |
| 2014-01-02 04:40:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 5600.0 |
| 2014-01-02 04:45:00 | AAPL | Stock | 19.8521 | 19.8521 | 19.8521 | 19.8521 | 2800.0 |
| 2014-01-02 05:00:00 | AAPL | Stock | 19.8318 | 19.8318 | 19.8318 | 19.8318 | 2800.0 |
| 2014-01-02 05:10:00 | AAPL | Stock | 19.8107 | 19.8107 | 19.8107 | 19.8107 | 2800.0 |
| 2014-01-02 05:20:00 | AAPL | Stock | 19.8039 | 19.8039 | 19.8039 | 19.8039 | 2800.0 |
| 2014-01-02 05:35:00 | AAPL | Stock | 19.8018 | 19.8036 | 19.8018 | 19.8018 | 11200.0 |
| 2014-01-02 05:45:00 | AAPL | Stock | 19.8118 | 19.8118 | 19.8118 | 19.8118 | 2800.0 |
| 2014-01-02 06:05:00 | AAPL | Stock | 19.8607 | 19.8607 | 19.8607 | 19.8607 | 11284.0 |
| 2014-01-02 06:10:00 | AAPL | Stock | 19.8543 | 19.8643 | 19.8543 | 19.8571 | 13356.0 |
| 2014-01-02 06:15:00 | AAPL | Stock | 19.8364 | 19.8364 | 19.8214 | 19.8214 | 18144.0 |
| 2014-01-02 06:20:00 | AAPL | Stock | 19.8282 | 19.8282 | 19.8214 | 19.8214 | 5600.0 |
| 2014-01-02 06:25:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8214 | 19.8214 | 11200.0 |
| 2014-01-02 06:30:00 | AAPL | Stock | 19.8396 | 19.8396 | 19.8396 | 19.8396 | 2800.0 |
| 2014-01-02 06:45:00 | AAPL | Stock | 19.845 | 19.845 | 19.845 | 19.845 | 5600.0 |
| 2014-01-02 07:00:00 | AAPL | Stock | 19.8214 | 19.8568 | 19.8214 | 19.8568 | 30520.0 |
| 2014-01-02 07:05:00 | AAPL | Stock | 19.8571 | 19.87 | 19.8518 | 19.8518 | 74928.0 |
| 2014-01-02 07:10:00 | AAPL | Stock | 19.8571 | 19.8729 | 19.8571 | 19.8729 | 17080.0 |
| 2014-01-02 07:15:00 | AAPL | Stock | 19.8871 | 19.8871 | 19.8871 | 19.8871 | 2800.0 |
| 2014-01-02 07:20:00 | AAPL | Stock | 19.8821 | 19.9286 | 19.875 | 19.875 | 90328.0 |
| 2014-01-02 07:25:00 | AAPL | Stock | 19.8596 | 19.8679 | 19.8536 | 19.8536 | 36400.0 |
| 2014-01-02 07:30:00 | AAPL | Stock | 19.8496 | 19.8821 | 19.8482 | 19.8821 | 84672.0 |
| 2014-01-02 07:35:00 | AAPL | Stock | 19.875 | 19.8886 | 19.8696 | 19.875 | 108920.0 |
| 2014-01-02 07:40:00 | AAPL | Stock | 19.8696 | 19.875 | 19.8471 | 19.8486 | 67256.0 |
| 2014-01-02 07:45:00 | AAPL | Stock | 19.85 | 19.8821 | 19.85 | 19.875 | 102788.0 |
| 2014-01-02 07:50:00 | AAPL | Stock | 19.8839 | 19.8839 | 19.8646 | 19.865 | 28000.0 |
| 2014-01-02 08:00:00 | AAPL | Stock | 19.8661 | 19.8925 | 19.8339 | 19.8571 | 541128.0 |
| 2014-01-02 08:05:00 | AAPL | Stock | 19.8511 | 19.8579 | 19.8496 | 19.8554 | 282492.0 |
| 2014-01-02 08:10:00 | AAPL | Stock | 19.8543 | 19.8568 | 19.8286 | 19.8371 | 509600.0 |
| 2014-01-02 08:15:00 | AAPL | Stock | 19.8325 | 19.8461 | 19.8325 | 19.8325 | 254688.0 |
| 2014-01-02 08:20:00 | AAPL | Stock | 19.8321 | 19.8429 | 19.8236 | 19.8321 | 197148.0 |
| 2014-01-02 08:25:00 | AAPL | Stock | 19.8357 | 19.8357 | 19.8214 | 19.8339 | 321412.0 |
| 2014-01-02 08:30:00 | AAPL | Stock | 19.8314 | 19.8314 | 19.8175 | 19.8175 | 202720.0 |
| 2014-01-02 08:35:00 | AAPL | Stock | 19.8171 | 19.8214 | 19.8036 | 19.8204 | 93268.0 |
| 2014-01-02 08:40:00 | AAPL | Stock | 19.8147 | 19.8211 | 19.81 | 19.8157 | 152320.0 |
| 2014-01-02 08:45:00 | AAPL | Stock | 19.8161 | 19.8357 | 19.8143 | 19.8357 | 196952.0 |
| 2014-01-02 08:50:00 | AAPL | Stock | 19.8321 | 19.8321 | 19.825 | 19.825 | 135408.0 |
| 2014-01-02 08:55:00 | AAPL | Stock | 19.8318 | 19.8321 | 19.8193 | 19.8268 | 457296.0 |
| 2014-01-02 09:00:00 | AAPL | Stock | 19.8304 | 19.8571 | 19.83 | 19.8564 | 484372.0 |
| 2014-01-02 09:05:00 | AAPL | Stock | 19.8571 | 19.8607 | 19.85 | 19.8582 | 140000.0 |
| 2014-01-02 09:10:00 | AAPL | Stock | 19.8607 | 19.8607 | 19.8397 | 19.8432 | 57008.0 |
| 2014-01-02 09:15:00 | AAPL | Stock | 19.8454 | 19.85 | 19.8393 | 19.85 | 62916.0 |
| 2014-01-02 09:20:00 | AAPL | Stock | 19.8493 | 19.8589 | 19.8457 | 19.8518 | 136220.0 |
| 2014-01-02 09:25:00 | AAPL | Stock | 19.8511 | 19.8611 | 19.8218 | 19.8557 | 277312.0 |
| 2014-01-02 09:30:00 | AAPL | Stock | 19.8457 | 19.8939 | 19.8082 | 19.8096 | 15020068.0 |
> showing 50 of 361,383 rows — these rows as CSV