PREVIEW / stock_30min / 2021-10-27
file: by_date/stock_30min/2021/2021-10-27.parquet size: 2.3 MB rows: 112,146 symbols: 2,705
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-10-27 04:00:00 | AAPL | Stock | 149.47 | 149.72 | 149.47 | 149.68 | 6760.0 |
| 2021-10-27 04:30:00 | AAPL | Stock | 149.6 | 149.6 | 149.33 | 149.33 | 4544.0 |
| 2021-10-27 05:00:00 | AAPL | Stock | 149.3 | 149.44 | 149.0 | 149.3 | 6373.0 |
| 2021-10-27 05:30:00 | AAPL | Stock | 149.31 | 149.31 | 148.98 | 149.12 | 6457.0 |
| 2021-10-27 06:00:00 | AAPL | Stock | 149.11 | 149.12 | 148.92 | 149.05 | 3719.0 |
| 2021-10-27 06:30:00 | AAPL | Stock | 149.05 | 149.18 | 148.82 | 149.07 | 8270.0 |
| 2021-10-27 07:00:00 | AAPL | Stock | 149.08 | 149.28 | 148.8 | 149.0 | 70622.0 |
| 2021-10-27 07:30:00 | AAPL | Stock | 149.02 | 149.1 | 148.82 | 148.85 | 49015.0 |
| 2021-10-27 08:00:00 | AAPL | Stock | 149.12 | 149.28 | 148.8 | 149.13 | 121150.0 |
| 2021-10-27 08:30:00 | AAPL | Stock | 149.13 | 149.42 | 149.13 | 149.4 | 129419.0 |
| 2021-10-27 09:00:00 | AAPL | Stock | 149.4 | 149.57 | 149.35 | 149.35 | 172126.0 |
| 2021-10-27 09:30:00 | AAPL | Stock | 149.38 | 149.69 | 148.49 | 149.39 | 7379795.0 |
| 2021-10-27 10:00:00 | AAPL | Stock | 149.39 | 149.41 | 148.49 | 148.71 | 4318122.0 |
| 2021-10-27 10:30:00 | AAPL | Stock | 148.72 | 149.1 | 148.7 | 148.795 | 2892291.0 |
| 2021-10-27 11:00:00 | AAPL | Stock | 148.8 | 149.395 | 148.7 | 149.335 | 2539304.0 |
| 2021-10-27 11:30:00 | AAPL | Stock | 149.33 | 149.5116 | 149.0255 | 149.18 | 2497259.0 |
| 2021-10-27 12:00:00 | AAPL | Stock | 149.1801 | 149.42 | 149.15 | 149.38 | 1976904.0 |
| 2021-10-27 12:30:00 | AAPL | Stock | 149.385 | 149.51 | 149.2399 | 149.43 | 1560500.0 |
| 2021-10-27 13:00:00 | AAPL | Stock | 149.43 | 149.72 | 149.395 | 149.635 | 2067914.0 |
| 2021-10-27 13:30:00 | AAPL | Stock | 149.6399 | 149.67 | 149.4 | 149.585 | 1836522.0 |
| 2021-10-27 14:00:00 | AAPL | Stock | 149.5875 | 149.685 | 149.51 | 149.56 | 1717158.0 |
| 2021-10-27 14:30:00 | AAPL | Stock | 149.57 | 149.73 | 149.45 | 149.47 | 2219527.0 |
| 2021-10-27 15:00:00 | AAPL | Stock | 149.47 | 149.55 | 148.945 | 149.19 | 2897427.0 |
| 2021-10-27 15:30:00 | AAPL | Stock | 149.185 | 149.33 | 148.8 | 148.85 | 4683861.0 |
| 2021-10-27 16:00:00 | AAPL | Stock | 148.85 | 149.1295 | 148.8 | 148.95 | 9349606.0 |
| 2021-10-27 16:30:00 | AAPL | Stock | 148.92 | 149.1 | 148.85 | 148.92 | 47446.0 |
| 2021-10-27 17:00:00 | AAPL | Stock | 148.97 | 149.08 | 148.89 | 148.97 | 24646.0 |
| 2021-10-27 17:30:00 | AAPL | Stock | 149.0 | 149.11 | 148.93 | 149.08 | 22930.0 |
| 2021-10-27 18:00:00 | AAPL | Stock | 149.09 | 149.17 | 149.07 | 149.1 | 36234.0 |
| 2021-10-27 18:30:00 | AAPL | Stock | 149.1 | 149.17 | 149.09 | 149.14 | 22114.0 |
| 2021-10-27 19:00:00 | AAPL | Stock | 149.17 | 149.17 | 149.03 | 149.17 | 32250.0 |
| 2021-10-27 19:30:00 | AAPL | Stock | 149.15 | 149.1699 | 149.0 | 149.07 | 62400.0 |
| 2021-10-27 04:00:00 | MSFT | Stock | 316.0 | 319.06 | 316.0 | 317.97 | 15367.0 |
| 2021-10-27 04:30:00 | MSFT | Stock | 318.0 | 318.2 | 316.92 | 317.3 | 4169.0 |
| 2021-10-27 05:00:00 | MSFT | Stock | 317.3 | 317.49 | 316.5 | 317.3 | 4139.0 |
| 2021-10-27 05:30:00 | MSFT | Stock | 317.1 | 317.4 | 316.9 | 317.05 | 6740.0 |
| 2021-10-27 06:00:00 | MSFT | Stock | 316.9 | 316.9 | 316.0 | 316.18 | 2285.0 |
| 2021-10-27 06:30:00 | MSFT | Stock | 316.26 | 316.5 | 315.64 | 315.85 | 6405.0 |
| 2021-10-27 07:00:00 | MSFT | Stock | 316.1 | 316.28 | 314.35 | 314.64 | 31603.0 |
| 2021-10-27 07:30:00 | MSFT | Stock | 314.65 | 315.13 | 314.1 | 314.11 | 16914.0 |
| 2021-10-27 08:00:00 | MSFT | Stock | 315.5299 | 316.0 | 314.1 | 314.32 | 101353.0 |
| 2021-10-27 08:30:00 | MSFT | Stock | 314.43 | 316.21 | 314.43 | 315.58 | 61433.0 |
| 2021-10-27 09:00:00 | MSFT | Stock | 315.58 | 316.95 | 315.31 | 316.05 | 127448.0 |
| 2021-10-27 09:30:00 | MSFT | Stock | 316.0 | 319.905 | 316.0 | 319.67 | 6386098.0 |
| 2021-10-27 10:00:00 | MSFT | Stock | 319.7 | 321.93 | 318.91 | 321.26 | 4017523.0 |
| 2021-10-27 10:30:00 | MSFT | Stock | 321.26 | 324.8 | 321.21 | 323.3935 | 4779591.0 |
| 2021-10-27 11:00:00 | MSFT | Stock | 323.3821 | 324.23 | 322.68 | 322.88 | 2343797.0 |
| 2021-10-27 11:30:00 | MSFT | Stock | 322.89 | 323.155 | 321.92 | 322.38 | 2119485.0 |
| 2021-10-27 12:00:00 | MSFT | Stock | 322.4 | 324.25 | 322.19 | 324.2 | 2408545.0 |
| 2021-10-27 12:30:00 | MSFT | Stock | 324.21 | 325.4 | 324.1 | 324.16 | 2051666.0 |
> showing 50 of 112,146 rows — these rows as CSV