PREVIEW / stock_30min / 2022-01-10
file: by_date/stock_30min/2022/2022-01-10.parquet size: 2.3 MB rows: 111,598 symbols: 2,645
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-01-10 04:00:00 | AAPL | Stock | 172.22 | 172.5 | 172.15 | 172.47 | 6482.0 |
| 2022-01-10 04:30:00 | AAPL | Stock | 172.5 | 172.55 | 172.36 | 172.47 | 7373.0 |
| 2022-01-10 05:00:00 | AAPL | Stock | 172.4 | 172.5 | 172.2 | 172.2 | 6311.0 |
| 2022-01-10 05:30:00 | AAPL | Stock | 172.21 | 172.27 | 171.64 | 171.78 | 12269.0 |
| 2022-01-10 06:00:00 | AAPL | Stock | 171.75 | 171.75 | 171.4 | 171.51 | 13425.0 |
| 2022-01-10 06:30:00 | AAPL | Stock | 171.53 | 171.84 | 171.42 | 171.66 | 16322.0 |
| 2022-01-10 07:00:00 | AAPL | Stock | 171.62 | 171.78 | 171.0 | 171.07 | 86828.0 |
| 2022-01-10 07:30:00 | AAPL | Stock | 171.06 | 171.06 | 170.0 | 170.0 | 111056.0 |
| 2022-01-10 08:00:00 | AAPL | Stock | 171.0999 | 171.77 | 169.76 | 170.1 | 423381.0 |
| 2022-01-10 08:30:00 | AAPL | Stock | 170.08 | 170.2 | 169.0 | 169.23 | 485136.0 |
| 2022-01-10 09:00:00 | AAPL | Stock | 169.21 | 169.43 | 168.68 | 169.01 | 705245.0 |
| 2022-01-10 09:30:00 | AAPL | Stock | 169.08 | 171.73 | 168.75 | 169.53 | 14272058.0 |
| 2022-01-10 10:00:00 | AAPL | Stock | 169.46 | 169.72 | 168.37 | 168.73 | 8010963.0 |
| 2022-01-10 10:30:00 | AAPL | Stock | 168.71 | 169.0 | 168.17 | 168.6932 | 5790296.0 |
| 2022-01-10 11:00:00 | AAPL | Stock | 168.7 | 170.02 | 168.45 | 169.925 | 5468728.0 |
| 2022-01-10 11:30:00 | AAPL | Stock | 169.93 | 169.93 | 168.75 | 169.075 | 3850564.0 |
| 2022-01-10 12:00:00 | AAPL | Stock | 169.07 | 169.105 | 168.29 | 168.9167 | 4091379.0 |
| 2022-01-10 12:30:00 | AAPL | Stock | 168.9 | 170.135 | 168.74 | 169.66 | 3879400.0 |
| 2022-01-10 13:00:00 | AAPL | Stock | 169.64 | 170.75 | 169.53 | 170.62 | 4775901.0 |
| 2022-01-10 13:30:00 | AAPL | Stock | 170.61 | 171.45 | 170.44 | 171.16 | 4383980.0 |
| 2022-01-10 14:00:00 | AAPL | Stock | 171.16 | 171.66 | 170.72 | 170.795 | 4203631.0 |
| 2022-01-10 14:30:00 | AAPL | Stock | 170.81 | 171.1762 | 170.35 | 170.69 | 3836380.0 |
| 2022-01-10 15:00:00 | AAPL | Stock | 170.7 | 170.93 | 169.9701 | 170.59 | 4541040.0 |
| 2022-01-10 15:30:00 | AAPL | Stock | 170.59 | 172.5 | 170.38 | 172.19 | 9376717.0 |
| 2022-01-10 16:00:00 | AAPL | Stock | 172.21 | 172.58 | 172.17 | 172.35 | 11206526.0 |
| 2022-01-10 16:30:00 | AAPL | Stock | 172.34 | 172.67 | 172.19 | 172.46 | 60657.0 |
| 2022-01-10 17:00:00 | AAPL | Stock | 172.47 | 172.56 | 172.19 | 172.53 | 1921231.0 |
| 2022-01-10 17:30:00 | AAPL | Stock | 172.49 | 172.56 | 172.49 | 172.56 | 13794.0 |
| 2022-01-10 18:00:00 | AAPL | Stock | 172.53 | 172.85 | 172.32 | 172.82 | 36018.0 |
| 2022-01-10 18:30:00 | AAPL | Stock | 172.8 | 172.8 | 172.57 | 172.72 | 11816.0 |
| 2022-01-10 19:00:00 | AAPL | Stock | 172.76 | 172.84 | 172.2 | 172.26 | 26722.0 |
| 2022-01-10 19:30:00 | AAPL | Stock | 172.2 | 172.95 | 172.19 | 172.9 | 24660.0 |
| 2022-01-10 04:00:00 | MSFT | Stock | 313.22 | 314.29 | 313.22 | 314.19 | 1832.0 |
| 2022-01-10 05:00:00 | MSFT | Stock | 314.2 | 314.48 | 314.1 | 314.1 | 829.0 |
| 2022-01-10 05:30:00 | MSFT | Stock | 313.96 | 313.96 | 313.7 | 313.7 | 464.0 |
| 2022-01-10 06:00:00 | MSFT | Stock | 313.27 | 313.27 | 312.63 | 312.7 | 1484.0 |
| 2022-01-10 06:30:00 | MSFT | Stock | 312.83 | 312.99 | 312.29 | 312.99 | 1555.0 |
| 2022-01-10 07:00:00 | MSFT | Stock | 313.19 | 313.45 | 311.51 | 311.52 | 12913.0 |
| 2022-01-10 07:30:00 | MSFT | Stock | 311.5 | 311.5 | 309.02 | 309.02 | 38313.0 |
| 2022-01-10 08:00:00 | MSFT | Stock | 312.6129 | 313.45 | 308.5 | 309.85 | 49116.0 |
| 2022-01-10 08:30:00 | MSFT | Stock | 309.92 | 310.01 | 309.11 | 309.98 | 47196.0 |
| 2022-01-10 09:00:00 | MSFT | Stock | 309.98 | 310.94 | 309.11 | 309.55 | 61626.0 |
| 2022-01-10 09:30:00 | MSFT | Stock | 309.49 | 310.01 | 306.59 | 307.05 | 4111275.0 |
| 2022-01-10 10:00:00 | MSFT | Stock | 307.0 | 307.15 | 305.221 | 306.31 | 2787344.0 |
| 2022-01-10 10:30:00 | MSFT | Stock | 306.334 | 306.8151 | 304.69 | 306.4669 | 1828952.0 |
| 2022-01-10 11:00:00 | MSFT | Stock | 306.41 | 308.94 | 306.29 | 308.62 | 1782595.0 |
| 2022-01-10 11:30:00 | MSFT | Stock | 308.64 | 308.6599 | 306.7 | 307.88 | 1193956.0 |
| 2022-01-10 12:00:00 | MSFT | Stock | 307.87 | 307.9437 | 305.83 | 305.98 | 962124.0 |
| 2022-01-10 12:30:00 | MSFT | Stock | 305.96 | 308.5 | 305.62 | 307.29 | 1201450.0 |
| 2022-01-10 13:00:00 | MSFT | Stock | 307.24 | 310.35 | 307.21 | 309.9483 | 1522941.0 |
> showing 50 of 111,598 rows — these rows as CSV