PREVIEW / stock_30min / 2022-02-10
file: by_date/stock_30min/2022/2022-02-10.parquet size: 2.2 MB rows: 110,168 symbols: 2,555
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-02-10 04:00:00 | AAPL | Stock | 175.75 | 175.75 | 175.39 | 175.5 | 5023.0 |
| 2022-02-10 04:30:00 | AAPL | Stock | 175.5 | 175.69 | 175.41 | 175.68 | 5932.0 |
| 2022-02-10 05:00:00 | AAPL | Stock | 175.65 | 175.65 | 175.65 | 175.65 | 290.0 |
| 2022-02-10 05:30:00 | AAPL | Stock | 175.63 | 175.68 | 175.55 | 175.55 | 1684.0 |
| 2022-02-10 06:00:00 | AAPL | Stock | 175.52 | 175.52 | 175.5 | 175.5 | 387.0 |
| 2022-02-10 06:30:00 | AAPL | Stock | 175.56 | 175.6 | 175.51 | 175.51 | 6806.0 |
| 2022-02-10 07:00:00 | AAPL | Stock | 175.6 | 175.99 | 175.6 | 175.85 | 31657.0 |
| 2022-02-10 07:30:00 | AAPL | Stock | 175.9 | 175.97 | 175.86 | 175.94 | 14633.0 |
| 2022-02-10 08:00:00 | AAPL | Stock | 175.97 | 176.27 | 175.62 | 176.15 | 124451.0 |
| 2022-02-10 08:30:00 | AAPL | Stock | 176.19 | 176.19 | 174.0 | 174.25 | 581749.0 |
| 2022-02-10 09:00:00 | AAPL | Stock | 174.25 | 174.65 | 173.75 | 174.09 | 623898.0 |
| 2022-02-10 09:30:00 | AAPL | Stock | 174.09 | 175.3899 | 173.75 | 175.08 | 9437467.0 |
| 2022-02-10 10:00:00 | AAPL | Stock | 175.09 | 175.48 | 174.77 | 174.92 | 4786212.0 |
| 2022-02-10 10:30:00 | AAPL | Stock | 174.95 | 175.22 | 174.28 | 174.405 | 5016786.0 |
| 2022-02-10 11:00:00 | AAPL | Stock | 174.415 | 174.47 | 173.79 | 174.4 | 4688626.0 |
| 2022-02-10 11:30:00 | AAPL | Stock | 174.39 | 175.01 | 173.9 | 174.8475 | 3933464.0 |
| 2022-02-10 12:00:00 | AAPL | Stock | 174.8501 | 175.02 | 174.57 | 174.92 | 2318450.0 |
| 2022-02-10 12:30:00 | AAPL | Stock | 174.92 | 175.06 | 173.32 | 174.1 | 5281042.0 |
| 2022-02-10 13:00:00 | AAPL | Stock | 174.09 | 174.52 | 172.37 | 173.14 | 4259014.0 |
| 2022-02-10 13:30:00 | AAPL | Stock | 173.13 | 173.46 | 172.75 | 173.44 | 3740158.0 |
| 2022-02-10 14:00:00 | AAPL | Stock | 173.43 | 173.58 | 172.52 | 173.061 | 3855697.0 |
| 2022-02-10 14:30:00 | AAPL | Stock | 173.07 | 173.56 | 172.59 | 172.83 | 3407571.0 |
| 2022-02-10 15:00:00 | AAPL | Stock | 172.83 | 173.14 | 172.45 | 172.705 | 3795953.0 |
| 2022-02-10 15:30:00 | AAPL | Stock | 172.69 | 172.89 | 171.55 | 172.295 | 9176919.0 |
| 2022-02-10 16:00:00 | AAPL | Stock | 172.12 | 172.43 | 171.81 | 171.95 | 11682264.0 |
| 2022-02-10 16:30:00 | AAPL | Stock | 172.05 | 172.22 | 172.0 | 172.22 | 67550.0 |
| 2022-02-10 17:00:00 | AAPL | Stock | 172.22 | 172.26 | 172.02 | 172.15 | 25005.0 |
| 2022-02-10 17:30:00 | AAPL | Stock | 172.19 | 172.26 | 172.13 | 172.19 | 13323.0 |
| 2022-02-10 18:00:00 | AAPL | Stock | 172.19 | 172.37 | 172.07 | 172.1 | 135754.0 |
| 2022-02-10 18:30:00 | AAPL | Stock | 172.05 | 172.1 | 171.82 | 171.82 | 24239.0 |
| 2022-02-10 19:00:00 | AAPL | Stock | 171.83 | 171.98 | 171.63 | 171.63 | 55225.0 |
| 2022-02-10 19:30:00 | AAPL | Stock | 171.63 | 171.79 | 171.5 | 171.79 | 34480.0 |
| 2022-02-10 04:00:00 | MSFT | Stock | 309.2 | 309.9 | 309.16 | 309.9 | 1639.0 |
| 2022-02-10 04:30:00 | MSFT | Stock | 309.75 | 309.75 | 309.32 | 309.5 | 1095.0 |
| 2022-02-10 05:00:00 | MSFT | Stock | 309.88 | 309.88 | 309.8 | 309.8 | 313.0 |
| 2022-02-10 05:30:00 | MSFT | Stock | 310.21 | 310.21 | 310.2 | 310.2 | 782.0 |
| 2022-02-10 06:00:00 | MSFT | Stock | 310.01 | 310.01 | 309.99 | 309.99 | 550.0 |
| 2022-02-10 06:30:00 | MSFT | Stock | 309.94 | 309.94 | 309.29 | 309.3 | 900.0 |
| 2022-02-10 07:00:00 | MSFT | Stock | 309.77 | 310.44 | 309.61 | 310.44 | 3692.0 |
| 2022-02-10 07:30:00 | MSFT | Stock | 310.31 | 310.56 | 310.28 | 310.49 | 6932.0 |
| 2022-02-10 08:00:00 | MSFT | Stock | 310.2577 | 311.81 | 309.85 | 310.9 | 14256.0 |
| 2022-02-10 08:30:00 | MSFT | Stock | 311.14 | 311.14 | 306.67 | 306.71 | 114181.0 |
| 2022-02-10 09:00:00 | MSFT | Stock | 306.7 | 306.7 | 303.52 | 303.99 | 123063.0 |
| 2022-02-10 09:30:00 | MSFT | Stock | 303.99 | 307.75 | 303.33 | 307.35 | 3805610.0 |
| 2022-02-10 10:00:00 | MSFT | Stock | 307.45 | 309.12 | 306.2 | 306.4111 | 2590286.0 |
| 2022-02-10 10:30:00 | MSFT | Stock | 306.405 | 308.61 | 305.83 | 306.21 | 2489417.0 |
| 2022-02-10 11:00:00 | MSFT | Stock | 306.22 | 306.65 | 304.29 | 305.28 | 2185921.0 |
| 2022-02-10 11:30:00 | MSFT | Stock | 305.24 | 305.97 | 304.0536 | 305.845 | 1581019.0 |
| 2022-02-10 12:00:00 | MSFT | Stock | 305.861 | 306.8 | 305.3201 | 306.68 | 975229.0 |
| 2022-02-10 12:30:00 | MSFT | Stock | 306.69 | 307.05 | 303.03 | 304.31 | 1820472.0 |
> showing 50 of 110,168 rows — these rows as CSV