PREVIEW / stock_5min / 2015-04-29
file: by_date/stock_5min/2015/2015-04-29.parquet size: 5.5 MB rows: 358,980 symbols: 3,495
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-04-29 04:00:00 | AAPL | Stock | 32.655 | 32.655 | 32.655 | 32.655 | 2960.0 |
| 2015-04-29 04:10:00 | AAPL | Stock | 32.6975 | 32.6975 | 32.6975 | 32.6975 | 400.0 |
| 2015-04-29 04:15:00 | AAPL | Stock | 32.73 | 32.73 | 32.73 | 32.73 | 1200.0 |
| 2015-04-29 04:30:00 | AAPL | Stock | 32.7225 | 32.7225 | 32.7225 | 32.7225 | 4400.0 |
| 2015-04-29 04:35:00 | AAPL | Stock | 32.7225 | 32.7225 | 32.7225 | 32.7225 | 400.0 |
| 2015-04-29 04:40:00 | AAPL | Stock | 32.7225 | 32.7225 | 32.715 | 32.7225 | 2000.0 |
| 2015-04-29 04:50:00 | AAPL | Stock | 32.72 | 32.72 | 32.7125 | 32.7125 | 1200.0 |
| 2015-04-29 04:55:00 | AAPL | Stock | 32.72 | 32.7225 | 32.7125 | 32.7125 | 4600.0 |
| 2015-04-29 05:00:00 | AAPL | Stock | 32.7225 | 32.7225 | 32.7225 | 32.7225 | 800.0 |
| 2015-04-29 05:05:00 | AAPL | Stock | 32.7225 | 32.7225 | 32.7225 | 32.7225 | 840.0 |
| 2015-04-29 05:10:00 | AAPL | Stock | 32.7125 | 32.7325 | 32.7125 | 32.7325 | 2380.0 |
| 2015-04-29 05:20:00 | AAPL | Stock | 32.7 | 32.7 | 32.7 | 32.7 | 600.0 |
| 2015-04-29 05:25:00 | AAPL | Stock | 32.7 | 32.7 | 32.7 | 32.7 | 400.0 |
| 2015-04-29 05:35:00 | AAPL | Stock | 32.7 | 32.7 | 32.7 | 32.7 | 400.0 |
| 2015-04-29 05:40:00 | AAPL | Stock | 32.675 | 32.675 | 32.65 | 32.65 | 2916.0 |
| 2015-04-29 05:45:00 | AAPL | Stock | 32.6275 | 32.6275 | 32.62 | 32.62 | 11600.0 |
| 2015-04-29 05:55:00 | AAPL | Stock | 32.65 | 32.65 | 32.65 | 32.65 | 800.0 |
| 2015-04-29 06:00:00 | AAPL | Stock | 32.65 | 32.65 | 32.62 | 32.62 | 6396.0 |
| 2015-04-29 06:05:00 | AAPL | Stock | 32.625 | 32.6525 | 32.625 | 32.6525 | 5292.0 |
| 2015-04-29 06:10:00 | AAPL | Stock | 32.665 | 32.6975 | 32.665 | 32.6975 | 7992.0 |
| 2015-04-29 06:15:00 | AAPL | Stock | 32.69 | 32.7 | 32.6875 | 32.7 | 11220.0 |
| 2015-04-29 06:20:00 | AAPL | Stock | 32.6975 | 32.71 | 32.6625 | 32.6875 | 14076.0 |
| 2015-04-29 06:25:00 | AAPL | Stock | 32.6975 | 32.7 | 32.6925 | 32.6925 | 5620.0 |
| 2015-04-29 06:30:00 | AAPL | Stock | 32.695 | 32.7475 | 32.695 | 32.7475 | 43196.0 |
| 2015-04-29 06:35:00 | AAPL | Stock | 32.7425 | 32.7475 | 32.715 | 32.715 | 5180.0 |
| 2015-04-29 06:45:00 | AAPL | Stock | 32.695 | 32.695 | 32.66 | 32.6625 | 24608.0 |
| 2015-04-29 06:50:00 | AAPL | Stock | 32.6775 | 32.6825 | 32.6775 | 32.6825 | 5800.0 |
| 2015-04-29 06:55:00 | AAPL | Stock | 32.68 | 32.685 | 32.68 | 32.685 | 12596.0 |
| 2015-04-29 07:00:00 | AAPL | Stock | 32.68 | 32.74 | 32.6775 | 32.7325 | 57784.0 |
| 2015-04-29 07:05:00 | AAPL | Stock | 32.7325 | 32.77 | 32.7225 | 32.725 | 86780.0 |
| 2015-04-29 07:10:00 | AAPL | Stock | 32.7125 | 32.725 | 32.6975 | 32.715 | 25192.0 |
| 2015-04-29 07:15:00 | AAPL | Stock | 32.7125 | 32.7125 | 32.6875 | 32.695 | 27380.0 |
| 2015-04-29 07:20:00 | AAPL | Stock | 32.695 | 32.695 | 32.6475 | 32.6475 | 55088.0 |
| 2015-04-29 07:25:00 | AAPL | Stock | 32.655 | 32.665 | 32.635 | 32.665 | 10440.0 |
| 2015-04-29 07:30:00 | AAPL | Stock | 32.6625 | 32.6675 | 32.6625 | 32.6675 | 8692.0 |
| 2015-04-29 07:35:00 | AAPL | Stock | 32.6925 | 32.7175 | 32.6925 | 32.7175 | 7180.0 |
| 2015-04-29 07:40:00 | AAPL | Stock | 32.7 | 32.705 | 32.6975 | 32.6975 | 6668.0 |
| 2015-04-29 07:45:00 | AAPL | Stock | 32.69 | 32.69 | 32.6725 | 32.6725 | 2036.0 |
| 2015-04-29 07:50:00 | AAPL | Stock | 32.6875 | 32.6875 | 32.65 | 32.6625 | 7120.0 |
| 2015-04-29 07:55:00 | AAPL | Stock | 32.655 | 32.67 | 32.65 | 32.67 | 7284.0 |
| 2015-04-29 08:00:00 | AAPL | Stock | 32.67 | 32.7325 | 32.6275 | 32.6875 | 230768.0 |
| 2015-04-29 08:05:00 | AAPL | Stock | 32.6975 | 32.705 | 32.6625 | 32.675 | 44136.0 |
| 2015-04-29 08:10:00 | AAPL | Stock | 32.6778 | 32.7025 | 32.665 | 32.665 | 72152.0 |
| 2015-04-29 08:15:00 | AAPL | Stock | 32.6675 | 32.695 | 32.6625 | 32.695 | 25612.0 |
| 2015-04-29 08:20:00 | AAPL | Stock | 32.695 | 32.7075 | 32.6875 | 32.7075 | 43192.0 |
| 2015-04-29 08:25:00 | AAPL | Stock | 32.7 | 32.72 | 32.7 | 32.72 | 42700.0 |
| 2015-04-29 08:30:00 | AAPL | Stock | 32.7125 | 32.74 | 32.6975 | 32.7375 | 125132.0 |
| 2015-04-29 08:35:00 | AAPL | Stock | 32.7375 | 32.7925 | 32.6875 | 32.7 | 205192.0 |
| 2015-04-29 08:40:00 | AAPL | Stock | 32.72 | 32.735 | 32.6675 | 32.6675 | 96280.0 |
| 2015-04-29 08:45:00 | AAPL | Stock | 32.675 | 32.6975 | 32.6675 | 32.6975 | 103396.0 |
> showing 50 of 358,980 rows — these rows as CSV