PREVIEW / stock_5min / 2019-02-13
file: by_date/stock_5min/2019/2019-02-13.parquet size: 5.6 MB rows: 350,621 symbols: 2,659
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-02-13 04:00:00 | AAPL | Stock | 42.8775 | 42.8775 | 42.875 | 42.875 | 3600.0 |
| 2019-02-13 04:05:00 | AAPL | Stock | 42.9375 | 42.9375 | 42.9375 | 42.9375 | 400.0 |
| 2019-02-13 04:25:00 | AAPL | Stock | 42.9075 | 42.9075 | 42.875 | 42.875 | 6372.0 |
| 2019-02-13 04:30:00 | AAPL | Stock | 42.945 | 42.945 | 42.945 | 42.945 | 1200.0 |
| 2019-02-13 05:10:00 | AAPL | Stock | 42.8775 | 42.8775 | 42.8775 | 42.8775 | 468.0 |
| 2019-02-13 05:25:00 | AAPL | Stock | 42.9125 | 42.9125 | 42.9125 | 42.9125 | 400.0 |
| 2019-02-13 05:55:00 | AAPL | Stock | 42.895 | 42.895 | 42.895 | 42.895 | 1212.0 |
| 2019-02-13 06:20:00 | AAPL | Stock | 42.9125 | 42.9125 | 42.9125 | 42.9125 | 400.0 |
| 2019-02-13 06:55:00 | AAPL | Stock | 42.915 | 42.915 | 42.915 | 42.915 | 1600.0 |
| 2019-02-13 07:00:00 | AAPL | Stock | 42.9075 | 42.9175 | 42.9 | 42.9175 | 4160.0 |
| 2019-02-13 07:05:00 | AAPL | Stock | 42.92 | 42.9375 | 42.92 | 42.925 | 10052.0 |
| 2019-02-13 07:10:00 | AAPL | Stock | 42.9325 | 42.9325 | 42.9275 | 42.9275 | 1600.0 |
| 2019-02-13 07:15:00 | AAPL | Stock | 42.9375 | 42.9375 | 42.925 | 42.935 | 6524.0 |
| 2019-02-13 07:20:00 | AAPL | Stock | 42.9225 | 42.9225 | 42.9125 | 42.9225 | 6048.0 |
| 2019-02-13 07:25:00 | AAPL | Stock | 42.9325 | 42.9325 | 42.9325 | 42.9325 | 2000.0 |
| 2019-02-13 07:30:00 | AAPL | Stock | 42.925 | 42.925 | 42.895 | 42.895 | 10056.0 |
| 2019-02-13 07:35:00 | AAPL | Stock | 42.915 | 42.915 | 42.915 | 42.915 | 1000.0 |
| 2019-02-13 07:40:00 | AAPL | Stock | 42.9125 | 42.9175 | 42.9125 | 42.9175 | 1600.0 |
| 2019-02-13 07:45:00 | AAPL | Stock | 42.9275 | 42.9275 | 42.92 | 42.92 | 2112.0 |
| 2019-02-13 07:50:00 | AAPL | Stock | 42.92 | 42.92 | 42.9175 | 42.9175 | 7584.0 |
| 2019-02-13 07:55:00 | AAPL | Stock | 42.9025 | 42.905 | 42.895 | 42.9025 | 11660.0 |
| 2019-02-13 08:00:00 | AAPL | Stock | 42.9175 | 42.935 | 42.8275 | 42.875 | 48000.0 |
| 2019-02-13 08:05:00 | AAPL | Stock | 42.875 | 42.8775 | 42.855 | 42.855 | 20296.0 |
| 2019-02-13 08:10:00 | AAPL | Stock | 42.8525 | 42.8625 | 42.85 | 42.85 | 20840.0 |
| 2019-02-13 08:15:00 | AAPL | Stock | 42.86 | 42.86 | 42.8375 | 42.855 | 13924.0 |
| 2019-02-13 08:20:00 | AAPL | Stock | 42.85 | 42.8675 | 42.85 | 42.8675 | 8880.0 |
| 2019-02-13 08:25:00 | AAPL | Stock | 42.8675 | 42.88 | 42.8625 | 42.8625 | 7320.0 |
| 2019-02-13 08:30:00 | AAPL | Stock | 42.855 | 42.855 | 42.8125 | 42.8375 | 15896.0 |
| 2019-02-13 08:35:00 | AAPL | Stock | 42.835 | 42.85 | 42.835 | 42.85 | 4900.0 |
| 2019-02-13 08:40:00 | AAPL | Stock | 42.8575 | 42.8875 | 42.8575 | 42.875 | 24652.0 |
| 2019-02-13 08:45:00 | AAPL | Stock | 42.9 | 42.9175 | 42.8975 | 42.9175 | 15804.0 |
| 2019-02-13 08:50:00 | AAPL | Stock | 42.9125 | 42.9375 | 42.9 | 42.925 | 54064.0 |
| 2019-02-13 08:55:00 | AAPL | Stock | 42.91 | 42.9125 | 42.8825 | 42.9125 | 45452.0 |
| 2019-02-13 09:00:00 | AAPL | Stock | 42.895 | 42.9125 | 42.8875 | 42.9125 | 7216.0 |
| 2019-02-13 09:05:00 | AAPL | Stock | 42.9125 | 42.9125 | 42.885 | 42.885 | 9136.0 |
| 2019-02-13 09:10:00 | AAPL | Stock | 42.885 | 42.8875 | 42.855 | 42.88 | 13980.0 |
| 2019-02-13 09:15:00 | AAPL | Stock | 42.88 | 42.8925 | 42.875 | 42.875 | 23360.0 |
| 2019-02-13 09:20:00 | AAPL | Stock | 42.8825 | 42.89 | 42.8725 | 42.8875 | 4512.0 |
| 2019-02-13 09:25:00 | AAPL | Stock | 42.875 | 42.875 | 42.8055 | 42.86 | 45836.0 |
| 2019-02-13 09:30:00 | AAPL | Stock | 42.8575 | 42.9825 | 42.77 | 42.93 | 4100668.0 |
| 2019-02-13 09:35:00 | AAPL | Stock | 42.9268 | 43.0775 | 42.9075 | 43.075 | 2395180.0 |
| 2019-02-13 09:40:00 | AAPL | Stock | 43.0788 | 43.12 | 42.9275 | 42.9825 | 2870260.0 |
| 2019-02-13 09:45:00 | AAPL | Stock | 42.985 | 43.0025 | 42.8975 | 42.9675 | 1494404.0 |
| 2019-02-13 09:50:00 | AAPL | Stock | 42.9725 | 42.9775 | 42.8925 | 42.9263 | 1281312.0 |
| 2019-02-13 09:55:00 | AAPL | Stock | 42.9263 | 42.9775 | 42.8625 | 42.8825 | 1189412.0 |
| 2019-02-13 10:00:00 | AAPL | Stock | 42.88 | 42.935 | 42.8375 | 42.9025 | 1232020.0 |
| 2019-02-13 10:05:00 | AAPL | Stock | 42.9025 | 42.915 | 42.845 | 42.8675 | 1366336.0 |
| 2019-02-13 10:10:00 | AAPL | Stock | 42.865 | 42.9325 | 42.78 | 42.7915 | 1982204.0 |
| 2019-02-13 10:15:00 | AAPL | Stock | 42.7925 | 42.8575 | 42.7375 | 42.8568 | 1406644.0 |
| 2019-02-13 10:20:00 | AAPL | Stock | 42.858 | 42.895 | 42.825 | 42.8675 | 1013200.0 |
> showing 50 of 350,621 rows — these rows as CSV