PREVIEW / stock_30min / 2021-09-03
file: by_date/stock_30min/2021/2021-09-03.parquet size: 2.2 MB rows: 107,156 symbols: 2,689
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-09-03 04:00:00 | AAPL | Stock | 153.77 | 154.07 | 153.77 | 153.99 | 7313.0 |
| 2021-09-03 04:30:00 | AAPL | Stock | 154.05 | 154.12 | 153.97 | 154.03 | 4485.0 |
| 2021-09-03 05:00:00 | AAPL | Stock | 154.01 | 154.01 | 153.95 | 153.95 | 2302.0 |
| 2021-09-03 05:30:00 | AAPL | Stock | 153.91 | 153.91 | 153.91 | 153.91 | 194.0 |
| 2021-09-03 06:00:00 | AAPL | Stock | 153.95 | 153.95 | 153.86 | 153.91 | 931.0 |
| 2021-09-03 06:30:00 | AAPL | Stock | 153.91 | 153.91 | 153.88 | 153.88 | 1485.0 |
| 2021-09-03 07:00:00 | AAPL | Stock | 153.89 | 154.13 | 153.88 | 154.12 | 32903.0 |
| 2021-09-03 07:30:00 | AAPL | Stock | 154.12 | 154.3 | 154.08 | 154.18 | 72219.0 |
| 2021-09-03 08:00:00 | AAPL | Stock | 153.9 | 154.26 | 153.266 | 154.14 | 151419.0 |
| 2021-09-03 08:30:00 | AAPL | Stock | 154.12 | 154.55 | 153.6 | 154.14 | 588592.0 |
| 2021-09-03 09:00:00 | AAPL | Stock | 154.18 | 154.25 | 153.52 | 153.75 | 496987.0 |
| 2021-09-03 09:30:00 | AAPL | Stock | 153.75 | 154.63 | 153.09 | 154.335 | 10444531.0 |
| 2021-09-03 10:00:00 | AAPL | Stock | 154.33 | 154.62 | 153.7 | 154.06 | 6282268.0 |
| 2021-09-03 10:30:00 | AAPL | Stock | 154.06 | 154.28 | 153.745 | 153.89 | 3983090.0 |
| 2021-09-03 11:00:00 | AAPL | Stock | 153.885 | 154.17 | 153.75 | 154.0815 | 2518741.0 |
| 2021-09-03 11:30:00 | AAPL | Stock | 154.085 | 154.24 | 153.91 | 153.9815 | 2052467.0 |
| 2021-09-03 12:00:00 | AAPL | Stock | 153.99 | 154.19 | 153.965 | 154.035 | 2083627.0 |
| 2021-09-03 12:30:00 | AAPL | Stock | 154.0354 | 154.06 | 153.765 | 153.85 | 2228370.0 |
| 2021-09-03 13:00:00 | AAPL | Stock | 153.84 | 154.22 | 153.83 | 154.04 | 2339999.0 |
| 2021-09-03 13:30:00 | AAPL | Stock | 154.0333 | 154.2 | 153.935 | 154.1901 | 1776377.0 |
| 2021-09-03 14:00:00 | AAPL | Stock | 154.191 | 154.24 | 153.785 | 153.895 | 2404221.0 |
| 2021-09-03 14:30:00 | AAPL | Stock | 153.89 | 154.11 | 153.865 | 154.065 | 1957011.0 |
| 2021-09-03 15:00:00 | AAPL | Stock | 154.0607 | 154.38 | 154.05 | 154.245 | 2852915.0 |
| 2021-09-03 15:30:00 | AAPL | Stock | 154.25 | 154.45 | 154.16 | 154.31 | 5122137.0 |
| 2021-09-03 16:00:00 | AAPL | Stock | 154.31 | 154.38 | 154.21 | 154.35 | 4466875.0 |
| 2021-09-03 16:30:00 | AAPL | Stock | 154.3 | 154.32 | 154.17 | 154.22 | 57264.0 |
| 2021-09-03 17:00:00 | AAPL | Stock | 154.24 | 154.34 | 154.24 | 154.3 | 33368.0 |
| 2021-09-03 17:30:00 | AAPL | Stock | 154.29 | 154.33 | 154.23 | 154.3 | 7284.0 |
| 2021-09-03 18:00:00 | AAPL | Stock | 154.3 | 154.3 | 154.23 | 154.23 | 5824.0 |
| 2021-09-03 18:30:00 | AAPL | Stock | 154.28 | 154.3 | 154.27 | 154.28 | 10039.0 |
| 2021-09-03 19:00:00 | AAPL | Stock | 154.29 | 154.34 | 154.29 | 154.31 | 12926.0 |
| 2021-09-03 19:30:00 | AAPL | Stock | 154.3 | 154.32 | 154.29 | 154.29 | 24687.0 |
| 2021-09-03 04:00:00 | MSFT | Stock | 302.19 | 302.35 | 302.19 | 302.35 | 320.0 |
| 2021-09-03 04:30:00 | MSFT | Stock | 302.13 | 302.13 | 301.65 | 301.7 | 1104.0 |
| 2021-09-03 05:00:00 | MSFT | Stock | 302.02 | 302.04 | 302.02 | 302.04 | 200.0 |
| 2021-09-03 06:30:00 | MSFT | Stock | 301.98 | 301.98 | 301.98 | 301.98 | 100.0 |
| 2021-09-03 07:00:00 | MSFT | Stock | 301.99 | 301.99 | 301.9 | 301.97 | 1823.0 |
| 2021-09-03 07:30:00 | MSFT | Stock | 301.94 | 301.99 | 301.67 | 301.67 | 4854.0 |
| 2021-09-03 08:00:00 | MSFT | Stock | 301.9776 | 302.0 | 301.55 | 301.79 | 10568.0 |
| 2021-09-03 08:30:00 | MSFT | Stock | 301.79 | 302.48 | 300.5 | 301.64 | 52383.0 |
| 2021-09-03 09:00:00 | MSFT | Stock | 301.5 | 301.88 | 300.31 | 301.0 | 37012.0 |
| 2021-09-03 09:30:00 | MSFT | Stock | 301.0 | 301.85 | 300.26 | 301.7 | 1346552.0 |
| 2021-09-03 10:00:00 | MSFT | Stock | 301.68 | 302.42 | 301.2 | 301.5139 | 825440.0 |
| 2021-09-03 10:30:00 | MSFT | Stock | 301.51 | 301.94 | 301.2935 | 301.76 | 582303.0 |
| 2021-09-03 11:00:00 | MSFT | Stock | 301.77 | 302.6 | 301.51 | 302.2798 | 549036.0 |
| 2021-09-03 11:30:00 | MSFT | Stock | 302.27 | 302.3901 | 301.81 | 301.9 | 402558.0 |
| 2021-09-03 12:00:00 | MSFT | Stock | 301.89 | 302.15 | 301.82 | 301.9116 | 391914.0 |
| 2021-09-03 12:30:00 | MSFT | Stock | 301.93 | 301.94 | 301.49 | 301.67 | 400972.0 |
| 2021-09-03 13:00:00 | MSFT | Stock | 301.68 | 302.3899 | 301.665 | 302.1098 | 436051.0 |
| 2021-09-03 13:30:00 | MSFT | Stock | 302.1 | 302.17 | 301.96 | 302.11 | 279272.0 |
> showing 50 of 107,156 rows — these rows as CSV