PREVIEW / stock_30min / 2024-08-29
file: by_date/stock_30min/2024/2024-08-29.parquet size: 2.0 MB rows: 96,451 symbols: 819
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-29 04:00:00 | AAPL | Stock | 226.89 | 228.8 | 226.89 | 228.23 | 25096.0 |
| 2024-08-29 04:30:00 | AAPL | Stock | 228.35 | 228.77 | 228.34 | 228.77 | 7120.0 |
| 2024-08-29 05:00:00 | AAPL | Stock | 228.73 | 229.19 | 228.63 | 229.16 | 32377.0 |
| 2024-08-29 05:30:00 | AAPL | Stock | 229.16 | 229.38 | 228.78 | 229.21 | 14539.0 |
| 2024-08-29 06:00:00 | AAPL | Stock | 229.33 | 229.74 | 229.08 | 229.3 | 14997.0 |
| 2024-08-29 06:30:00 | AAPL | Stock | 229.34 | 229.4 | 228.9 | 229.25 | 17861.0 |
| 2024-08-29 07:00:00 | AAPL | Stock | 229.25 | 230.0 | 229.16 | 229.88 | 95678.0 |
| 2024-08-29 07:30:00 | AAPL | Stock | 229.86 | 230.39 | 229.84 | 229.98 | 89172.0 |
| 2024-08-29 08:00:00 | AAPL | Stock | 229.4 | 230.4179 | 226.87 | 230.18 | 213889.0 |
| 2024-08-29 08:30:00 | AAPL | Stock | 230.19 | 230.6 | 226.49 | 226.49 | 212781.0 |
| 2024-08-29 09:00:00 | AAPL | Stock | 230.37 | 230.4998 | 228.95 | 230.1 | 370999.0 |
| 2024-08-29 09:30:00 | AAPL | Stock | 230.1 | 231.66 | 228.88 | 231.57 | 7997255.0 |
| 2024-08-29 10:00:00 | AAPL | Stock | 231.58 | 231.94 | 230.31 | 231.42 | 2835533.0 |
| 2024-08-29 10:30:00 | AAPL | Stock | 231.42 | 232.7249 | 231.38 | 232.37 | 3652382.0 |
| 2024-08-29 11:00:00 | AAPL | Stock | 232.34 | 232.92 | 231.98 | 232.45 | 2317181.0 |
| 2024-08-29 11:30:00 | AAPL | Stock | 232.4476 | 232.7091 | 231.49 | 231.6799 | 1556652.0 |
| 2024-08-29 12:00:00 | AAPL | Stock | 231.67 | 232.56 | 231.6 | 232.45 | 1564846.0 |
| 2024-08-29 12:30:00 | AAPL | Stock | 232.45 | 232.71 | 232.0 | 232.54 | 1201102.0 |
| 2024-08-29 13:00:00 | AAPL | Stock | 232.53 | 232.58 | 231.87 | 232.135 | 1040388.0 |
| 2024-08-29 13:30:00 | AAPL | Stock | 232.13 | 232.51 | 231.34 | 231.74 | 1916235.0 |
| 2024-08-29 14:00:00 | AAPL | Stock | 231.75 | 231.75 | 230.55 | 230.845 | 1499429.0 |
| 2024-08-29 14:30:00 | AAPL | Stock | 230.83 | 230.97 | 229.85 | 230.45 | 2289129.0 |
| 2024-08-29 15:00:00 | AAPL | Stock | 230.43 | 230.75 | 229.6201 | 230.14 | 1752181.0 |
| 2024-08-29 15:30:00 | AAPL | Stock | 230.17 | 230.78 | 229.33 | 229.83 | 3533877.0 |
| 2024-08-29 16:00:00 | AAPL | Stock | 229.79 | 230.25 | 229.3 | 230.09 | 5375080.0 |
| 2024-08-29 16:30:00 | AAPL | Stock | 230.21 | 230.25 | 229.79 | 230.25 | 64640.0 |
| 2024-08-29 17:00:00 | AAPL | Stock | 230.24 | 230.29 | 229.79 | 230.24 | 216895.0 |
| 2024-08-29 17:30:00 | AAPL | Stock | 230.2395 | 230.3399 | 230.21 | 230.33 | 8211.0 |
| 2024-08-29 18:00:00 | AAPL | Stock | 230.33 | 230.33 | 229.88 | 230.0 | 33783.0 |
| 2024-08-29 18:30:00 | AAPL | Stock | 230.0006 | 230.12 | 229.9302 | 230.1 | 9995.0 |
| 2024-08-29 19:00:00 | AAPL | Stock | 230.0203 | 230.3 | 230.0 | 230.29 | 11108.0 |
| 2024-08-29 19:30:00 | AAPL | Stock | 230.18 | 230.29 | 230.15 | 230.29 | 7815.0 |
| 2024-08-29 04:00:00 | MSFT | Stock | 411.73 | 412.81 | 410.12 | 411.65 | 6006.0 |
| 2024-08-29 04:30:00 | MSFT | Stock | 412.01 | 412.57 | 412.01 | 412.56 | 6390.0 |
| 2024-08-29 05:00:00 | MSFT | Stock | 412.56 | 412.81 | 412.56 | 412.81 | 3462.0 |
| 2024-08-29 05:30:00 | MSFT | Stock | 412.95 | 413.4 | 412.76 | 413.31 | 1491.0 |
| 2024-08-29 06:00:00 | MSFT | Stock | 413.12 | 413.21 | 412.71 | 412.8 | 1823.0 |
| 2024-08-29 06:30:00 | MSFT | Stock | 412.45 | 412.66 | 412.45 | 412.66 | 540.0 |
| 2024-08-29 07:00:00 | MSFT | Stock | 412.45 | 413.45 | 412.45 | 413.08 | 4393.0 |
| 2024-08-29 07:30:00 | MSFT | Stock | 412.77 | 413.45 | 412.77 | 413.0 | 4334.0 |
| 2024-08-29 08:00:00 | MSFT | Stock | 412.46 | 413.56 | 410.42 | 413.36 | 22085.0 |
| 2024-08-29 08:30:00 | MSFT | Stock | 413.68 | 414.114 | 412.3 | 413.4159 | 14775.0 |
| 2024-08-29 09:00:00 | MSFT | Stock | 413.1 | 414.92 | 411.99 | 414.92 | 19843.0 |
| 2024-08-29 09:30:00 | MSFT | Stock | 414.94 | 421.75 | 414.495 | 421.01 | 1879824.0 |
| 2024-08-29 10:00:00 | MSFT | Stock | 421.01 | 422.05 | 418.82 | 419.7787 | 1094331.0 |
| 2024-08-29 10:30:00 | MSFT | Stock | 419.865 | 421.6496 | 410.6 | 420.14 | 603667.0 |
| 2024-08-29 11:00:00 | MSFT | Stock | 420.175 | 420.43 | 418.92 | 419.42 | 489436.0 |
| 2024-08-29 11:30:00 | MSFT | Stock | 419.385 | 419.97 | 418.57 | 419.1579 | 366054.0 |
| 2024-08-29 12:00:00 | MSFT | Stock | 419.12 | 420.03 | 419.0 | 419.32 | 282582.0 |
| 2024-08-29 12:30:00 | MSFT | Stock | 419.315 | 420.35 | 418.96 | 419.495 | 235125.0 |
> showing 50 of 96,451 rows — these rows as CSV