PREVIEW / stock_30min / 2021-06-04
file: by_date/stock_30min/2021/2021-06-04.parquet size: 2.2 MB rows: 109,250 symbols: 2,962
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-06-04 04:00:00 | AAPL | Stock | 123.52 | 123.6 | 123.51 | 123.53 | 1888.0 |
| 2021-06-04 04:30:00 | AAPL | Stock | 123.53 | 123.53 | 123.45 | 123.45 | 681.0 |
| 2021-06-04 05:00:00 | AAPL | Stock | 123.5 | 123.55 | 123.5 | 123.52 | 2103.0 |
| 2021-06-04 05:30:00 | AAPL | Stock | 123.56 | 123.72 | 123.55 | 123.72 | 3805.0 |
| 2021-06-04 06:00:00 | AAPL | Stock | 123.77 | 123.77 | 123.67 | 123.73 | 2045.0 |
| 2021-06-04 06:30:00 | AAPL | Stock | 123.7 | 123.71 | 123.31 | 123.7 | 4468.0 |
| 2021-06-04 07:00:00 | AAPL | Stock | 123.67 | 123.89 | 123.66 | 123.88 | 42352.0 |
| 2021-06-04 07:30:00 | AAPL | Stock | 123.89 | 123.98 | 123.77 | 123.98 | 48710.0 |
| 2021-06-04 08:00:00 | AAPL | Stock | 123.7299 | 124.02 | 123.232 | 123.91 | 208643.0 |
| 2021-06-04 08:30:00 | AAPL | Stock | 123.9 | 124.28 | 123.8 | 124.15 | 520753.0 |
| 2021-06-04 09:00:00 | AAPL | Stock | 124.15 | 124.28 | 124.03 | 124.07 | 213861.0 |
| 2021-06-04 09:30:00 | AAPL | Stock | 124.07 | 125.0 | 123.85 | 124.925 | 9984198.0 |
| 2021-06-04 10:00:00 | AAPL | Stock | 124.9244 | 125.36 | 124.76 | 124.83 | 6492256.0 |
| 2021-06-04 10:30:00 | AAPL | Stock | 124.835 | 125.18 | 124.78 | 124.9699 | 4091969.0 |
| 2021-06-04 11:00:00 | AAPL | Stock | 124.965 | 125.375 | 124.87 | 125.3687 | 3555457.0 |
| 2021-06-04 11:30:00 | AAPL | Stock | 125.37 | 125.385 | 125.02 | 125.1 | 2725026.0 |
| 2021-06-04 12:00:00 | AAPL | Stock | 125.11 | 125.865 | 124.98 | 125.8 | 4975019.0 |
| 2021-06-04 12:30:00 | AAPL | Stock | 125.795 | 125.95 | 125.6 | 125.6499 | 3664437.0 |
| 2021-06-04 13:00:00 | AAPL | Stock | 125.65 | 125.669 | 125.48 | 125.5 | 2193110.0 |
| 2021-06-04 13:30:00 | AAPL | Stock | 125.5 | 125.79 | 125.5 | 125.68 | 2113450.0 |
| 2021-06-04 14:00:00 | AAPL | Stock | 125.6825 | 125.81 | 125.62 | 125.76 | 2362841.0 |
| 2021-06-04 14:30:00 | AAPL | Stock | 125.77 | 126.16 | 125.76 | 126.0547 | 2959668.0 |
| 2021-06-04 15:00:00 | AAPL | Stock | 126.05 | 126.06 | 125.63 | 125.63 | 2968413.0 |
| 2021-06-04 15:30:00 | AAPL | Stock | 125.63 | 126.05 | 125.495 | 125.88 | 7446844.0 |
| 2021-06-04 16:00:00 | AAPL | Stock | 125.89 | 125.9 | 125.78 | 125.86 | 7594831.0 |
| 2021-06-04 16:30:00 | AAPL | Stock | 125.86 | 126.0 | 125.85 | 125.98 | 367819.0 |
| 2021-06-04 17:00:00 | AAPL | Stock | 125.98 | 125.99 | 125.92 | 125.93 | 26417.0 |
| 2021-06-04 17:30:00 | AAPL | Stock | 125.95 | 126.0 | 125.94 | 125.99 | 22602.0 |
| 2021-06-04 18:00:00 | AAPL | Stock | 125.99 | 126.01 | 125.8901 | 125.9 | 33278.0 |
| 2021-06-04 18:30:00 | AAPL | Stock | 125.96 | 125.98 | 125.91 | 125.95 | 8528.0 |
| 2021-06-04 19:00:00 | AAPL | Stock | 125.95 | 126.0 | 125.9 | 125.93 | 17102.0 |
| 2021-06-04 19:30:00 | AAPL | Stock | 125.94 | 126.01 | 125.92 | 126.01 | 31270.0 |
| 2021-06-04 04:30:00 | MSFT | Stock | 245.66 | 245.66 | 245.66 | 245.66 | 203.0 |
| 2021-06-04 07:00:00 | MSFT | Stock | 245.73 | 246.34 | 245.71 | 246.21 | 3638.0 |
| 2021-06-04 07:30:00 | MSFT | Stock | 246.11 | 246.18 | 245.85 | 246.18 | 1449.0 |
| 2021-06-04 08:00:00 | MSFT | Stock | 246.18 | 246.35 | 245.096 | 246.34 | 9238.0 |
| 2021-06-04 08:30:00 | MSFT | Stock | 246.34 | 247.46 | 245.0 | 247.25 | 59017.0 |
| 2021-06-04 09:00:00 | MSFT | Stock | 247.25 | 247.97 | 247.02 | 247.91 | 38889.0 |
| 2021-06-04 09:30:00 | MSFT | Stock | 247.77 | 249.55 | 247.51 | 248.95 | 2824002.0 |
| 2021-06-04 10:00:00 | MSFT | Stock | 248.93 | 250.54 | 248.93 | 250.36 | 1726385.0 |
| 2021-06-04 10:30:00 | MSFT | Stock | 250.38 | 250.69 | 249.98 | 250.39 | 1114363.0 |
| 2021-06-04 11:00:00 | MSFT | Stock | 250.41 | 251.02 | 250.21 | 250.98 | 840158.0 |
| 2021-06-04 11:30:00 | MSFT | Stock | 250.99 | 251.65 | 250.86 | 251.22 | 1326160.0 |
| 2021-06-04 12:00:00 | MSFT | Stock | 251.23 | 251.3 | 250.93 | 251.055 | 738440.0 |
| 2021-06-04 12:30:00 | MSFT | Stock | 251.06 | 251.16 | 250.77 | 250.82 | 547722.0 |
| 2021-06-04 13:00:00 | MSFT | Stock | 250.83 | 250.935 | 250.6269 | 250.65 | 431683.0 |
| 2021-06-04 13:30:00 | MSFT | Stock | 250.65 | 251.02 | 250.6019 | 250.98 | 554136.0 |
| 2021-06-04 14:00:00 | MSFT | Stock | 250.99 | 251.35 | 250.94 | 251.1701 | 717121.0 |
| 2021-06-04 14:30:00 | MSFT | Stock | 251.19 | 251.4 | 251.11 | 251.17 | 654732.0 |
| 2021-06-04 15:00:00 | MSFT | Stock | 251.17 | 251.22 | 250.96 | 251.08 | 856874.0 |
> showing 50 of 109,250 rows — these rows as CSV