PREVIEW / stock_5min / 2023-09-07
file: by_date/stock_5min/2023/2023-09-07.parquet size: 6.5 MB rows: 396,471 symbols: 1,416
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-09-07 04:00:00 | AAPL | Stock | 181.48 | 181.9 | 179.6 | 179.71 | 59026.0 |
| 2023-09-07 04:05:00 | AAPL | Stock | 179.66 | 179.74 | 179.56 | 179.7 | 22437.0 |
| 2023-09-07 04:10:00 | AAPL | Stock | 179.56 | 179.7 | 179.55 | 179.66 | 6545.0 |
| 2023-09-07 04:15:00 | AAPL | Stock | 179.68 | 179.71 | 179.47 | 179.51 | 10141.0 |
| 2023-09-07 04:20:00 | AAPL | Stock | 179.51 | 179.68 | 179.3 | 179.3 | 15743.0 |
| 2023-09-07 04:25:00 | AAPL | Stock | 179.26 | 179.26 | 177.0 | 177.89 | 80974.0 |
| 2023-09-07 04:30:00 | AAPL | Stock | 177.89 | 178.38 | 177.5 | 178.3 | 38103.0 |
| 2023-09-07 04:35:00 | AAPL | Stock | 178.3 | 178.3 | 177.82 | 178.18 | 13552.0 |
| 2023-09-07 04:40:00 | AAPL | Stock | 178.27 | 178.47 | 178.25 | 178.31 | 15998.0 |
| 2023-09-07 04:45:00 | AAPL | Stock | 178.31 | 178.38 | 177.76 | 178.35 | 10162.0 |
| 2023-09-07 04:50:00 | AAPL | Stock | 178.35 | 178.42 | 177.7 | 178.24 | 21365.0 |
| 2023-09-07 04:55:00 | AAPL | Stock | 178.23 | 178.3 | 177.69 | 177.8 | 21129.0 |
| 2023-09-07 05:00:00 | AAPL | Stock | 177.99 | 178.15 | 177.9 | 178.09 | 14079.0 |
| 2023-09-07 05:05:00 | AAPL | Stock | 178.11 | 178.19 | 177.51 | 177.9 | 15185.0 |
| 2023-09-07 05:10:00 | AAPL | Stock | 177.96 | 178.0 | 177.91 | 177.94 | 13675.0 |
| 2023-09-07 05:15:00 | AAPL | Stock | 178.0 | 178.04 | 177.4 | 177.4 | 16522.0 |
| 2023-09-07 05:20:00 | AAPL | Stock | 177.33 | 177.67 | 177.25 | 177.6 | 10163.0 |
| 2023-09-07 05:25:00 | AAPL | Stock | 177.64 | 177.84 | 177.64 | 177.82 | 5998.0 |
| 2023-09-07 05:30:00 | AAPL | Stock | 177.84 | 178.18 | 177.84 | 178.15 | 13334.0 |
| 2023-09-07 05:35:00 | AAPL | Stock | 178.13 | 178.21 | 178.07 | 178.2 | 5734.0 |
| 2023-09-07 05:40:00 | AAPL | Stock | 178.21 | 178.36 | 178.14 | 178.25 | 8094.0 |
| 2023-09-07 05:45:00 | AAPL | Stock | 178.31 | 178.34 | 178.14 | 178.14 | 5272.0 |
| 2023-09-07 05:50:00 | AAPL | Stock | 178.14 | 178.14 | 178.01 | 178.04 | 5717.0 |
| 2023-09-07 05:55:00 | AAPL | Stock | 178.02 | 178.02 | 177.8 | 177.9 | 4672.0 |
| 2023-09-07 06:00:00 | AAPL | Stock | 177.96 | 178.0 | 177.96 | 177.98 | 3847.0 |
| 2023-09-07 06:05:00 | AAPL | Stock | 177.96 | 178.1 | 177.96 | 178.03 | 4879.0 |
| 2023-09-07 06:10:00 | AAPL | Stock | 178.12 | 178.15 | 178.11 | 178.11 | 400.0 |
| 2023-09-07 06:15:00 | AAPL | Stock | 178.11 | 178.9 | 177.95 | 177.95 | 16793.0 |
| 2023-09-07 06:20:00 | AAPL | Stock | 177.99 | 178.0 | 177.85 | 177.95 | 23783.0 |
| 2023-09-07 06:25:00 | AAPL | Stock | 177.95 | 178.0 | 177.93 | 178.0 | 9878.0 |
| 2023-09-07 06:30:00 | AAPL | Stock | 178.0 | 178.05 | 177.93 | 177.95 | 18414.0 |
| 2023-09-07 06:35:00 | AAPL | Stock | 177.95 | 177.95 | 177.85 | 177.89 | 6151.0 |
| 2023-09-07 06:40:00 | AAPL | Stock | 177.86 | 177.86 | 177.6 | 177.72 | 20080.0 |
| 2023-09-07 06:45:00 | AAPL | Stock | 177.72 | 177.72 | 177.4 | 177.5 | 20318.0 |
| 2023-09-07 06:50:00 | AAPL | Stock | 177.47 | 177.47 | 177.22 | 177.39 | 17897.0 |
| 2023-09-07 06:55:00 | AAPL | Stock | 177.36 | 177.45 | 177.35 | 177.43 | 14095.0 |
| 2023-09-07 07:00:00 | AAPL | Stock | 177.45 | 178.0 | 177.4 | 177.81 | 99440.0 |
| 2023-09-07 07:05:00 | AAPL | Stock | 177.9 | 178.35 | 177.83 | 178.35 | 25973.0 |
| 2023-09-07 07:10:00 | AAPL | Stock | 178.35 | 178.35 | 177.85 | 178.08 | 14613.0 |
| 2023-09-07 07:15:00 | AAPL | Stock | 178.06 | 178.3 | 177.91 | 178.25 | 34141.0 |
| 2023-09-07 07:20:00 | AAPL | Stock | 178.28 | 178.32 | 177.9 | 177.9 | 19209.0 |
| 2023-09-07 07:25:00 | AAPL | Stock | 177.87 | 177.93 | 177.7 | 177.74 | 33452.0 |
| 2023-09-07 07:30:00 | AAPL | Stock | 177.74 | 177.87 | 177.65 | 177.86 | 25832.0 |
| 2023-09-07 07:35:00 | AAPL | Stock | 177.88 | 178.09 | 177.85 | 178.08 | 19713.0 |
| 2023-09-07 07:40:00 | AAPL | Stock | 178.08 | 178.2 | 178.05 | 178.2 | 15572.0 |
| 2023-09-07 07:45:00 | AAPL | Stock | 178.22 | 178.25 | 177.95 | 178.11 | 22543.0 |
| 2023-09-07 07:50:00 | AAPL | Stock | 178.12 | 178.44 | 178.12 | 178.43 | 33110.0 |
| 2023-09-07 07:55:00 | AAPL | Stock | 178.42 | 178.49 | 178.33 | 178.39 | 36836.0 |
| 2023-09-07 08:00:00 | AAPL | Stock | 177.55 | 182.52 | 177.435 | 177.96 | 375107.0 |
| 2023-09-07 08:05:00 | AAPL | Stock | 178.01 | 178.05 | 177.9144 | 178.0 | 47175.0 |
> showing 50 of 396,471 rows — these rows as CSV