PREVIEW / stock_30min / 2022-08-12
file: by_date/stock_30min/2022/2022-08-12.parquet size: 2.2 MB rows: 106,324 symbols: 2,225
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-12 04:00:00 | AAPL | Stock | 168.81 | 169.69 | 168.81 | 169.38 | 12726.0 |
| 2022-08-12 04:30:00 | AAPL | Stock | 169.28 | 169.35 | 169.2 | 169.2 | 4336.0 |
| 2022-08-12 05:00:00 | AAPL | Stock | 169.09 | 169.15 | 168.99 | 169.02 | 12252.0 |
| 2022-08-12 05:30:00 | AAPL | Stock | 169.0 | 169.25 | 168.97 | 169.25 | 2197.0 |
| 2022-08-12 06:00:00 | AAPL | Stock | 169.0 | 169.0 | 168.85 | 168.97 | 2739.0 |
| 2022-08-12 06:30:00 | AAPL | Stock | 168.99 | 169.05 | 168.81 | 168.86 | 2670.0 |
| 2022-08-12 07:00:00 | AAPL | Stock | 168.96 | 169.0 | 168.72 | 168.81 | 36059.0 |
| 2022-08-12 07:30:00 | AAPL | Stock | 168.8 | 169.08 | 168.8 | 169.0 | 21032.0 |
| 2022-08-12 08:00:00 | AAPL | Stock | 168.99 | 169.5 | 168.069 | 169.37 | 225034.0 |
| 2022-08-12 08:30:00 | AAPL | Stock | 169.37 | 169.55 | 169.21 | 169.5 | 190603.0 |
| 2022-08-12 09:00:00 | AAPL | Stock | 169.53 | 170.0 | 169.44 | 169.84 | 393817.0 |
| 2022-08-12 09:30:00 | AAPL | Stock | 169.82 | 170.19 | 169.4 | 170.14 | 7303420.0 |
| 2022-08-12 10:00:00 | AAPL | Stock | 170.13 | 170.59 | 169.7 | 170.34 | 6350230.0 |
| 2022-08-12 10:30:00 | AAPL | Stock | 170.34 | 170.62 | 170.02 | 170.5001 | 3985551.0 |
| 2022-08-12 11:00:00 | AAPL | Stock | 170.51 | 171.11 | 170.43 | 170.91 | 4542267.0 |
| 2022-08-12 11:30:00 | AAPL | Stock | 170.91 | 171.1 | 170.661 | 170.9203 | 3148617.0 |
| 2022-08-12 12:00:00 | AAPL | Stock | 170.93 | 171.35 | 170.87 | 171.1973 | 2525595.0 |
| 2022-08-12 12:30:00 | AAPL | Stock | 171.1999 | 171.22 | 170.83 | 170.8801 | 1666583.0 |
| 2022-08-12 13:00:00 | AAPL | Stock | 170.879 | 171.52 | 170.81 | 171.4799 | 2664398.0 |
| 2022-08-12 13:30:00 | AAPL | Stock | 171.48 | 171.52 | 171.25 | 171.27 | 1695681.0 |
| 2022-08-12 14:00:00 | AAPL | Stock | 171.27 | 171.48 | 171.245 | 171.4599 | 1583420.0 |
| 2022-08-12 14:30:00 | AAPL | Stock | 171.47 | 171.78 | 171.46 | 171.6902 | 2322538.0 |
| 2022-08-12 15:00:00 | AAPL | Stock | 171.69 | 171.98 | 171.655 | 171.92 | 3429841.0 |
| 2022-08-12 15:30:00 | AAPL | Stock | 171.92 | 172.17 | 171.6733 | 172.15 | 7881233.0 |
| 2022-08-12 16:00:00 | AAPL | Stock | 172.14 | 172.17 | 171.81 | 172.05 | 8163877.0 |
| 2022-08-12 16:30:00 | AAPL | Stock | 172.05 | 172.1 | 172.01 | 172.04 | 63319.0 |
| 2022-08-12 17:00:00 | AAPL | Stock | 172.04 | 172.04 | 171.85 | 171.94 | 30648.0 |
| 2022-08-12 17:30:00 | AAPL | Stock | 171.95 | 171.97 | 171.7 | 171.78 | 66659.0 |
| 2022-08-12 18:00:00 | AAPL | Stock | 171.78 | 171.79 | 171.72 | 171.77 | 23872.0 |
| 2022-08-12 18:30:00 | AAPL | Stock | 171.77 | 171.84 | 171.77 | 171.82 | 15206.0 |
| 2022-08-12 19:00:00 | AAPL | Stock | 171.82 | 171.88 | 171.79 | 171.88 | 11895.0 |
| 2022-08-12 19:30:00 | AAPL | Stock | 171.88 | 171.9 | 171.85 | 171.9 | 25732.0 |
| 2022-08-12 04:00:00 | MSFT | Stock | 288.02 | 288.7 | 288.02 | 288.7 | 1066.0 |
| 2022-08-12 04:30:00 | MSFT | Stock | 288.64 | 288.8 | 288.6 | 288.6 | 1177.0 |
| 2022-08-12 05:00:00 | MSFT | Stock | 288.65 | 288.65 | 288.65 | 288.65 | 824.0 |
| 2022-08-12 05:30:00 | MSFT | Stock | 288.7 | 288.8 | 288.7 | 288.8 | 315.0 |
| 2022-08-12 06:00:00 | MSFT | Stock | 288.96 | 288.96 | 288.6 | 288.6 | 200.0 |
| 2022-08-12 06:30:00 | MSFT | Stock | 288.96 | 288.96 | 288.6 | 288.6 | 500.0 |
| 2022-08-12 07:00:00 | MSFT | Stock | 288.57 | 288.59 | 287.65 | 287.78 | 4225.0 |
| 2022-08-12 07:30:00 | MSFT | Stock | 287.95 | 288.0 | 287.81 | 288.0 | 3281.0 |
| 2022-08-12 08:00:00 | MSFT | Stock | 288.0 | 288.75 | 286.303 | 288.41 | 10007.0 |
| 2022-08-12 08:30:00 | MSFT | Stock | 288.41 | 288.85 | 288.1616 | 288.4 | 13099.0 |
| 2022-08-12 09:00:00 | MSFT | Stock | 288.49 | 288.96 | 288.2 | 288.41 | 24045.0 |
| 2022-08-12 09:30:00 | MSFT | Stock | 288.57 | 288.99 | 287.19 | 287.97 | 1448164.0 |
| 2022-08-12 10:00:00 | MSFT | Stock | 287.97 | 289.07 | 286.94 | 288.4 | 938333.0 |
| 2022-08-12 10:30:00 | MSFT | Stock | 288.39 | 288.87 | 287.89 | 288.53 | 541432.0 |
| 2022-08-12 11:00:00 | MSFT | Stock | 288.5 | 289.68 | 288.13 | 289.27 | 716208.0 |
| 2022-08-12 11:30:00 | MSFT | Stock | 289.28 | 289.48 | 288.73 | 288.81 | 561780.0 |
| 2022-08-12 12:00:00 | MSFT | Stock | 288.85 | 289.46 | 288.76 | 289.26 | 340805.0 |
| 2022-08-12 12:30:00 | MSFT | Stock | 289.3 | 289.5 | 288.92 | 289.11 | 285559.0 |
> showing 50 of 106,324 rows — these rows as CSV