PREVIEW / stock_30min / 2024-02-06
file: by_date/stock_30min/2024/2024-02-06.parquet size: 2.0 MB rows: 98,137 symbols: 1,151
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 |
|---|---|---|---|---|---|---|---|
| 2024-02-06 04:00:00 | AAPL | Stock | 188.4 | 188.4 | 187.9 | 187.9 | 8275.0 |
| 2024-02-06 04:30:00 | AAPL | Stock | 187.92 | 187.98 | 187.8 | 187.88 | 3535.0 |
| 2024-02-06 05:00:00 | AAPL | Stock | 187.86 | 187.92 | 187.8 | 187.83 | 3115.0 |
| 2024-02-06 05:30:00 | AAPL | Stock | 187.8 | 187.89 | 187.67 | 187.89 | 5291.0 |
| 2024-02-06 06:00:00 | AAPL | Stock | 187.95 | 188.28 | 187.95 | 188.09 | 4804.0 |
| 2024-02-06 06:30:00 | AAPL | Stock | 188.07 | 188.08 | 187.6 | 187.66 | 7028.0 |
| 2024-02-06 07:00:00 | AAPL | Stock | 187.8 | 187.83 | 187.5 | 187.53 | 17808.0 |
| 2024-02-06 07:30:00 | AAPL | Stock | 187.5 | 187.64 | 187.33 | 187.55 | 8013.0 |
| 2024-02-06 08:00:00 | AAPL | Stock | 187.8 | 188.24 | 187.2703 | 187.69 | 58600.0 |
| 2024-02-06 08:30:00 | AAPL | Stock | 187.65 | 187.74 | 187.6 | 187.69 | 14754.0 |
| 2024-02-06 09:00:00 | AAPL | Stock | 187.69 | 187.7337 | 186.52 | 186.85 | 115683.0 |
| 2024-02-06 09:30:00 | AAPL | Stock | 186.9 | 188.63 | 186.7695 | 187.9571 | 4332970.0 |
| 2024-02-06 10:00:00 | AAPL | Stock | 187.96 | 188.31 | 187.7 | 187.93 | 3114374.0 |
| 2024-02-06 10:30:00 | AAPL | Stock | 187.91 | 188.205 | 187.27 | 187.725 | 2568421.0 |
| 2024-02-06 11:00:00 | AAPL | Stock | 187.71 | 188.86 | 187.7 | 188.815 | 2661652.0 |
| 2024-02-06 11:30:00 | AAPL | Stock | 188.82 | 189.02 | 188.41 | 188.815 | 2061389.0 |
| 2024-02-06 12:00:00 | AAPL | Stock | 188.82 | 189.14 | 188.7 | 188.84 | 1960938.0 |
| 2024-02-06 12:30:00 | AAPL | Stock | 188.84 | 188.87 | 188.43 | 188.53 | 1218979.0 |
| 2024-02-06 13:00:00 | AAPL | Stock | 188.54 | 189.0 | 188.512 | 188.89 | 1796515.0 |
| 2024-02-06 13:30:00 | AAPL | Stock | 188.895 | 188.94 | 188.7501 | 188.775 | 1209264.0 |
| 2024-02-06 14:00:00 | AAPL | Stock | 188.775 | 188.8154 | 188.3611 | 188.4485 | 1305979.0 |
| 2024-02-06 14:30:00 | AAPL | Stock | 188.45 | 188.61 | 188.23 | 188.5701 | 1222416.0 |
| 2024-02-06 15:00:00 | AAPL | Stock | 188.58 | 188.6383 | 188.24 | 188.355 | 1390158.0 |
| 2024-02-06 15:30:00 | AAPL | Stock | 188.36 | 189.31 | 188.17 | 189.29 | 4113000.0 |
| 2024-02-06 16:00:00 | AAPL | Stock | 189.17 | 189.32 | 189.1 | 189.1 | 4978145.0 |
| 2024-02-06 16:30:00 | AAPL | Stock | 189.08 | 189.3 | 189.08 | 189.18 | 84103.0 |
| 2024-02-06 17:00:00 | AAPL | Stock | 189.18 | 189.39 | 189.18 | 189.39 | 36469.0 |
| 2024-02-06 17:30:00 | AAPL | Stock | 189.3 | 189.35 | 189.16 | 189.26 | 13348.0 |
| 2024-02-06 18:00:00 | AAPL | Stock | 189.28 | 189.59 | 189.28 | 189.58 | 21927.0 |
| 2024-02-06 18:30:00 | AAPL | Stock | 189.5457 | 189.87 | 189.5457 | 189.69 | 37853.0 |
| 2024-02-06 19:00:00 | AAPL | Stock | 189.68 | 189.73 | 189.26 | 189.62 | 36542.0 |
| 2024-02-06 19:30:00 | AAPL | Stock | 189.53 | 190.0 | 189.5 | 190.0 | 59018.0 |
| 2024-02-06 04:00:00 | MSFT | Stock | 407.55 | 407.55 | 407.22 | 407.22 | 300.0 |
| 2024-02-06 04:30:00 | MSFT | Stock | 407.24 | 407.4 | 407.21 | 407.21 | 1459.0 |
| 2024-02-06 05:00:00 | MSFT | Stock | 407.21 | 407.22 | 406.56 | 406.56 | 1070.0 |
| 2024-02-06 05:30:00 | MSFT | Stock | 406.83 | 406.95 | 406.75 | 406.95 | 2376.0 |
| 2024-02-06 06:00:00 | MSFT | Stock | 406.79 | 406.85 | 406.34 | 406.34 | 4057.0 |
| 2024-02-06 06:30:00 | MSFT | Stock | 406.0 | 406.2 | 405.01 | 405.01 | 7784.0 |
| 2024-02-06 07:00:00 | MSFT | Stock | 405.2 | 405.2 | 404.8 | 404.8 | 4675.0 |
| 2024-02-06 07:30:00 | MSFT | Stock | 404.7 | 405.46 | 404.7 | 404.83 | 7697.0 |
| 2024-02-06 08:00:00 | MSFT | Stock | 405.2 | 407.64 | 404.61 | 405.95 | 26065.0 |
| 2024-02-06 08:30:00 | MSFT | Stock | 405.98 | 406.74 | 405.98 | 406.1 | 15060.0 |
| 2024-02-06 09:00:00 | MSFT | Stock | 406.19 | 407.12 | 405.67 | 405.87 | 25685.0 |
| 2024-02-06 09:30:00 | MSFT | Stock | 405.87 | 407.97 | 405.03 | 405.03 | 2068032.0 |
| 2024-02-06 10:00:00 | MSFT | Stock | 405.01 | 405.37 | 403.56 | 404.58 | 1048332.0 |
| 2024-02-06 10:30:00 | MSFT | Stock | 404.56 | 404.85 | 404.09 | 404.72 | 907601.0 |
| 2024-02-06 11:00:00 | MSFT | Stock | 404.71 | 405.16 | 403.95 | 404.13 | 692346.0 |
| 2024-02-06 11:30:00 | MSFT | Stock | 404.12 | 405.01 | 403.22 | 403.93 | 730591.0 |
| 2024-02-06 12:00:00 | MSFT | Stock | 403.97 | 404.48 | 403.67 | 404.13 | 774879.0 |
| 2024-02-06 12:30:00 | MSFT | Stock | 404.14 | 404.26 | 403.5514 | 403.6201 | 496064.0 |
> showing 50 of 98,137 rows — these rows as CSV