PREVIEW / stock_30min / 2023-10-02
file: by_date/stock_30min/2023/2023-10-02.parquet size: 2.0 MB rows: 97,630 symbols: 1,368
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-10-02 04:00:00 | AAPL | Stock | 172.7 | 172.91 | 172.4 | 172.54 | 11926.0 |
| 2023-10-02 04:30:00 | AAPL | Stock | 172.56 | 172.78 | 172.51 | 172.51 | 5368.0 |
| 2023-10-02 05:00:00 | AAPL | Stock | 172.5 | 172.5 | 171.9 | 171.9 | 20419.0 |
| 2023-10-02 05:30:00 | AAPL | Stock | 171.98 | 172.18 | 171.33 | 171.33 | 22174.0 |
| 2023-10-02 06:00:00 | AAPL | Stock | 171.42 | 171.61 | 171.03 | 171.3 | 8309.0 |
| 2023-10-02 06:30:00 | AAPL | Stock | 171.27 | 171.44 | 171.04 | 171.23 | 11656.0 |
| 2023-10-02 07:00:00 | AAPL | Stock | 171.37 | 171.97 | 171.25 | 171.95 | 24812.0 |
| 2023-10-02 07:30:00 | AAPL | Stock | 171.9 | 171.94 | 171.29 | 171.55 | 25575.0 |
| 2023-10-02 08:00:00 | AAPL | Stock | 171.38 | 172.99 | 171.06 | 171.31 | 105011.0 |
| 2023-10-02 08:30:00 | AAPL | Stock | 171.34 | 171.55 | 171.21 | 171.3 | 27541.0 |
| 2023-10-02 09:00:00 | AAPL | Stock | 171.26 | 171.5 | 171.0 | 171.22 | 117207.0 |
| 2023-10-02 09:30:00 | AAPL | Stock | 171.29 | 173.25 | 170.93 | 172.94 | 5874989.0 |
| 2023-10-02 10:00:00 | AAPL | Stock | 172.94 | 174.04 | 172.8 | 173.33 | 4524992.0 |
| 2023-10-02 10:30:00 | AAPL | Stock | 173.35 | 173.78 | 172.84 | 173.009 | 3008332.0 |
| 2023-10-02 11:00:00 | AAPL | Stock | 173.01 | 174.3 | 172.955 | 174.1046 | 2887410.0 |
| 2023-10-02 11:30:00 | AAPL | Stock | 174.12 | 174.21 | 172.905 | 173.08 | 2462957.0 |
| 2023-10-02 12:00:00 | AAPL | Stock | 173.09 | 173.53 | 172.82 | 173.35 | 1997833.0 |
| 2023-10-02 12:30:00 | AAPL | Stock | 173.36 | 173.47 | 173.02 | 173.18 | 1405638.0 |
| 2023-10-02 13:00:00 | AAPL | Stock | 173.185 | 173.405 | 172.73 | 173.31 | 1699981.0 |
| 2023-10-02 13:30:00 | AAPL | Stock | 173.31 | 173.5799 | 173.11 | 173.13 | 1468205.0 |
| 2023-10-02 14:00:00 | AAPL | Stock | 173.13 | 173.71 | 172.77 | 172.782 | 2142377.0 |
| 2023-10-02 14:30:00 | AAPL | Stock | 172.7907 | 173.03 | 172.61 | 172.89 | 1544682.0 |
| 2023-10-02 15:00:00 | AAPL | Stock | 172.88 | 173.21 | 172.533 | 173.0 | 2064301.0 |
| 2023-10-02 15:30:00 | AAPL | Stock | 173.0 | 173.78 | 172.75 | 173.75 | 5568604.0 |
| 2023-10-02 16:00:00 | AAPL | Stock | 173.75 | 173.96 | 171.21 | 173.76 | 5576042.0 |
| 2023-10-02 16:30:00 | AAPL | Stock | 173.76 | 173.84 | 173.63 | 173.73 | 110777.0 |
| 2023-10-02 17:00:00 | AAPL | Stock | 173.75 | 173.78 | 173.64 | 173.64 | 19360.0 |
| 2023-10-02 17:30:00 | AAPL | Stock | 173.71 | 173.74 | 173.65 | 173.65 | 5005.0 |
| 2023-10-02 18:00:00 | AAPL | Stock | 173.69 | 173.86 | 173.65 | 173.84 | 8569.0 |
| 2023-10-02 18:30:00 | AAPL | Stock | 173.75 | 173.87 | 173.7 | 173.7 | 7339.0 |
| 2023-10-02 19:00:00 | AAPL | Stock | 173.75 | 173.75 | 173.63 | 173.63 | 11002.0 |
| 2023-10-02 19:30:00 | AAPL | Stock | 173.68 | 173.94 | 173.63 | 173.82 | 13189.0 |
| 2023-10-02 04:00:00 | MSFT | Stock | 317.5 | 318.83 | 317.5 | 318.49 | 833.0 |
| 2023-10-02 04:30:00 | MSFT | Stock | 318.65 | 318.65 | 318.65 | 318.65 | 187.0 |
| 2023-10-02 05:00:00 | MSFT | Stock | 318.3 | 318.3 | 317.67 | 317.67 | 1400.0 |
| 2023-10-02 05:30:00 | MSFT | Stock | 318.0 | 318.2 | 316.03 | 316.1 | 2579.0 |
| 2023-10-02 06:00:00 | MSFT | Stock | 316.81 | 317.18 | 316.02 | 316.92 | 2510.0 |
| 2023-10-02 06:30:00 | MSFT | Stock | 317.05 | 317.57 | 317.02 | 317.07 | 3243.0 |
| 2023-10-02 07:00:00 | MSFT | Stock | 317.2 | 317.38 | 316.82 | 317.38 | 2035.0 |
| 2023-10-02 07:30:00 | MSFT | Stock | 317.02 | 317.02 | 316.35 | 316.4 | 14321.0 |
| 2023-10-02 08:00:00 | MSFT | Stock | 316.4 | 318.88 | 315.7 | 315.7 | 19192.0 |
| 2023-10-02 08:30:00 | MSFT | Stock | 316.2 | 316.21 | 315.5 | 315.89 | 11908.0 |
| 2023-10-02 09:00:00 | MSFT | Stock | 315.89 | 316.7 | 315.46 | 316.38 | 100950.0 |
| 2023-10-02 09:30:00 | MSFT | Stock | 316.31 | 318.715 | 315.18 | 316.95 | 1802831.0 |
| 2023-10-02 10:00:00 | MSFT | Stock | 317.0 | 319.0372 | 316.8 | 318.26 | 1239874.0 |
| 2023-10-02 10:30:00 | MSFT | Stock | 318.32 | 318.69 | 317.13 | 317.73 | 831866.0 |
| 2023-10-02 11:00:00 | MSFT | Stock | 317.75 | 321.39 | 317.64 | 320.96 | 1225368.0 |
| 2023-10-02 11:30:00 | MSFT | Stock | 321.0 | 321.17 | 318.3 | 318.58 | 882374.0 |
| 2023-10-02 12:00:00 | MSFT | Stock | 318.61 | 319.1 | 317.83 | 318.58 | 564575.0 |
| 2023-10-02 12:30:00 | MSFT | Stock | 318.545 | 318.95 | 318.02 | 318.195 | 444355.0 |
> showing 50 of 97,630 rows — these rows as CSV