PREVIEW / stock_30min / 2022-08-30
file: by_date/stock_30min/2022/2022-08-30.parquet size: 2.1 MB rows: 103,454 symbols: 2,196
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 |
|---|---|---|---|---|---|---|---|
| 2022-08-30 04:00:00 | AAPL | Stock | 161.82 | 163.34 | 161.82 | 163.21 | 26076.0 |
| 2022-08-30 04:30:00 | AAPL | Stock | 163.25 | 163.26 | 162.9 | 162.9 | 12090.0 |
| 2022-08-30 05:00:00 | AAPL | Stock | 162.99 | 163.0 | 162.82 | 162.9 | 9780.0 |
| 2022-08-30 05:30:00 | AAPL | Stock | 162.94 | 163.09 | 162.88 | 163.08 | 14544.0 |
| 2022-08-30 06:00:00 | AAPL | Stock | 162.98 | 163.24 | 162.98 | 163.09 | 8643.0 |
| 2022-08-30 06:30:00 | AAPL | Stock | 163.1 | 163.1 | 163.02 | 163.03 | 3205.0 |
| 2022-08-30 07:00:00 | AAPL | Stock | 163.0 | 163.1 | 162.84 | 162.9 | 45165.0 |
| 2022-08-30 07:30:00 | AAPL | Stock | 162.9 | 162.9 | 162.6 | 162.67 | 31335.0 |
| 2022-08-30 08:00:00 | AAPL | Stock | 162.67 | 163.11 | 162.25 | 162.6 | 216296.0 |
| 2022-08-30 08:30:00 | AAPL | Stock | 162.55 | 162.74 | 162.28 | 162.34 | 164762.0 |
| 2022-08-30 09:00:00 | AAPL | Stock | 162.34 | 162.57 | 162.07 | 162.17 | 123678.0 |
| 2022-08-30 09:30:00 | AAPL | Stock | 162.16 | 162.56 | 160.97 | 161.24 | 6946867.0 |
| 2022-08-30 10:00:00 | AAPL | Stock | 161.25 | 161.4893 | 159.72 | 160.13 | 5801474.0 |
| 2022-08-30 10:30:00 | AAPL | Stock | 160.1401 | 160.27 | 158.2249 | 159.1611 | 6757967.0 |
| 2022-08-30 11:00:00 | AAPL | Stock | 159.17 | 159.42 | 158.61 | 158.96 | 5601437.0 |
| 2022-08-30 11:30:00 | AAPL | Stock | 158.95 | 159.4399 | 158.84 | 159.2 | 3426305.0 |
| 2022-08-30 12:00:00 | AAPL | Stock | 159.2 | 159.66 | 158.8829 | 159.08 | 3230972.0 |
| 2022-08-30 12:30:00 | AAPL | Stock | 159.0848 | 159.107 | 158.31 | 158.7803 | 2866195.0 |
| 2022-08-30 13:00:00 | AAPL | Stock | 158.78 | 158.8999 | 157.9 | 158.35 | 3580847.0 |
| 2022-08-30 13:30:00 | AAPL | Stock | 158.34 | 158.71 | 157.72 | 158.49 | 3865802.0 |
| 2022-08-30 14:00:00 | AAPL | Stock | 158.49 | 158.815 | 158.2 | 158.26 | 2972308.0 |
| 2022-08-30 14:30:00 | AAPL | Stock | 158.26 | 158.73 | 158.18 | 158.451 | 2622105.0 |
| 2022-08-30 15:00:00 | AAPL | Stock | 158.4557 | 159.425 | 158.38 | 158.8776 | 4084102.0 |
| 2022-08-30 15:30:00 | AAPL | Stock | 158.89 | 159.18 | 158.12 | 158.91 | 6916029.0 |
| 2022-08-30 16:00:00 | AAPL | Stock | 158.92 | 159.3 | 158.91 | 159.19 | 5768018.0 |
| 2022-08-30 16:30:00 | AAPL | Stock | 159.19 | 159.3 | 158.91 | 159.14 | 35388.0 |
| 2022-08-30 17:00:00 | AAPL | Stock | 159.14 | 159.14 | 159.05 | 159.11 | 21590.0 |
| 2022-08-30 17:30:00 | AAPL | Stock | 159.1 | 159.15 | 158.91 | 159.1 | 33603.0 |
| 2022-08-30 18:00:00 | AAPL | Stock | 159.13 | 159.13 | 158.92 | 158.94 | 15309.0 |
| 2022-08-30 18:30:00 | AAPL | Stock | 158.95 | 159.12 | 158.95 | 159.06 | 15391.0 |
| 2022-08-30 19:00:00 | AAPL | Stock | 159.09 | 159.09 | 158.93 | 158.93 | 19699.0 |
| 2022-08-30 19:30:00 | AAPL | Stock | 158.95 | 158.99 | 158.85 | 158.97 | 18479.0 |
| 2022-08-30 04:00:00 | MSFT | Stock | 268.3 | 268.59 | 268.05 | 268.58 | 3251.0 |
| 2022-08-30 04:30:00 | MSFT | Stock | 268.4 | 268.5 | 268.4 | 268.4 | 1974.0 |
| 2022-08-30 05:00:00 | MSFT | Stock | 268.4 | 268.4 | 268.0 | 268.15 | 1294.0 |
| 2022-08-30 05:30:00 | MSFT | Stock | 268.25 | 268.25 | 268.25 | 268.25 | 626.0 |
| 2022-08-30 06:00:00 | MSFT | Stock | 268.35 | 268.35 | 268.35 | 268.35 | 373.0 |
| 2022-08-30 06:30:00 | MSFT | Stock | 268.4 | 268.4 | 268.02 | 268.02 | 836.0 |
| 2022-08-30 07:00:00 | MSFT | Stock | 267.88 | 268.08 | 267.6 | 267.6 | 5002.0 |
| 2022-08-30 07:30:00 | MSFT | Stock | 267.74 | 267.83 | 267.4 | 267.41 | 3714.0 |
| 2022-08-30 08:00:00 | MSFT | Stock | 267.74 | 268.15 | 266.8818 | 266.8818 | 20520.0 |
| 2022-08-30 08:30:00 | MSFT | Stock | 266.97 | 267.1 | 266.48 | 266.9999 | 11480.0 |
| 2022-08-30 09:00:00 | MSFT | Stock | 266.67 | 267.19 | 266.51 | 266.75 | 20089.0 |
| 2022-08-30 09:30:00 | MSFT | Stock | 266.72 | 267.05 | 265.0 | 265.4021 | 1473328.0 |
| 2022-08-30 10:00:00 | MSFT | Stock | 265.33 | 265.435 | 263.21 | 263.75 | 1123573.0 |
| 2022-08-30 10:30:00 | MSFT | Stock | 263.72 | 263.875 | 260.99 | 262.33 | 1078290.0 |
| 2022-08-30 11:00:00 | MSFT | Stock | 262.33 | 263.13 | 261.83 | 262.8025 | 848002.0 |
| 2022-08-30 11:30:00 | MSFT | Stock | 262.78 | 263.34 | 261.98 | 262.69 | 604386.0 |
| 2022-08-30 12:00:00 | MSFT | Stock | 262.6679 | 263.625 | 262.55 | 262.645 | 742292.0 |
| 2022-08-30 12:30:00 | MSFT | Stock | 262.64 | 262.68 | 261.665 | 262.21 | 430402.0 |
> showing 50 of 103,454 rows — these rows as CSV