PREVIEW / stock_30min / 2021-11-16
file: by_date/stock_30min/2021/2021-11-16.parquet size: 2.3 MB rows: 114,802 symbols: 2,696
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-11-16 04:00:00 | AAPL | Stock | 149.92 | 149.92 | 149.92 | 149.92 | 153.0 |
| 2021-11-16 04:30:00 | AAPL | Stock | 149.8 | 149.8 | 149.6 | 149.7 | 7921.0 |
| 2021-11-16 05:00:00 | AAPL | Stock | 149.62 | 149.62 | 149.57 | 149.57 | 2106.0 |
| 2021-11-16 05:30:00 | AAPL | Stock | 149.57 | 149.68 | 149.57 | 149.68 | 2466.0 |
| 2021-11-16 06:00:00 | AAPL | Stock | 149.67 | 149.72 | 149.66 | 149.72 | 1474.0 |
| 2021-11-16 06:30:00 | AAPL | Stock | 149.75 | 150.0 | 149.75 | 149.99 | 2984.0 |
| 2021-11-16 07:00:00 | AAPL | Stock | 149.98 | 150.15 | 149.98 | 150.09 | 22643.0 |
| 2021-11-16 07:30:00 | AAPL | Stock | 150.08 | 150.24 | 150.02 | 150.13 | 23594.0 |
| 2021-11-16 08:00:00 | AAPL | Stock | 150.08 | 150.22 | 149.625 | 150.1 | 128440.0 |
| 2021-11-16 08:30:00 | AAPL | Stock | 150.1 | 150.25 | 149.87 | 149.99 | 92759.0 |
| 2021-11-16 09:00:00 | AAPL | Stock | 149.99 | 150.04 | 149.74 | 150.0 | 74899.0 |
| 2021-11-16 09:30:00 | AAPL | Stock | 149.93 | 150.39 | 149.6 | 149.845 | 6101044.0 |
| 2021-11-16 10:00:00 | AAPL | Stock | 149.84 | 149.9 | 149.34 | 149.37 | 3197406.0 |
| 2021-11-16 10:30:00 | AAPL | Stock | 149.37 | 149.8177 | 149.3427 | 149.68 | 1968595.0 |
| 2021-11-16 11:00:00 | AAPL | Stock | 149.675 | 151.285 | 149.6627 | 151.085 | 4883753.0 |
| 2021-11-16 11:30:00 | AAPL | Stock | 151.09 | 151.37 | 150.89 | 151.17 | 3859558.0 |
| 2021-11-16 12:00:00 | AAPL | Stock | 151.18 | 151.488 | 151.08 | 151.13 | 2624942.0 |
| 2021-11-16 12:30:00 | AAPL | Stock | 151.1274 | 151.365 | 151.06 | 151.155 | 1603563.0 |
| 2021-11-16 13:00:00 | AAPL | Stock | 151.14 | 151.275 | 151.0 | 151.0675 | 1493585.0 |
| 2021-11-16 13:30:00 | AAPL | Stock | 151.065 | 151.47 | 151.05 | 151.385 | 2139124.0 |
| 2021-11-16 14:00:00 | AAPL | Stock | 151.39 | 151.47 | 151.06 | 151.141 | 1782181.0 |
| 2021-11-16 14:30:00 | AAPL | Stock | 151.15 | 151.2 | 150.94 | 151.03 | 1635883.0 |
| 2021-11-16 15:00:00 | AAPL | Stock | 151.03 | 151.1 | 150.805 | 151.0495 | 1784671.0 |
| 2021-11-16 15:30:00 | AAPL | Stock | 151.04 | 151.25 | 150.92 | 151.0 | 4517206.0 |
| 2021-11-16 16:00:00 | AAPL | Stock | 151.0 | 151.24 | 150.63 | 151.06 | 8234831.0 |
| 2021-11-16 16:30:00 | AAPL | Stock | 151.03 | 151.05 | 150.96 | 150.99 | 32169.0 |
| 2021-11-16 17:00:00 | AAPL | Stock | 150.96 | 151.0 | 150.95 | 150.99 | 7340.0 |
| 2021-11-16 17:30:00 | AAPL | Stock | 150.96 | 151.14 | 150.91 | 151.13 | 19156.0 |
| 2021-11-16 18:00:00 | AAPL | Stock | 151.1 | 151.15 | 151.0 | 151.0 | 22116.0 |
| 2021-11-16 18:30:00 | AAPL | Stock | 151.0001 | 151.12 | 150.94 | 151.05 | 23659.0 |
| 2021-11-16 19:00:00 | AAPL | Stock | 151.02 | 151.08 | 151.01 | 151.03 | 4899.0 |
| 2021-11-16 19:30:00 | AAPL | Stock | 151.05 | 151.05 | 150.91 | 151.0 | 9260.0 |
| 2021-11-16 04:00:00 | MSFT | Stock | 336.55 | 336.55 | 336.55 | 336.55 | 100.0 |
| 2021-11-16 04:30:00 | MSFT | Stock | 336.61 | 336.68 | 336.61 | 336.68 | 300.0 |
| 2021-11-16 05:00:00 | MSFT | Stock | 336.67 | 336.8 | 336.32 | 336.5 | 1344.0 |
| 2021-11-16 05:30:00 | MSFT | Stock | 336.7 | 336.77 | 336.54 | 336.77 | 1818.0 |
| 2021-11-16 06:00:00 | MSFT | Stock | 336.73 | 336.9 | 336.73 | 336.9 | 3383.0 |
| 2021-11-16 06:30:00 | MSFT | Stock | 337.41 | 337.75 | 337.2 | 337.25 | 11955.0 |
| 2021-11-16 07:00:00 | MSFT | Stock | 337.13 | 337.13 | 336.7 | 336.9 | 11083.0 |
| 2021-11-16 07:30:00 | MSFT | Stock | 336.85 | 337.1 | 336.62 | 336.8 | 8948.0 |
| 2021-11-16 08:00:00 | MSFT | Stock | 337.05 | 337.19 | 336.6201 | 336.91 | 8248.0 |
| 2021-11-16 08:30:00 | MSFT | Stock | 336.91 | 337.13 | 336.35 | 336.4 | 22030.0 |
| 2021-11-16 09:00:00 | MSFT | Stock | 336.38 | 336.4 | 335.54 | 335.7 | 26863.0 |
| 2021-11-16 09:30:00 | MSFT | Stock | 335.86 | 337.56 | 335.51 | 337.0 | 1717125.0 |
| 2021-11-16 10:00:00 | MSFT | Stock | 337.02 | 338.01 | 336.8259 | 336.9 | 973153.0 |
| 2021-11-16 10:30:00 | MSFT | Stock | 336.9 | 337.8493 | 336.71 | 337.7199 | 715495.0 |
| 2021-11-16 11:00:00 | MSFT | Stock | 337.7 | 339.98 | 337.69 | 339.54 | 1398872.0 |
| 2021-11-16 11:30:00 | MSFT | Stock | 339.55 | 339.88 | 339.02 | 339.09 | 678447.0 |
| 2021-11-16 12:00:00 | MSFT | Stock | 339.11 | 339.94 | 339.02 | 339.6244 | 808187.0 |
| 2021-11-16 12:30:00 | MSFT | Stock | 339.5951 | 340.43 | 339.515 | 340.3386 | 687011.0 |
> showing 50 of 114,802 rows — these rows as CSV