PREVIEW / stock_30min / 2022-04-05
file: by_date/stock_30min/2022/2022-04-05.parquet size: 2.2 MB rows: 108,206 symbols: 2,489
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 |
|---|---|---|---|---|---|---|---|
| 2022-04-05 04:00:00 | AAPL | Stock | 178.66 | 178.66 | 178.4 | 178.41 | 10879.0 |
| 2022-04-05 04:30:00 | AAPL | Stock | 178.44 | 178.46 | 178.24 | 178.25 | 12807.0 |
| 2022-04-05 05:00:00 | AAPL | Stock | 178.13 | 178.13 | 177.74 | 177.79 | 13299.0 |
| 2022-04-05 05:30:00 | AAPL | Stock | 177.91 | 177.95 | 177.71 | 177.75 | 7650.0 |
| 2022-04-05 06:00:00 | AAPL | Stock | 177.7 | 178.1 | 177.7 | 177.84 | 11673.0 |
| 2022-04-05 06:30:00 | AAPL | Stock | 177.87 | 178.1 | 177.76 | 178.05 | 10512.0 |
| 2022-04-05 07:00:00 | AAPL | Stock | 178.05 | 178.11 | 177.84 | 178.06 | 33654.0 |
| 2022-04-05 07:30:00 | AAPL | Stock | 178.09 | 178.42 | 178.09 | 178.36 | 37388.0 |
| 2022-04-05 08:00:00 | AAPL | Stock | 177.9534 | 178.5 | 177.36 | 178.07 | 242079.0 |
| 2022-04-05 08:30:00 | AAPL | Stock | 178.03 | 178.21 | 177.87 | 177.96 | 175695.0 |
| 2022-04-05 09:00:00 | AAPL | Stock | 177.96 | 178.19 | 177.23 | 177.5 | 290819.0 |
| 2022-04-05 09:30:00 | AAPL | Stock | 177.55 | 178.3 | 177.05 | 177.63 | 8911097.0 |
| 2022-04-05 10:00:00 | AAPL | Stock | 177.63 | 178.13 | 176.21 | 176.9099 | 6771276.0 |
| 2022-04-05 10:30:00 | AAPL | Stock | 176.905 | 177.08 | 176.33 | 176.89 | 4436132.0 |
| 2022-04-05 11:00:00 | AAPL | Stock | 176.89 | 177.11 | 176.2 | 176.49 | 3636394.0 |
| 2022-04-05 11:30:00 | AAPL | Stock | 176.49 | 176.55 | 175.68 | 175.69 | 3324214.0 |
| 2022-04-05 12:00:00 | AAPL | Stock | 175.69 | 175.965 | 175.225 | 175.265 | 3401411.0 |
| 2022-04-05 12:30:00 | AAPL | Stock | 175.265 | 175.635 | 175.0 | 175.555 | 3120386.0 |
| 2022-04-05 13:00:00 | AAPL | Stock | 175.56 | 176.12 | 175.425 | 175.6491 | 3090722.0 |
| 2022-04-05 13:30:00 | AAPL | Stock | 175.6436 | 175.655 | 174.93 | 175.245 | 2634953.0 |
| 2022-04-05 14:00:00 | AAPL | Stock | 175.24 | 175.75 | 175.0916 | 175.38 | 2252829.0 |
| 2022-04-05 14:30:00 | AAPL | Stock | 175.38 | 175.49 | 174.99 | 175.055 | 2588591.0 |
| 2022-04-05 15:00:00 | AAPL | Stock | 175.06 | 175.15 | 174.415 | 174.86 | 4029659.0 |
| 2022-04-05 15:30:00 | AAPL | Stock | 174.85 | 175.22 | 174.44 | 175.04 | 6959403.0 |
| 2022-04-05 16:00:00 | AAPL | Stock | 175.09 | 175.5 | 174.94 | 175.09 | 6605593.0 |
| 2022-04-05 16:30:00 | AAPL | Stock | 175.09 | 175.34 | 174.98 | 175.33 | 176595.0 |
| 2022-04-05 17:00:00 | AAPL | Stock | 175.29 | 175.34 | 175.15 | 175.17 | 15000.0 |
| 2022-04-05 17:30:00 | AAPL | Stock | 175.17 | 175.28 | 175.15 | 175.17 | 12271.0 |
| 2022-04-05 18:00:00 | AAPL | Stock | 175.22 | 175.22 | 174.91 | 174.93 | 41009.0 |
| 2022-04-05 18:30:00 | AAPL | Stock | 174.94 | 175.15 | 174.94 | 175.11 | 18600.0 |
| 2022-04-05 19:00:00 | AAPL | Stock | 175.11 | 175.11 | 174.91 | 174.94 | 12899.0 |
| 2022-04-05 19:30:00 | AAPL | Stock | 174.94 | 175.15 | 174.88 | 175.0 | 15623.0 |
| 2022-04-05 04:00:00 | MSFT | Stock | 316.19 | 316.19 | 315.1 | 315.17 | 1673.0 |
| 2022-04-05 04:30:00 | MSFT | Stock | 315.1 | 315.3 | 315.04 | 315.04 | 2067.0 |
| 2022-04-05 05:00:00 | MSFT | Stock | 315.13 | 315.13 | 314.9 | 314.9 | 600.0 |
| 2022-04-05 05:30:00 | MSFT | Stock | 314.95 | 314.95 | 314.27 | 314.37 | 2284.0 |
| 2022-04-05 06:00:00 | MSFT | Stock | 314.87 | 315.08 | 314.35 | 314.35 | 2217.0 |
| 2022-04-05 06:30:00 | MSFT | Stock | 314.26 | 314.26 | 314.03 | 314.25 | 1200.0 |
| 2022-04-05 07:00:00 | MSFT | Stock | 314.76 | 314.95 | 314.52 | 314.52 | 1984.0 |
| 2022-04-05 07:30:00 | MSFT | Stock | 314.7 | 315.01 | 314.69 | 314.69 | 4745.0 |
| 2022-04-05 08:00:00 | MSFT | Stock | 314.5001 | 315.5 | 314.21 | 314.52 | 20136.0 |
| 2022-04-05 08:30:00 | MSFT | Stock | 314.3 | 314.3001 | 313.8 | 313.98 | 5304.0 |
| 2022-04-05 09:00:00 | MSFT | Stock | 313.94 | 314.18 | 312.09 | 313.25 | 58078.0 |
| 2022-04-05 09:30:00 | MSFT | Stock | 313.27 | 314.865 | 312.84 | 313.08 | 2111027.0 |
| 2022-04-05 10:00:00 | MSFT | Stock | 313.06 | 314.17 | 311.78 | 312.38 | 1338711.0 |
| 2022-04-05 10:30:00 | MSFT | Stock | 312.386 | 313.4317 | 311.7 | 313.0 | 968358.0 |
| 2022-04-05 11:00:00 | MSFT | Stock | 312.992 | 313.19 | 311.82 | 312.48 | 880686.0 |
| 2022-04-05 11:30:00 | MSFT | Stock | 312.47 | 312.64 | 311.55 | 311.87 | 757289.0 |
| 2022-04-05 12:00:00 | MSFT | Stock | 311.89 | 312.1723 | 310.56 | 310.67 | 851903.0 |
| 2022-04-05 12:30:00 | MSFT | Stock | 310.67 | 311.99 | 310.6 | 311.78 | 657846.0 |
> showing 50 of 108,206 rows — these rows as CSV