PREVIEW / stock_30min / 2023-05-02
file: by_date/stock_30min/2023/2023-05-02.parquet size: 2.1 MB rows: 102,844 symbols: 1,664
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-02 04:00:00 | AAPL | Stock | 169.9 | 169.9 | 169.43 | 169.44 | 10271.0 |
| 2023-05-02 04:30:00 | AAPL | Stock | 169.5 | 169.79 | 169.48 | 169.54 | 2356.0 |
| 2023-05-02 05:00:00 | AAPL | Stock | 169.57 | 169.57 | 169.54 | 169.54 | 980.0 |
| 2023-05-02 05:30:00 | AAPL | Stock | 169.55 | 169.78 | 169.55 | 169.67 | 4859.0 |
| 2023-05-02 06:00:00 | AAPL | Stock | 169.62 | 169.77 | 169.59 | 169.77 | 6470.0 |
| 2023-05-02 06:30:00 | AAPL | Stock | 169.82 | 169.88 | 169.65 | 169.88 | 3249.0 |
| 2023-05-02 07:00:00 | AAPL | Stock | 169.72 | 169.87 | 169.6 | 169.61 | 20946.0 |
| 2023-05-02 07:30:00 | AAPL | Stock | 169.6 | 169.82 | 169.6 | 169.8 | 8123.0 |
| 2023-05-02 08:00:00 | AAPL | Stock | 169.7805 | 170.03 | 169.14 | 169.8 | 77078.0 |
| 2023-05-02 08:30:00 | AAPL | Stock | 169.8 | 169.95 | 169.71 | 169.7789 | 61902.0 |
| 2023-05-02 09:00:00 | AAPL | Stock | 169.7757 | 170.1 | 169.7 | 170.09 | 87614.0 |
| 2023-05-02 09:30:00 | AAPL | Stock | 170.08 | 170.35 | 169.4107 | 169.77 | 4969648.0 |
| 2023-05-02 10:00:00 | AAPL | Stock | 169.8 | 169.9338 | 168.4801 | 168.71 | 4054085.0 |
| 2023-05-02 10:30:00 | AAPL | Stock | 168.72 | 168.73 | 168.02 | 168.27 | 3217121.0 |
| 2023-05-02 11:00:00 | AAPL | Stock | 168.26 | 168.3768 | 167.7 | 167.8169 | 3179493.0 |
| 2023-05-02 11:30:00 | AAPL | Stock | 167.82 | 168.2299 | 167.54 | 167.63 | 2866624.0 |
| 2023-05-02 12:00:00 | AAPL | Stock | 167.62 | 168.2 | 167.55 | 168.1101 | 1662933.0 |
| 2023-05-02 12:30:00 | AAPL | Stock | 168.11 | 168.52 | 168.0852 | 168.39 | 1799664.0 |
| 2023-05-02 13:00:00 | AAPL | Stock | 168.38 | 168.9299 | 168.33 | 168.81 | 2030438.0 |
| 2023-05-02 13:30:00 | AAPL | Stock | 168.8 | 168.95 | 168.58 | 168.6758 | 1536034.0 |
| 2023-05-02 14:00:00 | AAPL | Stock | 168.68 | 168.765 | 168.345 | 168.47 | 1455848.0 |
| 2023-05-02 14:30:00 | AAPL | Stock | 168.47 | 169.05 | 168.46 | 169.03 | 1455703.0 |
| 2023-05-02 15:00:00 | AAPL | Stock | 169.03 | 169.28 | 168.88 | 168.965 | 2075709.0 |
| 2023-05-02 15:30:00 | AAPL | Stock | 168.97 | 168.98 | 168.39 | 168.55 | 3901677.0 |
| 2023-05-02 16:00:00 | AAPL | Stock | 168.54 | 168.63 | 168.3 | 168.4 | 6397603.0 |
| 2023-05-02 16:30:00 | AAPL | Stock | 168.43 | 168.54 | 168.33 | 168.41 | 34754.0 |
| 2023-05-02 17:00:00 | AAPL | Stock | 168.4201 | 168.49 | 168.38 | 168.43 | 15765.0 |
| 2023-05-02 17:30:00 | AAPL | Stock | 168.43 | 168.45 | 168.32 | 168.37 | 6191.0 |
| 2023-05-02 18:00:00 | AAPL | Stock | 168.38 | 168.5 | 168.37 | 168.44 | 16225.0 |
| 2023-05-02 18:30:00 | AAPL | Stock | 168.46 | 168.47 | 168.3 | 168.35 | 21300.0 |
| 2023-05-02 19:00:00 | AAPL | Stock | 168.28 | 168.55 | 168.26 | 168.55 | 20287.0 |
| 2023-05-02 19:30:00 | AAPL | Stock | 168.54 | 168.6 | 168.49 | 168.6 | 20161.0 |
| 2023-05-02 04:00:00 | MSFT | Stock | 305.9 | 306.9 | 305.74 | 306.3 | 4284.0 |
| 2023-05-02 04:30:00 | MSFT | Stock | 306.4 | 306.75 | 306.2 | 306.23 | 892.0 |
| 2023-05-02 05:00:00 | MSFT | Stock | 306.3 | 306.49 | 306.3 | 306.48 | 403.0 |
| 2023-05-02 05:30:00 | MSFT | Stock | 306.43 | 306.66 | 306.43 | 306.66 | 405.0 |
| 2023-05-02 06:00:00 | MSFT | Stock | 306.43 | 306.55 | 306.38 | 306.53 | 513.0 |
| 2023-05-02 06:30:00 | MSFT | Stock | 306.46 | 306.46 | 306.46 | 306.46 | 100.0 |
| 2023-05-02 07:00:00 | MSFT | Stock | 306.41 | 306.74 | 306.2 | 306.4 | 4209.0 |
| 2023-05-02 07:30:00 | MSFT | Stock | 306.35 | 306.43 | 306.27 | 306.4 | 1794.0 |
| 2023-05-02 08:00:00 | MSFT | Stock | 306.3 | 306.75 | 304.65 | 306.2 | 18707.0 |
| 2023-05-02 08:30:00 | MSFT | Stock | 306.2 | 306.65 | 306.06 | 306.4 | 9771.0 |
| 2023-05-02 09:00:00 | MSFT | Stock | 306.4 | 308.21 | 306.4 | 307.86 | 90005.0 |
| 2023-05-02 09:30:00 | MSFT | Stock | 307.77 | 308.89 | 306.25 | 308.08 | 3324632.0 |
| 2023-05-02 10:00:00 | MSFT | Stock | 308.11 | 309.18 | 306.25 | 306.41 | 2223725.0 |
| 2023-05-02 10:30:00 | MSFT | Stock | 306.37 | 306.37 | 305.04 | 305.25 | 1532241.0 |
| 2023-05-02 11:00:00 | MSFT | Stock | 305.22 | 305.405 | 304.45 | 305.1 | 1259490.0 |
| 2023-05-02 11:30:00 | MSFT | Stock | 305.09 | 305.46 | 303.91 | 304.185 | 1059283.0 |
| 2023-05-02 12:00:00 | MSFT | Stock | 304.14 | 304.89 | 303.99 | 304.75 | 732298.0 |
| 2023-05-02 12:30:00 | MSFT | Stock | 304.74 | 305.49 | 304.68 | 305.1 | 588169.0 |
> showing 50 of 102,844 rows — these rows as CSV