PREVIEW / stock_30min / 2023-05-31
file: by_date/stock_30min/2023/2023-05-31.parquet size: 2.1 MB rows: 102,196 symbols: 1,628
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-05-31 04:00:00 | AAPL | Stock | 177.48 | 177.48 | 176.67 | 176.7 | 9093.0 |
| 2023-05-31 04:30:00 | AAPL | Stock | 176.69 | 176.69 | 176.45 | 176.69 | 5639.0 |
| 2023-05-31 05:00:00 | AAPL | Stock | 176.7 | 176.86 | 176.67 | 176.79 | 7685.0 |
| 2023-05-31 05:30:00 | AAPL | Stock | 176.7 | 176.92 | 176.62 | 176.85 | 2425.0 |
| 2023-05-31 06:00:00 | AAPL | Stock | 176.81 | 176.86 | 176.72 | 176.73 | 7457.0 |
| 2023-05-31 06:30:00 | AAPL | Stock | 176.72 | 177.36 | 176.72 | 177.29 | 15867.0 |
| 2023-05-31 07:00:00 | AAPL | Stock | 177.37 | 177.5 | 177.2 | 177.25 | 18301.0 |
| 2023-05-31 07:30:00 | AAPL | Stock | 177.25 | 177.35 | 176.95 | 177.1 | 22270.0 |
| 2023-05-31 08:00:00 | AAPL | Stock | 177.46 | 177.49 | 176.5 | 176.78 | 59660.0 |
| 2023-05-31 08:30:00 | AAPL | Stock | 176.78 | 177.1 | 176.77 | 176.82 | 40913.0 |
| 2023-05-31 09:00:00 | AAPL | Stock | 176.86 | 177.39 | 176.53 | 177.31 | 105345.0 |
| 2023-05-31 09:30:00 | AAPL | Stock | 177.31 | 179.09 | 177.05 | 178.95 | 7083931.0 |
| 2023-05-31 10:00:00 | AAPL | Stock | 178.97 | 179.35 | 177.72 | 177.895 | 5862368.0 |
| 2023-05-31 10:30:00 | AAPL | Stock | 177.9 | 178.43 | 177.42 | 178.34 | 3695972.0 |
| 2023-05-31 11:00:00 | AAPL | Stock | 178.35 | 178.6 | 178.06 | 178.32 | 3100803.0 |
| 2023-05-31 11:30:00 | AAPL | Stock | 178.325 | 179.07 | 178.24 | 178.87 | 2936370.0 |
| 2023-05-31 12:00:00 | AAPL | Stock | 178.875 | 179.04 | 178.6 | 178.7427 | 2031033.0 |
| 2023-05-31 12:30:00 | AAPL | Stock | 178.75 | 179.0 | 178.46 | 178.73 | 2097194.0 |
| 2023-05-31 13:00:00 | AAPL | Stock | 178.74 | 178.89 | 178.56 | 178.89 | 1457003.0 |
| 2023-05-31 13:30:00 | AAPL | Stock | 178.9 | 179.3 | 178.74 | 179.06 | 2627329.0 |
| 2023-05-31 14:00:00 | AAPL | Stock | 179.065 | 179.29 | 178.815 | 179.1699 | 2054904.0 |
| 2023-05-31 14:30:00 | AAPL | Stock | 179.1699 | 179.2 | 178.55 | 178.75 | 2180064.0 |
| 2023-05-31 15:00:00 | AAPL | Stock | 178.76 | 178.79 | 178.292 | 178.7179 | 2341782.0 |
| 2023-05-31 15:30:00 | AAPL | Stock | 178.72 | 179.3 | 176.76 | 177.42 | 12578500.0 |
| 2023-05-31 16:00:00 | AAPL | Stock | 177.43 | 177.47 | 176.86 | 177.4 | 30012724.0 |
| 2023-05-31 16:30:00 | AAPL | Stock | 177.4 | 177.62 | 177.25 | 177.38 | 95597.0 |
| 2023-05-31 17:00:00 | AAPL | Stock | 177.35 | 177.6 | 177.35 | 177.51 | 57061.0 |
| 2023-05-31 17:30:00 | AAPL | Stock | 177.54 | 177.65 | 177.42 | 177.42 | 37593.0 |
| 2023-05-31 18:00:00 | AAPL | Stock | 177.46 | 177.57 | 177.35 | 177.57 | 18429.0 |
| 2023-05-31 18:30:00 | AAPL | Stock | 177.5017 | 177.57 | 177.42 | 177.5 | 10053.0 |
| 2023-05-31 19:00:00 | AAPL | Stock | 177.58 | 177.7 | 177.5 | 177.68 | 8652.0 |
| 2023-05-31 19:30:00 | AAPL | Stock | 177.66 | 177.76 | 177.57 | 177.76 | 26111.0 |
| 2023-05-31 04:00:00 | MSFT | Stock | 330.8 | 332.91 | 330.51 | 332.5 | 17674.0 |
| 2023-05-31 04:30:00 | MSFT | Stock | 332.5 | 332.5 | 331.79 | 332.15 | 2719.0 |
| 2023-05-31 05:00:00 | MSFT | Stock | 332.63 | 333.0 | 332.4 | 333.0 | 3959.0 |
| 2023-05-31 05:30:00 | MSFT | Stock | 332.55 | 332.8 | 332.55 | 332.55 | 2594.0 |
| 2023-05-31 06:00:00 | MSFT | Stock | 332.4 | 332.4 | 331.77 | 332.29 | 3219.0 |
| 2023-05-31 06:30:00 | MSFT | Stock | 332.04 | 332.8 | 331.61 | 332.75 | 3766.0 |
| 2023-05-31 07:00:00 | MSFT | Stock | 333.0 | 333.69 | 332.9 | 333.12 | 11536.0 |
| 2023-05-31 07:30:00 | MSFT | Stock | 333.2 | 333.25 | 332.06 | 332.44 | 11887.0 |
| 2023-05-31 08:00:00 | MSFT | Stock | 333.0 | 333.7 | 330.2 | 332.0 | 34946.0 |
| 2023-05-31 08:30:00 | MSFT | Stock | 332.04 | 332.19 | 331.9 | 331.95 | 27799.0 |
| 2023-05-31 09:00:00 | MSFT | Stock | 331.98 | 332.8797 | 331.28 | 332.3 | 65660.0 |
| 2023-05-31 09:30:00 | MSFT | Stock | 332.29 | 335.94 | 331.45 | 334.71 | 3535308.0 |
| 2023-05-31 10:00:00 | MSFT | Stock | 334.73 | 334.99 | 331.04 | 331.7508 | 1897231.0 |
| 2023-05-31 10:30:00 | MSFT | Stock | 331.765 | 332.55 | 330.85 | 331.56 | 1541518.0 |
| 2023-05-31 11:00:00 | MSFT | Stock | 331.615 | 331.68 | 328.91 | 329.5701 | 1489020.0 |
| 2023-05-31 11:30:00 | MSFT | Stock | 329.62 | 330.34 | 328.96 | 329.72 | 954229.0 |
| 2023-05-31 12:00:00 | MSFT | Stock | 329.72 | 330.06 | 328.17 | 328.48 | 959217.0 |
| 2023-05-31 12:30:00 | MSFT | Stock | 328.51 | 329.2001 | 327.33 | 328.97 | 984896.0 |
> showing 50 of 102,196 rows — these rows as CSV