PREVIEW / stock_5min / 2023-03-06
file: by_date/stock_5min/2023/2023-03-06.parquet size: 6.8 MB rows: 416,280 symbols: 1,802
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-03-06 04:00:00 | AAPL | Stock | 152.05 | 152.86 | 152.05 | 152.54 | 21612.0 |
| 2023-03-06 04:05:00 | AAPL | Stock | 152.46 | 152.54 | 152.38 | 152.38 | 6116.0 |
| 2023-03-06 04:10:00 | AAPL | Stock | 152.42 | 152.58 | 152.41 | 152.5 | 1484.0 |
| 2023-03-06 04:15:00 | AAPL | Stock | 152.5 | 152.51 | 152.27 | 152.49 | 3348.0 |
| 2023-03-06 04:20:00 | AAPL | Stock | 152.37 | 152.45 | 152.28 | 152.28 | 2279.0 |
| 2023-03-06 04:25:00 | AAPL | Stock | 152.28 | 152.28 | 152.28 | 152.28 | 100.0 |
| 2023-03-06 04:30:00 | AAPL | Stock | 152.27 | 152.27 | 152.22 | 152.25 | 6545.0 |
| 2023-03-06 04:35:00 | AAPL | Stock | 152.22 | 152.3 | 152.22 | 152.3 | 2791.0 |
| 2023-03-06 04:40:00 | AAPL | Stock | 152.32 | 152.36 | 152.26 | 152.35 | 3195.0 |
| 2023-03-06 04:45:00 | AAPL | Stock | 152.29 | 152.29 | 152.24 | 152.24 | 899.0 |
| 2023-03-06 04:50:00 | AAPL | Stock | 152.17 | 152.26 | 152.17 | 152.25 | 1567.0 |
| 2023-03-06 04:55:00 | AAPL | Stock | 152.21 | 152.3 | 152.21 | 152.27 | 800.0 |
| 2023-03-06 05:00:00 | AAPL | Stock | 152.32 | 152.4 | 152.31 | 152.38 | 1947.0 |
| 2023-03-06 05:05:00 | AAPL | Stock | 152.38 | 152.38 | 152.34 | 152.38 | 775.0 |
| 2023-03-06 05:10:00 | AAPL | Stock | 152.35 | 152.55 | 152.35 | 152.55 | 3021.0 |
| 2023-03-06 05:15:00 | AAPL | Stock | 152.55 | 152.57 | 152.53 | 152.53 | 1206.0 |
| 2023-03-06 05:20:00 | AAPL | Stock | 152.55 | 152.55 | 152.47 | 152.47 | 609.0 |
| 2023-03-06 05:30:00 | AAPL | Stock | 152.45 | 152.45 | 152.45 | 152.45 | 1250.0 |
| 2023-03-06 05:35:00 | AAPL | Stock | 152.4 | 152.4 | 152.3 | 152.35 | 2251.0 |
| 2023-03-06 05:40:00 | AAPL | Stock | 152.4 | 152.5 | 152.32 | 152.32 | 6610.0 |
| 2023-03-06 05:45:00 | AAPL | Stock | 152.32 | 152.65 | 152.32 | 152.65 | 3335.0 |
| 2023-03-06 05:50:00 | AAPL | Stock | 152.65 | 152.82 | 152.65 | 152.82 | 6082.0 |
| 2023-03-06 05:55:00 | AAPL | Stock | 152.87 | 152.87 | 152.76 | 152.81 | 853.0 |
| 2023-03-06 06:00:00 | AAPL | Stock | 152.76 | 152.78 | 152.76 | 152.76 | 1617.0 |
| 2023-03-06 06:05:00 | AAPL | Stock | 152.68 | 152.77 | 152.68 | 152.77 | 697.0 |
| 2023-03-06 06:10:00 | AAPL | Stock | 152.85 | 152.88 | 152.85 | 152.85 | 1322.0 |
| 2023-03-06 06:15:00 | AAPL | Stock | 152.83 | 152.83 | 152.7 | 152.7 | 8444.0 |
| 2023-03-06 06:20:00 | AAPL | Stock | 152.74 | 152.75 | 152.67 | 152.67 | 3067.0 |
| 2023-03-06 06:25:00 | AAPL | Stock | 152.68 | 152.7 | 152.55 | 152.55 | 6819.0 |
| 2023-03-06 06:30:00 | AAPL | Stock | 152.55 | 152.74 | 152.45 | 152.73 | 11290.0 |
| 2023-03-06 06:35:00 | AAPL | Stock | 152.46 | 152.57 | 152.46 | 152.57 | 2054.0 |
| 2023-03-06 06:40:00 | AAPL | Stock | 152.6 | 152.6 | 152.5 | 152.5 | 985.0 |
| 2023-03-06 06:45:00 | AAPL | Stock | 152.5 | 152.5 | 152.28 | 152.28 | 4801.0 |
| 2023-03-06 06:50:00 | AAPL | Stock | 152.4 | 152.5 | 152.4 | 152.5 | 1437.0 |
| 2023-03-06 06:55:00 | AAPL | Stock | 152.45 | 152.75 | 152.45 | 152.75 | 5145.0 |
| 2023-03-06 07:00:00 | AAPL | Stock | 152.68 | 153.29 | 152.5 | 153.1 | 41273.0 |
| 2023-03-06 07:05:00 | AAPL | Stock | 153.1 | 153.11 | 153.0 | 153.0 | 10359.0 |
| 2023-03-06 07:10:00 | AAPL | Stock | 152.99 | 152.99 | 152.73 | 152.85 | 16436.0 |
| 2023-03-06 07:15:00 | AAPL | Stock | 152.84 | 152.99 | 152.79 | 152.86 | 15250.0 |
| 2023-03-06 07:20:00 | AAPL | Stock | 152.86 | 152.86 | 152.75 | 152.75 | 14880.0 |
| 2023-03-06 07:25:00 | AAPL | Stock | 152.77 | 152.92 | 152.75 | 152.92 | 13633.0 |
| 2023-03-06 07:30:00 | AAPL | Stock | 152.94 | 153.04 | 152.88 | 153.04 | 11336.0 |
| 2023-03-06 07:35:00 | AAPL | Stock | 152.99 | 153.19 | 152.95 | 153.15 | 8238.0 |
| 2023-03-06 07:40:00 | AAPL | Stock | 153.16 | 153.2 | 153.1 | 153.2 | 3145.0 |
| 2023-03-06 07:45:00 | AAPL | Stock | 153.2 | 153.2 | 153.0 | 153.05 | 12406.0 |
| 2023-03-06 07:50:00 | AAPL | Stock | 153.07 | 153.37 | 153.07 | 153.37 | 36465.0 |
| 2023-03-06 07:55:00 | AAPL | Stock | 153.39 | 153.49 | 153.35 | 153.45 | 20949.0 |
| 2023-03-06 08:00:00 | AAPL | Stock | 152.7 | 153.5 | 150.653 | 153.41 | 187539.0 |
| 2023-03-06 08:05:00 | AAPL | Stock | 153.4103 | 153.47 | 153.35 | 153.45 | 28698.0 |
| 2023-03-06 08:10:00 | AAPL | Stock | 153.45 | 153.54 | 153.42 | 153.49 | 26594.0 |
> showing 50 of 416,280 rows — these rows as CSV