PREVIEW / stock_30min / 2021-08-30
file: by_date/stock_30min/2021/2021-08-30.parquet size: 2.2 MB rows: 110,052 symbols: 2,754
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-08-30 04:00:00 | AAPL | Stock | 148.59 | 148.78 | 148.5 | 148.64 | 16291.0 |
| 2021-08-30 04:30:00 | AAPL | Stock | 148.62 | 148.64 | 148.62 | 148.64 | 5524.0 |
| 2021-08-30 05:00:00 | AAPL | Stock | 148.7 | 148.82 | 148.7 | 148.82 | 3713.0 |
| 2021-08-30 05:30:00 | AAPL | Stock | 148.81 | 148.82 | 148.74 | 148.75 | 1678.0 |
| 2021-08-30 06:00:00 | AAPL | Stock | 148.74 | 149.0 | 148.74 | 149.0 | 10793.0 |
| 2021-08-30 06:30:00 | AAPL | Stock | 149.04 | 149.05 | 148.83 | 148.83 | 2897.0 |
| 2021-08-30 07:00:00 | AAPL | Stock | 148.79 | 148.84 | 148.71 | 148.79 | 20741.0 |
| 2021-08-30 07:30:00 | AAPL | Stock | 148.77 | 148.8 | 148.7 | 148.78 | 14205.0 |
| 2021-08-30 08:00:00 | AAPL | Stock | 148.81 | 148.93 | 148.229 | 148.88 | 95656.0 |
| 2021-08-30 08:30:00 | AAPL | Stock | 148.88 | 148.9 | 148.74 | 148.85 | 55793.0 |
| 2021-08-30 09:00:00 | AAPL | Stock | 148.86 | 149.0 | 148.82 | 149.0 | 97981.0 |
| 2021-08-30 09:30:00 | AAPL | Stock | 149.0 | 150.95 | 148.61 | 150.775 | 12111359.0 |
| 2021-08-30 10:00:00 | AAPL | Stock | 150.78 | 151.84 | 150.78 | 151.7201 | 10512858.0 |
| 2021-08-30 10:30:00 | AAPL | Stock | 151.7217 | 152.13 | 151.67 | 151.91 | 6709904.0 |
| 2021-08-30 11:00:00 | AAPL | Stock | 151.919 | 152.26 | 151.8 | 151.8971 | 5519556.0 |
| 2021-08-30 11:30:00 | AAPL | Stock | 151.9 | 152.5 | 151.89 | 152.4999 | 4246635.0 |
| 2021-08-30 12:00:00 | AAPL | Stock | 152.49 | 152.56 | 152.13 | 152.5099 | 4137966.0 |
| 2021-08-30 12:30:00 | AAPL | Stock | 152.501 | 153.11 | 152.4101 | 152.9751 | 5585993.0 |
| 2021-08-30 13:00:00 | AAPL | Stock | 152.975 | 153.25 | 152.93 | 153.0984 | 4097322.0 |
| 2021-08-30 13:30:00 | AAPL | Stock | 153.095 | 153.42 | 152.86 | 153.405 | 3959670.0 |
| 2021-08-30 14:00:00 | AAPL | Stock | 153.4005 | 153.49 | 153.11 | 153.2 | 3814914.0 |
| 2021-08-30 14:30:00 | AAPL | Stock | 153.2 | 153.28 | 152.8107 | 153.0502 | 3918898.0 |
| 2021-08-30 15:00:00 | AAPL | Stock | 153.0501 | 153.295 | 152.98 | 153.28 | 3675068.0 |
| 2021-08-30 15:30:00 | AAPL | Stock | 153.285 | 153.41 | 152.9801 | 153.1 | 6801086.0 |
| 2021-08-30 16:00:00 | AAPL | Stock | 153.08 | 153.17 | 152.99 | 153.07 | 4727920.0 |
| 2021-08-30 16:30:00 | AAPL | Stock | 153.07 | 153.12 | 152.96 | 152.96 | 73237.0 |
| 2021-08-30 17:00:00 | AAPL | Stock | 152.99 | 153.03 | 152.85 | 152.98 | 34822.0 |
| 2021-08-30 17:30:00 | AAPL | Stock | 153.0 | 153.09 | 152.9 | 153.08 | 34582.0 |
| 2021-08-30 18:00:00 | AAPL | Stock | 153.09 | 153.14 | 153.07 | 153.1 | 19909.0 |
| 2021-08-30 18:30:00 | AAPL | Stock | 153.08 | 153.1 | 152.91 | 152.97 | 27194.0 |
| 2021-08-30 19:00:00 | AAPL | Stock | 152.98 | 153.0 | 152.88 | 152.9 | 23336.0 |
| 2021-08-30 19:30:00 | AAPL | Stock | 152.9 | 152.97 | 152.82 | 152.91 | 61424.0 |
| 2021-08-30 04:00:00 | MSFT | Stock | 301.19 | 301.22 | 300.99 | 300.99 | 8323.0 |
| 2021-08-30 04:30:00 | MSFT | Stock | 300.99 | 301.0 | 300.85 | 300.95 | 6884.0 |
| 2021-08-30 05:00:00 | MSFT | Stock | 300.94 | 301.2 | 300.94 | 301.2 | 1632.0 |
| 2021-08-30 05:30:00 | MSFT | Stock | 301.11 | 301.11 | 301.11 | 301.11 | 149.0 |
| 2021-08-30 06:00:00 | MSFT | Stock | 301.3 | 301.4 | 301.0 | 301.4 | 11317.0 |
| 2021-08-30 06:30:00 | MSFT | Stock | 301.33 | 301.33 | 301.0 | 301.0 | 1783.0 |
| 2021-08-30 07:00:00 | MSFT | Stock | 300.92 | 301.14 | 300.88 | 301.04 | 8979.0 |
| 2021-08-30 07:30:00 | MSFT | Stock | 301.04 | 301.04 | 300.82 | 300.83 | 600.0 |
| 2021-08-30 08:00:00 | MSFT | Stock | 300.84 | 301.06 | 300.73 | 300.73 | 13105.0 |
| 2021-08-30 08:30:00 | MSFT | Stock | 300.71 | 300.75 | 300.6 | 300.75 | 7567.0 |
| 2021-08-30 09:00:00 | MSFT | Stock | 300.76 | 301.44 | 300.5 | 301.07 | 19510.0 |
| 2021-08-30 09:30:00 | MSFT | Stock | 301.03 | 303.93 | 301.03 | 303.12 | 2050472.0 |
| 2021-08-30 10:00:00 | MSFT | Stock | 303.12 | 303.74 | 302.3067 | 303.691 | 1090103.0 |
| 2021-08-30 10:30:00 | MSFT | Stock | 303.71 | 304.15 | 303.45 | 304.135 | 1027671.0 |
| 2021-08-30 11:00:00 | MSFT | Stock | 304.13 | 304.22 | 303.18 | 303.47 | 677170.0 |
| 2021-08-30 11:30:00 | MSFT | Stock | 303.47 | 303.85 | 302.99 | 303.37 | 521129.0 |
| 2021-08-30 12:00:00 | MSFT | Stock | 303.38 | 303.42 | 302.72 | 302.82 | 536316.0 |
| 2021-08-30 12:30:00 | MSFT | Stock | 302.8227 | 303.17 | 302.68 | 302.9684 | 365185.0 |
> showing 50 of 110,052 rows — these rows as CSV