PREVIEW / stock_30min / 2022-03-10
file: by_date/stock_30min/2022/2022-03-10.parquet size: 2.2 MB rows: 108,433 symbols: 2,485
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-10 04:00:00 | AAPL | Stock | 161.75 | 162.0 | 161.5 | 161.53 | 19304.0 |
| 2022-03-10 04:30:00 | AAPL | Stock | 161.28 | 161.83 | 160.64 | 160.99 | 18591.0 |
| 2022-03-10 05:00:00 | AAPL | Stock | 161.0 | 161.2 | 160.5 | 161.2 | 7378.0 |
| 2022-03-10 05:30:00 | AAPL | Stock | 161.26 | 161.34 | 160.5 | 160.53 | 11265.0 |
| 2022-03-10 06:00:00 | AAPL | Stock | 160.53 | 160.75 | 160.1 | 160.64 | 9633.0 |
| 2022-03-10 06:30:00 | AAPL | Stock | 160.64 | 160.64 | 159.92 | 160.1 | 15365.0 |
| 2022-03-10 07:00:00 | AAPL | Stock | 160.24 | 160.92 | 160.0 | 160.89 | 73020.0 |
| 2022-03-10 07:30:00 | AAPL | Stock | 160.86 | 160.94 | 160.0 | 160.0 | 115872.0 |
| 2022-03-10 08:00:00 | AAPL | Stock | 160.4002 | 162.48 | 159.85 | 160.03 | 393354.0 |
| 2022-03-10 08:30:00 | AAPL | Stock | 160.03 | 160.89 | 160.0 | 160.18 | 361941.0 |
| 2022-03-10 09:00:00 | AAPL | Stock | 160.18 | 160.4 | 160.07 | 160.4 | 280580.0 |
| 2022-03-10 09:30:00 | AAPL | Stock | 160.2 | 160.39 | 158.03 | 158.921 | 12731046.0 |
| 2022-03-10 10:00:00 | AAPL | Stock | 158.93 | 158.95 | 157.9 | 158.12 | 6750053.0 |
| 2022-03-10 10:30:00 | AAPL | Stock | 158.135 | 158.37 | 157.6 | 157.78 | 4833740.0 |
| 2022-03-10 11:00:00 | AAPL | Stock | 157.77 | 157.77 | 156.48 | 156.6791 | 5837122.0 |
| 2022-03-10 11:30:00 | AAPL | Stock | 156.68 | 157.45 | 156.4 | 157.3601 | 5358020.0 |
| 2022-03-10 12:00:00 | AAPL | Stock | 157.36 | 157.5 | 156.91 | 157.21 | 3596269.0 |
| 2022-03-10 12:30:00 | AAPL | Stock | 157.21 | 157.21 | 156.0 | 156.07 | 4446633.0 |
| 2022-03-10 13:00:00 | AAPL | Stock | 156.06 | 157.075 | 155.98 | 156.83 | 4376792.0 |
| 2022-03-10 13:30:00 | AAPL | Stock | 156.82 | 157.738 | 156.57 | 157.55 | 3922811.0 |
| 2022-03-10 14:00:00 | AAPL | Stock | 157.55 | 158.54 | 157.41 | 158.23 | 4851947.0 |
| 2022-03-10 14:30:00 | AAPL | Stock | 158.23 | 159.19 | 158.12 | 159.015 | 4652882.0 |
| 2022-03-10 15:00:00 | AAPL | Stock | 159.02 | 159.08 | 157.74 | 158.01 | 4946404.0 |
| 2022-03-10 15:30:00 | AAPL | Stock | 158.02 | 158.6899 | 157.41 | 158.52 | 8255074.0 |
| 2022-03-10 16:00:00 | AAPL | Stock | 158.36 | 158.52 | 157.99 | 158.22 | 10621286.0 |
| 2022-03-10 16:30:00 | AAPL | Stock | 158.21 | 158.52 | 158.11 | 158.19 | 118089.0 |
| 2022-03-10 17:00:00 | AAPL | Stock | 158.15 | 158.15 | 157.87 | 157.96 | 26762.0 |
| 2022-03-10 17:30:00 | AAPL | Stock | 158.0 | 158.52 | 157.91 | 158.0 | 21888.0 |
| 2022-03-10 18:00:00 | AAPL | Stock | 158.04 | 158.39 | 158.04 | 158.3 | 36852.0 |
| 2022-03-10 18:30:00 | AAPL | Stock | 158.3 | 158.5 | 158.2799 | 158.36 | 31857.0 |
| 2022-03-10 19:00:00 | AAPL | Stock | 158.4 | 158.54 | 158.31 | 158.47 | 48241.0 |
| 2022-03-10 19:30:00 | AAPL | Stock | 158.45 | 158.46 | 158.0 | 158.05 | 34593.0 |
| 2022-03-10 04:00:00 | MSFT | Stock | 288.5 | 288.5 | 284.0 | 284.0 | 2524.0 |
| 2022-03-10 04:30:00 | MSFT | Stock | 284.02 | 284.5 | 283.25 | 283.85 | 3293.0 |
| 2022-03-10 05:00:00 | MSFT | Stock | 284.09 | 284.11 | 283.51 | 284.03 | 2450.0 |
| 2022-03-10 05:30:00 | MSFT | Stock | 284.18 | 284.18 | 283.5 | 283.62 | 2563.0 |
| 2022-03-10 06:00:00 | MSFT | Stock | 283.12 | 283.76 | 282.72 | 282.72 | 839.0 |
| 2022-03-10 06:30:00 | MSFT | Stock | 283.66 | 283.99 | 282.0 | 282.58 | 4064.0 |
| 2022-03-10 07:00:00 | MSFT | Stock | 283.07 | 283.5 | 282.36 | 283.31 | 23438.0 |
| 2022-03-10 07:30:00 | MSFT | Stock | 283.46 | 283.5 | 282.2 | 282.31 | 10300.0 |
| 2022-03-10 08:00:00 | MSFT | Stock | 282.5784 | 286.0 | 282.01 | 282.94 | 24523.0 |
| 2022-03-10 08:30:00 | MSFT | Stock | 283.49 | 285.76 | 282.18 | 282.24 | 49919.0 |
| 2022-03-10 09:00:00 | MSFT | Stock | 282.4 | 283.78 | 282.1 | 282.93 | 39658.0 |
| 2022-03-10 09:30:00 | MSFT | Stock | 283.18 | 285.09 | 282.3601 | 284.21 | 3002498.0 |
| 2022-03-10 10:00:00 | MSFT | Stock | 284.2 | 285.0 | 282.63 | 283.45 | 1666820.0 |
| 2022-03-10 10:30:00 | MSFT | Stock | 283.42 | 283.95 | 281.86 | 282.1919 | 1265837.0 |
| 2022-03-10 11:00:00 | MSFT | Stock | 282.17 | 282.18 | 280.8 | 281.12 | 1243404.0 |
| 2022-03-10 11:30:00 | MSFT | Stock | 281.14 | 282.14 | 280.58 | 281.603 | 1218564.0 |
| 2022-03-10 12:00:00 | MSFT | Stock | 281.62 | 283.0 | 281.42 | 282.68 | 1014280.0 |
| 2022-03-10 12:30:00 | MSFT | Stock | 282.67 | 282.9 | 281.9601 | 282.31 | 685278.0 |
> showing 50 of 108,433 rows — these rows as CSV