PREVIEW / stock_30min / 2022-05-12
file: by_date/stock_30min/2022/2022-05-12.parquet size: 2.2 MB rows: 111,034 symbols: 2,490
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-05-12 04:00:00 | AAPL | Stock | 146.59 | 146.59 | 144.92 | 145.48 | 51070.0 |
| 2022-05-12 04:30:00 | AAPL | Stock | 145.75 | 145.75 | 144.66 | 144.86 | 30934.0 |
| 2022-05-12 05:00:00 | AAPL | Stock | 144.86 | 144.86 | 144.41 | 144.5 | 42840.0 |
| 2022-05-12 05:30:00 | AAPL | Stock | 144.37 | 144.65 | 144.19 | 144.49 | 44911.0 |
| 2022-05-12 06:00:00 | AAPL | Stock | 144.42 | 144.75 | 144.12 | 144.75 | 29769.0 |
| 2022-05-12 06:30:00 | AAPL | Stock | 144.75 | 144.8 | 144.34 | 144.68 | 56954.0 |
| 2022-05-12 07:00:00 | AAPL | Stock | 144.68 | 145.05 | 144.39 | 144.7 | 206618.0 |
| 2022-05-12 07:30:00 | AAPL | Stock | 144.7 | 144.75 | 143.43 | 143.46 | 221514.0 |
| 2022-05-12 08:00:00 | AAPL | Stock | 144.8205 | 146.63 | 143.15 | 143.3 | 1132254.0 |
| 2022-05-12 08:30:00 | AAPL | Stock | 143.28 | 143.79 | 142.9 | 143.02 | 853026.0 |
| 2022-05-12 09:00:00 | AAPL | Stock | 143.03 | 143.45 | 142.45 | 142.76 | 884995.0 |
| 2022-05-12 09:30:00 | AAPL | Stock | 142.76 | 144.11 | 140.2 | 141.02 | 26237384.0 |
| 2022-05-12 10:00:00 | AAPL | Stock | 141.01 | 146.1281 | 140.0915 | 144.69 | 18442352.0 |
| 2022-05-12 10:30:00 | AAPL | Stock | 144.69 | 145.83 | 143.65 | 145.6298 | 9208637.0 |
| 2022-05-12 11:00:00 | AAPL | Stock | 145.63 | 146.2 | 144.75 | 144.95 | 8055864.0 |
| 2022-05-12 11:30:00 | AAPL | Stock | 144.96 | 145.0998 | 141.24 | 141.25 | 8287709.0 |
| 2022-05-12 12:00:00 | AAPL | Stock | 141.2451 | 142.1899 | 140.57 | 141.76 | 8630209.0 |
| 2022-05-12 12:30:00 | AAPL | Stock | 141.7501 | 142.6 | 141.438 | 141.8 | 5964063.0 |
| 2022-05-12 13:00:00 | AAPL | Stock | 141.78 | 142.47 | 141.4 | 141.8299 | 4645287.0 |
| 2022-05-12 13:30:00 | AAPL | Stock | 141.82 | 142.0 | 140.0 | 140.26 | 7262937.0 |
| 2022-05-12 14:00:00 | AAPL | Stock | 140.22 | 140.48 | 139.0 | 139.94 | 10370897.0 |
| 2022-05-12 14:30:00 | AAPL | Stock | 139.93 | 139.94 | 138.8 | 139.6 | 8000289.0 |
| 2022-05-12 15:00:00 | AAPL | Stock | 139.61 | 141.8389 | 139.4 | 140.93 | 11082780.0 |
| 2022-05-12 15:30:00 | AAPL | Stock | 140.91 | 142.86 | 140.71 | 142.59 | 15951327.0 |
| 2022-05-12 16:00:00 | AAPL | Stock | 142.55 | 142.99 | 140.9986 | 142.4492 | 10215525.0 |
| 2022-05-12 16:30:00 | AAPL | Stock | 142.45 | 142.56 | 141.11 | 141.34 | 342933.0 |
| 2022-05-12 17:00:00 | AAPL | Stock | 141.33 | 142.56 | 141.31 | 141.9 | 120209.0 |
| 2022-05-12 17:30:00 | AAPL | Stock | 141.91 | 142.49 | 141.9 | 142.0831 | 65069.0 |
| 2022-05-12 18:00:00 | AAPL | Stock | 142.18 | 142.74 | 142.18 | 142.7 | 96295.0 |
| 2022-05-12 18:30:00 | AAPL | Stock | 142.66 | 142.75 | 142.5 | 142.54 | 52842.0 |
| 2022-05-12 19:00:00 | AAPL | Stock | 142.5001 | 143.2 | 142.49 | 143.12 | 68754.0 |
| 2022-05-12 19:30:00 | AAPL | Stock | 143.12 | 143.99 | 143.1 | 143.9 | 106950.0 |
| 2022-05-12 04:00:00 | MSFT | Stock | 259.6 | 259.6 | 257.66 | 258.4 | 10330.0 |
| 2022-05-12 04:30:00 | MSFT | Stock | 258.15 | 258.15 | 257.5 | 257.77 | 2368.0 |
| 2022-05-12 05:00:00 | MSFT | Stock | 257.77 | 257.77 | 257.1 | 257.4 | 7797.0 |
| 2022-05-12 05:30:00 | MSFT | Stock | 257.4 | 257.68 | 257.1 | 257.36 | 9402.0 |
| 2022-05-12 06:00:00 | MSFT | Stock | 257.45 | 257.84 | 257.4 | 257.84 | 3615.0 |
| 2022-05-12 06:30:00 | MSFT | Stock | 257.85 | 259.0 | 257.5 | 258.62 | 8075.0 |
| 2022-05-12 07:00:00 | MSFT | Stock | 258.66 | 259.3 | 258.0 | 258.7 | 13587.0 |
| 2022-05-12 07:30:00 | MSFT | Stock | 258.67 | 258.67 | 256.53 | 256.81 | 34513.0 |
| 2022-05-12 08:00:00 | MSFT | Stock | 258.6825 | 259.32 | 256.5722 | 257.6 | 92347.0 |
| 2022-05-12 08:30:00 | MSFT | Stock | 257.5 | 258.4 | 257.0 | 257.7784 | 65284.0 |
| 2022-05-12 09:00:00 | MSFT | Stock | 257.6001 | 259.01 | 257.15 | 257.41 | 108000.0 |
| 2022-05-12 09:30:00 | MSFT | Stock | 257.63 | 258.51 | 252.98 | 254.78 | 4415766.0 |
| 2022-05-12 10:00:00 | MSFT | Stock | 254.76 | 258.21 | 253.61 | 257.13 | 2569440.0 |
| 2022-05-12 10:30:00 | MSFT | Stock | 257.17 | 258.86 | 254.22 | 258.34 | 2328769.0 |
| 2022-05-12 11:00:00 | MSFT | Stock | 258.37 | 259.88 | 257.33 | 259.01 | 2301932.0 |
| 2022-05-12 11:30:00 | MSFT | Stock | 259.04 | 259.32 | 254.83 | 254.83 | 1381426.0 |
| 2022-05-12 12:00:00 | MSFT | Stock | 254.81 | 255.8 | 253.7779 | 254.83 | 1691793.0 |
| 2022-05-12 12:30:00 | MSFT | Stock | 254.84 | 256.41 | 254.5 | 254.6 | 1380903.0 |
> showing 50 of 111,034 rows — these rows as CSV