PREVIEW / stock_30min / 2022-08-15
file: by_date/stock_30min/2022/2022-08-15.parquet size: 2.2 MB rows: 109,076 symbols: 2,278
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-08-15 04:00:00 | AAPL | Stock | 171.37 | 171.39 | 170.81 | 171.15 | 8404.0 |
| 2022-08-15 04:30:00 | AAPL | Stock | 171.17 | 171.36 | 171.1 | 171.1 | 5428.0 |
| 2022-08-15 05:00:00 | AAPL | Stock | 171.14 | 171.15 | 170.88 | 170.94 | 7114.0 |
| 2022-08-15 05:30:00 | AAPL | Stock | 170.94 | 171.09 | 170.75 | 171.09 | 5752.0 |
| 2022-08-15 06:00:00 | AAPL | Stock | 171.09 | 171.2 | 171.02 | 171.1 | 7283.0 |
| 2022-08-15 06:30:00 | AAPL | Stock | 171.12 | 171.41 | 171.12 | 171.39 | 6228.0 |
| 2022-08-15 07:00:00 | AAPL | Stock | 171.46 | 171.68 | 171.37 | 171.57 | 36117.0 |
| 2022-08-15 07:30:00 | AAPL | Stock | 171.55 | 171.55 | 171.12 | 171.37 | 26542.0 |
| 2022-08-15 08:00:00 | AAPL | Stock | 171.4 | 171.71 | 170.9 | 171.71 | 327271.0 |
| 2022-08-15 08:30:00 | AAPL | Stock | 171.69 | 171.69 | 170.95 | 171.04 | 210265.0 |
| 2022-08-15 09:00:00 | AAPL | Stock | 171.02 | 171.55 | 171.01 | 171.51 | 197320.0 |
| 2022-08-15 09:30:00 | AAPL | Stock | 171.5 | 172.38 | 171.345 | 172.1701 | 7318278.0 |
| 2022-08-15 10:00:00 | AAPL | Stock | 172.18 | 172.35 | 171.655 | 172.2244 | 3363966.0 |
| 2022-08-15 10:30:00 | AAPL | Stock | 172.225 | 172.46 | 171.72 | 171.83 | 2841490.0 |
| 2022-08-15 11:00:00 | AAPL | Stock | 171.83 | 172.36 | 171.67 | 172.35 | 2321645.0 |
| 2022-08-15 11:30:00 | AAPL | Stock | 172.36 | 173.25 | 172.25 | 173.025 | 3429625.0 |
| 2022-08-15 12:00:00 | AAPL | Stock | 173.03 | 173.3 | 172.75 | 173.25 | 2463760.0 |
| 2022-08-15 12:30:00 | AAPL | Stock | 173.25 | 173.3 | 173.01 | 173.11 | 1770845.0 |
| 2022-08-15 13:00:00 | AAPL | Stock | 173.115 | 173.27 | 172.91 | 173.08 | 1663319.0 |
| 2022-08-15 13:30:00 | AAPL | Stock | 173.08 | 173.185 | 172.97 | 173.1112 | 1274316.0 |
| 2022-08-15 14:00:00 | AAPL | Stock | 173.11 | 173.13 | 172.83 | 172.96 | 1517831.0 |
| 2022-08-15 14:30:00 | AAPL | Stock | 172.963 | 173.11 | 172.84 | 172.995 | 1658565.0 |
| 2022-08-15 15:00:00 | AAPL | Stock | 173.0 | 173.39 | 172.95 | 173.3 | 2743232.0 |
| 2022-08-15 15:30:00 | AAPL | Stock | 173.3 | 173.3 | 172.92 | 173.19 | 4195420.0 |
| 2022-08-15 16:00:00 | AAPL | Stock | 173.19 | 173.2 | 172.92 | 172.95 | 4686797.0 |
| 2022-08-15 16:30:00 | AAPL | Stock | 172.99 | 173.19 | 172.98 | 172.99 | 36431.0 |
| 2022-08-15 17:00:00 | AAPL | Stock | 173.0 | 173.07 | 172.96 | 173.05 | 19708.0 |
| 2022-08-15 17:30:00 | AAPL | Stock | 172.98 | 173.19 | 172.98 | 173.0786 | 70478.0 |
| 2022-08-15 18:00:00 | AAPL | Stock | 173.01 | 173.06 | 172.98 | 172.98 | 8503.0 |
| 2022-08-15 18:30:00 | AAPL | Stock | 172.98 | 173.05 | 172.96 | 172.96 | 12321.0 |
| 2022-08-15 19:00:00 | AAPL | Stock | 172.98 | 173.1 | 172.96 | 173.1 | 10647.0 |
| 2022-08-15 19:30:00 | AAPL | Stock | 173.09 | 173.15 | 173.02 | 173.15 | 15565.0 |
| 2022-08-15 04:00:00 | MSFT | Stock | 291.49 | 291.49 | 290.12 | 290.51 | 1251.0 |
| 2022-08-15 04:30:00 | MSFT | Stock | 290.4 | 290.4 | 290.4 | 290.4 | 136.0 |
| 2022-08-15 05:00:00 | MSFT | Stock | 290.42 | 290.42 | 290.34 | 290.34 | 910.0 |
| 2022-08-15 05:30:00 | MSFT | Stock | 290.2 | 290.2 | 290.2 | 290.2 | 210.0 |
| 2022-08-15 06:00:00 | MSFT | Stock | 291.08 | 291.87 | 291.08 | 291.24 | 745.0 |
| 2022-08-15 06:30:00 | MSFT | Stock | 291.23 | 291.74 | 291.23 | 291.5 | 1314.0 |
| 2022-08-15 07:00:00 | MSFT | Stock | 291.61 | 291.67 | 291.06 | 291.06 | 3789.0 |
| 2022-08-15 07:30:00 | MSFT | Stock | 291.25 | 291.25 | 290.5 | 290.5 | 4793.0 |
| 2022-08-15 08:00:00 | MSFT | Stock | 291.7392 | 291.74 | 290.25 | 291.51 | 23941.0 |
| 2022-08-15 08:30:00 | MSFT | Stock | 291.32 | 291.32 | 290.51 | 290.55 | 9140.0 |
| 2022-08-15 09:00:00 | MSFT | Stock | 290.54 | 291.37 | 290.53 | 291.21 | 18071.0 |
| 2022-08-15 09:30:00 | MSFT | Stock | 290.83 | 292.6799 | 290.45 | 292.12 | 1602847.0 |
| 2022-08-15 10:00:00 | MSFT | Stock | 292.17 | 292.2 | 290.11 | 290.66 | 774118.0 |
| 2022-08-15 10:30:00 | MSFT | Stock | 290.63 | 291.2499 | 290.21 | 290.5 | 660113.0 |
| 2022-08-15 11:00:00 | MSFT | Stock | 290.48 | 291.74 | 290.22 | 291.63 | 569673.0 |
| 2022-08-15 11:30:00 | MSFT | Stock | 291.62 | 292.8 | 291.58 | 292.68 | 605462.0 |
| 2022-08-15 12:00:00 | MSFT | Stock | 292.7 | 292.75 | 292.27 | 292.61 | 329202.0 |
| 2022-08-15 12:30:00 | MSFT | Stock | 292.64 | 292.95 | 292.55 | 292.8 | 510250.0 |
> showing 50 of 109,076 rows — these rows as CSV