PREVIEW / stock_30min / 2023-12-21
file: by_date/stock_30min/2023/2023-12-21.parquet size: 2.1 MB rows: 101,754 symbols: 1,242
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-12-21 04:00:00 | AAPL | Stock | 195.86 | 196.1 | 195.7 | 196.09 | 4957.0 |
| 2023-12-21 04:30:00 | AAPL | Stock | 196.04 | 196.07 | 195.94 | 195.94 | 12857.0 |
| 2023-12-21 05:00:00 | AAPL | Stock | 195.93 | 195.94 | 195.83 | 195.9 | 1761.0 |
| 2023-12-21 05:30:00 | AAPL | Stock | 195.82 | 195.82 | 195.75 | 195.79 | 2079.0 |
| 2023-12-21 06:00:00 | AAPL | Stock | 195.86 | 195.99 | 195.79 | 195.79 | 2327.0 |
| 2023-12-21 06:30:00 | AAPL | Stock | 195.89 | 195.91 | 195.83 | 195.84 | 1050.0 |
| 2023-12-21 07:00:00 | AAPL | Stock | 195.89 | 195.98 | 195.87 | 195.97 | 15754.0 |
| 2023-12-21 07:30:00 | AAPL | Stock | 195.94 | 195.99 | 195.81 | 195.85 | 8234.0 |
| 2023-12-21 08:00:00 | AAPL | Stock | 195.9 | 196.0 | 195.59 | 195.7 | 51206.0 |
| 2023-12-21 08:30:00 | AAPL | Stock | 195.7 | 196.49 | 195.5 | 196.05 | 104047.0 |
| 2023-12-21 09:00:00 | AAPL | Stock | 196.08 | 196.2999 | 195.9 | 196.04 | 74116.0 |
| 2023-12-21 09:30:00 | AAPL | Stock | 196.13 | 197.08 | 195.68 | 195.78 | 4137394.0 |
| 2023-12-21 10:00:00 | AAPL | Stock | 195.78 | 195.82 | 194.82 | 195.1297 | 3718968.0 |
| 2023-12-21 10:30:00 | AAPL | Stock | 195.13 | 195.2 | 194.29 | 194.44 | 2596864.0 |
| 2023-12-21 11:00:00 | AAPL | Stock | 194.435 | 194.89 | 194.34 | 194.86 | 2061064.0 |
| 2023-12-21 11:30:00 | AAPL | Stock | 194.86 | 194.97 | 194.44 | 194.49 | 1625186.0 |
| 2023-12-21 12:00:00 | AAPL | Stock | 194.4909 | 194.53 | 193.91 | 194.04 | 2227650.0 |
| 2023-12-21 12:30:00 | AAPL | Stock | 194.05 | 194.26 | 193.67 | 193.75 | 1880606.0 |
| 2023-12-21 13:00:00 | AAPL | Stock | 193.75 | 194.11 | 193.5 | 194.06 | 1761106.0 |
| 2023-12-21 13:30:00 | AAPL | Stock | 194.07 | 194.24 | 193.77 | 194.0601 | 1613797.0 |
| 2023-12-21 14:00:00 | AAPL | Stock | 194.06 | 194.15 | 193.78 | 194.0 | 1358288.0 |
| 2023-12-21 14:30:00 | AAPL | Stock | 193.995 | 194.36 | 193.8 | 193.89 | 1610828.0 |
| 2023-12-21 15:00:00 | AAPL | Stock | 193.89 | 194.42 | 193.76 | 194.4051 | 2039836.0 |
| 2023-12-21 15:30:00 | AAPL | Stock | 194.41 | 194.98 | 194.3321 | 194.68 | 4184367.0 |
| 2023-12-21 16:00:00 | AAPL | Stock | 194.7 | 194.99 | 194.68 | 194.84 | 5590172.0 |
| 2023-12-21 16:30:00 | AAPL | Stock | 194.84 | 194.97 | 194.68 | 194.85 | 84721.0 |
| 2023-12-21 17:00:00 | AAPL | Stock | 194.84 | 194.9 | 194.81 | 194.89 | 29473.0 |
| 2023-12-21 17:30:00 | AAPL | Stock | 194.83 | 194.88 | 194.78 | 194.8 | 15058.0 |
| 2023-12-21 18:00:00 | AAPL | Stock | 194.76 | 194.7663 | 194.58 | 194.65 | 35390.0 |
| 2023-12-21 18:30:00 | AAPL | Stock | 194.65 | 194.75 | 194.6 | 194.65 | 7471.0 |
| 2023-12-21 19:00:00 | AAPL | Stock | 194.64 | 194.6793 | 194.6 | 194.63 | 5893.0 |
| 2023-12-21 19:30:00 | AAPL | Stock | 194.65 | 194.6793 | 194.6 | 194.63 | 12691.0 |
| 2023-12-21 04:00:00 | MSFT | Stock | 372.44 | 372.61 | 372.12 | 372.17 | 3068.0 |
| 2023-12-21 04:30:00 | MSFT | Stock | 372.56 | 372.56 | 372.11 | 372.4 | 867.0 |
| 2023-12-21 05:00:00 | MSFT | Stock | 372.05 | 372.05 | 372.05 | 372.05 | 100.0 |
| 2023-12-21 05:30:00 | MSFT | Stock | 372.0 | 372.19 | 372.0 | 372.19 | 764.0 |
| 2023-12-21 06:00:00 | MSFT | Stock | 372.29 | 372.3 | 372.04 | 372.08 | 1306.0 |
| 2023-12-21 06:30:00 | MSFT | Stock | 371.92 | 371.92 | 371.92 | 371.92 | 297.0 |
| 2023-12-21 07:00:00 | MSFT | Stock | 372.19 | 372.6 | 372.19 | 372.6 | 2969.0 |
| 2023-12-21 07:30:00 | MSFT | Stock | 372.62 | 372.62 | 372.42 | 372.42 | 2327.0 |
| 2023-12-21 08:00:00 | MSFT | Stock | 372.1 | 372.66 | 371.42 | 372.2 | 22005.0 |
| 2023-12-21 08:30:00 | MSFT | Stock | 372.01 | 374.1 | 372.01 | 373.0005 | 50110.0 |
| 2023-12-21 09:00:00 | MSFT | Stock | 373.01 | 373.38 | 372.51 | 372.51 | 24334.0 |
| 2023-12-21 09:30:00 | MSFT | Stock | 372.59 | 374.41 | 371.78 | 372.007 | 1753054.0 |
| 2023-12-21 10:00:00 | MSFT | Stock | 372.03 | 372.58 | 370.82 | 371.49 | 1075289.0 |
| 2023-12-21 10:30:00 | MSFT | Stock | 371.55 | 372.39 | 371.23 | 371.45 | 506903.0 |
| 2023-12-21 11:00:00 | MSFT | Stock | 371.4384 | 371.82 | 370.99 | 371.6 | 491414.0 |
| 2023-12-21 11:30:00 | MSFT | Stock | 371.595 | 371.95 | 371.07 | 371.2 | 415886.0 |
| 2023-12-21 12:00:00 | MSFT | Stock | 371.195 | 371.2032 | 370.04 | 370.55 | 657801.0 |
| 2023-12-21 12:30:00 | MSFT | Stock | 370.52 | 370.8401 | 370.13 | 370.36 | 449015.0 |
> showing 50 of 101,754 rows — these rows as CSV