PREVIEW / stock_30min / 2024-03-27
file: by_date/stock_30min/2024/2024-03-27.parquet size: 2.0 MB rows: 100,177 symbols: 1,047
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-03-27 04:00:00 | AAPL | Stock | 170.0 | 170.12 | 169.7 | 170.11 | 6681.0 |
| 2024-03-27 04:30:00 | AAPL | Stock | 170.12 | 170.12 | 169.99 | 169.99 | 7340.0 |
| 2024-03-27 05:00:00 | AAPL | Stock | 170.07 | 170.2 | 170.07 | 170.2 | 1987.0 |
| 2024-03-27 05:30:00 | AAPL | Stock | 170.2 | 170.2 | 170.09 | 170.15 | 3058.0 |
| 2024-03-27 06:00:00 | AAPL | Stock | 170.22 | 170.58 | 170.16 | 170.58 | 9736.0 |
| 2024-03-27 06:30:00 | AAPL | Stock | 170.6 | 170.61 | 170.44 | 170.44 | 9044.0 |
| 2024-03-27 07:00:00 | AAPL | Stock | 170.5 | 170.51 | 170.28 | 170.42 | 10733.0 |
| 2024-03-27 07:30:00 | AAPL | Stock | 170.41 | 170.55 | 170.41 | 170.5 | 8944.0 |
| 2024-03-27 08:00:00 | AAPL | Stock | 170.238 | 170.56 | 169.96 | 170.35 | 48152.0 |
| 2024-03-27 08:30:00 | AAPL | Stock | 170.34 | 170.86 | 170.34 | 170.7787 | 44388.0 |
| 2024-03-27 09:00:00 | AAPL | Stock | 170.75 | 170.8 | 170.15 | 170.36 | 111450.0 |
| 2024-03-27 09:30:00 | AAPL | Stock | 170.39 | 172.88 | 170.11 | 172.7152 | 7612443.0 |
| 2024-03-27 10:00:00 | AAPL | Stock | 172.72 | 173.12 | 171.94 | 172.045 | 5156841.0 |
| 2024-03-27 10:30:00 | AAPL | Stock | 172.04 | 172.53 | 171.9401 | 172.455 | 2577343.0 |
| 2024-03-27 11:00:00 | AAPL | Stock | 172.44 | 172.76 | 172.33 | 172.455 | 2271709.0 |
| 2024-03-27 11:30:00 | AAPL | Stock | 172.46 | 172.7 | 172.05 | 172.06 | 1932323.0 |
| 2024-03-27 12:00:00 | AAPL | Stock | 172.07 | 172.31 | 171.86 | 172.0468 | 1772839.0 |
| 2024-03-27 12:30:00 | AAPL | Stock | 172.05 | 172.3499 | 172.035 | 172.165 | 1575669.0 |
| 2024-03-27 13:00:00 | AAPL | Stock | 172.17 | 172.39 | 172.0 | 172.26 | 1353100.0 |
| 2024-03-27 13:30:00 | AAPL | Stock | 172.27 | 172.49 | 172.14 | 172.288 | 1396117.0 |
| 2024-03-27 14:00:00 | AAPL | Stock | 172.28 | 172.82 | 172.23 | 172.755 | 1732247.0 |
| 2024-03-27 14:30:00 | AAPL | Stock | 172.76 | 172.785 | 172.4263 | 172.7 | 1738964.0 |
| 2024-03-27 15:00:00 | AAPL | Stock | 172.7 | 173.1 | 172.62 | 172.99 | 2854112.0 |
| 2024-03-27 15:30:00 | AAPL | Stock | 173.0 | 173.6 | 172.88 | 173.41 | 7251533.0 |
| 2024-03-27 16:00:00 | AAPL | Stock | 173.41 | 173.69 | 173.13 | 173.31 | 9286099.0 |
| 2024-03-27 16:30:00 | AAPL | Stock | 173.31 | 173.33 | 173.09 | 173.15 | 138165.0 |
| 2024-03-27 17:00:00 | AAPL | Stock | 173.12 | 173.25 | 173.11 | 173.18 | 13970.0 |
| 2024-03-27 17:30:00 | AAPL | Stock | 173.15 | 173.1689 | 173.01 | 173.09 | 27209.0 |
| 2024-03-27 18:00:00 | AAPL | Stock | 173.08 | 173.31 | 172.92 | 173.31 | 29381.0 |
| 2024-03-27 18:30:00 | AAPL | Stock | 173.0 | 173.01 | 172.88 | 172.93 | 24115.0 |
| 2024-03-27 19:00:00 | AAPL | Stock | 172.89 | 173.0 | 172.89 | 173.0 | 9795.0 |
| 2024-03-27 19:30:00 | AAPL | Stock | 172.92 | 173.0 | 172.87 | 172.9 | 10830.0 |
| 2024-03-27 04:00:00 | MSFT | Stock | 422.07 | 422.3 | 421.8 | 421.99 | 5181.0 |
| 2024-03-27 04:30:00 | MSFT | Stock | 421.98 | 421.98 | 421.46 | 421.46 | 1485.0 |
| 2024-03-27 05:00:00 | MSFT | Stock | 421.79 | 421.79 | 421.79 | 421.79 | 100.0 |
| 2024-03-27 05:30:00 | MSFT | Stock | 421.5 | 422.33 | 421.5 | 422.11 | 1704.0 |
| 2024-03-27 06:00:00 | MSFT | Stock | 422.2 | 422.25 | 422.0 | 422.02 | 2037.0 |
| 2024-03-27 06:30:00 | MSFT | Stock | 422.39 | 422.74 | 422.39 | 422.7 | 1022.0 |
| 2024-03-27 07:00:00 | MSFT | Stock | 422.75 | 422.88 | 422.15 | 422.15 | 5994.0 |
| 2024-03-27 07:30:00 | MSFT | Stock | 422.42 | 422.43 | 422.4 | 422.43 | 300.0 |
| 2024-03-27 08:00:00 | MSFT | Stock | 422.54 | 423.11 | 422.0 | 422.51 | 11326.0 |
| 2024-03-27 08:30:00 | MSFT | Stock | 422.52 | 423.575 | 422.52 | 423.4 | 3678.0 |
| 2024-03-27 09:00:00 | MSFT | Stock | 423.3 | 424.39 | 423.15 | 424.3 | 11283.0 |
| 2024-03-27 09:30:00 | MSFT | Stock | 424.44 | 424.45 | 421.89 | 422.4 | 920666.0 |
| 2024-03-27 10:00:00 | MSFT | Stock | 422.35 | 422.5099 | 420.2735 | 420.8058 | 907216.0 |
| 2024-03-27 10:30:00 | MSFT | Stock | 420.77 | 421.38 | 420.46 | 420.79 | 602704.0 |
| 2024-03-27 11:00:00 | MSFT | Stock | 420.79 | 420.97 | 419.64 | 419.69 | 531148.0 |
| 2024-03-27 11:30:00 | MSFT | Stock | 419.69 | 420.54 | 419.29 | 419.31 | 420016.0 |
| 2024-03-27 12:00:00 | MSFT | Stock | 419.32 | 420.14 | 419.28 | 420.03 | 363175.0 |
| 2024-03-27 12:30:00 | MSFT | Stock | 420.05 | 420.47 | 419.68 | 420.2475 | 274210.0 |
> showing 50 of 100,177 rows — these rows as CSV