PREVIEW / stock_30min / 2024-08-06
file: by_date/stock_30min/2024/2024-08-06.parquet size: 2.1 MB rows: 101,337 symbols: 878
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-06 04:00:00 | AAPL | Stock | 211.84 | 212.84 | 210.01 | 210.7 | 53734.0 |
| 2024-08-06 04:30:00 | AAPL | Stock | 210.55 | 210.69 | 210.1 | 210.33 | 11664.0 |
| 2024-08-06 05:00:00 | AAPL | Stock | 210.32 | 210.32 | 209.31 | 209.41 | 26520.0 |
| 2024-08-06 05:30:00 | AAPL | Stock | 209.5 | 209.59 | 208.23 | 209.21 | 12739.0 |
| 2024-08-06 06:00:00 | AAPL | Stock | 209.02 | 209.02 | 207.85 | 208.47 | 35637.0 |
| 2024-08-06 06:30:00 | AAPL | Stock | 208.46 | 208.8 | 208.1 | 208.5 | 29708.0 |
| 2024-08-06 07:00:00 | AAPL | Stock | 208.45 | 209.25 | 208.28 | 208.77 | 68729.0 |
| 2024-08-06 07:30:00 | AAPL | Stock | 208.8 | 209.14 | 207.2 | 207.74 | 57302.0 |
| 2024-08-06 08:00:00 | AAPL | Stock | 208.9 | 214.8 | 206.6301 | 207.0 | 207002.0 |
| 2024-08-06 08:30:00 | AAPL | Stock | 206.8201 | 206.92 | 205.3 | 205.8907 | 202422.0 |
| 2024-08-06 09:00:00 | AAPL | Stock | 206.0 | 206.9 | 205.3 | 205.3 | 273119.0 |
| 2024-08-06 09:30:00 | AAPL | Stock | 205.31 | 206.25 | 201.07 | 203.19 | 10561915.0 |
| 2024-08-06 10:00:00 | AAPL | Stock | 203.19 | 205.8 | 202.43 | 204.8901 | 4831313.0 |
| 2024-08-06 10:30:00 | AAPL | Stock | 204.98 | 207.68 | 204.37 | 207.546 | 3570587.0 |
| 2024-08-06 11:00:00 | AAPL | Stock | 207.52 | 207.7395 | 206.03 | 206.11 | 2578546.0 |
| 2024-08-06 11:30:00 | AAPL | Stock | 206.12 | 208.5596 | 206.06 | 208.45 | 2705783.0 |
| 2024-08-06 12:00:00 | AAPL | Stock | 208.46 | 208.99 | 208.27 | 208.631 | 1977977.0 |
| 2024-08-06 12:30:00 | AAPL | Stock | 208.67 | 209.99 | 208.36 | 209.7 | 1971023.0 |
| 2024-08-06 13:00:00 | AAPL | Stock | 209.69 | 209.72 | 208.52 | 208.99 | 1586723.0 |
| 2024-08-06 13:30:00 | AAPL | Stock | 208.99 | 209.185 | 208.33 | 208.51 | 1533096.0 |
| 2024-08-06 14:00:00 | AAPL | Stock | 208.51 | 209.4799 | 207.705 | 209.4464 | 2078474.0 |
| 2024-08-06 14:30:00 | AAPL | Stock | 209.45 | 209.95 | 208.7 | 208.78 | 1666154.0 |
| 2024-08-06 15:00:00 | AAPL | Stock | 208.74 | 208.83 | 207.4 | 208.505 | 2387475.0 |
| 2024-08-06 15:30:00 | AAPL | Stock | 208.505 | 208.59 | 206.4 | 207.125 | 4714202.0 |
| 2024-08-06 16:00:00 | AAPL | Stock | 207.23 | 207.24 | 205.8701 | 206.12 | 6557093.0 |
| 2024-08-06 16:30:00 | AAPL | Stock | 206.2 | 207.23 | 205.5 | 205.5 | 84995.0 |
| 2024-08-06 17:00:00 | AAPL | Stock | 205.5 | 207.23 | 205.1 | 205.41 | 53257.0 |
| 2024-08-06 17:30:00 | AAPL | Stock | 205.31 | 207.23 | 204.7195 | 204.93 | 87725.0 |
| 2024-08-06 18:00:00 | AAPL | Stock | 205.0 | 206.82 | 204.9 | 206.0 | 47861.0 |
| 2024-08-06 18:30:00 | AAPL | Stock | 206.2537 | 206.3399 | 205.27 | 205.83 | 10782.0 |
| 2024-08-06 19:00:00 | AAPL | Stock | 206.16 | 206.4997 | 205.82 | 206.0 | 18703.0 |
| 2024-08-06 19:30:00 | AAPL | Stock | 206.0 | 206.37 | 205.0 | 205.01 | 20011.0 |
| 2024-08-06 04:00:00 | MSFT | Stock | 402.03 | 402.03 | 399.4 | 400.7 | 14628.0 |
| 2024-08-06 04:30:00 | MSFT | Stock | 400.1 | 400.89 | 399.65 | 400.5 | 2260.0 |
| 2024-08-06 05:00:00 | MSFT | Stock | 399.5 | 399.5 | 396.96 | 398.19 | 5849.0 |
| 2024-08-06 05:30:00 | MSFT | Stock | 398.2 | 398.2 | 396.35 | 398.06 | 3873.0 |
| 2024-08-06 06:00:00 | MSFT | Stock | 397.98 | 398.89 | 397.78 | 398.83 | 2540.0 |
| 2024-08-06 06:30:00 | MSFT | Stock | 398.99 | 400.42 | 398.99 | 400.42 | 2451.0 |
| 2024-08-06 07:00:00 | MSFT | Stock | 400.62 | 401.15 | 399.12 | 399.75 | 20181.0 |
| 2024-08-06 07:30:00 | MSFT | Stock | 399.96 | 400.56 | 399.22 | 400.25 | 18325.0 |
| 2024-08-06 08:00:00 | MSFT | Stock | 400.5 | 403.3 | 396.137 | 399.6979 | 51618.0 |
| 2024-08-06 08:30:00 | MSFT | Stock | 399.5 | 399.6913 | 398.21 | 398.9 | 18084.0 |
| 2024-08-06 09:00:00 | MSFT | Stock | 398.71 | 402.0 | 397.5 | 400.25 | 66291.0 |
| 2024-08-06 09:30:00 | MSFT | Stock | 400.01 | 402.705 | 398.5 | 400.48 | 2492305.0 |
| 2024-08-06 10:00:00 | MSFT | Stock | 400.48 | 403.23 | 399.67 | 401.895 | 941787.0 |
| 2024-08-06 10:30:00 | MSFT | Stock | 401.895 | 404.68 | 401.31 | 403.92 | 1160072.0 |
| 2024-08-06 11:00:00 | MSFT | Stock | 403.95 | 404.98 | 401.11 | 401.24 | 774172.0 |
| 2024-08-06 11:30:00 | MSFT | Stock | 401.185 | 404.97 | 401.15 | 404.743 | 505954.0 |
| 2024-08-06 12:00:00 | MSFT | Stock | 404.76 | 405.58 | 403.65 | 403.995 | 502691.0 |
| 2024-08-06 12:30:00 | MSFT | Stock | 404.05 | 405.67 | 403.22 | 404.83 | 481330.0 |
> showing 50 of 101,337 rows — these rows as CSV