PREVIEW / stock_30min / 2022-05-19
file: by_date/stock_30min/2022/2022-05-19.parquet size: 2.1 MB rows: 105,583 symbols: 2,374
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-05-19 04:00:00 | AAPL | Stock | 140.18 | 140.18 | 139.19 | 139.48 | 28306.0 |
| 2022-05-19 04:30:00 | AAPL | Stock | 139.42 | 139.47 | 139.03 | 139.07 | 33205.0 |
| 2022-05-19 05:00:00 | AAPL | Stock | 139.02 | 139.25 | 138.72 | 138.86 | 24797.0 |
| 2022-05-19 05:30:00 | AAPL | Stock | 138.82 | 139.13 | 138.56 | 138.91 | 24617.0 |
| 2022-05-19 06:00:00 | AAPL | Stock | 138.86 | 139.55 | 138.86 | 139.25 | 24099.0 |
| 2022-05-19 06:30:00 | AAPL | Stock | 139.34 | 139.88 | 138.92 | 139.84 | 33159.0 |
| 2022-05-19 07:00:00 | AAPL | Stock | 139.85 | 140.27 | 139.45 | 140.1 | 104238.0 |
| 2022-05-19 07:30:00 | AAPL | Stock | 140.15 | 140.5 | 139.83 | 140.35 | 79709.0 |
| 2022-05-19 08:00:00 | AAPL | Stock | 139.7542 | 140.4899 | 139.2012 | 139.6 | 782519.0 |
| 2022-05-19 08:30:00 | AAPL | Stock | 139.6 | 140.15 | 139.33 | 140.0 | 357322.0 |
| 2022-05-19 09:00:00 | AAPL | Stock | 139.98 | 140.64 | 139.55 | 139.88 | 530871.0 |
| 2022-05-19 09:30:00 | AAPL | Stock | 139.88 | 141.66 | 138.7 | 139.49 | 16207638.0 |
| 2022-05-19 10:00:00 | AAPL | Stock | 139.47 | 141.02 | 139.17 | 139.37 | 9640484.0 |
| 2022-05-19 10:30:00 | AAPL | Stock | 139.38 | 139.7 | 137.84 | 138.73 | 10527251.0 |
| 2022-05-19 11:00:00 | AAPL | Stock | 138.73 | 139.2999 | 137.99 | 138.415 | 6977793.0 |
| 2022-05-19 11:30:00 | AAPL | Stock | 138.42 | 140.4 | 138.42 | 139.44 | 8595624.0 |
| 2022-05-19 12:00:00 | AAPL | Stock | 139.445 | 140.04 | 138.8246 | 139.76 | 5653100.0 |
| 2022-05-19 12:30:00 | AAPL | Stock | 139.7659 | 139.84 | 137.79 | 138.09 | 5977083.0 |
| 2022-05-19 13:00:00 | AAPL | Stock | 138.1 | 138.44 | 136.96 | 137.133 | 7087002.0 |
| 2022-05-19 13:30:00 | AAPL | Stock | 137.14 | 137.96 | 136.6 | 137.81 | 6952147.0 |
| 2022-05-19 14:00:00 | AAPL | Stock | 137.795 | 137.85 | 136.97 | 137.66 | 4706623.0 |
| 2022-05-19 14:30:00 | AAPL | Stock | 137.6501 | 139.15 | 137.48 | 138.8 | 6550139.0 |
| 2022-05-19 15:00:00 | AAPL | Stock | 138.805 | 139.41 | 136.95 | 137.14 | 6932666.0 |
| 2022-05-19 15:30:00 | AAPL | Stock | 137.14 | 137.81 | 136.67 | 137.31 | 11340620.0 |
| 2022-05-19 16:00:00 | AAPL | Stock | 137.33 | 137.65 | 137.12 | 137.57 | 6561986.0 |
| 2022-05-19 16:30:00 | AAPL | Stock | 137.56 | 137.9 | 137.35 | 137.8 | 133139.0 |
| 2022-05-19 17:00:00 | AAPL | Stock | 137.82 | 137.82 | 137.35 | 137.6 | 193300.0 |
| 2022-05-19 17:30:00 | AAPL | Stock | 137.6299 | 137.79 | 137.53 | 137.78 | 24237.0 |
| 2022-05-19 18:00:00 | AAPL | Stock | 137.7899 | 137.98 | 137.69 | 137.98 | 44333.0 |
| 2022-05-19 18:30:00 | AAPL | Stock | 137.99 | 138.0 | 137.75 | 137.88 | 38605.0 |
| 2022-05-19 19:00:00 | AAPL | Stock | 137.89 | 137.95 | 137.7 | 137.85 | 39812.0 |
| 2022-05-19 19:30:00 | AAPL | Stock | 137.88 | 138.33 | 137.88 | 138.3 | 40362.0 |
| 2022-05-19 04:00:00 | MSFT | Stock | 252.0 | 252.14 | 251.0 | 251.22 | 10569.0 |
| 2022-05-19 04:30:00 | MSFT | Stock | 251.55 | 251.57 | 250.75 | 250.77 | 12934.0 |
| 2022-05-19 05:00:00 | MSFT | Stock | 250.55 | 250.7 | 250.26 | 250.51 | 7309.0 |
| 2022-05-19 05:30:00 | MSFT | Stock | 250.26 | 250.59 | 250.0 | 250.53 | 7225.0 |
| 2022-05-19 06:00:00 | MSFT | Stock | 250.5 | 251.45 | 250.5 | 251.27 | 5850.0 |
| 2022-05-19 06:30:00 | MSFT | Stock | 251.06 | 251.86 | 250.69 | 251.86 | 9243.0 |
| 2022-05-19 07:00:00 | MSFT | Stock | 251.41 | 252.65 | 251.35 | 252.51 | 22052.0 |
| 2022-05-19 07:30:00 | MSFT | Stock | 252.51 | 252.84 | 252.12 | 252.84 | 12693.0 |
| 2022-05-19 08:00:00 | MSFT | Stock | 251.5073 | 252.8794 | 251.3 | 251.92 | 35304.0 |
| 2022-05-19 08:30:00 | MSFT | Stock | 251.94 | 252.64 | 251.2 | 252.43 | 21460.0 |
| 2022-05-19 09:00:00 | MSFT | Stock | 252.2 | 253.99 | 252.03 | 253.99 | 40949.0 |
| 2022-05-19 09:30:00 | MSFT | Stock | 253.89 | 256.0 | 252.36 | 254.45 | 3385887.0 |
| 2022-05-19 10:00:00 | MSFT | Stock | 254.46 | 256.52 | 253.81 | 254.22 | 1917858.0 |
| 2022-05-19 10:30:00 | MSFT | Stock | 254.21 | 256.835 | 253.6701 | 255.88 | 1454997.0 |
| 2022-05-19 11:00:00 | MSFT | Stock | 255.9 | 256.6105 | 254.88 | 255.28 | 1027923.0 |
| 2022-05-19 11:30:00 | MSFT | Stock | 255.35 | 257.67 | 255.245 | 256.36 | 1266543.0 |
| 2022-05-19 12:00:00 | MSFT | Stock | 256.365 | 257.58 | 256.0 | 256.365 | 1142213.0 |
| 2022-05-19 12:30:00 | MSFT | Stock | 256.38 | 256.42 | 253.03 | 253.86 | 1314709.0 |
> showing 50 of 105,583 rows — these rows as CSV