PREVIEW / stock_30min / 2023-10-30
file: by_date/stock_30min/2023/2023-10-30.parquet size: 2.0 MB rows: 96,288 symbols: 1,379
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-30 04:00:00 | AAPL | Stock | 168.98 | 169.0 | 168.6 | 168.85 | 10511.0 |
| 2023-10-30 04:30:00 | AAPL | Stock | 168.85 | 168.99 | 168.71 | 168.99 | 4526.0 |
| 2023-10-30 05:00:00 | AAPL | Stock | 168.97 | 169.47 | 168.97 | 169.2 | 5713.0 |
| 2023-10-30 05:30:00 | AAPL | Stock | 169.25 | 169.25 | 168.96 | 169.16 | 3441.0 |
| 2023-10-30 06:00:00 | AAPL | Stock | 169.17 | 169.17 | 168.96 | 169.01 | 13787.0 |
| 2023-10-30 06:30:00 | AAPL | Stock | 169.05 | 169.22 | 169.0 | 169.19 | 22377.0 |
| 2023-10-30 07:00:00 | AAPL | Stock | 169.14 | 169.3 | 169.1 | 169.1 | 13099.0 |
| 2023-10-30 07:30:00 | AAPL | Stock | 169.13 | 169.28 | 169.1 | 169.16 | 10473.0 |
| 2023-10-30 08:00:00 | AAPL | Stock | 169.16 | 169.28 | 168.47 | 168.73 | 77605.0 |
| 2023-10-30 08:30:00 | AAPL | Stock | 168.75 | 168.97 | 168.35 | 168.58 | 105119.0 |
| 2023-10-30 09:00:00 | AAPL | Stock | 168.56 | 169.06 | 168.37 | 169.06 | 70721.0 |
| 2023-10-30 09:30:00 | AAPL | Stock | 169.02 | 171.17 | 168.87 | 170.615 | 6382199.0 |
| 2023-10-30 10:00:00 | AAPL | Stock | 170.63 | 170.9 | 169.33 | 169.4 | 3949981.0 |
| 2023-10-30 10:30:00 | AAPL | Stock | 169.37 | 170.13 | 169.21 | 169.4414 | 3395156.0 |
| 2023-10-30 11:00:00 | AAPL | Stock | 169.44 | 170.2 | 169.425 | 169.67 | 2290293.0 |
| 2023-10-30 11:30:00 | AAPL | Stock | 169.67 | 170.16 | 169.54 | 169.92 | 1720604.0 |
| 2023-10-30 12:00:00 | AAPL | Stock | 169.91 | 170.0 | 169.41 | 169.4661 | 1397560.0 |
| 2023-10-30 12:30:00 | AAPL | Stock | 169.465 | 169.7 | 169.05 | 169.37 | 1759304.0 |
| 2023-10-30 13:00:00 | AAPL | Stock | 169.37 | 170.05 | 169.1834 | 169.9199 | 2061274.0 |
| 2023-10-30 13:30:00 | AAPL | Stock | 169.92 | 170.4 | 169.88 | 170.2801 | 1717831.0 |
| 2023-10-30 14:00:00 | AAPL | Stock | 170.28 | 170.49 | 170.135 | 170.36 | 1845579.0 |
| 2023-10-30 14:30:00 | AAPL | Stock | 170.35 | 170.82 | 170.302 | 170.5 | 1950909.0 |
| 2023-10-30 15:00:00 | AAPL | Stock | 170.5 | 170.67 | 169.8402 | 169.855 | 3163557.0 |
| 2023-10-30 15:30:00 | AAPL | Stock | 169.85 | 170.48 | 169.845 | 170.23 | 4952151.0 |
| 2023-10-30 16:00:00 | AAPL | Stock | 170.24 | 170.29 | 169.91 | 170.07 | 5039600.0 |
| 2023-10-30 16:30:00 | AAPL | Stock | 170.06 | 170.29 | 169.92 | 169.96 | 59933.0 |
| 2023-10-30 17:00:00 | AAPL | Stock | 170.0 | 170.06 | 169.94 | 170.05 | 13445.0 |
| 2023-10-30 17:30:00 | AAPL | Stock | 170.03 | 170.05 | 169.92 | 169.92 | 5084.0 |
| 2023-10-30 18:00:00 | AAPL | Stock | 169.94 | 169.99 | 169.8 | 169.81 | 7195.0 |
| 2023-10-30 18:30:00 | AAPL | Stock | 169.85 | 169.9 | 169.82 | 169.8699 | 8360.0 |
| 2023-10-30 19:00:00 | AAPL | Stock | 169.87 | 169.91 | 169.82 | 169.85 | 6659.0 |
| 2023-10-30 19:30:00 | AAPL | Stock | 169.85 | 169.87 | 169.7 | 169.7 | 14594.0 |
| 2023-10-30 04:00:00 | MSFT | Stock | 330.3 | 333.0 | 330.3 | 332.97 | 9014.0 |
| 2023-10-30 04:30:00 | MSFT | Stock | 332.62 | 332.64 | 332.6 | 332.6 | 1228.0 |
| 2023-10-30 05:00:00 | MSFT | Stock | 332.85 | 333.5 | 332.85 | 333.49 | 1808.0 |
| 2023-10-30 05:30:00 | MSFT | Stock | 333.55 | 333.55 | 333.25 | 333.4 | 1224.0 |
| 2023-10-30 06:00:00 | MSFT | Stock | 333.4 | 333.4 | 333.25 | 333.25 | 536.0 |
| 2023-10-30 06:30:00 | MSFT | Stock | 333.18 | 333.3 | 333.18 | 333.3 | 1434.0 |
| 2023-10-30 07:00:00 | MSFT | Stock | 333.47 | 333.47 | 332.59 | 332.75 | 8040.0 |
| 2023-10-30 07:30:00 | MSFT | Stock | 332.72 | 333.24 | 332.7 | 333.1 | 9603.0 |
| 2023-10-30 08:00:00 | MSFT | Stock | 333.37 | 333.7 | 331.0 | 333.32 | 48895.0 |
| 2023-10-30 08:30:00 | MSFT | Stock | 333.5 | 333.7 | 333.1 | 333.26 | 21124.0 |
| 2023-10-30 09:00:00 | MSFT | Stock | 333.27 | 333.43 | 332.85 | 333.26 | 31837.0 |
| 2023-10-30 09:30:00 | MSFT | Stock | 333.41 | 339.45 | 331.83 | 338.15 | 3249057.0 |
| 2023-10-30 10:00:00 | MSFT | Stock | 338.18 | 338.45 | 334.96 | 335.21 | 1511992.0 |
| 2023-10-30 10:30:00 | MSFT | Stock | 335.2 | 335.7 | 334.06 | 334.78 | 980151.0 |
| 2023-10-30 11:00:00 | MSFT | Stock | 334.74 | 336.41 | 334.02 | 334.705 | 945059.0 |
| 2023-10-30 11:30:00 | MSFT | Stock | 334.71 | 336.33 | 334.5 | 336.03 | 700441.0 |
| 2023-10-30 12:00:00 | MSFT | Stock | 336.044 | 336.05 | 334.79 | 335.0644 | 648778.0 |
| 2023-10-30 12:30:00 | MSFT | Stock | 335.1 | 335.8355 | 334.64 | 334.95 | 622513.0 |
> showing 50 of 96,288 rows — these rows as CSV