PREVIEW / stock_30min / 2024-02-22
file: by_date/stock_30min/2024/2024-02-22.parquet size: 2.1 MB rows: 102,086 symbols: 1,142
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-22 04:00:00 | AAPL | Stock | 183.8 | 183.98 | 183.35 | 183.42 | 20524.0 |
| 2024-02-22 04:30:00 | AAPL | Stock | 183.42 | 183.68 | 183.42 | 183.58 | 3632.0 |
| 2024-02-22 05:00:00 | AAPL | Stock | 183.54 | 183.54 | 183.03 | 183.1 | 12967.0 |
| 2024-02-22 05:30:00 | AAPL | Stock | 183.13 | 183.31 | 183.13 | 183.2 | 2441.0 |
| 2024-02-22 06:00:00 | AAPL | Stock | 183.19 | 183.75 | 183.13 | 183.63 | 8274.0 |
| 2024-02-22 06:30:00 | AAPL | Stock | 183.6 | 183.69 | 183.49 | 183.49 | 2264.0 |
| 2024-02-22 07:00:00 | AAPL | Stock | 183.32 | 183.54 | 183.2 | 183.34 | 39515.0 |
| 2024-02-22 07:30:00 | AAPL | Stock | 183.261 | 183.32 | 183.17 | 183.18 | 14218.0 |
| 2024-02-22 08:00:00 | AAPL | Stock | 183.42 | 184.11 | 182.9 | 183.08 | 121162.0 |
| 2024-02-22 08:30:00 | AAPL | Stock | 183.08 | 183.4 | 183.0 | 183.3787 | 53554.0 |
| 2024-02-22 09:00:00 | AAPL | Stock | 183.38 | 183.6 | 183.05 | 183.53 | 165011.0 |
| 2024-02-22 09:30:00 | AAPL | Stock | 183.55 | 184.19 | 182.524 | 183.13 | 5564759.0 |
| 2024-02-22 10:00:00 | AAPL | Stock | 183.13 | 183.49 | 182.7 | 183.055 | 3065952.0 |
| 2024-02-22 10:30:00 | AAPL | Stock | 183.06 | 183.2968 | 182.75 | 182.86 | 2076494.0 |
| 2024-02-22 11:00:00 | AAPL | Stock | 182.87 | 183.13 | 182.46 | 183.035 | 1912840.0 |
| 2024-02-22 11:30:00 | AAPL | Stock | 183.04 | 183.26 | 182.81 | 182.95 | 1599240.0 |
| 2024-02-22 12:00:00 | AAPL | Stock | 182.95 | 183.065 | 182.74 | 183.06 | 1352743.0 |
| 2024-02-22 12:30:00 | AAPL | Stock | 183.07 | 183.65 | 183.0 | 183.62 | 1948885.0 |
| 2024-02-22 13:00:00 | AAPL | Stock | 183.61 | 184.11 | 183.535 | 184.04 | 2153753.0 |
| 2024-02-22 13:30:00 | AAPL | Stock | 184.05 | 184.29 | 183.94 | 184.2175 | 1583623.0 |
| 2024-02-22 14:00:00 | AAPL | Stock | 184.21 | 184.95 | 184.19 | 184.94 | 2095049.0 |
| 2024-02-22 14:30:00 | AAPL | Stock | 184.94 | 184.955 | 184.39 | 184.545 | 1914295.0 |
| 2024-02-22 15:00:00 | AAPL | Stock | 184.55 | 184.85 | 184.445 | 184.56 | 2193708.0 |
| 2024-02-22 15:30:00 | AAPL | Stock | 184.5674 | 184.62 | 184.18 | 184.36 | 5208138.0 |
| 2024-02-22 16:00:00 | AAPL | Stock | 184.371 | 184.38 | 183.72 | 183.999 | 7150344.0 |
| 2024-02-22 16:30:00 | AAPL | Stock | 183.95 | 184.37 | 183.81 | 184.2 | 76186.0 |
| 2024-02-22 17:00:00 | AAPL | Stock | 184.2006 | 184.37 | 184.0 | 184.04 | 7999.0 |
| 2024-02-22 17:30:00 | AAPL | Stock | 184.01 | 184.0483 | 184.0 | 184.0 | 4216.0 |
| 2024-02-22 18:00:00 | AAPL | Stock | 184.0 | 184.28 | 184.0 | 184.11 | 8360.0 |
| 2024-02-22 18:30:00 | AAPL | Stock | 184.1701 | 184.31 | 184.1701 | 184.24 | 6080.0 |
| 2024-02-22 19:00:00 | AAPL | Stock | 184.15 | 184.18 | 184.06 | 184.1 | 1032.0 |
| 2024-02-22 19:30:00 | AAPL | Stock | 184.1 | 184.1 | 183.75 | 183.95 | 10562.0 |
| 2024-02-22 04:00:00 | MSFT | Stock | 408.4 | 408.4 | 406.2 | 406.89 | 13082.0 |
| 2024-02-22 04:30:00 | MSFT | Stock | 406.89 | 408.13 | 406.89 | 408.13 | 5070.0 |
| 2024-02-22 05:00:00 | MSFT | Stock | 408.0 | 408.97 | 407.9 | 408.55 | 7678.0 |
| 2024-02-22 05:30:00 | MSFT | Stock | 408.68 | 408.68 | 408.49 | 408.6 | 4955.0 |
| 2024-02-22 06:00:00 | MSFT | Stock | 408.54 | 409.43 | 408.54 | 409.41 | 3981.0 |
| 2024-02-22 06:30:00 | MSFT | Stock | 409.29 | 410.0 | 409.13 | 409.7 | 9708.0 |
| 2024-02-22 07:00:00 | MSFT | Stock | 409.5 | 409.7 | 408.75 | 409.39 | 40350.0 |
| 2024-02-22 07:30:00 | MSFT | Stock | 409.39 | 409.99 | 409.27 | 409.9 | 35970.0 |
| 2024-02-22 08:00:00 | MSFT | Stock | 409.35 | 410.72 | 407.115 | 410.2 | 106361.0 |
| 2024-02-22 08:30:00 | MSFT | Stock | 410.2 | 410.5 | 409.52 | 409.7 | 55007.0 |
| 2024-02-22 09:00:00 | MSFT | Stock | 409.8 | 410.25 | 409.1 | 410.17 | 40225.0 |
| 2024-02-22 09:30:00 | MSFT | Stock | 410.18 | 412.83 | 408.57 | 410.88 | 3962991.0 |
| 2024-02-22 10:00:00 | MSFT | Stock | 410.88 | 411.6 | 409.9 | 411.56 | 1373150.0 |
| 2024-02-22 10:30:00 | MSFT | Stock | 411.55 | 412.21 | 409.36 | 409.6 | 937113.0 |
| 2024-02-22 11:00:00 | MSFT | Stock | 409.62 | 410.39 | 409.31 | 409.76 | 604761.0 |
| 2024-02-22 11:30:00 | MSFT | Stock | 409.77 | 410.14 | 408.86 | 409.0 | 520698.0 |
| 2024-02-22 12:00:00 | MSFT | Stock | 409.0 | 409.7 | 408.64 | 409.55 | 454013.0 |
| 2024-02-22 12:30:00 | MSFT | Stock | 409.57 | 409.76 | 409.05 | 409.71 | 329415.0 |
> showing 50 of 102,086 rows — these rows as CSV