PREVIEW / stock_5min / 2018-08-10
file: by_date/stock_5min/2018/2018-08-10.parquet size: 5.5 MB rows: 348,701 symbols: 2,773
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-08-10 04:00:00 | AAPL | Stock | 51.975 | 51.975 | 51.75 | 51.7825 | 16300.0 |
| 2018-08-10 04:05:00 | AAPL | Stock | 51.8075 | 51.8075 | 51.8075 | 51.8075 | 2400.0 |
| 2018-08-10 04:15:00 | AAPL | Stock | 51.8125 | 51.8125 | 51.8025 | 51.8025 | 8740.0 |
| 2018-08-10 04:30:00 | AAPL | Stock | 51.8125 | 51.8125 | 51.78 | 51.78 | 6320.0 |
| 2018-08-10 04:35:00 | AAPL | Stock | 51.815 | 51.85 | 51.815 | 51.85 | 2800.0 |
| 2018-08-10 04:40:00 | AAPL | Stock | 51.85 | 51.85 | 51.85 | 51.85 | 2800.0 |
| 2018-08-10 04:45:00 | AAPL | Stock | 51.85 | 51.85 | 51.85 | 51.85 | 2000.0 |
| 2018-08-10 04:55:00 | AAPL | Stock | 51.8475 | 51.8475 | 51.8475 | 51.8475 | 2000.0 |
| 2018-08-10 05:00:00 | AAPL | Stock | 51.8475 | 51.8475 | 51.8475 | 51.8475 | 2000.0 |
| 2018-08-10 05:10:00 | AAPL | Stock | 51.8475 | 51.85 | 51.8475 | 51.85 | 3524.0 |
| 2018-08-10 05:15:00 | AAPL | Stock | 51.8725 | 51.8725 | 51.8725 | 51.8725 | 1200.0 |
| 2018-08-10 05:30:00 | AAPL | Stock | 51.8725 | 51.8725 | 51.8725 | 51.8725 | 780.0 |
| 2018-08-10 05:35:00 | AAPL | Stock | 51.8725 | 51.8725 | 51.8725 | 51.8725 | 2708.0 |
| 2018-08-10 05:40:00 | AAPL | Stock | 51.8625 | 51.8625 | 51.8125 | 51.8125 | 9024.0 |
| 2018-08-10 05:45:00 | AAPL | Stock | 51.8725 | 51.8725 | 51.865 | 51.865 | 1600.0 |
| 2018-08-10 05:50:00 | AAPL | Stock | 51.86 | 51.8725 | 51.86 | 51.8725 | 6640.0 |
| 2018-08-10 05:55:00 | AAPL | Stock | 51.825 | 51.825 | 51.825 | 51.825 | 496.0 |
| 2018-08-10 06:00:00 | AAPL | Stock | 51.8 | 51.86 | 51.8 | 51.8 | 3040.0 |
| 2018-08-10 06:05:00 | AAPL | Stock | 51.8025 | 51.8025 | 51.8025 | 51.8025 | 1600.0 |
| 2018-08-10 06:15:00 | AAPL | Stock | 51.84 | 51.845 | 51.84 | 51.845 | 2000.0 |
| 2018-08-10 06:20:00 | AAPL | Stock | 51.8525 | 51.865 | 51.8525 | 51.8625 | 5920.0 |
| 2018-08-10 06:25:00 | AAPL | Stock | 51.8725 | 51.8775 | 51.8725 | 51.8725 | 6360.0 |
| 2018-08-10 06:30:00 | AAPL | Stock | 51.8725 | 51.8725 | 51.8575 | 51.8575 | 1660.0 |
| 2018-08-10 06:35:00 | AAPL | Stock | 51.8725 | 51.875 | 51.8725 | 51.875 | 3112.0 |
| 2018-08-10 06:40:00 | AAPL | Stock | 51.875 | 51.895 | 51.875 | 51.895 | 3880.0 |
| 2018-08-10 06:45:00 | AAPL | Stock | 51.8775 | 51.8825 | 51.875 | 51.875 | 7480.0 |
| 2018-08-10 06:50:00 | AAPL | Stock | 51.895 | 51.895 | 51.895 | 51.895 | 652.0 |
| 2018-08-10 06:55:00 | AAPL | Stock | 51.8925 | 51.9 | 51.8875 | 51.8875 | 7640.0 |
| 2018-08-10 07:00:00 | AAPL | Stock | 51.9175 | 51.9325 | 51.9 | 51.9 | 11112.0 |
| 2018-08-10 07:05:00 | AAPL | Stock | 51.9 | 51.9675 | 51.8875 | 51.9675 | 43908.0 |
| 2018-08-10 07:10:00 | AAPL | Stock | 51.9375 | 51.9375 | 51.9025 | 51.925 | 3568.0 |
| 2018-08-10 07:15:00 | AAPL | Stock | 51.925 | 51.93 | 51.905 | 51.91 | 10800.0 |
| 2018-08-10 07:20:00 | AAPL | Stock | 51.925 | 51.95 | 51.925 | 51.95 | 13880.0 |
| 2018-08-10 07:25:00 | AAPL | Stock | 51.9475 | 51.9475 | 51.9175 | 51.9225 | 17856.0 |
| 2018-08-10 07:30:00 | AAPL | Stock | 51.9125 | 51.9375 | 51.9125 | 51.925 | 10056.0 |
| 2018-08-10 07:35:00 | AAPL | Stock | 51.9275 | 51.9275 | 51.9125 | 51.9125 | 16320.0 |
| 2018-08-10 07:40:00 | AAPL | Stock | 51.9125 | 51.9125 | 51.9 | 51.9 | 6000.0 |
| 2018-08-10 07:45:00 | AAPL | Stock | 51.9125 | 51.9125 | 51.8825 | 51.885 | 5600.0 |
| 2018-08-10 07:50:00 | AAPL | Stock | 51.8825 | 51.8875 | 51.85 | 51.875 | 32612.0 |
| 2018-08-10 07:55:00 | AAPL | Stock | 51.8625 | 51.875 | 51.85 | 51.85 | 4356.0 |
| 2018-08-10 08:00:00 | AAPL | Stock | 51.9105 | 51.9625 | 51.8375 | 51.8375 | 81696.0 |
| 2018-08-10 08:05:00 | AAPL | Stock | 51.86 | 51.86 | 51.8475 | 51.85 | 14096.0 |
| 2018-08-10 08:10:00 | AAPL | Stock | 51.85 | 51.875 | 51.85 | 51.875 | 84928.0 |
| 2018-08-10 08:15:00 | AAPL | Stock | 51.8625 | 51.865 | 51.8625 | 51.865 | 16400.0 |
| 2018-08-10 08:20:00 | AAPL | Stock | 51.865 | 51.9075 | 51.865 | 51.9075 | 48556.0 |
| 2018-08-10 08:25:00 | AAPL | Stock | 51.9 | 51.9 | 51.88 | 51.88 | 9200.0 |
| 2018-08-10 08:30:00 | AAPL | Stock | 51.885 | 51.9275 | 51.865 | 51.9 | 12480.0 |
| 2018-08-10 08:35:00 | AAPL | Stock | 51.925 | 51.9275 | 51.89 | 51.9225 | 17200.0 |
| 2018-08-10 08:40:00 | AAPL | Stock | 51.9225 | 51.9325 | 51.9125 | 51.9125 | 57120.0 |
| 2018-08-10 08:45:00 | AAPL | Stock | 51.9125 | 51.9225 | 51.8875 | 51.8875 | 38460.0 |
> showing 50 of 348,701 rows — these rows as CSV