PREVIEW / stock_30min / 2024-09-04
file: by_date/stock_30min/2024/2024-09-04.parquet size: 2.0 MB rows: 96,685 symbols: 841
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-09-04 04:00:00 | AAPL | Stock | 220.1 | 220.9 | 220.1 | 220.55 | 23872.0 |
| 2024-09-04 04:30:00 | AAPL | Stock | 220.72 | 220.83 | 220.27 | 220.54 | 7715.0 |
| 2024-09-04 05:00:00 | AAPL | Stock | 220.5 | 220.89 | 220.5 | 220.89 | 14996.0 |
| 2024-09-04 05:30:00 | AAPL | Stock | 220.84 | 221.09 | 220.84 | 221.08 | 19207.0 |
| 2024-09-04 06:00:00 | AAPL | Stock | 221.15 | 221.48 | 221.0 | 221.06 | 5443.0 |
| 2024-09-04 06:30:00 | AAPL | Stock | 221.09 | 221.14 | 220.66 | 220.75 | 7513.0 |
| 2024-09-04 07:00:00 | AAPL | Stock | 220.7 | 220.92 | 220.56 | 220.85 | 12890.0 |
| 2024-09-04 07:30:00 | AAPL | Stock | 220.9 | 221.12 | 220.7 | 220.7 | 12743.0 |
| 2024-09-04 08:00:00 | AAPL | Stock | 220.65 | 221.1799 | 219.67 | 221.12 | 47377.0 |
| 2024-09-04 08:30:00 | AAPL | Stock | 221.1 | 222.77 | 220.75 | 221.5 | 40898.0 |
| 2024-09-04 09:00:00 | AAPL | Stock | 221.5 | 222.0 | 220.88 | 221.54 | 77056.0 |
| 2024-09-04 09:30:00 | AAPL | Stock | 221.7 | 221.78 | 219.04 | 219.57 | 5155115.0 |
| 2024-09-04 10:00:00 | AAPL | Stock | 219.56 | 219.56 | 217.48 | 218.635 | 4918101.0 |
| 2024-09-04 10:30:00 | AAPL | Stock | 218.64 | 219.62 | 218.54 | 219.45 | 2453796.0 |
| 2024-09-04 11:00:00 | AAPL | Stock | 219.48 | 220.25 | 218.68 | 218.6801 | 2068632.0 |
| 2024-09-04 11:30:00 | AAPL | Stock | 218.695 | 219.4595 | 218.01 | 219.32 | 1472961.0 |
| 2024-09-04 12:00:00 | AAPL | Stock | 219.315 | 219.965 | 219.08 | 219.93 | 1097910.0 |
| 2024-09-04 12:30:00 | AAPL | Stock | 219.92 | 220.2182 | 219.54 | 220.215 | 1168804.0 |
| 2024-09-04 13:00:00 | AAPL | Stock | 220.21 | 220.7843 | 219.79 | 220.12 | 1128699.0 |
| 2024-09-04 13:30:00 | AAPL | Stock | 220.1046 | 220.91 | 220.07 | 220.875 | 1084609.0 |
| 2024-09-04 14:00:00 | AAPL | Stock | 220.875 | 221.11 | 220.4 | 220.91 | 1242302.0 |
| 2024-09-04 14:30:00 | AAPL | Stock | 220.9 | 221.14 | 220.46 | 220.51 | 1054599.0 |
| 2024-09-04 15:00:00 | AAPL | Stock | 220.52 | 220.59 | 220.17 | 220.55 | 1300439.0 |
| 2024-09-04 15:30:00 | AAPL | Stock | 220.55 | 221.4301 | 220.42 | 220.79 | 3515053.0 |
| 2024-09-04 16:00:00 | AAPL | Stock | 220.85 | 220.9 | 219.9133 | 220.7 | 4732702.0 |
| 2024-09-04 16:30:00 | AAPL | Stock | 220.82 | 220.86 | 220.56 | 220.67 | 147083.0 |
| 2024-09-04 17:00:00 | AAPL | Stock | 220.66 | 220.85 | 220.65 | 220.8395 | 144232.0 |
| 2024-09-04 17:30:00 | AAPL | Stock | 220.81 | 220.95 | 220.81 | 220.9 | 8518.0 |
| 2024-09-04 18:00:00 | AAPL | Stock | 220.86 | 220.9485 | 220.7331 | 220.85 | 2584.0 |
| 2024-09-04 18:30:00 | AAPL | Stock | 220.84 | 221.0 | 220.7 | 221.0 | 8689.0 |
| 2024-09-04 19:00:00 | AAPL | Stock | 220.8 | 220.8482 | 220.11 | 220.4 | 4889.0 |
| 2024-09-04 19:30:00 | AAPL | Stock | 220.25 | 220.29 | 219.43 | 220.0 | 25063.0 |
| 2024-09-04 04:00:00 | MSFT | Stock | 407.0 | 407.49 | 406.54 | 406.87 | 3549.0 |
| 2024-09-04 04:30:00 | MSFT | Stock | 406.65 | 406.65 | 406.65 | 406.65 | 135.0 |
| 2024-09-04 05:00:00 | MSFT | Stock | 406.57 | 407.35 | 406.5 | 407.04 | 1296.0 |
| 2024-09-04 05:30:00 | MSFT | Stock | 406.93 | 407.47 | 406.93 | 407.08 | 2000.0 |
| 2024-09-04 06:00:00 | MSFT | Stock | 406.94 | 406.94 | 406.3 | 406.3 | 602.0 |
| 2024-09-04 06:30:00 | MSFT | Stock | 406.37 | 406.37 | 405.9 | 405.9 | 529.0 |
| 2024-09-04 07:00:00 | MSFT | Stock | 406.04 | 406.68 | 405.99 | 406.34 | 1922.0 |
| 2024-09-04 07:30:00 | MSFT | Stock | 406.3 | 406.38 | 406.2 | 406.3 | 1305.0 |
| 2024-09-04 08:00:00 | MSFT | Stock | 406.15 | 406.75 | 406.0778 | 406.6984 | 23808.0 |
| 2024-09-04 08:30:00 | MSFT | Stock | 406.5095 | 409.44 | 406.3 | 407.32 | 10722.0 |
| 2024-09-04 09:00:00 | MSFT | Stock | 407.2855 | 407.29 | 405.32 | 405.5096 | 41305.0 |
| 2024-09-04 09:30:00 | MSFT | Stock | 405.79 | 407.89 | 404.37 | 406.89 | 1466142.0 |
| 2024-09-04 10:00:00 | MSFT | Stock | 406.87 | 408.22 | 404.6 | 408.22 | 895638.0 |
| 2024-09-04 10:30:00 | MSFT | Stock | 408.24 | 410.6 | 407.835 | 410.565 | 723811.0 |
| 2024-09-04 11:00:00 | MSFT | Stock | 410.565 | 411.24 | 409.09 | 409.2 | 575544.0 |
| 2024-09-04 11:30:00 | MSFT | Stock | 409.205 | 409.94 | 408.64 | 409.503 | 328222.0 |
| 2024-09-04 12:00:00 | MSFT | Stock | 409.48 | 409.94 | 408.66 | 409.76 | 250861.0 |
| 2024-09-04 12:30:00 | MSFT | Stock | 409.74 | 410.74 | 408.76 | 409.41 | 658858.0 |
> showing 50 of 96,685 rows — these rows as CSV