PREVIEW / stock_30min / 2022-09-08
file: by_date/stock_30min/2022/2022-09-08.parquet size: 2.1 MB rows: 102,542 symbols: 2,207
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-09-08 04:00:00 | AAPL | Stock | 156.4 | 156.4 | 155.4 | 155.71 | 24652.0 |
| 2022-09-08 04:30:00 | AAPL | Stock | 155.89 | 156.1 | 155.89 | 156.08 | 16350.0 |
| 2022-09-08 05:00:00 | AAPL | Stock | 156.1 | 156.15 | 155.9 | 156.0 | 7215.0 |
| 2022-09-08 05:30:00 | AAPL | Stock | 155.95 | 156.07 | 155.9 | 156.07 | 1533.0 |
| 2022-09-08 06:00:00 | AAPL | Stock | 156.07 | 156.15 | 156.0 | 156.11 | 3054.0 |
| 2022-09-08 06:30:00 | AAPL | Stock | 156.08 | 156.39 | 156.08 | 156.33 | 4299.0 |
| 2022-09-08 07:00:00 | AAPL | Stock | 156.31 | 156.38 | 155.95 | 156.0 | 34865.0 |
| 2022-09-08 07:30:00 | AAPL | Stock | 155.95 | 155.95 | 155.3 | 155.6 | 48944.0 |
| 2022-09-08 08:00:00 | AAPL | Stock | 156.33 | 159.0 | 155.12 | 155.29 | 207296.0 |
| 2022-09-08 08:30:00 | AAPL | Stock | 155.29 | 155.32 | 154.52 | 154.71 | 197688.0 |
| 2022-09-08 09:00:00 | AAPL | Stock | 154.7 | 154.9 | 154.02 | 154.65 | 255392.0 |
| 2022-09-08 09:30:00 | AAPL | Stock | 154.69 | 155.84 | 154.37 | 155.39 | 9094108.0 |
| 2022-09-08 10:00:00 | AAPL | Stock | 155.4 | 155.43 | 154.37 | 154.92 | 5670287.0 |
| 2022-09-08 10:30:00 | AAPL | Stock | 154.91 | 155.7961 | 154.7002 | 155.76 | 4625433.0 |
| 2022-09-08 11:00:00 | AAPL | Stock | 155.77 | 156.36 | 155.77 | 155.99 | 3663358.0 |
| 2022-09-08 11:30:00 | AAPL | Stock | 155.985 | 156.19 | 155.38 | 155.52 | 3129894.0 |
| 2022-09-08 12:00:00 | AAPL | Stock | 155.53 | 155.675 | 152.68 | 153.1499 | 7567342.0 |
| 2022-09-08 12:30:00 | AAPL | Stock | 153.15 | 153.7292 | 152.98 | 153.182 | 5061493.0 |
| 2022-09-08 13:00:00 | AAPL | Stock | 153.19 | 154.02 | 152.695 | 153.7335 | 4482914.0 |
| 2022-09-08 13:30:00 | AAPL | Stock | 153.74 | 154.14 | 153.23 | 153.55 | 3767319.0 |
| 2022-09-08 14:00:00 | AAPL | Stock | 153.55 | 153.9 | 153.37 | 153.79 | 2595811.0 |
| 2022-09-08 14:30:00 | AAPL | Stock | 153.8 | 154.41 | 153.71 | 153.8 | 3355660.0 |
| 2022-09-08 15:00:00 | AAPL | Stock | 153.81 | 154.17 | 153.48 | 154.11 | 3822742.0 |
| 2022-09-08 15:30:00 | AAPL | Stock | 154.1085 | 154.47 | 153.63 | 154.47 | 7438970.0 |
| 2022-09-08 16:00:00 | AAPL | Stock | 154.41 | 154.6 | 154.04 | 154.44 | 6849928.0 |
| 2022-09-08 16:30:00 | AAPL | Stock | 154.42 | 154.55 | 154.37 | 154.45 | 138675.0 |
| 2022-09-08 17:00:00 | AAPL | Stock | 154.45 | 154.52 | 154.36 | 154.46 | 75228.0 |
| 2022-09-08 17:30:00 | AAPL | Stock | 154.45 | 154.5 | 154.4 | 154.49 | 28030.0 |
| 2022-09-08 18:00:00 | AAPL | Stock | 154.45 | 154.45 | 154.26 | 154.3 | 26232.0 |
| 2022-09-08 18:30:00 | AAPL | Stock | 154.3 | 154.4 | 154.26 | 154.4 | 17175.0 |
| 2022-09-08 19:00:00 | AAPL | Stock | 154.38 | 154.56 | 154.3 | 154.46 | 34279.0 |
| 2022-09-08 19:30:00 | AAPL | Stock | 154.49 | 154.69 | 154.46 | 154.6 | 24637.0 |
| 2022-09-08 04:00:00 | MSFT | Stock | 258.08 | 258.08 | 257.61 | 257.8 | 1586.0 |
| 2022-09-08 04:30:00 | MSFT | Stock | 257.98 | 258.25 | 257.82 | 258.25 | 494.0 |
| 2022-09-08 07:00:00 | MSFT | Stock | 258.6 | 258.7 | 258.31 | 258.6 | 4372.0 |
| 2022-09-08 07:30:00 | MSFT | Stock | 258.41 | 258.41 | 258.0 | 258.0 | 4793.0 |
| 2022-09-08 08:00:00 | MSFT | Stock | 258.65 | 259.75 | 257.445 | 258.53 | 11901.0 |
| 2022-09-08 08:30:00 | MSFT | Stock | 258.53 | 258.69 | 256.6 | 256.65 | 11368.0 |
| 2022-09-08 09:00:00 | MSFT | Stock | 257.1 | 257.89 | 256.5 | 257.51 | 38248.0 |
| 2022-09-08 09:30:00 | MSFT | Stock | 257.51 | 258.46 | 255.5 | 257.84 | 2034096.0 |
| 2022-09-08 10:00:00 | MSFT | Stock | 257.87 | 258.35 | 256.3901 | 257.95 | 1155014.0 |
| 2022-09-08 10:30:00 | MSFT | Stock | 257.92 | 259.72 | 257.64 | 259.7 | 865365.0 |
| 2022-09-08 11:00:00 | MSFT | Stock | 259.69 | 260.43 | 259.54 | 259.935 | 732555.0 |
| 2022-09-08 11:30:00 | MSFT | Stock | 259.96 | 260.13 | 258.74 | 258.83 | 695277.0 |
| 2022-09-08 12:00:00 | MSFT | Stock | 258.83 | 258.98 | 254.79 | 255.665 | 1217071.0 |
| 2022-09-08 12:30:00 | MSFT | Stock | 255.65 | 256.63 | 255.46 | 256.28 | 578924.0 |
| 2022-09-08 13:00:00 | MSFT | Stock | 256.3 | 257.86 | 255.4564 | 257.3461 | 599670.0 |
| 2022-09-08 13:30:00 | MSFT | Stock | 257.37 | 257.9 | 256.31 | 256.84 | 431193.0 |
| 2022-09-08 14:00:00 | MSFT | Stock | 256.85 | 257.21 | 256.3 | 256.9 | 355303.0 |
| 2022-09-08 14:30:00 | MSFT | Stock | 256.9104 | 257.82 | 256.54 | 256.69 | 502628.0 |
> showing 50 of 102,542 rows — these rows as CSV