PREVIEW / stock_30min / 2024-04-22
file: by_date/stock_30min/2024/2024-04-22.parquet size: 2.0 MB rows: 97,242 symbols: 978
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-04-22 04:00:00 | AAPL | Stock | 165.5 | 165.8 | 165.4 | 165.8 | 8465.0 |
| 2024-04-22 04:30:00 | AAPL | Stock | 165.6 | 165.67 | 165.58 | 165.59 | 4245.0 |
| 2024-04-22 05:00:00 | AAPL | Stock | 165.53 | 166.2 | 165.5 | 165.91 | 14171.0 |
| 2024-04-22 05:30:00 | AAPL | Stock | 165.87 | 166.0 | 165.8 | 166.0 | 2544.0 |
| 2024-04-22 06:00:00 | AAPL | Stock | 165.96 | 166.33 | 165.82 | 165.94 | 5219.0 |
| 2024-04-22 06:30:00 | AAPL | Stock | 165.85 | 165.87 | 165.5 | 165.51 | 9612.0 |
| 2024-04-22 07:00:00 | AAPL | Stock | 165.7 | 165.9 | 165.46 | 165.65 | 18785.0 |
| 2024-04-22 07:30:00 | AAPL | Stock | 165.5 | 165.92 | 165.5 | 165.81 | 48823.0 |
| 2024-04-22 08:00:00 | AAPL | Stock | 165.61 | 166.21 | 164.588 | 166.05 | 98202.0 |
| 2024-04-22 08:30:00 | AAPL | Stock | 166.05 | 166.36 | 165.9925 | 166.13 | 72334.0 |
| 2024-04-22 09:00:00 | AAPL | Stock | 166.13 | 166.19 | 165.3 | 165.57 | 115198.0 |
| 2024-04-22 09:30:00 | AAPL | Stock | 165.57 | 166.23 | 165.32 | 165.835 | 4901042.0 |
| 2024-04-22 10:00:00 | AAPL | Stock | 165.84 | 166.03 | 165.225 | 165.37 | 2672491.0 |
| 2024-04-22 10:30:00 | AAPL | Stock | 165.37 | 165.54 | 165.1 | 165.2254 | 1679467.0 |
| 2024-04-22 11:00:00 | AAPL | Stock | 165.22 | 165.48 | 164.77 | 165.395 | 2245191.0 |
| 2024-04-22 11:30:00 | AAPL | Stock | 165.4 | 165.7 | 165.3748 | 165.655 | 1688548.0 |
| 2024-04-22 12:00:00 | AAPL | Stock | 165.6624 | 165.87 | 165.505 | 165.62 | 1752906.0 |
| 2024-04-22 12:30:00 | AAPL | Stock | 165.6142 | 165.84 | 165.43 | 165.81 | 1244802.0 |
| 2024-04-22 13:00:00 | AAPL | Stock | 165.82 | 166.29 | 165.8 | 166.275 | 1607859.0 |
| 2024-04-22 13:30:00 | AAPL | Stock | 166.28 | 167.26 | 166.27 | 167.19 | 2326824.0 |
| 2024-04-22 14:00:00 | AAPL | Stock | 167.185 | 167.25 | 166.85 | 166.855 | 1844955.0 |
| 2024-04-22 14:30:00 | AAPL | Stock | 166.86 | 167.05 | 166.255 | 166.6256 | 1811720.0 |
| 2024-04-22 15:00:00 | AAPL | Stock | 166.625 | 166.89 | 166.545 | 166.66 | 1526684.0 |
| 2024-04-22 15:30:00 | AAPL | Stock | 166.66 | 166.74 | 165.64 | 165.84 | 4161786.0 |
| 2024-04-22 16:00:00 | AAPL | Stock | 165.99 | 165.99 | 165.51 | 165.61 | 7338024.0 |
| 2024-04-22 16:30:00 | AAPL | Stock | 165.6 | 165.84 | 165.55 | 165.69 | 73617.0 |
| 2024-04-22 17:00:00 | AAPL | Stock | 165.71 | 165.94 | 165.64 | 165.94 | 22654.0 |
| 2024-04-22 17:30:00 | AAPL | Stock | 165.94 | 166.0786 | 165.93 | 166.05 | 11028.0 |
| 2024-04-22 18:00:00 | AAPL | Stock | 166.05 | 166.05 | 165.65 | 165.78 | 11924.0 |
| 2024-04-22 18:30:00 | AAPL | Stock | 165.7016 | 165.84 | 165.7 | 165.82 | 3522.0 |
| 2024-04-22 19:00:00 | AAPL | Stock | 165.8 | 165.84 | 165.56 | 165.62 | 10134.0 |
| 2024-04-22 19:30:00 | AAPL | Stock | 165.6498 | 165.81 | 165.6498 | 165.77 | 2457.0 |
| 2024-04-22 04:00:00 | MSFT | Stock | 400.0 | 400.5 | 396.85 | 400.5 | 4641.0 |
| 2024-04-22 04:30:00 | MSFT | Stock | 400.5 | 400.79 | 400.47 | 400.47 | 2362.0 |
| 2024-04-22 05:00:00 | MSFT | Stock | 400.6 | 400.67 | 400.56 | 400.67 | 2093.0 |
| 2024-04-22 05:30:00 | MSFT | Stock | 400.6 | 401.35 | 400.6 | 400.81 | 2804.0 |
| 2024-04-22 06:00:00 | MSFT | Stock | 401.0 | 401.37 | 401.0 | 401.34 | 1174.0 |
| 2024-04-22 06:30:00 | MSFT | Stock | 401.0 | 401.0 | 400.75 | 400.88 | 1445.0 |
| 2024-04-22 07:00:00 | MSFT | Stock | 400.81 | 400.81 | 400.0 | 400.0 | 7946.0 |
| 2024-04-22 07:30:00 | MSFT | Stock | 400.0 | 400.5 | 399.13 | 399.41 | 13663.0 |
| 2024-04-22 08:00:00 | MSFT | Stock | 400.22 | 401.34 | 397.97 | 398.15 | 43757.0 |
| 2024-04-22 08:30:00 | MSFT | Stock | 398.2 | 400.0 | 398.06 | 399.7201 | 27236.0 |
| 2024-04-22 09:00:00 | MSFT | Stock | 399.98 | 400.36 | 399.21 | 400.2 | 37562.0 |
| 2024-04-22 09:30:00 | MSFT | Stock | 400.08 | 402.5 | 398.37 | 399.51 | 1747748.0 |
| 2024-04-22 10:00:00 | MSFT | Stock | 399.66 | 401.29 | 397.6 | 397.765 | 1053218.0 |
| 2024-04-22 10:30:00 | MSFT | Stock | 397.78 | 398.72 | 396.67 | 396.92 | 669231.0 |
| 2024-04-22 11:00:00 | MSFT | Stock | 396.9 | 398.18 | 395.75 | 397.99 | 732599.0 |
| 2024-04-22 11:30:00 | MSFT | Stock | 398.02 | 398.93 | 397.9 | 398.83 | 460110.0 |
| 2024-04-22 12:00:00 | MSFT | Stock | 398.85 | 399.37 | 398.26 | 398.9865 | 442439.0 |
| 2024-04-22 12:30:00 | MSFT | Stock | 398.95 | 399.21 | 398.51 | 399.14 | 298568.0 |
> showing 50 of 97,242 rows — these rows as CSV