PREVIEW / stock_30min / 2022-05-11
file: by_date/stock_30min/2022/2022-05-11.parquet size: 2.2 MB rows: 110,927 symbols: 2,511
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-11 04:00:00 | AAPL | Stock | 155.28 | 155.9 | 155.15 | 155.8 | 42076.0 |
| 2022-05-11 04:30:00 | AAPL | Stock | 155.8 | 156.36 | 155.8 | 156.22 | 32699.0 |
| 2022-05-11 05:00:00 | AAPL | Stock | 156.22 | 156.4 | 156.12 | 156.26 | 17767.0 |
| 2022-05-11 05:30:00 | AAPL | Stock | 156.3 | 156.89 | 156.3 | 156.48 | 12423.0 |
| 2022-05-11 06:00:00 | AAPL | Stock | 156.44 | 156.44 | 156.11 | 156.35 | 19774.0 |
| 2022-05-11 06:30:00 | AAPL | Stock | 156.45 | 156.74 | 156.45 | 156.52 | 12588.0 |
| 2022-05-11 07:00:00 | AAPL | Stock | 156.41 | 156.57 | 156.15 | 156.27 | 87369.0 |
| 2022-05-11 07:30:00 | AAPL | Stock | 156.25 | 156.6 | 156.2 | 156.39 | 52157.0 |
| 2022-05-11 08:00:00 | AAPL | Stock | 156.2009 | 156.6 | 154.82 | 156.17 | 420170.0 |
| 2022-05-11 08:30:00 | AAPL | Stock | 156.1501 | 156.1501 | 152.0 | 152.43 | 967321.0 |
| 2022-05-11 09:00:00 | AAPL | Stock | 152.4299 | 153.8 | 152.4 | 153.57 | 499616.0 |
| 2022-05-11 09:30:00 | AAPL | Stock | 153.5 | 155.45 | 151.35 | 153.86 | 11706330.0 |
| 2022-05-11 10:00:00 | AAPL | Stock | 153.87 | 154.21 | 152.36 | 153.4001 | 7711510.0 |
| 2022-05-11 10:30:00 | AAPL | Stock | 153.4 | 154.15 | 152.49 | 152.77 | 5794480.0 |
| 2022-05-11 11:00:00 | AAPL | Stock | 152.78 | 152.91 | 151.9 | 152.86 | 5414532.0 |
| 2022-05-11 11:30:00 | AAPL | Stock | 152.87 | 153.84 | 152.27 | 152.5145 | 4009946.0 |
| 2022-05-11 12:00:00 | AAPL | Stock | 152.51 | 152.53 | 151.47 | 151.54 | 4442664.0 |
| 2022-05-11 12:30:00 | AAPL | Stock | 151.53 | 151.6 | 149.56 | 149.92 | 8473158.0 |
| 2022-05-11 13:00:00 | AAPL | Stock | 149.9118 | 149.98 | 148.29 | 148.565 | 8289772.0 |
| 2022-05-11 13:30:00 | AAPL | Stock | 148.56 | 148.84 | 146.82 | 147.03 | 9237127.0 |
| 2022-05-11 14:00:00 | AAPL | Stock | 147.02 | 147.95 | 146.51 | 147.3701 | 9041349.0 |
| 2022-05-11 14:30:00 | AAPL | Stock | 147.38 | 148.27 | 146.78 | 146.91 | 7489976.0 |
| 2022-05-11 15:00:00 | AAPL | Stock | 146.89 | 147.01 | 146.06 | 146.56 | 8637258.0 |
| 2022-05-11 15:30:00 | AAPL | Stock | 146.571 | 146.94 | 145.81 | 146.59 | 15146378.0 |
| 2022-05-11 16:00:00 | AAPL | Stock | 146.6 | 147.2 | 146.3203 | 146.7 | 10333881.0 |
| 2022-05-11 16:30:00 | AAPL | Stock | 146.7 | 147.0 | 146.49 | 146.8 | 168549.0 |
| 2022-05-11 17:00:00 | AAPL | Stock | 146.77 | 146.8 | 146.0 | 146.15 | 304876.0 |
| 2022-05-11 17:30:00 | AAPL | Stock | 146.12 | 146.53 | 146.1 | 146.5 | 103428.0 |
| 2022-05-11 18:00:00 | AAPL | Stock | 146.52 | 146.57 | 146.0 | 146.18 | 89558.0 |
| 2022-05-11 18:30:00 | AAPL | Stock | 146.2 | 146.5 | 146.15 | 146.49 | 51057.0 |
| 2022-05-11 19:00:00 | AAPL | Stock | 146.5 | 146.55 | 146.22 | 146.27 | 41524.0 |
| 2022-05-11 19:30:00 | AAPL | Stock | 146.2201 | 146.68 | 146.15 | 146.67 | 128875.0 |
| 2022-05-11 04:00:00 | MSFT | Stock | 270.5 | 271.75 | 270.5 | 271.75 | 440.0 |
| 2022-05-11 04:30:00 | MSFT | Stock | 271.88 | 272.96 | 271.8 | 272.74 | 2111.0 |
| 2022-05-11 05:00:00 | MSFT | Stock | 272.96 | 273.5 | 272.72 | 272.73 | 2043.0 |
| 2022-05-11 05:30:00 | MSFT | Stock | 272.79 | 272.85 | 272.64 | 272.85 | 1201.0 |
| 2022-05-11 06:00:00 | MSFT | Stock | 272.66 | 272.8 | 272.44 | 272.8 | 2280.0 |
| 2022-05-11 06:30:00 | MSFT | Stock | 272.94 | 273.73 | 272.94 | 273.73 | 4564.0 |
| 2022-05-11 07:00:00 | MSFT | Stock | 273.32 | 273.4 | 272.55 | 273.39 | 16646.0 |
| 2022-05-11 07:30:00 | MSFT | Stock | 273.11 | 273.8 | 273.0 | 273.2 | 14718.0 |
| 2022-05-11 08:00:00 | MSFT | Stock | 272.8018 | 273.8799 | 271.81 | 273.13 | 38283.0 |
| 2022-05-11 08:30:00 | MSFT | Stock | 272.5 | 272.5 | 263.75 | 264.5 | 129605.0 |
| 2022-05-11 09:00:00 | MSFT | Stock | 264.7923 | 268.08 | 264.54 | 265.88 | 80722.0 |
| 2022-05-11 09:30:00 | MSFT | Stock | 265.81 | 271.36 | 263.75 | 269.34 | 3497971.0 |
| 2022-05-11 10:00:00 | MSFT | Stock | 269.39 | 269.61 | 265.39 | 267.42 | 2087895.0 |
| 2022-05-11 10:30:00 | MSFT | Stock | 267.37 | 267.7028 | 264.9 | 265.76 | 1777712.0 |
| 2022-05-11 11:00:00 | MSFT | Stock | 265.8 | 266.39 | 263.7903 | 266.16 | 1654919.0 |
| 2022-05-11 11:30:00 | MSFT | Stock | 266.14 | 267.52 | 265.1 | 265.45 | 924083.0 |
| 2022-05-11 12:00:00 | MSFT | Stock | 265.42 | 266.3 | 264.13 | 264.36 | 972588.0 |
| 2022-05-11 12:30:00 | MSFT | Stock | 264.33 | 265.33 | 263.28 | 263.28 | 1480693.0 |
> showing 50 of 110,927 rows — these rows as CSV