PREVIEW / stock_30min / 2024-02-27
file: by_date/stock_30min/2024/2024-02-27.parquet size: 2.1 MB rows: 102,094 symbols: 1,132
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-27 04:00:00 | AAPL | Stock | 180.6 | 181.16 | 180.6 | 181.16 | 7496.0 |
| 2024-02-27 04:30:00 | AAPL | Stock | 181.16 | 181.16 | 180.96 | 181.0 | 4607.0 |
| 2024-02-27 05:00:00 | AAPL | Stock | 181.0 | 181.15 | 181.0 | 181.02 | 4629.0 |
| 2024-02-27 05:30:00 | AAPL | Stock | 180.93 | 180.98 | 180.77 | 180.98 | 3683.0 |
| 2024-02-27 06:00:00 | AAPL | Stock | 180.91 | 180.91 | 180.89 | 180.91 | 3684.0 |
| 2024-02-27 06:30:00 | AAPL | Stock | 180.86 | 180.86 | 180.85 | 180.85 | 1737.0 |
| 2024-02-27 07:00:00 | AAPL | Stock | 180.82 | 181.03 | 180.81 | 181.01 | 9619.0 |
| 2024-02-27 07:30:00 | AAPL | Stock | 181.01 | 181.22 | 181.01 | 181.16 | 6392.0 |
| 2024-02-27 08:00:00 | AAPL | Stock | 180.89 | 181.25 | 180.8401 | 180.95 | 61513.0 |
| 2024-02-27 08:30:00 | AAPL | Stock | 180.95 | 181.16 | 180.85 | 181.12 | 34069.0 |
| 2024-02-27 09:00:00 | AAPL | Stock | 181.15 | 181.24 | 180.65 | 181.11 | 60552.0 |
| 2024-02-27 09:30:00 | AAPL | Stock | 181.09 | 181.54 | 180.3 | 180.93 | 4106830.0 |
| 2024-02-27 10:00:00 | AAPL | Stock | 180.93 | 181.67 | 180.715 | 181.17 | 2423469.0 |
| 2024-02-27 10:30:00 | AAPL | Stock | 181.1601 | 181.27 | 180.76 | 181.08 | 1684422.0 |
| 2024-02-27 11:00:00 | AAPL | Stock | 181.085 | 181.12 | 180.7836 | 180.8628 | 1323401.0 |
| 2024-02-27 11:30:00 | AAPL | Stock | 180.86 | 180.97 | 180.725 | 180.82 | 1016286.0 |
| 2024-02-27 12:00:00 | AAPL | Stock | 180.8227 | 181.0101 | 180.55 | 180.69 | 1235326.0 |
| 2024-02-27 12:30:00 | AAPL | Stock | 180.685 | 180.79 | 180.11 | 180.18 | 1351656.0 |
| 2024-02-27 13:00:00 | AAPL | Stock | 180.18 | 180.415 | 180.0401 | 180.0654 | 1603493.0 |
| 2024-02-27 13:30:00 | AAPL | Stock | 180.07 | 180.49 | 179.56 | 180.4599 | 2110327.0 |
| 2024-02-27 14:00:00 | AAPL | Stock | 180.465 | 182.6 | 180.43 | 182.6 | 6637274.0 |
| 2024-02-27 14:30:00 | AAPL | Stock | 182.5979 | 183.9225 | 182.589 | 182.945 | 7050297.0 |
| 2024-02-27 15:00:00 | AAPL | Stock | 182.95 | 183.0 | 182.18 | 182.605 | 3686762.0 |
| 2024-02-27 15:30:00 | AAPL | Stock | 182.6 | 182.75 | 182.28 | 182.63 | 5490557.0 |
| 2024-02-27 16:00:00 | AAPL | Stock | 182.6 | 183.27 | 182.6 | 183.22 | 4966512.0 |
| 2024-02-27 16:30:00 | AAPL | Stock | 183.23 | 183.23 | 182.63 | 182.9 | 89444.0 |
| 2024-02-27 17:00:00 | AAPL | Stock | 182.88 | 183.14 | 182.8 | 183.0 | 38814.0 |
| 2024-02-27 17:30:00 | AAPL | Stock | 182.95 | 183.06 | 182.8 | 183.06 | 21058.0 |
| 2024-02-27 18:00:00 | AAPL | Stock | 183.06 | 183.18 | 182.85 | 182.91 | 24774.0 |
| 2024-02-27 18:30:00 | AAPL | Stock | 183.0 | 183.0 | 182.8 | 182.88 | 11047.0 |
| 2024-02-27 19:00:00 | AAPL | Stock | 182.86 | 183.15 | 182.81 | 183.01 | 9899.0 |
| 2024-02-27 19:30:00 | AAPL | Stock | 183.05 | 183.2 | 183.02 | 183.06 | 42073.0 |
| 2024-02-27 04:00:00 | MSFT | Stock | 407.54 | 407.61 | 406.97 | 407.61 | 2481.0 |
| 2024-02-27 04:30:00 | MSFT | Stock | 407.77 | 407.86 | 407.61 | 407.72 | 3899.0 |
| 2024-02-27 05:00:00 | MSFT | Stock | 407.8 | 408.09 | 407.8 | 408.09 | 4901.0 |
| 2024-02-27 05:30:00 | MSFT | Stock | 408.07 | 408.21 | 408.01 | 408.12 | 726.0 |
| 2024-02-27 06:00:00 | MSFT | Stock | 407.99 | 407.99 | 407.15 | 407.15 | 2907.0 |
| 2024-02-27 06:30:00 | MSFT | Stock | 406.79 | 406.79 | 406.56 | 406.79 | 960.0 |
| 2024-02-27 07:00:00 | MSFT | Stock | 407.0 | 407.78 | 407.0 | 407.75 | 7514.0 |
| 2024-02-27 07:30:00 | MSFT | Stock | 407.95 | 407.95 | 407.54 | 407.54 | 2885.0 |
| 2024-02-27 08:00:00 | MSFT | Stock | 407.3 | 407.9 | 406.68 | 406.75 | 21582.0 |
| 2024-02-27 08:30:00 | MSFT | Stock | 406.82 | 407.3 | 406.63 | 407.1091 | 11727.0 |
| 2024-02-27 09:00:00 | MSFT | Stock | 407.0478 | 407.98 | 406.62 | 407.98 | 19268.0 |
| 2024-02-27 09:30:00 | MSFT | Stock | 407.91 | 408.32 | 405.4 | 406.19 | 1336980.0 |
| 2024-02-27 10:00:00 | MSFT | Stock | 406.13 | 407.12 | 405.93 | 406.56 | 521267.0 |
| 2024-02-27 10:30:00 | MSFT | Stock | 406.5266 | 407.51 | 405.76 | 406.592 | 537852.0 |
| 2024-02-27 11:00:00 | MSFT | Stock | 406.65 | 406.71 | 405.26 | 405.275 | 443959.0 |
| 2024-02-27 11:30:00 | MSFT | Stock | 405.275 | 405.96 | 405.17 | 405.58 | 444233.0 |
| 2024-02-27 12:00:00 | MSFT | Stock | 405.61 | 406.12 | 404.69 | 404.89 | 394999.0 |
| 2024-02-27 12:30:00 | MSFT | Stock | 404.92 | 405.115 | 403.9606 | 404.16 | 381616.0 |
> showing 50 of 102,094 rows — these rows as CSV