PREVIEW / stock_30min / 2021-04-13
file: by_date/stock_30min/2021/2021-04-13.parquet size: 2.2 MB rows: 111,963 symbols: 2,950
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-13 04:00:00 | AAPL | Stock | 131.03 | 131.22 | 130.92 | 131.0 | 7840.0 |
| 2021-04-13 04:30:00 | AAPL | Stock | 131.0 | 131.04 | 130.81 | 130.81 | 6608.0 |
| 2021-04-13 05:00:00 | AAPL | Stock | 130.87 | 130.89 | 130.8 | 130.89 | 2999.0 |
| 2021-04-13 05:30:00 | AAPL | Stock | 130.82 | 131.09 | 130.81 | 131.09 | 13751.0 |
| 2021-04-13 06:00:00 | AAPL | Stock | 131.08 | 131.08 | 130.85 | 130.85 | 2734.0 |
| 2021-04-13 06:30:00 | AAPL | Stock | 130.82 | 130.91 | 130.71 | 130.71 | 2868.0 |
| 2021-04-13 07:00:00 | AAPL | Stock | 130.84 | 130.94 | 130.67 | 130.74 | 83114.0 |
| 2021-04-13 07:30:00 | AAPL | Stock | 130.75 | 130.91 | 130.62 | 130.78 | 59219.0 |
| 2021-04-13 08:00:00 | AAPL | Stock | 130.8 | 131.568 | 130.65 | 131.11 | 274614.0 |
| 2021-04-13 08:30:00 | AAPL | Stock | 131.07 | 131.95 | 130.91 | 131.85 | 417470.0 |
| 2021-04-13 09:00:00 | AAPL | Stock | 131.84 | 132.51 | 131.38 | 132.47 | 403711.0 |
| 2021-04-13 09:30:00 | AAPL | Stock | 132.49 | 133.69 | 131.93 | 133.115 | 12711984.0 |
| 2021-04-13 10:00:00 | AAPL | Stock | 133.12 | 133.3499 | 132.77 | 133.313 | 6397304.0 |
| 2021-04-13 10:30:00 | AAPL | Stock | 133.315 | 133.64 | 133.09 | 133.155 | 5404233.0 |
| 2021-04-13 11:00:00 | AAPL | Stock | 133.155 | 133.435 | 132.915 | 133.02 | 3783141.0 |
| 2021-04-13 11:30:00 | AAPL | Stock | 133.011 | 133.185 | 132.82 | 133.053 | 3287807.0 |
| 2021-04-13 12:00:00 | AAPL | Stock | 133.06 | 134.33 | 133.0 | 134.08 | 9968028.0 |
| 2021-04-13 12:30:00 | AAPL | Stock | 134.09 | 134.66 | 134.04 | 134.13 | 5844463.0 |
| 2021-04-13 13:00:00 | AAPL | Stock | 134.135 | 134.43 | 134.09 | 134.12 | 3321575.0 |
| 2021-04-13 13:30:00 | AAPL | Stock | 134.127 | 134.53 | 134.0701 | 134.27 | 2923395.0 |
| 2021-04-13 14:00:00 | AAPL | Stock | 134.2757 | 134.3 | 134.05 | 134.2701 | 3002111.0 |
| 2021-04-13 14:30:00 | AAPL | Stock | 134.2799 | 134.55 | 134.2527 | 134.36 | 3231266.0 |
| 2021-04-13 15:00:00 | AAPL | Stock | 134.355 | 134.6 | 134.22 | 134.585 | 4233727.0 |
| 2021-04-13 15:30:00 | AAPL | Stock | 134.59 | 134.64 | 134.29 | 134.41 | 6949897.0 |
| 2021-04-13 16:00:00 | AAPL | Stock | 134.43 | 134.59 | 134.4 | 134.53 | 7867635.0 |
| 2021-04-13 16:30:00 | AAPL | Stock | 134.53 | 134.55 | 134.44 | 134.46 | 51417.0 |
| 2021-04-13 17:00:00 | AAPL | Stock | 134.44 | 134.48 | 134.31 | 134.43 | 53776.0 |
| 2021-04-13 17:30:00 | AAPL | Stock | 134.43 | 134.45 | 134.35 | 134.35 | 31188.0 |
| 2021-04-13 18:00:00 | AAPL | Stock | 134.35 | 134.4 | 134.2601 | 134.33 | 30020.0 |
| 2021-04-13 18:30:00 | AAPL | Stock | 134.32 | 134.37 | 134.24 | 134.28 | 17458.0 |
| 2021-04-13 19:00:00 | AAPL | Stock | 134.28 | 134.28 | 134.2 | 134.21 | 40834.0 |
| 2021-04-13 19:30:00 | AAPL | Stock | 134.21 | 134.3 | 134.19 | 134.22 | 78288.0 |
| 2021-04-13 04:00:00 | MSFT | Stock | 256.36 | 256.67 | 256.36 | 256.67 | 200.0 |
| 2021-04-13 04:30:00 | MSFT | Stock | 256.63 | 256.63 | 256.14 | 256.14 | 637.0 |
| 2021-04-13 05:00:00 | MSFT | Stock | 256.06 | 256.41 | 255.71 | 256.41 | 2819.0 |
| 2021-04-13 05:30:00 | MSFT | Stock | 256.16 | 256.23 | 256.16 | 256.22 | 468.0 |
| 2021-04-13 06:00:00 | MSFT | Stock | 256.51 | 256.51 | 256.05 | 256.05 | 758.0 |
| 2021-04-13 07:00:00 | MSFT | Stock | 256.13 | 256.15 | 255.5 | 256.02 | 11574.0 |
| 2021-04-13 07:30:00 | MSFT | Stock | 256.13 | 256.55 | 255.98 | 255.98 | 3979.0 |
| 2021-04-13 08:00:00 | MSFT | Stock | 255.91 | 256.58 | 255.14 | 256.47 | 42499.0 |
| 2021-04-13 08:30:00 | MSFT | Stock | 256.32 | 257.71 | 256.04 | 257.5 | 33196.0 |
| 2021-04-13 09:00:00 | MSFT | Stock | 257.4804 | 257.677 | 256.89 | 257.13 | 30325.0 |
| 2021-04-13 09:30:00 | MSFT | Stock | 257.25 | 259.19 | 256.93 | 258.895 | 2570836.0 |
| 2021-04-13 10:00:00 | MSFT | Stock | 258.93 | 259.0 | 257.0 | 257.52 | 1799636.0 |
| 2021-04-13 10:30:00 | MSFT | Stock | 257.5399 | 257.99 | 257.15 | 257.475 | 880759.0 |
| 2021-04-13 11:00:00 | MSFT | Stock | 257.475 | 257.6606 | 256.83 | 257.5471 | 978515.0 |
| 2021-04-13 11:30:00 | MSFT | Stock | 257.54 | 257.6 | 256.86 | 257.16 | 706993.0 |
| 2021-04-13 12:00:00 | MSFT | Stock | 257.16 | 258.06 | 257.09 | 257.92 | 910619.0 |
| 2021-04-13 12:30:00 | MSFT | Stock | 257.9101 | 257.99 | 257.2 | 257.3509 | 818373.0 |
| 2021-04-13 13:00:00 | MSFT | Stock | 257.35 | 257.699 | 257.27 | 257.5922 | 622977.0 |
> showing 50 of 111,963 rows — these rows as CSV