PREVIEW / stock_5min / 2020-07-09
file: by_date/stock_5min/2020/2020-07-09.parquet size: 6.6 MB rows: 415,973 symbols: 2,428
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-07-09 04:20:00 | AAPL | Stock | 95.695 | 95.695 | 95.6925 | 95.6925 | 4420.0 |
| 2020-07-09 04:25:00 | AAPL | Stock | 95.725 | 95.725 | 95.6925 | 95.695 | 4052.0 |
| 2020-07-09 04:35:00 | AAPL | Stock | 95.7475 | 95.795 | 95.7475 | 95.775 | 5708.0 |
| 2020-07-09 04:40:00 | AAPL | Stock | 95.775 | 95.7775 | 95.7525 | 95.7775 | 3636.0 |
| 2020-07-09 04:45:00 | AAPL | Stock | 95.78 | 95.795 | 95.75 | 95.75 | 9352.0 |
| 2020-07-09 05:00:00 | AAPL | Stock | 95.7625 | 95.7625 | 95.7525 | 95.7525 | 960.0 |
| 2020-07-09 05:05:00 | AAPL | Stock | 95.8675 | 95.8975 | 95.8675 | 95.8975 | 5428.0 |
| 2020-07-09 05:10:00 | AAPL | Stock | 95.8725 | 95.875 | 95.7775 | 95.7775 | 5092.0 |
| 2020-07-09 05:15:00 | AAPL | Stock | 95.805 | 95.805 | 95.75 | 95.75 | 14056.0 |
| 2020-07-09 05:25:00 | AAPL | Stock | 95.7375 | 95.775 | 95.7375 | 95.775 | 2000.0 |
| 2020-07-09 05:30:00 | AAPL | Stock | 95.79 | 95.79 | 95.79 | 95.79 | 520.0 |
| 2020-07-09 05:35:00 | AAPL | Stock | 95.7775 | 95.7775 | 95.7775 | 95.7775 | 1200.0 |
| 2020-07-09 05:45:00 | AAPL | Stock | 95.9675 | 96.1225 | 95.9675 | 96.09 | 8696.0 |
| 2020-07-09 05:50:00 | AAPL | Stock | 96.1225 | 96.1225 | 96.1225 | 96.1225 | 400.0 |
| 2020-07-09 05:55:00 | AAPL | Stock | 96.1125 | 96.24 | 96.045 | 96.2175 | 17596.0 |
| 2020-07-09 06:00:00 | AAPL | Stock | 96.205 | 96.225 | 96.2025 | 96.2125 | 6688.0 |
| 2020-07-09 06:05:00 | AAPL | Stock | 96.2125 | 96.215 | 96.2125 | 96.2125 | 4892.0 |
| 2020-07-09 06:10:00 | AAPL | Stock | 96.13 | 96.13 | 96.125 | 96.1275 | 3192.0 |
| 2020-07-09 06:20:00 | AAPL | Stock | 96.175 | 96.175 | 96.175 | 96.175 | 776.0 |
| 2020-07-09 06:30:00 | AAPL | Stock | 96.1875 | 96.1875 | 96.17 | 96.1875 | 8860.0 |
| 2020-07-09 06:35:00 | AAPL | Stock | 96.1875 | 96.19 | 96.0625 | 96.175 | 8208.0 |
| 2020-07-09 06:40:00 | AAPL | Stock | 96.0275 | 96.055 | 96.0275 | 96.055 | 3548.0 |
| 2020-07-09 06:45:00 | AAPL | Stock | 96.035 | 96.175 | 96.0125 | 96.175 | 11560.0 |
| 2020-07-09 06:50:00 | AAPL | Stock | 96.0125 | 96.04 | 95.905 | 95.905 | 4248.0 |
| 2020-07-09 06:55:00 | AAPL | Stock | 95.99 | 95.99 | 95.9325 | 95.9325 | 1860.0 |
| 2020-07-09 07:00:00 | AAPL | Stock | 95.9825 | 96.175 | 95.9325 | 96.175 | 67180.0 |
| 2020-07-09 07:05:00 | AAPL | Stock | 96.175 | 96.1975 | 96.125 | 96.15 | 37672.0 |
| 2020-07-09 07:10:00 | AAPL | Stock | 96.1125 | 96.1625 | 96.1 | 96.1 | 32832.0 |
| 2020-07-09 07:15:00 | AAPL | Stock | 96.11 | 96.125 | 96.0 | 96.0 | 17120.0 |
| 2020-07-09 07:20:00 | AAPL | Stock | 96.0075 | 96.0925 | 96.0075 | 96.07 | 21520.0 |
| 2020-07-09 07:25:00 | AAPL | Stock | 96.075 | 96.2175 | 96.075 | 96.2125 | 33996.0 |
| 2020-07-09 07:30:00 | AAPL | Stock | 96.18 | 96.18 | 96.1325 | 96.1475 | 5624.0 |
| 2020-07-09 07:35:00 | AAPL | Stock | 96.1525 | 96.1925 | 96.1375 | 96.155 | 10796.0 |
| 2020-07-09 07:40:00 | AAPL | Stock | 96.16 | 96.16 | 96.1425 | 96.1425 | 7524.0 |
| 2020-07-09 07:45:00 | AAPL | Stock | 96.1425 | 96.16 | 96.1225 | 96.1225 | 37856.0 |
| 2020-07-09 07:50:00 | AAPL | Stock | 96.15 | 96.15 | 96.125 | 96.125 | 4232.0 |
| 2020-07-09 07:55:00 | AAPL | Stock | 96.1275 | 96.1825 | 96.125 | 96.125 | 22936.0 |
| 2020-07-09 08:00:00 | AAPL | Stock | 96.1808 | 96.2175 | 95.58 | 96.0925 | 164836.0 |
| 2020-07-09 08:05:00 | AAPL | Stock | 96.125 | 96.1875 | 96.0125 | 96.0932 | 21536.0 |
| 2020-07-09 08:10:00 | AAPL | Stock | 96.0525 | 96.0875 | 96.0 | 96.0875 | 22596.0 |
| 2020-07-09 08:15:00 | AAPL | Stock | 96.1075 | 96.16 | 96.0775 | 96.16 | 10484.0 |
| 2020-07-09 08:20:00 | AAPL | Stock | 96.14 | 96.1975 | 96.1375 | 96.1975 | 20152.0 |
| 2020-07-09 08:25:00 | AAPL | Stock | 96.175 | 96.1975 | 96.16 | 96.1782 | 23780.0 |
| 2020-07-09 08:30:00 | AAPL | Stock | 96.2 | 96.25 | 96.1875 | 96.1975 | 42064.0 |
| 2020-07-09 08:35:00 | AAPL | Stock | 96.195 | 96.2725 | 96.175 | 96.2625 | 94300.0 |
| 2020-07-09 08:40:00 | AAPL | Stock | 96.2625 | 96.3375 | 96.25 | 96.3025 | 69972.0 |
| 2020-07-09 08:45:00 | AAPL | Stock | 96.315 | 96.3475 | 96.225 | 96.2925 | 44508.0 |
| 2020-07-09 08:50:00 | AAPL | Stock | 96.2875 | 96.2875 | 96.225 | 96.25 | 28348.0 |
| 2020-07-09 08:55:00 | AAPL | Stock | 96.275 | 96.285 | 96.2 | 96.21 | 48320.0 |
| 2020-07-09 09:00:00 | AAPL | Stock | 96.205 | 96.25 | 96.1757 | 96.2275 | 29764.0 |
> showing 50 of 415,973 rows — these rows as CSV