PREVIEW / stock_5min / 2023-04-19
file: by_date/stock_5min/2023/2023-04-19.parquet size: 6.7 MB rows: 409,396 symbols: 1,706
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-04-19 04:00:00 | AAPL | Stock | 165.98 | 165.98 | 165.09 | 165.32 | 6872.0 |
| 2023-04-19 04:05:00 | AAPL | Stock | 165.5 | 165.77 | 165.5 | 165.53 | 8958.0 |
| 2023-04-19 04:10:00 | AAPL | Stock | 165.55 | 165.56 | 165.23 | 165.3 | 8302.0 |
| 2023-04-19 04:15:00 | AAPL | Stock | 165.34 | 165.37 | 165.34 | 165.37 | 2429.0 |
| 2023-04-19 04:20:00 | AAPL | Stock | 165.41 | 165.41 | 165.41 | 165.41 | 600.0 |
| 2023-04-19 04:25:00 | AAPL | Stock | 165.42 | 165.52 | 165.42 | 165.51 | 1285.0 |
| 2023-04-19 04:30:00 | AAPL | Stock | 165.53 | 165.55 | 165.53 | 165.54 | 2051.0 |
| 2023-04-19 04:35:00 | AAPL | Stock | 165.48 | 165.49 | 165.4 | 165.4 | 820.0 |
| 2023-04-19 04:40:00 | AAPL | Stock | 165.42 | 165.5 | 165.42 | 165.43 | 1361.0 |
| 2023-04-19 04:45:00 | AAPL | Stock | 165.45 | 165.46 | 165.42 | 165.46 | 1579.0 |
| 2023-04-19 04:55:00 | AAPL | Stock | 165.45 | 165.45 | 165.38 | 165.38 | 2206.0 |
| 2023-04-19 05:00:00 | AAPL | Stock | 165.4 | 165.46 | 165.4 | 165.46 | 1202.0 |
| 2023-04-19 05:05:00 | AAPL | Stock | 165.4 | 165.4 | 165.01 | 165.35 | 8099.0 |
| 2023-04-19 05:10:00 | AAPL | Stock | 165.35 | 165.49 | 165.35 | 165.37 | 3851.0 |
| 2023-04-19 05:15:00 | AAPL | Stock | 165.44 | 165.46 | 165.44 | 165.46 | 695.0 |
| 2023-04-19 05:30:00 | AAPL | Stock | 165.39 | 165.44 | 165.39 | 165.44 | 818.0 |
| 2023-04-19 05:35:00 | AAPL | Stock | 165.4 | 165.4 | 165.4 | 165.4 | 191.0 |
| 2023-04-19 05:40:00 | AAPL | Stock | 165.39 | 165.39 | 165.37 | 165.37 | 1100.0 |
| 2023-04-19 05:45:00 | AAPL | Stock | 165.33 | 165.33 | 165.33 | 165.33 | 100.0 |
| 2023-04-19 05:50:00 | AAPL | Stock | 165.27 | 165.27 | 165.2 | 165.2 | 655.0 |
| 2023-04-19 05:55:00 | AAPL | Stock | 165.12 | 165.17 | 165.12 | 165.17 | 3831.0 |
| 2023-04-19 06:00:00 | AAPL | Stock | 165.24 | 165.25 | 165.24 | 165.25 | 650.0 |
| 2023-04-19 06:05:00 | AAPL | Stock | 165.3 | 165.31 | 165.3 | 165.31 | 551.0 |
| 2023-04-19 06:10:00 | AAPL | Stock | 165.35 | 165.35 | 165.35 | 165.35 | 150.0 |
| 2023-04-19 06:15:00 | AAPL | Stock | 165.38 | 165.39 | 165.38 | 165.39 | 567.0 |
| 2023-04-19 06:20:00 | AAPL | Stock | 165.39 | 165.39 | 165.34 | 165.34 | 896.0 |
| 2023-04-19 06:25:00 | AAPL | Stock | 165.36 | 165.36 | 165.36 | 165.36 | 499.0 |
| 2023-04-19 06:30:00 | AAPL | Stock | 165.4 | 165.54 | 165.4 | 165.54 | 1297.0 |
| 2023-04-19 06:35:00 | AAPL | Stock | 165.51 | 165.64 | 165.5 | 165.55 | 1189.0 |
| 2023-04-19 06:40:00 | AAPL | Stock | 165.46 | 165.46 | 165.38 | 165.39 | 610.0 |
| 2023-04-19 06:45:00 | AAPL | Stock | 165.51 | 165.51 | 165.48 | 165.48 | 600.0 |
| 2023-04-19 06:50:00 | AAPL | Stock | 165.53 | 165.53 | 165.53 | 165.53 | 296.0 |
| 2023-04-19 06:55:00 | AAPL | Stock | 165.52 | 165.52 | 165.49 | 165.49 | 400.0 |
| 2023-04-19 07:00:00 | AAPL | Stock | 165.55 | 165.7 | 165.5 | 165.5 | 8625.0 |
| 2023-04-19 07:05:00 | AAPL | Stock | 165.51 | 165.64 | 165.5 | 165.55 | 3454.0 |
| 2023-04-19 07:10:00 | AAPL | Stock | 165.57 | 165.57 | 165.47 | 165.48 | 3544.0 |
| 2023-04-19 07:15:00 | AAPL | Stock | 165.56 | 165.59 | 165.56 | 165.59 | 500.0 |
| 2023-04-19 07:20:00 | AAPL | Stock | 165.59 | 165.59 | 165.48 | 165.5 | 2179.0 |
| 2023-04-19 07:25:00 | AAPL | Stock | 165.46 | 165.46 | 165.46 | 165.46 | 225.0 |
| 2023-04-19 07:30:00 | AAPL | Stock | 165.6 | 165.6 | 165.6 | 165.6 | 587.0 |
| 2023-04-19 07:40:00 | AAPL | Stock | 165.61 | 165.61 | 165.4 | 165.48 | 3711.0 |
| 2023-04-19 07:45:00 | AAPL | Stock | 165.5 | 165.51 | 165.4 | 165.4 | 3316.0 |
| 2023-04-19 07:50:00 | AAPL | Stock | 165.4 | 165.4 | 165.4 | 165.4 | 775.0 |
| 2023-04-19 07:55:00 | AAPL | Stock | 165.5 | 165.56 | 165.45 | 165.56 | 1361.0 |
| 2023-04-19 08:00:00 | AAPL | Stock | 165.5592 | 166.054 | 165.0 | 165.4 | 50295.0 |
| 2023-04-19 08:05:00 | AAPL | Stock | 165.5 | 165.59 | 165.5 | 165.51 | 5011.0 |
| 2023-04-19 08:10:00 | AAPL | Stock | 165.52 | 165.63 | 165.52 | 165.63 | 3709.0 |
| 2023-04-19 08:15:00 | AAPL | Stock | 165.58 | 165.58 | 165.423 | 165.44 | 5861.0 |
| 2023-04-19 08:20:00 | AAPL | Stock | 165.45 | 165.52 | 165.43 | 165.47 | 24148.0 |
| 2023-04-19 08:25:00 | AAPL | Stock | 165.5 | 165.53 | 165.38 | 165.52 | 8730.0 |
> showing 50 of 409,396 rows — these rows as CSV