PREVIEW / stock_30min / 2022-06-02
file: by_date/stock_30min/2022/2022-06-02.parquet size: 2.1 MB rows: 104,812 symbols: 2,369
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-06-02 04:00:00 | AAPL | Stock | 148.57 | 149.5 | 148.57 | 149.45 | 19091.0 |
| 2022-06-02 04:30:00 | AAPL | Stock | 149.47 | 149.6 | 149.29 | 149.29 | 6261.0 |
| 2022-06-02 05:00:00 | AAPL | Stock | 149.23 | 149.48 | 149.23 | 149.48 | 3171.0 |
| 2022-06-02 05:30:00 | AAPL | Stock | 149.46 | 149.46 | 149.29 | 149.34 | 1929.0 |
| 2022-06-02 06:00:00 | AAPL | Stock | 149.34 | 149.4 | 149.19 | 149.31 | 10638.0 |
| 2022-06-02 06:30:00 | AAPL | Stock | 149.3 | 149.7 | 149.25 | 149.6 | 16775.0 |
| 2022-06-02 07:00:00 | AAPL | Stock | 149.58 | 149.65 | 149.24 | 149.52 | 53147.0 |
| 2022-06-02 07:30:00 | AAPL | Stock | 149.54 | 149.59 | 149.36 | 149.41 | 23260.0 |
| 2022-06-02 08:00:00 | AAPL | Stock | 149.4 | 149.56 | 148.85 | 149.14 | 222500.0 |
| 2022-06-02 08:30:00 | AAPL | Stock | 149.1202 | 149.19 | 148.66 | 148.7 | 192892.0 |
| 2022-06-02 09:00:00 | AAPL | Stock | 148.74 | 148.92 | 147.61 | 147.81 | 648029.0 |
| 2022-06-02 09:30:00 | AAPL | Stock | 147.81 | 148.49 | 146.86 | 148.1601 | 7963451.0 |
| 2022-06-02 10:00:00 | AAPL | Stock | 148.16 | 149.03 | 147.24 | 147.41 | 6567286.0 |
| 2022-06-02 10:30:00 | AAPL | Stock | 147.41 | 148.32 | 147.34 | 148.23 | 4128499.0 |
| 2022-06-02 11:00:00 | AAPL | Stock | 148.21 | 149.32 | 148.11 | 148.93 | 4484192.0 |
| 2022-06-02 11:30:00 | AAPL | Stock | 148.94 | 149.9399 | 148.52 | 149.4412 | 4459621.0 |
| 2022-06-02 12:00:00 | AAPL | Stock | 149.45 | 150.54 | 149.3512 | 150.5011 | 3759202.0 |
| 2022-06-02 12:30:00 | AAPL | Stock | 150.5199 | 150.69 | 150.34 | 150.48 | 3074155.0 |
| 2022-06-02 13:00:00 | AAPL | Stock | 150.49 | 150.6153 | 149.96 | 150.1791 | 2549727.0 |
| 2022-06-02 13:30:00 | AAPL | Stock | 150.18 | 150.54 | 150.03 | 150.305 | 2226117.0 |
| 2022-06-02 14:00:00 | AAPL | Stock | 150.31 | 150.83 | 150.13 | 150.53 | 2767231.0 |
| 2022-06-02 14:30:00 | AAPL | Stock | 150.525 | 150.7 | 150.0701 | 150.11 | 2413714.0 |
| 2022-06-02 15:00:00 | AAPL | Stock | 150.1091 | 150.6099 | 150.06 | 150.3477 | 3064868.0 |
| 2022-06-02 15:30:00 | AAPL | Stock | 150.34 | 151.27 | 150.3 | 151.23 | 7242406.0 |
| 2022-06-02 16:00:00 | AAPL | Stock | 151.2 | 151.21 | 150.8 | 151.1 | 6918496.0 |
| 2022-06-02 16:30:00 | AAPL | Stock | 151.0601 | 151.21 | 150.97 | 151.15 | 49027.0 |
| 2022-06-02 17:00:00 | AAPL | Stock | 151.1599 | 151.21 | 151.03 | 151.12 | 14037.0 |
| 2022-06-02 17:30:00 | AAPL | Stock | 151.12 | 151.2 | 151.09 | 151.0902 | 21796.0 |
| 2022-06-02 18:00:00 | AAPL | Stock | 151.1 | 151.49 | 151.1 | 151.31 | 34339.0 |
| 2022-06-02 18:30:00 | AAPL | Stock | 151.43 | 151.45 | 151.35 | 151.41 | 18795.0 |
| 2022-06-02 19:00:00 | AAPL | Stock | 151.41 | 151.56 | 151.41 | 151.56 | 16975.0 |
| 2022-06-02 19:30:00 | AAPL | Stock | 151.56 | 151.6 | 151.47 | 151.55 | 40075.0 |
| 2022-06-02 04:00:00 | MSFT | Stock | 274.06 | 275.0 | 273.71 | 275.0 | 2214.0 |
| 2022-06-02 04:30:00 | MSFT | Stock | 274.51 | 274.51 | 274.4 | 274.4 | 558.0 |
| 2022-06-02 05:00:00 | MSFT | Stock | 274.1 | 274.39 | 274.0 | 274.39 | 2107.0 |
| 2022-06-02 05:30:00 | MSFT | Stock | 274.28 | 274.46 | 274.28 | 274.4 | 492.0 |
| 2022-06-02 06:30:00 | MSFT | Stock | 274.35 | 274.7 | 274.35 | 274.53 | 2954.0 |
| 2022-06-02 07:00:00 | MSFT | Stock | 274.5 | 274.89 | 274.0 | 274.89 | 10086.0 |
| 2022-06-02 07:30:00 | MSFT | Stock | 274.85 | 274.85 | 274.25 | 274.31 | 10784.0 |
| 2022-06-02 08:00:00 | MSFT | Stock | 274.68 | 274.87 | 273.21 | 273.9699 | 18900.0 |
| 2022-06-02 08:30:00 | MSFT | Stock | 273.46 | 273.99 | 273.4001 | 273.4001 | 8529.0 |
| 2022-06-02 09:00:00 | MSFT | Stock | 273.403 | 275.88 | 263.73 | 264.33 | 1137966.0 |
| 2022-06-02 09:30:00 | MSFT | Stock | 264.45 | 267.4799 | 261.6 | 266.21 | 7873574.0 |
| 2022-06-02 10:00:00 | MSFT | Stock | 266.17 | 267.76 | 264.54 | 265.12 | 2655042.0 |
| 2022-06-02 10:30:00 | MSFT | Stock | 265.14 | 266.43 | 264.9 | 266.276 | 1624172.0 |
| 2022-06-02 11:00:00 | MSFT | Stock | 266.27 | 268.6 | 266.06 | 267.733 | 1863789.0 |
| 2022-06-02 11:30:00 | MSFT | Stock | 267.73 | 269.05 | 266.96 | 268.0305 | 1633896.0 |
| 2022-06-02 12:00:00 | MSFT | Stock | 268.05 | 269.76 | 267.8 | 269.62 | 1577983.0 |
| 2022-06-02 12:30:00 | MSFT | Stock | 269.64 | 270.84 | 269.52 | 270.67 | 1619439.0 |
| 2022-06-02 13:00:00 | MSFT | Stock | 270.6928 | 271.37 | 270.4 | 271.29 | 1508548.0 |
> showing 50 of 104,812 rows — these rows as CSV