PREVIEW / stock_5min / 2015-03-24
file: by_date/stock_5min/2015/2015-03-24.parquet size: 5.4 MB rows: 358,845 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-03-24 04:05:00 | AAPL | Stock | 31.805 | 31.805 | 31.805 | 31.805 | 400.0 |
| 2015-03-24 04:30:00 | AAPL | Stock | 31.8725 | 31.8925 | 31.8725 | 31.8925 | 4000.0 |
| 2015-03-24 04:35:00 | AAPL | Stock | 31.8925 | 31.9 | 31.8925 | 31.9 | 3600.0 |
| 2015-03-24 04:40:00 | AAPL | Stock | 31.935 | 31.935 | 31.935 | 31.935 | 400.0 |
| 2015-03-24 05:05:00 | AAPL | Stock | 31.8825 | 31.8825 | 31.8825 | 31.8825 | 580.0 |
| 2015-03-24 05:30:00 | AAPL | Stock | 31.8625 | 31.8625 | 31.8625 | 31.8625 | 800.0 |
| 2015-03-24 05:45:00 | AAPL | Stock | 31.895 | 31.895 | 31.895 | 31.895 | 400.0 |
| 2015-03-24 06:00:00 | AAPL | Stock | 31.9125 | 31.9125 | 31.9125 | 31.9125 | 400.0 |
| 2015-03-24 06:05:00 | AAPL | Stock | 31.9125 | 31.9225 | 31.9125 | 31.9225 | 800.0 |
| 2015-03-24 06:10:00 | AAPL | Stock | 31.92 | 31.9225 | 31.92 | 31.9225 | 800.0 |
| 2015-03-24 06:15:00 | AAPL | Stock | 31.9225 | 31.925 | 31.9225 | 31.925 | 1560.0 |
| 2015-03-24 06:20:00 | AAPL | Stock | 31.925 | 31.925 | 31.9225 | 31.9225 | 800.0 |
| 2015-03-24 06:25:00 | AAPL | Stock | 31.9225 | 31.9225 | 31.9175 | 31.9175 | 5200.0 |
| 2015-03-24 06:30:00 | AAPL | Stock | 31.9175 | 31.92 | 31.9175 | 31.92 | 2000.0 |
| 2015-03-24 06:40:00 | AAPL | Stock | 31.905 | 31.905 | 31.905 | 31.905 | 1200.0 |
| 2015-03-24 06:45:00 | AAPL | Stock | 31.9125 | 31.9125 | 31.9125 | 31.9125 | 800.0 |
| 2015-03-24 06:55:00 | AAPL | Stock | 31.9 | 31.92 | 31.9 | 31.92 | 2564.0 |
| 2015-03-24 07:00:00 | AAPL | Stock | 31.9025 | 31.92 | 31.9 | 31.905 | 15124.0 |
| 2015-03-24 07:10:00 | AAPL | Stock | 31.89 | 31.89 | 31.8725 | 31.875 | 4800.0 |
| 2015-03-24 07:15:00 | AAPL | Stock | 31.8725 | 31.8725 | 31.8725 | 31.8725 | 2456.0 |
| 2015-03-24 07:25:00 | AAPL | Stock | 31.89 | 31.89 | 31.89 | 31.89 | 400.0 |
| 2015-03-24 07:30:00 | AAPL | Stock | 31.8875 | 31.89 | 31.885 | 31.885 | 6512.0 |
| 2015-03-24 07:45:00 | AAPL | Stock | 31.875 | 31.8875 | 31.87 | 31.8875 | 18784.0 |
| 2015-03-24 07:50:00 | AAPL | Stock | 31.8875 | 31.8875 | 31.8825 | 31.8825 | 16000.0 |
| 2015-03-24 07:55:00 | AAPL | Stock | 31.87 | 31.8975 | 31.87 | 31.8875 | 15864.0 |
| 2015-03-24 08:00:00 | AAPL | Stock | 31.8875 | 31.92 | 31.86 | 31.8725 | 140844.0 |
| 2015-03-24 08:05:00 | AAPL | Stock | 31.8575 | 31.8625 | 31.8575 | 31.86 | 12400.0 |
| 2015-03-24 08:10:00 | AAPL | Stock | 31.8675 | 31.87 | 31.8625 | 31.8675 | 38920.0 |
| 2015-03-24 08:15:00 | AAPL | Stock | 31.8625 | 31.8725 | 31.8625 | 31.8725 | 19936.0 |
| 2015-03-24 08:20:00 | AAPL | Stock | 31.8725 | 31.875 | 31.85 | 31.85 | 34200.0 |
| 2015-03-24 08:25:00 | AAPL | Stock | 31.85 | 31.8625 | 31.85 | 31.8625 | 43224.0 |
| 2015-03-24 08:30:00 | AAPL | Stock | 31.855 | 31.8575 | 31.8125 | 31.8125 | 49500.0 |
| 2015-03-24 08:35:00 | AAPL | Stock | 31.795 | 31.8325 | 31.795 | 31.8325 | 34728.0 |
| 2015-03-24 08:40:00 | AAPL | Stock | 31.835 | 31.8625 | 31.835 | 31.86 | 59944.0 |
| 2015-03-24 08:45:00 | AAPL | Stock | 31.8625 | 31.8625 | 31.8525 | 31.8525 | 10800.0 |
| 2015-03-24 08:50:00 | AAPL | Stock | 31.86 | 31.8675 | 31.85 | 31.85 | 19524.0 |
| 2015-03-24 08:55:00 | AAPL | Stock | 31.8425 | 31.8425 | 31.835 | 31.8425 | 15900.0 |
| 2015-03-24 09:00:00 | AAPL | Stock | 31.835 | 31.835 | 31.8175 | 31.82 | 53740.0 |
| 2015-03-24 09:05:00 | AAPL | Stock | 31.8175 | 31.825 | 31.805 | 31.8075 | 56512.0 |
| 2015-03-24 09:10:00 | AAPL | Stock | 31.8075 | 31.8075 | 31.7925 | 31.805 | 40552.0 |
| 2015-03-24 09:15:00 | AAPL | Stock | 31.82 | 31.82 | 31.79 | 31.7975 | 18064.0 |
| 2015-03-24 09:20:00 | AAPL | Stock | 31.8 | 31.815 | 31.795 | 31.8075 | 35332.0 |
| 2015-03-24 09:25:00 | AAPL | Stock | 31.805 | 31.8075 | 31.79 | 31.805 | 47224.0 |
| 2015-03-24 09:30:00 | AAPL | Stock | 31.7975 | 31.815 | 31.6925 | 31.695 | 5174744.0 |
| 2015-03-24 09:35:00 | AAPL | Stock | 31.695 | 31.7325 | 31.64 | 31.7075 | 3939100.0 |
| 2015-03-24 09:40:00 | AAPL | Stock | 31.7025 | 31.71 | 31.65 | 31.685 | 2268324.0 |
| 2015-03-24 09:45:00 | AAPL | Stock | 31.6875 | 31.78 | 31.675 | 31.7575 | 3204944.0 |
| 2015-03-24 09:50:00 | AAPL | Stock | 31.7575 | 31.785 | 31.735 | 31.7675 | 2503876.0 |
| 2015-03-24 09:55:00 | AAPL | Stock | 31.7675 | 31.78 | 31.715 | 31.77 | 1957004.0 |
| 2015-03-24 10:00:00 | AAPL | Stock | 31.77 | 31.83 | 31.7658 | 31.81 | 2558396.0 |
> showing 50 of 358,845 rows — these rows as CSV