PREVIEW / stock_30min / 2021-11-05
file: by_date/stock_30min/2021/2021-11-05.parquet size: 2.3 MB rows: 113,939 symbols: 2,688
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-05 04:00:00 | AAPL | Stock | 150.94 | 151.12 | 150.65 | 150.78 | 6012.0 |
| 2021-11-05 04:30:00 | AAPL | Stock | 150.73 | 150.75 | 150.55 | 150.75 | 4132.0 |
| 2021-11-05 05:00:00 | AAPL | Stock | 150.69 | 150.83 | 150.66 | 150.78 | 4426.0 |
| 2021-11-05 05:30:00 | AAPL | Stock | 150.9 | 151.1 | 150.89 | 151.04 | 6671.0 |
| 2021-11-05 06:00:00 | AAPL | Stock | 151.06 | 151.42 | 151.06 | 151.42 | 8877.0 |
| 2021-11-05 06:30:00 | AAPL | Stock | 151.43 | 151.43 | 151.23 | 151.27 | 3796.0 |
| 2021-11-05 07:00:00 | AAPL | Stock | 151.24 | 151.33 | 150.92 | 150.92 | 40345.0 |
| 2021-11-05 07:30:00 | AAPL | Stock | 150.91 | 151.11 | 150.82 | 151.11 | 28047.0 |
| 2021-11-05 08:00:00 | AAPL | Stock | 151.2304 | 151.31 | 150.364 | 151.05 | 199220.0 |
| 2021-11-05 08:30:00 | AAPL | Stock | 151.02 | 151.48 | 150.88 | 151.3 | 239278.0 |
| 2021-11-05 09:00:00 | AAPL | Stock | 151.28 | 151.96 | 151.28 | 151.85 | 195066.0 |
| 2021-11-05 09:30:00 | AAPL | Stock | 151.81 | 152.19 | 151.245 | 151.65 | 7219610.0 |
| 2021-11-05 10:00:00 | AAPL | Stock | 151.6399 | 151.78 | 151.13 | 151.23 | 3446191.0 |
| 2021-11-05 10:30:00 | AAPL | Stock | 151.22 | 151.32 | 150.81 | 151.133 | 3495892.0 |
| 2021-11-05 11:00:00 | AAPL | Stock | 151.13 | 151.33 | 150.86 | 150.9496 | 2758472.0 |
| 2021-11-05 11:30:00 | AAPL | Stock | 150.9499 | 151.1 | 150.85 | 150.9126 | 2040179.0 |
| 2021-11-05 12:00:00 | AAPL | Stock | 150.91 | 151.065 | 150.87 | 150.935 | 1541403.0 |
| 2021-11-05 12:30:00 | AAPL | Stock | 150.93 | 150.9874 | 150.525 | 150.81 | 2158976.0 |
| 2021-11-05 13:00:00 | AAPL | Stock | 150.82 | 150.87 | 150.06 | 150.09 | 2123205.0 |
| 2021-11-05 13:30:00 | AAPL | Stock | 150.09 | 150.57 | 150.06 | 150.551 | 1733247.0 |
| 2021-11-05 14:00:00 | AAPL | Stock | 150.55 | 150.68 | 150.19 | 150.45 | 1839821.0 |
| 2021-11-05 14:30:00 | AAPL | Stock | 150.45 | 150.63 | 150.22 | 150.62 | 1876350.0 |
| 2021-11-05 15:00:00 | AAPL | Stock | 150.62 | 150.89 | 150.3401 | 150.815 | 2751825.0 |
| 2021-11-05 15:30:00 | AAPL | Stock | 150.8177 | 151.46 | 150.815 | 151.27 | 6186715.0 |
| 2021-11-05 16:00:00 | AAPL | Stock | 151.28 | 151.28 | 150.91 | 151.0 | 9521616.0 |
| 2021-11-05 16:30:00 | AAPL | Stock | 151.0 | 151.28 | 150.45 | 151.25 | 81626.0 |
| 2021-11-05 17:00:00 | AAPL | Stock | 151.23 | 151.23 | 151.07 | 151.1 | 18628.0 |
| 2021-11-05 17:30:00 | AAPL | Stock | 151.1 | 151.15 | 151.1 | 151.15 | 6971.0 |
| 2021-11-05 18:00:00 | AAPL | Stock | 151.17 | 151.19 | 151.11 | 151.18 | 5335.0 |
| 2021-11-05 18:30:00 | AAPL | Stock | 151.12 | 151.17 | 151.11 | 151.1201 | 10936.0 |
| 2021-11-05 19:00:00 | AAPL | Stock | 151.11 | 151.15 | 151.11 | 151.1101 | 7846.0 |
| 2021-11-05 19:30:00 | AAPL | Stock | 151.16 | 151.16 | 151.01 | 151.05 | 17210.0 |
| 2021-11-05 04:00:00 | MSFT | Stock | 337.67 | 338.56 | 337.15 | 337.15 | 1381.0 |
| 2021-11-05 04:30:00 | MSFT | Stock | 337.33 | 337.67 | 337.23 | 337.37 | 1248.0 |
| 2021-11-05 05:00:00 | MSFT | Stock | 337.43 | 337.76 | 337.43 | 337.7 | 5159.0 |
| 2021-11-05 05:30:00 | MSFT | Stock | 337.83 | 337.94 | 337.8 | 337.92 | 1506.0 |
| 2021-11-05 06:00:00 | MSFT | Stock | 337.94 | 337.95 | 337.81 | 337.87 | 1803.0 |
| 2021-11-05 06:30:00 | MSFT | Stock | 337.93 | 338.0 | 337.26 | 337.26 | 6467.0 |
| 2021-11-05 07:00:00 | MSFT | Stock | 337.68 | 337.68 | 336.0 | 336.0 | 28726.0 |
| 2021-11-05 07:30:00 | MSFT | Stock | 335.87 | 336.84 | 335.73 | 335.86 | 21878.0 |
| 2021-11-05 08:00:00 | MSFT | Stock | 337.8328 | 337.8328 | 335.73 | 336.81 | 16644.0 |
| 2021-11-05 08:30:00 | MSFT | Stock | 336.7 | 337.66 | 336.0 | 337.45 | 34380.0 |
| 2021-11-05 09:00:00 | MSFT | Stock | 337.45 | 338.79 | 337.42 | 338.6 | 28045.0 |
| 2021-11-05 09:30:00 | MSFT | Stock | 338.6 | 338.86 | 335.91 | 337.45 | 2284744.0 |
| 2021-11-05 10:00:00 | MSFT | Stock | 337.42 | 337.78 | 336.79 | 337.295 | 1026672.0 |
| 2021-11-05 10:30:00 | MSFT | Stock | 337.285 | 337.5696 | 336.94 | 337.0 | 742183.0 |
| 2021-11-05 11:00:00 | MSFT | Stock | 337.01 | 337.13 | 336.16 | 336.22 | 706793.0 |
| 2021-11-05 11:30:00 | MSFT | Stock | 336.22 | 337.55 | 336.18 | 337.115 | 826452.0 |
| 2021-11-05 12:00:00 | MSFT | Stock | 337.12 | 337.2 | 336.29 | 336.41 | 600468.0 |
| 2021-11-05 12:30:00 | MSFT | Stock | 336.42 | 336.64 | 336.06 | 336.2497 | 633341.0 |
> showing 50 of 113,939 rows — these rows as CSV