PREVIEW / stock_30min / 2021-12-16
file: by_date/stock_30min/2021/2021-12-16.parquet size: 2.3 MB rows: 112,322 symbols: 2,642
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-12-16 04:00:00 | AAPL | Stock | 180.55 | 180.68 | 180.15 | 180.19 | 36984.0 |
| 2021-12-16 04:30:00 | AAPL | Stock | 180.23 | 180.68 | 180.14 | 180.57 | 18954.0 |
| 2021-12-16 05:00:00 | AAPL | Stock | 180.59 | 180.92 | 180.52 | 180.57 | 13129.0 |
| 2021-12-16 05:30:00 | AAPL | Stock | 180.57 | 180.87 | 180.57 | 180.84 | 12912.0 |
| 2021-12-16 06:00:00 | AAPL | Stock | 180.83 | 180.94 | 180.6 | 180.94 | 48471.0 |
| 2021-12-16 06:30:00 | AAPL | Stock | 180.8 | 181.25 | 180.6 | 180.7 | 50794.0 |
| 2021-12-16 07:00:00 | AAPL | Stock | 180.64 | 180.9 | 180.4 | 180.5 | 177976.0 |
| 2021-12-16 07:30:00 | AAPL | Stock | 180.48 | 180.58 | 180.01 | 180.18 | 126751.0 |
| 2021-12-16 08:00:00 | AAPL | Stock | 180.7 | 180.84 | 178.852 | 180.13 | 580752.0 |
| 2021-12-16 08:30:00 | AAPL | Stock | 180.14 | 180.2 | 179.2 | 179.73 | 395689.0 |
| 2021-12-16 09:00:00 | AAPL | Stock | 179.74 | 179.75 | 178.8 | 179.3 | 411969.0 |
| 2021-12-16 09:30:00 | AAPL | Stock | 179.28 | 181.14 | 176.5 | 176.52 | 17486660.0 |
| 2021-12-16 10:00:00 | AAPL | Stock | 176.53 | 176.58 | 174.53 | 175.94 | 16471851.0 |
| 2021-12-16 10:30:00 | AAPL | Stock | 175.935 | 176.57 | 175.5241 | 175.7826 | 7432800.0 |
| 2021-12-16 11:00:00 | AAPL | Stock | 175.78 | 175.79 | 174.24 | 175.15 | 7617085.0 |
| 2021-12-16 11:30:00 | AAPL | Stock | 175.145 | 175.47 | 174.47 | 174.79 | 4702577.0 |
| 2021-12-16 12:00:00 | AAPL | Stock | 174.78 | 175.32 | 174.52 | 174.5576 | 6138767.0 |
| 2021-12-16 12:30:00 | AAPL | Stock | 174.55 | 174.83 | 173.12 | 173.1552 | 7052861.0 |
| 2021-12-16 13:00:00 | AAPL | Stock | 173.15 | 174.145 | 173.15 | 174.0389 | 4762496.0 |
| 2021-12-16 13:30:00 | AAPL | Stock | 174.0329 | 174.44 | 173.59 | 173.595 | 4352904.0 |
| 2021-12-16 14:00:00 | AAPL | Stock | 173.6 | 173.79 | 171.58 | 172.08 | 8999932.0 |
| 2021-12-16 14:30:00 | AAPL | Stock | 172.09 | 172.7594 | 170.8 | 171.5909 | 9262745.0 |
| 2021-12-16 15:00:00 | AAPL | Stock | 171.59 | 172.18 | 170.75 | 171.94 | 9847170.0 |
| 2021-12-16 15:30:00 | AAPL | Stock | 171.945 | 173.33 | 171.905 | 172.25 | 16417128.0 |
| 2021-12-16 16:00:00 | AAPL | Stock | 172.32 | 172.57 | 171.7 | 172.33 | 10336944.0 |
| 2021-12-16 16:30:00 | AAPL | Stock | 172.26 | 172.4 | 172.25 | 172.34 | 82032.0 |
| 2021-12-16 17:00:00 | AAPL | Stock | 172.35 | 172.3799 | 171.48 | 171.5 | 125959.0 |
| 2021-12-16 17:30:00 | AAPL | Stock | 171.52 | 171.86 | 171.5 | 171.62 | 71022.0 |
| 2021-12-16 18:00:00 | AAPL | Stock | 171.64 | 171.88 | 171.02 | 171.05 | 76524.0 |
| 2021-12-16 18:30:00 | AAPL | Stock | 171.05 | 171.4 | 171.02 | 171.3 | 42389.0 |
| 2021-12-16 19:00:00 | AAPL | Stock | 171.3 | 171.8 | 171.25 | 171.66 | 42437.0 |
| 2021-12-16 19:30:00 | AAPL | Stock | 171.69 | 172.2599 | 171.69 | 172.12 | 52421.0 |
| 2021-12-16 04:00:00 | MSFT | Stock | 336.62 | 336.88 | 336.0 | 336.0 | 8204.0 |
| 2021-12-16 04:30:00 | MSFT | Stock | 336.0 | 336.35 | 336.0 | 336.2 | 2003.0 |
| 2021-12-16 05:00:00 | MSFT | Stock | 336.0 | 336.5 | 336.0 | 336.3 | 2320.0 |
| 2021-12-16 05:30:00 | MSFT | Stock | 336.48 | 336.85 | 336.4 | 336.85 | 3643.0 |
| 2021-12-16 06:00:00 | MSFT | Stock | 336.99 | 337.87 | 336.7 | 337.87 | 6555.0 |
| 2021-12-16 06:30:00 | MSFT | Stock | 337.8 | 337.89 | 337.4 | 337.4 | 5922.0 |
| 2021-12-16 07:00:00 | MSFT | Stock | 337.03 | 337.2 | 336.28 | 336.28 | 29034.0 |
| 2021-12-16 07:30:00 | MSFT | Stock | 336.35 | 336.6 | 336.21 | 336.4 | 15615.0 |
| 2021-12-16 08:00:00 | MSFT | Stock | 337.12 | 337.2126 | 335.23 | 336.0 | 46661.0 |
| 2021-12-16 08:30:00 | MSFT | Stock | 336.0 | 336.29 | 334.64 | 335.5 | 30369.0 |
| 2021-12-16 09:00:00 | MSFT | Stock | 335.17 | 336.07 | 334.65 | 335.63 | 51718.0 |
| 2021-12-16 09:30:00 | MSFT | Stock | 335.71 | 336.76 | 332.04 | 332.16 | 2928513.0 |
| 2021-12-16 10:00:00 | MSFT | Stock | 332.13 | 332.4 | 330.57 | 332.3405 | 1541992.0 |
| 2021-12-16 10:30:00 | MSFT | Stock | 332.34 | 332.8 | 331.28 | 331.6019 | 1022529.0 |
| 2021-12-16 11:00:00 | MSFT | Stock | 331.62 | 331.75 | 328.47 | 328.825 | 1422774.0 |
| 2021-12-16 11:30:00 | MSFT | Stock | 328.84 | 328.97 | 327.69 | 327.85 | 1322649.0 |
| 2021-12-16 12:00:00 | MSFT | Stock | 327.83 | 328.27 | 325.87 | 326.11 | 1475050.0 |
| 2021-12-16 12:30:00 | MSFT | Stock | 326.11 | 327.24 | 325.91 | 325.96 | 1057624.0 |
> showing 50 of 112,322 rows — these rows as CSV