PREVIEW / stock_30min / 2023-11-08
file: by_date/stock_30min/2023/2023-11-08.parquet size: 2.0 MB rows: 97,234 symbols: 1,330
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-11-08 04:00:00 | AAPL | Stock | 181.86 | 181.86 | 181.66 | 181.67 | 6277.0 |
| 2023-11-08 04:30:00 | AAPL | Stock | 181.67 | 181.96 | 181.67 | 181.92 | 6137.0 |
| 2023-11-08 05:00:00 | AAPL | Stock | 181.88 | 181.98 | 181.83 | 181.83 | 3140.0 |
| 2023-11-08 05:30:00 | AAPL | Stock | 181.93 | 181.94 | 181.82 | 181.9 | 10099.0 |
| 2023-11-08 06:00:00 | AAPL | Stock | 181.9 | 181.9 | 181.81 | 181.82 | 11923.0 |
| 2023-11-08 06:30:00 | AAPL | Stock | 181.89 | 181.9 | 181.83 | 181.84 | 3913.0 |
| 2023-11-08 07:00:00 | AAPL | Stock | 181.82 | 181.85 | 181.61 | 181.8 | 19570.0 |
| 2023-11-08 07:30:00 | AAPL | Stock | 181.81 | 181.85 | 181.71 | 181.85 | 9770.0 |
| 2023-11-08 08:00:00 | AAPL | Stock | 181.7 | 182.06 | 181.39 | 181.91 | 48976.0 |
| 2023-11-08 08:30:00 | AAPL | Stock | 181.96 | 181.96 | 181.52 | 181.53 | 37767.0 |
| 2023-11-08 09:00:00 | AAPL | Stock | 181.56 | 182.41 | 181.51 | 182.41 | 93054.0 |
| 2023-11-08 09:30:00 | AAPL | Stock | 182.41 | 183.45 | 182.18 | 182.96 | 7052673.0 |
| 2023-11-08 10:00:00 | AAPL | Stock | 182.98 | 183.33 | 182.2851 | 182.4985 | 4345730.0 |
| 2023-11-08 10:30:00 | AAPL | Stock | 182.49 | 182.985 | 182.31 | 182.58 | 2930889.0 |
| 2023-11-08 11:00:00 | AAPL | Stock | 182.585 | 182.85 | 182.0 | 182.15 | 2492137.0 |
| 2023-11-08 11:30:00 | AAPL | Stock | 182.15 | 182.5 | 182.0 | 182.01 | 2193231.0 |
| 2023-11-08 12:00:00 | AAPL | Stock | 182.02 | 182.1 | 181.59 | 181.89 | 2136584.0 |
| 2023-11-08 12:30:00 | AAPL | Stock | 181.9 | 182.29 | 181.74 | 182.1501 | 1546611.0 |
| 2023-11-08 13:00:00 | AAPL | Stock | 182.16 | 182.58 | 182.0 | 182.51 | 1810018.0 |
| 2023-11-08 13:30:00 | AAPL | Stock | 182.51 | 182.7475 | 182.46 | 182.5933 | 1175630.0 |
| 2023-11-08 14:00:00 | AAPL | Stock | 182.59 | 182.89 | 182.53 | 182.775 | 1321986.0 |
| 2023-11-08 14:30:00 | AAPL | Stock | 182.78 | 182.85 | 182.37 | 182.43 | 1670952.0 |
| 2023-11-08 15:00:00 | AAPL | Stock | 182.43 | 182.79 | 182.41 | 182.785 | 1977208.0 |
| 2023-11-08 15:30:00 | AAPL | Stock | 182.79 | 183.01 | 182.6225 | 182.89 | 4651701.0 |
| 2023-11-08 16:00:00 | AAPL | Stock | 182.905 | 182.94 | 182.72 | 182.87 | 6022439.0 |
| 2023-11-08 16:30:00 | AAPL | Stock | 182.85 | 182.89 | 182.72 | 182.77 | 33316.0 |
| 2023-11-08 17:00:00 | AAPL | Stock | 182.76 | 182.89 | 182.76 | 182.8 | 23951.0 |
| 2023-11-08 17:30:00 | AAPL | Stock | 182.8 | 182.81 | 182.77 | 182.79 | 3478.0 |
| 2023-11-08 18:00:00 | AAPL | Stock | 182.79 | 182.79 | 182.33 | 182.51 | 27200.0 |
| 2023-11-08 18:30:00 | AAPL | Stock | 182.6 | 182.66 | 182.49 | 182.6 | 12887.0 |
| 2023-11-08 19:00:00 | AAPL | Stock | 182.6 | 182.72 | 182.48 | 182.52 | 12125.0 |
| 2023-11-08 19:30:00 | AAPL | Stock | 182.53 | 182.63 | 182.43 | 182.43 | 15275.0 |
| 2023-11-08 04:00:00 | MSFT | Stock | 360.19 | 360.19 | 360.14 | 360.15 | 430.0 |
| 2023-11-08 04:30:00 | MSFT | Stock | 360.0 | 360.29 | 360.0 | 360.29 | 1412.0 |
| 2023-11-08 05:00:00 | MSFT | Stock | 360.3 | 360.48 | 360.3 | 360.48 | 2002.0 |
| 2023-11-08 05:30:00 | MSFT | Stock | 360.48 | 360.48 | 360.48 | 360.48 | 666.0 |
| 2023-11-08 06:00:00 | MSFT | Stock | 360.41 | 360.6 | 360.36 | 360.6 | 1306.0 |
| 2023-11-08 06:30:00 | MSFT | Stock | 360.98 | 360.98 | 360.8 | 360.92 | 2256.0 |
| 2023-11-08 07:00:00 | MSFT | Stock | 360.85 | 360.99 | 360.6 | 360.86 | 6465.0 |
| 2023-11-08 07:30:00 | MSFT | Stock | 360.75 | 360.9 | 360.51 | 360.9 | 2554.0 |
| 2023-11-08 08:00:00 | MSFT | Stock | 360.82 | 361.25 | 359.62 | 360.85 | 41345.0 |
| 2023-11-08 08:30:00 | MSFT | Stock | 360.9694 | 360.9694 | 360.6001 | 360.6501 | 7753.0 |
| 2023-11-08 09:00:00 | MSFT | Stock | 360.7002 | 362.0 | 360.7002 | 361.76 | 29838.0 |
| 2023-11-08 09:30:00 | MSFT | Stock | 361.68 | 363.87 | 361.405 | 362.51 | 2333093.0 |
| 2023-11-08 10:00:00 | MSFT | Stock | 362.54 | 362.63 | 360.55 | 360.94 | 1587258.0 |
| 2023-11-08 10:30:00 | MSFT | Stock | 360.9093 | 362.21 | 360.5896 | 361.635 | 927324.0 |
| 2023-11-08 11:00:00 | MSFT | Stock | 361.66 | 362.6 | 361.54 | 362.12 | 784595.0 |
| 2023-11-08 11:30:00 | MSFT | Stock | 362.11 | 362.95 | 361.79 | 362.3375 | 722102.0 |
| 2023-11-08 12:00:00 | MSFT | Stock | 362.34 | 362.62 | 361.29 | 362.085 | 760566.0 |
| 2023-11-08 12:30:00 | MSFT | Stock | 362.09 | 362.5 | 361.72 | 362.26 | 396026.0 |
> showing 50 of 97,234 rows — these rows as CSV