PREVIEW / stock_30min / 2021-04-06
file: by_date/stock_30min/2021/2021-04-06.parquet size: 2.2 MB rows: 112,753 symbols: 2,954
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-06 04:00:00 | AAPL | Stock | 125.33 | 125.4 | 125.0 | 125.31 | 25119.0 |
| 2021-04-06 04:30:00 | AAPL | Stock | 125.27 | 125.68 | 125.27 | 125.5 | 9986.0 |
| 2021-04-06 05:00:00 | AAPL | Stock | 125.5 | 125.56 | 125.46 | 125.56 | 5757.0 |
| 2021-04-06 05:30:00 | AAPL | Stock | 125.5 | 125.64 | 125.46 | 125.53 | 6405.0 |
| 2021-04-06 06:00:00 | AAPL | Stock | 125.61 | 125.61 | 125.5 | 125.5 | 3657.0 |
| 2021-04-06 06:30:00 | AAPL | Stock | 125.54 | 125.7 | 125.54 | 125.63 | 6836.0 |
| 2021-04-06 07:00:00 | AAPL | Stock | 125.64 | 125.98 | 125.61 | 125.73 | 98936.0 |
| 2021-04-06 07:30:00 | AAPL | Stock | 125.72 | 126.38 | 125.71 | 126.3 | 132499.0 |
| 2021-04-06 08:00:00 | AAPL | Stock | 125.9192 | 126.61 | 125.68 | 126.45 | 303824.0 |
| 2021-04-06 08:30:00 | AAPL | Stock | 126.46 | 126.71 | 126.1499 | 126.33 | 224468.0 |
| 2021-04-06 09:00:00 | AAPL | Stock | 126.34 | 126.55 | 126.12 | 126.53 | 256797.0 |
| 2021-04-06 09:30:00 | AAPL | Stock | 126.49 | 126.61 | 125.65 | 126.575 | 11630663.0 |
| 2021-04-06 10:00:00 | AAPL | Stock | 126.57 | 126.96 | 126.1772 | 126.3601 | 7741610.0 |
| 2021-04-06 10:30:00 | AAPL | Stock | 126.37 | 126.6699 | 125.979 | 126.5672 | 5250520.0 |
| 2021-04-06 11:00:00 | AAPL | Stock | 126.5699 | 127.13 | 126.5 | 126.8699 | 5328277.0 |
| 2021-04-06 11:30:00 | AAPL | Stock | 126.86 | 126.95 | 126.66 | 126.9201 | 3544545.0 |
| 2021-04-06 12:00:00 | AAPL | Stock | 126.93 | 126.94 | 126.41 | 126.4613 | 3293634.0 |
| 2021-04-06 12:30:00 | AAPL | Stock | 126.46 | 126.65 | 126.2198 | 126.235 | 3045249.0 |
| 2021-04-06 13:00:00 | AAPL | Stock | 126.235 | 126.29 | 125.7491 | 125.8801 | 4268465.0 |
| 2021-04-06 13:30:00 | AAPL | Stock | 125.885 | 126.21 | 125.81 | 126.1853 | 2782230.0 |
| 2021-04-06 14:00:00 | AAPL | Stock | 126.185 | 126.45 | 126.1302 | 126.42 | 2698936.0 |
| 2021-04-06 14:30:00 | AAPL | Stock | 126.4125 | 126.605 | 126.12 | 126.55 | 3030113.0 |
| 2021-04-06 15:00:00 | AAPL | Stock | 126.55 | 126.68 | 126.295 | 126.465 | 3552547.0 |
| 2021-04-06 15:30:00 | AAPL | Stock | 126.47 | 126.51 | 126.0 | 126.23 | 6725651.0 |
| 2021-04-06 16:00:00 | AAPL | Stock | 126.21 | 126.41 | 126.04 | 126.16 | 7183192.0 |
| 2021-04-06 16:30:00 | AAPL | Stock | 126.17 | 126.28 | 126.16 | 126.28 | 45221.0 |
| 2021-04-06 17:00:00 | AAPL | Stock | 126.23 | 126.27 | 126.21 | 126.25 | 17868.0 |
| 2021-04-06 17:30:00 | AAPL | Stock | 126.25 | 126.25 | 126.2 | 126.23 | 6549.0 |
| 2021-04-06 18:00:00 | AAPL | Stock | 126.23 | 126.34 | 126.2 | 126.29 | 28983.0 |
| 2021-04-06 18:30:00 | AAPL | Stock | 126.26 | 126.32 | 126.21 | 126.26 | 23107.0 |
| 2021-04-06 19:00:00 | AAPL | Stock | 126.27 | 126.3 | 126.21 | 126.3 | 27694.0 |
| 2021-04-06 19:30:00 | AAPL | Stock | 126.27 | 126.37 | 126.22 | 126.33 | 38364.0 |
| 2021-04-06 04:00:00 | MSFT | Stock | 248.0 | 248.0 | 247.63 | 247.63 | 5972.0 |
| 2021-04-06 04:30:00 | MSFT | Stock | 247.9 | 248.28 | 247.9 | 248.28 | 889.0 |
| 2021-04-06 05:00:00 | MSFT | Stock | 248.1 | 248.1 | 247.79 | 248.02 | 2825.0 |
| 2021-04-06 05:30:00 | MSFT | Stock | 248.05 | 248.05 | 247.64 | 247.64 | 1640.0 |
| 2021-04-06 06:00:00 | MSFT | Stock | 247.92 | 247.92 | 247.58 | 247.58 | 1181.0 |
| 2021-04-06 06:30:00 | MSFT | Stock | 247.8 | 247.8 | 247.62 | 247.62 | 689.0 |
| 2021-04-06 07:00:00 | MSFT | Stock | 247.87 | 248.18 | 247.8 | 247.91 | 22887.0 |
| 2021-04-06 07:30:00 | MSFT | Stock | 247.92 | 248.23 | 247.92 | 248.04 | 4174.0 |
| 2021-04-06 08:00:00 | MSFT | Stock | 248.09 | 249.07 | 247.9501 | 249.07 | 157730.0 |
| 2021-04-06 08:30:00 | MSFT | Stock | 248.35 | 248.83 | 248.07 | 248.26 | 14565.0 |
| 2021-04-06 09:00:00 | MSFT | Stock | 248.55 | 248.78 | 247.54 | 247.54 | 24232.0 |
| 2021-04-06 09:30:00 | MSFT | Stock | 247.62 | 248.47 | 246.88 | 248.27 | 2769300.0 |
| 2021-04-06 10:00:00 | MSFT | Stock | 248.26 | 248.99 | 247.65 | 248.18 | 1530079.0 |
| 2021-04-06 10:30:00 | MSFT | Stock | 248.21 | 248.56 | 247.395 | 248.51 | 1159635.0 |
| 2021-04-06 11:00:00 | MSFT | Stock | 248.51 | 249.1268 | 248.27 | 248.38 | 1060873.0 |
| 2021-04-06 11:30:00 | MSFT | Stock | 248.3701 | 249.38 | 248.3132 | 249.3626 | 902883.0 |
| 2021-04-06 12:00:00 | MSFT | Stock | 249.36 | 249.4 | 248.75 | 248.88 | 685180.0 |
| 2021-04-06 12:30:00 | MSFT | Stock | 248.86 | 249.105 | 248.705 | 248.82 | 617758.0 |
> showing 50 of 112,753 rows — these rows as CSV