PREVIEW / stock_5min / 2019-04-25
file: by_date/stock_5min/2019/2019-04-25.parquet size: 5.6 MB rows: 355,415 symbols: 2,608
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 |
|---|---|---|---|---|---|---|---|
| 2019-04-25 04:00:00 | AAPL | Stock | 51.965 | 51.965 | 51.94 | 51.94 | 6976.0 |
| 2019-04-25 04:10:00 | AAPL | Stock | 51.8625 | 51.8625 | 51.8625 | 51.8625 | 4836.0 |
| 2019-04-25 04:25:00 | AAPL | Stock | 51.8925 | 51.8925 | 51.8925 | 51.8925 | 400.0 |
| 2019-04-25 04:40:00 | AAPL | Stock | 51.885 | 51.885 | 51.885 | 51.885 | 400.0 |
| 2019-04-25 05:30:00 | AAPL | Stock | 51.9 | 51.9 | 51.9 | 51.9 | 1860.0 |
| 2019-04-25 05:45:00 | AAPL | Stock | 51.9125 | 51.9125 | 51.9 | 51.9 | 2140.0 |
| 2019-04-25 05:50:00 | AAPL | Stock | 51.875 | 51.875 | 51.875 | 51.875 | 1044.0 |
| 2019-04-25 05:55:00 | AAPL | Stock | 51.875 | 51.875 | 51.875 | 51.875 | 2000.0 |
| 2019-04-25 06:05:00 | AAPL | Stock | 51.8875 | 51.8875 | 51.8875 | 51.8875 | 400.0 |
| 2019-04-25 06:10:00 | AAPL | Stock | 51.8775 | 51.925 | 51.8775 | 51.925 | 2000.0 |
| 2019-04-25 06:20:00 | AAPL | Stock | 51.9 | 51.9 | 51.9 | 51.9 | 2160.0 |
| 2019-04-25 06:30:00 | AAPL | Stock | 51.875 | 51.875 | 51.875 | 51.875 | 9580.0 |
| 2019-04-25 06:35:00 | AAPL | Stock | 51.875 | 51.875 | 51.805 | 51.805 | 2088.0 |
| 2019-04-25 06:55:00 | AAPL | Stock | 51.86 | 51.8625 | 51.86 | 51.8625 | 2208.0 |
| 2019-04-25 07:00:00 | AAPL | Stock | 51.8475 | 51.975 | 51.8475 | 51.9625 | 19068.0 |
| 2019-04-25 07:05:00 | AAPL | Stock | 51.9725 | 51.9925 | 51.93 | 51.9375 | 18628.0 |
| 2019-04-25 07:10:00 | AAPL | Stock | 51.9125 | 51.9125 | 51.8875 | 51.89 | 4556.0 |
| 2019-04-25 07:15:00 | AAPL | Stock | 51.9 | 51.9 | 51.8875 | 51.895 | 3284.0 |
| 2019-04-25 07:20:00 | AAPL | Stock | 51.9 | 51.9 | 51.88 | 51.8875 | 3668.0 |
| 2019-04-25 07:25:00 | AAPL | Stock | 51.8975 | 51.8975 | 51.8975 | 51.8975 | 1200.0 |
| 2019-04-25 07:30:00 | AAPL | Stock | 51.95 | 51.95 | 51.8875 | 51.9225 | 6400.0 |
| 2019-04-25 07:35:00 | AAPL | Stock | 51.925 | 51.925 | 51.9 | 51.9 | 1200.0 |
| 2019-04-25 07:40:00 | AAPL | Stock | 51.905 | 51.905 | 51.8875 | 51.8925 | 7952.0 |
| 2019-04-25 07:45:00 | AAPL | Stock | 51.905 | 51.905 | 51.9 | 51.9 | 800.0 |
| 2019-04-25 07:50:00 | AAPL | Stock | 51.9 | 51.9 | 51.9 | 51.9 | 3852.0 |
| 2019-04-25 07:55:00 | AAPL | Stock | 51.895 | 51.94 | 51.895 | 51.9375 | 12452.0 |
| 2019-04-25 08:00:00 | AAPL | Stock | 51.95 | 51.9725 | 51.8625 | 51.9325 | 68124.0 |
| 2019-04-25 08:05:00 | AAPL | Stock | 51.92 | 51.9323 | 51.9 | 51.9323 | 5468.0 |
| 2019-04-25 08:10:00 | AAPL | Stock | 51.9125 | 51.9475 | 51.9125 | 51.9475 | 12132.0 |
| 2019-04-25 08:15:00 | AAPL | Stock | 51.9475 | 51.97 | 51.9275 | 51.93 | 23376.0 |
| 2019-04-25 08:20:00 | AAPL | Stock | 51.935 | 51.97 | 51.935 | 51.95 | 8484.0 |
| 2019-04-25 08:25:00 | AAPL | Stock | 51.95 | 51.9625 | 51.95 | 51.9625 | 5332.0 |
| 2019-04-25 08:30:00 | AAPL | Stock | 51.95 | 51.95 | 51.8875 | 51.925 | 14196.0 |
| 2019-04-25 08:35:00 | AAPL | Stock | 51.915 | 51.9275 | 51.8875 | 51.9 | 9824.0 |
| 2019-04-25 08:40:00 | AAPL | Stock | 51.9272 | 51.9425 | 51.9225 | 51.9425 | 10648.0 |
| 2019-04-25 08:45:00 | AAPL | Stock | 51.93 | 51.93 | 51.875 | 51.875 | 15600.0 |
| 2019-04-25 08:50:00 | AAPL | Stock | 51.8825 | 51.9 | 51.86 | 51.875 | 49948.0 |
| 2019-04-25 08:55:00 | AAPL | Stock | 51.865 | 51.88 | 51.8575 | 51.8575 | 20820.0 |
| 2019-04-25 09:00:00 | AAPL | Stock | 51.885 | 51.885 | 51.875 | 51.875 | 3600.0 |
| 2019-04-25 09:05:00 | AAPL | Stock | 51.87 | 51.875 | 51.8425 | 51.85 | 38636.0 |
| 2019-04-25 09:10:00 | AAPL | Stock | 51.85 | 51.895 | 51.85 | 51.895 | 22724.0 |
| 2019-04-25 09:15:00 | AAPL | Stock | 51.88 | 51.8875 | 51.86 | 51.88 | 29712.0 |
| 2019-04-25 09:20:00 | AAPL | Stock | 51.86 | 51.895 | 51.85 | 51.875 | 23988.0 |
| 2019-04-25 09:25:00 | AAPL | Stock | 51.8625 | 51.885 | 51.6925 | 51.71 | 157696.0 |
| 2019-04-25 09:30:00 | AAPL | Stock | 51.71 | 51.94 | 51.6625 | 51.845 | 4294820.0 |
| 2019-04-25 09:35:00 | AAPL | Stock | 51.84 | 51.89 | 51.705 | 51.7275 | 1751472.0 |
| 2019-04-25 09:40:00 | AAPL | Stock | 51.7275 | 51.7712 | 51.6825 | 51.7225 | 1741724.0 |
| 2019-04-25 09:45:00 | AAPL | Stock | 51.72 | 51.83 | 51.6975 | 51.8 | 1130628.0 |
| 2019-04-25 09:50:00 | AAPL | Stock | 51.7988 | 51.8145 | 51.7162 | 51.73 | 1021304.0 |
| 2019-04-25 09:55:00 | AAPL | Stock | 51.7325 | 51.7575 | 51.6825 | 51.6925 | 1062968.0 |
> showing 50 of 355,415 rows — these rows as CSV