PREVIEW / stock_30min / 2021-02-17
file: by_date/stock_30min/2021/2021-02-17.parquet size: 2.4 MB rows: 122,274 symbols: 2,822
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-02-17 04:00:00 | AAPL | Stock | 133.0 | 133.0 | 132.71 | 132.77 | 21410.0 |
| 2021-02-17 04:30:00 | AAPL | Stock | 132.78 | 132.8 | 132.51 | 132.58 | 6564.0 |
| 2021-02-17 05:00:00 | AAPL | Stock | 132.55 | 132.6 | 132.5 | 132.5 | 8380.0 |
| 2021-02-17 05:30:00 | AAPL | Stock | 132.66 | 132.67 | 132.3 | 132.45 | 5680.0 |
| 2021-02-17 06:00:00 | AAPL | Stock | 132.5 | 132.66 | 132.5 | 132.6 | 5954.0 |
| 2021-02-17 06:30:00 | AAPL | Stock | 132.47 | 132.66 | 132.37 | 132.52 | 5363.0 |
| 2021-02-17 07:00:00 | AAPL | Stock | 132.63 | 132.67 | 132.13 | 132.3 | 131539.0 |
| 2021-02-17 07:30:00 | AAPL | Stock | 132.29 | 132.42 | 132.1 | 132.34 | 207081.0 |
| 2021-02-17 08:00:00 | AAPL | Stock | 132.3 | 132.65 | 131.98 | 131.98 | 366318.0 |
| 2021-02-17 08:30:00 | AAPL | Stock | 132.0 | 133.19 | 131.33 | 131.64 | 431313.0 |
| 2021-02-17 09:00:00 | AAPL | Stock | 131.64 | 133.256 | 130.93 | 131.23 | 604619.0 |
| 2021-02-17 09:30:00 | AAPL | Stock | 131.23 | 132.22 | 130.81 | 130.829 | 14124858.0 |
| 2021-02-17 10:00:00 | AAPL | Stock | 130.83 | 131.038 | 129.89 | 130.25 | 12299292.0 |
| 2021-02-17 10:30:00 | AAPL | Stock | 130.24 | 130.941 | 129.94 | 130.879 | 7041394.0 |
| 2021-02-17 11:00:00 | AAPL | Stock | 130.87 | 130.99 | 129.47 | 129.715 | 8344525.0 |
| 2021-02-17 11:30:00 | AAPL | Stock | 129.72 | 130.26 | 129.6 | 130.25 | 5769695.0 |
| 2021-02-17 12:00:00 | AAPL | Stock | 130.25 | 130.36 | 129.69 | 129.965 | 4433089.0 |
| 2021-02-17 12:30:00 | AAPL | Stock | 129.965 | 130.42 | 129.945 | 130.385 | 3051495.0 |
| 2021-02-17 13:00:00 | AAPL | Stock | 130.381 | 130.55 | 130.17 | 130.489 | 2992805.0 |
| 2021-02-17 13:30:00 | AAPL | Stock | 130.49 | 130.66 | 130.315 | 130.51 | 2439270.0 |
| 2021-02-17 14:00:00 | AAPL | Stock | 130.51 | 130.74 | 130.3 | 130.375 | 2692862.0 |
| 2021-02-17 14:30:00 | AAPL | Stock | 130.37 | 130.72 | 130.25 | 130.345 | 2609371.0 |
| 2021-02-17 15:00:00 | AAPL | Stock | 130.35 | 130.84 | 130.26 | 130.69 | 3687810.0 |
| 2021-02-17 15:30:00 | AAPL | Stock | 130.68 | 130.99 | 130.675 | 130.84 | 5998223.0 |
| 2021-02-17 16:00:00 | AAPL | Stock | 130.84 | 130.97 | 130.7 | 130.81 | 4474038.0 |
| 2021-02-17 16:30:00 | AAPL | Stock | 130.81 | 131.0 | 130.78 | 130.83 | 97711.0 |
| 2021-02-17 17:00:00 | AAPL | Stock | 130.81 | 130.85 | 130.73 | 130.83 | 37793.0 |
| 2021-02-17 17:30:00 | AAPL | Stock | 130.83 | 130.95 | 130.75 | 130.84 | 29540.0 |
| 2021-02-17 18:00:00 | AAPL | Stock | 130.83 | 130.86 | 130.75 | 130.77 | 25066.0 |
| 2021-02-17 18:30:00 | AAPL | Stock | 130.75 | 130.81 | 130.7 | 130.79 | 36633.0 |
| 2021-02-17 19:00:00 | AAPL | Stock | 130.77 | 130.89 | 130.75 | 130.84 | 31167.0 |
| 2021-02-17 19:30:00 | AAPL | Stock | 130.85 | 130.89 | 130.8 | 130.88 | 33990.0 |
| 2021-02-17 04:30:00 | MSFT | Stock | 243.22 | 243.22 | 243.2 | 243.2 | 1097.0 |
| 2021-02-17 05:30:00 | MSFT | Stock | 243.13 | 243.21 | 243.13 | 243.21 | 819.0 |
| 2021-02-17 06:00:00 | MSFT | Stock | 243.12 | 243.12 | 243.01 | 243.01 | 695.0 |
| 2021-02-17 06:30:00 | MSFT | Stock | 243.1 | 243.13 | 243.0 | 243.13 | 987.0 |
| 2021-02-17 07:00:00 | MSFT | Stock | 243.0 | 243.25 | 242.75 | 242.77 | 5542.0 |
| 2021-02-17 07:30:00 | MSFT | Stock | 242.67 | 243.2 | 242.66 | 243.0 | 10738.0 |
| 2021-02-17 08:00:00 | MSFT | Stock | 242.75 | 243.14 | 242.28 | 242.59 | 13127.0 |
| 2021-02-17 08:30:00 | MSFT | Stock | 242.59 | 242.9 | 241.69 | 242.06 | 34453.0 |
| 2021-02-17 09:00:00 | MSFT | Stock | 242.1 | 243.261 | 240.65 | 241.11 | 53408.0 |
| 2021-02-17 09:30:00 | MSFT | Stock | 241.32 | 242.8 | 240.94 | 242.25 | 2215665.0 |
| 2021-02-17 10:00:00 | MSFT | Stock | 242.29 | 242.528 | 241.081 | 241.44 | 897954.0 |
| 2021-02-17 10:30:00 | MSFT | Stock | 241.44 | 242.92 | 241.16 | 242.65 | 878340.0 |
| 2021-02-17 11:00:00 | MSFT | Stock | 242.63 | 242.91 | 241.48 | 241.76 | 635941.0 |
| 2021-02-17 11:30:00 | MSFT | Stock | 241.73 | 242.2 | 241.31 | 242.09 | 638032.0 |
| 2021-02-17 12:00:00 | MSFT | Stock | 242.08 | 242.46 | 242.02 | 242.41 | 447252.0 |
| 2021-02-17 12:30:00 | MSFT | Stock | 242.41 | 242.88 | 242.33 | 242.72 | 419590.0 |
| 2021-02-17 13:00:00 | MSFT | Stock | 242.735 | 243.38 | 242.68 | 243.29 | 538121.0 |
| 2021-02-17 13:30:00 | MSFT | Stock | 243.31 | 243.4 | 242.94 | 243.15 | 466881.0 |
> showing 50 of 122,274 rows — these rows as CSV