PREVIEW / stock_30min / 2021-02-03
file: by_date/stock_30min/2021/2021-02-03.parquet size: 2.3 MB rows: 117,897 symbols: 2,752
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-02-03 04:00:00 | AAPL | Stock | 135.6 | 135.7 | 135.4 | 135.58 | 23035.0 |
| 2021-02-03 04:30:00 | AAPL | Stock | 135.6 | 135.66 | 135.47 | 135.65 | 10082.0 |
| 2021-02-03 05:00:00 | AAPL | Stock | 135.61 | 135.8 | 135.5 | 135.8 | 4778.0 |
| 2021-02-03 05:30:00 | AAPL | Stock | 135.74 | 135.88 | 135.7 | 135.88 | 5938.0 |
| 2021-02-03 06:00:00 | AAPL | Stock | 135.88 | 135.88 | 135.63 | 135.69 | 9870.0 |
| 2021-02-03 06:30:00 | AAPL | Stock | 135.66 | 135.83 | 135.5 | 135.69 | 35644.0 |
| 2021-02-03 07:00:00 | AAPL | Stock | 135.64 | 135.72 | 135.01 | 135.18 | 178625.0 |
| 2021-02-03 07:30:00 | AAPL | Stock | 135.19 | 135.35 | 135.0 | 135.17 | 132439.0 |
| 2021-02-03 08:00:00 | AAPL | Stock | 135.47 | 135.69 | 135.02 | 135.29 | 281471.0 |
| 2021-02-03 08:30:00 | AAPL | Stock | 135.33 | 135.38 | 135.22 | 135.3 | 189017.0 |
| 2021-02-03 09:00:00 | AAPL | Stock | 135.32 | 135.8 | 135.02 | 135.52 | 278805.0 |
| 2021-02-03 09:30:00 | AAPL | Stock | 135.52 | 135.77 | 134.34 | 135.348 | 10382797.0 |
| 2021-02-03 10:00:00 | AAPL | Stock | 135.36 | 135.4 | 133.61 | 133.772 | 8992235.0 |
| 2021-02-03 10:30:00 | AAPL | Stock | 133.77 | 134.305 | 133.7 | 134.1 | 4961087.0 |
| 2021-02-03 11:00:00 | AAPL | Stock | 134.11 | 134.485 | 133.87 | 134.07 | 4180850.0 |
| 2021-02-03 11:30:00 | AAPL | Stock | 134.08 | 134.76 | 133.92 | 134.585 | 2906520.0 |
| 2021-02-03 12:00:00 | AAPL | Stock | 134.585 | 135.08 | 134.54 | 134.795 | 3366785.0 |
| 2021-02-03 12:30:00 | AAPL | Stock | 134.799 | 135.47 | 134.68 | 135.445 | 3748344.0 |
| 2021-02-03 13:00:00 | AAPL | Stock | 135.45 | 135.55 | 134.82 | 134.985 | 3563739.0 |
| 2021-02-03 13:30:00 | AAPL | Stock | 134.981 | 135.24 | 134.845 | 134.993 | 2748174.0 |
| 2021-02-03 14:00:00 | AAPL | Stock | 135.0 | 135.08 | 134.5 | 134.67 | 3096961.0 |
| 2021-02-03 14:30:00 | AAPL | Stock | 134.675 | 134.752 | 134.31 | 134.385 | 3013303.0 |
| 2021-02-03 15:00:00 | AAPL | Stock | 134.38 | 134.59 | 134.07 | 134.158 | 4039561.0 |
| 2021-02-03 15:30:00 | AAPL | Stock | 134.151 | 134.34 | 133.9 | 133.9 | 6211741.0 |
| 2021-02-03 16:00:00 | AAPL | Stock | 133.92 | 134.954 | 133.67 | 134.01 | 6880122.0 |
| 2021-02-03 16:30:00 | AAPL | Stock | 134.01 | 134.15 | 133.98 | 134.1 | 93266.0 |
| 2021-02-03 17:00:00 | AAPL | Stock | 134.12 | 134.18 | 133.99 | 134.0 | 66618.0 |
| 2021-02-03 17:30:00 | AAPL | Stock | 134.0 | 137.3 | 133.95 | 136.14 | 1006468.0 |
| 2021-02-03 18:00:00 | AAPL | Stock | 136.14 | 138.02 | 135.75 | 136.63 | 2152058.0 |
| 2021-02-03 18:30:00 | AAPL | Stock | 136.56 | 137.15 | 136.11 | 136.72 | 495696.0 |
| 2021-02-03 19:00:00 | AAPL | Stock | 136.7 | 137.08 | 136.65 | 136.88 | 295424.0 |
| 2021-02-03 19:30:00 | AAPL | Stock | 136.84 | 137.0 | 136.55 | 136.56 | 303185.0 |
| 2021-02-03 04:00:00 | MSFT | Stock | 241.8 | 241.8 | 240.67 | 240.69 | 3487.0 |
| 2021-02-03 04:30:00 | MSFT | Stock | 240.38 | 240.38 | 240.1 | 240.1 | 1103.0 |
| 2021-02-03 05:00:00 | MSFT | Stock | 240.23 | 240.23 | 240.1 | 240.1 | 1452.0 |
| 2021-02-03 05:30:00 | MSFT | Stock | 239.84 | 240.45 | 239.84 | 240.45 | 1956.0 |
| 2021-02-03 06:00:00 | MSFT | Stock | 240.44 | 240.46 | 240.23 | 240.41 | 1406.0 |
| 2021-02-03 06:30:00 | MSFT | Stock | 240.47 | 240.75 | 240.23 | 240.75 | 12425.0 |
| 2021-02-03 07:00:00 | MSFT | Stock | 240.3 | 240.59 | 239.01 | 239.4 | 17996.0 |
| 2021-02-03 07:30:00 | MSFT | Stock | 239.5 | 239.6 | 238.8 | 239.15 | 16442.0 |
| 2021-02-03 08:00:00 | MSFT | Stock | 240.37 | 240.4 | 238.92 | 239.88 | 24958.0 |
| 2021-02-03 08:30:00 | MSFT | Stock | 239.75 | 239.95 | 239.25 | 239.6 | 43552.0 |
| 2021-02-03 09:00:00 | MSFT | Stock | 239.64 | 239.88 | 239.02 | 239.64 | 69878.0 |
| 2021-02-03 09:30:00 | MSFT | Stock | 239.57 | 242.56 | 239.26 | 242.53 | 3005534.0 |
| 2021-02-03 10:00:00 | MSFT | Stock | 242.56 | 242.96 | 240.21 | 240.27 | 1928937.0 |
| 2021-02-03 10:30:00 | MSFT | Stock | 240.308 | 241.916 | 240.308 | 241.53 | 1058298.0 |
| 2021-02-03 11:00:00 | MSFT | Stock | 241.57 | 243.4 | 241.52 | 242.855 | 1774861.0 |
| 2021-02-03 11:30:00 | MSFT | Stock | 242.845 | 243.35 | 242.3 | 243.117 | 950143.0 |
| 2021-02-03 12:00:00 | MSFT | Stock | 243.12 | 243.6 | 242.85 | 243.37 | 891042.0 |
| 2021-02-03 12:30:00 | MSFT | Stock | 243.36 | 243.65 | 242.93 | 243.49 | 682671.0 |
> showing 50 of 117,897 rows — these rows as CSV