PREVIEW / stock_5min / 2022-03-18
file: by_date/stock_5min/2022/2022-03-18.parquet size: 7.5 MB rows: 462,546 symbols: 2,482
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-18 04:00:00 | AAPL | Stock | 159.89 | 159.89 | 159.67 | 159.8 | 586.0 |
| 2022-03-18 04:05:00 | AAPL | Stock | 159.8 | 159.88 | 159.74 | 159.88 | 2291.0 |
| 2022-03-18 04:10:00 | AAPL | Stock | 159.9 | 159.9 | 159.9 | 159.9 | 674.0 |
| 2022-03-18 04:15:00 | AAPL | Stock | 160.0 | 160.0 | 159.88 | 159.88 | 864.0 |
| 2022-03-18 04:20:00 | AAPL | Stock | 159.87 | 159.99 | 159.87 | 159.99 | 1105.0 |
| 2022-03-18 04:25:00 | AAPL | Stock | 160.01 | 160.05 | 160.0 | 160.05 | 2446.0 |
| 2022-03-18 04:30:00 | AAPL | Stock | 160.07 | 160.07 | 159.62 | 159.62 | 3700.0 |
| 2022-03-18 04:35:00 | AAPL | Stock | 159.75 | 159.89 | 159.75 | 159.89 | 720.0 |
| 2022-03-18 04:40:00 | AAPL | Stock | 159.81 | 159.81 | 159.6 | 159.6 | 2691.0 |
| 2022-03-18 04:45:00 | AAPL | Stock | 159.78 | 159.78 | 159.55 | 159.55 | 1324.0 |
| 2022-03-18 04:50:00 | AAPL | Stock | 159.56 | 159.7 | 159.56 | 159.61 | 873.0 |
| 2022-03-18 05:00:00 | AAPL | Stock | 159.6 | 159.6 | 159.57 | 159.57 | 355.0 |
| 2022-03-18 05:05:00 | AAPL | Stock | 159.64 | 159.64 | 159.64 | 159.64 | 250.0 |
| 2022-03-18 05:15:00 | AAPL | Stock | 159.59 | 159.59 | 159.36 | 159.36 | 1213.0 |
| 2022-03-18 05:25:00 | AAPL | Stock | 159.45 | 159.5 | 159.4 | 159.5 | 2299.0 |
| 2022-03-18 05:30:00 | AAPL | Stock | 159.8 | 159.85 | 159.8 | 159.85 | 295.0 |
| 2022-03-18 05:35:00 | AAPL | Stock | 159.66 | 159.66 | 159.66 | 159.66 | 150.0 |
| 2022-03-18 05:45:00 | AAPL | Stock | 159.7 | 159.7 | 159.7 | 159.7 | 340.0 |
| 2022-03-18 05:50:00 | AAPL | Stock | 159.69 | 159.7 | 159.69 | 159.7 | 335.0 |
| 2022-03-18 05:55:00 | AAPL | Stock | 159.71 | 159.71 | 159.71 | 159.71 | 200.0 |
| 2022-03-18 06:05:00 | AAPL | Stock | 159.78 | 159.98 | 159.78 | 159.98 | 2963.0 |
| 2022-03-18 06:10:00 | AAPL | Stock | 159.98 | 159.99 | 159.98 | 159.99 | 1000.0 |
| 2022-03-18 06:15:00 | AAPL | Stock | 159.88 | 159.88 | 159.6 | 159.6 | 1646.0 |
| 2022-03-18 06:20:00 | AAPL | Stock | 159.61 | 159.71 | 159.61 | 159.71 | 251.0 |
| 2022-03-18 06:30:00 | AAPL | Stock | 159.71 | 159.71 | 159.6 | 159.61 | 929.0 |
| 2022-03-18 06:35:00 | AAPL | Stock | 159.6 | 159.6 | 159.6 | 159.6 | 845.0 |
| 2022-03-18 06:40:00 | AAPL | Stock | 159.62 | 159.62 | 159.35 | 159.5 | 1168.0 |
| 2022-03-18 06:45:00 | AAPL | Stock | 159.38 | 159.51 | 159.38 | 159.51 | 433.0 |
| 2022-03-18 06:50:00 | AAPL | Stock | 159.5 | 159.5 | 159.35 | 159.44 | 1053.0 |
| 2022-03-18 06:55:00 | AAPL | Stock | 159.45 | 159.5 | 159.45 | 159.5 | 836.0 |
| 2022-03-18 07:00:00 | AAPL | Stock | 159.55 | 159.6 | 159.5 | 159.55 | 12181.0 |
| 2022-03-18 07:05:00 | AAPL | Stock | 159.52 | 159.55 | 159.4 | 159.41 | 9528.0 |
| 2022-03-18 07:10:00 | AAPL | Stock | 159.46 | 159.53 | 159.35 | 159.53 | 4689.0 |
| 2022-03-18 07:15:00 | AAPL | Stock | 159.5 | 159.62 | 159.5 | 159.62 | 1948.0 |
| 2022-03-18 07:20:00 | AAPL | Stock | 159.62 | 159.62 | 159.57 | 159.57 | 1900.0 |
| 2022-03-18 07:25:00 | AAPL | Stock | 159.55 | 159.57 | 159.32 | 159.52 | 10151.0 |
| 2022-03-18 07:30:00 | AAPL | Stock | 159.54 | 159.63 | 159.54 | 159.63 | 3225.0 |
| 2022-03-18 07:35:00 | AAPL | Stock | 159.6 | 159.67 | 159.6 | 159.67 | 5227.0 |
| 2022-03-18 07:40:00 | AAPL | Stock | 159.67 | 159.72 | 159.67 | 159.72 | 5817.0 |
| 2022-03-18 07:45:00 | AAPL | Stock | 159.72 | 159.72 | 159.58 | 159.65 | 8897.0 |
| 2022-03-18 07:50:00 | AAPL | Stock | 159.62 | 159.62 | 159.53 | 159.55 | 2197.0 |
| 2022-03-18 07:55:00 | AAPL | Stock | 159.58 | 159.64 | 159.49 | 159.49 | 4624.0 |
| 2022-03-18 08:00:00 | AAPL | Stock | 159.5301 | 161.021 | 159.3 | 159.4 | 143224.0 |
| 2022-03-18 08:05:00 | AAPL | Stock | 159.35 | 159.59 | 159.35 | 159.581 | 6225.0 |
| 2022-03-18 08:10:00 | AAPL | Stock | 159.59 | 159.66 | 159.51 | 159.61 | 5146.0 |
| 2022-03-18 08:15:00 | AAPL | Stock | 159.5899 | 159.59 | 159.37 | 159.49 | 24282.0 |
| 2022-03-18 08:20:00 | AAPL | Stock | 159.4471 | 159.71 | 159.4471 | 159.67 | 19253.0 |
| 2022-03-18 08:25:00 | AAPL | Stock | 159.69 | 159.77 | 159.64 | 159.76 | 24763.0 |
| 2022-03-18 08:30:00 | AAPL | Stock | 159.72 | 159.7399 | 159.62 | 159.64 | 4506.0 |
| 2022-03-18 08:35:00 | AAPL | Stock | 159.61 | 159.77 | 159.61 | 159.77 | 20222.0 |
> showing 50 of 462,546 rows — these rows as CSV