PREVIEW / stock_5min / 2012-09-27
file: by_date/stock_5min/2012/2012-09-27.parquet size: 4.8 MB rows: 322,603 symbols: 3,472
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-27 04:00:00 | AAPL | Stock | 23.8554 | 23.8571 | 23.8554 | 23.8571 | 18200.0 |
| 2012-09-27 04:10:00 | AAPL | Stock | 23.8571 | 23.8571 | 23.8571 | 23.8571 | 5600.0 |
| 2012-09-27 04:15:00 | AAPL | Stock | 23.8571 | 23.8571 | 23.8571 | 23.8571 | 5600.0 |
| 2012-09-27 04:25:00 | AAPL | Stock | 23.8536 | 23.8571 | 23.8536 | 23.8571 | 11200.0 |
| 2012-09-27 04:30:00 | AAPL | Stock | 23.8571 | 23.8571 | 23.8571 | 23.8571 | 12432.0 |
| 2012-09-27 04:35:00 | AAPL | Stock | 23.8571 | 23.8571 | 23.8464 | 23.8464 | 9072.0 |
| 2012-09-27 05:10:00 | AAPL | Stock | 23.85 | 23.85 | 23.85 | 23.85 | 8400.0 |
| 2012-09-27 05:20:00 | AAPL | Stock | 23.85 | 23.85 | 23.8214 | 23.8214 | 39200.0 |
| 2012-09-27 05:25:00 | AAPL | Stock | 23.8143 | 23.8143 | 23.8143 | 23.8143 | 2800.0 |
| 2012-09-27 05:30:00 | AAPL | Stock | 23.8143 | 23.8143 | 23.8143 | 23.8143 | 2800.0 |
| 2012-09-27 05:40:00 | AAPL | Stock | 23.8143 | 23.8214 | 23.8143 | 23.8214 | 5600.0 |
| 2012-09-27 05:45:00 | AAPL | Stock | 23.8214 | 23.8214 | 23.8143 | 23.8214 | 44744.0 |
| 2012-09-27 05:50:00 | AAPL | Stock | 23.8214 | 23.8214 | 23.8214 | 23.8214 | 15400.0 |
| 2012-09-27 05:55:00 | AAPL | Stock | 23.8214 | 23.8214 | 23.8214 | 23.8214 | 11200.0 |
| 2012-09-27 06:00:00 | AAPL | Stock | 23.8214 | 23.8214 | 23.8214 | 23.8214 | 9016.0 |
| 2012-09-27 06:05:00 | AAPL | Stock | 23.8214 | 23.8214 | 23.8211 | 23.8214 | 59416.0 |
| 2012-09-27 06:15:00 | AAPL | Stock | 23.8489 | 23.8489 | 23.8321 | 23.8321 | 8400.0 |
| 2012-09-27 06:20:00 | AAPL | Stock | 23.8321 | 23.8321 | 23.8143 | 23.8143 | 55664.0 |
| 2012-09-27 06:25:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.7679 | 23.7679 | 52080.0 |
| 2012-09-27 06:30:00 | AAPL | Stock | 23.7868 | 23.7921 | 23.7679 | 23.7679 | 66780.0 |
| 2012-09-27 06:35:00 | AAPL | Stock | 23.7679 | 23.7679 | 23.7589 | 23.7679 | 63000.0 |
| 2012-09-27 06:40:00 | AAPL | Stock | 23.7679 | 23.7679 | 23.7679 | 23.7679 | 13300.0 |
| 2012-09-27 06:45:00 | AAPL | Stock | 23.7679 | 23.7679 | 23.7589 | 23.7589 | 53200.0 |
| 2012-09-27 06:50:00 | AAPL | Stock | 23.7579 | 23.7579 | 23.7254 | 23.7254 | 70588.0 |
| 2012-09-27 06:55:00 | AAPL | Stock | 23.7254 | 23.7321 | 23.7254 | 23.7321 | 82600.0 |
| 2012-09-27 07:00:00 | AAPL | Stock | 23.7264 | 23.7286 | 23.6786 | 23.6968 | 235648.0 |
| 2012-09-27 07:05:00 | AAPL | Stock | 23.7093 | 23.7586 | 23.7093 | 23.7446 | 163940.0 |
| 2012-09-27 07:10:00 | AAPL | Stock | 23.7443 | 23.7857 | 23.7443 | 23.7857 | 262080.0 |
| 2012-09-27 07:15:00 | AAPL | Stock | 23.7857 | 23.8214 | 23.7857 | 23.8211 | 233744.0 |
| 2012-09-27 07:20:00 | AAPL | Stock | 23.8214 | 23.8214 | 23.8 | 23.8036 | 79156.0 |
| 2012-09-27 07:25:00 | AAPL | Stock | 23.8036 | 23.8107 | 23.7704 | 23.8107 | 97356.0 |
| 2012-09-27 07:30:00 | AAPL | Stock | 23.8068 | 23.8107 | 23.8021 | 23.8021 | 56672.0 |
| 2012-09-27 07:35:00 | AAPL | Stock | 23.8018 | 23.8375 | 23.7896 | 23.8375 | 195524.0 |
| 2012-09-27 07:40:00 | AAPL | Stock | 23.8286 | 23.8346 | 23.8214 | 23.8214 | 57400.0 |
| 2012-09-27 07:45:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.8036 | 23.8036 | 14924.0 |
| 2012-09-27 07:50:00 | AAPL | Stock | 23.8036 | 23.8089 | 23.7857 | 23.7857 | 59024.0 |
| 2012-09-27 07:55:00 | AAPL | Stock | 23.7857 | 23.7857 | 23.7593 | 23.7786 | 124796.0 |
| 2012-09-27 08:00:00 | AAPL | Stock | 23.7782 | 23.8036 | 23.7782 | 23.7946 | 221284.0 |
| 2012-09-27 08:05:00 | AAPL | Stock | 23.7954 | 23.8304 | 23.7954 | 23.825 | 176456.0 |
| 2012-09-27 08:10:00 | AAPL | Stock | 23.8354 | 23.8436 | 23.8243 | 23.8339 | 306712.0 |
| 2012-09-27 08:15:00 | AAPL | Stock | 23.8321 | 23.8679 | 23.8321 | 23.8575 | 360220.0 |
| 2012-09-27 08:20:00 | AAPL | Stock | 23.8575 | 23.8596 | 23.8518 | 23.8518 | 128856.0 |
| 2012-09-27 08:25:00 | AAPL | Stock | 23.8514 | 23.8607 | 23.8393 | 23.8607 | 182644.0 |
| 2012-09-27 08:30:00 | AAPL | Stock | 23.8425 | 23.8425 | 23.8125 | 23.8254 | 373660.0 |
| 2012-09-27 08:35:00 | AAPL | Stock | 23.8214 | 23.8271 | 23.7764 | 23.7764 | 473200.0 |
| 2012-09-27 08:40:00 | AAPL | Stock | 23.7696 | 23.7857 | 23.7636 | 23.7768 | 372988.0 |
| 2012-09-27 08:45:00 | AAPL | Stock | 23.7839 | 23.8111 | 23.7757 | 23.7986 | 347312.0 |
| 2012-09-27 08:50:00 | AAPL | Stock | 23.8036 | 23.8111 | 23.7679 | 23.7761 | 326256.0 |
| 2012-09-27 08:55:00 | AAPL | Stock | 23.7743 | 23.7775 | 23.7493 | 23.7679 | 480648.0 |
| 2012-09-27 09:00:00 | AAPL | Stock | 23.7611 | 23.775 | 23.75 | 23.775 | 227640.0 |
> showing 50 of 322,603 rows — these rows as CSV