PREVIEW / stock_5min / 2015-11-18
file: by_date/stock_5min/2015/2015-11-18.parquet size: 5.5 MB rows: 363,724 symbols: 3,437
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-18 04:00:00 | AAPL | Stock | 28.445 | 28.7525 | 28.445 | 28.63 | 5520.0 |
| 2015-11-18 04:10:00 | AAPL | Stock | 28.6525 | 28.66 | 28.6525 | 28.66 | 2400.0 |
| 2015-11-18 04:15:00 | AAPL | Stock | 28.66 | 28.6975 | 28.66 | 28.6975 | 12400.0 |
| 2015-11-18 04:20:00 | AAPL | Stock | 28.6875 | 28.695 | 28.6875 | 28.6875 | 51128.0 |
| 2015-11-18 04:25:00 | AAPL | Stock | 28.6925 | 28.6925 | 28.6925 | 28.6925 | 400.0 |
| 2015-11-18 04:30:00 | AAPL | Stock | 28.6725 | 28.6725 | 28.6725 | 28.6725 | 800.0 |
| 2015-11-18 04:35:00 | AAPL | Stock | 28.6725 | 28.6725 | 28.6525 | 28.6525 | 2400.0 |
| 2015-11-18 04:40:00 | AAPL | Stock | 28.6525 | 28.6525 | 28.6525 | 28.6525 | 996.0 |
| 2015-11-18 04:50:00 | AAPL | Stock | 28.625 | 28.6325 | 28.625 | 28.6325 | 4000.0 |
| 2015-11-18 05:00:00 | AAPL | Stock | 28.6375 | 28.6725 | 28.6375 | 28.6725 | 4800.0 |
| 2015-11-18 05:05:00 | AAPL | Stock | 28.625 | 28.625 | 28.625 | 28.625 | 1600.0 |
| 2015-11-18 05:20:00 | AAPL | Stock | 28.6275 | 28.6275 | 28.6275 | 28.6275 | 592.0 |
| 2015-11-18 05:25:00 | AAPL | Stock | 28.6125 | 28.6125 | 28.6125 | 28.6125 | 400.0 |
| 2015-11-18 05:30:00 | AAPL | Stock | 28.665 | 28.665 | 28.665 | 28.665 | 4400.0 |
| 2015-11-18 05:45:00 | AAPL | Stock | 28.6475 | 28.6475 | 28.6275 | 28.6275 | 2000.0 |
| 2015-11-18 05:50:00 | AAPL | Stock | 28.6275 | 28.65 | 28.6275 | 28.65 | 1200.0 |
| 2015-11-18 05:55:00 | AAPL | Stock | 28.6275 | 28.6625 | 28.625 | 28.6625 | 5844.0 |
| 2015-11-18 06:00:00 | AAPL | Stock | 28.62 | 28.62 | 28.6175 | 28.6175 | 7200.0 |
| 2015-11-18 06:05:00 | AAPL | Stock | 28.6575 | 28.6625 | 28.6575 | 28.6625 | 33040.0 |
| 2015-11-18 06:10:00 | AAPL | Stock | 28.6625 | 28.665 | 28.6625 | 28.665 | 15512.0 |
| 2015-11-18 06:15:00 | AAPL | Stock | 28.665 | 28.675 | 28.665 | 28.675 | 27448.0 |
| 2015-11-18 06:20:00 | AAPL | Stock | 28.675 | 28.685 | 28.6725 | 28.675 | 40480.0 |
| 2015-11-18 06:25:00 | AAPL | Stock | 28.685 | 28.685 | 28.6675 | 28.6675 | 17232.0 |
| 2015-11-18 06:30:00 | AAPL | Stock | 28.685 | 28.6875 | 28.6675 | 28.6675 | 15160.0 |
| 2015-11-18 06:35:00 | AAPL | Stock | 28.6525 | 28.6525 | 28.65 | 28.65 | 18432.0 |
| 2015-11-18 06:40:00 | AAPL | Stock | 28.675 | 28.675 | 28.675 | 28.675 | 18400.0 |
| 2015-11-18 06:45:00 | AAPL | Stock | 28.675 | 28.675 | 28.63 | 28.675 | 44464.0 |
| 2015-11-18 06:50:00 | AAPL | Stock | 28.6725 | 28.6725 | 28.6625 | 28.6725 | 33260.0 |
| 2015-11-18 06:55:00 | AAPL | Stock | 28.6725 | 28.685 | 28.6725 | 28.685 | 29096.0 |
| 2015-11-18 07:00:00 | AAPL | Stock | 28.685 | 28.75 | 28.675 | 28.75 | 57372.0 |
| 2015-11-18 07:05:00 | AAPL | Stock | 28.775 | 28.8 | 28.775 | 28.79 | 93000.0 |
| 2015-11-18 07:10:00 | AAPL | Stock | 28.79 | 28.7925 | 28.7775 | 28.79 | 23960.0 |
| 2015-11-18 07:15:00 | AAPL | Stock | 28.8 | 28.825 | 28.8 | 28.815 | 24960.0 |
| 2015-11-18 07:20:00 | AAPL | Stock | 28.8325 | 28.885 | 28.82 | 28.8625 | 88640.0 |
| 2015-11-18 07:25:00 | AAPL | Stock | 28.85 | 28.9025 | 28.85 | 28.885 | 29580.0 |
| 2015-11-18 07:30:00 | AAPL | Stock | 28.8875 | 28.8875 | 28.8525 | 28.8575 | 25936.0 |
| 2015-11-18 07:35:00 | AAPL | Stock | 28.8575 | 28.8675 | 28.82 | 28.8325 | 34004.0 |
| 2015-11-18 07:40:00 | AAPL | Stock | 28.8325 | 28.84 | 28.8225 | 28.8325 | 19000.0 |
| 2015-11-18 07:45:00 | AAPL | Stock | 28.835 | 28.865 | 28.8225 | 28.8575 | 24160.0 |
| 2015-11-18 07:50:00 | AAPL | Stock | 28.8575 | 28.86 | 28.84 | 28.855 | 21512.0 |
| 2015-11-18 07:55:00 | AAPL | Stock | 28.8525 | 28.9 | 28.8525 | 28.9 | 42360.0 |
| 2015-11-18 08:00:00 | AAPL | Stock | 28.9 | 28.925 | 28.65 | 28.8725 | 273116.0 |
| 2015-11-18 08:05:00 | AAPL | Stock | 28.875 | 28.9025 | 28.8375 | 28.845 | 90832.0 |
| 2015-11-18 08:10:00 | AAPL | Stock | 28.8375 | 28.8575 | 28.8325 | 28.85 | 32096.0 |
| 2015-11-18 08:15:00 | AAPL | Stock | 28.85 | 28.8725 | 28.85 | 28.87 | 38672.0 |
| 2015-11-18 08:20:00 | AAPL | Stock | 28.87 | 28.88 | 28.8375 | 28.85 | 79628.0 |
| 2015-11-18 08:25:00 | AAPL | Stock | 28.84 | 28.855 | 28.84 | 28.845 | 15960.0 |
| 2015-11-18 08:30:00 | AAPL | Stock | 28.845 | 28.85 | 28.83 | 28.84 | 29336.0 |
| 2015-11-18 08:35:00 | AAPL | Stock | 28.84 | 28.8575 | 28.83 | 28.8575 | 101868.0 |
| 2015-11-18 08:40:00 | AAPL | Stock | 28.8575 | 28.875 | 28.855 | 28.87 | 79776.0 |
> showing 50 of 363,724 rows — these rows as CSV