PREVIEW / stock_5min / 2023-07-03
file: by_date/stock_5min/2023/2023-07-03.parquet size: 4.2 MB rows: 246,685 symbols: 1,481
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-07-03 04:00:00 | AAPL | Stock | 193.99 | 194.25 | 193.97 | 194.13 | 17912.0 |
| 2023-07-03 04:05:00 | AAPL | Stock | 194.06 | 194.16 | 193.99 | 194.0 | 3615.0 |
| 2023-07-03 04:10:00 | AAPL | Stock | 193.97 | 194.11 | 193.96 | 194.02 | 4870.0 |
| 2023-07-03 04:15:00 | AAPL | Stock | 194.05 | 194.05 | 193.82 | 193.84 | 4140.0 |
| 2023-07-03 04:20:00 | AAPL | Stock | 193.84 | 193.88 | 193.8 | 193.8 | 4441.0 |
| 2023-07-03 04:25:00 | AAPL | Stock | 193.74 | 193.76 | 193.73 | 193.73 | 843.0 |
| 2023-07-03 04:30:00 | AAPL | Stock | 193.76 | 193.8 | 193.76 | 193.8 | 882.0 |
| 2023-07-03 04:35:00 | AAPL | Stock | 193.85 | 193.85 | 193.73 | 193.73 | 3248.0 |
| 2023-07-03 04:40:00 | AAPL | Stock | 193.73 | 193.82 | 193.73 | 193.82 | 1621.0 |
| 2023-07-03 04:45:00 | AAPL | Stock | 193.76 | 193.8 | 193.76 | 193.79 | 2847.0 |
| 2023-07-03 04:50:00 | AAPL | Stock | 193.79 | 193.83 | 193.79 | 193.79 | 1735.0 |
| 2023-07-03 04:55:00 | AAPL | Stock | 193.77 | 193.78 | 193.71 | 193.71 | 1589.0 |
| 2023-07-03 05:00:00 | AAPL | Stock | 193.72 | 193.74 | 193.7 | 193.7 | 2335.0 |
| 2023-07-03 05:05:00 | AAPL | Stock | 193.72 | 193.8 | 193.69 | 193.8 | 5131.0 |
| 2023-07-03 05:10:00 | AAPL | Stock | 193.8 | 193.8 | 193.79 | 193.79 | 884.0 |
| 2023-07-03 05:15:00 | AAPL | Stock | 193.79 | 193.79 | 193.77 | 193.77 | 643.0 |
| 2023-07-03 05:20:00 | AAPL | Stock | 193.68 | 193.68 | 193.68 | 193.68 | 100.0 |
| 2023-07-03 05:25:00 | AAPL | Stock | 193.7 | 193.7 | 193.7 | 193.7 | 132.0 |
| 2023-07-03 05:30:00 | AAPL | Stock | 193.8 | 193.8 | 193.65 | 193.65 | 1222.0 |
| 2023-07-03 05:35:00 | AAPL | Stock | 193.66 | 193.66 | 193.6 | 193.6 | 4747.0 |
| 2023-07-03 05:40:00 | AAPL | Stock | 193.6 | 193.6 | 193.54 | 193.55 | 1676.0 |
| 2023-07-03 05:50:00 | AAPL | Stock | 193.6 | 193.6 | 193.6 | 193.6 | 560.0 |
| 2023-07-03 05:55:00 | AAPL | Stock | 193.6 | 193.62 | 193.6 | 193.62 | 1221.0 |
| 2023-07-03 06:00:00 | AAPL | Stock | 193.63 | 193.63 | 193.51 | 193.51 | 404.0 |
| 2023-07-03 06:05:00 | AAPL | Stock | 193.5 | 193.51 | 193.0 | 193.35 | 4971.0 |
| 2023-07-03 06:10:00 | AAPL | Stock | 193.35 | 193.42 | 193.35 | 193.4 | 901.0 |
| 2023-07-03 06:15:00 | AAPL | Stock | 193.47 | 193.47 | 193.36 | 193.36 | 1726.0 |
| 2023-07-03 06:20:00 | AAPL | Stock | 193.38 | 193.5 | 193.38 | 193.49 | 950.0 |
| 2023-07-03 06:25:00 | AAPL | Stock | 193.43 | 193.43 | 193.43 | 193.43 | 1181.0 |
| 2023-07-03 06:35:00 | AAPL | Stock | 193.48 | 193.48 | 193.48 | 193.48 | 200.0 |
| 2023-07-03 06:45:00 | AAPL | Stock | 193.46 | 193.46 | 193.46 | 193.46 | 158.0 |
| 2023-07-03 06:50:00 | AAPL | Stock | 193.48 | 193.48 | 193.36 | 193.4 | 1442.0 |
| 2023-07-03 06:55:00 | AAPL | Stock | 193.37 | 193.37 | 193.2 | 193.22 | 3698.0 |
| 2023-07-03 07:00:00 | AAPL | Stock | 193.31 | 193.6 | 193.22 | 193.58 | 23339.0 |
| 2023-07-03 07:05:00 | AAPL | Stock | 193.6 | 193.6 | 193.4 | 193.4 | 20600.0 |
| 2023-07-03 07:10:00 | AAPL | Stock | 193.5 | 193.58 | 193.4 | 193.43 | 10221.0 |
| 2023-07-03 07:15:00 | AAPL | Stock | 193.52 | 193.59 | 193.44 | 193.52 | 1142.0 |
| 2023-07-03 07:20:00 | AAPL | Stock | 193.52 | 193.56 | 193.49 | 193.56 | 4439.0 |
| 2023-07-03 07:25:00 | AAPL | Stock | 193.56 | 193.65 | 193.56 | 193.61 | 6768.0 |
| 2023-07-03 07:30:00 | AAPL | Stock | 193.6 | 193.6 | 193.42 | 193.44 | 6654.0 |
| 2023-07-03 07:35:00 | AAPL | Stock | 193.47 | 193.55 | 193.46 | 193.55 | 1926.0 |
| 2023-07-03 07:40:00 | AAPL | Stock | 193.53 | 193.56 | 193.49 | 193.54 | 9744.0 |
| 2023-07-03 07:45:00 | AAPL | Stock | 193.53 | 193.54 | 193.5 | 193.54 | 2668.0 |
| 2023-07-03 07:50:00 | AAPL | Stock | 193.51 | 193.51 | 193.45 | 193.5 | 3045.0 |
| 2023-07-03 07:55:00 | AAPL | Stock | 193.47 | 193.47 | 193.33 | 193.41 | 9393.0 |
| 2023-07-03 08:00:00 | AAPL | Stock | 193.43 | 195.27 | 193.26 | 193.34 | 135809.0 |
| 2023-07-03 08:05:00 | AAPL | Stock | 193.38 | 193.38 | 193.29 | 193.35 | 10927.0 |
| 2023-07-03 08:10:00 | AAPL | Stock | 193.3599 | 193.4 | 193.32 | 193.35 | 6595.0 |
| 2023-07-03 08:15:00 | AAPL | Stock | 193.35 | 193.97 | 193.25 | 193.3 | 24542.0 |
| 2023-07-03 08:20:00 | AAPL | Stock | 193.3 | 193.48 | 193.3 | 193.47 | 19001.0 |
> showing 50 of 246,685 rows — these rows as CSV