PREVIEW / stock_30min / 2023-05-08
file: by_date/stock_30min/2023/2023-05-08.parquet size: 2.1 MB rows: 101,636 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-08 04:00:00 | AAPL | Stock | 173.1 | 173.57 | 173.1 | 173.35 | 14809.0 |
| 2023-05-08 04:30:00 | AAPL | Stock | 173.35 | 173.42 | 173.32 | 173.42 | 4302.0 |
| 2023-05-08 05:00:00 | AAPL | Stock | 173.41 | 173.43 | 173.3 | 173.3 | 3078.0 |
| 2023-05-08 05:30:00 | AAPL | Stock | 173.33 | 173.48 | 173.31 | 173.47 | 4209.0 |
| 2023-05-08 06:00:00 | AAPL | Stock | 173.47 | 173.47 | 173.38 | 173.41 | 1060.0 |
| 2023-05-08 06:30:00 | AAPL | Stock | 173.48 | 173.54 | 173.1 | 173.23 | 19617.0 |
| 2023-05-08 07:00:00 | AAPL | Stock | 173.2 | 173.45 | 173.13 | 173.25 | 28999.0 |
| 2023-05-08 07:30:00 | AAPL | Stock | 173.24 | 173.34 | 173.1 | 173.16 | 28869.0 |
| 2023-05-08 08:00:00 | AAPL | Stock | 173.27 | 173.46 | 172.88 | 173.12 | 117806.0 |
| 2023-05-08 08:30:00 | AAPL | Stock | 173.14 | 173.22 | 172.76 | 172.9 | 137038.0 |
| 2023-05-08 09:00:00 | AAPL | Stock | 172.89 | 173.0684 | 172.26 | 172.52 | 303336.0 |
| 2023-05-08 09:30:00 | AAPL | Stock | 172.48 | 173.57 | 172.11 | 172.784 | 9028553.0 |
| 2023-05-08 10:00:00 | AAPL | Stock | 172.795 | 173.82 | 172.74 | 173.37 | 5316107.0 |
| 2023-05-08 10:30:00 | AAPL | Stock | 173.375 | 173.59 | 172.7201 | 173.47 | 4036506.0 |
| 2023-05-08 11:00:00 | AAPL | Stock | 173.48 | 173.63 | 173.15 | 173.2206 | 2315133.0 |
| 2023-05-08 11:30:00 | AAPL | Stock | 173.23 | 173.768 | 173.15 | 173.76 | 2194081.0 |
| 2023-05-08 12:00:00 | AAPL | Stock | 173.77 | 173.82 | 173.5 | 173.745 | 1782754.0 |
| 2023-05-08 12:30:00 | AAPL | Stock | 173.75 | 173.77 | 173.41 | 173.44 | 1592188.0 |
| 2023-05-08 13:00:00 | AAPL | Stock | 173.45 | 173.65 | 173.35 | 173.63 | 1432996.0 |
| 2023-05-08 13:30:00 | AAPL | Stock | 173.64 | 173.85 | 173.62 | 173.705 | 1515748.0 |
| 2023-05-08 14:00:00 | AAPL | Stock | 173.7 | 173.74 | 172.96 | 173.5999 | 2536840.0 |
| 2023-05-08 14:30:00 | AAPL | Stock | 173.595 | 173.8 | 173.47 | 173.725 | 1661222.0 |
| 2023-05-08 15:00:00 | AAPL | Stock | 173.725 | 173.78 | 173.21 | 173.405 | 1900406.0 |
| 2023-05-08 15:30:00 | AAPL | Stock | 173.4 | 173.68 | 173.37 | 173.52 | 3084783.0 |
| 2023-05-08 16:00:00 | AAPL | Stock | 173.52 | 173.53 | 173.3 | 173.39 | 4385247.0 |
| 2023-05-08 16:30:00 | AAPL | Stock | 173.36 | 173.5 | 173.32 | 173.35 | 109501.0 |
| 2023-05-08 17:00:00 | AAPL | Stock | 173.35 | 173.5 | 173.35 | 173.38 | 1010182.0 |
| 2023-05-08 17:30:00 | AAPL | Stock | 173.38 | 173.41 | 173.38 | 173.4 | 4694.0 |
| 2023-05-08 18:00:00 | AAPL | Stock | 173.38 | 173.38 | 173.2622 | 173.28 | 11704.0 |
| 2023-05-08 18:30:00 | AAPL | Stock | 173.3 | 173.36 | 173.3 | 173.36 | 6514.0 |
| 2023-05-08 19:00:00 | AAPL | Stock | 173.36 | 173.43 | 173.32 | 173.32 | 2745.0 |
| 2023-05-08 19:30:00 | AAPL | Stock | 173.32 | 173.38 | 173.25 | 173.28 | 8423.0 |
| 2023-05-08 04:00:00 | MSFT | Stock | 310.11 | 310.11 | 309.8 | 309.8 | 1107.0 |
| 2023-05-08 04:30:00 | MSFT | Stock | 310.2 | 310.21 | 310.19 | 310.19 | 1098.0 |
| 2023-05-08 05:30:00 | MSFT | Stock | 310.21 | 310.21 | 310.21 | 310.21 | 404.0 |
| 2023-05-08 06:00:00 | MSFT | Stock | 310.24 | 310.25 | 310.24 | 310.25 | 200.0 |
| 2023-05-08 06:30:00 | MSFT | Stock | 310.34 | 310.34 | 310.2 | 310.21 | 1767.0 |
| 2023-05-08 07:00:00 | MSFT | Stock | 310.26 | 310.46 | 310.12 | 310.12 | 4818.0 |
| 2023-05-08 07:30:00 | MSFT | Stock | 310.17 | 310.2 | 309.6 | 309.75 | 7217.0 |
| 2023-05-08 08:00:00 | MSFT | Stock | 310.21 | 310.5 | 309.48 | 309.75 | 29797.0 |
| 2023-05-08 08:30:00 | MSFT | Stock | 309.7 | 309.7 | 309.0 | 309.45 | 43079.0 |
| 2023-05-08 09:00:00 | MSFT | Stock | 309.21 | 310.12 | 309.21 | 310.12 | 47206.0 |
| 2023-05-08 09:30:00 | MSFT | Stock | 310.12 | 310.2 | 308.24 | 308.38 | 2371149.0 |
| 2023-05-08 10:00:00 | MSFT | Stock | 308.42 | 308.755 | 307.82 | 308.14 | 1273635.0 |
| 2023-05-08 10:30:00 | MSFT | Stock | 308.14 | 308.15 | 307.07 | 307.475 | 1246805.0 |
| 2023-05-08 11:00:00 | MSFT | Stock | 307.475 | 308.02 | 307.44 | 307.56 | 986539.0 |
| 2023-05-08 11:30:00 | MSFT | Stock | 307.55 | 308.03 | 307.0 | 307.46 | 986359.0 |
| 2023-05-08 12:00:00 | MSFT | Stock | 307.475 | 307.69 | 306.67 | 306.94 | 906067.0 |
| 2023-05-08 12:30:00 | MSFT | Stock | 306.95 | 307.6 | 306.7501 | 307.3335 | 763042.0 |
| 2023-05-08 13:00:00 | MSFT | Stock | 307.36 | 307.75 | 307.03 | 307.33 | 545259.0 |
> showing 50 of 101,636 rows — these rows as CSV