PREVIEW / stock_5min / 2020-02-28
file: by_date/stock_5min/2020/2020-02-28.parquet size: 6.9 MB rows: 429,952 symbols: 2,468
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-02-28 04:00:00 | AAPL | Stock | 66.2 | 66.2 | 65.75 | 65.8875 | 78616.0 |
| 2020-02-28 04:05:00 | AAPL | Stock | 65.8875 | 66.3425 | 65.8875 | 66.0 | 43676.0 |
| 2020-02-28 04:10:00 | AAPL | Stock | 65.88 | 66.2475 | 65.65 | 65.7425 | 60380.0 |
| 2020-02-28 04:15:00 | AAPL | Stock | 65.725 | 65.9925 | 65.725 | 65.8 | 20176.0 |
| 2020-02-28 04:20:00 | AAPL | Stock | 65.8 | 65.885 | 65.555 | 65.555 | 55860.0 |
| 2020-02-28 04:25:00 | AAPL | Stock | 65.55 | 65.65 | 65.425 | 65.57 | 30868.0 |
| 2020-02-28 04:30:00 | AAPL | Stock | 65.625 | 65.6925 | 65.375 | 65.6925 | 49744.0 |
| 2020-02-28 04:35:00 | AAPL | Stock | 65.6975 | 65.7475 | 65.625 | 65.625 | 43040.0 |
| 2020-02-28 04:40:00 | AAPL | Stock | 65.735 | 66.005 | 65.735 | 65.8325 | 56076.0 |
| 2020-02-28 04:45:00 | AAPL | Stock | 65.815 | 66.125 | 65.78 | 65.9 | 22628.0 |
| 2020-02-28 04:50:00 | AAPL | Stock | 65.875 | 65.8875 | 65.625 | 65.625 | 17364.0 |
| 2020-02-28 04:55:00 | AAPL | Stock | 65.5075 | 66.0 | 65.5 | 65.9725 | 56308.0 |
| 2020-02-28 05:00:00 | AAPL | Stock | 66.0 | 66.0 | 65.755 | 65.9375 | 30192.0 |
| 2020-02-28 05:05:00 | AAPL | Stock | 65.95 | 66.0 | 65.865 | 65.865 | 15800.0 |
| 2020-02-28 05:10:00 | AAPL | Stock | 65.825 | 66.0425 | 65.75 | 66.0425 | 13108.0 |
| 2020-02-28 05:15:00 | AAPL | Stock | 66.005 | 66.125 | 65.8 | 66.0 | 14488.0 |
| 2020-02-28 05:20:00 | AAPL | Stock | 65.905 | 66.45 | 65.905 | 66.4125 | 17476.0 |
| 2020-02-28 05:25:00 | AAPL | Stock | 66.375 | 66.6125 | 66.2525 | 66.5 | 34860.0 |
| 2020-02-28 05:30:00 | AAPL | Stock | 66.5975 | 66.5975 | 66.1 | 66.3975 | 43564.0 |
| 2020-02-28 05:35:00 | AAPL | Stock | 66.25 | 66.25 | 66.155 | 66.25 | 24960.0 |
| 2020-02-28 05:40:00 | AAPL | Stock | 66.2525 | 66.2525 | 66.125 | 66.175 | 88264.0 |
| 2020-02-28 05:45:00 | AAPL | Stock | 66.25 | 66.25 | 66.15 | 66.2 | 77524.0 |
| 2020-02-28 05:50:00 | AAPL | Stock | 66.2075 | 66.25 | 66.2075 | 66.25 | 35552.0 |
| 2020-02-28 05:55:00 | AAPL | Stock | 66.225 | 66.5 | 66.225 | 66.4875 | 72432.0 |
| 2020-02-28 06:00:00 | AAPL | Stock | 66.47 | 66.5 | 66.4625 | 66.5 | 97064.0 |
| 2020-02-28 06:05:00 | AAPL | Stock | 66.495 | 66.8125 | 66.4525 | 66.7225 | 83828.0 |
| 2020-02-28 06:10:00 | AAPL | Stock | 66.7225 | 66.775 | 66.5825 | 66.625 | 45908.0 |
| 2020-02-28 06:15:00 | AAPL | Stock | 66.5875 | 66.5875 | 66.2625 | 66.3775 | 46488.0 |
| 2020-02-28 06:20:00 | AAPL | Stock | 66.3975 | 66.3975 | 66.2 | 66.225 | 28144.0 |
| 2020-02-28 06:25:00 | AAPL | Stock | 66.2125 | 66.55 | 66.125 | 66.125 | 89572.0 |
| 2020-02-28 06:30:00 | AAPL | Stock | 66.125 | 66.625 | 66.125 | 66.625 | 47468.0 |
| 2020-02-28 06:35:00 | AAPL | Stock | 66.6325 | 66.85 | 66.625 | 66.7525 | 25796.0 |
| 2020-02-28 06:40:00 | AAPL | Stock | 66.765 | 66.765 | 66.3975 | 66.425 | 23024.0 |
| 2020-02-28 06:45:00 | AAPL | Stock | 66.495 | 66.61 | 66.3875 | 66.3875 | 24964.0 |
| 2020-02-28 06:50:00 | AAPL | Stock | 66.5125 | 66.625 | 66.4875 | 66.6225 | 9640.0 |
| 2020-02-28 06:55:00 | AAPL | Stock | 66.6025 | 66.6025 | 66.4875 | 66.5975 | 2608.0 |
| 2020-02-28 07:00:00 | AAPL | Stock | 66.45 | 66.5625 | 66.1775 | 66.325 | 183704.0 |
| 2020-02-28 07:05:00 | AAPL | Stock | 66.3675 | 66.3825 | 66.125 | 66.3375 | 164440.0 |
| 2020-02-28 07:10:00 | AAPL | Stock | 66.35 | 66.555 | 66.15 | 66.525 | 117184.0 |
| 2020-02-28 07:15:00 | AAPL | Stock | 66.555 | 66.805 | 66.45 | 66.75 | 103372.0 |
| 2020-02-28 07:20:00 | AAPL | Stock | 66.7725 | 67.2 | 66.77 | 67.0 | 96780.0 |
| 2020-02-28 07:25:00 | AAPL | Stock | 66.925 | 67.0525 | 66.87 | 67.0525 | 43940.0 |
| 2020-02-28 07:30:00 | AAPL | Stock | 67.0 | 67.1975 | 66.675 | 66.675 | 140444.0 |
| 2020-02-28 07:35:00 | AAPL | Stock | 66.6875 | 67.0 | 66.675 | 66.9 | 76228.0 |
| 2020-02-28 07:40:00 | AAPL | Stock | 66.9 | 67.125 | 66.8625 | 67.125 | 34068.0 |
| 2020-02-28 07:45:00 | AAPL | Stock | 67.1975 | 67.3375 | 66.925 | 67.3375 | 85000.0 |
| 2020-02-28 07:50:00 | AAPL | Stock | 67.3325 | 67.3325 | 66.995 | 66.995 | 39664.0 |
| 2020-02-28 07:55:00 | AAPL | Stock | 67.0 | 67.1 | 66.9075 | 66.9075 | 68368.0 |
| 2020-02-28 08:00:00 | AAPL | Stock | 67.0 | 67.2725 | 66.1775 | 66.565 | 395736.0 |
| 2020-02-28 08:05:00 | AAPL | Stock | 66.5725 | 66.576 | 66.3725 | 66.4875 | 227632.0 |
> showing 50 of 429,952 rows — these rows as CSV