PREVIEW / stock_30min / 2022-03-16
file: by_date/stock_30min/2022/2022-03-16.parquet size: 2.2 MB rows: 112,250 symbols: 2,524
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-16 04:00:00 | AAPL | Stock | 156.7 | 157.96 | 156.23 | 157.96 | 42435.0 |
| 2022-03-16 04:30:00 | AAPL | Stock | 157.9 | 158.38 | 157.76 | 158.09 | 72643.0 |
| 2022-03-16 05:00:00 | AAPL | Stock | 158.11 | 158.2 | 158.02 | 158.15 | 16102.0 |
| 2022-03-16 05:30:00 | AAPL | Stock | 158.1 | 158.21 | 157.75 | 157.8 | 9144.0 |
| 2022-03-16 06:00:00 | AAPL | Stock | 157.79 | 158.26 | 157.61 | 157.9 | 22466.0 |
| 2022-03-16 06:30:00 | AAPL | Stock | 157.9 | 158.35 | 157.72 | 158.0 | 47063.0 |
| 2022-03-16 07:00:00 | AAPL | Stock | 158.11 | 158.17 | 157.4 | 158.07 | 144205.0 |
| 2022-03-16 07:30:00 | AAPL | Stock | 158.06 | 158.34 | 158.0 | 158.29 | 92506.0 |
| 2022-03-16 08:00:00 | AAPL | Stock | 157.6501 | 158.55 | 155.78 | 158.01 | 518609.0 |
| 2022-03-16 08:30:00 | AAPL | Stock | 158.0 | 158.1 | 157.55 | 157.63 | 356486.0 |
| 2022-03-16 09:00:00 | AAPL | Stock | 157.62 | 157.73 | 157.0 | 157.07 | 319213.0 |
| 2022-03-16 09:30:00 | AAPL | Stock | 157.08 | 157.51 | 155.53 | 157.365 | 10278448.0 |
| 2022-03-16 10:00:00 | AAPL | Stock | 157.37 | 158.02 | 156.55 | 157.81 | 6639187.0 |
| 2022-03-16 10:30:00 | AAPL | Stock | 157.83 | 158.64 | 157.71 | 158.42 | 6001319.0 |
| 2022-03-16 11:00:00 | AAPL | Stock | 158.42 | 158.49 | 157.7 | 157.9791 | 4060140.0 |
| 2022-03-16 11:30:00 | AAPL | Stock | 157.98 | 158.18 | 157.635 | 158.0869 | 2801421.0 |
| 2022-03-16 12:00:00 | AAPL | Stock | 158.09 | 158.3 | 157.7 | 158.04 | 2768346.0 |
| 2022-03-16 12:30:00 | AAPL | Stock | 158.0546 | 158.13 | 157.21 | 157.305 | 3078088.0 |
| 2022-03-16 13:00:00 | AAPL | Stock | 157.305 | 157.41 | 156.53 | 156.79 | 3109955.0 |
| 2022-03-16 13:30:00 | AAPL | Stock | 156.7816 | 157.48 | 156.78 | 157.3504 | 2916328.0 |
| 2022-03-16 14:00:00 | AAPL | Stock | 157.33 | 157.45 | 155.1329 | 155.22 | 7418213.0 |
| 2022-03-16 14:30:00 | AAPL | Stock | 155.21 | 157.56 | 154.46 | 157.11 | 7643513.0 |
| 2022-03-16 15:00:00 | AAPL | Stock | 157.12 | 158.52 | 156.75 | 158.326 | 6100678.0 |
| 2022-03-16 15:30:00 | AAPL | Stock | 158.33 | 160.0 | 157.78 | 159.59 | 9782808.0 |
| 2022-03-16 16:00:00 | AAPL | Stock | 159.49 | 159.8 | 159.2 | 159.72 | 11796940.0 |
| 2022-03-16 16:30:00 | AAPL | Stock | 159.74 | 160.2 | 159.59 | 159.78 | 362980.0 |
| 2022-03-16 17:00:00 | AAPL | Stock | 159.74 | 159.78 | 159.42 | 159.69 | 85117.0 |
| 2022-03-16 17:30:00 | AAPL | Stock | 159.67 | 159.7 | 159.37 | 159.57 | 43198.0 |
| 2022-03-16 18:00:00 | AAPL | Stock | 159.58 | 159.6 | 159.19 | 159.2 | 49634.0 |
| 2022-03-16 18:30:00 | AAPL | Stock | 159.27 | 159.31 | 159.14 | 159.18 | 28467.0 |
| 2022-03-16 19:00:00 | AAPL | Stock | 159.18 | 159.39 | 159.05 | 159.15 | 22344.0 |
| 2022-03-16 19:30:00 | AAPL | Stock | 159.16 | 159.38 | 159.11 | 159.25 | 37176.0 |
| 2022-03-16 04:00:00 | MSFT | Stock | 290.72 | 292.0 | 290.1 | 292.0 | 9036.0 |
| 2022-03-16 04:30:00 | MSFT | Stock | 291.85 | 292.0 | 291.22 | 291.5 | 5065.0 |
| 2022-03-16 05:00:00 | MSFT | Stock | 292.0 | 292.5 | 292.0 | 292.5 | 1668.0 |
| 2022-03-16 05:30:00 | MSFT | Stock | 292.55 | 292.69 | 291.89 | 292.11 | 2949.0 |
| 2022-03-16 06:00:00 | MSFT | Stock | 292.14 | 292.45 | 291.55 | 292.33 | 8821.0 |
| 2022-03-16 06:30:00 | MSFT | Stock | 292.29 | 292.29 | 291.45 | 292.25 | 6319.0 |
| 2022-03-16 07:00:00 | MSFT | Stock | 292.02 | 292.3 | 291.29 | 291.75 | 15296.0 |
| 2022-03-16 07:30:00 | MSFT | Stock | 291.72 | 292.0 | 291.34 | 291.9 | 16889.0 |
| 2022-03-16 08:00:00 | MSFT | Stock | 291.78 | 292.5 | 288.0 | 291.17 | 44634.0 |
| 2022-03-16 08:30:00 | MSFT | Stock | 291.22 | 291.33 | 289.3301 | 289.58 | 61768.0 |
| 2022-03-16 09:00:00 | MSFT | Stock | 289.97 | 290.94 | 288.72 | 289.11 | 25621.0 |
| 2022-03-16 09:30:00 | MSFT | Stock | 289.11 | 292.23 | 289.03 | 290.635 | 3039971.0 |
| 2022-03-16 10:00:00 | MSFT | Stock | 290.63 | 292.76 | 289.775 | 291.7799 | 1804617.0 |
| 2022-03-16 10:30:00 | MSFT | Stock | 291.78 | 292.81 | 290.911 | 291.8174 | 1418741.0 |
| 2022-03-16 11:00:00 | MSFT | Stock | 291.78 | 291.9 | 290.7 | 291.15 | 969336.0 |
| 2022-03-16 11:30:00 | MSFT | Stock | 291.18 | 291.66 | 290.77 | 291.01 | 872966.0 |
| 2022-03-16 12:00:00 | MSFT | Stock | 290.99 | 291.6 | 289.96 | 290.41 | 977492.0 |
| 2022-03-16 12:30:00 | MSFT | Stock | 290.4051 | 290.4622 | 289.0 | 289.42 | 966850.0 |
> showing 50 of 112,250 rows — these rows as CSV