PREVIEW / stock_30min / 2021-03-03
file: by_date/stock_30min/2021/2021-03-03.parquet size: 2.4 MB rows: 120,023 symbols: 2,856
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-03-03 04:00:00 | AAPL | Stock | 126.22 | 126.7 | 126.0 | 126.2 | 25678.0 |
| 2021-03-03 04:30:00 | AAPL | Stock | 126.15 | 126.33 | 126.0 | 126.12 | 16815.0 |
| 2021-03-03 05:00:00 | AAPL | Stock | 126.1 | 126.3 | 126.1 | 126.23 | 6687.0 |
| 2021-03-03 05:30:00 | AAPL | Stock | 126.0 | 126.02 | 125.6 | 126.0 | 11537.0 |
| 2021-03-03 06:00:00 | AAPL | Stock | 125.99 | 126.14 | 125.95 | 126.09 | 9327.0 |
| 2021-03-03 06:30:00 | AAPL | Stock | 126.1 | 126.19 | 125.97 | 126.18 | 4345.0 |
| 2021-03-03 07:00:00 | AAPL | Stock | 126.12 | 126.2 | 125.75 | 125.75 | 129485.0 |
| 2021-03-03 07:30:00 | AAPL | Stock | 125.71 | 125.79 | 125.53 | 125.65 | 112419.0 |
| 2021-03-03 08:00:00 | AAPL | Stock | 126.12 | 126.15 | 125.2 | 125.46 | 347981.0 |
| 2021-03-03 08:30:00 | AAPL | Stock | 125.48 | 125.48 | 124.5 | 124.63 | 504138.0 |
| 2021-03-03 09:00:00 | AAPL | Stock | 124.62 | 124.9 | 124.17 | 124.77 | 446026.0 |
| 2021-03-03 09:30:00 | AAPL | Stock | 124.77 | 125.71 | 123.75 | 124.0 | 12251350.0 |
| 2021-03-03 10:00:00 | AAPL | Stock | 124.0 | 124.17 | 123.1116 | 123.71 | 8579658.0 |
| 2021-03-03 10:30:00 | AAPL | Stock | 123.7 | 124.7 | 123.46 | 124.6324 | 7064023.0 |
| 2021-03-03 11:00:00 | AAPL | Stock | 124.63 | 124.785 | 124.18 | 124.7793 | 4408667.0 |
| 2021-03-03 11:30:00 | AAPL | Stock | 124.77 | 124.935 | 124.02 | 124.0593 | 4141845.0 |
| 2021-03-03 12:00:00 | AAPL | Stock | 124.06 | 124.4699 | 123.93 | 124.035 | 3700947.0 |
| 2021-03-03 12:30:00 | AAPL | Stock | 124.03 | 124.1399 | 123.45 | 123.47 | 4165138.0 |
| 2021-03-03 13:00:00 | AAPL | Stock | 123.47 | 124.17 | 123.35 | 123.8702 | 4154046.0 |
| 2021-03-03 13:30:00 | AAPL | Stock | 123.87 | 123.8702 | 122.93 | 123.14 | 5303011.0 |
| 2021-03-03 14:00:00 | AAPL | Stock | 123.145 | 123.21 | 122.16 | 122.25 | 6793481.0 |
| 2021-03-03 14:30:00 | AAPL | Stock | 122.25 | 122.93 | 121.84 | 122.81 | 6895705.0 |
| 2021-03-03 15:00:00 | AAPL | Stock | 122.81 | 122.975 | 122.12 | 122.485 | 5430169.0 |
| 2021-03-03 15:30:00 | AAPL | Stock | 122.49 | 122.97 | 122.0 | 122.06 | 10105506.0 |
| 2021-03-03 16:00:00 | AAPL | Stock | 122.06 | 123.3609 | 121.9 | 122.17 | 11006483.0 |
| 2021-03-03 16:30:00 | AAPL | Stock | 122.17 | 122.19 | 121.95 | 122.12 | 88167.0 |
| 2021-03-03 17:00:00 | AAPL | Stock | 122.14 | 122.27 | 122.1 | 122.2 | 57024.0 |
| 2021-03-03 17:30:00 | AAPL | Stock | 122.19 | 122.22 | 122.06 | 122.12 | 41801.0 |
| 2021-03-03 18:00:00 | AAPL | Stock | 122.08 | 122.16 | 121.5 | 121.68 | 158141.0 |
| 2021-03-03 18:30:00 | AAPL | Stock | 121.61 | 121.77 | 121.4 | 121.4 | 134905.0 |
| 2021-03-03 19:00:00 | AAPL | Stock | 121.46 | 121.65 | 121.25 | 121.5 | 122339.0 |
| 2021-03-03 19:30:00 | AAPL | Stock | 121.5 | 121.97 | 121.5 | 121.7 | 121573.0 |
| 2021-03-03 04:00:00 | MSFT | Stock | 235.45 | 235.87 | 235.22 | 235.3 | 3855.0 |
| 2021-03-03 04:30:00 | MSFT | Stock | 235.41 | 235.8 | 235.01 | 235.01 | 4091.0 |
| 2021-03-03 05:00:00 | MSFT | Stock | 234.89 | 235.28 | 234.89 | 235.27 | 1513.0 |
| 2021-03-03 05:30:00 | MSFT | Stock | 235.39 | 235.39 | 234.7 | 234.78 | 1628.0 |
| 2021-03-03 06:00:00 | MSFT | Stock | 235.1 | 235.1 | 235.01 | 235.01 | 341.0 |
| 2021-03-03 06:30:00 | MSFT | Stock | 235.36 | 235.48 | 235.36 | 235.48 | 423.0 |
| 2021-03-03 07:00:00 | MSFT | Stock | 235.5 | 235.5 | 234.48 | 234.51 | 12195.0 |
| 2021-03-03 07:30:00 | MSFT | Stock | 234.51 | 234.62 | 234.4 | 234.62 | 3305.0 |
| 2021-03-03 08:00:00 | MSFT | Stock | 235.5 | 235.5 | 233.286 | 234.35 | 20951.0 |
| 2021-03-03 08:30:00 | MSFT | Stock | 234.28 | 234.29 | 231.88 | 232.86 | 42145.0 |
| 2021-03-03 09:00:00 | MSFT | Stock | 232.73 | 232.9708 | 231.59 | 232.17 | 53492.0 |
| 2021-03-03 09:30:00 | MSFT | Stock | 232.17 | 233.5799 | 230.51 | 230.75 | 2962884.0 |
| 2021-03-03 10:00:00 | MSFT | Stock | 230.71 | 231.12 | 229.43 | 229.8602 | 2184132.0 |
| 2021-03-03 10:30:00 | MSFT | Stock | 229.86 | 230.99 | 229.56 | 230.77 | 1398391.0 |
| 2021-03-03 11:00:00 | MSFT | Stock | 230.755 | 231.54 | 230.73 | 231.46 | 1087137.0 |
| 2021-03-03 11:30:00 | MSFT | Stock | 231.46 | 231.56 | 230.52 | 230.66 | 788820.0 |
| 2021-03-03 12:00:00 | MSFT | Stock | 230.64 | 230.6618 | 229.76 | 229.89 | 1156455.0 |
| 2021-03-03 12:30:00 | MSFT | Stock | 229.88 | 229.99 | 229.3 | 229.3191 | 1073410.0 |
> showing 50 of 120,023 rows — these rows as CSV