PREVIEW / stock_5min / 2018-06-12
file: by_date/stock_5min/2018/2018-06-12.parquet size: 5.7 MB rows: 365,103 symbols: 2,823
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-06-12 04:00:00 | AAPL | Stock | 47.8725 | 47.8725 | 47.8725 | 47.8725 | 400.0 |
| 2018-06-12 04:05:00 | AAPL | Stock | 47.8725 | 47.8725 | 47.8725 | 47.8725 | 400.0 |
| 2018-06-12 04:20:00 | AAPL | Stock | 47.8425 | 47.8425 | 47.8425 | 47.8425 | 400.0 |
| 2018-06-12 04:30:00 | AAPL | Stock | 47.83 | 47.83 | 47.83 | 47.83 | 400.0 |
| 2018-06-12 07:00:00 | AAPL | Stock | 47.75 | 47.7925 | 47.75 | 47.775 | 4840.0 |
| 2018-06-12 07:05:00 | AAPL | Stock | 47.775 | 47.775 | 47.775 | 47.775 | 1600.0 |
| 2018-06-12 07:10:00 | AAPL | Stock | 47.78 | 47.83 | 47.78 | 47.83 | 16800.0 |
| 2018-06-12 07:15:00 | AAPL | Stock | 47.7875 | 47.79 | 47.7875 | 47.79 | 1364.0 |
| 2018-06-12 07:20:00 | AAPL | Stock | 47.7875 | 47.8025 | 47.7625 | 47.765 | 5968.0 |
| 2018-06-12 07:25:00 | AAPL | Stock | 47.775 | 47.775 | 47.7625 | 47.7625 | 800.0 |
| 2018-06-12 07:30:00 | AAPL | Stock | 47.8 | 47.8075 | 47.755 | 47.755 | 7952.0 |
| 2018-06-12 07:35:00 | AAPL | Stock | 47.8075 | 47.8075 | 47.79 | 47.79 | 1676.0 |
| 2018-06-12 07:40:00 | AAPL | Stock | 47.8075 | 47.8075 | 47.8075 | 47.8075 | 7860.0 |
| 2018-06-12 07:45:00 | AAPL | Stock | 47.8 | 47.8 | 47.8 | 47.8 | 400.0 |
| 2018-06-12 07:50:00 | AAPL | Stock | 47.8175 | 47.825 | 47.8175 | 47.825 | 9880.0 |
| 2018-06-12 08:00:00 | AAPL | Stock | 47.8075 | 47.9125 | 47.7525 | 47.83 | 46324.0 |
| 2018-06-12 08:05:00 | AAPL | Stock | 47.8325 | 47.8375 | 47.825 | 47.835 | 11896.0 |
| 2018-06-12 08:10:00 | AAPL | Stock | 47.835 | 47.8375 | 47.825 | 47.825 | 2956.0 |
| 2018-06-12 08:15:00 | AAPL | Stock | 47.83 | 47.83 | 47.8125 | 47.8125 | 12892.0 |
| 2018-06-12 08:20:00 | AAPL | Stock | 47.8125 | 47.8325 | 47.8125 | 47.83 | 19900.0 |
| 2018-06-12 08:25:00 | AAPL | Stock | 47.8325 | 47.85 | 47.825 | 47.825 | 44596.0 |
| 2018-06-12 08:30:00 | AAPL | Stock | 47.835 | 47.8625 | 47.835 | 47.8625 | 8860.0 |
| 2018-06-12 08:35:00 | AAPL | Stock | 47.8375 | 47.85 | 47.8275 | 47.8475 | 8664.0 |
| 2018-06-12 08:40:00 | AAPL | Stock | 47.8475 | 47.8625 | 47.8375 | 47.8625 | 33600.0 |
| 2018-06-12 08:45:00 | AAPL | Stock | 47.8695 | 47.8695 | 47.8695 | 47.8695 | 436.0 |
| 2018-06-12 08:50:00 | AAPL | Stock | 47.8625 | 47.8875 | 47.86 | 47.875 | 26392.0 |
| 2018-06-12 08:55:00 | AAPL | Stock | 47.875 | 47.8875 | 47.8625 | 47.885 | 13736.0 |
| 2018-06-12 09:00:00 | AAPL | Stock | 47.875 | 47.885 | 47.875 | 47.885 | 3100.0 |
| 2018-06-12 09:05:00 | AAPL | Stock | 47.8825 | 47.8825 | 47.88 | 47.88 | 2508.0 |
| 2018-06-12 09:10:00 | AAPL | Stock | 47.87 | 47.8875 | 47.8625 | 47.8875 | 7764.0 |
| 2018-06-12 09:15:00 | AAPL | Stock | 47.8875 | 47.8975 | 47.8875 | 47.89 | 5560.0 |
| 2018-06-12 09:20:00 | AAPL | Stock | 47.89 | 47.9 | 47.88 | 47.9 | 13288.0 |
| 2018-06-12 09:25:00 | AAPL | Stock | 47.8825 | 47.9125 | 47.83 | 47.85 | 36208.0 |
| 2018-06-12 09:30:00 | AAPL | Stock | 47.8462 | 47.9325 | 47.7875 | 47.893 | 2213604.0 |
| 2018-06-12 09:35:00 | AAPL | Stock | 47.8938 | 47.915 | 47.84 | 47.8625 | 1066044.0 |
| 2018-06-12 09:40:00 | AAPL | Stock | 47.8625 | 47.935 | 47.83 | 47.883 | 1140508.0 |
| 2018-06-12 09:45:00 | AAPL | Stock | 47.885 | 47.9475 | 47.8575 | 47.86 | 1458568.0 |
| 2018-06-12 09:50:00 | AAPL | Stock | 47.8625 | 47.8725 | 47.79 | 47.82 | 1216700.0 |
| 2018-06-12 09:55:00 | AAPL | Stock | 47.82 | 47.865 | 47.7875 | 47.8075 | 951456.0 |
| 2018-06-12 10:00:00 | AAPL | Stock | 47.8075 | 47.8775 | 47.8 | 47.86 | 743436.0 |
| 2018-06-12 10:05:00 | AAPL | Stock | 47.8588 | 47.9025 | 47.85 | 47.89 | 658068.0 |
| 2018-06-12 10:10:00 | AAPL | Stock | 47.8925 | 47.9425 | 47.892 | 47.94 | 1016060.0 |
| 2018-06-12 10:15:00 | AAPL | Stock | 47.935 | 47.9725 | 47.8825 | 47.9075 | 1068816.0 |
| 2018-06-12 10:20:00 | AAPL | Stock | 47.905 | 47.9275 | 47.875 | 47.8975 | 651088.0 |
| 2018-06-12 10:25:00 | AAPL | Stock | 47.895 | 47.895 | 47.8575 | 47.8775 | 555456.0 |
| 2018-06-12 10:30:00 | AAPL | Stock | 47.8775 | 47.93 | 47.8765 | 47.9025 | 592656.0 |
| 2018-06-12 10:35:00 | AAPL | Stock | 47.9025 | 47.92 | 47.835 | 47.8588 | 965608.0 |
| 2018-06-12 10:40:00 | AAPL | Stock | 47.86 | 47.905 | 47.8575 | 47.8888 | 645220.0 |
| 2018-06-12 10:45:00 | AAPL | Stock | 47.89 | 47.9175 | 47.88 | 47.9025 | 571548.0 |
| 2018-06-12 10:50:00 | AAPL | Stock | 47.905 | 47.9125 | 47.87 | 47.8775 | 462160.0 |
> showing 50 of 365,103 rows — these rows as CSV