PREVIEW / stock_30min / 2024-05-23
file: by_date/stock_30min/2024/2024-05-23.parquet size: 2.1 MB rows: 99,252 symbols: 964
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-23 04:00:00 | AAPL | Stock | 190.65 | 191.12 | 190.65 | 191.12 | 5165.0 |
| 2024-05-23 04:30:00 | AAPL | Stock | 191.04 | 191.1 | 190.7 | 190.78 | 3583.0 |
| 2024-05-23 05:00:00 | AAPL | Stock | 190.77 | 190.88 | 190.77 | 190.88 | 3603.0 |
| 2024-05-23 05:30:00 | AAPL | Stock | 190.97 | 190.98 | 190.83 | 190.83 | 3674.0 |
| 2024-05-23 06:00:00 | AAPL | Stock | 190.83 | 190.83 | 190.78 | 190.78 | 1610.0 |
| 2024-05-23 06:30:00 | AAPL | Stock | 190.83 | 190.9 | 190.83 | 190.85 | 2809.0 |
| 2024-05-23 07:00:00 | AAPL | Stock | 190.85 | 191.11 | 190.85 | 190.92 | 11457.0 |
| 2024-05-23 07:30:00 | AAPL | Stock | 190.95 | 191.25 | 190.95 | 191.25 | 3431.0 |
| 2024-05-23 08:00:00 | AAPL | Stock | 190.85 | 191.45 | 190.85 | 191.37 | 80679.0 |
| 2024-05-23 08:30:00 | AAPL | Stock | 191.35 | 191.46 | 191.21 | 191.32 | 48592.0 |
| 2024-05-23 09:00:00 | AAPL | Stock | 191.34 | 191.4 | 190.5 | 190.94 | 132130.0 |
| 2024-05-23 09:30:00 | AAPL | Stock | 190.98 | 191.01 | 189.05 | 189.42 | 5309722.0 |
| 2024-05-23 10:00:00 | AAPL | Stock | 189.42 | 189.59 | 188.505 | 189.05 | 2834338.0 |
| 2024-05-23 10:30:00 | AAPL | Stock | 189.06 | 189.69 | 188.7 | 188.725 | 2333995.0 |
| 2024-05-23 11:00:00 | AAPL | Stock | 188.73 | 189.63 | 188.68 | 189.45 | 1561702.0 |
| 2024-05-23 11:30:00 | AAPL | Stock | 189.455 | 189.71 | 189.07 | 189.685 | 1470812.0 |
| 2024-05-23 12:00:00 | AAPL | Stock | 189.685 | 189.69 | 189.26 | 189.525 | 1157839.0 |
| 2024-05-23 12:30:00 | AAPL | Stock | 189.525 | 189.6 | 188.75 | 188.79 | 1397800.0 |
| 2024-05-23 13:00:00 | AAPL | Stock | 188.78 | 188.9691 | 188.42 | 188.6401 | 1680457.0 |
| 2024-05-23 13:30:00 | AAPL | Stock | 188.65 | 188.685 | 187.56 | 187.595 | 2229641.0 |
| 2024-05-23 14:00:00 | AAPL | Stock | 187.59 | 187.87 | 187.31 | 187.705 | 2174471.0 |
| 2024-05-23 14:30:00 | AAPL | Stock | 187.7 | 187.8 | 187.16 | 187.27 | 1498690.0 |
| 2024-05-23 15:00:00 | AAPL | Stock | 187.27 | 187.68 | 187.21 | 187.62 | 1829264.0 |
| 2024-05-23 15:30:00 | AAPL | Stock | 187.62 | 187.83 | 186.625 | 186.91 | 4645330.0 |
| 2024-05-23 16:00:00 | AAPL | Stock | 186.86 | 187.1677 | 186.63 | 186.88 | 9240462.0 |
| 2024-05-23 16:30:00 | AAPL | Stock | 186.9 | 187.0 | 186.85 | 186.97 | 15400.0 |
| 2024-05-23 17:00:00 | AAPL | Stock | 187.0 | 187.05 | 186.88 | 187.01 | 108003.0 |
| 2024-05-23 17:30:00 | AAPL | Stock | 187.0 | 187.14 | 186.9096 | 187.01 | 14914.0 |
| 2024-05-23 18:00:00 | AAPL | Stock | 187.08 | 187.3 | 187.06 | 187.1402 | 21329.0 |
| 2024-05-23 18:30:00 | AAPL | Stock | 187.225 | 187.3 | 187.16 | 187.2999 | 14223.0 |
| 2024-05-23 19:00:00 | AAPL | Stock | 187.17 | 187.23 | 187.12 | 187.16 | 9705.0 |
| 2024-05-23 19:30:00 | AAPL | Stock | 187.12 | 187.29 | 187.09 | 187.28 | 10262.0 |
| 2024-05-23 04:00:00 | MSFT | Stock | 432.84 | 433.0 | 432.4 | 432.8 | 5913.0 |
| 2024-05-23 04:30:00 | MSFT | Stock | 433.0 | 433.0 | 432.23 | 432.23 | 5028.0 |
| 2024-05-23 05:00:00 | MSFT | Stock | 432.22 | 432.78 | 432.22 | 432.63 | 1430.0 |
| 2024-05-23 05:30:00 | MSFT | Stock | 432.6 | 432.79 | 432.6 | 432.79 | 500.0 |
| 2024-05-23 06:00:00 | MSFT | Stock | 432.79 | 433.03 | 432.79 | 433.03 | 894.0 |
| 2024-05-23 06:30:00 | MSFT | Stock | 433.29 | 433.39 | 433.2 | 433.24 | 2955.0 |
| 2024-05-23 07:00:00 | MSFT | Stock | 433.28 | 434.5 | 432.81 | 434.38 | 32467.0 |
| 2024-05-23 07:30:00 | MSFT | Stock | 434.34 | 434.69 | 433.76 | 433.8 | 6883.0 |
| 2024-05-23 08:00:00 | MSFT | Stock | 433.06 | 434.75 | 432.69 | 434.4 | 46844.0 |
| 2024-05-23 08:30:00 | MSFT | Stock | 434.35 | 434.5 | 434.01 | 434.3 | 13683.0 |
| 2024-05-23 09:00:00 | MSFT | Stock | 434.12 | 434.2 | 432.13 | 433.25 | 23838.0 |
| 2024-05-23 09:30:00 | MSFT | Stock | 432.96 | 433.6 | 429.79 | 430.15 | 1761351.0 |
| 2024-05-23 10:00:00 | MSFT | Stock | 430.165 | 432.0 | 430.16 | 431.67 | 805302.0 |
| 2024-05-23 10:30:00 | MSFT | Stock | 431.7 | 432.75 | 430.62 | 430.639 | 636826.0 |
| 2024-05-23 11:00:00 | MSFT | Stock | 430.67 | 432.11 | 430.6 | 431.865 | 436099.0 |
| 2024-05-23 11:30:00 | MSFT | Stock | 431.925 | 432.12 | 431.6101 | 431.775 | 297378.0 |
| 2024-05-23 12:00:00 | MSFT | Stock | 431.755 | 432.08 | 431.14 | 432.0545 | 251107.0 |
| 2024-05-23 12:30:00 | MSFT | Stock | 432.04 | 432.1 | 430.26 | 430.29 | 250137.0 |
> showing 50 of 99,252 rows — these rows as CSV