PREVIEW / stock_30min / 2021-04-08
file: by_date/stock_30min/2021/2021-04-08.parquet size: 2.2 MB rows: 111,041 symbols: 2,943
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-08 04:00:00 | AAPL | Stock | 128.61 | 128.9 | 128.5 | 128.79 | 24818.0 |
| 2021-04-08 04:30:00 | AAPL | Stock | 128.78 | 128.78 | 128.55 | 128.64 | 5249.0 |
| 2021-04-08 05:00:00 | AAPL | Stock | 128.64 | 128.79 | 128.5 | 128.5 | 12289.0 |
| 2021-04-08 05:30:00 | AAPL | Stock | 128.54 | 128.98 | 128.54 | 128.87 | 13241.0 |
| 2021-04-08 06:00:00 | AAPL | Stock | 128.95 | 129.2 | 128.9 | 129.15 | 16412.0 |
| 2021-04-08 06:30:00 | AAPL | Stock | 129.09 | 129.09 | 128.82 | 128.84 | 15438.0 |
| 2021-04-08 07:00:00 | AAPL | Stock | 128.84 | 129.0 | 128.62 | 128.9 | 142387.0 |
| 2021-04-08 07:30:00 | AAPL | Stock | 128.9 | 129.04 | 128.85 | 128.9 | 94599.0 |
| 2021-04-08 08:00:00 | AAPL | Stock | 128.82 | 129.05 | 128.219 | 128.83 | 290880.0 |
| 2021-04-08 08:30:00 | AAPL | Stock | 128.83 | 129.05 | 128.47 | 128.72 | 359977.0 |
| 2021-04-08 09:00:00 | AAPL | Stock | 128.73 | 129.2 | 128.63 | 128.96 | 417636.0 |
| 2021-04-08 09:30:00 | AAPL | Stock | 128.91 | 130.0 | 128.52 | 129.9746 | 14286872.0 |
| 2021-04-08 10:00:00 | AAPL | Stock | 129.9709 | 130.07 | 129.22 | 129.33 | 9145327.0 |
| 2021-04-08 10:30:00 | AAPL | Stock | 129.33 | 129.62 | 129.02 | 129.243 | 5626774.0 |
| 2021-04-08 11:00:00 | AAPL | Stock | 129.25 | 129.5599 | 129.0601 | 129.5 | 4118874.0 |
| 2021-04-08 11:30:00 | AAPL | Stock | 129.505 | 129.665 | 129.42 | 129.58 | 3344446.0 |
| 2021-04-08 12:00:00 | AAPL | Stock | 129.59 | 129.82 | 129.405 | 129.7367 | 3627125.0 |
| 2021-04-08 12:30:00 | AAPL | Stock | 129.74 | 129.9 | 129.64 | 129.8198 | 3463005.0 |
| 2021-04-08 13:00:00 | AAPL | Stock | 129.815 | 130.14 | 129.755 | 130.03 | 4339638.0 |
| 2021-04-08 13:30:00 | AAPL | Stock | 130.04 | 130.27 | 129.7416 | 129.9473 | 4459089.0 |
| 2021-04-08 14:00:00 | AAPL | Stock | 129.95 | 130.3 | 129.915 | 130.1984 | 3385801.0 |
| 2021-04-08 14:30:00 | AAPL | Stock | 130.2 | 130.39 | 130.0823 | 130.2799 | 3713259.0 |
| 2021-04-08 15:00:00 | AAPL | Stock | 130.275 | 130.3299 | 130.01 | 130.0201 | 3610523.0 |
| 2021-04-08 15:30:00 | AAPL | Stock | 130.025 | 130.39 | 129.92 | 130.3772 | 7992964.0 |
| 2021-04-08 16:00:00 | AAPL | Stock | 130.36 | 130.52 | 130.34 | 130.46 | 5838702.0 |
| 2021-04-08 16:30:00 | AAPL | Stock | 130.43 | 130.65 | 130.43 | 130.65 | 105012.0 |
| 2021-04-08 17:00:00 | AAPL | Stock | 130.66 | 130.68 | 130.62 | 130.66 | 77155.0 |
| 2021-04-08 17:30:00 | AAPL | Stock | 130.66 | 130.72 | 130.63 | 130.7099 | 42004.0 |
| 2021-04-08 18:00:00 | AAPL | Stock | 130.68 | 130.71 | 130.56 | 130.61 | 83663.0 |
| 2021-04-08 18:30:00 | AAPL | Stock | 130.6 | 130.64 | 130.56 | 130.61 | 29812.0 |
| 2021-04-08 19:00:00 | AAPL | Stock | 130.6 | 130.75 | 130.6 | 130.75 | 27176.0 |
| 2021-04-08 19:30:00 | AAPL | Stock | 130.74 | 130.87 | 130.65 | 130.87 | 84304.0 |
| 2021-04-08 04:00:00 | MSFT | Stock | 252.0 | 252.39 | 251.73 | 251.87 | 1536.0 |
| 2021-04-08 04:30:00 | MSFT | Stock | 251.85 | 251.85 | 251.38 | 251.38 | 1117.0 |
| 2021-04-08 05:00:00 | MSFT | Stock | 251.8 | 251.89 | 251.79 | 251.88 | 4391.0 |
| 2021-04-08 05:30:00 | MSFT | Stock | 251.75 | 252.16 | 251.58 | 252.16 | 2126.0 |
| 2021-04-08 06:00:00 | MSFT | Stock | 252.32 | 252.6 | 252.15 | 252.6 | 5385.0 |
| 2021-04-08 06:30:00 | MSFT | Stock | 252.55 | 252.55 | 252.3 | 252.5 | 2546.0 |
| 2021-04-08 07:00:00 | MSFT | Stock | 252.5 | 252.7 | 252.33 | 252.4 | 8782.0 |
| 2021-04-08 07:30:00 | MSFT | Stock | 252.32 | 252.54 | 252.2 | 252.53 | 6552.0 |
| 2021-04-08 08:00:00 | MSFT | Stock | 252.3945 | 252.65 | 249.276 | 252.08 | 32589.0 |
| 2021-04-08 08:30:00 | MSFT | Stock | 252.1 | 252.49 | 252.0 | 252.38 | 15905.0 |
| 2021-04-08 09:00:00 | MSFT | Stock | 252.11 | 252.98 | 251.94 | 252.94 | 25759.0 |
| 2021-04-08 09:30:00 | MSFT | Stock | 252.85 | 254.139 | 252.0 | 253.92 | 3582754.0 |
| 2021-04-08 10:00:00 | MSFT | Stock | 253.93 | 253.97 | 252.89 | 253.1 | 1284505.0 |
| 2021-04-08 10:30:00 | MSFT | Stock | 253.09 | 253.81 | 252.66 | 252.85 | 1363745.0 |
| 2021-04-08 11:00:00 | MSFT | Stock | 252.87 | 253.19 | 252.123 | 252.95 | 1144546.0 |
| 2021-04-08 11:30:00 | MSFT | Stock | 252.945 | 253.085 | 252.51 | 252.93 | 681853.0 |
| 2021-04-08 12:00:00 | MSFT | Stock | 252.9398 | 253.24 | 252.58 | 252.67 | 813969.0 |
| 2021-04-08 12:30:00 | MSFT | Stock | 252.68 | 252.82 | 252.135 | 252.45 | 912496.0 |
> showing 50 of 111,041 rows — these rows as CSV