PREVIEW / stock_5min / 2021-06-17
file: by_date/stock_5min/2021/2021-06-17.parquet size: 7.6 MB rows: 470,475 symbols: 2,953
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-17 04:00:00 | AAPL | Stock | 129.1 | 129.25 | 129.0 | 129.18 | 7337.0 |
| 2021-06-17 04:05:00 | AAPL | Stock | 129.2 | 129.2 | 129.0 | 129.0 | 4603.0 |
| 2021-06-17 04:10:00 | AAPL | Stock | 129.0 | 129.01 | 128.98 | 129.0 | 3800.0 |
| 2021-06-17 04:15:00 | AAPL | Stock | 129.0 | 129.25 | 129.0 | 129.21 | 8250.0 |
| 2021-06-17 04:20:00 | AAPL | Stock | 129.21 | 129.21 | 129.01 | 129.01 | 2008.0 |
| 2021-06-17 04:25:00 | AAPL | Stock | 129.04 | 129.04 | 129.04 | 129.04 | 104.0 |
| 2021-06-17 04:30:00 | AAPL | Stock | 129.11 | 129.12 | 129.1 | 129.12 | 700.0 |
| 2021-06-17 04:35:00 | AAPL | Stock | 129.12 | 129.12 | 129.07 | 129.07 | 1451.0 |
| 2021-06-17 04:40:00 | AAPL | Stock | 129.0 | 129.0 | 128.91 | 128.92 | 2065.0 |
| 2021-06-17 04:45:00 | AAPL | Stock | 128.94 | 128.99 | 128.9 | 128.98 | 1291.0 |
| 2021-06-17 04:50:00 | AAPL | Stock | 128.96 | 128.96 | 128.96 | 128.96 | 200.0 |
| 2021-06-17 04:55:00 | AAPL | Stock | 128.96 | 128.96 | 128.96 | 128.96 | 906.0 |
| 2021-06-17 05:00:00 | AAPL | Stock | 128.92 | 128.92 | 128.92 | 128.92 | 200.0 |
| 2021-06-17 05:05:00 | AAPL | Stock | 129.03 | 129.18 | 129.03 | 129.18 | 1841.0 |
| 2021-06-17 05:15:00 | AAPL | Stock | 129.15 | 129.15 | 129.15 | 129.15 | 114.0 |
| 2021-06-17 05:20:00 | AAPL | Stock | 129.22 | 129.22 | 129.15 | 129.15 | 579.0 |
| 2021-06-17 05:25:00 | AAPL | Stock | 129.24 | 129.24 | 129.24 | 129.24 | 900.0 |
| 2021-06-17 05:30:00 | AAPL | Stock | 129.35 | 129.37 | 129.35 | 129.35 | 991.0 |
| 2021-06-17 05:35:00 | AAPL | Stock | 129.27 | 129.35 | 129.26 | 129.31 | 1478.0 |
| 2021-06-17 05:40:00 | AAPL | Stock | 129.31 | 129.31 | 129.31 | 129.31 | 153.0 |
| 2021-06-17 05:45:00 | AAPL | Stock | 129.28 | 129.28 | 129.27 | 129.28 | 835.0 |
| 2021-06-17 05:50:00 | AAPL | Stock | 129.28 | 129.3 | 129.28 | 129.3 | 1088.0 |
| 2021-06-17 05:55:00 | AAPL | Stock | 129.35 | 129.4 | 129.34 | 129.34 | 1929.0 |
| 2021-06-17 06:00:00 | AAPL | Stock | 129.37 | 129.4 | 129.33 | 129.4 | 1781.0 |
| 2021-06-17 06:05:00 | AAPL | Stock | 129.37 | 129.39 | 129.36 | 129.36 | 460.0 |
| 2021-06-17 06:10:00 | AAPL | Stock | 129.5 | 129.5 | 129.37 | 129.37 | 1355.0 |
| 2021-06-17 06:15:00 | AAPL | Stock | 129.4 | 129.46 | 129.4 | 129.46 | 323.0 |
| 2021-06-17 06:20:00 | AAPL | Stock | 129.44 | 129.48 | 129.44 | 129.48 | 330.0 |
| 2021-06-17 06:25:00 | AAPL | Stock | 129.4 | 129.4 | 129.34 | 129.34 | 695.0 |
| 2021-06-17 06:30:00 | AAPL | Stock | 129.3 | 129.3 | 129.3 | 129.3 | 2390.0 |
| 2021-06-17 06:35:00 | AAPL | Stock | 129.22 | 129.22 | 129.22 | 129.22 | 100.0 |
| 2021-06-17 06:40:00 | AAPL | Stock | 129.21 | 129.21 | 129.2 | 129.2 | 1370.0 |
| 2021-06-17 06:45:00 | AAPL | Stock | 129.15 | 129.15 | 129.15 | 129.15 | 284.0 |
| 2021-06-17 06:50:00 | AAPL | Stock | 129.29 | 129.29 | 129.29 | 129.29 | 130.0 |
| 2021-06-17 07:00:00 | AAPL | Stock | 129.26 | 129.45 | 129.1 | 129.43 | 31896.0 |
| 2021-06-17 07:05:00 | AAPL | Stock | 129.43 | 129.7 | 129.4 | 129.66 | 38043.0 |
| 2021-06-17 07:10:00 | AAPL | Stock | 129.65 | 129.75 | 129.58 | 129.68 | 20811.0 |
| 2021-06-17 07:15:00 | AAPL | Stock | 129.59 | 129.65 | 129.52 | 129.64 | 4468.0 |
| 2021-06-17 07:20:00 | AAPL | Stock | 129.65 | 129.66 | 129.59 | 129.65 | 7079.0 |
| 2021-06-17 07:25:00 | AAPL | Stock | 129.63 | 129.68 | 129.55 | 129.6 | 6513.0 |
| 2021-06-17 07:30:00 | AAPL | Stock | 129.6 | 129.64 | 129.53 | 129.62 | 6678.0 |
| 2021-06-17 07:35:00 | AAPL | Stock | 129.62 | 129.69 | 129.6 | 129.6 | 6481.0 |
| 2021-06-17 07:40:00 | AAPL | Stock | 129.6 | 129.7 | 129.6 | 129.61 | 14205.0 |
| 2021-06-17 07:45:00 | AAPL | Stock | 129.62 | 129.62 | 129.52 | 129.57 | 17082.0 |
| 2021-06-17 07:50:00 | AAPL | Stock | 129.57 | 129.58 | 129.5 | 129.55 | 7920.0 |
| 2021-06-17 07:55:00 | AAPL | Stock | 129.55 | 129.55 | 129.33 | 129.37 | 15209.0 |
| 2021-06-17 08:00:00 | AAPL | Stock | 129.3701 | 129.74 | 129.35 | 129.5 | 99198.0 |
| 2021-06-17 08:05:00 | AAPL | Stock | 129.5 | 129.6 | 129.47 | 129.52 | 12428.0 |
| 2021-06-17 08:10:00 | AAPL | Stock | 129.54 | 129.54 | 129.4 | 129.48 | 14042.0 |
| 2021-06-17 08:15:00 | AAPL | Stock | 129.47 | 129.47 | 129.38 | 129.4 | 12283.0 |
> showing 50 of 470,475 rows — these rows as CSV