PREVIEW / stock_30min / 2022-07-15
file: by_date/stock_30min/2022/2022-07-15.parquet size: 2.0 MB rows: 101,819 symbols: 2,279
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-07-15 04:00:00 | AAPL | Stock | 148.3 | 148.64 | 148.25 | 148.54 | 18264.0 |
| 2022-07-15 04:30:00 | AAPL | Stock | 148.59 | 149.04 | 148.48 | 148.75 | 18669.0 |
| 2022-07-15 05:00:00 | AAPL | Stock | 148.75 | 148.99 | 148.65 | 148.68 | 4549.0 |
| 2022-07-15 05:30:00 | AAPL | Stock | 148.9 | 148.9 | 148.7 | 148.7 | 2205.0 |
| 2022-07-15 06:00:00 | AAPL | Stock | 148.62 | 148.77 | 148.55 | 148.77 | 2293.0 |
| 2022-07-15 06:30:00 | AAPL | Stock | 148.66 | 148.75 | 148.63 | 148.73 | 1575.0 |
| 2022-07-15 07:00:00 | AAPL | Stock | 148.81 | 149.02 | 148.8 | 149.02 | 27382.0 |
| 2022-07-15 07:30:00 | AAPL | Stock | 148.99 | 149.09 | 148.59 | 148.59 | 30287.0 |
| 2022-07-15 08:00:00 | AAPL | Stock | 148.86 | 149.27 | 148.2 | 148.37 | 201119.0 |
| 2022-07-15 08:30:00 | AAPL | Stock | 148.34 | 149.84 | 148.0 | 149.6301 | 329499.0 |
| 2022-07-15 09:00:00 | AAPL | Stock | 149.67 | 150.07 | 149.3 | 149.78 | 527306.0 |
| 2022-07-15 09:30:00 | AAPL | Stock | 149.82 | 150.86 | 148.78 | 149.37 | 11878405.0 |
| 2022-07-15 10:00:00 | AAPL | Stock | 149.38 | 150.52 | 148.96 | 149.71 | 5878655.0 |
| 2022-07-15 10:30:00 | AAPL | Stock | 149.72 | 149.75 | 148.84 | 149.26 | 4257388.0 |
| 2022-07-15 11:00:00 | AAPL | Stock | 149.25 | 149.63 | 149.025 | 149.04 | 2978687.0 |
| 2022-07-15 11:30:00 | AAPL | Stock | 149.04 | 149.365 | 148.79 | 148.791 | 3024387.0 |
| 2022-07-15 12:00:00 | AAPL | Stock | 148.79 | 148.86 | 148.2 | 148.76 | 3363995.0 |
| 2022-07-15 12:30:00 | AAPL | Stock | 148.755 | 149.058 | 148.43 | 148.91 | 2673037.0 |
| 2022-07-15 13:00:00 | AAPL | Stock | 148.91 | 149.33 | 148.81 | 149.325 | 2120324.0 |
| 2022-07-15 13:30:00 | AAPL | Stock | 149.3247 | 149.51 | 148.83 | 149.135 | 2607510.0 |
| 2022-07-15 14:00:00 | AAPL | Stock | 149.1219 | 149.425 | 148.86 | 149.41 | 2495067.0 |
| 2022-07-15 14:30:00 | AAPL | Stock | 149.41 | 149.57 | 149.18 | 149.35 | 2319190.0 |
| 2022-07-15 15:00:00 | AAPL | Stock | 149.3501 | 149.61 | 149.14 | 149.2094 | 2888928.0 |
| 2022-07-15 15:30:00 | AAPL | Stock | 149.205 | 150.25 | 149.05 | 150.17 | 9179432.0 |
| 2022-07-15 16:00:00 | AAPL | Stock | 150.13 | 150.27 | 149.78 | 150.0 | 9982999.0 |
| 2022-07-15 16:30:00 | AAPL | Stock | 149.99 | 150.17 | 149.98 | 150.02 | 123238.0 |
| 2022-07-15 17:00:00 | AAPL | Stock | 150.02 | 150.05 | 149.99 | 150.0 | 46437.0 |
| 2022-07-15 17:30:00 | AAPL | Stock | 150.0199 | 150.02 | 150.0 | 150.01 | 11704.0 |
| 2022-07-15 18:00:00 | AAPL | Stock | 150.01 | 150.05 | 150.0 | 150.01 | 12478.0 |
| 2022-07-15 18:30:00 | AAPL | Stock | 150.0 | 150.05 | 149.98 | 149.99 | 18941.0 |
| 2022-07-15 19:00:00 | AAPL | Stock | 149.97 | 150.05 | 149.97 | 149.99 | 5251.0 |
| 2022-07-15 19:30:00 | AAPL | Stock | 150.03 | 150.07 | 150.0 | 150.03 | 17057.0 |
| 2022-07-15 04:00:00 | MSFT | Stock | 254.4 | 254.4 | 254.4 | 254.4 | 423.0 |
| 2022-07-15 05:00:00 | MSFT | Stock | 255.15 | 255.15 | 255.0 | 255.0 | 580.0 |
| 2022-07-15 05:30:00 | MSFT | Stock | 255.0 | 255.0 | 254.55 | 254.55 | 328.0 |
| 2022-07-15 06:00:00 | MSFT | Stock | 254.5 | 254.5 | 254.5 | 254.5 | 430.0 |
| 2022-07-15 06:30:00 | MSFT | Stock | 254.73 | 254.73 | 254.62 | 254.62 | 800.0 |
| 2022-07-15 07:00:00 | MSFT | Stock | 254.99 | 255.08 | 254.66 | 254.85 | 6056.0 |
| 2022-07-15 07:30:00 | MSFT | Stock | 254.76 | 254.83 | 253.53 | 253.53 | 10286.0 |
| 2022-07-15 08:00:00 | MSFT | Stock | 254.85 | 255.0 | 253.13 | 253.91 | 34108.0 |
| 2022-07-15 08:30:00 | MSFT | Stock | 253.83 | 256.32 | 253.09 | 255.6021 | 44728.0 |
| 2022-07-15 09:00:00 | MSFT | Stock | 255.6049 | 256.31 | 254.24 | 255.72 | 77997.0 |
| 2022-07-15 09:30:00 | MSFT | Stock | 255.72 | 258.68 | 255.68 | 257.76 | 3725641.0 |
| 2022-07-15 10:00:00 | MSFT | Stock | 257.88 | 260.3699 | 257.87 | 260.08 | 2079334.0 |
| 2022-07-15 10:30:00 | MSFT | Stock | 260.09 | 260.16 | 258.281 | 258.77 | 1014364.0 |
| 2022-07-15 11:00:00 | MSFT | Stock | 258.81 | 259.32 | 258.25 | 258.28 | 904508.0 |
| 2022-07-15 11:30:00 | MSFT | Stock | 258.26 | 258.55 | 257.15 | 257.2 | 721416.0 |
| 2022-07-15 12:00:00 | MSFT | Stock | 257.2249 | 257.38 | 256.3 | 256.66 | 757554.0 |
| 2022-07-15 12:30:00 | MSFT | Stock | 256.66 | 256.69 | 255.9 | 256.17 | 649322.0 |
| 2022-07-15 13:00:00 | MSFT | Stock | 256.19 | 256.205 | 255.2 | 255.9607 | 694592.0 |
> showing 50 of 101,819 rows — these rows as CSV