PREVIEW / stock_30min / 2024-08-15
file: by_date/stock_30min/2024/2024-08-15.parquet size: 2.1 MB rows: 99,027 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-08-15 04:00:00 | AAPL | Stock | 222.34 | 222.71 | 222.04 | 222.19 | 5072.0 |
| 2024-08-15 04:30:00 | AAPL | Stock | 222.1 | 222.22 | 221.88 | 222.22 | 3269.0 |
| 2024-08-15 05:00:00 | AAPL | Stock | 222.21 | 222.34 | 222.21 | 222.34 | 1288.0 |
| 2024-08-15 05:30:00 | AAPL | Stock | 222.29 | 222.48 | 222.29 | 222.44 | 3594.0 |
| 2024-08-15 06:00:00 | AAPL | Stock | 222.46 | 222.48 | 222.04 | 222.16 | 3423.0 |
| 2024-08-15 06:30:00 | AAPL | Stock | 222.07 | 222.11 | 221.84 | 221.84 | 2407.0 |
| 2024-08-15 07:00:00 | AAPL | Stock | 221.91 | 222.34 | 221.76 | 222.32 | 12878.0 |
| 2024-08-15 07:30:00 | AAPL | Stock | 222.3 | 222.37 | 222.2 | 222.28 | 3876.0 |
| 2024-08-15 08:00:00 | AAPL | Stock | 221.94 | 222.6 | 221.78 | 222.3003 | 42193.0 |
| 2024-08-15 08:30:00 | AAPL | Stock | 222.46 | 223.71 | 222.3 | 223.43 | 148884.0 |
| 2024-08-15 09:00:00 | AAPL | Stock | 223.53 | 224.83 | 223.08 | 224.55 | 166219.0 |
| 2024-08-15 09:30:00 | AAPL | Stock | 224.49 | 224.87 | 222.76 | 224.43 | 4564783.0 |
| 2024-08-15 10:00:00 | AAPL | Stock | 224.4201 | 224.99 | 223.95 | 224.79 | 2661521.0 |
| 2024-08-15 10:30:00 | AAPL | Stock | 224.795 | 225.35 | 224.35 | 224.45 | 2615985.0 |
| 2024-08-15 11:00:00 | AAPL | Stock | 224.44 | 224.61 | 223.9 | 224.005 | 1476763.0 |
| 2024-08-15 11:30:00 | AAPL | Stock | 224.01 | 224.815 | 223.84 | 224.65 | 1413312.0 |
| 2024-08-15 12:00:00 | AAPL | Stock | 224.65 | 225.02 | 224.58 | 224.995 | 1092244.0 |
| 2024-08-15 12:30:00 | AAPL | Stock | 225.0 | 225.02 | 224.35 | 224.57 | 1075301.0 |
| 2024-08-15 13:00:00 | AAPL | Stock | 224.5601 | 224.7 | 224.245 | 224.545 | 834856.0 |
| 2024-08-15 13:30:00 | AAPL | Stock | 224.56 | 224.87 | 224.51 | 224.6761 | 751687.0 |
| 2024-08-15 14:00:00 | AAPL | Stock | 224.6801 | 225.15 | 224.62 | 225.07 | 957588.0 |
| 2024-08-15 14:30:00 | AAPL | Stock | 225.06 | 225.19 | 224.935 | 225.11 | 895434.0 |
| 2024-08-15 15:00:00 | AAPL | Stock | 225.11 | 225.33 | 224.9138 | 225.06 | 1255383.0 |
| 2024-08-15 15:30:00 | AAPL | Stock | 225.055 | 225.09 | 223.845 | 224.71 | 3926099.0 |
| 2024-08-15 16:00:00 | AAPL | Stock | 224.71 | 224.98 | 224.25 | 224.74 | 10403488.0 |
| 2024-08-15 16:30:00 | AAPL | Stock | 224.76 | 224.81 | 224.62 | 224.78 | 93389.0 |
| 2024-08-15 17:00:00 | AAPL | Stock | 224.8 | 224.9 | 224.67 | 224.67 | 21911.0 |
| 2024-08-15 17:30:00 | AAPL | Stock | 224.7 | 224.82 | 224.61 | 224.8199 | 12259.0 |
| 2024-08-15 18:00:00 | AAPL | Stock | 224.83 | 225.08 | 224.82 | 225.0 | 10940.0 |
| 2024-08-15 18:30:00 | AAPL | Stock | 225.0 | 225.41 | 224.99 | 225.39 | 18217.0 |
| 2024-08-15 19:00:00 | AAPL | Stock | 225.38 | 225.55 | 225.15 | 225.5 | 14592.0 |
| 2024-08-15 19:30:00 | AAPL | Stock | 225.5 | 225.53 | 225.25 | 225.3901 | 13697.0 |
| 2024-08-15 04:00:00 | MSFT | Stock | 418.1 | 418.1 | 417.3 | 417.3 | 1054.0 |
| 2024-08-15 04:30:00 | MSFT | Stock | 417.15 | 417.49 | 417.05 | 417.44 | 1435.0 |
| 2024-08-15 05:00:00 | MSFT | Stock | 417.5 | 417.79 | 417.5 | 417.78 | 1265.0 |
| 2024-08-15 05:30:00 | MSFT | Stock | 417.74 | 417.8 | 417.7 | 417.8 | 1846.0 |
| 2024-08-15 06:00:00 | MSFT | Stock | 417.8 | 417.92 | 417.39 | 417.39 | 1483.0 |
| 2024-08-15 06:30:00 | MSFT | Stock | 417.4 | 417.4 | 417.13 | 417.13 | 548.0 |
| 2024-08-15 07:00:00 | MSFT | Stock | 417.1 | 417.96 | 417.01 | 417.96 | 2431.0 |
| 2024-08-15 07:30:00 | MSFT | Stock | 418.0 | 418.19 | 417.99 | 418.08 | 2263.0 |
| 2024-08-15 08:00:00 | MSFT | Stock | 417.3 | 418.09 | 417.11 | 417.35 | 18615.0 |
| 2024-08-15 08:30:00 | MSFT | Stock | 417.75 | 420.5 | 417.75 | 419.74 | 37197.0 |
| 2024-08-15 09:00:00 | MSFT | Stock | 419.7 | 420.78 | 419.2102 | 419.26 | 30354.0 |
| 2024-08-15 09:30:00 | MSFT | Stock | 419.26 | 420.63 | 417.66 | 420.63 | 1265163.0 |
| 2024-08-15 10:00:00 | MSFT | Stock | 420.58 | 420.936 | 418.395 | 419.8691 | 732049.0 |
| 2024-08-15 10:30:00 | MSFT | Stock | 419.83 | 419.93 | 418.2 | 418.4675 | 558053.0 |
| 2024-08-15 11:00:00 | MSFT | Stock | 418.48 | 419.04 | 417.95 | 418.735 | 690644.0 |
| 2024-08-15 11:30:00 | MSFT | Stock | 418.73 | 420.0699 | 418.43 | 419.735 | 472262.0 |
| 2024-08-15 12:00:00 | MSFT | Stock | 419.715 | 420.55 | 419.62 | 420.09 | 355798.0 |
| 2024-08-15 12:30:00 | MSFT | Stock | 420.1 | 420.16 | 418.82 | 418.93 | 360231.0 |
> showing 50 of 99,027 rows — these rows as CSV