PREVIEW / stock_30min / 2022-03-25
file: by_date/stock_30min/2022/2022-03-25.parquet size: 2.2 MB rows: 108,567 symbols: 2,484
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-03-25 04:00:00 | AAPL | Stock | 173.81 | 173.88 | 172.74 | 173.23 | 50746.0 |
| 2022-03-25 04:30:00 | AAPL | Stock | 173.17 | 173.43 | 173.16 | 173.28 | 4738.0 |
| 2022-03-25 05:00:00 | AAPL | Stock | 173.37 | 173.69 | 173.27 | 173.48 | 9806.0 |
| 2022-03-25 05:30:00 | AAPL | Stock | 173.48 | 173.8 | 173.47 | 173.77 | 12318.0 |
| 2022-03-25 06:00:00 | AAPL | Stock | 173.82 | 173.98 | 173.8 | 173.96 | 8422.0 |
| 2022-03-25 06:30:00 | AAPL | Stock | 173.96 | 174.31 | 173.76 | 174.25 | 17076.0 |
| 2022-03-25 07:00:00 | AAPL | Stock | 174.1 | 174.75 | 174.09 | 174.67 | 79200.0 |
| 2022-03-25 07:30:00 | AAPL | Stock | 174.65 | 174.76 | 174.56 | 174.62 | 67332.0 |
| 2022-03-25 08:00:00 | AAPL | Stock | 174.24 | 174.76 | 172.8 | 174.27 | 428714.0 |
| 2022-03-25 08:30:00 | AAPL | Stock | 174.25 | 174.25 | 173.9 | 174.05 | 176316.0 |
| 2022-03-25 09:00:00 | AAPL | Stock | 174.0501 | 174.06 | 173.5 | 173.75 | 277873.0 |
| 2022-03-25 09:30:00 | AAPL | Stock | 173.79 | 174.65 | 173.03 | 173.8 | 9665452.0 |
| 2022-03-25 10:00:00 | AAPL | Stock | 173.781 | 174.73 | 173.55 | 174.415 | 6297072.0 |
| 2022-03-25 10:30:00 | AAPL | Stock | 174.42 | 175.28 | 174.2416 | 174.56 | 6812148.0 |
| 2022-03-25 11:00:00 | AAPL | Stock | 174.57 | 174.6585 | 172.7997 | 173.2047 | 6173567.0 |
| 2022-03-25 11:30:00 | AAPL | Stock | 173.22 | 173.6 | 172.75 | 173.08 | 4381722.0 |
| 2022-03-25 12:00:00 | AAPL | Stock | 173.0983 | 173.75 | 172.9 | 173.3262 | 3571452.0 |
| 2022-03-25 12:30:00 | AAPL | Stock | 173.31 | 173.48 | 172.845 | 173.275 | 2976305.0 |
| 2022-03-25 13:00:00 | AAPL | Stock | 173.28 | 173.805 | 172.91 | 173.645 | 3201705.0 |
| 2022-03-25 13:30:00 | AAPL | Stock | 173.65 | 174.3299 | 173.58 | 174.29 | 2798175.0 |
| 2022-03-25 14:00:00 | AAPL | Stock | 174.29 | 174.555 | 174.17 | 174.4533 | 2973938.0 |
| 2022-03-25 14:30:00 | AAPL | Stock | 174.45 | 174.78 | 174.345 | 174.715 | 3010566.0 |
| 2022-03-25 15:00:00 | AAPL | Stock | 174.715 | 174.77 | 173.395 | 173.4269 | 4300740.0 |
| 2022-03-25 15:30:00 | AAPL | Stock | 173.42 | 174.8 | 173.33 | 174.73 | 7274684.0 |
| 2022-03-25 16:00:00 | AAPL | Stock | 174.73 | 174.77 | 174.5 | 174.61 | 5583167.0 |
| 2022-03-25 16:30:00 | AAPL | Stock | 174.68 | 174.72 | 174.52 | 174.55 | 90970.0 |
| 2022-03-25 17:00:00 | AAPL | Stock | 174.53 | 174.65 | 174.52 | 174.61 | 31271.0 |
| 2022-03-25 17:30:00 | AAPL | Stock | 174.61 | 174.69 | 174.61 | 174.69 | 22958.0 |
| 2022-03-25 18:00:00 | AAPL | Stock | 174.69 | 174.75 | 174.68 | 174.7 | 13992.0 |
| 2022-03-25 18:30:00 | AAPL | Stock | 174.7 | 174.93 | 174.69 | 174.85 | 18826.0 |
| 2022-03-25 19:00:00 | AAPL | Stock | 174.93 | 175.0 | 174.7601 | 174.85 | 20131.0 |
| 2022-03-25 19:30:00 | AAPL | Stock | 174.84 | 175.0 | 174.77 | 175.0 | 19563.0 |
| 2022-03-25 04:00:00 | MSFT | Stock | 304.07 | 304.12 | 303.32 | 303.46 | 5178.0 |
| 2022-03-25 04:30:00 | MSFT | Stock | 303.4 | 304.09 | 303.4 | 304.02 | 1176.0 |
| 2022-03-25 05:00:00 | MSFT | Stock | 304.1 | 304.5 | 303.61 | 303.99 | 1330.0 |
| 2022-03-25 05:30:00 | MSFT | Stock | 304.0 | 304.66 | 304.0 | 304.1 | 1419.0 |
| 2022-03-25 06:00:00 | MSFT | Stock | 304.5 | 304.5 | 304.5 | 304.5 | 200.0 |
| 2022-03-25 06:30:00 | MSFT | Stock | 304.58 | 305.0 | 304.58 | 305.0 | 1568.0 |
| 2022-03-25 07:00:00 | MSFT | Stock | 304.9 | 306.0 | 304.6 | 306.0 | 6956.0 |
| 2022-03-25 07:30:00 | MSFT | Stock | 305.87 | 306.21 | 305.5 | 306.0 | 9592.0 |
| 2022-03-25 08:00:00 | MSFT | Stock | 304.9278 | 306.2 | 304.6 | 306.01 | 31479.0 |
| 2022-03-25 08:30:00 | MSFT | Stock | 306.0 | 306.0 | 305.27 | 305.6 | 11030.0 |
| 2022-03-25 09:00:00 | MSFT | Stock | 305.56 | 305.66 | 304.65 | 305.22 | 28786.0 |
| 2022-03-25 09:30:00 | MSFT | Stock | 305.23 | 305.5 | 302.92 | 302.9533 | 1794178.0 |
| 2022-03-25 10:00:00 | MSFT | Stock | 303.0 | 304.15 | 301.82 | 303.68 | 1105323.0 |
| 2022-03-25 10:30:00 | MSFT | Stock | 303.69 | 305.1905 | 303.44 | 303.56 | 1041446.0 |
| 2022-03-25 11:00:00 | MSFT | Stock | 303.57 | 303.77 | 299.48 | 300.07 | 1624510.0 |
| 2022-03-25 11:30:00 | MSFT | Stock | 300.01 | 300.66 | 299.2855 | 299.9386 | 1006472.0 |
| 2022-03-25 12:00:00 | MSFT | Stock | 299.959 | 301.6199 | 299.77 | 301.445 | 922652.0 |
| 2022-03-25 12:30:00 | MSFT | Stock | 301.4199 | 301.55 | 300.58 | 301.13 | 661792.0 |
> showing 50 of 108,567 rows — these rows as CSV