PREVIEW / stock_30min / 2020-08-31
file: by_date/stock_30min/2020/2020-08-31.parquet size: 2.0 MB rows: 98,936 symbols: 2,465
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-08-31 04:00:00 | AAPL | Stock | 128.0 | 137.29 | 125.6 | 126.6 | 289976.0 |
| 2020-08-31 04:30:00 | AAPL | Stock | 126.59 | 127.14 | 126.41 | 126.99 | 94107.0 |
| 2020-08-31 05:00:00 | AAPL | Stock | 126.99 | 126.99 | 126.6 | 126.7 | 42266.0 |
| 2020-08-31 05:30:00 | AAPL | Stock | 126.71 | 126.77 | 126.36 | 126.7 | 59430.0 |
| 2020-08-31 06:00:00 | AAPL | Stock | 126.67 | 126.74 | 126.26 | 126.64 | 51576.0 |
| 2020-08-31 06:30:00 | AAPL | Stock | 126.68 | 126.72 | 125.95 | 126.04 | 90623.0 |
| 2020-08-31 07:00:00 | AAPL | Stock | 126.2 | 126.9 | 125.36 | 125.8 | 908499.0 |
| 2020-08-31 07:30:00 | AAPL | Stock | 125.79 | 126.1 | 125.37 | 125.75 | 557564.0 |
| 2020-08-31 08:00:00 | AAPL | Stock | 125.73 | 126.9 | 125.21 | 125.75 | 1233841.0 |
| 2020-08-31 08:30:00 | AAPL | Stock | 125.75 | 126.05 | 125.3 | 125.67 | 837724.0 |
| 2020-08-31 09:00:00 | AAPL | Stock | 125.67 | 128.1 | 125.02 | 127.62 | 3877212.0 |
| 2020-08-31 09:30:00 | AAPL | Stock | 127.62 | 128.74 | 126.0 | 128.035 | 31063338.0 |
| 2020-08-31 10:00:00 | AAPL | Stock | 128.048 | 128.5 | 127.12 | 128.23 | 14274918.0 |
| 2020-08-31 10:30:00 | AAPL | Stock | 128.23 | 129.5 | 127.85 | 129.065 | 15843142.0 |
| 2020-08-31 11:00:00 | AAPL | Stock | 129.07 | 130.05 | 127.92 | 128.54 | 18466116.0 |
| 2020-08-31 11:30:00 | AAPL | Stock | 128.546 | 129.52 | 127.7 | 128.95 | 12496470.0 |
| 2020-08-31 12:00:00 | AAPL | Stock | 128.94 | 129.41 | 128.53 | 129.323 | 7970051.0 |
| 2020-08-31 12:30:00 | AAPL | Stock | 129.325 | 129.69 | 128.96 | 129.456 | 6638563.0 |
| 2020-08-31 13:00:00 | AAPL | Stock | 129.46 | 130.9 | 129.4 | 130.26 | 12032860.0 |
| 2020-08-31 13:30:00 | AAPL | Stock | 130.257 | 131.0 | 130.257 | 130.69 | 7683131.0 |
| 2020-08-31 14:00:00 | AAPL | Stock | 130.681 | 130.89 | 130.5 | 130.63 | 5747479.0 |
| 2020-08-31 14:30:00 | AAPL | Stock | 130.63 | 130.69 | 129.76 | 130.521 | 8298093.0 |
| 2020-08-31 15:00:00 | AAPL | Stock | 130.52 | 130.6 | 129.37 | 129.99 | 9137466.0 |
| 2020-08-31 15:30:00 | AAPL | Stock | 130.0 | 130.29 | 128.75 | 128.85 | 15483682.0 |
| 2020-08-31 16:00:00 | AAPL | Stock | 128.85 | 129.65 | 128.79 | 129.51 | 14224135.0 |
| 2020-08-31 16:30:00 | AAPL | Stock | 129.54 | 129.64 | 129.0 | 129.1 | 334704.0 |
| 2020-08-31 17:00:00 | AAPL | Stock | 129.1 | 129.64 | 129.07 | 129.5 | 234223.0 |
| 2020-08-31 17:30:00 | AAPL | Stock | 129.45 | 129.6 | 129.37 | 129.41 | 82606.0 |
| 2020-08-31 18:00:00 | AAPL | Stock | 129.41 | 129.65 | 129.01 | 129.32 | 186823.0 |
| 2020-08-31 18:30:00 | AAPL | Stock | 129.3 | 129.38 | 129.1 | 129.2 | 64577.0 |
| 2020-08-31 19:00:00 | AAPL | Stock | 129.17 | 129.25 | 129.12 | 129.25 | 64344.0 |
| 2020-08-31 19:30:00 | AAPL | Stock | 129.25 | 129.48 | 129.15 | 129.33 | 107278.0 |
| 2020-08-31 04:00:00 | MSFT | Stock | 228.0 | 228.0 | 222.0 | 223.1 | 21893.0 |
| 2020-08-31 04:30:00 | MSFT | Stock | 223.14 | 224.34 | 223.14 | 224.04 | 10791.0 |
| 2020-08-31 05:00:00 | MSFT | Stock | 224.0 | 225.5 | 223.91 | 225.19 | 10203.0 |
| 2020-08-31 05:30:00 | MSFT | Stock | 225.16 | 225.68 | 224.78 | 225.65 | 6505.0 |
| 2020-08-31 06:00:00 | MSFT | Stock | 225.78 | 225.98 | 225.15 | 225.15 | 4359.0 |
| 2020-08-31 06:30:00 | MSFT | Stock | 225.89 | 226.0 | 225.65 | 225.79 | 2048.0 |
| 2020-08-31 07:00:00 | MSFT | Stock | 226.0 | 226.0 | 224.2 | 224.67 | 47524.0 |
| 2020-08-31 07:30:00 | MSFT | Stock | 224.74 | 224.87 | 224.1 | 224.43 | 27474.0 |
| 2020-08-31 08:00:00 | MSFT | Stock | 224.5 | 225.78 | 224.1 | 224.58 | 75391.0 |
| 2020-08-31 08:30:00 | MSFT | Stock | 224.46 | 227.7 | 224.25 | 227.0 | 186965.0 |
| 2020-08-31 09:00:00 | MSFT | Stock | 227.0 | 227.3 | 225.83 | 227.2 | 233032.0 |
| 2020-08-31 09:30:00 | MSFT | Stock | 227.1 | 228.7 | 226.5 | 227.36 | 3784602.0 |
| 2020-08-31 10:00:00 | MSFT | Stock | 227.37 | 227.9 | 226.17 | 226.35 | 1950310.0 |
| 2020-08-31 10:30:00 | MSFT | Stock | 226.38 | 226.69 | 225.46 | 226.035 | 1497565.0 |
| 2020-08-31 11:00:00 | MSFT | Stock | 226.035 | 226.25 | 224.58 | 224.937 | 1792388.0 |
| 2020-08-31 11:30:00 | MSFT | Stock | 224.925 | 225.58 | 224.31 | 225.105 | 1100251.0 |
| 2020-08-31 12:00:00 | MSFT | Stock | 225.111 | 225.9 | 225.11 | 225.595 | 723303.0 |
| 2020-08-31 12:30:00 | MSFT | Stock | 225.59 | 225.84 | 225.32 | 225.477 | 531725.0 |
> showing 50 of 98,936 rows — these rows as CSV