PREVIEW / stock_30min / 2023-12-15
file: by_date/stock_30min/2023/2023-12-15.parquet size: 2.1 MB rows: 103,920 symbols: 1,265
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-15 04:00:00 | AAPL | Stock | 198.3 | 198.35 | 198.21 | 198.21 | 1356.0 |
| 2023-12-15 04:30:00 | AAPL | Stock | 198.25 | 198.35 | 198.24 | 198.3 | 4328.0 |
| 2023-12-15 05:00:00 | AAPL | Stock | 198.25 | 198.3 | 198.22 | 198.28 | 3143.0 |
| 2023-12-15 05:30:00 | AAPL | Stock | 198.22 | 198.26 | 198.16 | 198.25 | 4726.0 |
| 2023-12-15 06:00:00 | AAPL | Stock | 198.25 | 198.29 | 198.25 | 198.29 | 1008.0 |
| 2023-12-15 06:30:00 | AAPL | Stock | 198.27 | 198.34 | 198.25 | 198.25 | 4386.0 |
| 2023-12-15 07:00:00 | AAPL | Stock | 198.26 | 198.26 | 198.1 | 198.1 | 8564.0 |
| 2023-12-15 07:30:00 | AAPL | Stock | 198.09 | 198.13 | 197.46 | 197.7 | 22287.0 |
| 2023-12-15 08:00:00 | AAPL | Stock | 198.2501 | 198.77 | 197.5 | 198.07 | 73489.0 |
| 2023-12-15 08:30:00 | AAPL | Stock | 198.1 | 198.33 | 197.8 | 198.15 | 70781.0 |
| 2023-12-15 09:00:00 | AAPL | Stock | 198.2 | 198.5 | 196.66 | 197.55 | 817180.0 |
| 2023-12-15 09:30:00 | AAPL | Stock | 197.53 | 198.15 | 197.08 | 197.885 | 20024338.0 |
| 2023-12-15 10:00:00 | AAPL | Stock | 197.89 | 198.3999 | 197.555 | 198.03 | 3329022.0 |
| 2023-12-15 10:30:00 | AAPL | Stock | 198.04 | 198.159 | 197.42 | 197.677 | 3007440.0 |
| 2023-12-15 11:00:00 | AAPL | Stock | 197.68 | 197.74 | 197.35 | 197.625 | 2130572.0 |
| 2023-12-15 11:30:00 | AAPL | Stock | 197.63 | 198.02 | 197.59 | 197.935 | 1854470.0 |
| 2023-12-15 12:00:00 | AAPL | Stock | 197.94 | 197.95 | 197.535 | 197.73 | 1382077.0 |
| 2023-12-15 12:30:00 | AAPL | Stock | 197.74 | 197.74 | 197.155 | 197.1699 | 1765333.0 |
| 2023-12-15 13:00:00 | AAPL | Stock | 197.1612 | 197.47 | 197.1 | 197.375 | 1545109.0 |
| 2023-12-15 13:30:00 | AAPL | Stock | 197.38 | 197.6388 | 197.02 | 197.56 | 2092291.0 |
| 2023-12-15 14:00:00 | AAPL | Stock | 197.565 | 197.665 | 197.27 | 197.27 | 1340224.0 |
| 2023-12-15 14:30:00 | AAPL | Stock | 197.2909 | 197.64 | 197.28 | 197.4799 | 1239867.0 |
| 2023-12-15 15:00:00 | AAPL | Stock | 197.475 | 198.09 | 197.455 | 197.99 | 1986053.0 |
| 2023-12-15 15:30:00 | AAPL | Stock | 197.994 | 198.2 | 197.0 | 197.12 | 7719531.0 |
| 2023-12-15 16:00:00 | AAPL | Stock | 197.57 | 197.57 | 195.81 | 196.34 | 40765431.0 |
| 2023-12-15 16:30:00 | AAPL | Stock | 196.34 | 197.57 | 196.28 | 196.45 | 190139.0 |
| 2023-12-15 17:00:00 | AAPL | Stock | 196.48 | 197.57 | 196.15 | 196.2 | 105335.0 |
| 2023-12-15 17:30:00 | AAPL | Stock | 196.25 | 196.63 | 196.25 | 196.4173 | 30655.0 |
| 2023-12-15 18:00:00 | AAPL | Stock | 196.5 | 196.62 | 196.4 | 196.4 | 30700.0 |
| 2023-12-15 18:30:00 | AAPL | Stock | 196.4 | 196.65 | 196.4 | 196.62 | 34475.0 |
| 2023-12-15 19:00:00 | AAPL | Stock | 196.62 | 196.82 | 196.52 | 196.8 | 106003.0 |
| 2023-12-15 19:30:00 | AAPL | Stock | 196.82 | 196.85 | 196.54 | 196.5999 | 94416.0 |
| 2023-12-15 04:00:00 | MSFT | Stock | 367.3 | 368.52 | 367.3 | 368.5 | 6124.0 |
| 2023-12-15 04:30:00 | MSFT | Stock | 368.52 | 368.52 | 368.39 | 368.39 | 6687.0 |
| 2023-12-15 05:00:00 | MSFT | Stock | 368.39 | 368.39 | 367.7 | 367.7 | 3762.0 |
| 2023-12-15 05:30:00 | MSFT | Stock | 367.68 | 367.68 | 367.0 | 367.45 | 2141.0 |
| 2023-12-15 06:00:00 | MSFT | Stock | 367.7 | 367.76 | 367.61 | 367.68 | 1926.0 |
| 2023-12-15 06:30:00 | MSFT | Stock | 367.64 | 367.69 | 367.5 | 367.62 | 2001.0 |
| 2023-12-15 07:00:00 | MSFT | Stock | 367.51 | 367.59 | 367.05 | 367.48 | 17479.0 |
| 2023-12-15 07:30:00 | MSFT | Stock | 367.48 | 367.48 | 366.6 | 366.6 | 15344.0 |
| 2023-12-15 08:00:00 | MSFT | Stock | 367.42 | 367.83 | 366.8 | 367.55 | 55526.0 |
| 2023-12-15 08:30:00 | MSFT | Stock | 367.6 | 368.65 | 367.0 | 368.4994 | 42099.0 |
| 2023-12-15 09:00:00 | MSFT | Stock | 368.5 | 368.98 | 365.8 | 366.85 | 296187.0 |
| 2023-12-15 09:30:00 | MSFT | Stock | 366.85 | 371.17 | 366.28 | 369.09 | 11155422.0 |
| 2023-12-15 10:00:00 | MSFT | Stock | 369.09 | 370.63 | 368.43 | 370.4925 | 1450955.0 |
| 2023-12-15 10:30:00 | MSFT | Stock | 370.53 | 371.74 | 370.255 | 371.23 | 1440698.0 |
| 2023-12-15 11:00:00 | MSFT | Stock | 371.26 | 371.85 | 370.12 | 371.74 | 991214.0 |
| 2023-12-15 11:30:00 | MSFT | Stock | 371.75 | 372.16 | 370.88 | 371.3 | 796859.0 |
| 2023-12-15 12:00:00 | MSFT | Stock | 371.31 | 372.01 | 370.91 | 371.47 | 675027.0 |
| 2023-12-15 12:30:00 | MSFT | Stock | 371.49 | 371.6 | 370.1 | 370.1299 | 761471.0 |
> showing 50 of 103,920 rows — these rows as CSV