PREVIEW / stock_30min / 2021-10-04
file: by_date/stock_30min/2021/2021-10-04.parquet size: 2.2 MB rows: 110,233 symbols: 2,762
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-04 04:00:00 | AAPL | Stock | 141.46 | 141.83 | 141.38 | 141.61 | 13406.0 |
| 2021-10-04 04:30:00 | AAPL | Stock | 141.55 | 141.62 | 141.35 | 141.62 | 4053.0 |
| 2021-10-04 05:00:00 | AAPL | Stock | 141.63 | 141.84 | 141.6 | 141.6 | 4564.0 |
| 2021-10-04 05:30:00 | AAPL | Stock | 141.44 | 141.62 | 141.4 | 141.5 | 17487.0 |
| 2021-10-04 06:00:00 | AAPL | Stock | 141.46 | 141.7 | 141.35 | 141.43 | 12874.0 |
| 2021-10-04 06:30:00 | AAPL | Stock | 141.53 | 141.6 | 141.21 | 141.6 | 5517.0 |
| 2021-10-04 07:00:00 | AAPL | Stock | 141.59 | 141.84 | 141.23 | 141.49 | 98033.0 |
| 2021-10-04 07:30:00 | AAPL | Stock | 141.5 | 141.68 | 141.41 | 141.53 | 56849.0 |
| 2021-10-04 08:00:00 | AAPL | Stock | 141.5499 | 141.9 | 141.24 | 141.86 | 264010.0 |
| 2021-10-04 08:30:00 | AAPL | Stock | 141.86 | 142.2 | 141.6709 | 141.99 | 170343.0 |
| 2021-10-04 09:00:00 | AAPL | Stock | 141.9551 | 141.99 | 141.67 | 141.71 | 135465.0 |
| 2021-10-04 09:30:00 | AAPL | Stock | 141.71 | 142.21 | 140.24 | 140.73 | 9326065.0 |
| 2021-10-04 10:00:00 | AAPL | Stock | 140.72 | 140.8844 | 139.87 | 139.88 | 6512199.0 |
| 2021-10-04 10:30:00 | AAPL | Stock | 139.88 | 139.91 | 138.837 | 139.11 | 8071286.0 |
| 2021-10-04 11:00:00 | AAPL | Stock | 139.11 | 139.5 | 138.79 | 139.09 | 5622739.0 |
| 2021-10-04 11:30:00 | AAPL | Stock | 139.08 | 139.39 | 138.63 | 139.239 | 5176564.0 |
| 2021-10-04 12:00:00 | AAPL | Stock | 139.23 | 139.25 | 138.46 | 138.53 | 4510358.0 |
| 2021-10-04 12:30:00 | AAPL | Stock | 138.5315 | 138.6869 | 138.31 | 138.5199 | 4508176.0 |
| 2021-10-04 13:00:00 | AAPL | Stock | 138.515 | 138.905 | 138.27 | 138.5562 | 3818245.0 |
| 2021-10-04 13:30:00 | AAPL | Stock | 138.56 | 138.98 | 138.535 | 138.56 | 3650433.0 |
| 2021-10-04 14:00:00 | AAPL | Stock | 138.56 | 139.22 | 138.5499 | 138.7519 | 4915029.0 |
| 2021-10-04 14:30:00 | AAPL | Stock | 138.75 | 139.0799 | 138.53 | 138.945 | 3907836.0 |
| 2021-10-04 15:00:00 | AAPL | Stock | 138.95 | 139.32 | 138.51 | 138.585 | 5303771.0 |
| 2021-10-04 15:30:00 | AAPL | Stock | 138.58 | 139.23 | 138.47 | 139.19 | 10062830.0 |
| 2021-10-04 16:00:00 | AAPL | Stock | 139.14 | 139.35 | 139.14 | 139.2 | 9758701.0 |
| 2021-10-04 16:30:00 | AAPL | Stock | 139.2 | 139.3 | 139.15 | 139.21 | 38204.0 |
| 2021-10-04 17:00:00 | AAPL | Stock | 139.24 | 139.24 | 139.16 | 139.16 | 21731.0 |
| 2021-10-04 17:30:00 | AAPL | Stock | 139.15 | 139.24 | 139.15 | 139.21 | 25740.0 |
| 2021-10-04 18:00:00 | AAPL | Stock | 139.22 | 139.4 | 139.21 | 139.4 | 44495.0 |
| 2021-10-04 18:30:00 | AAPL | Stock | 139.45 | 139.5 | 139.38 | 139.41 | 30970.0 |
| 2021-10-04 19:00:00 | AAPL | Stock | 139.42 | 139.48 | 139.15 | 139.3 | 31048.0 |
| 2021-10-04 19:30:00 | AAPL | Stock | 139.29 | 139.34 | 139.14 | 139.14 | 44477.0 |
| 2021-10-04 04:00:00 | MSFT | Stock | 287.05 | 287.29 | 287.0 | 287.0 | 1072.0 |
| 2021-10-04 04:30:00 | MSFT | Stock | 286.7 | 286.7 | 286.57 | 286.57 | 663.0 |
| 2021-10-04 05:00:00 | MSFT | Stock | 287.11 | 287.2 | 287.11 | 287.2 | 300.0 |
| 2021-10-04 05:30:00 | MSFT | Stock | 287.37 | 287.38 | 287.01 | 287.01 | 948.0 |
| 2021-10-04 06:00:00 | MSFT | Stock | 287.29 | 287.38 | 287.04 | 287.04 | 3558.0 |
| 2021-10-04 06:30:00 | MSFT | Stock | 287.12 | 287.38 | 286.7 | 287.38 | 7992.0 |
| 2021-10-04 07:00:00 | MSFT | Stock | 287.35 | 287.47 | 286.7 | 287.13 | 59007.0 |
| 2021-10-04 07:30:00 | MSFT | Stock | 287.11 | 287.34 | 287.0 | 287.1 | 29477.0 |
| 2021-10-04 08:00:00 | MSFT | Stock | 287.29 | 287.87 | 286.7 | 287.8 | 13396.0 |
| 2021-10-04 08:30:00 | MSFT | Stock | 287.9 | 288.45 | 287.18 | 288.2061 | 22260.0 |
| 2021-10-04 09:00:00 | MSFT | Stock | 288.12 | 288.1259 | 287.49 | 287.49 | 20037.0 |
| 2021-10-04 09:30:00 | MSFT | Stock | 287.49 | 287.75 | 283.55 | 284.1 | 2612326.0 |
| 2021-10-04 10:00:00 | MSFT | Stock | 284.09 | 284.32 | 282.87 | 283.2086 | 1585485.0 |
| 2021-10-04 10:30:00 | MSFT | Stock | 283.18 | 283.18 | 280.4 | 281.25 | 1980384.0 |
| 2021-10-04 11:00:00 | MSFT | Stock | 281.22 | 282.54 | 280.7601 | 282.52 | 1445017.0 |
| 2021-10-04 11:30:00 | MSFT | Stock | 282.5 | 282.77 | 280.9 | 282.3 | 1529467.0 |
| 2021-10-04 12:00:00 | MSFT | Stock | 282.27 | 282.72 | 281.25 | 281.37 | 950547.0 |
| 2021-10-04 12:30:00 | MSFT | Stock | 281.35 | 281.73 | 280.47 | 280.915 | 864624.0 |
> showing 50 of 110,233 rows — these rows as CSV