PREVIEW / stock_30min / 2024-08-20
file: by_date/stock_30min/2024/2024-08-20.parquet size: 2.0 MB rows: 98,020 symbols: 848
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-20 04:00:00 | AAPL | Stock | 226.11 | 226.19 | 225.81 | 225.9 | 7322.0 |
| 2024-08-20 04:30:00 | AAPL | Stock | 225.92 | 225.99 | 225.69 | 225.79 | 6356.0 |
| 2024-08-20 05:00:00 | AAPL | Stock | 225.81 | 226.11 | 225.81 | 226.1 | 1025.0 |
| 2024-08-20 05:30:00 | AAPL | Stock | 226.18 | 226.18 | 226.0 | 226.05 | 3110.0 |
| 2024-08-20 06:00:00 | AAPL | Stock | 225.98 | 226.12 | 225.96 | 226.12 | 1804.0 |
| 2024-08-20 06:30:00 | AAPL | Stock | 226.1 | 226.27 | 226.07 | 226.21 | 4224.0 |
| 2024-08-20 07:00:00 | AAPL | Stock | 226.12 | 226.16 | 226.0 | 226.09 | 4696.0 |
| 2024-08-20 07:30:00 | AAPL | Stock | 226.05 | 226.14 | 225.92 | 226.0 | 3393.0 |
| 2024-08-20 08:00:00 | AAPL | Stock | 225.99 | 226.2 | 225.6705 | 225.83 | 37828.0 |
| 2024-08-20 08:30:00 | AAPL | Stock | 225.71 | 225.98 | 225.71 | 225.9019 | 22796.0 |
| 2024-08-20 09:00:00 | AAPL | Stock | 225.98 | 226.15 | 225.11 | 225.81 | 89013.0 |
| 2024-08-20 09:30:00 | AAPL | Stock | 225.75 | 227.17 | 225.45 | 227.02 | 3863966.0 |
| 2024-08-20 10:00:00 | AAPL | Stock | 227.02 | 227.1 | 226.05 | 226.66 | 1866656.0 |
| 2024-08-20 10:30:00 | AAPL | Stock | 226.68 | 226.69 | 225.71 | 225.96 | 1618166.0 |
| 2024-08-20 11:00:00 | AAPL | Stock | 225.96 | 226.54 | 225.86 | 226.21 | 934838.0 |
| 2024-08-20 11:30:00 | AAPL | Stock | 226.21 | 226.9756 | 226.08 | 226.9268 | 935714.0 |
| 2024-08-20 12:00:00 | AAPL | Stock | 226.92 | 227.1 | 226.6 | 226.9 | 890424.0 |
| 2024-08-20 12:30:00 | AAPL | Stock | 226.895 | 227.09 | 226.46 | 226.52 | 778022.0 |
| 2024-08-20 13:00:00 | AAPL | Stock | 226.53 | 226.79 | 226.11 | 226.71 | 797072.0 |
| 2024-08-20 13:30:00 | AAPL | Stock | 226.7 | 226.79 | 226.35 | 226.76 | 607962.0 |
| 2024-08-20 14:00:00 | AAPL | Stock | 226.75 | 227.11 | 226.6504 | 227.02 | 871751.0 |
| 2024-08-20 14:30:00 | AAPL | Stock | 227.03 | 227.06 | 226.5202 | 226.525 | 674966.0 |
| 2024-08-20 15:00:00 | AAPL | Stock | 226.52 | 226.54 | 226.19 | 226.485 | 1048206.0 |
| 2024-08-20 15:30:00 | AAPL | Stock | 226.48 | 226.93 | 226.39 | 226.51 | 1928020.0 |
| 2024-08-20 16:00:00 | AAPL | Stock | 226.4334 | 226.89 | 226.4334 | 226.78 | 6117419.0 |
| 2024-08-20 16:30:00 | AAPL | Stock | 226.74 | 226.74 | 226.51 | 226.53 | 115825.0 |
| 2024-08-20 17:00:00 | AAPL | Stock | 226.58 | 226.66 | 226.461 | 226.461 | 18493.0 |
| 2024-08-20 17:30:00 | AAPL | Stock | 226.5 | 226.6 | 226.45 | 226.4503 | 4622.0 |
| 2024-08-20 18:00:00 | AAPL | Stock | 226.53 | 226.84 | 226.32 | 226.34 | 9336.0 |
| 2024-08-20 18:30:00 | AAPL | Stock | 226.35 | 226.62 | 226.32 | 226.3584 | 11276.0 |
| 2024-08-20 19:00:00 | AAPL | Stock | 226.52 | 226.76 | 226.44 | 226.56 | 8673.0 |
| 2024-08-20 19:30:00 | AAPL | Stock | 226.68 | 227.0 | 226.45 | 226.55 | 15923.0 |
| 2024-08-20 04:00:00 | MSFT | Stock | 422.69 | 423.1 | 422.51 | 422.72 | 3477.0 |
| 2024-08-20 04:30:00 | MSFT | Stock | 422.93 | 422.93 | 422.03 | 422.66 | 3192.0 |
| 2024-08-20 05:00:00 | MSFT | Stock | 422.85 | 422.95 | 422.81 | 422.9 | 1330.0 |
| 2024-08-20 06:00:00 | MSFT | Stock | 422.41 | 422.68 | 422.41 | 422.65 | 382.0 |
| 2024-08-20 06:30:00 | MSFT | Stock | 422.76 | 422.94 | 422.6 | 422.6 | 1306.0 |
| 2024-08-20 07:00:00 | MSFT | Stock | 422.6 | 422.63 | 422.27 | 422.35 | 1547.0 |
| 2024-08-20 07:30:00 | MSFT | Stock | 422.35 | 422.51 | 422.22 | 422.22 | 2915.0 |
| 2024-08-20 08:00:00 | MSFT | Stock | 422.6 | 423.0 | 422.2 | 422.7 | 9976.0 |
| 2024-08-20 08:30:00 | MSFT | Stock | 422.57 | 422.57 | 421.25 | 421.4717 | 17661.0 |
| 2024-08-20 09:00:00 | MSFT | Stock | 421.61 | 422.2 | 421.05 | 421.92 | 17583.0 |
| 2024-08-20 09:30:00 | MSFT | Stock | 421.7 | 423.61 | 421.64 | 423.4098 | 1030154.0 |
| 2024-08-20 10:00:00 | MSFT | Stock | 423.43 | 423.655 | 422.35 | 422.55 | 644865.0 |
| 2024-08-20 10:30:00 | MSFT | Stock | 422.57 | 423.38 | 421.97 | 423.12 | 515703.0 |
| 2024-08-20 11:00:00 | MSFT | Stock | 423.17 | 423.17 | 421.82 | 422.025 | 264112.0 |
| 2024-08-20 11:30:00 | MSFT | Stock | 421.9 | 422.88 | 421.87 | 422.87 | 263272.0 |
| 2024-08-20 12:00:00 | MSFT | Stock | 422.9 | 423.09 | 422.36 | 423.08 | 304678.0 |
| 2024-08-20 12:30:00 | MSFT | Stock | 423.065 | 424.0 | 422.9 | 423.5 | 413486.0 |
| 2024-08-20 13:00:00 | MSFT | Stock | 423.53 | 423.98 | 423.21 | 423.765 | 367376.0 |
> showing 50 of 98,020 rows — these rows as CSV