PREVIEW / stock_30min / 2022-03-21
file: by_date/stock_30min/2022/2022-03-21.parquet size: 2.2 MB rows: 110,927 symbols: 2,520
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-21 04:00:00 | AAPL | Stock | 164.0 | 164.0 | 163.3 | 163.35 | 8297.0 |
| 2022-03-21 04:30:00 | AAPL | Stock | 163.3 | 163.5 | 163.0 | 163.0 | 4234.0 |
| 2022-03-21 05:00:00 | AAPL | Stock | 163.1 | 163.36 | 163.01 | 163.36 | 4843.0 |
| 2022-03-21 05:30:00 | AAPL | Stock | 163.52 | 163.52 | 163.45 | 163.52 | 2383.0 |
| 2022-03-21 06:00:00 | AAPL | Stock | 163.51 | 163.55 | 163.45 | 163.52 | 4756.0 |
| 2022-03-21 06:30:00 | AAPL | Stock | 163.49 | 163.64 | 163.4 | 163.64 | 2474.0 |
| 2022-03-21 07:00:00 | AAPL | Stock | 163.67 | 164.2 | 163.58 | 164.15 | 37197.0 |
| 2022-03-21 07:30:00 | AAPL | Stock | 164.11 | 164.33 | 164.01 | 164.05 | 38703.0 |
| 2022-03-21 08:00:00 | AAPL | Stock | 163.74 | 164.33 | 163.0 | 163.6351 | 311073.0 |
| 2022-03-21 08:30:00 | AAPL | Stock | 163.63 | 163.82 | 163.45 | 163.6 | 159102.0 |
| 2022-03-21 09:00:00 | AAPL | Stock | 163.58 | 164.0 | 163.42 | 163.55 | 221069.0 |
| 2022-03-21 09:30:00 | AAPL | Stock | 163.51 | 165.59 | 163.5 | 164.0324 | 9631177.0 |
| 2022-03-21 10:00:00 | AAPL | Stock | 164.08 | 164.28 | 163.015 | 163.225 | 5051830.0 |
| 2022-03-21 10:30:00 | AAPL | Stock | 163.22 | 165.0 | 163.22 | 164.865 | 5362447.0 |
| 2022-03-21 11:00:00 | AAPL | Stock | 164.87 | 166.16 | 164.54 | 166.0399 | 5746195.0 |
| 2022-03-21 11:30:00 | AAPL | Stock | 166.035 | 166.35 | 165.66 | 166.25 | 5290838.0 |
| 2022-03-21 12:00:00 | AAPL | Stock | 166.25 | 166.31 | 165.37 | 165.615 | 3446488.0 |
| 2022-03-21 12:30:00 | AAPL | Stock | 165.62 | 165.645 | 163.82 | 163.935 | 5040431.0 |
| 2022-03-21 13:00:00 | AAPL | Stock | 163.94 | 164.1 | 163.16 | 163.6855 | 3684722.0 |
| 2022-03-21 13:30:00 | AAPL | Stock | 163.69 | 164.03 | 163.42 | 163.89 | 3073283.0 |
| 2022-03-21 14:00:00 | AAPL | Stock | 163.89 | 164.79 | 163.61 | 164.68 | 4169389.0 |
| 2022-03-21 14:30:00 | AAPL | Stock | 164.668 | 164.87 | 163.98 | 164.07 | 3207862.0 |
| 2022-03-21 15:00:00 | AAPL | Stock | 164.0701 | 164.76 | 163.91 | 164.69 | 2830623.0 |
| 2022-03-21 15:30:00 | AAPL | Stock | 164.7 | 165.4 | 164.1 | 165.38 | 6637682.0 |
| 2022-03-21 16:00:00 | AAPL | Stock | 165.38 | 165.82 | 165.27 | 165.36 | 11648290.0 |
| 2022-03-21 16:30:00 | AAPL | Stock | 165.37 | 165.64 | 165.33 | 165.5 | 63247.0 |
| 2022-03-21 17:00:00 | AAPL | Stock | 165.4 | 165.52 | 165.38 | 165.47 | 12172.0 |
| 2022-03-21 17:30:00 | AAPL | Stock | 165.49 | 165.49 | 165.31 | 165.42 | 42260.0 |
| 2022-03-21 18:00:00 | AAPL | Stock | 165.42 | 165.45 | 165.3 | 165.3 | 10016.0 |
| 2022-03-21 18:30:00 | AAPL | Stock | 165.35 | 165.35 | 165.13 | 165.21 | 14169.0 |
| 2022-03-21 19:00:00 | AAPL | Stock | 165.17 | 165.29 | 165.17 | 165.29 | 14760.0 |
| 2022-03-21 19:30:00 | AAPL | Stock | 165.24 | 165.24 | 165.0 | 165.0 | 34922.0 |
| 2022-03-21 04:00:00 | MSFT | Stock | 299.75 | 299.75 | 298.85 | 298.98 | 3327.0 |
| 2022-03-21 04:30:00 | MSFT | Stock | 299.47 | 299.57 | 299.23 | 299.4 | 2891.0 |
| 2022-03-21 05:00:00 | MSFT | Stock | 299.38 | 300.4 | 298.97 | 300.3 | 12961.0 |
| 2022-03-21 05:30:00 | MSFT | Stock | 300.28 | 300.43 | 300.28 | 300.43 | 2995.0 |
| 2022-03-21 06:00:00 | MSFT | Stock | 299.74 | 299.75 | 298.89 | 299.01 | 1674.0 |
| 2022-03-21 06:30:00 | MSFT | Stock | 299.09 | 299.2 | 298.78 | 298.99 | 3060.0 |
| 2022-03-21 07:00:00 | MSFT | Stock | 299.53 | 300.07 | 299.2 | 299.95 | 8341.0 |
| 2022-03-21 07:30:00 | MSFT | Stock | 300.0 | 300.07 | 299.3 | 299.41 | 5971.0 |
| 2022-03-21 08:00:00 | MSFT | Stock | 299.5 | 300.2 | 298.8 | 299.0 | 25717.0 |
| 2022-03-21 08:30:00 | MSFT | Stock | 298.99 | 298.99 | 298.25 | 298.25 | 23312.0 |
| 2022-03-21 09:00:00 | MSFT | Stock | 298.4 | 299.0 | 298.01 | 298.81 | 8287.0 |
| 2022-03-21 09:30:00 | MSFT | Stock | 298.84 | 300.14 | 296.76 | 297.1799 | 2298105.0 |
| 2022-03-21 10:00:00 | MSFT | Stock | 297.23 | 297.6 | 295.63 | 295.92 | 1315301.0 |
| 2022-03-21 10:30:00 | MSFT | Stock | 295.93 | 298.45 | 295.93 | 298.11 | 1186558.0 |
| 2022-03-21 11:00:00 | MSFT | Stock | 298.12 | 299.7755 | 297.62 | 299.46 | 1144875.0 |
| 2022-03-21 11:30:00 | MSFT | Stock | 299.49 | 299.63 | 298.48 | 299.37 | 909294.0 |
| 2022-03-21 12:00:00 | MSFT | Stock | 299.39 | 299.47 | 298.09 | 298.5 | 604083.0 |
| 2022-03-21 12:30:00 | MSFT | Stock | 298.54 | 298.5401 | 295.95 | 296.11 | 1052264.0 |
> showing 50 of 110,927 rows — these rows as CSV