PREVIEW / stock_30min / 2023-04-10
file: by_date/stock_30min/2023/2023-04-10.parquet size: 2.0 MB rows: 99,554 symbols: 1,695
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-04-10 04:00:00 | AAPL | Stock | 164.49 | 164.49 | 163.59 | 163.61 | 9702.0 |
| 2023-04-10 04:30:00 | AAPL | Stock | 163.61 | 163.8 | 163.56 | 163.75 | 4586.0 |
| 2023-04-10 05:00:00 | AAPL | Stock | 163.77 | 163.8 | 163.57 | 163.68 | 2570.0 |
| 2023-04-10 05:30:00 | AAPL | Stock | 163.76 | 163.97 | 163.76 | 163.8 | 10105.0 |
| 2023-04-10 06:00:00 | AAPL | Stock | 163.8 | 163.98 | 163.68 | 163.78 | 4383.0 |
| 2023-04-10 06:30:00 | AAPL | Stock | 163.85 | 163.85 | 163.23 | 163.32 | 13084.0 |
| 2023-04-10 07:00:00 | AAPL | Stock | 163.6 | 163.64 | 163.1 | 163.17 | 25296.0 |
| 2023-04-10 07:30:00 | AAPL | Stock | 163.12 | 163.12 | 162.5 | 162.75 | 38030.0 |
| 2023-04-10 08:00:00 | AAPL | Stock | 163.35 | 163.75 | 162.33 | 162.4 | 149623.0 |
| 2023-04-10 08:30:00 | AAPL | Stock | 162.46 | 162.64 | 162.4 | 162.55 | 74330.0 |
| 2023-04-10 09:00:00 | AAPL | Stock | 162.55 | 162.61 | 161.2 | 161.39 | 248214.0 |
| 2023-04-10 09:30:00 | AAPL | Stock | 161.39 | 162.0 | 160.08 | 160.4712 | 8301050.0 |
| 2023-04-10 10:00:00 | AAPL | Stock | 160.47 | 160.73 | 160.09 | 160.155 | 3644165.0 |
| 2023-04-10 10:30:00 | AAPL | Stock | 160.16 | 160.82 | 160.145 | 160.545 | 2698191.0 |
| 2023-04-10 11:00:00 | AAPL | Stock | 160.545 | 161.4 | 160.53 | 161.135 | 2761376.0 |
| 2023-04-10 11:30:00 | AAPL | Stock | 161.1408 | 161.61 | 161.07 | 161.1008 | 1970453.0 |
| 2023-04-10 12:00:00 | AAPL | Stock | 161.1 | 161.1492 | 160.6 | 160.8208 | 1757927.0 |
| 2023-04-10 12:30:00 | AAPL | Stock | 160.83 | 161.6131 | 160.82 | 161.4 | 2005948.0 |
| 2023-04-10 13:00:00 | AAPL | Stock | 161.41 | 161.575 | 161.1701 | 161.5699 | 1667534.0 |
| 2023-04-10 13:30:00 | AAPL | Stock | 161.57 | 161.63 | 161.31 | 161.435 | 1405441.0 |
| 2023-04-10 14:00:00 | AAPL | Stock | 161.44 | 161.84 | 161.34 | 161.715 | 1553095.0 |
| 2023-04-10 14:30:00 | AAPL | Stock | 161.72 | 161.77 | 161.43 | 161.72 | 1375036.0 |
| 2023-04-10 15:00:00 | AAPL | Stock | 161.73 | 161.799 | 161.5 | 161.5892 | 1719803.0 |
| 2023-04-10 15:30:00 | AAPL | Stock | 161.59 | 162.03 | 161.55 | 162.025 | 4214952.0 |
| 2023-04-10 16:00:00 | AAPL | Stock | 162.02 | 162.09 | 161.93 | 162.09 | 4152612.0 |
| 2023-04-10 16:30:00 | AAPL | Stock | 162.13 | 162.19 | 162.03 | 162.06 | 106549.0 |
| 2023-04-10 17:00:00 | AAPL | Stock | 162.0428 | 162.1 | 161.95 | 161.95 | 24435.0 |
| 2023-04-10 17:30:00 | AAPL | Stock | 161.96 | 161.98 | 161.91 | 161.93 | 4939.0 |
| 2023-04-10 18:00:00 | AAPL | Stock | 161.91 | 162.05 | 161.91 | 162.05 | 9054.0 |
| 2023-04-10 18:30:00 | AAPL | Stock | 162.07 | 162.099 | 162.01 | 162.01 | 12079.0 |
| 2023-04-10 19:00:00 | AAPL | Stock | 162.01 | 162.06 | 162.01 | 162.02 | 4767.0 |
| 2023-04-10 19:30:00 | AAPL | Stock | 162.04 | 162.2 | 162.02 | 162.2 | 11240.0 |
| 2023-04-10 04:00:00 | MSFT | Stock | 291.06 | 291.06 | 290.7 | 290.81 | 5323.0 |
| 2023-04-10 04:30:00 | MSFT | Stock | 290.8 | 291.3 | 290.8 | 291.0 | 1695.0 |
| 2023-04-10 05:00:00 | MSFT | Stock | 291.23 | 291.3 | 291.16 | 291.3 | 543.0 |
| 2023-04-10 05:30:00 | MSFT | Stock | 291.32 | 291.32 | 291.32 | 291.32 | 422.0 |
| 2023-04-10 06:00:00 | MSFT | Stock | 291.4 | 291.5 | 291.4 | 291.41 | 1225.0 |
| 2023-04-10 06:30:00 | MSFT | Stock | 291.41 | 291.85 | 291.3 | 291.43 | 8844.0 |
| 2023-04-10 07:00:00 | MSFT | Stock | 291.46 | 291.46 | 290.1 | 290.1 | 9605.0 |
| 2023-04-10 07:30:00 | MSFT | Stock | 290.2 | 290.65 | 290.0 | 290.65 | 4611.0 |
| 2023-04-10 08:00:00 | MSFT | Stock | 291.2 | 291.5 | 289.01 | 289.71 | 66094.0 |
| 2023-04-10 08:30:00 | MSFT | Stock | 289.63 | 290.2947 | 289.45 | 289.72 | 28813.0 |
| 2023-04-10 09:00:00 | MSFT | Stock | 289.69 | 290.0 | 288.67 | 289.08 | 65022.0 |
| 2023-04-10 09:30:00 | MSFT | Stock | 289.13 | 289.28 | 285.11 | 285.49 | 3231814.0 |
| 2023-04-10 10:00:00 | MSFT | Stock | 285.51 | 286.41 | 284.71 | 285.89 | 2044979.0 |
| 2023-04-10 10:30:00 | MSFT | Stock | 285.9 | 287.13 | 285.8 | 286.3 | 1262389.0 |
| 2023-04-10 11:00:00 | MSFT | Stock | 286.32 | 287.94 | 286.29 | 287.23 | 1161499.0 |
| 2023-04-10 11:30:00 | MSFT | Stock | 287.24 | 287.94 | 286.9292 | 286.9329 | 832029.0 |
| 2023-04-10 12:00:00 | MSFT | Stock | 286.95 | 286.96 | 285.93 | 286.71 | 764753.0 |
| 2023-04-10 12:30:00 | MSFT | Stock | 286.73 | 288.59 | 286.69 | 288.285 | 877921.0 |
> showing 50 of 99,554 rows — these rows as CSV