PREVIEW / stock_30min / 2022-08-03
file: by_date/stock_30min/2022/2022-08-03.parquet size: 2.2 MB rows: 108,204 symbols: 2,335
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-08-03 04:00:00 | AAPL | Stock | 160.28 | 160.3 | 159.84 | 160.25 | 19068.0 |
| 2022-08-03 04:30:00 | AAPL | Stock | 160.25 | 160.43 | 160.25 | 160.32 | 6772.0 |
| 2022-08-03 05:00:00 | AAPL | Stock | 160.28 | 160.88 | 160.24 | 160.85 | 17125.0 |
| 2022-08-03 05:30:00 | AAPL | Stock | 160.86 | 161.14 | 160.83 | 160.93 | 7921.0 |
| 2022-08-03 06:00:00 | AAPL | Stock | 160.99 | 161.0 | 160.8 | 160.8 | 6904.0 |
| 2022-08-03 06:30:00 | AAPL | Stock | 160.89 | 160.89 | 160.73 | 160.8 | 1485.0 |
| 2022-08-03 07:00:00 | AAPL | Stock | 160.84 | 161.31 | 160.84 | 161.23 | 30978.0 |
| 2022-08-03 07:30:00 | AAPL | Stock | 161.23 | 161.29 | 160.98 | 161.21 | 23598.0 |
| 2022-08-03 08:00:00 | AAPL | Stock | 160.9443 | 161.53 | 159.61 | 161.5 | 242895.0 |
| 2022-08-03 08:30:00 | AAPL | Stock | 161.49 | 161.66 | 161.4 | 161.5 | 164872.0 |
| 2022-08-03 09:00:00 | AAPL | Stock | 161.5 | 161.74 | 160.01 | 160.94 | 294965.0 |
| 2022-08-03 09:30:00 | AAPL | Stock | 160.84 | 163.32 | 160.75 | 163.24 | 8175851.0 |
| 2022-08-03 10:00:00 | AAPL | Stock | 163.24 | 164.43 | 162.83 | 163.9 | 6054179.0 |
| 2022-08-03 10:30:00 | AAPL | Stock | 163.89 | 164.085 | 163.309 | 164.03 | 3865306.0 |
| 2022-08-03 11:00:00 | AAPL | Stock | 164.03 | 164.84 | 164.005 | 164.54 | 4339781.0 |
| 2022-08-03 11:30:00 | AAPL | Stock | 164.55 | 165.185 | 164.41 | 165.0758 | 4540325.0 |
| 2022-08-03 12:00:00 | AAPL | Stock | 165.08 | 165.1 | 164.455 | 164.98 | 2775191.0 |
| 2022-08-03 12:30:00 | AAPL | Stock | 164.9799 | 166.04 | 164.945 | 165.87 | 4761447.0 |
| 2022-08-03 13:00:00 | AAPL | Stock | 165.86 | 166.44 | 165.62 | 165.8616 | 4617749.0 |
| 2022-08-03 13:30:00 | AAPL | Stock | 165.87 | 166.25 | 165.7201 | 166.08 | 2865204.0 |
| 2022-08-03 14:00:00 | AAPL | Stock | 166.075 | 166.56 | 166.01 | 166.26 | 2864240.0 |
| 2022-08-03 14:30:00 | AAPL | Stock | 166.26 | 166.39 | 166.01 | 166.13 | 2898276.0 |
| 2022-08-03 15:00:00 | AAPL | Stock | 166.13 | 166.29 | 165.81 | 166.045 | 3553167.0 |
| 2022-08-03 15:30:00 | AAPL | Stock | 166.04 | 166.59 | 165.89 | 166.1299 | 7799884.0 |
| 2022-08-03 16:00:00 | AAPL | Stock | 166.13 | 166.15 | 165.63 | 165.86 | 8993365.0 |
| 2022-08-03 16:30:00 | AAPL | Stock | 165.8535 | 166.13 | 165.82 | 166.13 | 84347.0 |
| 2022-08-03 17:00:00 | AAPL | Stock | 165.9002 | 165.93 | 165.8 | 165.88 | 20257.0 |
| 2022-08-03 17:30:00 | AAPL | Stock | 165.82 | 165.87 | 165.8 | 165.83 | 6718.0 |
| 2022-08-03 18:00:00 | AAPL | Stock | 165.82 | 165.84 | 165.69 | 165.78 | 9256.0 |
| 2022-08-03 18:30:00 | AAPL | Stock | 165.78 | 165.87 | 165.64 | 165.77 | 10662.0 |
| 2022-08-03 19:00:00 | AAPL | Stock | 165.75 | 165.82 | 165.73 | 165.79 | 8541.0 |
| 2022-08-03 19:30:00 | AAPL | Stock | 165.73 | 165.84 | 165.73 | 165.84 | 26768.0 |
| 2022-08-03 04:00:00 | MSFT | Stock | 274.75 | 274.75 | 274.75 | 274.75 | 100.0 |
| 2022-08-03 04:30:00 | MSFT | Stock | 274.95 | 275.0 | 274.95 | 275.0 | 480.0 |
| 2022-08-03 05:00:00 | MSFT | Stock | 275.19 | 276.3 | 275.19 | 276.2 | 1351.0 |
| 2022-08-03 05:30:00 | MSFT | Stock | 276.16 | 276.18 | 276.16 | 276.18 | 355.0 |
| 2022-08-03 06:00:00 | MSFT | Stock | 276.17 | 276.17 | 276.14 | 276.14 | 951.0 |
| 2022-08-03 06:30:00 | MSFT | Stock | 276.07 | 276.07 | 276.07 | 276.07 | 126.0 |
| 2022-08-03 07:00:00 | MSFT | Stock | 275.9 | 276.5 | 275.9 | 275.99 | 3105.0 |
| 2022-08-03 07:30:00 | MSFT | Stock | 276.2 | 276.2 | 275.62 | 275.9 | 2573.0 |
| 2022-08-03 08:00:00 | MSFT | Stock | 276.0 | 276.7 | 275.5 | 276.7 | 15602.0 |
| 2022-08-03 08:30:00 | MSFT | Stock | 276.78 | 277.48 | 276.78 | 277.12 | 29801.0 |
| 2022-08-03 09:00:00 | MSFT | Stock | 277.2 | 277.49 | 276.86 | 276.99 | 31019.0 |
| 2022-08-03 09:30:00 | MSFT | Stock | 276.94 | 279.3 | 276.61 | 278.87 | 1504115.0 |
| 2022-08-03 10:00:00 | MSFT | Stock | 278.8 | 280.28 | 278.41 | 279.44 | 1147117.0 |
| 2022-08-03 10:30:00 | MSFT | Stock | 279.45 | 279.52 | 278.05 | 278.83 | 748316.0 |
| 2022-08-03 11:00:00 | MSFT | Stock | 278.825 | 280.44 | 278.55 | 280.2158 | 951693.0 |
| 2022-08-03 11:30:00 | MSFT | Stock | 280.22 | 281.42 | 279.83 | 281.28 | 1036073.0 |
| 2022-08-03 12:00:00 | MSFT | Stock | 281.28 | 281.79 | 280.615 | 281.4261 | 839580.0 |
| 2022-08-03 12:30:00 | MSFT | Stock | 281.43 | 282.85 | 281.41 | 282.344 | 839018.0 |
> showing 50 of 108,204 rows — these rows as CSV