PREVIEW / stock_30min / 2022-03-03
file: by_date/stock_30min/2022/2022-03-03.parquet size: 2.1 MB rows: 106,170 symbols: 2,523
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-03-03 04:00:00 | AAPL | Stock | 166.35 | 166.46 | 165.92 | 166.32 | 6025.0 |
| 2022-03-03 04:30:00 | AAPL | Stock | 166.16 | 166.43 | 166.16 | 166.41 | 928.0 |
| 2022-03-03 05:00:00 | AAPL | Stock | 166.41 | 166.41 | 166.02 | 166.06 | 3619.0 |
| 2022-03-03 05:30:00 | AAPL | Stock | 166.19 | 166.28 | 166.19 | 166.28 | 637.0 |
| 2022-03-03 06:00:00 | AAPL | Stock | 166.3 | 166.68 | 166.3 | 166.68 | 2065.0 |
| 2022-03-03 06:30:00 | AAPL | Stock | 166.78 | 166.79 | 165.93 | 166.16 | 8400.0 |
| 2022-03-03 07:00:00 | AAPL | Stock | 166.23 | 166.78 | 166.21 | 166.67 | 28236.0 |
| 2022-03-03 07:30:00 | AAPL | Stock | 166.71 | 166.78 | 166.41 | 166.53 | 18669.0 |
| 2022-03-03 08:00:00 | AAPL | Stock | 166.77 | 167.55 | 166.144 | 167.17 | 242786.0 |
| 2022-03-03 08:30:00 | AAPL | Stock | 167.18 | 167.96 | 166.99 | 167.86 | 305964.0 |
| 2022-03-03 09:00:00 | AAPL | Stock | 167.8599 | 168.57 | 167.84 | 168.44 | 453757.0 |
| 2022-03-03 09:30:00 | AAPL | Stock | 168.47 | 168.91 | 167.5199 | 168.06 | 8638037.0 |
| 2022-03-03 10:00:00 | AAPL | Stock | 168.065 | 168.4 | 166.54 | 166.8105 | 5437085.0 |
| 2022-03-03 10:30:00 | AAPL | Stock | 166.82 | 167.0599 | 166.0101 | 166.03 | 4245092.0 |
| 2022-03-03 11:00:00 | AAPL | Stock | 166.02 | 166.8593 | 165.73 | 166.66 | 4263250.0 |
| 2022-03-03 11:30:00 | AAPL | Stock | 166.65 | 167.02 | 166.3 | 166.83 | 3837267.0 |
| 2022-03-03 12:00:00 | AAPL | Stock | 166.82 | 167.24 | 166.18 | 166.25 | 3039736.0 |
| 2022-03-03 12:30:00 | AAPL | Stock | 166.25 | 167.9276 | 166.09 | 167.11 | 4812757.0 |
| 2022-03-03 13:00:00 | AAPL | Stock | 167.1 | 167.8 | 166.93 | 167.691 | 2829985.0 |
| 2022-03-03 13:30:00 | AAPL | Stock | 167.69 | 167.7 | 166.88 | 167.3693 | 2668681.0 |
| 2022-03-03 14:00:00 | AAPL | Stock | 167.36 | 167.91 | 167.14 | 167.77 | 2904128.0 |
| 2022-03-03 14:30:00 | AAPL | Stock | 167.76 | 167.76 | 166.58 | 166.685 | 2932299.0 |
| 2022-03-03 15:00:00 | AAPL | Stock | 166.68 | 166.7213 | 165.92 | 166.6881 | 4002917.0 |
| 2022-03-03 15:30:00 | AAPL | Stock | 166.68 | 166.74 | 165.55 | 166.2882 | 6906282.0 |
| 2022-03-03 16:00:00 | AAPL | Stock | 166.3 | 166.42 | 166.01 | 166.29 | 6350686.0 |
| 2022-03-03 16:30:00 | AAPL | Stock | 166.29 | 166.4 | 166.21 | 166.35 | 17180.0 |
| 2022-03-03 17:00:00 | AAPL | Stock | 166.34 | 166.35 | 165.9 | 166.17 | 76268.0 |
| 2022-03-03 17:30:00 | AAPL | Stock | 166.17 | 166.22 | 166.06 | 166.08 | 35268.0 |
| 2022-03-03 18:00:00 | AAPL | Stock | 166.1001 | 166.19 | 165.95 | 166.18 | 24622.0 |
| 2022-03-03 18:30:00 | AAPL | Stock | 166.07 | 166.39 | 166.07 | 166.35 | 29397.0 |
| 2022-03-03 19:00:00 | AAPL | Stock | 166.39 | 166.42 | 165.5 | 165.5 | 60115.0 |
| 2022-03-03 19:30:00 | AAPL | Stock | 165.52 | 165.54 | 162.09 | 162.95 | 189221.0 |
| 2022-03-03 04:00:00 | MSFT | Stock | 298.59 | 299.5 | 298.59 | 299.5 | 1701.0 |
| 2022-03-03 04:30:00 | MSFT | Stock | 299.0 | 299.0 | 298.73 | 298.73 | 919.0 |
| 2022-03-03 05:00:00 | MSFT | Stock | 299.02 | 299.13 | 298.16 | 298.16 | 895.0 |
| 2022-03-03 05:30:00 | MSFT | Stock | 298.12 | 298.27 | 298.0 | 298.27 | 400.0 |
| 2022-03-03 06:00:00 | MSFT | Stock | 298.62 | 298.95 | 298.62 | 298.95 | 678.0 |
| 2022-03-03 06:30:00 | MSFT | Stock | 299.18 | 299.18 | 298.01 | 298.01 | 933.0 |
| 2022-03-03 07:00:00 | MSFT | Stock | 298.5 | 299.39 | 298.5 | 299.21 | 4780.0 |
| 2022-03-03 07:30:00 | MSFT | Stock | 299.19 | 299.24 | 298.63 | 299.2 | 4062.0 |
| 2022-03-03 08:00:00 | MSFT | Stock | 299.0501 | 300.54 | 298.95 | 300.46 | 9809.0 |
| 2022-03-03 08:30:00 | MSFT | Stock | 300.2 | 302.3 | 300.06 | 302.17 | 31684.0 |
| 2022-03-03 09:00:00 | MSFT | Stock | 302.18 | 303.75 | 302.0 | 303.11 | 66065.0 |
| 2022-03-03 09:30:00 | MSFT | Stock | 303.13 | 303.13 | 300.5296 | 300.895 | 2227212.0 |
| 2022-03-03 10:00:00 | MSFT | Stock | 300.92 | 301.33 | 297.55 | 298.34 | 1546188.0 |
| 2022-03-03 10:30:00 | MSFT | Stock | 298.38 | 298.65 | 296.42 | 296.45 | 932837.0 |
| 2022-03-03 11:00:00 | MSFT | Stock | 296.42 | 297.67 | 296.02 | 297.35 | 1144048.0 |
| 2022-03-03 11:30:00 | MSFT | Stock | 297.34 | 297.66 | 296.37 | 297.25 | 964477.0 |
| 2022-03-03 12:00:00 | MSFT | Stock | 297.22 | 297.84 | 295.71 | 296.02 | 774991.0 |
| 2022-03-03 12:30:00 | MSFT | Stock | 296.0498 | 299.37 | 295.76 | 297.7758 | 1165457.0 |
> showing 50 of 106,170 rows — these rows as CSV