PREVIEW / stock_30min / 2021-05-07
file: by_date/stock_30min/2021/2021-05-07.parquet size: 2.2 MB rows: 110,665 symbols: 2,997
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-05-07 04:00:00 | AAPL | Stock | 129.93 | 129.93 | 129.38 | 129.55 | 10709.0 |
| 2021-05-07 04:30:00 | AAPL | Stock | 129.64 | 129.73 | 129.6 | 129.71 | 8850.0 |
| 2021-05-07 05:00:00 | AAPL | Stock | 129.72 | 129.88 | 129.72 | 129.87 | 2128.0 |
| 2021-05-07 05:30:00 | AAPL | Stock | 129.88 | 129.9 | 129.76 | 129.76 | 3172.0 |
| 2021-05-07 06:00:00 | AAPL | Stock | 129.9 | 130.0 | 129.86 | 129.86 | 4968.0 |
| 2021-05-07 06:30:00 | AAPL | Stock | 129.88 | 130.05 | 129.88 | 129.96 | 10808.0 |
| 2021-05-07 07:00:00 | AAPL | Stock | 129.99 | 130.07 | 129.9 | 129.97 | 47736.0 |
| 2021-05-07 07:30:00 | AAPL | Stock | 129.97 | 130.05 | 129.91 | 129.96 | 37982.0 |
| 2021-05-07 08:00:00 | AAPL | Stock | 130.05 | 130.08 | 129.81 | 130.04 | 176118.0 |
| 2021-05-07 08:30:00 | AAPL | Stock | 130.05 | 132.0 | 129.93 | 131.29 | 1077269.0 |
| 2021-05-07 09:00:00 | AAPL | Stock | 131.25 | 131.6 | 130.82 | 130.84 | 465460.0 |
| 2021-05-07 09:30:00 | AAPL | Stock | 130.84 | 130.99 | 129.475 | 130.14 | 10538690.0 |
| 2021-05-07 10:00:00 | AAPL | Stock | 130.14 | 130.97 | 129.98 | 130.5913 | 7364389.0 |
| 2021-05-07 10:30:00 | AAPL | Stock | 130.595 | 130.87 | 130.34 | 130.56 | 4422837.0 |
| 2021-05-07 11:00:00 | AAPL | Stock | 130.56 | 131.13 | 130.47 | 131.0656 | 4634856.0 |
| 2021-05-07 11:30:00 | AAPL | Stock | 131.07 | 131.2582 | 130.91 | 131.12 | 3573058.0 |
| 2021-05-07 12:00:00 | AAPL | Stock | 131.1201 | 131.15 | 130.67 | 130.7242 | 3075340.0 |
| 2021-05-07 12:30:00 | AAPL | Stock | 130.72 | 130.75 | 130.38 | 130.5915 | 2927924.0 |
| 2021-05-07 13:00:00 | AAPL | Stock | 130.595 | 130.62 | 130.1301 | 130.15 | 3249682.0 |
| 2021-05-07 13:30:00 | AAPL | Stock | 130.15 | 130.36 | 130.0 | 130.01 | 2369929.0 |
| 2021-05-07 14:00:00 | AAPL | Stock | 130.0 | 130.26 | 129.85 | 130.25 | 2950075.0 |
| 2021-05-07 14:30:00 | AAPL | Stock | 130.25 | 130.37 | 129.9 | 130.3099 | 2485388.0 |
| 2021-05-07 15:00:00 | AAPL | Stock | 130.3 | 130.6 | 130.22 | 130.465 | 3003931.0 |
| 2021-05-07 15:30:00 | AAPL | Stock | 130.47 | 130.57 | 130.17 | 130.21 | 6024073.0 |
| 2021-05-07 16:00:00 | AAPL | Stock | 130.21 | 130.28 | 130.1 | 130.23 | 6404103.0 |
| 2021-05-07 16:30:00 | AAPL | Stock | 130.23 | 130.4 | 130.23 | 130.32 | 49541.0 |
| 2021-05-07 17:00:00 | AAPL | Stock | 130.28 | 130.3 | 130.2 | 130.24 | 24350.0 |
| 2021-05-07 17:30:00 | AAPL | Stock | 130.27 | 130.27 | 130.2 | 130.23 | 12812.0 |
| 2021-05-07 18:00:00 | AAPL | Stock | 130.21 | 130.25 | 130.21 | 130.22 | 4235.0 |
| 2021-05-07 18:30:00 | AAPL | Stock | 130.22 | 130.3 | 130.2 | 130.24 | 11445.0 |
| 2021-05-07 19:00:00 | AAPL | Stock | 130.22 | 130.25 | 130.2 | 130.25 | 9658.0 |
| 2021-05-07 19:30:00 | AAPL | Stock | 130.23 | 130.49 | 130.2 | 130.49 | 48071.0 |
| 2021-05-07 04:00:00 | MSFT | Stock | 249.5 | 250.0 | 249.49 | 250.0 | 1693.0 |
| 2021-05-07 04:30:00 | MSFT | Stock | 249.91 | 249.91 | 249.91 | 249.91 | 100.0 |
| 2021-05-07 05:00:00 | MSFT | Stock | 250.13 | 250.89 | 250.13 | 250.2 | 2839.0 |
| 2021-05-07 05:30:00 | MSFT | Stock | 250.1 | 250.1 | 250.07 | 250.07 | 281.0 |
| 2021-05-07 06:00:00 | MSFT | Stock | 250.08 | 250.29 | 250.08 | 250.28 | 4677.0 |
| 2021-05-07 06:30:00 | MSFT | Stock | 250.23 | 250.39 | 250.23 | 250.39 | 1291.0 |
| 2021-05-07 07:00:00 | MSFT | Stock | 250.41 | 250.45 | 250.15 | 250.25 | 11411.0 |
| 2021-05-07 07:30:00 | MSFT | Stock | 250.35 | 250.36 | 250.2 | 250.23 | 2907.0 |
| 2021-05-07 08:00:00 | MSFT | Stock | 250.39 | 250.49 | 249.8982 | 250.32 | 24341.0 |
| 2021-05-07 08:30:00 | MSFT | Stock | 250.5 | 254.75 | 250.31 | 252.8 | 241736.0 |
| 2021-05-07 09:00:00 | MSFT | Stock | 252.75 | 253.0 | 251.77 | 252.12 | 75784.0 |
| 2021-05-07 09:30:00 | MSFT | Stock | 252.15 | 253.17 | 251.17 | 252.49 | 2642970.0 |
| 2021-05-07 10:00:00 | MSFT | Stock | 252.47 | 253.83 | 251.89 | 252.96 | 1881880.0 |
| 2021-05-07 10:30:00 | MSFT | Stock | 252.97 | 253.55 | 252.86 | 253.36 | 880406.0 |
| 2021-05-07 11:00:00 | MSFT | Stock | 253.35 | 254.17 | 253.22 | 254.11 | 1156518.0 |
| 2021-05-07 11:30:00 | MSFT | Stock | 254.12 | 254.3 | 253.71 | 254.23 | 811409.0 |
| 2021-05-07 12:00:00 | MSFT | Stock | 254.24 | 254.27 | 253.19 | 253.19 | 795454.0 |
| 2021-05-07 12:30:00 | MSFT | Stock | 253.2 | 253.2 | 252.66 | 252.975 | 812021.0 |
> showing 50 of 110,665 rows — these rows as CSV