PREVIEW / stock_30min / 2023-05-22
file: by_date/stock_30min/2023/2023-05-22.parquet size: 2.1 MB rows: 101,914 symbols: 1,647
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-05-22 04:00:00 | AAPL | Stock | 175.25 | 175.44 | 175.22 | 175.41 | 11569.0 |
| 2023-05-22 04:30:00 | AAPL | Stock | 175.36 | 175.46 | 175.27 | 175.3 | 2808.0 |
| 2023-05-22 05:00:00 | AAPL | Stock | 175.27 | 175.3 | 175.14 | 175.15 | 11428.0 |
| 2023-05-22 05:30:00 | AAPL | Stock | 175.18 | 175.27 | 172.87 | 173.31 | 93098.0 |
| 2023-05-22 06:00:00 | AAPL | Stock | 173.31 | 173.6 | 172.6 | 173.26 | 73888.0 |
| 2023-05-22 06:30:00 | AAPL | Stock | 173.33 | 173.7 | 173.25 | 173.5 | 45841.0 |
| 2023-05-22 07:00:00 | AAPL | Stock | 173.5 | 173.75 | 173.25 | 173.25 | 109979.0 |
| 2023-05-22 07:30:00 | AAPL | Stock | 173.25 | 173.5 | 173.24 | 173.42 | 23171.0 |
| 2023-05-22 08:00:00 | AAPL | Stock | 173.4998 | 175.16 | 173.22 | 173.57 | 124059.0 |
| 2023-05-22 08:30:00 | AAPL | Stock | 173.53 | 173.84 | 173.33 | 173.56 | 151155.0 |
| 2023-05-22 09:00:00 | AAPL | Stock | 173.56 | 174.0 | 173.42 | 173.96 | 159131.0 |
| 2023-05-22 09:30:00 | AAPL | Stock | 173.96 | 174.71 | 173.65 | 174.0199 | 5800203.0 |
| 2023-05-22 10:00:00 | AAPL | Stock | 174.015 | 174.38 | 173.45 | 174.192 | 3735388.0 |
| 2023-05-22 10:30:00 | AAPL | Stock | 174.2 | 174.2797 | 173.6 | 173.905 | 2295712.0 |
| 2023-05-22 11:00:00 | AAPL | Stock | 173.905 | 174.6 | 173.83 | 174.4888 | 2135704.0 |
| 2023-05-22 11:30:00 | AAPL | Stock | 174.48 | 174.55 | 174.1001 | 174.3391 | 1786704.0 |
| 2023-05-22 12:00:00 | AAPL | Stock | 174.335 | 174.45 | 173.93 | 174.16 | 1708944.0 |
| 2023-05-22 12:30:00 | AAPL | Stock | 174.145 | 174.2864 | 173.91 | 174.21 | 1490738.0 |
| 2023-05-22 13:00:00 | AAPL | Stock | 174.22 | 174.39 | 173.87 | 174.22 | 1658905.0 |
| 2023-05-22 13:30:00 | AAPL | Stock | 174.23 | 174.52 | 174.2 | 174.235 | 1228191.0 |
| 2023-05-22 14:00:00 | AAPL | Stock | 174.2399 | 174.32 | 174.09 | 174.32 | 1366191.0 |
| 2023-05-22 14:30:00 | AAPL | Stock | 174.32 | 174.62 | 174.245 | 174.375 | 1307058.0 |
| 2023-05-22 15:00:00 | AAPL | Stock | 174.37 | 174.4987 | 174.1 | 174.22 | 1894541.0 |
| 2023-05-22 15:30:00 | AAPL | Stock | 174.23 | 174.5 | 174.035 | 174.24 | 3583227.0 |
| 2023-05-22 16:00:00 | AAPL | Stock | 174.2 | 174.34 | 174.1 | 174.13 | 4309349.0 |
| 2023-05-22 16:30:00 | AAPL | Stock | 174.14 | 174.22 | 174.09 | 174.2 | 139530.0 |
| 2023-05-22 17:00:00 | AAPL | Stock | 174.19 | 174.21 | 174.13 | 174.2 | 14833.0 |
| 2023-05-22 17:30:00 | AAPL | Stock | 174.2 | 174.2381 | 174.13 | 174.15 | 6104.0 |
| 2023-05-22 18:00:00 | AAPL | Stock | 174.16 | 174.26 | 174.16 | 174.22 | 7505.0 |
| 2023-05-22 18:30:00 | AAPL | Stock | 174.22 | 174.3489 | 174.21 | 174.33 | 8154.0 |
| 2023-05-22 19:00:00 | AAPL | Stock | 174.36 | 174.71 | 174.3 | 174.65 | 24989.0 |
| 2023-05-22 19:30:00 | AAPL | Stock | 174.65 | 174.74 | 174.63 | 174.7 | 20427.0 |
| 2023-05-22 04:00:00 | MSFT | Stock | 318.45 | 318.84 | 318.42 | 318.67 | 3744.0 |
| 2023-05-22 04:30:00 | MSFT | Stock | 318.65 | 318.71 | 318.65 | 318.71 | 514.0 |
| 2023-05-22 05:00:00 | MSFT | Stock | 318.42 | 318.46 | 318.4 | 318.46 | 700.0 |
| 2023-05-22 05:30:00 | MSFT | Stock | 318.4 | 318.74 | 318.24 | 318.69 | 7198.0 |
| 2023-05-22 06:00:00 | MSFT | Stock | 318.4 | 318.75 | 318.2 | 318.2 | 3773.0 |
| 2023-05-22 06:30:00 | MSFT | Stock | 318.23 | 318.6 | 318.23 | 318.6 | 1820.0 |
| 2023-05-22 07:00:00 | MSFT | Stock | 318.28 | 318.28 | 317.85 | 318.2 | 4489.0 |
| 2023-05-22 07:30:00 | MSFT | Stock | 318.15 | 318.88 | 318.15 | 318.88 | 8557.0 |
| 2023-05-22 08:00:00 | MSFT | Stock | 318.45 | 319.29 | 317.8033 | 318.8 | 21446.0 |
| 2023-05-22 08:30:00 | MSFT | Stock | 318.77 | 319.22 | 318.51 | 318.7 | 13153.0 |
| 2023-05-22 09:00:00 | MSFT | Stock | 318.6427 | 318.9 | 318.39 | 318.53 | 19980.0 |
| 2023-05-22 09:30:00 | MSFT | Stock | 318.6 | 321.94 | 318.01 | 320.965 | 3168696.0 |
| 2023-05-22 10:00:00 | MSFT | Stock | 320.95 | 321.34 | 319.53 | 320.75 | 1543189.0 |
| 2023-05-22 10:30:00 | MSFT | Stock | 320.74 | 321.94 | 320.7119 | 321.85 | 1138223.0 |
| 2023-05-22 11:00:00 | MSFT | Stock | 321.87 | 322.59 | 321.23 | 321.43 | 1195797.0 |
| 2023-05-22 11:30:00 | MSFT | Stock | 321.42 | 321.58 | 320.54 | 320.68 | 763099.0 |
| 2023-05-22 12:00:00 | MSFT | Stock | 320.69 | 321.3201 | 320.44 | 320.51 | 697722.0 |
| 2023-05-22 12:30:00 | MSFT | Stock | 320.5 | 320.8 | 320.27 | 320.485 | 500274.0 |
> showing 50 of 101,914 rows — these rows as CSV