PREVIEW / stock_5min / 2021-04-28
file: by_date/stock_5min/2021/2021-04-28.parquet size: 7.4 MB rows: 457,179 symbols: 2,972
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-04-28 04:00:00 | AAPL | Stock | 134.31 | 134.7 | 134.31 | 134.6 | 2313.0 |
| 2021-04-28 04:05:00 | AAPL | Stock | 134.53 | 134.53 | 134.39 | 134.48 | 1020.0 |
| 2021-04-28 04:10:00 | AAPL | Stock | 134.37 | 134.37 | 134.18 | 134.2 | 2000.0 |
| 2021-04-28 04:15:00 | AAPL | Stock | 134.17 | 134.17 | 134.0 | 134.07 | 2422.0 |
| 2021-04-28 04:20:00 | AAPL | Stock | 134.05 | 134.05 | 134.01 | 134.02 | 811.0 |
| 2021-04-28 04:25:00 | AAPL | Stock | 134.03 | 134.19 | 134.03 | 134.19 | 854.0 |
| 2021-04-28 04:30:00 | AAPL | Stock | 134.11 | 134.22 | 134.11 | 134.21 | 534.0 |
| 2021-04-28 04:35:00 | AAPL | Stock | 134.25 | 134.27 | 134.25 | 134.27 | 339.0 |
| 2021-04-28 04:40:00 | AAPL | Stock | 134.2 | 134.24 | 134.18 | 134.24 | 400.0 |
| 2021-04-28 04:45:00 | AAPL | Stock | 134.3 | 134.35 | 134.3 | 134.3 | 1099.0 |
| 2021-04-28 04:50:00 | AAPL | Stock | 134.3 | 134.3 | 134.3 | 134.3 | 237.0 |
| 2021-04-28 04:55:00 | AAPL | Stock | 134.35 | 134.35 | 134.32 | 134.32 | 1248.0 |
| 2021-04-28 05:00:00 | AAPL | Stock | 134.28 | 134.28 | 134.2 | 134.2 | 2803.0 |
| 2021-04-28 05:05:00 | AAPL | Stock | 134.18 | 134.18 | 134.0 | 134.0 | 5286.0 |
| 2021-04-28 05:10:00 | AAPL | Stock | 134.05 | 134.05 | 134.02 | 134.02 | 1663.0 |
| 2021-04-28 05:15:00 | AAPL | Stock | 134.03 | 134.03 | 134.03 | 134.03 | 320.0 |
| 2021-04-28 05:20:00 | AAPL | Stock | 134.05 | 134.13 | 134.0 | 134.02 | 1719.0 |
| 2021-04-28 05:25:00 | AAPL | Stock | 134.05 | 134.05 | 134.0 | 134.0 | 524.0 |
| 2021-04-28 05:30:00 | AAPL | Stock | 134.0 | 134.01 | 133.95 | 134.01 | 1528.0 |
| 2021-04-28 05:35:00 | AAPL | Stock | 133.92 | 133.92 | 133.92 | 133.92 | 1860.0 |
| 2021-04-28 05:40:00 | AAPL | Stock | 134.03 | 134.05 | 134.0 | 134.05 | 2286.0 |
| 2021-04-28 05:45:00 | AAPL | Stock | 134.06 | 134.06 | 134.01 | 134.01 | 918.0 |
| 2021-04-28 05:50:00 | AAPL | Stock | 134.01 | 134.01 | 134.01 | 134.01 | 740.0 |
| 2021-04-28 05:55:00 | AAPL | Stock | 134.11 | 134.11 | 134.11 | 134.11 | 300.0 |
| 2021-04-28 06:00:00 | AAPL | Stock | 134.14 | 134.14 | 134.06 | 134.06 | 1576.0 |
| 2021-04-28 06:05:00 | AAPL | Stock | 134.16 | 134.17 | 134.16 | 134.17 | 7072.0 |
| 2021-04-28 06:10:00 | AAPL | Stock | 134.16 | 134.16 | 134.08 | 134.08 | 450.0 |
| 2021-04-28 06:15:00 | AAPL | Stock | 134.06 | 134.16 | 134.06 | 134.16 | 3316.0 |
| 2021-04-28 06:20:00 | AAPL | Stock | 134.16 | 134.17 | 134.07 | 134.11 | 560.0 |
| 2021-04-28 06:25:00 | AAPL | Stock | 134.14 | 134.22 | 134.14 | 134.22 | 2504.0 |
| 2021-04-28 06:30:00 | AAPL | Stock | 134.2 | 134.2 | 134.09 | 134.09 | 1088.0 |
| 2021-04-28 06:35:00 | AAPL | Stock | 134.11 | 134.11 | 134.11 | 134.11 | 439.0 |
| 2021-04-28 06:40:00 | AAPL | Stock | 134.13 | 134.24 | 134.13 | 134.24 | 871.0 |
| 2021-04-28 06:45:00 | AAPL | Stock | 134.26 | 134.27 | 134.26 | 134.27 | 424.0 |
| 2021-04-28 06:50:00 | AAPL | Stock | 134.21 | 134.21 | 134.13 | 134.13 | 1927.0 |
| 2021-04-28 06:55:00 | AAPL | Stock | 134.16 | 134.17 | 134.16 | 134.17 | 1613.0 |
| 2021-04-28 07:00:00 | AAPL | Stock | 134.17 | 134.65 | 134.14 | 134.59 | 45265.0 |
| 2021-04-28 07:05:00 | AAPL | Stock | 134.59 | 134.7 | 134.5 | 134.63 | 34332.0 |
| 2021-04-28 07:10:00 | AAPL | Stock | 134.65 | 134.68 | 134.53 | 134.53 | 10492.0 |
| 2021-04-28 07:15:00 | AAPL | Stock | 134.52 | 134.6 | 134.43 | 134.59 | 18363.0 |
| 2021-04-28 07:20:00 | AAPL | Stock | 134.6 | 134.65 | 134.56 | 134.56 | 12171.0 |
| 2021-04-28 07:25:00 | AAPL | Stock | 134.6 | 134.6 | 134.51 | 134.53 | 14451.0 |
| 2021-04-28 07:30:00 | AAPL | Stock | 134.53 | 134.53 | 134.35 | 134.36 | 61838.0 |
| 2021-04-28 07:35:00 | AAPL | Stock | 134.37 | 134.43 | 134.3 | 134.36 | 26018.0 |
| 2021-04-28 07:40:00 | AAPL | Stock | 134.39 | 134.42 | 134.3 | 134.32 | 14253.0 |
| 2021-04-28 07:45:00 | AAPL | Stock | 134.31 | 134.35 | 134.22 | 134.27 | 28184.0 |
| 2021-04-28 07:50:00 | AAPL | Stock | 134.28 | 134.37 | 134.28 | 134.34 | 17424.0 |
| 2021-04-28 07:55:00 | AAPL | Stock | 134.33 | 134.4 | 134.27 | 134.4 | 8708.0 |
| 2021-04-28 08:00:00 | AAPL | Stock | 134.5199 | 134.7 | 134.21 | 134.37 | 127355.0 |
| 2021-04-28 08:05:00 | AAPL | Stock | 134.37 | 134.55 | 134.37 | 134.54 | 26472.0 |
> showing 50 of 457,179 rows — these rows as CSV