PREVIEW / stock_30min / 2024-02-07
file: by_date/stock_30min/2024/2024-02-07.parquet size: 2.1 MB rows: 99,366 symbols: 1,161
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-07 04:00:00 | AAPL | Stock | 189.36 | 189.76 | 189.25 | 189.61 | 15103.0 |
| 2024-02-07 04:30:00 | AAPL | Stock | 189.66 | 189.8 | 189.6 | 189.6 | 5857.0 |
| 2024-02-07 05:00:00 | AAPL | Stock | 189.71 | 189.71 | 189.63 | 189.63 | 628.0 |
| 2024-02-07 05:30:00 | AAPL | Stock | 189.62 | 189.62 | 189.31 | 189.31 | 3982.0 |
| 2024-02-07 06:00:00 | AAPL | Stock | 189.38 | 189.65 | 189.38 | 189.45 | 5104.0 |
| 2024-02-07 06:30:00 | AAPL | Stock | 189.62 | 189.65 | 189.62 | 189.64 | 1047.0 |
| 2024-02-07 07:00:00 | AAPL | Stock | 189.61 | 189.81 | 189.58 | 189.7 | 6938.0 |
| 2024-02-07 07:30:00 | AAPL | Stock | 189.7 | 190.0 | 189.6 | 189.96 | 26722.0 |
| 2024-02-07 08:00:00 | AAPL | Stock | 189.63 | 190.39 | 189.36 | 190.2 | 97249.0 |
| 2024-02-07 08:30:00 | AAPL | Stock | 190.2 | 190.38 | 190.07 | 190.129 | 45873.0 |
| 2024-02-07 09:00:00 | AAPL | Stock | 190.15 | 191.0 | 190.15 | 190.59 | 188083.0 |
| 2024-02-07 09:30:00 | AAPL | Stock | 190.61 | 191.05 | 188.8408 | 189.005 | 5935320.0 |
| 2024-02-07 10:00:00 | AAPL | Stock | 189.005 | 190.39 | 188.61 | 190.371 | 4346879.0 |
| 2024-02-07 10:30:00 | AAPL | Stock | 190.38 | 190.4 | 189.46 | 189.66 | 2808286.0 |
| 2024-02-07 11:00:00 | AAPL | Stock | 189.66 | 189.72 | 188.806 | 189.075 | 2725556.0 |
| 2024-02-07 11:30:00 | AAPL | Stock | 189.075 | 189.27 | 188.81 | 189.135 | 1973212.0 |
| 2024-02-07 12:00:00 | AAPL | Stock | 189.14 | 189.22 | 188.92 | 188.995 | 1442451.0 |
| 2024-02-07 12:30:00 | AAPL | Stock | 189.0 | 189.08 | 188.65 | 188.9964 | 1956487.0 |
| 2024-02-07 13:00:00 | AAPL | Stock | 189.0 | 189.175 | 188.73 | 189.12 | 1648161.0 |
| 2024-02-07 13:30:00 | AAPL | Stock | 189.13 | 189.295 | 188.86 | 189.1999 | 1573708.0 |
| 2024-02-07 14:00:00 | AAPL | Stock | 189.2 | 189.269 | 188.94 | 188.9734 | 1429786.0 |
| 2024-02-07 14:30:00 | AAPL | Stock | 188.98 | 189.41 | 188.89 | 189.26 | 1533738.0 |
| 2024-02-07 15:00:00 | AAPL | Stock | 189.265 | 189.35 | 189.04 | 189.175 | 2121264.0 |
| 2024-02-07 15:30:00 | AAPL | Stock | 189.175 | 189.42 | 188.935 | 189.41 | 4549448.0 |
| 2024-02-07 16:00:00 | AAPL | Stock | 189.41 | 189.55 | 189.21 | 189.36 | 7157861.0 |
| 2024-02-07 16:30:00 | AAPL | Stock | 189.33 | 189.41 | 189.26 | 189.38 | 52858.0 |
| 2024-02-07 17:00:00 | AAPL | Stock | 189.38 | 189.81 | 189.32 | 189.4 | 31782.0 |
| 2024-02-07 17:30:00 | AAPL | Stock | 189.36 | 189.41 | 189.22 | 189.36 | 16063.0 |
| 2024-02-07 18:00:00 | AAPL | Stock | 189.24 | 189.39 | 189.22 | 189.33 | 9333.0 |
| 2024-02-07 18:30:00 | AAPL | Stock | 189.31 | 189.3637 | 189.22 | 189.34 | 4394.0 |
| 2024-02-07 19:00:00 | AAPL | Stock | 189.26 | 189.32 | 189.22 | 189.27 | 7036.0 |
| 2024-02-07 19:30:00 | AAPL | Stock | 189.25 | 189.41 | 189.25 | 189.37 | 5236.0 |
| 2024-02-07 04:00:00 | MSFT | Stock | 405.09 | 405.45 | 405.09 | 405.45 | 919.0 |
| 2024-02-07 04:30:00 | MSFT | Stock | 405.49 | 405.7 | 405.49 | 405.66 | 989.0 |
| 2024-02-07 05:00:00 | MSFT | Stock | 405.66 | 406.06 | 405.66 | 406.06 | 222.0 |
| 2024-02-07 05:30:00 | MSFT | Stock | 405.9 | 406.03 | 405.8 | 405.85 | 1825.0 |
| 2024-02-07 06:00:00 | MSFT | Stock | 405.97 | 406.45 | 405.95 | 406.45 | 1129.0 |
| 2024-02-07 06:30:00 | MSFT | Stock | 406.46 | 406.58 | 406.36 | 406.36 | 1060.0 |
| 2024-02-07 07:00:00 | MSFT | Stock | 406.15 | 406.35 | 406.0 | 406.0 | 3609.0 |
| 2024-02-07 07:30:00 | MSFT | Stock | 406.35 | 406.74 | 406.35 | 406.74 | 2662.0 |
| 2024-02-07 08:00:00 | MSFT | Stock | 406.18 | 407.77 | 405.0 | 407.7107 | 35634.0 |
| 2024-02-07 08:30:00 | MSFT | Stock | 407.74 | 407.9139 | 406.9 | 407.0 | 15991.0 |
| 2024-02-07 09:00:00 | MSFT | Stock | 407.39 | 407.89 | 407.27 | 407.4 | 25880.0 |
| 2024-02-07 09:30:00 | MSFT | Stock | 407.44 | 409.93 | 407.4 | 409.16 | 2317280.0 |
| 2024-02-07 10:00:00 | MSFT | Stock | 409.13 | 411.96 | 408.8 | 411.94 | 1445510.0 |
| 2024-02-07 10:30:00 | MSFT | Stock | 411.97 | 412.4299 | 410.8 | 411.23 | 993358.0 |
| 2024-02-07 11:00:00 | MSFT | Stock | 411.27 | 411.8 | 410.7 | 411.45 | 517227.0 |
| 2024-02-07 11:30:00 | MSFT | Stock | 411.46 | 412.02 | 411.02 | 411.7 | 463565.0 |
| 2024-02-07 12:00:00 | MSFT | Stock | 411.705 | 412.4 | 411.5119 | 411.825 | 493167.0 |
| 2024-02-07 12:30:00 | MSFT | Stock | 411.813 | 412.159 | 411.18 | 412.0 | 363482.0 |
> showing 50 of 99,366 rows — these rows as CSV