PREVIEW / stock_5min / 2020-08-07
file: by_date/stock_5min/2020/2020-08-07.parquet size: 6.6 MB rows: 414,788 symbols: 2,442
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-08-07 04:00:00 | AAPL | Stock | 113.5 | 113.5 | 112.5125 | 113.375 | 13484.0 |
| 2020-08-07 04:05:00 | AAPL | Stock | 113.245 | 113.2625 | 113.1625 | 113.2375 | 4848.0 |
| 2020-08-07 04:10:00 | AAPL | Stock | 113.175 | 113.25 | 113.125 | 113.125 | 16920.0 |
| 2020-08-07 04:15:00 | AAPL | Stock | 113.205 | 113.205 | 113.2 | 113.2 | 988.0 |
| 2020-08-07 04:20:00 | AAPL | Stock | 113.1875 | 113.1875 | 113.1875 | 113.1875 | 1964.0 |
| 2020-08-07 04:35:00 | AAPL | Stock | 113.025 | 113.025 | 112.95 | 112.95 | 3600.0 |
| 2020-08-07 04:40:00 | AAPL | Stock | 112.95 | 112.9725 | 112.95 | 112.9725 | 1600.0 |
| 2020-08-07 04:45:00 | AAPL | Stock | 112.9925 | 113.05 | 112.9925 | 113.05 | 1200.0 |
| 2020-08-07 04:50:00 | AAPL | Stock | 113.05 | 113.05 | 112.95 | 112.95 | 2680.0 |
| 2020-08-07 04:55:00 | AAPL | Stock | 113.075 | 113.075 | 113.0125 | 113.0125 | 1200.0 |
| 2020-08-07 05:00:00 | AAPL | Stock | 113.0425 | 113.0425 | 113.03 | 113.03 | 1600.0 |
| 2020-08-07 05:05:00 | AAPL | Stock | 112.95 | 112.96 | 112.95 | 112.96 | 2832.0 |
| 2020-08-07 05:10:00 | AAPL | Stock | 112.96 | 112.96 | 112.875 | 112.875 | 2844.0 |
| 2020-08-07 05:15:00 | AAPL | Stock | 112.875 | 112.875 | 112.875 | 112.875 | 400.0 |
| 2020-08-07 05:20:00 | AAPL | Stock | 113.03 | 113.1975 | 113.03 | 113.1975 | 3352.0 |
| 2020-08-07 05:35:00 | AAPL | Stock | 113.1975 | 113.25 | 113.1975 | 113.1975 | 1828.0 |
| 2020-08-07 05:40:00 | AAPL | Stock | 113.12 | 113.12 | 113.12 | 113.12 | 400.0 |
| 2020-08-07 05:45:00 | AAPL | Stock | 113.14 | 113.14 | 113.14 | 113.14 | 400.0 |
| 2020-08-07 05:50:00 | AAPL | Stock | 113.125 | 113.125 | 113.125 | 113.125 | 640.0 |
| 2020-08-07 05:55:00 | AAPL | Stock | 113.175 | 113.175 | 113.175 | 113.175 | 400.0 |
| 2020-08-07 06:00:00 | AAPL | Stock | 113.2425 | 113.2425 | 113.2 | 113.2 | 2388.0 |
| 2020-08-07 06:05:00 | AAPL | Stock | 113.25 | 113.2575 | 113.2025 | 113.2025 | 3208.0 |
| 2020-08-07 06:10:00 | AAPL | Stock | 113.2025 | 113.2025 | 113.2 | 113.2 | 1784.0 |
| 2020-08-07 06:35:00 | AAPL | Stock | 113.215 | 113.215 | 113.215 | 113.215 | 540.0 |
| 2020-08-07 06:40:00 | AAPL | Stock | 113.23 | 113.25 | 113.23 | 113.25 | 2200.0 |
| 2020-08-07 06:45:00 | AAPL | Stock | 113.24 | 113.24 | 113.16 | 113.165 | 28380.0 |
| 2020-08-07 06:50:00 | AAPL | Stock | 113.165 | 113.2625 | 113.165 | 113.175 | 37824.0 |
| 2020-08-07 06:55:00 | AAPL | Stock | 113.235 | 113.325 | 113.2225 | 113.25 | 6992.0 |
| 2020-08-07 07:00:00 | AAPL | Stock | 113.25 | 113.4775 | 113.225 | 113.2775 | 102048.0 |
| 2020-08-07 07:05:00 | AAPL | Stock | 113.3025 | 113.3375 | 113.2625 | 113.275 | 9324.0 |
| 2020-08-07 07:10:00 | AAPL | Stock | 113.2975 | 113.375 | 113.25 | 113.375 | 38092.0 |
| 2020-08-07 07:15:00 | AAPL | Stock | 113.38 | 113.49 | 113.375 | 113.45 | 14260.0 |
| 2020-08-07 07:20:00 | AAPL | Stock | 113.4575 | 113.6125 | 113.4575 | 113.585 | 26416.0 |
| 2020-08-07 07:25:00 | AAPL | Stock | 113.655 | 113.6775 | 113.6275 | 113.6625 | 25872.0 |
| 2020-08-07 07:30:00 | AAPL | Stock | 113.6625 | 113.6625 | 113.575 | 113.575 | 24576.0 |
| 2020-08-07 07:35:00 | AAPL | Stock | 113.585 | 113.62 | 113.5 | 113.5 | 40588.0 |
| 2020-08-07 07:40:00 | AAPL | Stock | 113.55 | 113.55 | 113.34 | 113.3775 | 62076.0 |
| 2020-08-07 07:45:00 | AAPL | Stock | 113.38 | 113.3875 | 113.155 | 113.25 | 104132.0 |
| 2020-08-07 07:50:00 | AAPL | Stock | 113.3175 | 113.3175 | 113.1875 | 113.22 | 40668.0 |
| 2020-08-07 07:55:00 | AAPL | Stock | 113.22 | 113.3025 | 113.22 | 113.25 | 106336.0 |
| 2020-08-07 08:00:00 | AAPL | Stock | 113.7125 | 113.725 | 113.175 | 113.2325 | 272372.0 |
| 2020-08-07 08:05:00 | AAPL | Stock | 113.208 | 113.2475 | 113.2 | 113.205 | 22892.0 |
| 2020-08-07 08:10:00 | AAPL | Stock | 113.1875 | 113.2105 | 113.135 | 113.21 | 94260.0 |
| 2020-08-07 08:15:00 | AAPL | Stock | 113.21 | 113.35 | 113.174 | 113.25 | 123440.0 |
| 2020-08-07 08:20:00 | AAPL | Stock | 113.285 | 113.3125 | 113.225 | 113.3125 | 75612.0 |
| 2020-08-07 08:25:00 | AAPL | Stock | 113.3125 | 113.3125 | 113.25 | 113.29 | 51184.0 |
| 2020-08-07 08:30:00 | AAPL | Stock | 113.2875 | 113.7775 | 113.2875 | 113.6875 | 531668.0 |
| 2020-08-07 08:35:00 | AAPL | Stock | 113.7125 | 113.7125 | 113.5 | 113.5575 | 237264.0 |
| 2020-08-07 08:40:00 | AAPL | Stock | 113.5575 | 113.6075 | 113.15 | 113.1875 | 270280.0 |
| 2020-08-07 08:45:00 | AAPL | Stock | 113.15 | 113.3975 | 113.125 | 113.3125 | 211500.0 |
> showing 50 of 414,788 rows — these rows as CSV