PREVIEW / stock_30min / 2024-02-01
file: by_date/stock_30min/2024/2024-02-01.parquet size: 2.1 MB rows: 99,204 symbols: 1,156
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-01 04:00:00 | AAPL | Stock | 185.49 | 185.9 | 185.49 | 185.76 | 3624.0 |
| 2024-02-01 04:30:00 | AAPL | Stock | 185.75 | 185.75 | 185.45 | 185.51 | 6326.0 |
| 2024-02-01 05:00:00 | AAPL | Stock | 185.4 | 185.41 | 185.37 | 185.4 | 9270.0 |
| 2024-02-01 05:30:00 | AAPL | Stock | 185.4 | 185.69 | 185.36 | 185.69 | 12253.0 |
| 2024-02-01 06:00:00 | AAPL | Stock | 185.65 | 185.65 | 185.11 | 185.11 | 4149.0 |
| 2024-02-01 06:30:00 | AAPL | Stock | 185.06 | 185.88 | 185.06 | 185.6 | 20230.0 |
| 2024-02-01 07:00:00 | AAPL | Stock | 185.64 | 185.76 | 185.44 | 185.64 | 22398.0 |
| 2024-02-01 07:30:00 | AAPL | Stock | 185.55 | 185.82 | 185.55 | 185.7 | 9301.0 |
| 2024-02-01 08:00:00 | AAPL | Stock | 185.7 | 186.0786 | 185.26 | 185.52 | 100049.0 |
| 2024-02-01 08:30:00 | AAPL | Stock | 185.55 | 185.86 | 185.24 | 185.3096 | 85834.0 |
| 2024-02-01 09:00:00 | AAPL | Stock | 185.25 | 185.64 | 183.98 | 184.1 | 243640.0 |
| 2024-02-01 09:30:00 | AAPL | Stock | 184.01 | 185.64 | 183.81 | 185.5 | 5380906.0 |
| 2024-02-01 10:00:00 | AAPL | Stock | 185.46 | 186.18 | 184.9 | 186.105 | 3005567.0 |
| 2024-02-01 10:30:00 | AAPL | Stock | 186.12 | 186.31 | 185.35 | 185.3706 | 2611195.0 |
| 2024-02-01 11:00:00 | AAPL | Stock | 185.37 | 186.07 | 185.29 | 185.395 | 2028341.0 |
| 2024-02-01 11:30:00 | AAPL | Stock | 185.39 | 185.895 | 185.36 | 185.682 | 1819507.0 |
| 2024-02-01 12:00:00 | AAPL | Stock | 185.68 | 186.295 | 185.66 | 185.89 | 2043509.0 |
| 2024-02-01 12:30:00 | AAPL | Stock | 185.89 | 186.44 | 185.64 | 186.12 | 2033442.0 |
| 2024-02-01 13:00:00 | AAPL | Stock | 186.13 | 186.19 | 185.57 | 185.73 | 1558740.0 |
| 2024-02-01 13:30:00 | AAPL | Stock | 185.74 | 185.96 | 185.26 | 185.795 | 1722604.0 |
| 2024-02-01 14:00:00 | AAPL | Stock | 185.8 | 186.155 | 185.55 | 185.975 | 1877483.0 |
| 2024-02-01 14:30:00 | AAPL | Stock | 185.9799 | 186.62 | 185.8811 | 186.475 | 2147356.0 |
| 2024-02-01 15:00:00 | AAPL | Stock | 186.47 | 186.8 | 186.28 | 186.66 | 2822261.0 |
| 2024-02-01 15:30:00 | AAPL | Stock | 186.65 | 186.95 | 186.36 | 186.89 | 5648418.0 |
| 2024-02-01 16:00:00 | AAPL | Stock | 186.89 | 188.81 | 186.21 | 188.5 | 6390251.0 |
| 2024-02-01 16:30:00 | AAPL | Stock | 188.5 | 191.81 | 181.5 | 184.66 | 3792774.0 |
| 2024-02-01 17:00:00 | AAPL | Stock | 184.71 | 185.75 | 182.55 | 184.02 | 1225128.0 |
| 2024-02-01 17:30:00 | AAPL | Stock | 184.0 | 184.39 | 179.1 | 180.61 | 2383598.0 |
| 2024-02-01 18:00:00 | AAPL | Stock | 180.61 | 181.37 | 180.28 | 180.77 | 361681.0 |
| 2024-02-01 18:30:00 | AAPL | Stock | 180.79 | 181.25 | 180.6 | 180.95 | 215959.0 |
| 2024-02-01 19:00:00 | AAPL | Stock | 180.86 | 181.2 | 180.79 | 181.1 | 129700.0 |
| 2024-02-01 19:30:00 | AAPL | Stock | 181.1 | 181.58 | 181.03 | 181.4 | 183180.0 |
| 2024-02-01 04:00:00 | MSFT | Stock | 400.15 | 400.71 | 399.45 | 400.71 | 9474.0 |
| 2024-02-01 04:30:00 | MSFT | Stock | 400.79 | 400.95 | 400.47 | 400.47 | 3429.0 |
| 2024-02-01 05:00:00 | MSFT | Stock | 400.56 | 401.85 | 400.56 | 401.13 | 5875.0 |
| 2024-02-01 05:30:00 | MSFT | Stock | 401.09 | 401.66 | 401.0 | 401.28 | 9673.0 |
| 2024-02-01 06:00:00 | MSFT | Stock | 401.28 | 402.59 | 401.28 | 402.25 | 20282.0 |
| 2024-02-01 06:30:00 | MSFT | Stock | 402.0 | 402.0 | 401.2 | 401.4 | 16539.0 |
| 2024-02-01 07:00:00 | MSFT | Stock | 401.54 | 401.58 | 400.61 | 400.95 | 17217.0 |
| 2024-02-01 07:30:00 | MSFT | Stock | 400.85 | 402.0 | 400.5 | 401.25 | 17941.0 |
| 2024-02-01 08:00:00 | MSFT | Stock | 400.9 | 401.68 | 398.81 | 400.98 | 108654.0 |
| 2024-02-01 08:30:00 | MSFT | Stock | 401.0 | 402.0 | 400.5796 | 401.59 | 52094.0 |
| 2024-02-01 09:00:00 | MSFT | Stock | 401.71 | 402.37 | 400.85 | 401.99 | 85266.0 |
| 2024-02-01 09:30:00 | MSFT | Stock | 401.98 | 406.2899 | 401.8 | 406.0 | 4740817.0 |
| 2024-02-01 10:00:00 | MSFT | Stock | 405.96 | 408.0 | 405.2 | 406.622 | 2650470.0 |
| 2024-02-01 10:30:00 | MSFT | Stock | 406.6417 | 406.83 | 403.36 | 403.6801 | 1645556.0 |
| 2024-02-01 11:00:00 | MSFT | Stock | 403.7 | 403.97 | 402.55 | 403.91 | 1169340.0 |
| 2024-02-01 11:30:00 | MSFT | Stock | 403.93 | 404.42 | 403.6 | 403.76 | 878845.0 |
| 2024-02-01 12:00:00 | MSFT | Stock | 403.83 | 404.51 | 403.09 | 403.16 | 840370.0 |
| 2024-02-01 12:30:00 | MSFT | Stock | 403.17 | 405.11 | 402.68 | 404.0 | 1070577.0 |
> showing 50 of 99,204 rows — these rows as CSV