PREVIEW / stock_30min / 2022-06-15
file: by_date/stock_30min/2022/2022-06-15.parquet size: 2.1 MB rows: 106,165 symbols: 2,389
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-06-15 04:00:00 | AAPL | Stock | 133.46 | 133.76 | 133.3 | 133.76 | 33274.0 |
| 2022-06-15 04:30:00 | AAPL | Stock | 133.71 | 133.84 | 133.45 | 133.55 | 8887.0 |
| 2022-06-15 05:00:00 | AAPL | Stock | 133.5 | 133.5 | 133.26 | 133.34 | 5879.0 |
| 2022-06-15 05:30:00 | AAPL | Stock | 133.57 | 133.65 | 133.38 | 133.44 | 3460.0 |
| 2022-06-15 06:00:00 | AAPL | Stock | 133.5 | 133.5 | 133.34 | 133.34 | 3322.0 |
| 2022-06-15 06:30:00 | AAPL | Stock | 133.39 | 133.39 | 133.34 | 133.34 | 405.0 |
| 2022-06-15 07:00:00 | AAPL | Stock | 133.5 | 133.83 | 133.3 | 133.83 | 42252.0 |
| 2022-06-15 07:30:00 | AAPL | Stock | 133.8 | 134.21 | 133.7 | 134.17 | 62391.0 |
| 2022-06-15 08:00:00 | AAPL | Stock | 133.476 | 134.23 | 132.429 | 133.84 | 276252.0 |
| 2022-06-15 08:30:00 | AAPL | Stock | 133.84 | 134.55 | 133.6 | 134.33 | 285842.0 |
| 2022-06-15 09:00:00 | AAPL | Stock | 134.38 | 134.55 | 134.03 | 134.23 | 303336.0 |
| 2022-06-15 09:30:00 | AAPL | Stock | 134.22 | 134.74 | 133.67 | 134.2 | 8035910.0 |
| 2022-06-15 10:00:00 | AAPL | Stock | 134.22 | 134.6108 | 133.97 | 134.1565 | 5378695.0 |
| 2022-06-15 10:30:00 | AAPL | Stock | 134.2 | 134.25 | 133.38 | 133.82 | 4116067.0 |
| 2022-06-15 11:00:00 | AAPL | Stock | 133.81 | 134.14 | 133.61 | 134.07 | 3142596.0 |
| 2022-06-15 11:30:00 | AAPL | Stock | 134.08 | 134.485 | 133.95 | 134.42 | 2729297.0 |
| 2022-06-15 12:00:00 | AAPL | Stock | 134.425 | 134.88 | 134.37 | 134.66 | 2837471.0 |
| 2022-06-15 12:30:00 | AAPL | Stock | 134.65 | 134.7 | 133.52 | 133.615 | 2970814.0 |
| 2022-06-15 13:00:00 | AAPL | Stock | 133.62 | 134.3197 | 133.49 | 134.21 | 2833703.0 |
| 2022-06-15 13:30:00 | AAPL | Stock | 134.2194 | 134.5299 | 133.675 | 134.3899 | 2836833.0 |
| 2022-06-15 14:00:00 | AAPL | Stock | 134.36 | 135.28 | 132.25 | 133.11 | 7951010.0 |
| 2022-06-15 14:30:00 | AAPL | Stock | 133.11 | 136.49 | 132.16 | 134.865 | 9450328.0 |
| 2022-06-15 15:00:00 | AAPL | Stock | 134.88 | 136.68 | 134.66 | 136.5891 | 6525213.0 |
| 2022-06-15 15:30:00 | AAPL | Stock | 136.59 | 137.34 | 134.86 | 135.42 | 9959393.0 |
| 2022-06-15 16:00:00 | AAPL | Stock | 135.43 | 135.55 | 134.62 | 135.21 | 10170367.0 |
| 2022-06-15 16:30:00 | AAPL | Stock | 135.29 | 135.57 | 135.21 | 135.4 | 90519.0 |
| 2022-06-15 17:00:00 | AAPL | Stock | 135.45 | 135.65 | 135.44 | 135.64 | 33041.0 |
| 2022-06-15 17:30:00 | AAPL | Stock | 135.6 | 135.9 | 135.43 | 135.86 | 70924.0 |
| 2022-06-15 18:00:00 | AAPL | Stock | 135.86 | 136.25 | 135.75 | 136.25 | 61149.0 |
| 2022-06-15 18:30:00 | AAPL | Stock | 136.32 | 136.34 | 136.15 | 136.25 | 39330.0 |
| 2022-06-15 19:00:00 | AAPL | Stock | 136.21 | 136.28 | 136.04 | 136.1 | 24216.0 |
| 2022-06-15 19:30:00 | AAPL | Stock | 136.18 | 136.69 | 136.16 | 136.5 | 31801.0 |
| 2022-06-15 04:00:00 | MSFT | Stock | 246.21 | 246.4 | 245.93 | 246.2 | 4729.0 |
| 2022-06-15 04:30:00 | MSFT | Stock | 246.5 | 246.68 | 246.5 | 246.5 | 1067.0 |
| 2022-06-15 05:00:00 | MSFT | Stock | 246.37 | 246.37 | 246.02 | 246.1 | 4916.0 |
| 2022-06-15 05:30:00 | MSFT | Stock | 246.49 | 246.5 | 246.25 | 246.25 | 1681.0 |
| 2022-06-15 06:00:00 | MSFT | Stock | 246.11 | 246.25 | 246.0 | 246.0 | 2382.0 |
| 2022-06-15 07:00:00 | MSFT | Stock | 246.08 | 246.75 | 245.5 | 246.75 | 4836.0 |
| 2022-06-15 07:30:00 | MSFT | Stock | 246.83 | 247.5 | 246.53 | 247.5 | 5490.0 |
| 2022-06-15 08:00:00 | MSFT | Stock | 245.848 | 247.7 | 243.879 | 246.8 | 13456.0 |
| 2022-06-15 08:30:00 | MSFT | Stock | 246.8 | 248.38 | 246.5 | 247.8 | 31307.0 |
| 2022-06-15 09:00:00 | MSFT | Stock | 247.87 | 248.54 | 247.25 | 248.26 | 29246.0 |
| 2022-06-15 09:30:00 | MSFT | Stock | 248.3 | 250.79 | 247.44 | 249.48 | 2662443.0 |
| 2022-06-15 10:00:00 | MSFT | Stock | 249.51 | 250.1408 | 248.88 | 249.085 | 1307805.0 |
| 2022-06-15 10:30:00 | MSFT | Stock | 249.1 | 249.14 | 248.22 | 248.8 | 994263.0 |
| 2022-06-15 11:00:00 | MSFT | Stock | 248.8 | 249.45 | 248.081 | 248.86 | 704926.0 |
| 2022-06-15 11:30:00 | MSFT | Stock | 248.87 | 249.41 | 248.71 | 249.2 | 643529.0 |
| 2022-06-15 12:00:00 | MSFT | Stock | 249.21 | 250.61 | 249.04 | 250.22 | 777536.0 |
| 2022-06-15 12:30:00 | MSFT | Stock | 250.21 | 250.5 | 248.7 | 248.9 | 670588.0 |
| 2022-06-15 13:00:00 | MSFT | Stock | 248.91 | 250.18 | 248.84 | 250.04 | 635137.0 |
> showing 50 of 106,165 rows — these rows as CSV