PREVIEW / stock_5min / 2014-01-17
file: by_date/stock_5min/2014/2014-01-17.parquet size: 5.5 MB rows: 359,427 symbols: 3,531
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-17 05:05:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8214 | 19.8214 | 2800.0 |
| 2014-01-17 05:10:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8214 | 19.8214 | 2800.0 |
| 2014-01-17 05:20:00 | AAPL | Stock | 19.8182 | 19.8182 | 19.8107 | 19.8107 | 5600.0 |
| 2014-01-17 05:30:00 | AAPL | Stock | 19.8111 | 19.8129 | 19.8107 | 19.8129 | 10220.0 |
| 2014-01-17 05:35:00 | AAPL | Stock | 19.8129 | 19.8129 | 19.8129 | 19.8129 | 2800.0 |
| 2014-01-17 05:45:00 | AAPL | Stock | 19.8054 | 19.8154 | 19.8054 | 19.8154 | 11200.0 |
| 2014-01-17 06:00:00 | AAPL | Stock | 19.7946 | 19.7946 | 19.7875 | 19.7875 | 5600.0 |
| 2014-01-17 06:10:00 | AAPL | Stock | 19.7814 | 19.7857 | 19.7814 | 19.7857 | 13720.0 |
| 2014-01-17 06:15:00 | AAPL | Stock | 19.7821 | 19.7821 | 19.7789 | 19.7789 | 15904.0 |
| 2014-01-17 06:20:00 | AAPL | Stock | 19.7768 | 19.7768 | 19.7768 | 19.7768 | 2800.0 |
| 2014-01-17 06:25:00 | AAPL | Stock | 19.8111 | 19.8111 | 19.7821 | 19.7857 | 37548.0 |
| 2014-01-17 06:30:00 | AAPL | Stock | 19.7821 | 19.7825 | 19.7821 | 19.7825 | 10304.0 |
| 2014-01-17 06:35:00 | AAPL | Stock | 19.7754 | 19.7754 | 19.7525 | 19.7525 | 5600.0 |
| 2014-01-17 06:40:00 | AAPL | Stock | 19.7525 | 19.7607 | 19.7518 | 19.7607 | 27160.0 |
| 2014-01-17 06:45:00 | AAPL | Stock | 19.7357 | 19.7536 | 19.7254 | 19.7536 | 42000.0 |
| 2014-01-17 06:50:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 8400.0 |
| 2014-01-17 06:55:00 | AAPL | Stock | 19.7411 | 19.7464 | 19.7407 | 19.7464 | 33600.0 |
| 2014-01-17 07:00:00 | AAPL | Stock | 19.7325 | 19.7504 | 19.7311 | 19.7504 | 28000.0 |
| 2014-01-17 07:05:00 | AAPL | Stock | 19.7446 | 19.7607 | 19.7446 | 19.7607 | 40264.0 |
| 2014-01-17 07:10:00 | AAPL | Stock | 19.7589 | 19.7589 | 19.7464 | 19.7464 | 11200.0 |
| 2014-01-17 07:15:00 | AAPL | Stock | 19.7564 | 19.7568 | 19.7464 | 19.7464 | 18200.0 |
| 2014-01-17 07:20:00 | AAPL | Stock | 19.7339 | 19.7339 | 19.7039 | 19.7143 | 42812.0 |
| 2014-01-17 07:25:00 | AAPL | Stock | 19.7057 | 19.7057 | 19.6521 | 19.6536 | 156492.0 |
| 2014-01-17 07:30:00 | AAPL | Stock | 19.6521 | 19.6696 | 19.6464 | 19.6679 | 95312.0 |
| 2014-01-17 07:35:00 | AAPL | Stock | 19.6775 | 19.6775 | 19.6704 | 19.6704 | 11200.0 |
| 2014-01-17 07:40:00 | AAPL | Stock | 19.6782 | 19.6786 | 19.6486 | 19.6571 | 165228.0 |
| 2014-01-17 07:45:00 | AAPL | Stock | 19.6611 | 19.6696 | 19.6607 | 19.6679 | 78400.0 |
| 2014-01-17 07:50:00 | AAPL | Stock | 19.6761 | 19.6786 | 19.6707 | 19.6782 | 42000.0 |
| 2014-01-17 07:55:00 | AAPL | Stock | 19.6786 | 19.695 | 19.6786 | 19.695 | 69188.0 |
| 2014-01-17 08:00:00 | AAPL | Stock | 19.6964 | 19.7625 | 19.6589 | 19.7142 | 541688.0 |
| 2014-01-17 08:05:00 | AAPL | Stock | 19.6839 | 19.6964 | 19.6393 | 19.6518 | 369824.0 |
| 2014-01-17 08:10:00 | AAPL | Stock | 19.6429 | 19.6611 | 19.6382 | 19.6536 | 253288.0 |
| 2014-01-17 08:15:00 | AAPL | Stock | 19.6536 | 19.6714 | 19.6429 | 19.6714 | 326032.0 |
| 2014-01-17 08:20:00 | AAPL | Stock | 19.6743 | 19.7054 | 19.6679 | 19.6964 | 409220.0 |
| 2014-01-17 08:25:00 | AAPL | Stock | 19.6861 | 19.7018 | 19.6821 | 19.7018 | 177940.0 |
| 2014-01-17 08:30:00 | AAPL | Stock | 19.7054 | 19.7096 | 19.6846 | 19.6986 | 215600.0 |
| 2014-01-17 08:35:00 | AAPL | Stock | 19.7079 | 19.7104 | 19.7004 | 19.7054 | 124880.0 |
| 2014-01-17 08:40:00 | AAPL | Stock | 19.7054 | 19.7054 | 19.6786 | 19.6864 | 193704.0 |
| 2014-01-17 08:45:00 | AAPL | Stock | 19.6857 | 19.6857 | 19.665 | 19.6661 | 122500.0 |
| 2014-01-17 08:50:00 | AAPL | Stock | 19.6639 | 19.6661 | 19.5939 | 19.6196 | 755888.0 |
| 2014-01-17 08:55:00 | AAPL | Stock | 19.6254 | 19.6532 | 19.5989 | 19.6432 | 288484.0 |
| 2014-01-17 09:00:00 | AAPL | Stock | 19.6543 | 19.6646 | 19.6471 | 19.6596 | 108752.0 |
| 2014-01-17 09:05:00 | AAPL | Stock | 19.6604 | 19.675 | 19.6539 | 19.6661 | 246484.0 |
| 2014-01-17 09:10:00 | AAPL | Stock | 19.6661 | 19.6693 | 19.6389 | 19.6518 | 369096.0 |
| 2014-01-17 09:15:00 | AAPL | Stock | 19.6518 | 19.6646 | 19.6511 | 19.6575 | 98000.0 |
| 2014-01-17 09:20:00 | AAPL | Stock | 19.6575 | 19.6818 | 19.6529 | 19.6818 | 376404.0 |
| 2014-01-17 09:25:00 | AAPL | Stock | 19.6786 | 19.7139 | 19.6746 | 19.6857 | 906248.0 |
| 2014-01-17 09:30:00 | AAPL | Stock | 19.6957 | 19.7168 | 19.5643 | 19.5693 | 57632092.0 |
| 2014-01-17 09:35:00 | AAPL | Stock | 19.5757 | 19.6144 | 19.5571 | 19.5898 | 12493068.0 |
| 2014-01-17 09:40:00 | AAPL | Stock | 19.59 | 19.6568 | 19.5854 | 19.6368 | 8584408.0 |
> showing 50 of 359,427 rows — these rows as CSV