PREVIEW / stock_30min / 2021-04-16
file: by_date/stock_30min/2021/2021-04-16.parquet size: 2.2 MB rows: 111,709 symbols: 2,958
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-16 04:00:00 | AAPL | Stock | 134.29 | 134.36 | 134.12 | 134.25 | 7523.0 |
| 2021-04-16 04:30:00 | AAPL | Stock | 134.25 | 134.25 | 134.1 | 134.1 | 4065.0 |
| 2021-04-16 05:00:00 | AAPL | Stock | 134.11 | 134.16 | 134.0 | 134.0 | 809.0 |
| 2021-04-16 05:30:00 | AAPL | Stock | 134.13 | 134.25 | 134.1 | 134.13 | 6242.0 |
| 2021-04-16 06:00:00 | AAPL | Stock | 134.13 | 134.13 | 134.05 | 134.07 | 4488.0 |
| 2021-04-16 06:30:00 | AAPL | Stock | 134.15 | 134.27 | 134.07 | 134.24 | 2539.0 |
| 2021-04-16 07:00:00 | AAPL | Stock | 134.2 | 134.67 | 134.2 | 134.67 | 62440.0 |
| 2021-04-16 07:30:00 | AAPL | Stock | 134.68 | 134.8 | 134.63 | 134.74 | 36156.0 |
| 2021-04-16 08:00:00 | AAPL | Stock | 134.3101 | 134.9 | 134.31 | 134.84 | 234741.0 |
| 2021-04-16 08:30:00 | AAPL | Stock | 134.88 | 134.9 | 134.75 | 134.79 | 117818.0 |
| 2021-04-16 09:00:00 | AAPL | Stock | 134.78 | 134.98 | 134.3 | 134.3 | 564163.0 |
| 2021-04-16 09:30:00 | AAPL | Stock | 134.3 | 134.67 | 133.28 | 133.41 | 13454241.0 |
| 2021-04-16 10:00:00 | AAPL | Stock | 133.415 | 134.58 | 133.3601 | 134.21 | 7862337.0 |
| 2021-04-16 10:30:00 | AAPL | Stock | 134.205 | 134.41 | 133.95 | 133.97 | 4501375.0 |
| 2021-04-16 11:00:00 | AAPL | Stock | 133.965 | 134.0979 | 133.685 | 133.755 | 4432210.0 |
| 2021-04-16 11:30:00 | AAPL | Stock | 133.76 | 133.95 | 133.67 | 133.83 | 3568134.0 |
| 2021-04-16 12:00:00 | AAPL | Stock | 133.825 | 134.1299 | 133.7301 | 134.02 | 3611335.0 |
| 2021-04-16 12:30:00 | AAPL | Stock | 134.0281 | 134.08 | 133.78 | 133.78 | 2498160.0 |
| 2021-04-16 13:00:00 | AAPL | Stock | 133.785 | 133.9199 | 133.63 | 133.64 | 2420782.0 |
| 2021-04-16 13:30:00 | AAPL | Stock | 133.65 | 133.815 | 133.53 | 133.535 | 2261680.0 |
| 2021-04-16 14:00:00 | AAPL | Stock | 133.535 | 133.98 | 133.515 | 133.9715 | 2713684.0 |
| 2021-04-16 14:30:00 | AAPL | Stock | 133.97 | 134.12 | 133.92 | 133.99 | 2374423.0 |
| 2021-04-16 15:00:00 | AAPL | Stock | 133.995 | 134.18 | 133.885 | 134.095 | 3313226.0 |
| 2021-04-16 15:30:00 | AAPL | Stock | 134.1 | 134.16 | 133.94 | 134.15 | 7198190.0 |
| 2021-04-16 16:00:00 | AAPL | Stock | 134.15 | 134.16 | 134.0081 | 134.09 | 12117515.0 |
| 2021-04-16 16:30:00 | AAPL | Stock | 134.1 | 134.15 | 134.0 | 134.04 | 62017.0 |
| 2021-04-16 17:00:00 | AAPL | Stock | 134.04 | 134.27 | 134.0 | 134.02 | 153030.0 |
| 2021-04-16 17:30:00 | AAPL | Stock | 134.05 | 134.16 | 134.01 | 134.04 | 35116.0 |
| 2021-04-16 18:00:00 | AAPL | Stock | 134.05 | 134.13 | 134.05 | 134.12 | 24343.0 |
| 2021-04-16 18:30:00 | AAPL | Stock | 134.11 | 134.15 | 134.09 | 134.12 | 16367.0 |
| 2021-04-16 19:00:00 | AAPL | Stock | 134.11 | 134.12 | 134.07 | 134.08 | 14105.0 |
| 2021-04-16 19:30:00 | AAPL | Stock | 134.09 | 134.15 | 134.07 | 134.09 | 33603.0 |
| 2021-04-16 04:00:00 | MSFT | Stock | 258.26 | 258.88 | 257.96 | 258.85 | 1999.0 |
| 2021-04-16 04:30:00 | MSFT | Stock | 258.61 | 258.61 | 258.52 | 258.52 | 635.0 |
| 2021-04-16 05:00:00 | MSFT | Stock | 258.7 | 259.0 | 258.7 | 259.0 | 987.0 |
| 2021-04-16 05:30:00 | MSFT | Stock | 259.2 | 259.2 | 258.95 | 258.95 | 525.0 |
| 2021-04-16 06:00:00 | MSFT | Stock | 259.1 | 259.49 | 259.1 | 259.49 | 506.0 |
| 2021-04-16 06:30:00 | MSFT | Stock | 259.4 | 259.5 | 259.17 | 259.17 | 1753.0 |
| 2021-04-16 07:00:00 | MSFT | Stock | 259.4 | 259.5 | 259.2 | 259.49 | 5079.0 |
| 2021-04-16 07:30:00 | MSFT | Stock | 259.49 | 259.79 | 259.28 | 259.5 | 5634.0 |
| 2021-04-16 08:00:00 | MSFT | Stock | 259.48 | 260.34 | 258.852 | 260.0 | 22363.0 |
| 2021-04-16 08:30:00 | MSFT | Stock | 260.0 | 260.11 | 259.88 | 259.9 | 6157.0 |
| 2021-04-16 09:00:00 | MSFT | Stock | 259.87 | 260.89 | 259.2001 | 259.43 | 259296.0 |
| 2021-04-16 09:30:00 | MSFT | Stock | 259.43 | 260.0 | 257.6014 | 258.3325 | 3716591.0 |
| 2021-04-16 10:00:00 | MSFT | Stock | 258.33 | 260.53 | 258.28 | 259.5439 | 1495229.0 |
| 2021-04-16 10:30:00 | MSFT | Stock | 259.57 | 260.09 | 259.13 | 259.58 | 989140.0 |
| 2021-04-16 11:00:00 | MSFT | Stock | 259.6 | 259.7 | 259.01 | 259.23 | 747163.0 |
| 2021-04-16 11:30:00 | MSFT | Stock | 259.24 | 259.4869 | 259.04 | 259.45 | 751084.0 |
| 2021-04-16 12:00:00 | MSFT | Stock | 259.45 | 260.64 | 259.38 | 260.47 | 1439944.0 |
| 2021-04-16 12:30:00 | MSFT | Stock | 260.47 | 260.6204 | 260.0754 | 260.17 | 736192.0 |
> showing 50 of 111,709 rows — these rows as CSV