PREVIEW / stock_30min / 2022-12-13
file: by_date/stock_30min/2022/2022-12-13.parquet size: 2.2 MB rows: 106,711 symbols: 2,039
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-12-13 04:00:00 | AAPL | Stock | 144.74 | 144.89 | 144.4 | 144.89 | 12502.0 |
| 2022-12-13 04:30:00 | AAPL | Stock | 144.89 | 144.92 | 144.69 | 144.69 | 14445.0 |
| 2022-12-13 05:00:00 | AAPL | Stock | 144.73 | 144.97 | 144.67 | 144.97 | 15044.0 |
| 2022-12-13 05:30:00 | AAPL | Stock | 144.91 | 144.99 | 144.85 | 144.89 | 8321.0 |
| 2022-12-13 06:00:00 | AAPL | Stock | 144.89 | 144.96 | 144.89 | 144.96 | 20272.0 |
| 2022-12-13 06:30:00 | AAPL | Stock | 144.98 | 145.14 | 144.93 | 145.08 | 21909.0 |
| 2022-12-13 07:00:00 | AAPL | Stock | 145.08 | 145.35 | 144.96 | 145.26 | 22502.0 |
| 2022-12-13 07:30:00 | AAPL | Stock | 145.28 | 145.73 | 145.28 | 145.71 | 44927.0 |
| 2022-12-13 08:00:00 | AAPL | Stock | 145.0379 | 146.83 | 144.0 | 146.83 | 270454.0 |
| 2022-12-13 08:30:00 | AAPL | Stock | 146.8 | 151.0 | 146.55 | 149.45 | 1125322.0 |
| 2022-12-13 09:00:00 | AAPL | Stock | 149.53 | 150.01 | 149.01 | 149.43 | 610974.0 |
| 2022-12-13 09:30:00 | AAPL | Stock | 149.47 | 149.9692 | 148.785 | 149.29 | 10234416.0 |
| 2022-12-13 10:00:00 | AAPL | Stock | 149.29 | 149.37 | 147.94 | 148.09 | 7248024.0 |
| 2022-12-13 10:30:00 | AAPL | Stock | 148.0801 | 148.23 | 146.91 | 147.86 | 5180474.0 |
| 2022-12-13 11:00:00 | AAPL | Stock | 147.87 | 148.3496 | 147.28 | 147.56 | 4333629.0 |
| 2022-12-13 11:30:00 | AAPL | Stock | 147.565 | 148.1082 | 145.668 | 146.2 | 4569392.0 |
| 2022-12-13 12:00:00 | AAPL | Stock | 146.2008 | 146.37 | 144.61 | 144.8 | 4418372.0 |
| 2022-12-13 12:30:00 | AAPL | Stock | 144.795 | 145.31 | 144.24 | 145.065 | 4429714.0 |
| 2022-12-13 13:00:00 | AAPL | Stock | 145.08 | 145.63 | 144.53 | 145.545 | 3289204.0 |
| 2022-12-13 13:30:00 | AAPL | Stock | 145.54 | 145.77 | 144.84 | 145.3 | 2835010.0 |
| 2022-12-13 14:00:00 | AAPL | Stock | 145.3 | 145.49 | 144.28 | 145.1 | 4884339.0 |
| 2022-12-13 14:30:00 | AAPL | Stock | 145.09 | 146.14 | 144.98 | 145.14 | 4083033.0 |
| 2022-12-13 15:00:00 | AAPL | Stock | 145.1336 | 145.4199 | 144.32 | 145.41 | 4392810.0 |
| 2022-12-13 15:30:00 | AAPL | Stock | 145.4 | 145.97 | 145.13 | 145.49 | 5794946.0 |
| 2022-12-13 16:00:00 | AAPL | Stock | 145.48 | 145.48 | 145.21 | 145.3 | 12540776.0 |
| 2022-12-13 16:30:00 | AAPL | Stock | 145.3 | 145.47 | 145.29 | 145.3416 | 57158.0 |
| 2022-12-13 17:00:00 | AAPL | Stock | 145.34 | 145.47 | 145.31 | 145.39 | 11965.0 |
| 2022-12-13 17:30:00 | AAPL | Stock | 145.38 | 145.45 | 145.38 | 145.45 | 12178.0 |
| 2022-12-13 18:00:00 | AAPL | Stock | 145.45 | 145.5 | 145.4 | 145.4 | 10247.0 |
| 2022-12-13 18:30:00 | AAPL | Stock | 145.4 | 145.45 | 145.4 | 145.41 | 3897.0 |
| 2022-12-13 19:00:00 | AAPL | Stock | 145.41 | 145.51 | 145.4 | 145.5 | 10983.0 |
| 2022-12-13 19:30:00 | AAPL | Stock | 145.5 | 145.6 | 145.42 | 145.49 | 22588.0 |
| 2022-12-13 04:00:00 | MSFT | Stock | 252.52 | 252.79 | 252.52 | 252.79 | 1787.0 |
| 2022-12-13 04:30:00 | MSFT | Stock | 253.0 | 253.25 | 252.82 | 252.82 | 800.0 |
| 2022-12-13 05:00:00 | MSFT | Stock | 252.92 | 253.69 | 252.9 | 253.69 | 2813.0 |
| 2022-12-13 05:30:00 | MSFT | Stock | 253.69 | 254.0 | 253.69 | 254.0 | 780.0 |
| 2022-12-13 06:00:00 | MSFT | Stock | 254.1 | 254.5 | 254.1 | 254.4 | 2227.0 |
| 2022-12-13 06:30:00 | MSFT | Stock | 254.45 | 255.02 | 254.39 | 254.71 | 8261.0 |
| 2022-12-13 07:00:00 | MSFT | Stock | 254.5 | 254.8 | 254.3 | 254.8 | 4172.0 |
| 2022-12-13 07:30:00 | MSFT | Stock | 254.94 | 255.97 | 254.94 | 255.5 | 55369.0 |
| 2022-12-13 08:00:00 | MSFT | Stock | 254.8729 | 257.0 | 251.879 | 257.0 | 62857.0 |
| 2022-12-13 08:30:00 | MSFT | Stock | 257.0 | 265.0 | 257.0 | 262.5 | 226570.0 |
| 2022-12-13 09:00:00 | MSFT | Stock | 262.6 | 263.75 | 261.4 | 261.6 | 165862.0 |
| 2022-12-13 09:30:00 | MSFT | Stock | 261.76 | 263.915 | 260.87 | 262.32 | 4413554.0 |
| 2022-12-13 10:00:00 | MSFT | Stock | 262.34 | 262.52 | 258.82 | 259.63 | 2541472.0 |
| 2022-12-13 10:30:00 | MSFT | Stock | 259.61 | 260.5 | 258.4 | 259.91 | 1877844.0 |
| 2022-12-13 11:00:00 | MSFT | Stock | 259.95 | 261.28 | 259.38 | 259.945 | 1874179.0 |
| 2022-12-13 11:30:00 | MSFT | Stock | 259.96 | 261.2 | 257.32 | 257.95 | 1729068.0 |
| 2022-12-13 12:00:00 | MSFT | Stock | 257.95 | 258.37 | 253.96 | 254.23 | 1636993.0 |
| 2022-12-13 12:30:00 | MSFT | Stock | 254.21 | 255.33 | 253.07 | 254.67 | 1342564.0 |
> showing 50 of 106,711 rows — these rows as CSV