PREVIEW / stock_30min / 2021-09-30
file: by_date/stock_30min/2021/2021-09-30.parquet size: 2.2 MB rows: 110,790 symbols: 2,751
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-09-30 04:00:00 | AAPL | Stock | 144.0 | 144.13 | 143.77 | 143.95 | 17445.0 |
| 2021-09-30 04:30:00 | AAPL | Stock | 143.8 | 143.92 | 143.8 | 143.92 | 710.0 |
| 2021-09-30 05:00:00 | AAPL | Stock | 143.98 | 143.98 | 143.72 | 143.75 | 2300.0 |
| 2021-09-30 05:30:00 | AAPL | Stock | 143.61 | 143.7 | 143.51 | 143.7 | 5336.0 |
| 2021-09-30 06:00:00 | AAPL | Stock | 143.96 | 143.98 | 143.37 | 143.37 | 4382.0 |
| 2021-09-30 06:30:00 | AAPL | Stock | 143.55 | 143.62 | 143.46 | 143.46 | 1633.0 |
| 2021-09-30 07:00:00 | AAPL | Stock | 143.57 | 143.64 | 143.4 | 143.44 | 34129.0 |
| 2021-09-30 07:30:00 | AAPL | Stock | 143.44 | 143.47 | 143.25 | 143.45 | 23588.0 |
| 2021-09-30 08:00:00 | AAPL | Stock | 143.5497 | 143.62 | 143.187 | 143.44 | 207345.0 |
| 2021-09-30 08:30:00 | AAPL | Stock | 143.49 | 143.65 | 143.43 | 143.58 | 123018.0 |
| 2021-09-30 09:00:00 | AAPL | Stock | 143.56 | 143.68 | 143.28 | 143.66 | 194296.0 |
| 2021-09-30 09:30:00 | AAPL | Stock | 143.66 | 144.378 | 143.21 | 143.3501 | 8423818.0 |
| 2021-09-30 10:00:00 | AAPL | Stock | 143.3571 | 143.46 | 142.85 | 143.035 | 5414452.0 |
| 2021-09-30 10:30:00 | AAPL | Stock | 143.03 | 143.13 | 142.5035 | 142.63 | 4644698.0 |
| 2021-09-30 11:00:00 | AAPL | Stock | 142.62 | 143.11 | 142.5499 | 143.03 | 3910019.0 |
| 2021-09-30 11:30:00 | AAPL | Stock | 143.04 | 143.1 | 141.9 | 142.11 | 5838147.0 |
| 2021-09-30 12:00:00 | AAPL | Stock | 142.12 | 142.17 | 141.3001 | 141.46 | 5806875.0 |
| 2021-09-30 12:30:00 | AAPL | Stock | 141.46 | 141.94 | 141.28 | 141.7799 | 4085403.0 |
| 2021-09-30 13:00:00 | AAPL | Stock | 141.78 | 142.29 | 141.69 | 141.825 | 3447701.0 |
| 2021-09-30 13:30:00 | AAPL | Stock | 141.825 | 142.29 | 141.66 | 142.2701 | 3379325.0 |
| 2021-09-30 14:00:00 | AAPL | Stock | 142.272 | 142.73 | 142.23 | 142.655 | 3609543.0 |
| 2021-09-30 14:30:00 | AAPL | Stock | 142.65 | 143.0 | 142.4448 | 142.45 | 3557823.0 |
| 2021-09-30 15:00:00 | AAPL | Stock | 142.45 | 142.98 | 142.3 | 142.71 | 4445381.0 |
| 2021-09-30 15:30:00 | AAPL | Stock | 142.71 | 143.06 | 141.3 | 141.32 | 12383028.0 |
| 2021-09-30 16:00:00 | AAPL | Stock | 141.35 | 142.8348 | 141.35 | 141.62 | 9867560.0 |
| 2021-09-30 16:30:00 | AAPL | Stock | 141.61 | 141.61 | 141.5 | 141.57 | 38600.0 |
| 2021-09-30 17:00:00 | AAPL | Stock | 141.6 | 141.76 | 141.52 | 141.76 | 23288.0 |
| 2021-09-30 17:30:00 | AAPL | Stock | 141.76 | 141.76 | 141.64 | 141.72 | 21724.0 |
| 2021-09-30 18:00:00 | AAPL | Stock | 141.73 | 141.85 | 141.62 | 141.69 | 43832.0 |
| 2021-09-30 18:30:00 | AAPL | Stock | 141.69 | 141.74 | 141.69 | 141.74 | 9292.0 |
| 2021-09-30 19:00:00 | AAPL | Stock | 141.74 | 141.98 | 141.7 | 141.88 | 36156.0 |
| 2021-09-30 19:30:00 | AAPL | Stock | 141.88 | 141.91 | 141.66 | 141.76 | 39587.0 |
| 2021-09-30 04:00:00 | MSFT | Stock | 286.0 | 286.29 | 285.9 | 285.96 | 444.0 |
| 2021-09-30 04:30:00 | MSFT | Stock | 285.84 | 286.29 | 285.72 | 286.29 | 577.0 |
| 2021-09-30 05:00:00 | MSFT | Stock | 286.19 | 286.2 | 285.9 | 285.93 | 1580.0 |
| 2021-09-30 05:30:00 | MSFT | Stock | 285.77 | 285.77 | 285.77 | 285.77 | 100.0 |
| 2021-09-30 06:00:00 | MSFT | Stock | 285.6 | 285.6 | 285.18 | 285.18 | 482.0 |
| 2021-09-30 07:00:00 | MSFT | Stock | 285.34 | 285.5 | 284.81 | 285.0 | 3128.0 |
| 2021-09-30 07:30:00 | MSFT | Stock | 285.0 | 285.01 | 284.82 | 284.98 | 2105.0 |
| 2021-09-30 08:00:00 | MSFT | Stock | 285.35 | 285.5 | 284.61 | 285.15 | 16159.0 |
| 2021-09-30 08:30:00 | MSFT | Stock | 285.28 | 285.77 | 285.25 | 285.4 | 14408.0 |
| 2021-09-30 09:00:00 | MSFT | Stock | 285.42 | 285.81 | 284.8 | 285.81 | 23160.0 |
| 2021-09-30 09:30:00 | MSFT | Stock | 285.66 | 287.36 | 284.86 | 286.47 | 2261252.0 |
| 2021-09-30 10:00:00 | MSFT | Stock | 286.47 | 287.83 | 285.94 | 287.74 | 1607148.0 |
| 2021-09-30 10:30:00 | MSFT | Stock | 287.73 | 287.79 | 285.86 | 285.9729 | 1216508.0 |
| 2021-09-30 11:00:00 | MSFT | Stock | 285.92 | 287.09 | 285.815 | 286.3394 | 1144703.0 |
| 2021-09-30 11:30:00 | MSFT | Stock | 286.33 | 286.37 | 283.78 | 284.17 | 1693153.0 |
| 2021-09-30 12:00:00 | MSFT | Stock | 284.18 | 284.27 | 281.89 | 282.45 | 1703446.0 |
| 2021-09-30 12:30:00 | MSFT | Stock | 282.455 | 283.3 | 282.01 | 282.21 | 1400134.0 |
| 2021-09-30 13:00:00 | MSFT | Stock | 282.1771 | 283.83 | 282.02 | 282.59 | 985360.0 |
> showing 50 of 110,790 rows — these rows as CSV