PREVIEW / stock_30min / 2024-04-26
file: by_date/stock_30min/2024/2024-04-26.parquet size: 2.0 MB rows: 95,704 symbols: 964
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-26 04:00:00 | AAPL | Stock | 169.99 | 170.19 | 169.99 | 170.0 | 8465.0 |
| 2024-04-26 04:30:00 | AAPL | Stock | 170.05 | 170.14 | 170.05 | 170.11 | 1642.0 |
| 2024-04-26 05:00:00 | AAPL | Stock | 170.05 | 170.17 | 170.0 | 170.17 | 3873.0 |
| 2024-04-26 05:30:00 | AAPL | Stock | 170.15 | 170.15 | 170.1 | 170.11 | 4464.0 |
| 2024-04-26 06:00:00 | AAPL | Stock | 170.15 | 170.21 | 170.11 | 170.21 | 1874.0 |
| 2024-04-26 06:30:00 | AAPL | Stock | 170.19 | 170.19 | 169.89 | 169.99 | 10281.0 |
| 2024-04-26 07:00:00 | AAPL | Stock | 170.0 | 170.1 | 169.89 | 169.92 | 12720.0 |
| 2024-04-26 07:30:00 | AAPL | Stock | 169.91 | 170.3 | 169.86 | 170.17 | 18325.0 |
| 2024-04-26 08:00:00 | AAPL | Stock | 169.99 | 170.48 | 169.8002 | 170.13 | 56545.0 |
| 2024-04-26 08:30:00 | AAPL | Stock | 170.23 | 170.98 | 170.04 | 170.5802 | 75228.0 |
| 2024-04-26 09:00:00 | AAPL | Stock | 170.67 | 170.85 | 169.75 | 169.9 | 91250.0 |
| 2024-04-26 09:30:00 | AAPL | Stock | 169.83 | 170.71 | 169.54 | 170.1 | 4396491.0 |
| 2024-04-26 10:00:00 | AAPL | Stock | 170.11 | 171.06 | 170.03 | 170.66 | 2780642.0 |
| 2024-04-26 10:30:00 | AAPL | Stock | 170.66 | 171.18 | 170.66 | 171.09 | 2154848.0 |
| 2024-04-26 11:00:00 | AAPL | Stock | 171.09 | 171.34 | 170.41 | 170.69 | 2065669.0 |
| 2024-04-26 11:30:00 | AAPL | Stock | 170.685 | 170.92 | 170.3832 | 170.52 | 1511027.0 |
| 2024-04-26 12:00:00 | AAPL | Stock | 170.52 | 170.53 | 170.21 | 170.245 | 1638980.0 |
| 2024-04-26 12:30:00 | AAPL | Stock | 170.25 | 170.26 | 169.93 | 170.0173 | 1954852.0 |
| 2024-04-26 13:00:00 | AAPL | Stock | 170.0162 | 170.1684 | 169.7601 | 169.875 | 1478760.0 |
| 2024-04-26 13:30:00 | AAPL | Stock | 169.88 | 169.89 | 169.37 | 169.475 | 1744622.0 |
| 2024-04-26 14:00:00 | AAPL | Stock | 169.48 | 169.7 | 169.37 | 169.7 | 1628451.0 |
| 2024-04-26 14:30:00 | AAPL | Stock | 169.7 | 170.02 | 169.52 | 170.015 | 1723489.0 |
| 2024-04-26 15:00:00 | AAPL | Stock | 170.01 | 170.11 | 169.8601 | 169.99 | 1435050.0 |
| 2024-04-26 15:30:00 | AAPL | Stock | 169.98 | 170.09 | 169.18 | 169.29 | 4888077.0 |
| 2024-04-26 16:00:00 | AAPL | Stock | 169.3 | 169.55 | 169.14 | 169.33 | 6325548.0 |
| 2024-04-26 16:30:00 | AAPL | Stock | 169.3 | 169.48 | 169.27 | 169.39 | 150883.0 |
| 2024-04-26 17:00:00 | AAPL | Stock | 169.43 | 169.45 | 169.39 | 169.4 | 10554.0 |
| 2024-04-26 17:30:00 | AAPL | Stock | 169.4299 | 169.49 | 169.33 | 169.43 | 9090.0 |
| 2024-04-26 18:00:00 | AAPL | Stock | 169.4219 | 170.0 | 169.3935 | 169.65 | 31528.0 |
| 2024-04-26 18:30:00 | AAPL | Stock | 169.58 | 169.89 | 169.5136 | 169.82 | 37525.0 |
| 2024-04-26 19:00:00 | AAPL | Stock | 169.82 | 169.85 | 169.6 | 169.85 | 9524.0 |
| 2024-04-26 19:30:00 | AAPL | Stock | 169.8 | 169.81 | 169.59 | 169.6 | 10234.0 |
| 2024-04-26 04:00:00 | MSFT | Stock | 415.6 | 418.0 | 413.0 | 413.0 | 22370.0 |
| 2024-04-26 04:30:00 | MSFT | Stock | 413.35 | 414.51 | 413.27 | 414.03 | 10629.0 |
| 2024-04-26 05:00:00 | MSFT | Stock | 414.03 | 414.25 | 414.0 | 414.04 | 6124.0 |
| 2024-04-26 05:30:00 | MSFT | Stock | 414.3 | 415.57 | 414.3 | 414.77 | 13707.0 |
| 2024-04-26 06:00:00 | MSFT | Stock | 414.98 | 415.32 | 414.98 | 415.06 | 1569.0 |
| 2024-04-26 06:30:00 | MSFT | Stock | 415.27 | 415.98 | 415.16 | 415.16 | 6072.0 |
| 2024-04-26 07:00:00 | MSFT | Stock | 415.4 | 416.78 | 415.4 | 416.6 | 20530.0 |
| 2024-04-26 07:30:00 | MSFT | Stock | 416.63 | 416.64 | 415.8 | 415.91 | 21375.0 |
| 2024-04-26 08:00:00 | MSFT | Stock | 416.0 | 417.55 | 413.8701 | 414.0 | 115834.0 |
| 2024-04-26 08:30:00 | MSFT | Stock | 414.15 | 416.47 | 412.47 | 413.68 | 143166.0 |
| 2024-04-26 09:00:00 | MSFT | Stock | 413.92 | 414.73 | 411.66 | 412.37 | 165694.0 |
| 2024-04-26 09:30:00 | MSFT | Stock | 412.1 | 413.0 | 405.7601 | 409.09 | 5229560.0 |
| 2024-04-26 10:00:00 | MSFT | Stock | 409.14 | 412.33 | 407.52 | 409.91 | 2222984.0 |
| 2024-04-26 10:30:00 | MSFT | Stock | 409.91 | 411.57 | 408.31 | 410.81 | 1475739.0 |
| 2024-04-26 11:00:00 | MSFT | Stock | 410.82 | 412.09 | 408.6 | 408.89 | 1153592.0 |
| 2024-04-26 11:30:00 | MSFT | Stock | 408.89 | 410.0 | 408.44 | 409.78 | 793858.0 |
| 2024-04-26 12:00:00 | MSFT | Stock | 409.74 | 410.11 | 408.3278 | 408.68 | 618693.0 |
| 2024-04-26 12:30:00 | MSFT | Stock | 408.68 | 409.56 | 408.145 | 409.56 | 595387.0 |
> showing 50 of 95,704 rows — these rows as CSV