PREVIEW / stock_30min / 2022-12-30
file: by_date/stock_30min/2022/2022-12-30.parquet size: 2.1 MB rows: 104,681 symbols: 1,975
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-12-30 04:00:00 | AAPL | Stock | 129.0 | 129.19 | 128.75 | 128.8 | 18156.0 |
| 2022-12-30 04:30:00 | AAPL | Stock | 128.85 | 129.18 | 128.85 | 129.1 | 9717.0 |
| 2022-12-30 05:00:00 | AAPL | Stock | 129.1 | 129.11 | 128.85 | 129.0 | 7941.0 |
| 2022-12-30 05:30:00 | AAPL | Stock | 129.04 | 129.18 | 128.98 | 129.14 | 7277.0 |
| 2022-12-30 06:00:00 | AAPL | Stock | 129.17 | 129.17 | 129.09 | 129.09 | 4128.0 |
| 2022-12-30 06:30:00 | AAPL | Stock | 129.1 | 129.19 | 129.1 | 129.15 | 1698.0 |
| 2022-12-30 07:00:00 | AAPL | Stock | 129.17 | 129.22 | 128.65 | 128.7 | 24249.0 |
| 2022-12-30 07:30:00 | AAPL | Stock | 128.6 | 128.66 | 128.4 | 128.47 | 20144.0 |
| 2022-12-30 08:00:00 | AAPL | Stock | 128.8583 | 129.72 | 127.84 | 128.0 | 191390.0 |
| 2022-12-30 08:30:00 | AAPL | Stock | 128.0 | 128.37 | 127.88 | 128.19 | 113566.0 |
| 2022-12-30 09:00:00 | AAPL | Stock | 128.19 | 128.58 | 128.0 | 128.5 | 118841.0 |
| 2022-12-30 09:30:00 | AAPL | Stock | 128.41 | 128.69 | 127.48 | 127.8801 | 7675643.0 |
| 2022-12-30 10:00:00 | AAPL | Stock | 127.881 | 128.65 | 127.43 | 128.4298 | 5729901.0 |
| 2022-12-30 10:30:00 | AAPL | Stock | 128.43 | 129.25 | 128.26 | 128.8375 | 5019180.0 |
| 2022-12-30 11:00:00 | AAPL | Stock | 128.833 | 129.0 | 128.08 | 128.31 | 4211235.0 |
| 2022-12-30 11:30:00 | AAPL | Stock | 128.32 | 129.05 | 128.21 | 128.995 | 3496019.0 |
| 2022-12-30 12:00:00 | AAPL | Stock | 128.995 | 129.08 | 128.73 | 128.815 | 2473026.0 |
| 2022-12-30 12:30:00 | AAPL | Stock | 128.815 | 129.03 | 128.635 | 128.955 | 2171291.0 |
| 2022-12-30 13:00:00 | AAPL | Stock | 128.96 | 128.965 | 128.02 | 128.33 | 3154760.0 |
| 2022-12-30 13:30:00 | AAPL | Stock | 128.33 | 128.67 | 128.265 | 128.375 | 2693370.0 |
| 2022-12-30 14:00:00 | AAPL | Stock | 128.38 | 128.395 | 127.97 | 128.22 | 2778457.0 |
| 2022-12-30 14:30:00 | AAPL | Stock | 128.225 | 128.38 | 128.08 | 128.28 | 2643243.0 |
| 2022-12-30 15:00:00 | AAPL | Stock | 128.28 | 129.18 | 128.255 | 128.91 | 5150928.0 |
| 2022-12-30 15:30:00 | AAPL | Stock | 128.92 | 129.95 | 128.86 | 129.91 | 9659362.0 |
| 2022-12-30 16:00:00 | AAPL | Stock | 129.91 | 130.04 | 129.78 | 130.01 | 10237705.0 |
| 2022-12-30 16:30:00 | AAPL | Stock | 130.02 | 130.05 | 129.93 | 129.99 | 101585.0 |
| 2022-12-30 17:00:00 | AAPL | Stock | 130.0 | 130.02 | 129.91 | 129.95 | 35334.0 |
| 2022-12-30 17:30:00 | AAPL | Stock | 129.94 | 130.05 | 129.91 | 129.9487 | 31428.0 |
| 2022-12-30 18:00:00 | AAPL | Stock | 129.95 | 130.0 | 129.94 | 129.95 | 12286.0 |
| 2022-12-30 18:30:00 | AAPL | Stock | 129.94 | 130.05 | 129.94 | 130.01 | 16846.0 |
| 2022-12-30 19:00:00 | AAPL | Stock | 129.99 | 130.04 | 129.99 | 130.0 | 10423.0 |
| 2022-12-30 19:30:00 | AAPL | Stock | 130.0 | 130.04 | 129.97 | 129.97 | 23957.0 |
| 2022-12-30 04:00:00 | MSFT | Stock | 240.0 | 240.0 | 238.87 | 239.14 | 2037.0 |
| 2022-12-30 04:30:00 | MSFT | Stock | 239.33 | 239.54 | 239.31 | 239.54 | 7633.0 |
| 2022-12-30 05:00:00 | MSFT | Stock | 239.81 | 239.86 | 239.69 | 239.86 | 1666.0 |
| 2022-12-30 05:30:00 | MSFT | Stock | 240.18 | 240.48 | 240.01 | 240.01 | 574.0 |
| 2022-12-30 06:00:00 | MSFT | Stock | 239.79 | 239.9 | 239.79 | 239.9 | 566.0 |
| 2022-12-30 07:00:00 | MSFT | Stock | 239.62 | 239.7 | 239.5 | 239.5 | 5423.0 |
| 2022-12-30 07:30:00 | MSFT | Stock | 239.27 | 239.27 | 238.61 | 238.8 | 6608.0 |
| 2022-12-30 08:00:00 | MSFT | Stock | 239.6 | 239.7399 | 238.205 | 238.3 | 14115.0 |
| 2022-12-30 08:30:00 | MSFT | Stock | 238.3 | 238.7 | 238.2 | 238.5 | 7125.0 |
| 2022-12-30 09:00:00 | MSFT | Stock | 238.5 | 238.5 | 237.77 | 238.5 | 15699.0 |
| 2022-12-30 09:30:00 | MSFT | Stock | 238.21 | 238.94 | 236.66 | 238.025 | 1735961.0 |
| 2022-12-30 10:00:00 | MSFT | Stock | 238.0101 | 238.3814 | 237.16 | 237.7 | 912557.0 |
| 2022-12-30 10:30:00 | MSFT | Stock | 237.685 | 239.03 | 237.29 | 237.99 | 910526.0 |
| 2022-12-30 11:00:00 | MSFT | Stock | 237.99 | 238.4 | 237.5 | 237.78 | 685893.0 |
| 2022-12-30 11:30:00 | MSFT | Stock | 237.765 | 238.95 | 237.6601 | 238.8662 | 691284.0 |
| 2022-12-30 12:00:00 | MSFT | Stock | 238.86 | 239.19 | 238.4 | 239.05 | 521456.0 |
| 2022-12-30 12:30:00 | MSFT | Stock | 239.05 | 239.39 | 238.6441 | 239.22 | 679120.0 |
| 2022-12-30 13:00:00 | MSFT | Stock | 239.23 | 239.24 | 237.3 | 237.92 | 874613.0 |
> showing 50 of 104,681 rows — these rows as CSV