PREVIEW / stock_30min / 2020-10-08
file: by_date/stock_30min/2020/2020-10-08.parquet size: 2.0 MB rows: 98,810 symbols: 2,520
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-10-08 04:00:00 | AAPL | Stock | 116.0 | 116.1 | 115.79 | 115.84 | 41564.0 |
| 2020-10-08 04:30:00 | AAPL | Stock | 115.84 | 116.09 | 115.78 | 116.03 | 9339.0 |
| 2020-10-08 05:00:00 | AAPL | Stock | 116.05 | 116.34 | 116.01 | 116.2 | 16775.0 |
| 2020-10-08 05:30:00 | AAPL | Stock | 116.16 | 116.27 | 116.06 | 116.19 | 21823.0 |
| 2020-10-08 06:00:00 | AAPL | Stock | 116.1 | 116.3 | 116.08 | 116.17 | 12053.0 |
| 2020-10-08 06:30:00 | AAPL | Stock | 116.15 | 116.34 | 115.79 | 115.99 | 26382.0 |
| 2020-10-08 07:00:00 | AAPL | Stock | 115.91 | 116.15 | 115.8 | 116.15 | 197823.0 |
| 2020-10-08 07:30:00 | AAPL | Stock | 116.09 | 116.28 | 115.95 | 116.25 | 147868.0 |
| 2020-10-08 08:00:00 | AAPL | Stock | 116.0 | 116.5 | 115.85 | 116.3 | 491964.0 |
| 2020-10-08 08:30:00 | AAPL | Stock | 116.3 | 116.32 | 116.1 | 116.18 | 290773.0 |
| 2020-10-08 09:00:00 | AAPL | Stock | 116.18 | 116.3 | 116.15 | 116.28 | 227073.0 |
| 2020-10-08 09:30:00 | AAPL | Stock | 116.25 | 116.4 | 115.36 | 115.528 | 13430425.0 |
| 2020-10-08 10:00:00 | AAPL | Stock | 115.525 | 115.69 | 115.05 | 115.21 | 6491339.0 |
| 2020-10-08 10:30:00 | AAPL | Stock | 115.21 | 115.48 | 115.1 | 115.265 | 4913697.0 |
| 2020-10-08 11:00:00 | AAPL | Stock | 115.27 | 115.78 | 115.15 | 115.445 | 5845501.0 |
| 2020-10-08 11:30:00 | AAPL | Stock | 115.45 | 115.46 | 114.92 | 115.23 | 5865459.0 |
| 2020-10-08 12:00:00 | AAPL | Stock | 115.24 | 115.54 | 115.23 | 115.36 | 4121998.0 |
| 2020-10-08 12:30:00 | AAPL | Stock | 115.36 | 115.42 | 115.16 | 115.26 | 2678062.0 |
| 2020-10-08 13:00:00 | AAPL | Stock | 115.265 | 115.3 | 114.65 | 114.835 | 4635622.0 |
| 2020-10-08 13:30:00 | AAPL | Stock | 114.822 | 115.0 | 114.7 | 114.715 | 3338154.0 |
| 2020-10-08 14:00:00 | AAPL | Stock | 114.71 | 115.03 | 114.59 | 114.9 | 4086538.0 |
| 2020-10-08 14:30:00 | AAPL | Stock | 114.901 | 115.14 | 114.828 | 115.1 | 3835413.0 |
| 2020-10-08 15:00:00 | AAPL | Stock | 115.105 | 115.13 | 114.81 | 114.965 | 3932260.0 |
| 2020-10-08 15:30:00 | AAPL | Stock | 114.96 | 115.0 | 114.78 | 114.97 | 5924658.0 |
| 2020-10-08 16:00:00 | AAPL | Stock | 114.97 | 115.12 | 114.83 | 115.08 | 5062159.0 |
| 2020-10-08 16:30:00 | AAPL | Stock | 115.07 | 115.19 | 114.97 | 115.08 | 315016.0 |
| 2020-10-08 17:00:00 | AAPL | Stock | 115.08 | 115.16 | 115.06 | 115.06 | 44824.0 |
| 2020-10-08 17:30:00 | AAPL | Stock | 115.1 | 115.15 | 115.02 | 115.12 | 104209.0 |
| 2020-10-08 18:00:00 | AAPL | Stock | 115.13 | 115.19 | 115.05 | 115.15 | 346091.0 |
| 2020-10-08 18:30:00 | AAPL | Stock | 115.15 | 115.199 | 115.1 | 115.19 | 47604.0 |
| 2020-10-08 19:00:00 | AAPL | Stock | 115.2 | 115.22 | 115.17 | 115.22 | 50912.0 |
| 2020-10-08 19:30:00 | AAPL | Stock | 115.22 | 115.28 | 115.18 | 115.27 | 120919.0 |
| 2020-10-08 04:00:00 | MSFT | Stock | 210.37 | 210.8 | 210.37 | 210.6 | 510.0 |
| 2020-10-08 04:30:00 | MSFT | Stock | 210.4 | 210.44 | 210.4 | 210.44 | 1200.0 |
| 2020-10-08 05:00:00 | MSFT | Stock | 210.33 | 210.6 | 210.33 | 210.33 | 1840.0 |
| 2020-10-08 05:30:00 | MSFT | Stock | 210.31 | 210.31 | 210.31 | 210.31 | 100.0 |
| 2020-10-08 06:00:00 | MSFT | Stock | 210.14 | 210.15 | 210.07 | 210.1 | 2216.0 |
| 2020-10-08 06:30:00 | MSFT | Stock | 210.0 | 210.54 | 209.79 | 210.27 | 10496.0 |
| 2020-10-08 07:00:00 | MSFT | Stock | 210.07 | 210.1 | 209.83 | 209.98 | 19887.0 |
| 2020-10-08 07:30:00 | MSFT | Stock | 209.88 | 210.79 | 209.8 | 210.61 | 16839.0 |
| 2020-10-08 08:00:00 | MSFT | Stock | 209.977 | 211.0 | 209.8 | 210.75 | 44680.0 |
| 2020-10-08 08:30:00 | MSFT | Stock | 210.7 | 210.78 | 209.83 | 210.51 | 18440.0 |
| 2020-10-08 09:00:00 | MSFT | Stock | 210.6 | 210.88 | 210.4 | 210.55 | 16268.0 |
| 2020-10-08 09:30:00 | MSFT | Stock | 210.5 | 210.87 | 209.21 | 209.64 | 2192196.0 |
| 2020-10-08 10:00:00 | MSFT | Stock | 209.63 | 209.74 | 208.32 | 208.76 | 1395710.0 |
| 2020-10-08 10:30:00 | MSFT | Stock | 208.76 | 209.86 | 208.75 | 209.5 | 1147412.0 |
| 2020-10-08 11:00:00 | MSFT | Stock | 209.5 | 210.51 | 209.39 | 210.18 | 1362343.0 |
| 2020-10-08 11:30:00 | MSFT | Stock | 210.17 | 210.77 | 209.75 | 210.07 | 1017868.0 |
| 2020-10-08 12:00:00 | MSFT | Stock | 210.08 | 211.178 | 210.05 | 210.76 | 1000315.0 |
| 2020-10-08 12:30:00 | MSFT | Stock | 210.745 | 211.19 | 210.61 | 210.782 | 544531.0 |
> showing 50 of 98,810 rows — these rows as CSV