PREVIEW / stock_30min / 2021-09-22
file: by_date/stock_30min/2021/2021-09-22.parquet size: 2.2 MB rows: 108,192 symbols: 2,700
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-09-22 04:00:00 | AAPL | Stock | 143.71 | 144.14 | 143.71 | 144.11 | 7089.0 |
| 2021-09-22 04:30:00 | AAPL | Stock | 144.08 | 144.27 | 144.04 | 144.22 | 5815.0 |
| 2021-09-22 05:00:00 | AAPL | Stock | 144.19 | 144.19 | 144.19 | 144.19 | 100.0 |
| 2021-09-22 05:30:00 | AAPL | Stock | 144.1 | 144.15 | 144.0 | 144.1 | 7112.0 |
| 2021-09-22 06:00:00 | AAPL | Stock | 144.11 | 144.21 | 144.11 | 144.17 | 4626.0 |
| 2021-09-22 06:30:00 | AAPL | Stock | 144.18 | 144.22 | 144.13 | 144.16 | 6761.0 |
| 2021-09-22 07:00:00 | AAPL | Stock | 144.13 | 144.17 | 143.89 | 143.91 | 99745.0 |
| 2021-09-22 07:30:00 | AAPL | Stock | 143.87 | 143.95 | 143.78 | 143.83 | 50631.0 |
| 2021-09-22 08:00:00 | AAPL | Stock | 144.0499 | 144.12 | 143.78 | 144.09 | 146175.0 |
| 2021-09-22 08:30:00 | AAPL | Stock | 144.09 | 144.16 | 144.02 | 144.05 | 72225.0 |
| 2021-09-22 09:00:00 | AAPL | Stock | 144.07 | 144.5 | 144.02 | 144.4 | 332025.0 |
| 2021-09-22 09:30:00 | AAPL | Stock | 144.4 | 144.89 | 143.7001 | 144.585 | 7433338.0 |
| 2021-09-22 10:00:00 | AAPL | Stock | 144.59 | 145.29 | 144.59 | 145.1314 | 5741360.0 |
| 2021-09-22 10:30:00 | AAPL | Stock | 145.14 | 145.2483 | 144.88 | 144.905 | 3547967.0 |
| 2021-09-22 11:00:00 | AAPL | Stock | 144.91 | 145.29 | 144.91 | 145.09 | 3124039.0 |
| 2021-09-22 11:30:00 | AAPL | Stock | 145.08 | 145.89 | 145.08 | 145.53 | 4085841.0 |
| 2021-09-22 12:00:00 | AAPL | Stock | 145.52 | 145.64 | 145.2233 | 145.5 | 2034950.0 |
| 2021-09-22 12:30:00 | AAPL | Stock | 145.5084 | 145.695 | 145.19 | 145.2341 | 2380653.0 |
| 2021-09-22 13:00:00 | AAPL | Stock | 145.2301 | 145.32 | 145.04 | 145.275 | 2291569.0 |
| 2021-09-22 13:30:00 | AAPL | Stock | 145.27 | 145.39 | 145.03 | 145.3 | 2047665.0 |
| 2021-09-22 14:00:00 | AAPL | Stock | 145.0 | 146.4294 | 144.75 | 146.085 | 7268181.0 |
| 2021-09-22 14:30:00 | AAPL | Stock | 146.08 | 146.1599 | 145.06 | 145.41 | 5605746.0 |
| 2021-09-22 15:00:00 | AAPL | Stock | 145.41 | 146.43 | 145.22 | 146.17 | 5546305.0 |
| 2021-09-22 15:30:00 | AAPL | Stock | 146.17 | 146.25 | 145.7 | 145.83 | 7876807.0 |
| 2021-09-22 16:00:00 | AAPL | Stock | 145.85 | 146.03 | 145.8201 | 145.97 | 7639599.0 |
| 2021-09-22 16:30:00 | AAPL | Stock | 145.96 | 145.96 | 145.85 | 145.89 | 118589.0 |
| 2021-09-22 17:00:00 | AAPL | Stock | 145.9 | 145.92 | 145.86 | 145.87 | 11802.0 |
| 2021-09-22 17:30:00 | AAPL | Stock | 145.9099 | 146.0 | 145.9099 | 145.98 | 8833.0 |
| 2021-09-22 18:00:00 | AAPL | Stock | 145.98 | 146.1 | 145.95 | 146.09 | 44516.0 |
| 2021-09-22 18:30:00 | AAPL | Stock | 146.04 | 146.12 | 146.0 | 146.11 | 32810.0 |
| 2021-09-22 19:00:00 | AAPL | Stock | 146.01 | 146.15 | 146.01 | 146.13 | 15571.0 |
| 2021-09-22 19:30:00 | AAPL | Stock | 146.15 | 146.25 | 146.11 | 146.25 | 41485.0 |
| 2021-09-22 04:00:00 | MSFT | Stock | 295.1 | 295.87 | 295.1 | 295.75 | 1309.0 |
| 2021-09-22 04:30:00 | MSFT | Stock | 295.86 | 295.86 | 295.75 | 295.75 | 549.0 |
| 2021-09-22 05:30:00 | MSFT | Stock | 295.94 | 295.94 | 295.67 | 295.7 | 499.0 |
| 2021-09-22 06:30:00 | MSFT | Stock | 295.89 | 295.9 | 295.89 | 295.9 | 847.0 |
| 2021-09-22 07:00:00 | MSFT | Stock | 295.66 | 295.73 | 295.3 | 295.3 | 8808.0 |
| 2021-09-22 07:30:00 | MSFT | Stock | 295.29 | 295.49 | 295.29 | 295.49 | 2529.0 |
| 2021-09-22 08:00:00 | MSFT | Stock | 295.6999 | 295.88 | 295.3 | 295.88 | 25368.0 |
| 2021-09-22 08:30:00 | MSFT | Stock | 295.85 | 296.3699 | 295.85 | 296.0 | 15965.0 |
| 2021-09-22 09:00:00 | MSFT | Stock | 296.05 | 297.0 | 296.05 | 296.87 | 53544.0 |
| 2021-09-22 09:30:00 | MSFT | Stock | 296.72 | 296.915 | 294.51 | 296.2 | 2020991.0 |
| 2021-09-22 10:00:00 | MSFT | Stock | 296.21 | 299.11 | 296.1 | 298.865 | 1931953.0 |
| 2021-09-22 10:30:00 | MSFT | Stock | 298.88 | 299.61 | 298.39 | 298.82 | 1464819.0 |
| 2021-09-22 11:00:00 | MSFT | Stock | 298.83 | 299.12 | 298.3777 | 298.46 | 841137.0 |
| 2021-09-22 11:30:00 | MSFT | Stock | 298.46 | 299.93 | 298.45 | 299.03 | 912144.0 |
| 2021-09-22 12:00:00 | MSFT | Stock | 299.02 | 299.06 | 298.45 | 298.675 | 651654.0 |
| 2021-09-22 12:30:00 | MSFT | Stock | 298.67 | 298.85 | 298.1 | 298.23 | 519703.0 |
| 2021-09-22 13:00:00 | MSFT | Stock | 298.225 | 298.24 | 297.5888 | 297.99 | 497260.0 |
| 2021-09-22 13:30:00 | MSFT | Stock | 297.99 | 298.09 | 297.03 | 297.5 | 618921.0 |
> showing 50 of 108,192 rows — these rows as CSV