PREVIEW / stock_30min / 2020-12-30
file: by_date/stock_30min/2020/2020-12-30.parquet size: 2.2 MB rows: 110,256 symbols: 2,672
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-30 04:00:00 | AAPL | Stock | 135.41 | 135.5 | 135.3 | 135.47 | 11705.0 |
| 2020-12-30 04:30:00 | AAPL | Stock | 135.42 | 135.45 | 135.37 | 135.44 | 4588.0 |
| 2020-12-30 05:00:00 | AAPL | Stock | 135.49 | 135.7 | 135.47 | 135.65 | 4074.0 |
| 2020-12-30 05:30:00 | AAPL | Stock | 135.68 | 135.68 | 135.59 | 135.68 | 2268.0 |
| 2020-12-30 06:00:00 | AAPL | Stock | 135.7 | 135.75 | 135.5 | 135.58 | 7050.0 |
| 2020-12-30 06:30:00 | AAPL | Stock | 135.59 | 135.8 | 135.4 | 135.8 | 11942.0 |
| 2020-12-30 07:00:00 | AAPL | Stock | 135.75 | 135.84 | 135.43 | 135.45 | 109620.0 |
| 2020-12-30 07:30:00 | AAPL | Stock | 135.45 | 135.65 | 135.19 | 135.639 | 99828.0 |
| 2020-12-30 08:00:00 | AAPL | Stock | 135.66 | 135.8 | 135.19 | 135.77 | 273394.0 |
| 2020-12-30 08:30:00 | AAPL | Stock | 135.77 | 135.82 | 135.6 | 135.62 | 134644.0 |
| 2020-12-30 09:00:00 | AAPL | Stock | 135.6 | 135.9 | 135.45 | 135.54 | 329635.0 |
| 2020-12-30 09:30:00 | AAPL | Stock | 135.54 | 135.99 | 134.43 | 134.8 | 12826295.0 |
| 2020-12-30 10:00:00 | AAPL | Stock | 134.79 | 134.88 | 133.66 | 133.995 | 9737092.0 |
| 2020-12-30 10:30:00 | AAPL | Stock | 134.009 | 134.461 | 133.565 | 134.391 | 6709535.0 |
| 2020-12-30 11:00:00 | AAPL | Stock | 134.39 | 134.78 | 134.1 | 134.62 | 4927519.0 |
| 2020-12-30 11:30:00 | AAPL | Stock | 134.617 | 135.14 | 134.6 | 135.126 | 5710826.0 |
| 2020-12-30 12:00:00 | AAPL | Stock | 135.12 | 135.18 | 134.53 | 134.675 | 4396389.0 |
| 2020-12-30 12:30:00 | AAPL | Stock | 134.68 | 134.71 | 134.2 | 134.36 | 4043940.0 |
| 2020-12-30 13:00:00 | AAPL | Stock | 134.355 | 134.55 | 134.235 | 134.46 | 3424619.0 |
| 2020-12-30 13:30:00 | AAPL | Stock | 134.455 | 134.62 | 134.26 | 134.544 | 2684469.0 |
| 2020-12-30 14:00:00 | AAPL | Stock | 134.54 | 134.589 | 133.86 | 133.99 | 4650571.0 |
| 2020-12-30 14:30:00 | AAPL | Stock | 134.0 | 134.01 | 133.69 | 133.774 | 4309315.0 |
| 2020-12-30 15:00:00 | AAPL | Stock | 133.765 | 133.85 | 133.4 | 133.703 | 5065903.0 |
| 2020-12-30 15:30:00 | AAPL | Stock | 133.7 | 134.18 | 133.49 | 133.72 | 8944645.0 |
| 2020-12-30 16:00:00 | AAPL | Stock | 133.72 | 133.87 | 133.7 | 133.74 | 6388912.0 |
| 2020-12-30 16:30:00 | AAPL | Stock | 133.75 | 133.78 | 133.67 | 133.67 | 54426.0 |
| 2020-12-30 17:00:00 | AAPL | Stock | 133.67 | 133.74 | 133.53 | 133.6 | 74178.0 |
| 2020-12-30 17:30:00 | AAPL | Stock | 133.6 | 133.75 | 133.54 | 133.75 | 33112.0 |
| 2020-12-30 18:00:00 | AAPL | Stock | 133.74 | 133.82 | 133.73 | 133.82 | 45815.0 |
| 2020-12-30 18:30:00 | AAPL | Stock | 133.85 | 133.85 | 133.69 | 133.74 | 21776.0 |
| 2020-12-30 19:00:00 | AAPL | Stock | 133.75 | 133.77 | 133.68 | 133.75 | 37902.0 |
| 2020-12-30 19:30:00 | AAPL | Stock | 133.75 | 133.82 | 133.69 | 133.82 | 59531.0 |
| 2020-12-30 04:00:00 | MSFT | Stock | 224.72 | 225.0 | 224.72 | 225.0 | 801.0 |
| 2020-12-30 04:30:00 | MSFT | Stock | 224.72 | 224.72 | 224.72 | 224.72 | 100.0 |
| 2020-12-30 05:00:00 | MSFT | Stock | 225.0 | 225.0 | 225.0 | 225.0 | 976.0 |
| 2020-12-30 05:30:00 | MSFT | Stock | 224.97 | 224.97 | 224.97 | 224.97 | 100.0 |
| 2020-12-30 06:30:00 | MSFT | Stock | 224.86 | 224.87 | 224.83 | 224.83 | 1434.0 |
| 2020-12-30 07:00:00 | MSFT | Stock | 224.77 | 224.9 | 224.52 | 224.52 | 5762.0 |
| 2020-12-30 07:30:00 | MSFT | Stock | 224.53 | 224.85 | 224.5 | 224.82 | 11598.0 |
| 2020-12-30 08:00:00 | MSFT | Stock | 224.85 | 224.92 | 224.6 | 224.9 | 19624.0 |
| 2020-12-30 08:30:00 | MSFT | Stock | 224.92 | 225.09 | 224.91 | 224.92 | 10764.0 |
| 2020-12-30 09:00:00 | MSFT | Stock | 225.14 | 225.6 | 225.01 | 225.31 | 22987.0 |
| 2020-12-30 09:30:00 | MSFT | Stock | 225.29 | 225.63 | 222.88 | 223.254 | 2262397.0 |
| 2020-12-30 10:00:00 | MSFT | Stock | 223.25 | 223.32 | 222.453 | 222.95 | 1336234.0 |
| 2020-12-30 10:30:00 | MSFT | Stock | 222.96 | 223.08 | 222.3 | 223.029 | 1011309.0 |
| 2020-12-30 11:00:00 | MSFT | Stock | 223.02 | 223.099 | 222.32 | 222.36 | 757356.0 |
| 2020-12-30 11:30:00 | MSFT | Stock | 222.36 | 222.74 | 222.31 | 222.53 | 673498.0 |
| 2020-12-30 12:00:00 | MSFT | Stock | 222.522 | 222.56 | 222.35 | 222.49 | 542784.0 |
| 2020-12-30 12:30:00 | MSFT | Stock | 222.49 | 222.72 | 222.32 | 222.717 | 693642.0 |
| 2020-12-30 13:00:00 | MSFT | Stock | 222.71 | 223.055 | 222.69 | 222.77 | 678776.0 |
> showing 50 of 110,256 rows — these rows as CSV