PREVIEW / stock_30min / 2022-03-08
file: by_date/stock_30min/2022/2022-03-08.parquet size: 2.3 MB rows: 112,081 symbols: 2,537
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-08 04:00:00 | AAPL | Stock | 160.18 | 160.18 | 159.45 | 159.71 | 39802.0 |
| 2022-03-08 04:30:00 | AAPL | Stock | 159.6 | 159.68 | 159.38 | 159.61 | 7202.0 |
| 2022-03-08 05:00:00 | AAPL | Stock | 159.62 | 159.8 | 159.17 | 159.8 | 20192.0 |
| 2022-03-08 05:30:00 | AAPL | Stock | 159.7 | 159.76 | 159.28 | 159.59 | 9479.0 |
| 2022-03-08 06:00:00 | AAPL | Stock | 159.6 | 159.75 | 159.26 | 159.66 | 9921.0 |
| 2022-03-08 06:30:00 | AAPL | Stock | 159.77 | 159.85 | 159.52 | 159.68 | 13727.0 |
| 2022-03-08 07:00:00 | AAPL | Stock | 159.71 | 160.72 | 159.69 | 160.21 | 88214.0 |
| 2022-03-08 07:30:00 | AAPL | Stock | 160.22 | 160.38 | 159.06 | 159.25 | 86163.0 |
| 2022-03-08 08:00:00 | AAPL | Stock | 159.8999 | 160.72 | 157.81 | 158.84 | 691674.0 |
| 2022-03-08 08:30:00 | AAPL | Stock | 158.88 | 159.7 | 158.66 | 159.0 | 221756.0 |
| 2022-03-08 09:00:00 | AAPL | Stock | 159.07 | 159.9 | 158.62 | 158.84 | 429499.0 |
| 2022-03-08 09:30:00 | AAPL | Stock | 158.82 | 160.32 | 158.41 | 159.25 | 12888036.0 |
| 2022-03-08 10:00:00 | AAPL | Stock | 159.24 | 159.26 | 156.72 | 156.735 | 9002957.0 |
| 2022-03-08 10:30:00 | AAPL | Stock | 156.73 | 158.2 | 156.0504 | 157.99 | 8244443.0 |
| 2022-03-08 11:00:00 | AAPL | Stock | 157.99 | 158.38 | 156.49 | 156.54 | 5875797.0 |
| 2022-03-08 11:30:00 | AAPL | Stock | 156.54 | 157.245 | 155.8 | 156.91 | 6282068.0 |
| 2022-03-08 12:00:00 | AAPL | Stock | 156.905 | 160.91 | 156.845 | 160.8759 | 9317539.0 |
| 2022-03-08 12:30:00 | AAPL | Stock | 160.865 | 162.16 | 160.13 | 161.75 | 7751586.0 |
| 2022-03-08 13:00:00 | AAPL | Stock | 161.76 | 162.88 | 160.83 | 160.99 | 7441816.0 |
| 2022-03-08 13:30:00 | AAPL | Stock | 160.9991 | 160.9991 | 158.6 | 158.61 | 6385781.0 |
| 2022-03-08 14:00:00 | AAPL | Stock | 158.62 | 159.29 | 157.83 | 159.1515 | 6160433.0 |
| 2022-03-08 14:30:00 | AAPL | Stock | 159.13 | 160.01 | 158.55 | 159.44 | 5494468.0 |
| 2022-03-08 15:00:00 | AAPL | Stock | 159.44 | 160.5 | 158.36 | 158.45 | 5539147.0 |
| 2022-03-08 15:30:00 | AAPL | Stock | 158.46 | 158.51 | 157.1066 | 157.28 | 10249665.0 |
| 2022-03-08 16:00:00 | AAPL | Stock | 157.36 | 158.79 | 156.53 | 156.7301 | 9891012.0 |
| 2022-03-08 16:30:00 | AAPL | Stock | 156.75 | 157.44 | 156.44 | 156.66 | 156460.0 |
| 2022-03-08 17:00:00 | AAPL | Stock | 156.65 | 156.69 | 156.5 | 156.57 | 46054.0 |
| 2022-03-08 17:30:00 | AAPL | Stock | 156.56 | 156.67 | 156.5 | 156.55 | 39628.0 |
| 2022-03-08 18:00:00 | AAPL | Stock | 156.55 | 156.84 | 156.46 | 156.8 | 34332.0 |
| 2022-03-08 18:30:00 | AAPL | Stock | 156.87 | 157.16 | 156.85 | 157.1 | 30592.0 |
| 2022-03-08 19:00:00 | AAPL | Stock | 157.1 | 157.64 | 157.1 | 157.6 | 40030.0 |
| 2022-03-08 19:30:00 | AAPL | Stock | 157.55 | 157.8 | 157.45 | 157.68 | 47193.0 |
| 2022-03-08 04:00:00 | MSFT | Stock | 279.0 | 279.95 | 278.4 | 279.53 | 9243.0 |
| 2022-03-08 04:30:00 | MSFT | Stock | 279.2 | 279.48 | 279.0 | 279.48 | 2951.0 |
| 2022-03-08 05:00:00 | MSFT | Stock | 279.5 | 279.78 | 278.25 | 279.1 | 4951.0 |
| 2022-03-08 05:30:00 | MSFT | Stock | 278.31 | 278.41 | 278.26 | 278.41 | 303.0 |
| 2022-03-08 06:00:00 | MSFT | Stock | 278.99 | 279.38 | 278.0 | 278.65 | 2374.0 |
| 2022-03-08 06:30:00 | MSFT | Stock | 278.91 | 279.3 | 278.64 | 279.3 | 1824.0 |
| 2022-03-08 07:00:00 | MSFT | Stock | 279.6 | 280.92 | 279.32 | 280.34 | 21256.0 |
| 2022-03-08 07:30:00 | MSFT | Stock | 280.03 | 280.33 | 278.5 | 279.16 | 16132.0 |
| 2022-03-08 08:00:00 | MSFT | Stock | 280.1 | 280.9655 | 274.59 | 277.4 | 52323.0 |
| 2022-03-08 08:30:00 | MSFT | Stock | 277.83 | 279.0 | 277.68 | 278.61 | 16751.0 |
| 2022-03-08 09:00:00 | MSFT | Stock | 278.77 | 279.3116 | 277.86 | 278.19 | 33016.0 |
| 2022-03-08 09:30:00 | MSFT | Stock | 277.8 | 280.3 | 275.1108 | 275.33 | 3884315.0 |
| 2022-03-08 10:00:00 | MSFT | Stock | 275.36 | 275.36 | 270.62 | 273.95 | 3584750.0 |
| 2022-03-08 10:30:00 | MSFT | Stock | 273.93 | 275.67 | 272.55 | 275.1816 | 2130556.0 |
| 2022-03-08 11:00:00 | MSFT | Stock | 275.18 | 275.59 | 270.92 | 271.22 | 2884927.0 |
| 2022-03-08 11:30:00 | MSFT | Stock | 271.23 | 273.945 | 270.0 | 273.0 | 2435638.0 |
| 2022-03-08 12:00:00 | MSFT | Stock | 273.0 | 281.51 | 272.97 | 280.12 | 3230071.0 |
| 2022-03-08 12:30:00 | MSFT | Stock | 280.07 | 283.17 | 279.37 | 282.91 | 2441752.0 |
> showing 50 of 112,081 rows — these rows as CSV