PREVIEW / stock_30min / 2021-12-06
file: by_date/stock_30min/2021/2021-12-06.parquet size: 2.3 MB rows: 114,929 symbols: 2,700
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-06 04:00:00 | AAPL | Stock | 163.29 | 164.25 | 163.1 | 164.2 | 71914.0 |
| 2021-12-06 04:30:00 | AAPL | Stock | 164.2 | 164.2 | 162.8 | 163.2 | 57989.0 |
| 2021-12-06 05:00:00 | AAPL | Stock | 163.18 | 163.8 | 162.56 | 162.64 | 30836.0 |
| 2021-12-06 05:30:00 | AAPL | Stock | 162.6 | 162.87 | 161.84 | 162.12 | 42305.0 |
| 2021-12-06 06:00:00 | AAPL | Stock | 162.09 | 162.65 | 162.09 | 162.46 | 16705.0 |
| 2021-12-06 06:30:00 | AAPL | Stock | 162.37 | 163.2 | 162.35 | 163.2 | 23649.0 |
| 2021-12-06 07:00:00 | AAPL | Stock | 163.13 | 163.25 | 162.02 | 162.55 | 90914.0 |
| 2021-12-06 07:30:00 | AAPL | Stock | 162.55 | 163.65 | 162.4 | 163.51 | 231453.0 |
| 2021-12-06 08:00:00 | AAPL | Stock | 162.3102 | 163.95 | 161.436 | 163.9 | 508388.0 |
| 2021-12-06 08:30:00 | AAPL | Stock | 163.91 | 164.08 | 163.45 | 163.95 | 402308.0 |
| 2021-12-06 09:00:00 | AAPL | Stock | 163.95 | 164.32 | 163.51 | 164.32 | 338731.0 |
| 2021-12-06 09:30:00 | AAPL | Stock | 164.32 | 167.16 | 164.28 | 167.12 | 19405340.0 |
| 2021-12-06 10:00:00 | AAPL | Stock | 167.1 | 167.8799 | 165.75 | 165.94 | 13238730.0 |
| 2021-12-06 10:30:00 | AAPL | Stock | 165.93 | 166.65 | 165.28 | 165.9999 | 6263847.0 |
| 2021-12-06 11:00:00 | AAPL | Stock | 165.99 | 166.05 | 164.9028 | 165.26 | 4712243.0 |
| 2021-12-06 11:30:00 | AAPL | Stock | 165.27 | 166.24 | 165.07 | 165.61 | 4062436.0 |
| 2021-12-06 12:00:00 | AAPL | Stock | 165.61 | 166.38 | 165.6 | 166.25 | 3108953.0 |
| 2021-12-06 12:30:00 | AAPL | Stock | 166.25 | 166.44 | 165.82 | 166.2899 | 2651451.0 |
| 2021-12-06 13:00:00 | AAPL | Stock | 166.3 | 166.42 | 165.57 | 166.27 | 2980017.0 |
| 2021-12-06 13:30:00 | AAPL | Stock | 166.28 | 166.33 | 165.77 | 166.195 | 2733162.0 |
| 2021-12-06 14:00:00 | AAPL | Stock | 166.195 | 166.5 | 165.47 | 165.7301 | 3338564.0 |
| 2021-12-06 14:30:00 | AAPL | Stock | 165.7346 | 165.845 | 165.29 | 165.55 | 2749411.0 |
| 2021-12-06 15:00:00 | AAPL | Stock | 165.54 | 165.83 | 164.99 | 165.3552 | 3719054.0 |
| 2021-12-06 15:30:00 | AAPL | Stock | 165.355 | 165.66 | 165.05 | 165.29 | 7231362.0 |
| 2021-12-06 16:00:00 | AAPL | Stock | 165.32 | 165.32 | 164.89 | 165.18 | 15032724.0 |
| 2021-12-06 16:30:00 | AAPL | Stock | 165.161 | 165.32 | 165.161 | 165.29 | 50327.0 |
| 2021-12-06 17:00:00 | AAPL | Stock | 165.31 | 165.32 | 165.18 | 165.24 | 683118.0 |
| 2021-12-06 17:30:00 | AAPL | Stock | 165.24 | 165.24 | 165.04 | 165.1 | 25076.0 |
| 2021-12-06 18:00:00 | AAPL | Stock | 165.15 | 165.2 | 165.03 | 165.05 | 12727.0 |
| 2021-12-06 18:30:00 | AAPL | Stock | 165.03 | 165.09 | 165.02 | 165.09 | 9435.0 |
| 2021-12-06 19:00:00 | AAPL | Stock | 165.08 | 165.09 | 164.92 | 165.0 | 22445.0 |
| 2021-12-06 19:30:00 | AAPL | Stock | 164.95 | 165.1 | 164.83 | 165.1 | 33653.0 |
| 2021-12-06 04:00:00 | MSFT | Stock | 323.02 | 325.0 | 323.02 | 324.68 | 8375.0 |
| 2021-12-06 04:30:00 | MSFT | Stock | 324.82 | 325.15 | 322.75 | 322.99 | 5566.0 |
| 2021-12-06 05:00:00 | MSFT | Stock | 323.25 | 323.34 | 322.05 | 322.05 | 3379.0 |
| 2021-12-06 05:30:00 | MSFT | Stock | 321.71 | 322.26 | 321.05 | 321.05 | 3291.0 |
| 2021-12-06 06:00:00 | MSFT | Stock | 320.9 | 322.0 | 320.9 | 321.71 | 1819.0 |
| 2021-12-06 06:30:00 | MSFT | Stock | 321.64 | 322.19 | 321.47 | 321.47 | 1549.0 |
| 2021-12-06 07:00:00 | MSFT | Stock | 322.7 | 322.7 | 321.99 | 322.27 | 90507.0 |
| 2021-12-06 07:30:00 | MSFT | Stock | 322.2 | 322.72 | 322.15 | 322.2 | 3062.0 |
| 2021-12-06 08:00:00 | MSFT | Stock | 322.55 | 323.817 | 322.01 | 323.11 | 29090.0 |
| 2021-12-06 08:30:00 | MSFT | Stock | 322.99 | 323.62 | 322.3 | 323.38 | 15191.0 |
| 2021-12-06 09:00:00 | MSFT | Stock | 323.44 | 324.2 | 323.13 | 323.82 | 43918.0 |
| 2021-12-06 09:30:00 | MSFT | Stock | 323.95 | 324.85 | 319.23 | 320.39 | 2445807.0 |
| 2021-12-06 10:00:00 | MSFT | Stock | 320.38 | 323.51 | 319.25 | 322.29 | 1813858.0 |
| 2021-12-06 10:30:00 | MSFT | Stock | 322.34 | 323.07 | 320.8899 | 322.47 | 955786.0 |
| 2021-12-06 11:00:00 | MSFT | Stock | 322.48 | 323.175 | 321.55 | 322.01 | 743305.0 |
| 2021-12-06 11:30:00 | MSFT | Stock | 322.03 | 323.14 | 321.7287 | 322.17 | 774479.0 |
| 2021-12-06 12:00:00 | MSFT | Stock | 322.185 | 323.7999 | 321.87 | 323.4603 | 772371.0 |
| 2021-12-06 12:30:00 | MSFT | Stock | 323.52 | 324.0899 | 322.95 | 323.96 | 641917.0 |
> showing 50 of 114,929 rows — these rows as CSV