PREVIEW / stock_30min / 2020-11-25
file: by_date/stock_30min/2020/2020-11-25.parquet size: 2.1 MB rows: 104,707 symbols: 2,594
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-11-25 04:00:00 | AAPL | Stock | 115.54 | 115.54 | 115.19 | 115.2 | 6342.0 |
| 2020-11-25 04:30:00 | AAPL | Stock | 115.26 | 115.59 | 115.0 | 115.59 | 14292.0 |
| 2020-11-25 05:00:00 | AAPL | Stock | 115.56 | 115.66 | 115.11 | 115.21 | 13073.0 |
| 2020-11-25 05:30:00 | AAPL | Stock | 115.25 | 115.45 | 115.16 | 115.25 | 5352.0 |
| 2020-11-25 06:00:00 | AAPL | Stock | 115.27 | 115.43 | 115.19 | 115.23 | 4880.0 |
| 2020-11-25 06:30:00 | AAPL | Stock | 115.26 | 115.68 | 115.19 | 115.42 | 21030.0 |
| 2020-11-25 07:00:00 | AAPL | Stock | 115.5 | 115.67 | 115.37 | 115.61 | 101912.0 |
| 2020-11-25 07:30:00 | AAPL | Stock | 115.62 | 115.64 | 115.16 | 115.23 | 108527.0 |
| 2020-11-25 08:00:00 | AAPL | Stock | 115.23 | 115.64 | 114.98 | 114.98 | 267961.0 |
| 2020-11-25 08:30:00 | AAPL | Stock | 114.98 | 115.45 | 114.9 | 115.2 | 226712.0 |
| 2020-11-25 09:00:00 | AAPL | Stock | 115.2 | 115.75 | 115.04 | 115.53 | 245804.0 |
| 2020-11-25 09:30:00 | AAPL | Stock | 115.54 | 116.61 | 115.17 | 116.35 | 14017781.0 |
| 2020-11-25 10:00:00 | AAPL | Stock | 116.354 | 116.405 | 115.53 | 115.98 | 7065378.0 |
| 2020-11-25 10:30:00 | AAPL | Stock | 115.978 | 116.53 | 115.88 | 116.5 | 4776470.0 |
| 2020-11-25 11:00:00 | AAPL | Stock | 116.492 | 116.75 | 115.99 | 116.17 | 5014883.0 |
| 2020-11-25 11:30:00 | AAPL | Stock | 116.17 | 116.324 | 115.89 | 116.02 | 3872319.0 |
| 2020-11-25 12:00:00 | AAPL | Stock | 116.03 | 116.06 | 115.7 | 115.948 | 3017071.0 |
| 2020-11-25 12:30:00 | AAPL | Stock | 115.94 | 116.33 | 115.86 | 116.21 | 2764437.0 |
| 2020-11-25 13:00:00 | AAPL | Stock | 116.215 | 116.34 | 115.995 | 116.03 | 2448412.0 |
| 2020-11-25 13:30:00 | AAPL | Stock | 116.02 | 116.12 | 115.87 | 115.99 | 2309587.0 |
| 2020-11-25 14:00:00 | AAPL | Stock | 115.986 | 116.05 | 115.731 | 116.03 | 2864117.0 |
| 2020-11-25 14:30:00 | AAPL | Stock | 116.034 | 116.139 | 115.8 | 116.122 | 2607025.0 |
| 2020-11-25 15:00:00 | AAPL | Stock | 116.12 | 116.37 | 115.96 | 116.34 | 3580200.0 |
| 2020-11-25 15:30:00 | AAPL | Stock | 116.33 | 116.47 | 115.95 | 116.02 | 6694600.0 |
| 2020-11-25 16:00:00 | AAPL | Stock | 116.03 | 116.41 | 116.01 | 116.2 | 6327518.0 |
| 2020-11-25 16:30:00 | AAPL | Stock | 116.15 | 116.27 | 116.11 | 116.21 | 26785.0 |
| 2020-11-25 17:00:00 | AAPL | Stock | 116.2 | 116.21 | 116.17 | 116.18 | 18270.0 |
| 2020-11-25 17:30:00 | AAPL | Stock | 116.17 | 116.18 | 116.11 | 116.13 | 23440.0 |
| 2020-11-25 18:00:00 | AAPL | Stock | 116.13 | 116.22 | 116.13 | 116.18 | 37975.0 |
| 2020-11-25 18:30:00 | AAPL | Stock | 116.2 | 116.28 | 116.18 | 116.28 | 22748.0 |
| 2020-11-25 19:00:00 | AAPL | Stock | 116.28 | 116.3 | 116.19 | 116.23 | 28469.0 |
| 2020-11-25 19:30:00 | AAPL | Stock | 116.25 | 116.27 | 116.21 | 116.27 | 31589.0 |
| 2020-11-25 04:00:00 | MSFT | Stock | 214.19 | 214.19 | 214.18 | 214.18 | 1354.0 |
| 2020-11-25 04:30:00 | MSFT | Stock | 214.2 | 214.2 | 214.16 | 214.16 | 1732.0 |
| 2020-11-25 05:00:00 | MSFT | Stock | 214.25 | 214.5 | 214.25 | 214.48 | 4426.0 |
| 2020-11-25 05:30:00 | MSFT | Stock | 214.47 | 214.55 | 214.47 | 214.47 | 1090.0 |
| 2020-11-25 06:00:00 | MSFT | Stock | 214.78 | 214.78 | 214.32 | 214.32 | 840.0 |
| 2020-11-25 06:30:00 | MSFT | Stock | 214.39 | 214.97 | 214.39 | 214.75 | 3570.0 |
| 2020-11-25 07:00:00 | MSFT | Stock | 214.6 | 214.75 | 214.54 | 214.69 | 2123.0 |
| 2020-11-25 07:30:00 | MSFT | Stock | 214.74 | 214.98 | 214.51 | 214.69 | 11816.0 |
| 2020-11-25 08:00:00 | MSFT | Stock | 214.75 | 214.98 | 213.33 | 214.45 | 30110.0 |
| 2020-11-25 08:30:00 | MSFT | Stock | 214.44 | 215.2 | 214.44 | 214.715 | 29444.0 |
| 2020-11-25 09:00:00 | MSFT | Stock | 214.71 | 215.5 | 214.65 | 215.29 | 31791.0 |
| 2020-11-25 09:30:00 | MSFT | Stock | 215.29 | 215.29 | 213.5 | 213.93 | 2891689.0 |
| 2020-11-25 10:00:00 | MSFT | Stock | 213.91 | 214.11 | 213.13 | 213.35 | 1335852.0 |
| 2020-11-25 10:30:00 | MSFT | Stock | 213.38 | 214.069 | 213.276 | 213.67 | 895040.0 |
| 2020-11-25 11:00:00 | MSFT | Stock | 213.675 | 213.96 | 213.3 | 213.53 | 957612.0 |
| 2020-11-25 11:30:00 | MSFT | Stock | 213.52 | 213.91 | 212.46 | 212.83 | 1261731.0 |
| 2020-11-25 12:00:00 | MSFT | Stock | 212.82 | 213.47 | 212.7 | 213.267 | 716365.0 |
| 2020-11-25 12:30:00 | MSFT | Stock | 213.28 | 213.68 | 213.09 | 213.59 | 531831.0 |
> showing 50 of 104,707 rows — these rows as CSV