PREVIEW / stock_30min / 2022-08-10
file: by_date/stock_30min/2022/2022-08-10.parquet size: 2.2 MB rows: 108,022 symbols: 2,289
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-10 04:00:00 | AAPL | Stock | 165.0 | 165.0 | 164.57 | 164.77 | 9310.0 |
| 2022-08-10 04:30:00 | AAPL | Stock | 164.92 | 165.49 | 164.92 | 165.36 | 4788.0 |
| 2022-08-10 05:00:00 | AAPL | Stock | 165.41 | 165.48 | 165.17 | 165.17 | 2668.0 |
| 2022-08-10 05:30:00 | AAPL | Stock | 165.12 | 165.23 | 165.12 | 165.23 | 1200.0 |
| 2022-08-10 06:00:00 | AAPL | Stock | 165.13 | 165.24 | 165.02 | 165.24 | 1782.0 |
| 2022-08-10 06:30:00 | AAPL | Stock | 165.19 | 165.19 | 164.85 | 165.08 | 5600.0 |
| 2022-08-10 07:00:00 | AAPL | Stock | 165.04 | 165.45 | 164.91 | 165.4 | 31750.0 |
| 2022-08-10 07:30:00 | AAPL | Stock | 165.43 | 165.43 | 165.0 | 165.28 | 34238.0 |
| 2022-08-10 08:00:00 | AAPL | Stock | 165.0 | 165.94 | 164.12 | 165.685 | 157314.0 |
| 2022-08-10 08:30:00 | AAPL | Stock | 165.69 | 168.18 | 165.49 | 167.4 | 1041654.0 |
| 2022-08-10 09:00:00 | AAPL | Stock | 167.4 | 167.81 | 167.12 | 167.66 | 343798.0 |
| 2022-08-10 09:30:00 | AAPL | Stock | 167.66 | 168.65 | 167.44 | 168.44 | 10077247.0 |
| 2022-08-10 10:00:00 | AAPL | Stock | 168.46 | 168.48 | 166.9 | 167.3387 | 4944672.0 |
| 2022-08-10 10:30:00 | AAPL | Stock | 167.35 | 168.05 | 167.17 | 167.75 | 3441349.0 |
| 2022-08-10 11:00:00 | AAPL | Stock | 167.75 | 168.23 | 167.5406 | 167.8406 | 3184612.0 |
| 2022-08-10 11:30:00 | AAPL | Stock | 167.84 | 168.245 | 167.82 | 168.1519 | 2429143.0 |
| 2022-08-10 12:00:00 | AAPL | Stock | 168.1615 | 168.3 | 167.65 | 167.9 | 2540698.0 |
| 2022-08-10 12:30:00 | AAPL | Stock | 167.9 | 168.28 | 167.88 | 168.07 | 2298572.0 |
| 2022-08-10 13:00:00 | AAPL | Stock | 168.0809 | 168.225 | 167.87 | 168.035 | 1715968.0 |
| 2022-08-10 13:30:00 | AAPL | Stock | 168.035 | 168.5 | 167.92 | 168.29 | 2255406.0 |
| 2022-08-10 14:00:00 | AAPL | Stock | 168.28 | 168.49 | 168.19 | 168.48 | 1845338.0 |
| 2022-08-10 14:30:00 | AAPL | Stock | 168.4788 | 168.74 | 168.3183 | 168.46 | 2670975.0 |
| 2022-08-10 15:00:00 | AAPL | Stock | 168.46 | 168.895 | 168.36 | 168.885 | 3071039.0 |
| 2022-08-10 15:30:00 | AAPL | Stock | 168.885 | 169.34 | 168.77 | 169.24 | 8878234.0 |
| 2022-08-10 16:00:00 | AAPL | Stock | 169.1838 | 169.25 | 168.96 | 169.06 | 8467284.0 |
| 2022-08-10 16:30:00 | AAPL | Stock | 169.04 | 169.24 | 168.85 | 168.93 | 127648.0 |
| 2022-08-10 17:00:00 | AAPL | Stock | 168.93 | 169.0 | 168.85 | 168.91 | 26938.0 |
| 2022-08-10 17:30:00 | AAPL | Stock | 168.9891 | 169.0 | 168.88 | 168.96 | 34319.0 |
| 2022-08-10 18:00:00 | AAPL | Stock | 168.98 | 168.98 | 168.87 | 168.91 | 11624.0 |
| 2022-08-10 18:30:00 | AAPL | Stock | 168.95 | 168.96 | 168.83 | 168.88 | 12946.0 |
| 2022-08-10 19:00:00 | AAPL | Stock | 168.86 | 169.05 | 168.86 | 169.0 | 27820.0 |
| 2022-08-10 19:30:00 | AAPL | Stock | 168.98 | 169.24 | 168.94 | 169.1 | 20035.0 |
| 2022-08-10 04:00:00 | MSFT | Stock | 282.83 | 282.83 | 282.5 | 282.69 | 415.0 |
| 2022-08-10 04:30:00 | MSFT | Stock | 282.84 | 283.03 | 282.0 | 282.0 | 640.0 |
| 2022-08-10 05:00:00 | MSFT | Stock | 283.69 | 283.76 | 283.49 | 283.76 | 415.0 |
| 2022-08-10 05:30:00 | MSFT | Stock | 283.18 | 283.18 | 283.01 | 283.01 | 510.0 |
| 2022-08-10 06:00:00 | MSFT | Stock | 283.0 | 283.0 | 283.0 | 283.0 | 404.0 |
| 2022-08-10 06:30:00 | MSFT | Stock | 282.7 | 282.71 | 282.53 | 282.53 | 530.0 |
| 2022-08-10 07:00:00 | MSFT | Stock | 282.7 | 283.25 | 282.7 | 283.25 | 3592.0 |
| 2022-08-10 07:30:00 | MSFT | Stock | 283.29 | 283.8 | 283.29 | 283.8 | 5068.0 |
| 2022-08-10 08:00:00 | MSFT | Stock | 282.748 | 284.6 | 282.1 | 284.2 | 21450.0 |
| 2022-08-10 08:30:00 | MSFT | Stock | 284.6 | 290.0 | 284.6 | 289.43 | 205810.0 |
| 2022-08-10 09:00:00 | MSFT | Stock | 289.13 | 289.3 | 288.0 | 288.32 | 76350.0 |
| 2022-08-10 09:30:00 | MSFT | Stock | 288.17 | 289.24 | 286.94 | 288.5813 | 2958911.0 |
| 2022-08-10 10:00:00 | MSFT | Stock | 288.64 | 289.07 | 287.02 | 287.66 | 1436585.0 |
| 2022-08-10 10:30:00 | MSFT | Stock | 287.72 | 289.2698 | 287.5663 | 288.39 | 1037120.0 |
| 2022-08-10 11:00:00 | MSFT | Stock | 288.41 | 289.66 | 288.37 | 288.81 | 1123707.0 |
| 2022-08-10 11:30:00 | MSFT | Stock | 288.79 | 289.085 | 288.33 | 288.63 | 807605.0 |
| 2022-08-10 12:00:00 | MSFT | Stock | 288.65 | 288.8 | 287.6533 | 288.08 | 695299.0 |
| 2022-08-10 12:30:00 | MSFT | Stock | 288.1 | 288.25 | 287.64 | 288.175 | 568232.0 |
> showing 50 of 108,022 rows — these rows as CSV