PREVIEW / stock_5min / 2015-03-18
file: by_date/stock_5min/2015/2015-03-18.parquet size: 5.6 MB rows: 364,121 symbols: 3,496
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-03-18 04:00:00 | AAPL | Stock | 31.775 | 31.825 | 31.775 | 31.8125 | 2800.0 |
| 2015-03-18 04:05:00 | AAPL | Stock | 31.8 | 31.8 | 31.775 | 31.775 | 2400.0 |
| 2015-03-18 04:15:00 | AAPL | Stock | 31.7975 | 31.8 | 31.7875 | 31.8 | 3200.0 |
| 2015-03-18 04:20:00 | AAPL | Stock | 31.8125 | 31.8125 | 31.79 | 31.79 | 900.0 |
| 2015-03-18 04:30:00 | AAPL | Stock | 31.835 | 31.835 | 31.835 | 31.835 | 400.0 |
| 2015-03-18 04:40:00 | AAPL | Stock | 31.8375 | 31.84 | 31.8375 | 31.84 | 1100.0 |
| 2015-03-18 04:45:00 | AAPL | Stock | 31.8425 | 31.8425 | 31.8425 | 31.8425 | 1120.0 |
| 2015-03-18 04:55:00 | AAPL | Stock | 31.8425 | 31.8525 | 31.8425 | 31.85 | 5532.0 |
| 2015-03-18 05:00:00 | AAPL | Stock | 31.8525 | 31.86 | 31.8525 | 31.86 | 16200.0 |
| 2015-03-18 05:20:00 | AAPL | Stock | 31.8575 | 31.86 | 31.8575 | 31.86 | 2680.0 |
| 2015-03-18 05:25:00 | AAPL | Stock | 31.85 | 31.8675 | 31.85 | 31.8675 | 3880.0 |
| 2015-03-18 05:30:00 | AAPL | Stock | 31.865 | 31.865 | 31.865 | 31.865 | 1152.0 |
| 2015-03-18 05:35:00 | AAPL | Stock | 31.8575 | 31.8675 | 31.8575 | 31.8675 | 6880.0 |
| 2015-03-18 05:40:00 | AAPL | Stock | 31.8575 | 31.8575 | 31.8575 | 31.8575 | 600.0 |
| 2015-03-18 05:45:00 | AAPL | Stock | 31.87 | 31.87 | 31.87 | 31.87 | 1600.0 |
| 2015-03-18 05:55:00 | AAPL | Stock | 31.8575 | 31.87 | 31.855 | 31.87 | 3600.0 |
| 2015-03-18 06:00:00 | AAPL | Stock | 31.855 | 31.855 | 31.845 | 31.845 | 12656.0 |
| 2015-03-18 06:05:00 | AAPL | Stock | 31.855 | 31.875 | 31.855 | 31.875 | 10000.0 |
| 2015-03-18 06:10:00 | AAPL | Stock | 31.8575 | 31.86 | 31.8575 | 31.86 | 5600.0 |
| 2015-03-18 06:15:00 | AAPL | Stock | 31.875 | 31.8775 | 31.8625 | 31.8625 | 7800.0 |
| 2015-03-18 06:20:00 | AAPL | Stock | 31.875 | 31.8875 | 31.875 | 31.885 | 6000.0 |
| 2015-03-18 06:25:00 | AAPL | Stock | 31.875 | 31.875 | 31.875 | 31.875 | 896.0 |
| 2015-03-18 06:30:00 | AAPL | Stock | 31.8625 | 31.875 | 31.8625 | 31.875 | 2736.0 |
| 2015-03-18 06:35:00 | AAPL | Stock | 31.86 | 31.86 | 31.8375 | 31.8375 | 10112.0 |
| 2015-03-18 06:40:00 | AAPL | Stock | 31.8375 | 31.8375 | 31.8 | 31.8 | 9200.0 |
| 2015-03-18 06:45:00 | AAPL | Stock | 31.7825 | 31.8325 | 31.7825 | 31.8 | 17600.0 |
| 2015-03-18 06:50:00 | AAPL | Stock | 31.8 | 31.85 | 31.8 | 31.8275 | 31376.0 |
| 2015-03-18 06:55:00 | AAPL | Stock | 31.8075 | 31.845 | 31.8075 | 31.845 | 800.0 |
| 2015-03-18 07:00:00 | AAPL | Stock | 31.825 | 31.825 | 31.825 | 31.825 | 3832.0 |
| 2015-03-18 07:05:00 | AAPL | Stock | 31.8175 | 31.85 | 31.8125 | 31.8125 | 12180.0 |
| 2015-03-18 07:10:00 | AAPL | Stock | 31.8125 | 31.8125 | 31.7975 | 31.8 | 18400.0 |
| 2015-03-18 07:15:00 | AAPL | Stock | 31.8 | 31.8025 | 31.785 | 31.785 | 11100.0 |
| 2015-03-18 07:20:00 | AAPL | Stock | 31.785 | 31.785 | 31.7625 | 31.7625 | 34380.0 |
| 2015-03-18 07:25:00 | AAPL | Stock | 31.7575 | 31.775 | 31.7575 | 31.775 | 7832.0 |
| 2015-03-18 07:30:00 | AAPL | Stock | 31.775 | 31.775 | 31.7475 | 31.77 | 19140.0 |
| 2015-03-18 07:35:00 | AAPL | Stock | 31.775 | 31.7775 | 31.775 | 31.7775 | 8408.0 |
| 2015-03-18 07:40:00 | AAPL | Stock | 31.7625 | 31.7625 | 31.735 | 31.7575 | 48880.0 |
| 2015-03-18 07:45:00 | AAPL | Stock | 31.7575 | 31.76 | 31.7575 | 31.76 | 7600.0 |
| 2015-03-18 07:50:00 | AAPL | Stock | 31.7475 | 31.7475 | 31.73 | 31.73 | 4400.0 |
| 2015-03-18 07:55:00 | AAPL | Stock | 31.7375 | 31.7375 | 31.725 | 31.725 | 8000.0 |
| 2015-03-18 08:00:00 | AAPL | Stock | 31.76 | 31.845 | 31.675 | 31.6875 | 185172.0 |
| 2015-03-18 08:05:00 | AAPL | Stock | 31.6848 | 31.725 | 31.6848 | 31.7075 | 58760.0 |
| 2015-03-18 08:10:00 | AAPL | Stock | 31.7125 | 31.7175 | 31.695 | 31.695 | 41224.0 |
| 2015-03-18 08:15:00 | AAPL | Stock | 31.695 | 31.725 | 31.6925 | 31.725 | 47552.0 |
| 2015-03-18 08:20:00 | AAPL | Stock | 31.7225 | 31.74 | 31.7175 | 31.725 | 52996.0 |
| 2015-03-18 08:25:00 | AAPL | Stock | 31.7248 | 31.7425 | 31.7248 | 31.7425 | 15800.0 |
| 2015-03-18 08:30:00 | AAPL | Stock | 31.73 | 31.75 | 31.7175 | 31.75 | 58520.0 |
| 2015-03-18 08:35:00 | AAPL | Stock | 31.75 | 31.7625 | 31.7375 | 31.745 | 23152.0 |
| 2015-03-18 08:40:00 | AAPL | Stock | 31.7575 | 31.7725 | 31.75 | 31.7622 | 18624.0 |
| 2015-03-18 08:45:00 | AAPL | Stock | 31.7625 | 31.7625 | 31.7375 | 31.7375 | 21652.0 |
> showing 50 of 364,121 rows — these rows as CSV