PREVIEW / stock_30min / 2022-02-15
file: by_date/stock_30min/2022/2022-02-15.parquet size: 2.2 MB rows: 108,591 symbols: 2,540
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-02-15 04:00:00 | AAPL | Stock | 168.9 | 171.56 | 168.9 | 171.1 | 23325.0 |
| 2022-02-15 04:30:00 | AAPL | Stock | 171.14 | 171.34 | 171.09 | 171.19 | 14543.0 |
| 2022-02-15 05:00:00 | AAPL | Stock | 171.25 | 171.59 | 171.01 | 171.34 | 7742.0 |
| 2022-02-15 05:30:00 | AAPL | Stock | 171.28 | 171.7 | 171.28 | 171.58 | 15736.0 |
| 2022-02-15 06:00:00 | AAPL | Stock | 171.65 | 171.75 | 171.55 | 171.65 | 13100.0 |
| 2022-02-15 06:30:00 | AAPL | Stock | 171.63 | 172.16 | 171.63 | 171.82 | 13707.0 |
| 2022-02-15 07:00:00 | AAPL | Stock | 171.74 | 172.03 | 171.52 | 171.83 | 86617.0 |
| 2022-02-15 07:30:00 | AAPL | Stock | 171.82 | 171.9 | 171.66 | 171.81 | 44614.0 |
| 2022-02-15 08:00:00 | AAPL | Stock | 171.93 | 172.03 | 168.88 | 171.5 | 262051.0 |
| 2022-02-15 08:30:00 | AAPL | Stock | 171.52 | 171.8 | 170.86 | 171.05 | 174862.0 |
| 2022-02-15 09:00:00 | AAPL | Stock | 171.05 | 171.3 | 170.88 | 170.99 | 243844.0 |
| 2022-02-15 09:30:00 | AAPL | Stock | 170.99 | 171.4506 | 170.25 | 170.88 | 7459828.0 |
| 2022-02-15 10:00:00 | AAPL | Stock | 170.89 | 171.1784 | 170.48 | 171.08 | 4074727.0 |
| 2022-02-15 10:30:00 | AAPL | Stock | 171.08 | 171.36 | 170.69 | 171.18 | 3191528.0 |
| 2022-02-15 11:00:00 | AAPL | Stock | 171.19 | 171.64 | 171.02 | 171.465 | 3164273.0 |
| 2022-02-15 11:30:00 | AAPL | Stock | 171.47 | 171.72 | 171.37 | 171.521 | 2140564.0 |
| 2022-02-15 12:00:00 | AAPL | Stock | 171.52 | 171.65 | 170.6609 | 170.876 | 2684332.0 |
| 2022-02-15 12:30:00 | AAPL | Stock | 170.88 | 171.0 | 170.34 | 170.5699 | 2633073.0 |
| 2022-02-15 13:00:00 | AAPL | Stock | 170.57 | 171.95 | 170.53 | 171.84 | 2786032.0 |
| 2022-02-15 13:30:00 | AAPL | Stock | 171.85 | 172.04 | 171.59 | 171.77 | 2295426.0 |
| 2022-02-15 14:00:00 | AAPL | Stock | 171.77 | 171.89 | 171.38 | 171.82 | 2262868.0 |
| 2022-02-15 14:30:00 | AAPL | Stock | 171.82 | 172.27 | 171.68 | 171.985 | 2651256.0 |
| 2022-02-15 15:00:00 | AAPL | Stock | 171.99 | 172.36 | 171.93 | 172.19 | 2784218.0 |
| 2022-02-15 15:30:00 | AAPL | Stock | 172.18 | 172.95 | 171.72 | 172.8 | 7993922.0 |
| 2022-02-15 16:00:00 | AAPL | Stock | 172.79 | 172.96 | 172.22 | 172.52 | 7632873.0 |
| 2022-02-15 16:30:00 | AAPL | Stock | 172.57 | 172.57 | 172.3 | 172.3 | 34048.0 |
| 2022-02-15 17:00:00 | AAPL | Stock | 172.26 | 172.46 | 172.25 | 172.4 | 21487.0 |
| 2022-02-15 17:30:00 | AAPL | Stock | 172.31 | 172.79 | 172.28 | 172.28 | 682585.0 |
| 2022-02-15 18:00:00 | AAPL | Stock | 172.37 | 172.4 | 172.2 | 172.24 | 9668.0 |
| 2022-02-15 18:30:00 | AAPL | Stock | 172.22 | 172.35 | 172.22 | 172.22 | 10608.0 |
| 2022-02-15 19:00:00 | AAPL | Stock | 172.25 | 172.3 | 172.15 | 172.15 | 10869.0 |
| 2022-02-15 19:30:00 | AAPL | Stock | 172.14 | 172.15 | 171.88 | 171.9 | 86171.0 |
| 2022-02-15 04:00:00 | MSFT | Stock | 295.75 | 300.49 | 295.75 | 300.49 | 2531.0 |
| 2022-02-15 04:30:00 | MSFT | Stock | 300.39 | 300.39 | 299.99 | 300.12 | 2302.0 |
| 2022-02-15 05:00:00 | MSFT | Stock | 300.45 | 300.95 | 300.0 | 300.0 | 4577.0 |
| 2022-02-15 05:30:00 | MSFT | Stock | 300.0 | 300.79 | 300.0 | 300.53 | 2817.0 |
| 2022-02-15 06:00:00 | MSFT | Stock | 300.7 | 300.88 | 300.55 | 300.69 | 2730.0 |
| 2022-02-15 06:30:00 | MSFT | Stock | 300.32 | 301.69 | 300.32 | 301.16 | 2933.0 |
| 2022-02-15 07:00:00 | MSFT | Stock | 301.16 | 301.87 | 300.75 | 301.6 | 14140.0 |
| 2022-02-15 07:30:00 | MSFT | Stock | 301.75 | 301.75 | 301.0 | 301.44 | 16708.0 |
| 2022-02-15 08:00:00 | MSFT | Stock | 300.9996 | 301.88 | 300.61 | 300.75 | 52352.0 |
| 2022-02-15 08:30:00 | MSFT | Stock | 300.76 | 300.88 | 299.65 | 299.75 | 46760.0 |
| 2022-02-15 09:00:00 | MSFT | Stock | 300.0 | 300.7099 | 299.67 | 299.9 | 31433.0 |
| 2022-02-15 09:30:00 | MSFT | Stock | 299.97 | 300.8 | 298.88 | 299.34 | 2581985.0 |
| 2022-02-15 10:00:00 | MSFT | Stock | 299.38 | 299.7 | 298.24 | 299.105 | 1485067.0 |
| 2022-02-15 10:30:00 | MSFT | Stock | 299.115 | 300.7 | 298.77 | 299.88 | 1405392.0 |
| 2022-02-15 11:00:00 | MSFT | Stock | 299.9 | 300.33 | 299.192 | 299.4314 | 798834.0 |
| 2022-02-15 11:30:00 | MSFT | Stock | 299.43 | 300.1 | 299.19 | 299.46 | 707181.0 |
| 2022-02-15 12:00:00 | MSFT | Stock | 299.51 | 299.72 | 297.84 | 297.96 | 932096.0 |
| 2022-02-15 12:30:00 | MSFT | Stock | 297.97 | 298.105 | 297.02 | 298.02 | 873889.0 |
> showing 50 of 108,591 rows — these rows as CSV