PREVIEW / stock_30min / 2022-06-10
file: by_date/stock_30min/2022/2022-06-10.parquet size: 2.1 MB rows: 106,510 symbols: 2,360
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-10 04:00:00 | AAPL | Stock | 143.03 | 143.45 | 142.9 | 143.4 | 8334.0 |
| 2022-06-10 04:30:00 | AAPL | Stock | 143.38 | 143.48 | 142.98 | 143.0 | 19248.0 |
| 2022-06-10 05:00:00 | AAPL | Stock | 143.04 | 143.38 | 143.04 | 143.36 | 5734.0 |
| 2022-06-10 05:30:00 | AAPL | Stock | 143.29 | 143.29 | 143.2 | 143.26 | 1403.0 |
| 2022-06-10 06:00:00 | AAPL | Stock | 143.29 | 143.31 | 142.99 | 143.02 | 5526.0 |
| 2022-06-10 06:30:00 | AAPL | Stock | 142.97 | 142.97 | 142.77 | 142.95 | 2359.0 |
| 2022-06-10 07:00:00 | AAPL | Stock | 143.03 | 143.08 | 142.75 | 142.85 | 37435.0 |
| 2022-06-10 07:30:00 | AAPL | Stock | 142.84 | 143.19 | 142.84 | 142.95 | 32512.0 |
| 2022-06-10 08:00:00 | AAPL | Stock | 142.7999 | 143.7 | 142.75 | 143.1 | 180262.0 |
| 2022-06-10 08:30:00 | AAPL | Stock | 143.09 | 143.09 | 139.66 | 140.05 | 1006150.0 |
| 2022-06-10 09:00:00 | AAPL | Stock | 139.86 | 140.74 | 139.4 | 140.28 | 507701.0 |
| 2022-06-10 09:30:00 | AAPL | Stock | 140.28 | 140.76 | 138.32 | 138.49 | 10991946.0 |
| 2022-06-10 10:00:00 | AAPL | Stock | 138.48 | 138.515 | 137.46 | 137.49 | 7247782.0 |
| 2022-06-10 10:30:00 | AAPL | Stock | 137.4899 | 138.539 | 137.38 | 137.64 | 6304796.0 |
| 2022-06-10 11:00:00 | AAPL | Stock | 137.64 | 138.0513 | 137.27 | 137.4 | 4772981.0 |
| 2022-06-10 11:30:00 | AAPL | Stock | 137.411 | 138.0 | 137.29 | 137.84 | 3518107.0 |
| 2022-06-10 12:00:00 | AAPL | Stock | 137.8586 | 138.07 | 137.45 | 137.975 | 3137027.0 |
| 2022-06-10 12:30:00 | AAPL | Stock | 137.98 | 138.21 | 137.55 | 137.7747 | 2990708.0 |
| 2022-06-10 13:00:00 | AAPL | Stock | 137.775 | 138.1 | 137.46 | 138.09 | 2530537.0 |
| 2022-06-10 13:30:00 | AAPL | Stock | 138.09 | 138.74 | 137.73 | 138.2 | 3511909.0 |
| 2022-06-10 14:00:00 | AAPL | Stock | 138.21 | 138.25 | 137.79 | 137.96 | 2757615.0 |
| 2022-06-10 14:30:00 | AAPL | Stock | 137.96 | 139.02 | 137.95 | 138.74 | 3667935.0 |
| 2022-06-10 15:00:00 | AAPL | Stock | 138.75 | 139.165 | 138.12 | 138.87 | 4988862.0 |
| 2022-06-10 15:30:00 | AAPL | Stock | 138.87 | 138.9 | 137.06 | 137.12 | 11071887.0 |
| 2022-06-10 16:00:00 | AAPL | Stock | 137.125 | 137.52 | 137.06 | 137.37 | 10251907.0 |
| 2022-06-10 16:30:00 | AAPL | Stock | 137.4 | 137.5 | 137.31 | 137.37 | 36508.0 |
| 2022-06-10 17:00:00 | AAPL | Stock | 137.35 | 137.37 | 137.13 | 137.29 | 116536.0 |
| 2022-06-10 17:30:00 | AAPL | Stock | 137.3 | 137.33 | 137.13 | 137.28 | 30468.0 |
| 2022-06-10 18:00:00 | AAPL | Stock | 137.3 | 137.3 | 137.25 | 137.25 | 11540.0 |
| 2022-06-10 18:30:00 | AAPL | Stock | 137.2899 | 137.4 | 137.28 | 137.35 | 51437.0 |
| 2022-06-10 19:00:00 | AAPL | Stock | 137.35 | 137.4 | 137.29 | 137.38 | 17986.0 |
| 2022-06-10 19:30:00 | AAPL | Stock | 137.4 | 137.5 | 137.35 | 137.37 | 28125.0 |
| 2022-06-10 04:00:00 | MSFT | Stock | 264.73 | 265.5 | 264.73 | 265.5 | 1405.0 |
| 2022-06-10 04:30:00 | MSFT | Stock | 265.4 | 265.4 | 265.14 | 265.2 | 1615.0 |
| 2022-06-10 05:00:00 | MSFT | Stock | 265.5 | 265.5 | 265.5 | 265.5 | 100.0 |
| 2022-06-10 05:30:00 | MSFT | Stock | 265.49 | 265.71 | 265.15 | 265.3 | 3244.0 |
| 2022-06-10 06:00:00 | MSFT | Stock | 265.05 | 265.05 | 265.0 | 265.0 | 200.0 |
| 2022-06-10 06:30:00 | MSFT | Stock | 265.1 | 265.1 | 265.1 | 265.1 | 100.0 |
| 2022-06-10 07:00:00 | MSFT | Stock | 265.08 | 265.35 | 264.77 | 265.1 | 6512.0 |
| 2022-06-10 07:30:00 | MSFT | Stock | 265.18 | 265.85 | 265.18 | 265.6 | 7232.0 |
| 2022-06-10 08:00:00 | MSFT | Stock | 265.0 | 266.55 | 264.129 | 266.0 | 16153.0 |
| 2022-06-10 08:30:00 | MSFT | Stock | 265.75 | 265.75 | 260.22 | 260.22 | 122375.0 |
| 2022-06-10 09:00:00 | MSFT | Stock | 260.25 | 261.4454 | 259.6 | 260.42 | 43456.0 |
| 2022-06-10 09:30:00 | MSFT | Stock | 260.42 | 260.58 | 255.65 | 256.31 | 3246379.0 |
| 2022-06-10 10:00:00 | MSFT | Stock | 255.79 | 256.27 | 254.43 | 254.43 | 2082335.0 |
| 2022-06-10 10:30:00 | MSFT | Stock | 254.42 | 255.4 | 253.95 | 254.07 | 1881018.0 |
| 2022-06-10 11:00:00 | MSFT | Stock | 254.07 | 255.5 | 254.03 | 254.84 | 1222022.0 |
| 2022-06-10 11:30:00 | MSFT | Stock | 254.85 | 255.4285 | 254.48 | 255.175 | 908554.0 |
| 2022-06-10 12:00:00 | MSFT | Stock | 255.18 | 255.56 | 254.43 | 254.69 | 786259.0 |
| 2022-06-10 12:30:00 | MSFT | Stock | 254.71 | 255.2 | 254.1201 | 254.38 | 609462.0 |
> showing 50 of 106,510 rows — these rows as CSV