PREVIEW / stock_5min / 2018-04-19
file: by_date/stock_5min/2018/2018-04-19.parquet size: 5.4 MB rows: 349,724 symbols: 2,847
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 |
|---|---|---|---|---|---|---|---|
| 2018-04-19 04:00:00 | AAPL | Stock | 44.325 | 44.325 | 44.25 | 44.25 | 6800.0 |
| 2018-04-19 04:05:00 | AAPL | Stock | 44.2075 | 44.2075 | 44.2075 | 44.2075 | 800.0 |
| 2018-04-19 04:30:00 | AAPL | Stock | 44.2075 | 44.2075 | 44.2075 | 44.2075 | 800.0 |
| 2018-04-19 04:50:00 | AAPL | Stock | 44.1925 | 44.1925 | 44.19 | 44.19 | 8400.0 |
| 2018-04-19 05:00:00 | AAPL | Stock | 44.125 | 44.125 | 44.12 | 44.12 | 1260.0 |
| 2018-04-19 05:05:00 | AAPL | Stock | 44.1475 | 44.1475 | 44.1475 | 44.1475 | 440.0 |
| 2018-04-19 05:15:00 | AAPL | Stock | 44.15 | 44.15 | 44.0125 | 44.0725 | 8636.0 |
| 2018-04-19 05:50:00 | AAPL | Stock | 44.0975 | 44.0975 | 44.0975 | 44.0975 | 736.0 |
| 2018-04-19 06:05:00 | AAPL | Stock | 44.0875 | 44.0875 | 44.0875 | 44.0875 | 400.0 |
| 2018-04-19 06:10:00 | AAPL | Stock | 44.05 | 44.05 | 44.0 | 44.0 | 6224.0 |
| 2018-04-19 06:15:00 | AAPL | Stock | 43.9875 | 43.9875 | 43.875 | 43.915 | 8744.0 |
| 2018-04-19 06:20:00 | AAPL | Stock | 43.875 | 43.875 | 43.875 | 43.875 | 10712.0 |
| 2018-04-19 06:25:00 | AAPL | Stock | 43.885 | 43.885 | 43.885 | 43.885 | 800.0 |
| 2018-04-19 06:30:00 | AAPL | Stock | 43.875 | 43.875 | 43.87 | 43.87 | 1200.0 |
| 2018-04-19 06:35:00 | AAPL | Stock | 43.87 | 43.8775 | 43.87 | 43.8775 | 4800.0 |
| 2018-04-19 06:40:00 | AAPL | Stock | 43.875 | 43.875 | 43.875 | 43.875 | 4640.0 |
| 2018-04-19 06:45:00 | AAPL | Stock | 43.9125 | 43.9125 | 43.85 | 43.85 | 16000.0 |
| 2018-04-19 06:50:00 | AAPL | Stock | 43.85 | 43.85 | 43.85 | 43.85 | 3200.0 |
| 2018-04-19 06:55:00 | AAPL | Stock | 43.8125 | 43.8125 | 43.6375 | 43.7125 | 31156.0 |
| 2018-04-19 07:00:00 | AAPL | Stock | 43.7125 | 43.875 | 43.7125 | 43.8625 | 77836.0 |
| 2018-04-19 07:05:00 | AAPL | Stock | 43.8725 | 44.0 | 43.8625 | 44.0 | 46832.0 |
| 2018-04-19 07:10:00 | AAPL | Stock | 44.0 | 44.0125 | 43.8975 | 43.8975 | 38552.0 |
| 2018-04-19 07:15:00 | AAPL | Stock | 43.8875 | 43.9 | 43.8625 | 43.8775 | 68076.0 |
| 2018-04-19 07:20:00 | AAPL | Stock | 43.875 | 43.9 | 43.8375 | 43.86 | 38432.0 |
| 2018-04-19 07:25:00 | AAPL | Stock | 43.8625 | 43.8775 | 43.85 | 43.8625 | 105544.0 |
| 2018-04-19 07:30:00 | AAPL | Stock | 43.8525 | 43.8725 | 43.85 | 43.8525 | 31136.0 |
| 2018-04-19 07:35:00 | AAPL | Stock | 43.8475 | 43.8525 | 43.825 | 43.8375 | 13720.0 |
| 2018-04-19 07:40:00 | AAPL | Stock | 43.8275 | 43.8475 | 43.825 | 43.825 | 6220.0 |
| 2018-04-19 07:45:00 | AAPL | Stock | 43.8375 | 43.85 | 43.8375 | 43.85 | 5280.0 |
| 2018-04-19 07:50:00 | AAPL | Stock | 43.855 | 43.8725 | 43.8375 | 43.85 | 56536.0 |
| 2018-04-19 07:55:00 | AAPL | Stock | 43.845 | 43.85 | 43.825 | 43.825 | 49096.0 |
| 2018-04-19 08:00:00 | AAPL | Stock | 43.82 | 44.0 | 43.6875 | 43.7 | 418276.0 |
| 2018-04-19 08:05:00 | AAPL | Stock | 43.6975 | 43.745 | 43.67 | 43.7125 | 110816.0 |
| 2018-04-19 08:10:00 | AAPL | Stock | 43.7125 | 43.7375 | 43.665 | 43.68 | 83180.0 |
| 2018-04-19 08:15:00 | AAPL | Stock | 43.685 | 43.725 | 43.68 | 43.69 | 44740.0 |
| 2018-04-19 08:20:00 | AAPL | Stock | 43.705 | 43.7125 | 43.65 | 43.65 | 104872.0 |
| 2018-04-19 08:25:00 | AAPL | Stock | 43.6525 | 43.695 | 43.6432 | 43.66 | 58284.0 |
| 2018-04-19 08:30:00 | AAPL | Stock | 43.6625 | 43.6775 | 43.625 | 43.6625 | 86284.0 |
| 2018-04-19 08:35:00 | AAPL | Stock | 43.6775 | 43.715 | 43.6725 | 43.7 | 80404.0 |
| 2018-04-19 08:40:00 | AAPL | Stock | 43.7 | 43.71 | 43.6525 | 43.71 | 100884.0 |
| 2018-04-19 08:45:00 | AAPL | Stock | 43.7 | 43.8025 | 43.7 | 43.7925 | 80784.0 |
| 2018-04-19 08:50:00 | AAPL | Stock | 43.7875 | 43.795 | 43.7475 | 43.75 | 55344.0 |
| 2018-04-19 08:55:00 | AAPL | Stock | 43.75 | 43.7575 | 43.7 | 43.7225 | 125228.0 |
| 2018-04-19 09:00:00 | AAPL | Stock | 43.7225 | 43.795 | 43.6875 | 43.7775 | 107268.0 |
| 2018-04-19 09:05:00 | AAPL | Stock | 43.79 | 43.8375 | 43.7625 | 43.795 | 138024.0 |
| 2018-04-19 09:10:00 | AAPL | Stock | 43.8 | 43.9 | 43.775 | 43.8225 | 104832.0 |
| 2018-04-19 09:15:00 | AAPL | Stock | 43.815 | 43.835 | 43.7775 | 43.7875 | 73176.0 |
| 2018-04-19 09:20:00 | AAPL | Stock | 43.7875 | 43.79 | 43.7175 | 43.7175 | 169316.0 |
| 2018-04-19 09:25:00 | AAPL | Stock | 43.725 | 43.75 | 43.6975 | 43.725 | 146524.0 |
| 2018-04-19 09:30:00 | AAPL | Stock | 43.735 | 43.8475 | 43.62 | 43.735 | 6459388.0 |
> showing 50 of 349,724 rows — these rows as CSV