PREVIEW / stock_30min / 2022-08-05
file: by_date/stock_30min/2022/2022-08-05.parquet size: 2.1 MB rows: 105,673 symbols: 2,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 |
|---|---|---|---|---|---|---|---|
| 2022-08-05 04:00:00 | AAPL | Stock | 166.0 | 166.2 | 165.8 | 165.81 | 3308.0 |
| 2022-08-05 04:30:00 | AAPL | Stock | 165.8 | 165.8 | 165.5 | 165.58 | 3088.0 |
| 2022-08-05 05:00:00 | AAPL | Stock | 165.62 | 165.7 | 165.56 | 165.7 | 2935.0 |
| 2022-08-05 05:30:00 | AAPL | Stock | 165.52 | 165.6 | 165.02 | 165.6 | 4063.0 |
| 2022-08-05 06:00:00 | AAPL | Stock | 165.39 | 165.39 | 165.08 | 165.15 | 9354.0 |
| 2022-08-05 06:30:00 | AAPL | Stock | 165.35 | 165.36 | 165.15 | 165.27 | 1880.0 |
| 2022-08-05 07:00:00 | AAPL | Stock | 165.34 | 165.49 | 165.2 | 165.45 | 13622.0 |
| 2022-08-05 07:30:00 | AAPL | Stock | 165.47 | 165.77 | 165.4 | 165.72 | 17135.0 |
| 2022-08-05 08:00:00 | AAPL | Stock | 165.36 | 165.79 | 165.1312 | 165.67 | 111210.0 |
| 2022-08-05 08:30:00 | AAPL | Stock | 165.55 | 165.61 | 163.31 | 163.59 | 833940.0 |
| 2022-08-05 09:00:00 | AAPL | Stock | 163.56 | 165.58 | 162.8 | 163.16 | 320038.0 |
| 2022-08-05 09:30:00 | AAPL | Stock | 163.23 | 164.98 | 163.0 | 164.74 | 7227227.0 |
| 2022-08-05 10:00:00 | AAPL | Stock | 164.77 | 165.85 | 164.53 | 165.2 | 4527289.0 |
| 2022-08-05 10:30:00 | AAPL | Stock | 165.2 | 165.29 | 164.485 | 164.75 | 2725498.0 |
| 2022-08-05 11:00:00 | AAPL | Stock | 164.74 | 164.7985 | 163.44 | 163.45 | 3211142.0 |
| 2022-08-05 11:30:00 | AAPL | Stock | 163.4404 | 164.36 | 163.39 | 164.174 | 2928599.0 |
| 2022-08-05 12:00:00 | AAPL | Stock | 164.18 | 164.7491 | 164.0917 | 164.675 | 2386672.0 |
| 2022-08-05 12:30:00 | AAPL | Stock | 164.6863 | 165.02 | 164.09 | 164.915 | 2320421.0 |
| 2022-08-05 13:00:00 | AAPL | Stock | 164.91 | 165.45 | 164.735 | 165.2201 | 2581822.0 |
| 2022-08-05 13:30:00 | AAPL | Stock | 165.215 | 165.42 | 164.52 | 164.7302 | 2142221.0 |
| 2022-08-05 14:00:00 | AAPL | Stock | 164.73 | 165.0 | 164.5 | 164.508 | 1928002.0 |
| 2022-08-05 14:30:00 | AAPL | Stock | 164.5 | 164.7399 | 164.37 | 164.66 | 1742642.0 |
| 2022-08-05 15:00:00 | AAPL | Stock | 164.6586 | 165.107 | 164.5 | 165.035 | 2599283.0 |
| 2022-08-05 15:30:00 | AAPL | Stock | 165.035 | 165.42 | 164.93 | 165.34 | 5016594.0 |
| 2022-08-05 16:00:00 | AAPL | Stock | 165.34 | 165.42 | 165.14 | 165.25 | 5842893.0 |
| 2022-08-05 16:30:00 | AAPL | Stock | 165.25 | 165.35 | 165.2 | 165.25 | 15851.0 |
| 2022-08-05 17:00:00 | AAPL | Stock | 165.25 | 165.27 | 165.2 | 165.2394 | 10205.0 |
| 2022-08-05 17:30:00 | AAPL | Stock | 165.21 | 165.27 | 165.2 | 165.22 | 6919.0 |
| 2022-08-05 18:00:00 | AAPL | Stock | 165.18 | 165.21 | 165.15 | 165.16 | 4676.0 |
| 2022-08-05 18:30:00 | AAPL | Stock | 165.19 | 165.19 | 165.03 | 165.1 | 8151.0 |
| 2022-08-05 19:00:00 | AAPL | Stock | 165.1 | 165.12 | 165.06 | 165.08 | 7274.0 |
| 2022-08-05 19:30:00 | AAPL | Stock | 165.07 | 165.1 | 164.9 | 164.9 | 15222.0 |
| 2022-08-05 04:00:00 | MSFT | Stock | 284.03 | 284.1 | 283.85 | 283.85 | 1524.0 |
| 2022-08-05 05:00:00 | MSFT | Stock | 283.42 | 283.42 | 283.01 | 283.22 | 511.0 |
| 2022-08-05 05:30:00 | MSFT | Stock | 283.99 | 283.99 | 283.25 | 283.56 | 1283.0 |
| 2022-08-05 06:00:00 | MSFT | Stock | 283.98 | 283.98 | 283.5 | 283.5 | 666.0 |
| 2022-08-05 06:30:00 | MSFT | Stock | 283.67 | 283.84 | 283.46 | 283.46 | 1268.0 |
| 2022-08-05 07:00:00 | MSFT | Stock | 283.77 | 283.77 | 283.18 | 283.5 | 2885.0 |
| 2022-08-05 07:30:00 | MSFT | Stock | 283.7 | 283.87 | 283.65 | 283.87 | 1285.0 |
| 2022-08-05 08:00:00 | MSFT | Stock | 283.22 | 285.11 | 283.22 | 284.18 | 6313.0 |
| 2022-08-05 08:30:00 | MSFT | Stock | 283.79 | 283.79 | 279.5 | 280.0 | 159403.0 |
| 2022-08-05 09:00:00 | MSFT | Stock | 280.0 | 280.2 | 278.41 | 279.14 | 82398.0 |
| 2022-08-05 09:30:00 | MSFT | Stock | 279.2 | 281.91 | 278.68 | 281.4869 | 1901987.0 |
| 2022-08-05 10:00:00 | MSFT | Stock | 281.51 | 283.65 | 281.084 | 282.84 | 1071263.0 |
| 2022-08-05 10:30:00 | MSFT | Stock | 282.84 | 282.875 | 281.68 | 282.136 | 600370.0 |
| 2022-08-05 11:00:00 | MSFT | Stock | 282.13 | 282.1821 | 279.47 | 279.47 | 738079.0 |
| 2022-08-05 11:30:00 | MSFT | Stock | 279.475 | 280.73 | 279.41 | 280.13 | 895395.0 |
| 2022-08-05 12:00:00 | MSFT | Stock | 280.17 | 281.03 | 280.02 | 280.8501 | 439588.0 |
| 2022-08-05 12:30:00 | MSFT | Stock | 280.89 | 281.62 | 280.22 | 281.48 | 376111.0 |
| 2022-08-05 13:00:00 | MSFT | Stock | 281.47 | 282.4 | 281.33 | 281.83 | 453974.0 |
> showing 50 of 105,673 rows — these rows as CSV