PREVIEW / stock_30min / 2024-02-21
file: by_date/stock_30min/2024/2024-02-21.parquet size: 2.1 MB rows: 100,242 symbols: 1,127
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-02-21 04:00:00 | AAPL | Stock | 181.55 | 181.55 | 180.85 | 180.98 | 7749.0 |
| 2024-02-21 04:30:00 | AAPL | Stock | 180.98 | 181.18 | 180.96 | 181.03 | 2210.0 |
| 2024-02-21 05:00:00 | AAPL | Stock | 181.03 | 181.58 | 181.03 | 181.56 | 4875.0 |
| 2024-02-21 05:30:00 | AAPL | Stock | 181.51 | 181.77 | 181.5 | 181.76 | 7360.0 |
| 2024-02-21 06:00:00 | AAPL | Stock | 181.76 | 181.77 | 181.55 | 181.57 | 8298.0 |
| 2024-02-21 06:30:00 | AAPL | Stock | 181.57 | 181.6 | 181.5 | 181.5 | 2564.0 |
| 2024-02-21 07:00:00 | AAPL | Stock | 181.5 | 181.97 | 181.39 | 181.91 | 26300.0 |
| 2024-02-21 07:30:00 | AAPL | Stock | 181.83 | 181.89 | 181.6 | 181.6 | 12439.0 |
| 2024-02-21 08:00:00 | AAPL | Stock | 181.66 | 181.95 | 181.2449 | 181.7 | 58634.0 |
| 2024-02-21 08:30:00 | AAPL | Stock | 181.56 | 181.8499 | 181.4 | 181.79 | 28853.0 |
| 2024-02-21 09:00:00 | AAPL | Stock | 181.8 | 182.57 | 181.45 | 182.09 | 63183.0 |
| 2024-02-21 09:30:00 | AAPL | Stock | 181.94 | 182.8888 | 181.53 | 182.54 | 4658306.0 |
| 2024-02-21 10:00:00 | AAPL | Stock | 182.54 | 182.85 | 182.17 | 182.56 | 2500779.0 |
| 2024-02-21 10:30:00 | AAPL | Stock | 182.56 | 182.65 | 182.13 | 182.16 | 1843620.0 |
| 2024-02-21 11:00:00 | AAPL | Stock | 182.16 | 182.59 | 182.07 | 182.155 | 1699733.0 |
| 2024-02-21 11:30:00 | AAPL | Stock | 182.15 | 182.33 | 181.98 | 182.12 | 1532409.0 |
| 2024-02-21 12:00:00 | AAPL | Stock | 182.12 | 182.125 | 181.36 | 181.39 | 1554884.0 |
| 2024-02-21 12:30:00 | AAPL | Stock | 181.39 | 181.58 | 181.18 | 181.5399 | 1204229.0 |
| 2024-02-21 13:00:00 | AAPL | Stock | 181.53 | 181.725 | 181.06 | 181.42 | 1519890.0 |
| 2024-02-21 13:30:00 | AAPL | Stock | 181.43 | 181.52 | 181.265 | 181.2935 | 1058780.0 |
| 2024-02-21 14:00:00 | AAPL | Stock | 181.2921 | 181.47 | 180.66 | 180.95 | 1841640.0 |
| 2024-02-21 14:30:00 | AAPL | Stock | 180.95 | 181.13 | 180.765 | 181.02 | 1564624.0 |
| 2024-02-21 15:00:00 | AAPL | Stock | 181.01 | 181.305 | 180.96 | 181.205 | 1588889.0 |
| 2024-02-21 15:30:00 | AAPL | Stock | 181.21 | 182.39 | 181.205 | 182.32 | 3962672.0 |
| 2024-02-21 16:00:00 | AAPL | Stock | 182.33 | 182.39 | 181.55 | 182.39 | 4330004.0 |
| 2024-02-21 16:30:00 | AAPL | Stock | 182.39 | 182.66 | 182.1 | 182.55 | 134595.0 |
| 2024-02-21 17:00:00 | AAPL | Stock | 182.59 | 182.59 | 182.1 | 182.35 | 67551.0 |
| 2024-02-21 17:30:00 | AAPL | Stock | 182.36 | 182.5 | 182.3 | 182.37 | 21158.0 |
| 2024-02-21 18:00:00 | AAPL | Stock | 182.56 | 182.7502 | 182.11 | 182.7502 | 409033.0 |
| 2024-02-21 18:30:00 | AAPL | Stock | 182.75 | 182.79 | 182.3535 | 182.47 | 38395.0 |
| 2024-02-21 19:00:00 | AAPL | Stock | 182.47 | 182.79 | 182.42 | 182.75 | 17351.0 |
| 2024-02-21 19:30:00 | AAPL | Stock | 182.78 | 182.98 | 182.51 | 182.98 | 47614.0 |
| 2024-02-21 04:00:00 | MSFT | Stock | 400.86 | 401.64 | 400.86 | 401.0 | 1217.0 |
| 2024-02-21 04:30:00 | MSFT | Stock | 400.97 | 401.25 | 400.97 | 401.02 | 1900.0 |
| 2024-02-21 05:00:00 | MSFT | Stock | 401.19 | 401.78 | 401.19 | 401.78 | 1351.0 |
| 2024-02-21 05:30:00 | MSFT | Stock | 401.15 | 401.15 | 401.02 | 401.02 | 365.0 |
| 2024-02-21 06:00:00 | MSFT | Stock | 401.26 | 401.26 | 400.63 | 400.63 | 887.0 |
| 2024-02-21 07:00:00 | MSFT | Stock | 400.89 | 400.89 | 400.08 | 400.58 | 2956.0 |
| 2024-02-21 07:30:00 | MSFT | Stock | 400.47 | 400.47 | 399.7 | 399.72 | 4820.0 |
| 2024-02-21 08:00:00 | MSFT | Stock | 400.89 | 401.18 | 399.72 | 400.25 | 15870.0 |
| 2024-02-21 08:30:00 | MSFT | Stock | 400.0 | 400.106 | 399.67 | 399.94 | 9542.0 |
| 2024-02-21 09:00:00 | MSFT | Stock | 399.99 | 400.16 | 399.28 | 400.0 | 27840.0 |
| 2024-02-21 09:30:00 | MSFT | Stock | 400.0 | 400.49 | 397.22 | 398.81 | 2062416.0 |
| 2024-02-21 10:00:00 | MSFT | Stock | 398.81 | 400.47 | 398.73 | 399.41 | 784084.0 |
| 2024-02-21 10:30:00 | MSFT | Stock | 399.38 | 400.01 | 398.73 | 399.79 | 550820.0 |
| 2024-02-21 11:00:00 | MSFT | Stock | 399.766 | 400.71 | 399.174 | 399.81 | 555682.0 |
| 2024-02-21 11:30:00 | MSFT | Stock | 399.81 | 400.15 | 399.545 | 400.02 | 327693.0 |
| 2024-02-21 12:00:00 | MSFT | Stock | 400.05 | 400.16 | 399.02 | 399.29 | 343512.0 |
| 2024-02-21 12:30:00 | MSFT | Stock | 399.3 | 399.675 | 398.71 | 399.58 | 333539.0 |
| 2024-02-21 13:00:00 | MSFT | Stock | 399.57 | 400.0 | 398.61 | 399.035 | 465980.0 |
> showing 50 of 100,242 rows — these rows as CSV