PREVIEW / stock_30min / 2022-03-15
file: by_date/stock_30min/2022/2022-03-15.parquet size: 2.2 MB rows: 108,857 symbols: 2,487
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-15 04:00:00 | AAPL | Stock | 149.4 | 150.9 | 149.4 | 149.93 | 66207.0 |
| 2022-03-15 04:30:00 | AAPL | Stock | 149.85 | 149.92 | 149.12 | 149.3 | 27320.0 |
| 2022-03-15 05:00:00 | AAPL | Stock | 149.3 | 149.9 | 148.93 | 149.74 | 37526.0 |
| 2022-03-15 05:30:00 | AAPL | Stock | 149.78 | 150.0 | 149.4 | 149.4 | 16032.0 |
| 2022-03-15 06:00:00 | AAPL | Stock | 149.5 | 150.02 | 149.5 | 150.02 | 12433.0 |
| 2022-03-15 06:30:00 | AAPL | Stock | 149.98 | 150.76 | 149.98 | 150.22 | 27464.0 |
| 2022-03-15 07:00:00 | AAPL | Stock | 150.24 | 150.89 | 150.23 | 150.44 | 83495.0 |
| 2022-03-15 07:30:00 | AAPL | Stock | 150.46 | 150.74 | 150.03 | 150.26 | 68389.0 |
| 2022-03-15 08:00:00 | AAPL | Stock | 150.4518 | 152.16 | 150.01 | 150.57 | 359227.0 |
| 2022-03-15 08:30:00 | AAPL | Stock | 150.53 | 151.55 | 150.52 | 150.98 | 318988.0 |
| 2022-03-15 09:00:00 | AAPL | Stock | 150.99 | 151.58 | 150.31 | 150.99 | 235025.0 |
| 2022-03-15 09:30:00 | AAPL | Stock | 151.04 | 152.2989 | 150.38 | 151.5607 | 10322933.0 |
| 2022-03-15 10:00:00 | AAPL | Stock | 151.56 | 152.05 | 150.68 | 152.025 | 6062252.0 |
| 2022-03-15 10:30:00 | AAPL | Stock | 152.03 | 152.775 | 151.92 | 152.5 | 5214847.0 |
| 2022-03-15 11:00:00 | AAPL | Stock | 152.515 | 153.41 | 152.29 | 153.38 | 4485414.0 |
| 2022-03-15 11:30:00 | AAPL | Stock | 153.39 | 154.22 | 153.0724 | 153.3383 | 5298813.0 |
| 2022-03-15 12:00:00 | AAPL | Stock | 153.33 | 154.67 | 153.03 | 154.53 | 4359528.0 |
| 2022-03-15 12:30:00 | AAPL | Stock | 154.54 | 154.659 | 153.68 | 154.115 | 3351016.0 |
| 2022-03-15 13:00:00 | AAPL | Stock | 154.13 | 154.18 | 153.25 | 153.25 | 2802328.0 |
| 2022-03-15 13:30:00 | AAPL | Stock | 153.2599 | 153.8 | 153.13 | 153.6982 | 2904768.0 |
| 2022-03-15 14:00:00 | AAPL | Stock | 153.69 | 153.78 | 152.83 | 153.225 | 3882998.0 |
| 2022-03-15 14:30:00 | AAPL | Stock | 153.21 | 154.4499 | 153.015 | 154.4 | 3721596.0 |
| 2022-03-15 15:00:00 | AAPL | Stock | 154.39 | 155.19 | 154.27 | 154.909 | 5475718.0 |
| 2022-03-15 15:30:00 | AAPL | Stock | 154.91 | 155.57 | 154.81 | 155.16 | 9202190.0 |
| 2022-03-15 16:00:00 | AAPL | Stock | 155.08 | 155.15 | 154.71 | 154.8999 | 11083426.0 |
| 2022-03-15 16:30:00 | AAPL | Stock | 154.894 | 155.09 | 154.87 | 154.96 | 156970.0 |
| 2022-03-15 17:00:00 | AAPL | Stock | 154.94 | 155.06 | 154.85 | 154.95 | 13820.0 |
| 2022-03-15 17:30:00 | AAPL | Stock | 154.98 | 154.98 | 154.84 | 154.85 | 14913.0 |
| 2022-03-15 18:00:00 | AAPL | Stock | 154.89 | 154.9 | 154.7 | 154.8 | 26910.0 |
| 2022-03-15 18:30:00 | AAPL | Stock | 154.8 | 154.8 | 154.59 | 154.77 | 20015.0 |
| 2022-03-15 19:00:00 | AAPL | Stock | 154.73 | 154.8 | 154.66 | 154.78 | 11108.0 |
| 2022-03-15 19:30:00 | AAPL | Stock | 154.75 | 155.1 | 154.65 | 155.0 | 25642.0 |
| 2022-03-15 04:00:00 | MSFT | Stock | 275.8 | 276.88 | 275.66 | 275.7 | 4053.0 |
| 2022-03-15 04:30:00 | MSFT | Stock | 275.6 | 276.09 | 275.15 | 275.4 | 2795.0 |
| 2022-03-15 05:00:00 | MSFT | Stock | 275.43 | 275.6 | 274.62 | 275.6 | 6880.0 |
| 2022-03-15 05:30:00 | MSFT | Stock | 276.1 | 277.18 | 275.85 | 275.85 | 1839.0 |
| 2022-03-15 06:00:00 | MSFT | Stock | 277.04 | 277.27 | 276.6 | 277.0 | 1550.0 |
| 2022-03-15 06:30:00 | MSFT | Stock | 277.33 | 278.59 | 277.2 | 278.28 | 6179.0 |
| 2022-03-15 07:00:00 | MSFT | Stock | 278.21 | 279.0 | 277.83 | 277.83 | 5961.0 |
| 2022-03-15 07:30:00 | MSFT | Stock | 277.8 | 277.9 | 277.02 | 277.51 | 6256.0 |
| 2022-03-15 08:00:00 | MSFT | Stock | 278.1666 | 279.0 | 277.0 | 278.52 | 34662.0 |
| 2022-03-15 08:30:00 | MSFT | Stock | 278.6 | 280.88 | 278.6 | 279.3 | 29548.0 |
| 2022-03-15 09:00:00 | MSFT | Stock | 279.5 | 280.71 | 279.1 | 280.38 | 26936.0 |
| 2022-03-15 09:30:00 | MSFT | Stock | 280.49 | 281.87 | 278.725 | 280.3399 | 2605967.0 |
| 2022-03-15 10:00:00 | MSFT | Stock | 280.33 | 281.13 | 279.375 | 280.69 | 1333190.0 |
| 2022-03-15 10:30:00 | MSFT | Stock | 280.68 | 281.99 | 280.55 | 280.99 | 1348582.0 |
| 2022-03-15 11:00:00 | MSFT | Stock | 281.02 | 283.39 | 280.695 | 283.34 | 1291721.0 |
| 2022-03-15 11:30:00 | MSFT | Stock | 283.33 | 284.81 | 282.26 | 282.8 | 1380405.0 |
| 2022-03-15 12:00:00 | MSFT | Stock | 282.78 | 285.22 | 281.62 | 285.01 | 1218242.0 |
| 2022-03-15 12:30:00 | MSFT | Stock | 285.04 | 285.24 | 283.79 | 284.53 | 1046267.0 |
> showing 50 of 108,857 rows — these rows as CSV