PREVIEW / stock_5min / 2023-02-09
file: by_date/stock_5min/2023/2023-02-09.parquet size: 7.0 MB rows: 423,602 symbols: 1,856
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-02-09 04:00:00 | AAPL | Stock | 152.98 | 153.3 | 152.93 | 153.23 | 13534.0 |
| 2023-02-09 04:05:00 | AAPL | Stock | 153.23 | 153.31 | 153.16 | 153.17 | 8044.0 |
| 2023-02-09 04:10:00 | AAPL | Stock | 153.13 | 153.21 | 153.13 | 153.16 | 4112.0 |
| 2023-02-09 04:15:00 | AAPL | Stock | 153.13 | 153.13 | 153.11 | 153.12 | 1900.0 |
| 2023-02-09 04:20:00 | AAPL | Stock | 153.18 | 153.18 | 153.16 | 153.16 | 434.0 |
| 2023-02-09 04:25:00 | AAPL | Stock | 153.16 | 153.16 | 153.12 | 153.12 | 1613.0 |
| 2023-02-09 04:30:00 | AAPL | Stock | 153.14 | 153.26 | 153.14 | 153.26 | 3167.0 |
| 2023-02-09 04:35:00 | AAPL | Stock | 153.29 | 153.35 | 153.29 | 153.35 | 3646.0 |
| 2023-02-09 04:40:00 | AAPL | Stock | 153.45 | 153.47 | 153.45 | 153.47 | 1662.0 |
| 2023-02-09 04:45:00 | AAPL | Stock | 153.48 | 153.67 | 153.48 | 153.67 | 2624.0 |
| 2023-02-09 04:50:00 | AAPL | Stock | 153.61 | 153.61 | 153.3 | 153.49 | 3834.0 |
| 2023-02-09 04:55:00 | AAPL | Stock | 153.49 | 153.69 | 153.49 | 153.69 | 7524.0 |
| 2023-02-09 05:00:00 | AAPL | Stock | 153.68 | 153.72 | 153.61 | 153.72 | 4944.0 |
| 2023-02-09 05:05:00 | AAPL | Stock | 153.72 | 153.72 | 153.59 | 153.59 | 5557.0 |
| 2023-02-09 05:10:00 | AAPL | Stock | 153.67 | 153.67 | 153.64 | 153.64 | 430.0 |
| 2023-02-09 05:15:00 | AAPL | Stock | 153.62 | 153.62 | 153.6 | 153.6 | 200.0 |
| 2023-02-09 05:20:00 | AAPL | Stock | 153.53 | 153.61 | 153.53 | 153.61 | 731.0 |
| 2023-02-09 05:25:00 | AAPL | Stock | 153.6 | 153.6 | 153.58 | 153.58 | 400.0 |
| 2023-02-09 05:30:00 | AAPL | Stock | 153.59 | 153.59 | 153.54 | 153.57 | 1210.0 |
| 2023-02-09 05:35:00 | AAPL | Stock | 153.57 | 153.58 | 153.57 | 153.58 | 750.0 |
| 2023-02-09 05:40:00 | AAPL | Stock | 153.63 | 153.63 | 153.61 | 153.61 | 216.0 |
| 2023-02-09 05:45:00 | AAPL | Stock | 153.62 | 153.67 | 153.57 | 153.66 | 3155.0 |
| 2023-02-09 05:50:00 | AAPL | Stock | 153.69 | 153.76 | 153.69 | 153.76 | 2013.0 |
| 2023-02-09 05:55:00 | AAPL | Stock | 153.75 | 153.78 | 153.7 | 153.76 | 1615.0 |
| 2023-02-09 06:00:00 | AAPL | Stock | 153.76 | 153.79 | 153.75 | 153.75 | 6546.0 |
| 2023-02-09 06:05:00 | AAPL | Stock | 153.67 | 153.67 | 153.67 | 153.67 | 200.0 |
| 2023-02-09 06:10:00 | AAPL | Stock | 153.72 | 153.75 | 153.72 | 153.75 | 208.0 |
| 2023-02-09 06:15:00 | AAPL | Stock | 153.66 | 153.66 | 153.6 | 153.6 | 2077.0 |
| 2023-02-09 06:20:00 | AAPL | Stock | 153.6 | 153.6 | 153.57 | 153.6 | 2155.0 |
| 2023-02-09 06:25:00 | AAPL | Stock | 153.6 | 153.6 | 153.6 | 153.6 | 300.0 |
| 2023-02-09 06:30:00 | AAPL | Stock | 153.63 | 153.64 | 153.56 | 153.56 | 5539.0 |
| 2023-02-09 06:35:00 | AAPL | Stock | 153.53 | 153.53 | 153.5 | 153.51 | 1439.0 |
| 2023-02-09 06:40:00 | AAPL | Stock | 153.58 | 153.64 | 153.58 | 153.64 | 1828.0 |
| 2023-02-09 06:45:00 | AAPL | Stock | 153.64 | 153.64 | 153.58 | 153.6 | 4960.0 |
| 2023-02-09 06:50:00 | AAPL | Stock | 153.71 | 153.71 | 153.59 | 153.6 | 2502.0 |
| 2023-02-09 06:55:00 | AAPL | Stock | 153.6 | 153.6 | 153.6 | 153.6 | 1769.0 |
| 2023-02-09 07:00:00 | AAPL | Stock | 153.63 | 153.65 | 153.5 | 153.6 | 28025.0 |
| 2023-02-09 07:05:00 | AAPL | Stock | 153.6 | 153.6 | 153.56 | 153.58 | 3119.0 |
| 2023-02-09 07:10:00 | AAPL | Stock | 153.53 | 153.59 | 153.51 | 153.51 | 6921.0 |
| 2023-02-09 07:15:00 | AAPL | Stock | 153.54 | 153.65 | 153.54 | 153.6 | 2287.0 |
| 2023-02-09 07:20:00 | AAPL | Stock | 153.61 | 153.64 | 153.6 | 153.62 | 5092.0 |
| 2023-02-09 07:25:00 | AAPL | Stock | 153.65 | 153.7 | 153.64 | 153.64 | 3547.0 |
| 2023-02-09 07:30:00 | AAPL | Stock | 153.62 | 153.74 | 153.62 | 153.74 | 2907.0 |
| 2023-02-09 07:35:00 | AAPL | Stock | 153.65 | 153.65 | 153.58 | 153.58 | 830.0 |
| 2023-02-09 07:40:00 | AAPL | Stock | 153.5 | 153.6 | 153.49 | 153.6 | 5978.0 |
| 2023-02-09 07:45:00 | AAPL | Stock | 153.56 | 153.56 | 153.56 | 153.56 | 9651.0 |
| 2023-02-09 07:50:00 | AAPL | Stock | 153.53 | 153.62 | 153.52 | 153.55 | 3015.0 |
| 2023-02-09 07:55:00 | AAPL | Stock | 153.52 | 153.52 | 153.35 | 153.37 | 2382.0 |
| 2023-02-09 08:00:00 | AAPL | Stock | 153.5 | 153.7515 | 151.541 | 153.44 | 105943.0 |
| 2023-02-09 08:05:00 | AAPL | Stock | 153.44 | 153.45 | 153.35 | 153.41 | 21611.0 |
> showing 50 of 423,602 rows — these rows as CSV