PREVIEW / stock_5min / 2020-02-18
file: by_date/stock_5min/2020/2020-02-18.parquet size: 6.0 MB rows: 368,160 symbols: 2,420
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-18 04:00:00 | AAPL | Stock | 78.2375 | 78.2375 | 77.5175 | 77.985 | 89428.0 |
| 2020-02-18 04:05:00 | AAPL | Stock | 77.9375 | 77.9975 | 77.805 | 77.85 | 44092.0 |
| 2020-02-18 04:10:00 | AAPL | Stock | 77.7925 | 78.125 | 77.7925 | 78.0875 | 62908.0 |
| 2020-02-18 04:15:00 | AAPL | Stock | 78.1 | 78.325 | 78.1 | 78.2925 | 32820.0 |
| 2020-02-18 04:20:00 | AAPL | Stock | 78.2875 | 78.3625 | 78.2625 | 78.3625 | 32012.0 |
| 2020-02-18 04:25:00 | AAPL | Stock | 78.3575 | 78.3825 | 78.2475 | 78.2475 | 32088.0 |
| 2020-02-18 04:30:00 | AAPL | Stock | 78.245 | 78.25 | 78.125 | 78.2025 | 19888.0 |
| 2020-02-18 04:35:00 | AAPL | Stock | 78.2125 | 78.275 | 78.2125 | 78.275 | 5136.0 |
| 2020-02-18 04:40:00 | AAPL | Stock | 78.2725 | 78.4225 | 78.245 | 78.4225 | 11480.0 |
| 2020-02-18 04:45:00 | AAPL | Stock | 78.4725 | 78.4725 | 78.3125 | 78.3625 | 18472.0 |
| 2020-02-18 04:50:00 | AAPL | Stock | 78.325 | 78.375 | 78.1275 | 78.3125 | 32488.0 |
| 2020-02-18 04:55:00 | AAPL | Stock | 78.3625 | 78.3625 | 78.25 | 78.25 | 9968.0 |
| 2020-02-18 05:00:00 | AAPL | Stock | 78.25 | 78.2775 | 78.18 | 78.2775 | 11200.0 |
| 2020-02-18 05:05:00 | AAPL | Stock | 78.3 | 78.3125 | 78.3 | 78.3125 | 22952.0 |
| 2020-02-18 05:10:00 | AAPL | Stock | 78.385 | 78.575 | 78.385 | 78.505 | 28836.0 |
| 2020-02-18 05:15:00 | AAPL | Stock | 78.505 | 78.625 | 78.375 | 78.5775 | 46484.0 |
| 2020-02-18 05:20:00 | AAPL | Stock | 78.5075 | 78.5075 | 78.4375 | 78.4375 | 9200.0 |
| 2020-02-18 05:25:00 | AAPL | Stock | 78.4475 | 78.5 | 78.4475 | 78.475 | 30868.0 |
| 2020-02-18 05:30:00 | AAPL | Stock | 78.4775 | 78.5 | 78.475 | 78.5 | 15044.0 |
| 2020-02-18 05:35:00 | AAPL | Stock | 78.595 | 78.595 | 78.4975 | 78.5 | 6036.0 |
| 2020-02-18 05:40:00 | AAPL | Stock | 78.5625 | 78.57 | 78.5625 | 78.57 | 2700.0 |
| 2020-02-18 05:45:00 | AAPL | Stock | 78.6125 | 78.625 | 78.4975 | 78.4975 | 21248.0 |
| 2020-02-18 05:50:00 | AAPL | Stock | 78.5 | 78.625 | 78.5 | 78.625 | 24428.0 |
| 2020-02-18 05:55:00 | AAPL | Stock | 78.6225 | 78.625 | 78.6225 | 78.625 | 5120.0 |
| 2020-02-18 06:00:00 | AAPL | Stock | 78.5875 | 78.6225 | 78.5 | 78.6225 | 15756.0 |
| 2020-02-18 06:05:00 | AAPL | Stock | 78.5975 | 78.625 | 78.515 | 78.6225 | 6520.0 |
| 2020-02-18 06:10:00 | AAPL | Stock | 78.595 | 78.595 | 78.575 | 78.575 | 1588.0 |
| 2020-02-18 06:15:00 | AAPL | Stock | 78.5475 | 78.5575 | 78.5125 | 78.5575 | 8460.0 |
| 2020-02-18 06:20:00 | AAPL | Stock | 78.5175 | 78.5625 | 78.515 | 78.5425 | 15360.0 |
| 2020-02-18 06:25:00 | AAPL | Stock | 78.5225 | 78.5475 | 78.425 | 78.5475 | 26272.0 |
| 2020-02-18 06:30:00 | AAPL | Stock | 78.545 | 78.58 | 78.545 | 78.58 | 5316.0 |
| 2020-02-18 06:35:00 | AAPL | Stock | 78.57 | 78.575 | 78.5275 | 78.5275 | 5904.0 |
| 2020-02-18 06:40:00 | AAPL | Stock | 78.5 | 78.5 | 78.415 | 78.43 | 28432.0 |
| 2020-02-18 06:45:00 | AAPL | Stock | 78.43 | 78.4825 | 78.36 | 78.38 | 37596.0 |
| 2020-02-18 06:50:00 | AAPL | Stock | 78.355 | 78.3725 | 78.355 | 78.3725 | 800.0 |
| 2020-02-18 06:55:00 | AAPL | Stock | 78.3625 | 78.3975 | 78.3525 | 78.3975 | 6592.0 |
| 2020-02-18 07:00:00 | AAPL | Stock | 78.375 | 78.625 | 78.375 | 78.5625 | 292512.0 |
| 2020-02-18 07:05:00 | AAPL | Stock | 78.62 | 78.625 | 78.4075 | 78.4375 | 56332.0 |
| 2020-02-18 07:10:00 | AAPL | Stock | 78.4625 | 78.6 | 78.4525 | 78.6 | 35616.0 |
| 2020-02-18 07:15:00 | AAPL | Stock | 78.5875 | 78.625 | 78.5675 | 78.62 | 154164.0 |
| 2020-02-18 07:20:00 | AAPL | Stock | 78.6225 | 78.625 | 78.55 | 78.625 | 69404.0 |
| 2020-02-18 07:25:00 | AAPL | Stock | 78.625 | 78.8325 | 78.625 | 78.7375 | 137784.0 |
| 2020-02-18 07:30:00 | AAPL | Stock | 78.7 | 78.825 | 78.7 | 78.82 | 79756.0 |
| 2020-02-18 07:35:00 | AAPL | Stock | 78.82 | 78.9375 | 78.7925 | 78.8775 | 80196.0 |
| 2020-02-18 07:40:00 | AAPL | Stock | 78.9075 | 78.91 | 78.725 | 78.725 | 50500.0 |
| 2020-02-18 07:45:00 | AAPL | Stock | 78.6875 | 78.75 | 78.6275 | 78.7 | 106828.0 |
| 2020-02-18 07:50:00 | AAPL | Stock | 78.7 | 78.7825 | 78.675 | 78.75 | 69840.0 |
| 2020-02-18 07:55:00 | AAPL | Stock | 78.75 | 79.05 | 78.75 | 79.025 | 71064.0 |
| 2020-02-18 08:00:00 | AAPL | Stock | 78.6 | 79.3425 | 78.4075 | 79.2 | 660260.0 |
| 2020-02-18 08:05:00 | AAPL | Stock | 79.2375 | 79.2975 | 79.1125 | 79.13 | 145420.0 |
> showing 50 of 368,160 rows — these rows as CSV