PREVIEW / stock_5min / 2023-01-20
file: by_date/stock_5min/2023/2023-01-20.parquet size: 6.8 MB rows: 417,633 symbols: 1,936
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-20 04:00:00 | AAPL | Stock | 135.6 | 135.6 | 135.38 | 135.53 | 2001.0 |
| 2023-01-20 04:05:00 | AAPL | Stock | 135.4 | 135.48 | 135.25 | 135.26 | 5880.0 |
| 2023-01-20 04:10:00 | AAPL | Stock | 135.29 | 135.3 | 135.25 | 135.25 | 3195.0 |
| 2023-01-20 04:15:00 | AAPL | Stock | 135.51 | 135.51 | 135.51 | 135.51 | 275.0 |
| 2023-01-20 04:20:00 | AAPL | Stock | 135.63 | 135.63 | 135.49 | 135.6 | 7641.0 |
| 2023-01-20 04:25:00 | AAPL | Stock | 135.59 | 135.59 | 135.58 | 135.59 | 1328.0 |
| 2023-01-20 04:30:00 | AAPL | Stock | 135.42 | 135.42 | 135.35 | 135.4 | 6897.0 |
| 2023-01-20 04:35:00 | AAPL | Stock | 135.42 | 135.42 | 135.42 | 135.42 | 700.0 |
| 2023-01-20 04:40:00 | AAPL | Stock | 135.43 | 135.43 | 135.43 | 135.43 | 320.0 |
| 2023-01-20 04:45:00 | AAPL | Stock | 135.36 | 135.37 | 135.33 | 135.37 | 1984.0 |
| 2023-01-20 04:50:00 | AAPL | Stock | 135.37 | 135.37 | 135.36 | 135.36 | 276.0 |
| 2023-01-20 04:55:00 | AAPL | Stock | 135.31 | 135.31 | 135.24 | 135.24 | 800.0 |
| 2023-01-20 05:00:00 | AAPL | Stock | 135.25 | 135.27 | 135.2 | 135.2 | 1975.0 |
| 2023-01-20 05:05:00 | AAPL | Stock | 135.24 | 135.24 | 135.18 | 135.18 | 500.0 |
| 2023-01-20 05:15:00 | AAPL | Stock | 135.27 | 135.33 | 135.25 | 135.3 | 4316.0 |
| 2023-01-20 05:20:00 | AAPL | Stock | 135.29 | 135.29 | 135.26 | 135.26 | 696.0 |
| 2023-01-20 05:30:00 | AAPL | Stock | 135.33 | 135.35 | 135.33 | 135.35 | 250.0 |
| 2023-01-20 05:45:00 | AAPL | Stock | 135.28 | 135.37 | 135.28 | 135.37 | 672.0 |
| 2023-01-20 05:55:00 | AAPL | Stock | 135.38 | 135.4 | 135.38 | 135.4 | 1151.0 |
| 2023-01-20 06:00:00 | AAPL | Stock | 135.44 | 135.44 | 135.29 | 135.29 | 1020.0 |
| 2023-01-20 06:05:00 | AAPL | Stock | 135.4 | 135.54 | 135.4 | 135.54 | 1552.0 |
| 2023-01-20 06:10:00 | AAPL | Stock | 135.54 | 135.55 | 135.51 | 135.51 | 701.0 |
| 2023-01-20 06:15:00 | AAPL | Stock | 135.56 | 135.56 | 135.56 | 135.56 | 101.0 |
| 2023-01-20 06:20:00 | AAPL | Stock | 135.42 | 135.42 | 135.3 | 135.3 | 1781.0 |
| 2023-01-20 06:25:00 | AAPL | Stock | 135.29 | 135.35 | 135.13 | 135.35 | 989.0 |
| 2023-01-20 06:30:00 | AAPL | Stock | 135.3 | 135.3 | 135.3 | 135.3 | 320.0 |
| 2023-01-20 06:35:00 | AAPL | Stock | 135.33 | 135.33 | 135.29 | 135.3 | 1239.0 |
| 2023-01-20 06:40:00 | AAPL | Stock | 135.31 | 135.38 | 135.21 | 135.38 | 1401.0 |
| 2023-01-20 06:45:00 | AAPL | Stock | 135.36 | 135.4 | 135.36 | 135.4 | 1353.0 |
| 2023-01-20 06:50:00 | AAPL | Stock | 135.31 | 135.33 | 135.26 | 135.27 | 1705.0 |
| 2023-01-20 06:55:00 | AAPL | Stock | 135.27 | 135.27 | 135.27 | 135.27 | 1159.0 |
| 2023-01-20 07:00:00 | AAPL | Stock | 135.36 | 135.49 | 135.36 | 135.48 | 4334.0 |
| 2023-01-20 07:05:00 | AAPL | Stock | 135.47 | 135.68 | 135.46 | 135.68 | 8686.0 |
| 2023-01-20 07:10:00 | AAPL | Stock | 135.68 | 135.86 | 135.68 | 135.86 | 6958.0 |
| 2023-01-20 07:15:00 | AAPL | Stock | 135.88 | 135.88 | 135.8 | 135.85 | 2756.0 |
| 2023-01-20 07:20:00 | AAPL | Stock | 135.81 | 135.81 | 135.71 | 135.73 | 10778.0 |
| 2023-01-20 07:25:00 | AAPL | Stock | 135.75 | 135.83 | 135.75 | 135.83 | 648.0 |
| 2023-01-20 07:30:00 | AAPL | Stock | 135.83 | 135.98 | 135.83 | 135.92 | 2379.0 |
| 2023-01-20 07:35:00 | AAPL | Stock | 135.92 | 136.09 | 135.92 | 136.09 | 7455.0 |
| 2023-01-20 07:40:00 | AAPL | Stock | 136.14 | 136.17 | 136.06 | 136.07 | 9850.0 |
| 2023-01-20 07:45:00 | AAPL | Stock | 136.09 | 136.22 | 136.09 | 136.22 | 6851.0 |
| 2023-01-20 07:50:00 | AAPL | Stock | 136.25 | 136.26 | 136.21 | 136.22 | 11488.0 |
| 2023-01-20 07:55:00 | AAPL | Stock | 136.24 | 136.29 | 136.17 | 136.17 | 5139.0 |
| 2023-01-20 08:00:00 | AAPL | Stock | 135.85 | 136.29 | 134.932 | 136.14 | 101474.0 |
| 2023-01-20 08:05:00 | AAPL | Stock | 136.14 | 136.16 | 136.03 | 136.04 | 19693.0 |
| 2023-01-20 08:10:00 | AAPL | Stock | 136.05 | 136.07 | 135.9715 | 136.05 | 8550.0 |
| 2023-01-20 08:15:00 | AAPL | Stock | 136.05 | 136.08 | 136.0051 | 136.05 | 6200.0 |
| 2023-01-20 08:20:00 | AAPL | Stock | 136.1 | 136.1 | 135.95 | 135.96 | 11710.0 |
| 2023-01-20 08:25:00 | AAPL | Stock | 135.95 | 135.95 | 135.82 | 135.84 | 15245.0 |
| 2023-01-20 08:30:00 | AAPL | Stock | 135.81 | 135.81 | 135.6 | 135.71 | 30306.0 |
> showing 50 of 417,633 rows — these rows as CSV