PREVIEW / stock_30min / 2022-12-19
file: by_date/stock_30min/2022/2022-12-19.parquet size: 2.1 MB rows: 104,008 symbols: 2,006
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-12-19 04:00:00 | AAPL | Stock | 136.0 | 136.0 | 135.3 | 135.42 | 23016.0 |
| 2022-12-19 04:30:00 | AAPL | Stock | 135.42 | 135.46 | 135.2 | 135.29 | 9629.0 |
| 2022-12-19 05:00:00 | AAPL | Stock | 135.32 | 135.58 | 135.29 | 135.5 | 6225.0 |
| 2022-12-19 05:30:00 | AAPL | Stock | 135.52 | 135.7 | 135.52 | 135.62 | 6191.0 |
| 2022-12-19 06:00:00 | AAPL | Stock | 135.6 | 135.62 | 135.5 | 135.6 | 7242.0 |
| 2022-12-19 06:30:00 | AAPL | Stock | 135.6 | 135.62 | 135.35 | 135.51 | 10923.0 |
| 2022-12-19 07:00:00 | AAPL | Stock | 135.55 | 135.55 | 135.3 | 135.5 | 60859.0 |
| 2022-12-19 07:30:00 | AAPL | Stock | 135.54 | 135.62 | 135.46 | 135.48 | 16418.0 |
| 2022-12-19 08:00:00 | AAPL | Stock | 135.39 | 135.7385 | 134.51 | 135.13 | 147414.0 |
| 2022-12-19 08:30:00 | AAPL | Stock | 135.12 | 135.12 | 134.81 | 134.9201 | 76666.0 |
| 2022-12-19 09:00:00 | AAPL | Stock | 134.9202 | 135.21 | 134.75 | 134.99 | 166952.0 |
| 2022-12-19 09:30:00 | AAPL | Stock | 135.15 | 135.25 | 133.0218 | 133.26 | 6760807.0 |
| 2022-12-19 10:00:00 | AAPL | Stock | 133.255 | 133.265 | 132.33 | 132.63 | 5937540.0 |
| 2022-12-19 10:30:00 | AAPL | Stock | 132.62 | 132.6399 | 131.77 | 131.8728 | 5097612.0 |
| 2022-12-19 11:00:00 | AAPL | Stock | 131.88 | 132.14 | 131.4549 | 132.025 | 4884338.0 |
| 2022-12-19 11:30:00 | AAPL | Stock | 132.02 | 132.61 | 131.74 | 132.355 | 3558409.0 |
| 2022-12-19 12:00:00 | AAPL | Stock | 132.355 | 133.0 | 132.34 | 132.6488 | 3153352.0 |
| 2022-12-19 12:30:00 | AAPL | Stock | 132.6489 | 133.25 | 132.6 | 132.852 | 3014800.0 |
| 2022-12-19 13:00:00 | AAPL | Stock | 132.855 | 132.92 | 132.51 | 132.6453 | 2417821.0 |
| 2022-12-19 13:30:00 | AAPL | Stock | 132.64 | 132.69 | 132.27 | 132.3394 | 2297951.0 |
| 2022-12-19 14:00:00 | AAPL | Stock | 132.33 | 132.485 | 132.01 | 132.03 | 2679280.0 |
| 2022-12-19 14:30:00 | AAPL | Stock | 132.035 | 132.69 | 132.0315 | 132.18 | 2965099.0 |
| 2022-12-19 15:00:00 | AAPL | Stock | 132.18 | 132.2 | 131.4501 | 131.46 | 4621978.0 |
| 2022-12-19 15:30:00 | AAPL | Stock | 131.4575 | 132.6 | 131.32 | 132.35 | 8743425.0 |
| 2022-12-19 16:00:00 | AAPL | Stock | 132.37 | 132.52 | 132.21 | 132.31 | 10910344.0 |
| 2022-12-19 16:30:00 | AAPL | Stock | 132.33 | 132.37 | 132.2 | 132.27 | 93612.0 |
| 2022-12-19 17:00:00 | AAPL | Stock | 132.27 | 132.27 | 131.98 | 132.0504 | 94543.0 |
| 2022-12-19 17:30:00 | AAPL | Stock | 132.04 | 132.16 | 132.01 | 132.1 | 27500.0 |
| 2022-12-19 18:00:00 | AAPL | Stock | 132.2 | 132.37 | 132.14 | 132.33 | 35051.0 |
| 2022-12-19 18:30:00 | AAPL | Stock | 132.37 | 132.55 | 132.21 | 132.43 | 26118.0 |
| 2022-12-19 19:00:00 | AAPL | Stock | 132.47 | 132.47 | 132.35 | 132.39 | 14314.0 |
| 2022-12-19 19:30:00 | AAPL | Stock | 132.3698 | 132.59 | 132.3698 | 132.55 | 23439.0 |
| 2022-12-19 04:00:00 | MSFT | Stock | 246.82 | 246.82 | 245.79 | 246.2 | 3092.0 |
| 2022-12-19 04:30:00 | MSFT | Stock | 245.81 | 245.81 | 245.25 | 245.38 | 1491.0 |
| 2022-12-19 05:00:00 | MSFT | Stock | 245.41 | 245.58 | 245.4 | 245.58 | 1611.0 |
| 2022-12-19 05:30:00 | MSFT | Stock | 246.0 | 246.2 | 245.9 | 246.2 | 1704.0 |
| 2022-12-19 06:00:00 | MSFT | Stock | 246.11 | 246.4 | 246.01 | 246.4 | 1596.0 |
| 2022-12-19 06:30:00 | MSFT | Stock | 246.25 | 246.25 | 245.68 | 245.88 | 2334.0 |
| 2022-12-19 07:00:00 | MSFT | Stock | 245.95 | 246.0 | 245.77 | 245.81 | 4981.0 |
| 2022-12-19 07:30:00 | MSFT | Stock | 245.82 | 246.38 | 245.8 | 246.29 | 7368.0 |
| 2022-12-19 08:00:00 | MSFT | Stock | 245.9601 | 246.39 | 244.8 | 245.72 | 33071.0 |
| 2022-12-19 08:30:00 | MSFT | Stock | 245.75 | 245.75 | 245.2 | 245.46 | 6215.0 |
| 2022-12-19 09:00:00 | MSFT | Stock | 245.4 | 245.5 | 244.82 | 244.83 | 25041.0 |
| 2022-12-19 09:30:00 | MSFT | Stock | 245.0 | 245.22 | 241.25 | 241.6511 | 2206615.0 |
| 2022-12-19 10:00:00 | MSFT | Stock | 241.66 | 242.96 | 240.27 | 242.72 | 1624521.0 |
| 2022-12-19 10:30:00 | MSFT | Stock | 242.725 | 242.91 | 241.26 | 241.265 | 1394555.0 |
| 2022-12-19 11:00:00 | MSFT | Stock | 241.25 | 241.26 | 239.56 | 240.35 | 1781919.0 |
| 2022-12-19 11:30:00 | MSFT | Stock | 240.36 | 241.1867 | 239.0778 | 240.83 | 1502342.0 |
| 2022-12-19 12:00:00 | MSFT | Stock | 240.84 | 241.37 | 240.62 | 240.63 | 1111733.0 |
| 2022-12-19 12:30:00 | MSFT | Stock | 240.63 | 241.26 | 240.45 | 240.68 | 1012991.0 |
> showing 50 of 104,008 rows — these rows as CSV