PREVIEW / stock_5min / 2023-10-10
file: by_date/stock_5min/2023/2023-10-10.parquet size: 6.4 MB rows: 386,403 symbols: 1,387
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-10-10 04:00:00 | AAPL | Stock | 179.0 | 179.0 | 178.88 | 178.88 | 1447.0 |
| 2023-10-10 04:10:00 | AAPL | Stock | 178.85 | 179.02 | 178.85 | 179.0 | 3181.0 |
| 2023-10-10 04:15:00 | AAPL | Stock | 179.0 | 179.01 | 179.0 | 179.0 | 1022.0 |
| 2023-10-10 04:20:00 | AAPL | Stock | 179.07 | 179.14 | 179.03 | 179.14 | 2324.0 |
| 2023-10-10 04:25:00 | AAPL | Stock | 179.17 | 179.25 | 179.17 | 179.25 | 6451.0 |
| 2023-10-10 04:30:00 | AAPL | Stock | 179.3 | 179.33 | 179.28 | 179.3 | 890.0 |
| 2023-10-10 04:35:00 | AAPL | Stock | 179.27 | 179.32 | 179.27 | 179.27 | 416.0 |
| 2023-10-10 04:40:00 | AAPL | Stock | 179.23 | 179.23 | 179.2 | 179.2 | 996.0 |
| 2023-10-10 04:45:00 | AAPL | Stock | 179.2 | 179.24 | 179.2 | 179.24 | 800.0 |
| 2023-10-10 04:50:00 | AAPL | Stock | 179.3 | 179.3 | 179.3 | 179.3 | 263.0 |
| 2023-10-10 04:55:00 | AAPL | Stock | 179.35 | 179.35 | 179.29 | 179.35 | 1940.0 |
| 2023-10-10 05:00:00 | AAPL | Stock | 179.3 | 179.3 | 179.2 | 179.2 | 4627.0 |
| 2023-10-10 05:05:00 | AAPL | Stock | 179.17 | 179.17 | 179.17 | 179.17 | 500.0 |
| 2023-10-10 05:10:00 | AAPL | Stock | 179.25 | 179.25 | 179.15 | 179.15 | 684.0 |
| 2023-10-10 05:15:00 | AAPL | Stock | 179.23 | 179.24 | 179.23 | 179.24 | 1077.0 |
| 2023-10-10 05:20:00 | AAPL | Stock | 179.24 | 179.24 | 179.18 | 179.18 | 904.0 |
| 2023-10-10 05:30:00 | AAPL | Stock | 179.15 | 179.15 | 179.15 | 179.15 | 400.0 |
| 2023-10-10 05:40:00 | AAPL | Stock | 179.1 | 179.16 | 179.1 | 179.16 | 215.0 |
| 2023-10-10 05:45:00 | AAPL | Stock | 179.13 | 179.13 | 179.13 | 179.13 | 100.0 |
| 2023-10-10 05:50:00 | AAPL | Stock | 179.13 | 179.13 | 179.12 | 179.12 | 400.0 |
| 2023-10-10 06:00:00 | AAPL | Stock | 179.14 | 179.14 | 179.05 | 179.05 | 300.0 |
| 2023-10-10 06:05:00 | AAPL | Stock | 179.16 | 179.18 | 179.16 | 179.18 | 1011.0 |
| 2023-10-10 06:10:00 | AAPL | Stock | 179.11 | 179.11 | 179.11 | 179.11 | 452.0 |
| 2023-10-10 06:15:00 | AAPL | Stock | 179.14 | 179.14 | 179.1 | 179.1 | 1328.0 |
| 2023-10-10 06:20:00 | AAPL | Stock | 179.08 | 179.08 | 179.08 | 179.08 | 102.0 |
| 2023-10-10 06:25:00 | AAPL | Stock | 179.15 | 179.18 | 179.15 | 179.18 | 1313.0 |
| 2023-10-10 06:30:00 | AAPL | Stock | 179.17 | 179.17 | 179.17 | 179.17 | 100.0 |
| 2023-10-10 06:35:00 | AAPL | Stock | 179.13 | 179.13 | 179.13 | 179.13 | 252.0 |
| 2023-10-10 06:40:00 | AAPL | Stock | 179.1 | 179.16 | 179.1 | 179.16 | 1334.0 |
| 2023-10-10 06:45:00 | AAPL | Stock | 179.15 | 179.15 | 179.1 | 179.1 | 2485.0 |
| 2023-10-10 06:50:00 | AAPL | Stock | 179.13 | 179.13 | 179.07 | 179.07 | 1519.0 |
| 2023-10-10 06:55:00 | AAPL | Stock | 179.01 | 179.01 | 178.82 | 178.82 | 4298.0 |
| 2023-10-10 07:00:00 | AAPL | Stock | 178.89 | 178.89 | 178.78 | 178.83 | 1792.0 |
| 2023-10-10 07:05:00 | AAPL | Stock | 178.82 | 178.82 | 178.55 | 178.6 | 4880.0 |
| 2023-10-10 07:10:00 | AAPL | Stock | 178.63 | 178.63 | 178.38 | 178.41 | 4148.0 |
| 2023-10-10 07:15:00 | AAPL | Stock | 178.49 | 178.55 | 178.48 | 178.48 | 4866.0 |
| 2023-10-10 07:20:00 | AAPL | Stock | 178.5 | 178.51 | 178.25 | 178.25 | 3846.0 |
| 2023-10-10 07:25:00 | AAPL | Stock | 178.25 | 178.3 | 178.2 | 178.25 | 2802.0 |
| 2023-10-10 07:30:00 | AAPL | Stock | 178.3 | 178.49 | 178.3 | 178.47 | 3808.0 |
| 2023-10-10 07:35:00 | AAPL | Stock | 178.45 | 178.51 | 178.3 | 178.4 | 8004.0 |
| 2023-10-10 07:40:00 | AAPL | Stock | 178.41 | 178.41 | 178.35 | 178.35 | 700.0 |
| 2023-10-10 07:45:00 | AAPL | Stock | 178.32 | 178.33 | 177.84 | 177.84 | 13537.0 |
| 2023-10-10 07:50:00 | AAPL | Stock | 177.92 | 178.0 | 177.92 | 177.94 | 10489.0 |
| 2023-10-10 07:55:00 | AAPL | Stock | 177.94 | 177.95 | 177.7 | 177.7 | 16018.0 |
| 2023-10-10 08:00:00 | AAPL | Stock | 178.25 | 179.11 | 177.7 | 177.83 | 66766.0 |
| 2023-10-10 08:05:00 | AAPL | Stock | 177.94 | 178.18 | 177.9 | 178.1 | 18867.0 |
| 2023-10-10 08:10:00 | AAPL | Stock | 178.08 | 178.15 | 178.08 | 178.1 | 2929.0 |
| 2023-10-10 08:15:00 | AAPL | Stock | 178.1898 | 178.19 | 178.0808 | 178.13 | 2372.0 |
| 2023-10-10 08:20:00 | AAPL | Stock | 178.13 | 178.29 | 178.12 | 178.29 | 6088.0 |
| 2023-10-10 08:25:00 | AAPL | Stock | 178.25 | 178.3 | 178.2 | 178.29 | 5930.0 |
> showing 50 of 386,403 rows — these rows as CSV