PREVIEW / stock_30min / 2024-08-26
file: by_date/stock_30min/2024/2024-08-26.parquet size: 2.0 MB rows: 99,227 symbols: 874
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-08-26 04:00:00 | AAPL | Stock | 226.75 | 227.34 | 226.75 | 227.21 | 7415.0 |
| 2024-08-26 04:30:00 | AAPL | Stock | 227.34 | 227.38 | 227.25 | 227.31 | 927.0 |
| 2024-08-26 05:00:00 | AAPL | Stock | 227.39 | 227.5 | 227.39 | 227.5 | 3616.0 |
| 2024-08-26 05:30:00 | AAPL | Stock | 227.53 | 227.53 | 227.35 | 227.43 | 1050.0 |
| 2024-08-26 06:00:00 | AAPL | Stock | 227.44 | 227.49 | 227.4 | 227.47 | 1328.0 |
| 2024-08-26 06:30:00 | AAPL | Stock | 227.34 | 227.34 | 227.24 | 227.25 | 1336.0 |
| 2024-08-26 07:00:00 | AAPL | Stock | 227.24 | 227.35 | 227.08 | 227.13 | 8081.0 |
| 2024-08-26 07:30:00 | AAPL | Stock | 227.04 | 227.04 | 226.0 | 226.64 | 10310.0 |
| 2024-08-26 08:00:00 | AAPL | Stock | 227.3 | 227.36 | 226.273 | 226.94 | 40950.0 |
| 2024-08-26 08:30:00 | AAPL | Stock | 226.9 | 227.0 | 226.52 | 227.0 | 20511.0 |
| 2024-08-26 09:00:00 | AAPL | Stock | 227.04 | 227.06 | 226.3 | 226.78 | 63475.0 |
| 2024-08-26 09:30:00 | AAPL | Stock | 226.76 | 227.22 | 226.03 | 226.34 | 2460598.0 |
| 2024-08-26 10:00:00 | AAPL | Stock | 226.35 | 226.72 | 224.47 | 224.95 | 2006123.0 |
| 2024-08-26 10:30:00 | AAPL | Stock | 224.93 | 224.93 | 223.8905 | 224.82 | 1754768.0 |
| 2024-08-26 11:00:00 | AAPL | Stock | 224.8066 | 225.21 | 224.54 | 225.07 | 1122624.0 |
| 2024-08-26 11:30:00 | AAPL | Stock | 225.07 | 225.4 | 224.74 | 224.87 | 924815.0 |
| 2024-08-26 12:00:00 | AAPL | Stock | 224.84 | 225.82 | 224.64 | 225.8105 | 883989.0 |
| 2024-08-26 12:30:00 | AAPL | Stock | 225.8 | 226.24 | 225.75 | 226.185 | 760312.0 |
| 2024-08-26 13:00:00 | AAPL | Stock | 226.1887 | 226.4 | 225.95 | 226.12 | 835722.0 |
| 2024-08-26 13:30:00 | AAPL | Stock | 226.13 | 226.425 | 225.443 | 225.6 | 858262.0 |
| 2024-08-26 14:00:00 | AAPL | Stock | 225.61 | 225.93 | 225.46 | 225.87 | 770247.0 |
| 2024-08-26 14:30:00 | AAPL | Stock | 225.86 | 226.34 | 225.7601 | 226.325 | 750199.0 |
| 2024-08-26 15:00:00 | AAPL | Stock | 226.32 | 226.67 | 226.115 | 226.4301 | 1084418.0 |
| 2024-08-26 15:30:00 | AAPL | Stock | 226.43 | 227.28 | 226.29 | 227.22 | 2824777.0 |
| 2024-08-26 16:00:00 | AAPL | Stock | 227.18 | 227.21 | 226.82 | 226.82 | 3182917.0 |
| 2024-08-26 16:30:00 | AAPL | Stock | 226.82 | 227.18 | 223.3 | 225.67 | 372761.0 |
| 2024-08-26 17:00:00 | AAPL | Stock | 225.71 | 226.32 | 225.5 | 225.8 | 49829.0 |
| 2024-08-26 17:30:00 | AAPL | Stock | 225.8001 | 226.17 | 225.8 | 226.1 | 20921.0 |
| 2024-08-26 18:00:00 | AAPL | Stock | 226.08 | 226.14 | 225.51 | 225.75 | 14719.0 |
| 2024-08-26 18:30:00 | AAPL | Stock | 225.77 | 225.98 | 225.6117 | 225.97 | 13701.0 |
| 2024-08-26 19:00:00 | AAPL | Stock | 225.9 | 226.35 | 225.86 | 226.35 | 10515.0 |
| 2024-08-26 19:30:00 | AAPL | Stock | 226.3 | 226.5 | 226.07 | 226.5 | 12223.0 |
| 2024-08-26 04:00:00 | MSFT | Stock | 417.17 | 417.44 | 417.12 | 417.12 | 1653.0 |
| 2024-08-26 04:30:00 | MSFT | Stock | 417.23 | 417.44 | 417.16 | 417.43 | 2324.0 |
| 2024-08-26 05:00:00 | MSFT | Stock | 417.29 | 417.43 | 417.12 | 417.43 | 998.0 |
| 2024-08-26 05:30:00 | MSFT | Stock | 417.3 | 417.4 | 417.3 | 417.4 | 470.0 |
| 2024-08-26 06:30:00 | MSFT | Stock | 417.47 | 417.48 | 417.2 | 417.2 | 1304.0 |
| 2024-08-26 07:00:00 | MSFT | Stock | 417.12 | 417.17 | 416.5 | 416.5 | 1585.0 |
| 2024-08-26 07:30:00 | MSFT | Stock | 416.33 | 416.48 | 416.29 | 416.29 | 2439.0 |
| 2024-08-26 08:00:00 | MSFT | Stock | 416.59 | 417.2869 | 415.77 | 415.98 | 15117.0 |
| 2024-08-26 08:30:00 | MSFT | Stock | 415.8 | 416.09 | 415.6 | 416.02 | 5786.0 |
| 2024-08-26 09:00:00 | MSFT | Stock | 416.0 | 416.7835 | 415.6 | 416.7835 | 9592.0 |
| 2024-08-26 09:30:00 | MSFT | Stock | 416.69 | 417.2799 | 414.68 | 415.64 | 843995.0 |
| 2024-08-26 10:00:00 | MSFT | Stock | 415.73 | 416.0512 | 413.82 | 414.2 | 553528.0 |
| 2024-08-26 10:30:00 | MSFT | Stock | 414.175 | 414.2 | 412.14 | 414.04 | 404500.0 |
| 2024-08-26 11:00:00 | MSFT | Stock | 414.05 | 415.14 | 413.46 | 414.57 | 365688.0 |
| 2024-08-26 11:30:00 | MSFT | Stock | 414.56 | 414.58 | 413.08 | 413.24 | 319261.0 |
| 2024-08-26 12:00:00 | MSFT | Stock | 413.21 | 414.27 | 412.995 | 413.98 | 245275.0 |
| 2024-08-26 12:30:00 | MSFT | Stock | 413.98 | 414.35 | 413.62 | 413.9 | 172747.0 |
| 2024-08-26 13:00:00 | MSFT | Stock | 413.93 | 414.14 | 413.24 | 413.45 | 231461.0 |
> showing 50 of 99,227 rows — these rows as CSV