PREVIEW / stock_5min / 2020-05-11
file: by_date/stock_5min/2020/2020-05-11.parquet size: 6.5 MB rows: 414,097 symbols: 2,381
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-11 04:00:00 | AAPL | Stock | 77.785 | 77.785 | 77.785 | 77.785 | 968.0 |
| 2020-05-11 04:05:00 | AAPL | Stock | 77.8375 | 77.9125 | 77.785 | 77.7875 | 15844.0 |
| 2020-05-11 04:10:00 | AAPL | Stock | 77.785 | 77.785 | 77.7775 | 77.785 | 5332.0 |
| 2020-05-11 04:15:00 | AAPL | Stock | 77.745 | 77.745 | 77.745 | 77.745 | 936.0 |
| 2020-05-11 04:20:00 | AAPL | Stock | 77.675 | 77.675 | 77.675 | 77.675 | 904.0 |
| 2020-05-11 04:25:00 | AAPL | Stock | 77.6375 | 77.645 | 77.6375 | 77.645 | 1200.0 |
| 2020-05-11 04:30:00 | AAPL | Stock | 77.6475 | 77.65 | 77.6475 | 77.65 | 800.0 |
| 2020-05-11 04:35:00 | AAPL | Stock | 77.5175 | 77.5175 | 77.5 | 77.5 | 5240.0 |
| 2020-05-11 04:40:00 | AAPL | Stock | 77.48 | 77.48 | 77.48 | 77.48 | 47600.0 |
| 2020-05-11 04:45:00 | AAPL | Stock | 77.395 | 77.4175 | 77.395 | 77.4175 | 2484.0 |
| 2020-05-11 04:55:00 | AAPL | Stock | 77.355 | 77.375 | 77.355 | 77.375 | 4400.0 |
| 2020-05-11 05:00:00 | AAPL | Stock | 77.375 | 77.375 | 77.25 | 77.25 | 6004.0 |
| 2020-05-11 05:05:00 | AAPL | Stock | 77.15 | 77.25 | 77.15 | 77.25 | 9104.0 |
| 2020-05-11 05:10:00 | AAPL | Stock | 77.2475 | 77.2475 | 77.2475 | 77.2475 | 1456.0 |
| 2020-05-11 05:20:00 | AAPL | Stock | 77.2325 | 77.2875 | 77.2325 | 77.2875 | 4028.0 |
| 2020-05-11 05:25:00 | AAPL | Stock | 77.275 | 77.2875 | 77.275 | 77.2875 | 10780.0 |
| 2020-05-11 05:35:00 | AAPL | Stock | 77.3325 | 77.3325 | 77.3325 | 77.3325 | 400.0 |
| 2020-05-11 05:40:00 | AAPL | Stock | 77.375 | 77.3775 | 77.375 | 77.3775 | 7640.0 |
| 2020-05-11 05:45:00 | AAPL | Stock | 77.415 | 77.415 | 77.415 | 77.415 | 764.0 |
| 2020-05-11 05:50:00 | AAPL | Stock | 77.4375 | 77.4375 | 77.4375 | 77.4375 | 8048.0 |
| 2020-05-11 05:55:00 | AAPL | Stock | 77.4275 | 77.4275 | 77.4025 | 77.4025 | 4464.0 |
| 2020-05-11 06:00:00 | AAPL | Stock | 77.4 | 77.4 | 77.3275 | 77.3275 | 4184.0 |
| 2020-05-11 06:05:00 | AAPL | Stock | 77.3725 | 77.425 | 77.3725 | 77.425 | 2436.0 |
| 2020-05-11 06:15:00 | AAPL | Stock | 77.3325 | 77.3325 | 77.325 | 77.325 | 2800.0 |
| 2020-05-11 06:20:00 | AAPL | Stock | 77.165 | 77.165 | 77.165 | 77.165 | 400.0 |
| 2020-05-11 06:25:00 | AAPL | Stock | 77.1625 | 77.1625 | 77.1625 | 77.1625 | 404.0 |
| 2020-05-11 06:30:00 | AAPL | Stock | 77.125 | 77.1375 | 77.125 | 77.1375 | 2860.0 |
| 2020-05-11 06:40:00 | AAPL | Stock | 77.1975 | 77.2 | 77.15 | 77.2 | 1476.0 |
| 2020-05-11 06:45:00 | AAPL | Stock | 77.1625 | 77.1625 | 77.1625 | 77.1625 | 3196.0 |
| 2020-05-11 06:50:00 | AAPL | Stock | 77.1775 | 77.1775 | 77.0625 | 77.0625 | 6596.0 |
| 2020-05-11 06:55:00 | AAPL | Stock | 77.05 | 77.165 | 77.0025 | 77.165 | 6456.0 |
| 2020-05-11 07:00:00 | AAPL | Stock | 77.1875 | 77.225 | 77.125 | 77.1325 | 69476.0 |
| 2020-05-11 07:05:00 | AAPL | Stock | 77.1975 | 77.23 | 77.135 | 77.1875 | 16760.0 |
| 2020-05-11 07:10:00 | AAPL | Stock | 77.1875 | 77.25 | 77.1825 | 77.25 | 73768.0 |
| 2020-05-11 07:15:00 | AAPL | Stock | 77.25 | 77.3225 | 77.25 | 77.25 | 25584.0 |
| 2020-05-11 07:20:00 | AAPL | Stock | 77.25 | 77.25 | 77.1525 | 77.1525 | 13820.0 |
| 2020-05-11 07:25:00 | AAPL | Stock | 77.175 | 77.1925 | 77.16 | 77.175 | 13044.0 |
| 2020-05-11 07:30:00 | AAPL | Stock | 77.175 | 77.225 | 77.085 | 77.085 | 58816.0 |
| 2020-05-11 07:35:00 | AAPL | Stock | 77.1175 | 77.1175 | 77.075 | 77.0875 | 13424.0 |
| 2020-05-11 07:40:00 | AAPL | Stock | 77.09 | 77.095 | 77.025 | 77.0425 | 48092.0 |
| 2020-05-11 07:45:00 | AAPL | Stock | 77.035 | 77.035 | 76.9375 | 76.9375 | 149468.0 |
| 2020-05-11 07:50:00 | AAPL | Stock | 76.9425 | 76.9725 | 76.925 | 76.955 | 8928.0 |
| 2020-05-11 07:55:00 | AAPL | Stock | 76.97 | 76.97 | 76.87 | 76.95 | 69808.0 |
| 2020-05-11 08:00:00 | AAPL | Stock | 77.0 | 77.3125 | 76.8125 | 76.925 | 192000.0 |
| 2020-05-11 08:05:00 | AAPL | Stock | 76.9 | 76.9275 | 76.8 | 76.845 | 51320.0 |
| 2020-05-11 08:10:00 | AAPL | Stock | 76.85 | 76.9375 | 76.8225 | 76.9375 | 22680.0 |
| 2020-05-11 08:15:00 | AAPL | Stock | 76.925 | 76.925 | 76.875 | 76.921 | 86744.0 |
| 2020-05-11 08:20:00 | AAPL | Stock | 76.8975 | 76.987 | 76.89 | 76.987 | 22940.0 |
| 2020-05-11 08:25:00 | AAPL | Stock | 76.9825 | 76.9875 | 76.83 | 76.855 | 30424.0 |
| 2020-05-11 08:30:00 | AAPL | Stock | 76.855 | 76.9125 | 76.855 | 76.8825 | 12588.0 |
> showing 50 of 414,097 rows — these rows as CSV