PREVIEW / stock_30min / 2024-02-23
file: by_date/stock_30min/2024/2024-02-23.parquet size: 2.1 MB rows: 99,147 symbols: 1,121
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-02-23 04:00:00 | AAPL | Stock | 183.94 | 184.0 | 183.4 | 183.4 | 6721.0 |
| 2024-02-23 04:30:00 | AAPL | Stock | 183.47 | 183.76 | 183.47 | 183.76 | 4009.0 |
| 2024-02-23 05:00:00 | AAPL | Stock | 183.71 | 183.74 | 183.61 | 183.69 | 3432.0 |
| 2024-02-23 05:30:00 | AAPL | Stock | 183.67 | 183.85 | 183.67 | 183.85 | 433.0 |
| 2024-02-23 06:00:00 | AAPL | Stock | 183.85 | 183.92 | 183.84 | 183.92 | 3378.0 |
| 2024-02-23 06:30:00 | AAPL | Stock | 183.94 | 184.1 | 183.75 | 183.9 | 11992.0 |
| 2024-02-23 07:00:00 | AAPL | Stock | 183.9 | 184.05 | 183.8 | 184.05 | 5053.0 |
| 2024-02-23 07:30:00 | AAPL | Stock | 184.06 | 184.18 | 184.06 | 184.08 | 7264.0 |
| 2024-02-23 08:00:00 | AAPL | Stock | 183.8 | 184.327 | 183.78 | 184.3 | 39730.0 |
| 2024-02-23 08:30:00 | AAPL | Stock | 184.27 | 184.5 | 184.2 | 184.44 | 36088.0 |
| 2024-02-23 09:00:00 | AAPL | Stock | 184.47 | 185.35 | 184.41 | 185.0 | 129730.0 |
| 2024-02-23 09:30:00 | AAPL | Stock | 185.01 | 185.05 | 183.75 | 183.87 | 4149782.0 |
| 2024-02-23 10:00:00 | AAPL | Stock | 183.88 | 183.94 | 183.295 | 183.3 | 2660312.0 |
| 2024-02-23 10:30:00 | AAPL | Stock | 183.295 | 183.556 | 182.8 | 183.39 | 2405637.0 |
| 2024-02-23 11:00:00 | AAPL | Stock | 183.39 | 183.41 | 182.64 | 183.059 | 2126152.0 |
| 2024-02-23 11:30:00 | AAPL | Stock | 183.055 | 183.115 | 182.745 | 182.92 | 1655018.0 |
| 2024-02-23 12:00:00 | AAPL | Stock | 182.915 | 183.03 | 182.3901 | 182.56 | 1620092.0 |
| 2024-02-23 12:30:00 | AAPL | Stock | 182.555 | 182.85 | 182.31 | 182.8026 | 1534359.0 |
| 2024-02-23 13:00:00 | AAPL | Stock | 182.805 | 182.96 | 182.61 | 182.955 | 1565005.0 |
| 2024-02-23 13:30:00 | AAPL | Stock | 182.955 | 182.97 | 182.6 | 182.725 | 1180442.0 |
| 2024-02-23 14:00:00 | AAPL | Stock | 182.73 | 182.77 | 182.4303 | 182.47 | 1251424.0 |
| 2024-02-23 14:30:00 | AAPL | Stock | 182.48 | 182.695 | 182.45 | 182.615 | 1399488.0 |
| 2024-02-23 15:00:00 | AAPL | Stock | 182.61 | 182.695 | 182.44 | 182.585 | 1522238.0 |
| 2024-02-23 15:30:00 | AAPL | Stock | 182.59 | 182.82 | 182.23 | 182.52 | 4545455.0 |
| 2024-02-23 16:00:00 | AAPL | Stock | 182.45 | 182.9 | 182.35 | 182.52 | 5260008.0 |
| 2024-02-23 16:30:00 | AAPL | Stock | 182.52 | 182.59 | 182.46 | 182.57 | 100108.0 |
| 2024-02-23 17:00:00 | AAPL | Stock | 182.55 | 182.56 | 182.46 | 182.49 | 34548.0 |
| 2024-02-23 17:30:00 | AAPL | Stock | 182.5 | 182.51 | 182.36 | 182.36 | 12588.0 |
| 2024-02-23 18:00:00 | AAPL | Stock | 182.36 | 182.39 | 182.31 | 182.33 | 11126.0 |
| 2024-02-23 18:30:00 | AAPL | Stock | 182.32 | 182.33 | 182.31 | 182.33 | 11107.0 |
| 2024-02-23 19:00:00 | AAPL | Stock | 182.31 | 182.31 | 182.25 | 182.25 | 5927.0 |
| 2024-02-23 19:30:00 | AAPL | Stock | 182.25 | 182.35 | 182.23 | 182.28 | 10453.0 |
| 2024-02-23 04:00:00 | MSFT | Stock | 411.86 | 413.1 | 411.86 | 412.88 | 5269.0 |
| 2024-02-23 04:30:00 | MSFT | Stock | 412.53 | 412.66 | 412.44 | 412.66 | 2301.0 |
| 2024-02-23 05:00:00 | MSFT | Stock | 412.66 | 412.66 | 412.5 | 412.62 | 2519.0 |
| 2024-02-23 05:30:00 | MSFT | Stock | 412.84 | 412.92 | 412.84 | 412.92 | 5408.0 |
| 2024-02-23 06:00:00 | MSFT | Stock | 412.92 | 413.31 | 412.86 | 413.31 | 2428.0 |
| 2024-02-23 06:30:00 | MSFT | Stock | 413.47 | 414.3 | 413.09 | 414.19 | 3896.0 |
| 2024-02-23 07:00:00 | MSFT | Stock | 413.86 | 413.91 | 412.94 | 413.43 | 4937.0 |
| 2024-02-23 07:30:00 | MSFT | Stock | 413.6 | 413.88 | 413.3 | 413.3 | 4166.0 |
| 2024-02-23 08:00:00 | MSFT | Stock | 413.81 | 413.9498 | 412.08 | 413.9 | 21944.0 |
| 2024-02-23 08:30:00 | MSFT | Stock | 413.85 | 414.79 | 413.8 | 414.41 | 27395.0 |
| 2024-02-23 09:00:00 | MSFT | Stock | 414.5 | 415.75 | 414.4002 | 415.69 | 45743.0 |
| 2024-02-23 09:30:00 | MSFT | Stock | 415.61 | 415.86 | 413.42 | 414.26 | 1875766.0 |
| 2024-02-23 10:00:00 | MSFT | Stock | 414.3 | 414.31 | 412.31 | 412.98 | 876417.0 |
| 2024-02-23 10:30:00 | MSFT | Stock | 412.99 | 412.99 | 411.29 | 411.46 | 695628.0 |
| 2024-02-23 11:00:00 | MSFT | Stock | 411.4 | 411.5405 | 410.09 | 410.73 | 595947.0 |
| 2024-02-23 11:30:00 | MSFT | Stock | 410.77 | 410.86 | 409.29 | 410.24 | 465387.0 |
| 2024-02-23 12:00:00 | MSFT | Stock | 410.22 | 410.415 | 409.0501 | 409.46 | 386069.0 |
| 2024-02-23 12:30:00 | MSFT | Stock | 409.455 | 409.905 | 408.97 | 409.78 | 347073.0 |
> showing 50 of 99,147 rows — these rows as CSV