PREVIEW / stock_30min / 2021-12-03
file: by_date/stock_30min/2021/2021-12-03.parquet size: 2.3 MB rows: 112,138 symbols: 2,676
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-03 04:00:00 | AAPL | Stock | 162.53 | 163.06 | 162.51 | 162.92 | 13125.0 |
| 2021-12-03 04:30:00 | AAPL | Stock | 162.95 | 162.95 | 162.57 | 162.73 | 2580.0 |
| 2021-12-03 05:00:00 | AAPL | Stock | 162.79 | 162.94 | 162.0 | 162.7 | 16790.0 |
| 2021-12-03 05:30:00 | AAPL | Stock | 162.8 | 162.86 | 162.38 | 162.6 | 3791.0 |
| 2021-12-03 06:00:00 | AAPL | Stock | 162.75 | 162.98 | 162.75 | 162.98 | 13690.0 |
| 2021-12-03 06:30:00 | AAPL | Stock | 162.88 | 163.18 | 162.88 | 163.15 | 8402.0 |
| 2021-12-03 07:00:00 | AAPL | Stock | 163.17 | 163.6 | 163.06 | 163.45 | 68568.0 |
| 2021-12-03 07:30:00 | AAPL | Stock | 163.44 | 163.79 | 163.35 | 163.76 | 55774.0 |
| 2021-12-03 08:00:00 | AAPL | Stock | 163.17 | 164.16 | 163.12 | 164.01 | 290324.0 |
| 2021-12-03 08:30:00 | AAPL | Stock | 164.14 | 165.4 | 163.8 | 163.9 | 448849.0 |
| 2021-12-03 09:00:00 | AAPL | Stock | 163.86 | 164.59 | 163.5 | 164.04 | 269333.0 |
| 2021-12-03 09:30:00 | AAPL | Stock | 164.01 | 164.96 | 162.77 | 163.3 | 12000979.0 |
| 2021-12-03 10:00:00 | AAPL | Stock | 163.32 | 163.88 | 161.8 | 163.685 | 9800919.0 |
| 2021-12-03 10:30:00 | AAPL | Stock | 163.67 | 163.73 | 162.27 | 162.803 | 7155209.0 |
| 2021-12-03 11:00:00 | AAPL | Stock | 162.81 | 163.27 | 161.6 | 162.43 | 6957318.0 |
| 2021-12-03 11:30:00 | AAPL | Stock | 162.425 | 162.6 | 160.795 | 161.025 | 7676870.0 |
| 2021-12-03 12:00:00 | AAPL | Stock | 161.01 | 161.515 | 160.51 | 161.44 | 5882590.0 |
| 2021-12-03 12:30:00 | AAPL | Stock | 161.44 | 162.41 | 161.01 | 161.59 | 4746092.0 |
| 2021-12-03 13:00:00 | AAPL | Stock | 161.57 | 161.58 | 160.75 | 160.85 | 4064585.0 |
| 2021-12-03 13:30:00 | AAPL | Stock | 160.84 | 160.85 | 159.77 | 159.92 | 6166754.0 |
| 2021-12-03 14:00:00 | AAPL | Stock | 159.92 | 160.72 | 159.75 | 160.48 | 4980850.0 |
| 2021-12-03 14:30:00 | AAPL | Stock | 160.48 | 160.6 | 159.895 | 160.075 | 3845142.0 |
| 2021-12-03 15:00:00 | AAPL | Stock | 160.07 | 160.68 | 159.72 | 160.38 | 5443948.0 |
| 2021-12-03 15:30:00 | AAPL | Stock | 160.37 | 162.18 | 160.25 | 161.84 | 10145086.0 |
| 2021-12-03 16:00:00 | AAPL | Stock | 161.84 | 162.21 | 161.2 | 161.35 | 13179601.0 |
| 2021-12-03 16:30:00 | AAPL | Stock | 161.32 | 161.45 | 161.2 | 161.3 | 33718.0 |
| 2021-12-03 17:00:00 | AAPL | Stock | 161.3 | 161.84 | 161.2 | 161.39 | 56761.0 |
| 2021-12-03 17:30:00 | AAPL | Stock | 161.35 | 161.55 | 161.35 | 161.43 | 38323.0 |
| 2021-12-03 18:00:00 | AAPL | Stock | 161.55 | 161.55 | 161.4 | 161.54 | 21742.0 |
| 2021-12-03 18:30:00 | AAPL | Stock | 161.56 | 161.56 | 161.37 | 161.37 | 14858.0 |
| 2021-12-03 19:00:00 | AAPL | Stock | 161.38 | 161.49 | 161.32 | 161.49 | 12144.0 |
| 2021-12-03 19:30:00 | AAPL | Stock | 161.49 | 161.56 | 161.2 | 161.25 | 33121.0 |
| 2021-12-03 04:00:00 | MSFT | Stock | 328.75 | 329.24 | 328.4 | 329.24 | 1858.0 |
| 2021-12-03 04:30:00 | MSFT | Stock | 328.87 | 328.87 | 328.2 | 328.33 | 3302.0 |
| 2021-12-03 05:00:00 | MSFT | Stock | 328.71 | 328.75 | 327.07 | 327.98 | 6186.0 |
| 2021-12-03 05:30:00 | MSFT | Stock | 328.07 | 328.13 | 327.96 | 327.96 | 1978.0 |
| 2021-12-03 06:00:00 | MSFT | Stock | 328.21 | 328.85 | 328.15 | 328.85 | 2798.0 |
| 2021-12-03 06:30:00 | MSFT | Stock | 328.5 | 329.0 | 328.5 | 329.0 | 1719.0 |
| 2021-12-03 07:00:00 | MSFT | Stock | 329.48 | 329.8 | 329.48 | 329.8 | 11736.0 |
| 2021-12-03 07:30:00 | MSFT | Stock | 329.86 | 330.49 | 329.85 | 330.49 | 5741.0 |
| 2021-12-03 08:00:00 | MSFT | Stock | 329.5162 | 331.5 | 329.5 | 331.45 | 21077.0 |
| 2021-12-03 08:30:00 | MSFT | Stock | 331.35 | 333.56 | 330.7 | 331.8 | 60169.0 |
| 2021-12-03 09:00:00 | MSFT | Stock | 331.31 | 332.14 | 330.85 | 331.25 | 31642.0 |
| 2021-12-03 09:30:00 | MSFT | Stock | 331.99 | 332.7 | 327.1 | 327.4 | 2563427.0 |
| 2021-12-03 10:00:00 | MSFT | Stock | 327.46 | 327.68 | 324.25 | 325.67 | 2225227.0 |
| 2021-12-03 10:30:00 | MSFT | Stock | 325.65 | 325.84 | 321.23 | 321.95 | 2375960.0 |
| 2021-12-03 11:00:00 | MSFT | Stock | 321.93 | 323.36 | 320.78 | 323.085 | 1790450.0 |
| 2021-12-03 11:30:00 | MSFT | Stock | 323.09 | 323.3 | 319.51 | 319.96 | 1677926.0 |
| 2021-12-03 12:00:00 | MSFT | Stock | 320.0 | 321.09 | 319.43 | 320.6101 | 1280969.0 |
| 2021-12-03 12:30:00 | MSFT | Stock | 320.65 | 321.36 | 319.43 | 320.2362 | 1093657.0 |
> showing 50 of 112,138 rows — these rows as CSV