PREVIEW / stock_30min / 2021-06-10
file: by_date/stock_30min/2021/2021-06-10.parquet size: 2.2 MB rows: 112,842 symbols: 2,971
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-06-10 04:00:00 | AAPL | Stock | 126.82 | 126.92 | 126.36 | 126.4 | 14156.0 |
| 2021-06-10 04:30:00 | AAPL | Stock | 126.38 | 126.53 | 126.38 | 126.5 | 6450.0 |
| 2021-06-10 05:00:00 | AAPL | Stock | 126.51 | 126.64 | 126.51 | 126.6 | 6351.0 |
| 2021-06-10 05:30:00 | AAPL | Stock | 126.6 | 126.62 | 126.47 | 126.57 | 3398.0 |
| 2021-06-10 06:00:00 | AAPL | Stock | 126.6 | 126.69 | 126.6 | 126.65 | 1443.0 |
| 2021-06-10 06:30:00 | AAPL | Stock | 126.61 | 126.61 | 126.55 | 126.55 | 531.0 |
| 2021-06-10 07:00:00 | AAPL | Stock | 126.62 | 126.84 | 126.51 | 126.69 | 30596.0 |
| 2021-06-10 07:30:00 | AAPL | Stock | 126.71 | 127.0 | 126.42 | 126.73 | 75657.0 |
| 2021-06-10 08:00:00 | AAPL | Stock | 126.5801 | 126.98 | 126.45 | 126.75 | 147736.0 |
| 2021-06-10 08:30:00 | AAPL | Stock | 126.75 | 127.38 | 126.22 | 127.26 | 426822.0 |
| 2021-06-10 09:00:00 | AAPL | Stock | 127.26 | 127.5 | 126.61 | 127.03 | 345622.0 |
| 2021-06-10 09:30:00 | AAPL | Stock | 127.02 | 128.19 | 126.62 | 127.92 | 9994752.0 |
| 2021-06-10 10:00:00 | AAPL | Stock | 127.92 | 128.015 | 127.34 | 127.46 | 5022940.0 |
| 2021-06-10 10:30:00 | AAPL | Stock | 127.47 | 127.59 | 126.115 | 126.48 | 7027365.0 |
| 2021-06-10 11:00:00 | AAPL | Stock | 126.475 | 126.685 | 126.19 | 126.62 | 4326569.0 |
| 2021-06-10 11:30:00 | AAPL | Stock | 126.63 | 126.69 | 126.4 | 126.59 | 2802691.0 |
| 2021-06-10 12:00:00 | AAPL | Stock | 126.5901 | 126.825 | 126.45 | 126.46 | 2427323.0 |
| 2021-06-10 12:30:00 | AAPL | Stock | 126.46 | 126.7 | 126.42 | 126.59 | 2044956.0 |
| 2021-06-10 13:00:00 | AAPL | Stock | 126.59 | 126.63 | 126.41 | 126.455 | 1996811.0 |
| 2021-06-10 13:30:00 | AAPL | Stock | 126.455 | 126.47 | 126.24 | 126.3535 | 2978536.0 |
| 2021-06-10 14:00:00 | AAPL | Stock | 126.3576 | 126.39 | 126.11 | 126.13 | 2596862.0 |
| 2021-06-10 14:30:00 | AAPL | Stock | 126.13 | 126.355 | 125.96 | 126.34 | 3776195.0 |
| 2021-06-10 15:00:00 | AAPL | Stock | 126.335 | 126.41 | 126.13 | 126.285 | 3665533.0 |
| 2021-06-10 15:30:00 | AAPL | Stock | 126.28 | 126.35 | 125.94 | 126.11 | 9121308.0 |
| 2021-06-10 16:00:00 | AAPL | Stock | 126.11 | 126.11 | 126.02 | 126.08 | 5627786.0 |
| 2021-06-10 16:30:00 | AAPL | Stock | 126.08 | 126.36 | 126.07 | 126.26 | 144881.0 |
| 2021-06-10 17:00:00 | AAPL | Stock | 126.24 | 126.24 | 126.16 | 126.21 | 21558.0 |
| 2021-06-10 17:30:00 | AAPL | Stock | 126.22 | 126.28 | 126.2 | 126.27 | 23448.0 |
| 2021-06-10 18:00:00 | AAPL | Stock | 126.26 | 126.32 | 126.22 | 126.29 | 25659.0 |
| 2021-06-10 18:30:00 | AAPL | Stock | 126.28 | 126.3 | 126.25 | 126.27 | 24585.0 |
| 2021-06-10 19:00:00 | AAPL | Stock | 126.28 | 126.28 | 126.21 | 126.25 | 31086.0 |
| 2021-06-10 19:30:00 | AAPL | Stock | 126.25 | 126.3 | 126.21 | 126.2801 | 28672.0 |
| 2021-06-10 04:00:00 | MSFT | Stock | 253.2 | 253.2 | 253.04 | 253.09 | 583.0 |
| 2021-06-10 04:30:00 | MSFT | Stock | 252.78 | 252.78 | 252.78 | 252.78 | 100.0 |
| 2021-06-10 05:30:00 | MSFT | Stock | 253.0 | 253.0 | 253.0 | 253.0 | 966.0 |
| 2021-06-10 06:30:00 | MSFT | Stock | 252.8 | 252.8 | 252.8 | 252.8 | 100.0 |
| 2021-06-10 07:00:00 | MSFT | Stock | 252.85 | 253.01 | 252.76 | 252.76 | 6448.0 |
| 2021-06-10 07:30:00 | MSFT | Stock | 252.75 | 253.08 | 252.36 | 252.95 | 10310.0 |
| 2021-06-10 08:00:00 | MSFT | Stock | 253.11 | 253.11 | 252.63 | 252.75 | 8363.0 |
| 2021-06-10 08:30:00 | MSFT | Stock | 252.77 | 254.22 | 251.5 | 254.0 | 35465.0 |
| 2021-06-10 09:00:00 | MSFT | Stock | 254.24 | 255.16 | 254.0101 | 254.36 | 35593.0 |
| 2021-06-10 09:30:00 | MSFT | Stock | 254.3 | 256.35 | 253.64 | 255.87 | 2284409.0 |
| 2021-06-10 10:00:00 | MSFT | Stock | 255.86 | 256.25 | 255.6199 | 256.07 | 1334751.0 |
| 2021-06-10 10:30:00 | MSFT | Stock | 256.08 | 256.42 | 254.58 | 255.21 | 1651798.0 |
| 2021-06-10 11:00:00 | MSFT | Stock | 255.2 | 256.2 | 254.98 | 256.135 | 1032274.0 |
| 2021-06-10 11:30:00 | MSFT | Stock | 256.11 | 256.895 | 256.11 | 256.78 | 2017306.0 |
| 2021-06-10 12:00:00 | MSFT | Stock | 256.78 | 257.24 | 256.5702 | 256.79 | 1133411.0 |
| 2021-06-10 12:30:00 | MSFT | Stock | 256.8 | 257.445 | 256.74 | 257.43 | 868888.0 |
| 2021-06-10 13:00:00 | MSFT | Stock | 257.43 | 257.46 | 256.55 | 256.615 | 874658.0 |
| 2021-06-10 13:30:00 | MSFT | Stock | 256.62 | 257.0 | 256.28 | 256.99 | 828317.0 |
> showing 50 of 112,842 rows — these rows as CSV