PREVIEW / stock_30min / 2022-01-12
file: by_date/stock_30min/2022/2022-01-12.parquet size: 2.2 MB rows: 108,744 symbols: 2,590
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-12 04:00:00 | AAPL | Stock | 174.65 | 175.18 | 174.65 | 175.16 | 14498.0 |
| 2022-01-12 04:30:00 | AAPL | Stock | 175.24 | 175.89 | 175.21 | 175.82 | 11932.0 |
| 2022-01-12 05:00:00 | AAPL | Stock | 175.86 | 175.95 | 175.55 | 175.79 | 11839.0 |
| 2022-01-12 05:30:00 | AAPL | Stock | 175.82 | 176.04 | 175.78 | 175.97 | 5798.0 |
| 2022-01-12 06:00:00 | AAPL | Stock | 176.0 | 176.0 | 175.81 | 175.82 | 5642.0 |
| 2022-01-12 06:30:00 | AAPL | Stock | 175.85 | 175.86 | 175.76 | 175.76 | 3168.0 |
| 2022-01-12 07:00:00 | AAPL | Stock | 175.63 | 175.63 | 175.2 | 175.53 | 47656.0 |
| 2022-01-12 07:30:00 | AAPL | Stock | 175.55 | 175.7 | 175.5 | 175.64 | 37945.0 |
| 2022-01-12 08:00:00 | AAPL | Stock | 175.35 | 176.02 | 175.2 | 175.93 | 174233.0 |
| 2022-01-12 08:30:00 | AAPL | Stock | 175.9 | 176.78 | 175.72 | 176.76 | 359600.0 |
| 2022-01-12 09:00:00 | AAPL | Stock | 176.78 | 176.88 | 176.0 | 176.05 | 289678.0 |
| 2022-01-12 09:30:00 | AAPL | Stock | 176.09 | 176.79 | 175.3 | 176.32 | 9293564.0 |
| 2022-01-12 10:00:00 | AAPL | Stock | 176.33 | 177.18 | 176.065 | 176.76 | 7068870.0 |
| 2022-01-12 10:30:00 | AAPL | Stock | 176.7485 | 176.84 | 175.3 | 175.6475 | 5683289.0 |
| 2022-01-12 11:00:00 | AAPL | Stock | 175.64 | 175.92 | 174.82 | 175.64 | 5529743.0 |
| 2022-01-12 11:30:00 | AAPL | Stock | 175.64 | 176.255 | 175.635 | 175.83 | 3854332.0 |
| 2022-01-12 12:00:00 | AAPL | Stock | 175.84 | 176.04 | 175.31 | 175.779 | 2928267.0 |
| 2022-01-12 12:30:00 | AAPL | Stock | 175.78 | 176.39 | 175.73 | 176.24 | 3261623.0 |
| 2022-01-12 13:00:00 | AAPL | Stock | 176.24 | 176.275 | 175.57 | 175.685 | 2336453.0 |
| 2022-01-12 13:30:00 | AAPL | Stock | 175.685 | 176.03 | 175.47 | 175.57 | 2524680.0 |
| 2022-01-12 14:00:00 | AAPL | Stock | 175.565 | 175.81 | 175.22 | 175.7 | 2739442.0 |
| 2022-01-12 14:30:00 | AAPL | Stock | 175.695 | 175.7441 | 175.355 | 175.4999 | 2347812.0 |
| 2022-01-12 15:00:00 | AAPL | Stock | 175.5 | 175.6 | 175.08 | 175.46 | 2869426.0 |
| 2022-01-12 15:30:00 | AAPL | Stock | 175.45 | 175.94 | 175.15 | 175.61 | 6220372.0 |
| 2022-01-12 16:00:00 | AAPL | Stock | 175.53 | 175.7 | 175.44 | 175.51 | 6151576.0 |
| 2022-01-12 16:30:00 | AAPL | Stock | 175.5 | 175.53 | 175.36 | 175.41 | 35012.0 |
| 2022-01-12 17:00:00 | AAPL | Stock | 175.41 | 175.45 | 175.3 | 175.3 | 17776.0 |
| 2022-01-12 17:30:00 | AAPL | Stock | 175.33 | 175.39 | 175.3 | 175.35 | 9899.0 |
| 2022-01-12 18:00:00 | AAPL | Stock | 175.31 | 175.44 | 175.25 | 175.25 | 10840.0 |
| 2022-01-12 18:30:00 | AAPL | Stock | 175.26 | 175.3 | 175.15 | 175.2 | 22167.0 |
| 2022-01-12 19:00:00 | AAPL | Stock | 175.13 | 175.22 | 174.14 | 175.03 | 26262.0 |
| 2022-01-12 19:30:00 | AAPL | Stock | 175.07 | 175.2 | 175.07 | 175.1 | 27695.0 |
| 2022-01-12 04:00:00 | MSFT | Stock | 314.0 | 316.56 | 314.0 | 315.98 | 4745.0 |
| 2022-01-12 04:30:00 | MSFT | Stock | 316.06 | 316.4 | 315.91 | 316.4 | 2398.0 |
| 2022-01-12 05:00:00 | MSFT | Stock | 316.4 | 316.51 | 316.35 | 316.51 | 1526.0 |
| 2022-01-12 05:30:00 | MSFT | Stock | 316.4 | 316.58 | 316.31 | 316.58 | 735.0 |
| 2022-01-12 06:00:00 | MSFT | Stock | 316.7 | 316.7 | 316.56 | 316.65 | 670.0 |
| 2022-01-12 06:30:00 | MSFT | Stock | 316.55 | 316.56 | 316.31 | 316.31 | 3211.0 |
| 2022-01-12 07:00:00 | MSFT | Stock | 316.21 | 316.24 | 315.6 | 316.01 | 11303.0 |
| 2022-01-12 07:30:00 | MSFT | Stock | 316.07 | 316.5 | 315.98 | 316.0 | 11888.0 |
| 2022-01-12 08:00:00 | MSFT | Stock | 315.8499 | 316.81 | 315.6 | 316.77 | 27004.0 |
| 2022-01-12 08:30:00 | MSFT | Stock | 316.75 | 319.15 | 315.6 | 319.0 | 196829.0 |
| 2022-01-12 09:00:00 | MSFT | Stock | 319.0 | 320.51 | 318.0 | 319.79 | 126646.0 |
| 2022-01-12 09:30:00 | MSFT | Stock | 319.67 | 321.98 | 318.18 | 321.895 | 4603383.0 |
| 2022-01-12 10:00:00 | MSFT | Stock | 321.91 | 323.41 | 321.17 | 322.46 | 2616886.0 |
| 2022-01-12 10:30:00 | MSFT | Stock | 322.43 | 322.56 | 318.54 | 318.88 | 2424538.0 |
| 2022-01-12 11:00:00 | MSFT | Stock | 318.87 | 319.64 | 317.81 | 318.6 | 1562147.0 |
| 2022-01-12 11:30:00 | MSFT | Stock | 318.6 | 320.19 | 318.57 | 319.51 | 1086704.0 |
| 2022-01-12 12:00:00 | MSFT | Stock | 319.55 | 319.71 | 318.26 | 319.2311 | 689335.0 |
| 2022-01-12 12:30:00 | MSFT | Stock | 319.29 | 320.24 | 319.1371 | 319.82 | 818232.0 |
> showing 50 of 108,744 rows — these rows as CSV