PREVIEW / stock_30min / 2020-12-01
file: by_date/stock_30min/2020/2020-12-01.parquet size: 2.1 MB rows: 106,697 symbols: 2,620
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-01 04:00:00 | AAPL | Stock | 120.84 | 120.99 | 119.95 | 120.74 | 55730.0 |
| 2020-12-01 04:30:00 | AAPL | Stock | 120.7 | 121.01 | 120.56 | 120.76 | 32018.0 |
| 2020-12-01 05:00:00 | AAPL | Stock | 120.7 | 120.89 | 120.6 | 120.8 | 13010.0 |
| 2020-12-01 05:30:00 | AAPL | Stock | 120.85 | 121.45 | 120.77 | 121.27 | 34624.0 |
| 2020-12-01 06:00:00 | AAPL | Stock | 121.27 | 121.5 | 120.98 | 121.2 | 41637.0 |
| 2020-12-01 06:30:00 | AAPL | Stock | 121.19 | 121.83 | 121.02 | 121.1 | 40627.0 |
| 2020-12-01 07:00:00 | AAPL | Stock | 121.11 | 121.66 | 121.04 | 121.34 | 220952.0 |
| 2020-12-01 07:30:00 | AAPL | Stock | 121.32 | 121.53 | 121.23 | 121.45 | 118516.0 |
| 2020-12-01 08:00:00 | AAPL | Stock | 121.27 | 121.66 | 121.08 | 121.18 | 448561.0 |
| 2020-12-01 08:30:00 | AAPL | Stock | 121.18 | 121.25 | 120.88 | 121.09 | 263377.0 |
| 2020-12-01 09:00:00 | AAPL | Stock | 121.1 | 121.3 | 120.77 | 120.99 | 397023.0 |
| 2020-12-01 09:30:00 | AAPL | Stock | 120.98 | 122.6 | 120.01 | 122.39 | 20182021.0 |
| 2020-12-01 10:00:00 | AAPL | Stock | 122.388 | 122.96 | 121.98 | 122.065 | 12369226.0 |
| 2020-12-01 10:30:00 | AAPL | Stock | 122.06 | 122.53 | 121.62 | 122.46 | 9139345.0 |
| 2020-12-01 11:00:00 | AAPL | Stock | 122.46 | 122.84 | 122.09 | 122.71 | 7353334.0 |
| 2020-12-01 11:30:00 | AAPL | Stock | 122.71 | 123.25 | 122.48 | 123.099 | 8710735.0 |
| 2020-12-01 12:00:00 | AAPL | Stock | 123.1 | 123.469 | 122.82 | 122.89 | 6961547.0 |
| 2020-12-01 12:30:00 | AAPL | Stock | 122.89 | 123.12 | 122.56 | 122.581 | 4271432.0 |
| 2020-12-01 13:00:00 | AAPL | Stock | 122.585 | 123.1 | 122.565 | 123.02 | 3792098.0 |
| 2020-12-01 13:30:00 | AAPL | Stock | 123.025 | 123.29 | 122.74 | 122.775 | 4143524.0 |
| 2020-12-01 14:00:00 | AAPL | Stock | 122.775 | 123.15 | 122.71 | 123.08 | 4084595.0 |
| 2020-12-01 14:30:00 | AAPL | Stock | 123.09 | 123.22 | 122.62 | 122.788 | 4413458.0 |
| 2020-12-01 15:00:00 | AAPL | Stock | 122.785 | 122.81 | 122.06 | 122.629 | 5754785.0 |
| 2020-12-01 15:30:00 | AAPL | Stock | 122.63 | 122.96 | 122.31 | 122.7 | 9362546.0 |
| 2020-12-01 16:00:00 | AAPL | Stock | 122.72 | 123.15 | 122.68 | 122.9 | 9289354.0 |
| 2020-12-01 16:30:00 | AAPL | Stock | 122.9 | 123.0 | 122.318 | 122.87 | 123559.0 |
| 2020-12-01 17:00:00 | AAPL | Stock | 122.87 | 122.99 | 122.83 | 122.97 | 50463.0 |
| 2020-12-01 17:30:00 | AAPL | Stock | 122.98 | 122.98 | 122.59 | 122.65 | 96135.0 |
| 2020-12-01 18:00:00 | AAPL | Stock | 122.65 | 122.85 | 122.52 | 122.8 | 107337.0 |
| 2020-12-01 18:30:00 | AAPL | Stock | 122.8 | 122.91 | 122.65 | 122.85 | 102700.0 |
| 2020-12-01 19:00:00 | AAPL | Stock | 122.88 | 122.88 | 122.62 | 122.75 | 63534.0 |
| 2020-12-01 19:30:00 | AAPL | Stock | 122.67 | 122.72 | 122.2 | 122.36 | 162122.0 |
| 2020-12-01 04:00:00 | MSFT | Stock | 214.73 | 214.75 | 214.72 | 214.75 | 525.0 |
| 2020-12-01 04:30:00 | MSFT | Stock | 214.96 | 214.96 | 214.5 | 214.66 | 2051.0 |
| 2020-12-01 05:00:00 | MSFT | Stock | 214.75 | 214.75 | 214.75 | 214.75 | 100.0 |
| 2020-12-01 05:30:00 | MSFT | Stock | 214.95 | 215.34 | 214.93 | 215.34 | 3835.0 |
| 2020-12-01 06:00:00 | MSFT | Stock | 215.19 | 215.63 | 215.19 | 215.3 | 1755.0 |
| 2020-12-01 06:30:00 | MSFT | Stock | 215.45 | 215.86 | 215.45 | 215.5 | 21740.0 |
| 2020-12-01 07:00:00 | MSFT | Stock | 215.1 | 215.41 | 215.1 | 215.41 | 14093.0 |
| 2020-12-01 07:30:00 | MSFT | Stock | 215.45 | 215.5 | 215.26 | 215.5 | 3782.0 |
| 2020-12-01 08:00:00 | MSFT | Stock | 215.29 | 215.52 | 213.54 | 214.91 | 29928.0 |
| 2020-12-01 08:30:00 | MSFT | Stock | 215.0 | 215.15 | 214.5 | 215.0 | 16060.0 |
| 2020-12-01 09:00:00 | MSFT | Stock | 214.92 | 215.0 | 214.5 | 214.5 | 29355.0 |
| 2020-12-01 09:30:00 | MSFT | Stock | 214.51 | 215.08 | 213.35 | 213.72 | 3282190.0 |
| 2020-12-01 10:00:00 | MSFT | Stock | 213.715 | 214.23 | 213.43 | 213.852 | 1927104.0 |
| 2020-12-01 10:30:00 | MSFT | Stock | 213.89 | 214.29 | 213.402 | 213.91 | 1580879.0 |
| 2020-12-01 11:00:00 | MSFT | Stock | 213.92 | 214.42 | 213.909 | 213.99 | 1400903.0 |
| 2020-12-01 11:30:00 | MSFT | Stock | 213.98 | 214.72 | 213.65 | 214.68 | 1362598.0 |
| 2020-12-01 12:00:00 | MSFT | Stock | 214.68 | 215.49 | 214.62 | 215.46 | 1488879.0 |
| 2020-12-01 12:30:00 | MSFT | Stock | 215.45 | 215.89 | 215.1 | 215.46 | 1115666.0 |
> showing 50 of 106,697 rows — these rows as CSV