PREVIEW / stock_30min / 2024-05-22
file: by_date/stock_30min/2024/2024-05-22.parquet size: 2.1 MB rows: 99,189 symbols: 976
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-05-22 04:00:00 | AAPL | Stock | 192.42 | 192.42 | 192.1 | 192.1 | 9266.0 |
| 2024-05-22 04:30:00 | AAPL | Stock | 192.1 | 192.11 | 192.01 | 192.01 | 2914.0 |
| 2024-05-22 05:00:00 | AAPL | Stock | 192.04 | 192.05 | 191.75 | 191.75 | 4170.0 |
| 2024-05-22 05:30:00 | AAPL | Stock | 191.73 | 191.81 | 191.73 | 191.81 | 597.0 |
| 2024-05-22 06:00:00 | AAPL | Stock | 191.9 | 191.9 | 191.8 | 191.8 | 541.0 |
| 2024-05-22 06:30:00 | AAPL | Stock | 191.82 | 191.82 | 191.73 | 191.77 | 1303.0 |
| 2024-05-22 07:00:00 | AAPL | Stock | 191.83 | 192.39 | 191.83 | 192.34 | 9586.0 |
| 2024-05-22 07:30:00 | AAPL | Stock | 192.32 | 192.57 | 192.15 | 192.17 | 16563.0 |
| 2024-05-22 08:00:00 | AAPL | Stock | 191.87 | 192.59 | 191.8057 | 192.18 | 26795.0 |
| 2024-05-22 08:30:00 | AAPL | Stock | 192.14 | 192.29 | 192.09 | 192.1 | 11861.0 |
| 2024-05-22 09:00:00 | AAPL | Stock | 192.08 | 192.3898 | 191.95 | 192.3898 | 42603.0 |
| 2024-05-22 09:30:00 | AAPL | Stock | 192.38 | 192.79 | 191.98 | 192.47 | 3089899.0 |
| 2024-05-22 10:00:00 | AAPL | Stock | 192.44 | 192.8231 | 192.37 | 192.715 | 1735296.0 |
| 2024-05-22 10:30:00 | AAPL | Stock | 192.715 | 192.76 | 192.08 | 192.08 | 1414906.0 |
| 2024-05-22 11:00:00 | AAPL | Stock | 192.0801 | 192.3 | 192.033 | 192.14 | 1464679.0 |
| 2024-05-22 11:30:00 | AAPL | Stock | 192.14 | 192.2 | 191.66 | 191.829 | 1660803.0 |
| 2024-05-22 12:00:00 | AAPL | Stock | 191.83 | 191.87 | 191.525 | 191.62 | 1018139.0 |
| 2024-05-22 12:30:00 | AAPL | Stock | 191.615 | 191.73 | 191.155 | 191.3 | 1066984.0 |
| 2024-05-22 13:00:00 | AAPL | Stock | 191.3085 | 191.4829 | 191.08 | 191.37 | 1127416.0 |
| 2024-05-22 13:30:00 | AAPL | Stock | 191.3699 | 191.43 | 190.72 | 190.855 | 1423724.0 |
| 2024-05-22 14:00:00 | AAPL | Stock | 190.85 | 190.87 | 190.27 | 190.6 | 1744938.0 |
| 2024-05-22 14:30:00 | AAPL | Stock | 190.6 | 190.8985 | 190.52 | 190.81 | 1018698.0 |
| 2024-05-22 15:00:00 | AAPL | Stock | 190.815 | 190.94 | 190.63 | 190.9399 | 1164867.0 |
| 2024-05-22 15:30:00 | AAPL | Stock | 190.9301 | 191.305 | 190.38 | 190.98 | 3531815.0 |
| 2024-05-22 16:00:00 | AAPL | Stock | 191.02 | 191.3 | 190.78 | 190.93 | 5593154.0 |
| 2024-05-22 16:30:00 | AAPL | Stock | 190.9699 | 191.08 | 190.32 | 190.5 | 74056.0 |
| 2024-05-22 17:00:00 | AAPL | Stock | 190.52 | 190.75 | 190.35 | 190.38 | 38009.0 |
| 2024-05-22 17:30:00 | AAPL | Stock | 190.38 | 190.69 | 190.28 | 190.69 | 24636.0 |
| 2024-05-22 18:00:00 | AAPL | Stock | 190.69 | 190.9 | 190.5403 | 190.56 | 25822.0 |
| 2024-05-22 18:30:00 | AAPL | Stock | 190.5802 | 190.73 | 190.58 | 190.61 | 11583.0 |
| 2024-05-22 19:00:00 | AAPL | Stock | 190.61 | 190.69 | 190.56 | 190.56 | 10020.0 |
| 2024-05-22 19:30:00 | AAPL | Stock | 190.54 | 190.56 | 190.36 | 190.46 | 13592.0 |
| 2024-05-22 04:00:00 | MSFT | Stock | 429.39 | 430.1 | 429.39 | 430.03 | 824.0 |
| 2024-05-22 04:30:00 | MSFT | Stock | 429.98 | 430.0 | 429.98 | 430.0 | 491.0 |
| 2024-05-22 05:00:00 | MSFT | Stock | 430.51 | 430.51 | 430.51 | 430.51 | 100.0 |
| 2024-05-22 05:30:00 | MSFT | Stock | 430.55 | 430.55 | 430.4 | 430.4 | 533.0 |
| 2024-05-22 06:00:00 | MSFT | Stock | 430.28 | 430.3 | 430.16 | 430.16 | 300.0 |
| 2024-05-22 06:30:00 | MSFT | Stock | 430.2 | 430.2 | 429.97 | 430.0 | 3002.0 |
| 2024-05-22 07:00:00 | MSFT | Stock | 430.3 | 430.32 | 430.2 | 430.3 | 1838.0 |
| 2024-05-22 07:30:00 | MSFT | Stock | 430.25 | 430.36 | 429.6 | 429.6 | 2272.0 |
| 2024-05-22 08:00:00 | MSFT | Stock | 430.29 | 430.5581 | 428.5 | 429.937 | 29863.0 |
| 2024-05-22 08:30:00 | MSFT | Stock | 429.87 | 429.94 | 429.64 | 429.75 | 5942.0 |
| 2024-05-22 09:00:00 | MSFT | Stock | 429.7 | 430.43 | 429.54 | 430.09 | 6619.0 |
| 2024-05-22 09:30:00 | MSFT | Stock | 430.09 | 432.2864 | 430.01 | 431.17 | 1348188.0 |
| 2024-05-22 10:00:00 | MSFT | Stock | 431.165 | 432.41 | 431.11 | 431.91 | 637830.0 |
| 2024-05-22 10:30:00 | MSFT | Stock | 431.9 | 432.15 | 430.76 | 430.82 | 524028.0 |
| 2024-05-22 11:00:00 | MSFT | Stock | 430.86 | 431.8286 | 430.6 | 431.27 | 348370.0 |
| 2024-05-22 11:30:00 | MSFT | Stock | 431.27 | 431.32 | 430.07 | 430.5381 | 321015.0 |
| 2024-05-22 12:00:00 | MSFT | Stock | 430.525 | 431.095 | 429.77 | 429.8589 | 316932.0 |
| 2024-05-22 12:30:00 | MSFT | Stock | 429.8799 | 430.2 | 429.39 | 429.7404 | 261180.0 |
> showing 50 of 99,189 rows — these rows as CSV