PREVIEW / stock_30min / 2022-09-01
file: by_date/stock_30min/2022/2022-09-01.parquet size: 2.1 MB rows: 105,164 symbols: 2,234
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-01 04:00:00 | AAPL | Stock | 156.0 | 156.42 | 156.0 | 156.13 | 33338.0 |
| 2022-09-01 04:30:00 | AAPL | Stock | 156.09 | 156.11 | 155.74 | 155.98 | 14639.0 |
| 2022-09-01 05:00:00 | AAPL | Stock | 156.0 | 156.0 | 155.51 | 155.78 | 6612.0 |
| 2022-09-01 05:30:00 | AAPL | Stock | 155.78 | 156.05 | 155.66 | 156.0 | 13341.0 |
| 2022-09-01 06:00:00 | AAPL | Stock | 156.0 | 156.07 | 155.95 | 156.07 | 5436.0 |
| 2022-09-01 06:30:00 | AAPL | Stock | 156.07 | 156.14 | 155.89 | 156.14 | 14820.0 |
| 2022-09-01 07:00:00 | AAPL | Stock | 156.03 | 156.7 | 155.95 | 156.5 | 70799.0 |
| 2022-09-01 07:30:00 | AAPL | Stock | 156.45 | 156.95 | 156.32 | 156.58 | 22555.0 |
| 2022-09-01 08:00:00 | AAPL | Stock | 156.0 | 156.95 | 155.29 | 156.49 | 223203.0 |
| 2022-09-01 08:30:00 | AAPL | Stock | 156.45 | 157.22 | 155.88 | 156.23 | 266168.0 |
| 2022-09-01 09:00:00 | AAPL | Stock | 156.23 | 156.75 | 156.0398 | 156.69 | 124760.0 |
| 2022-09-01 09:30:00 | AAPL | Stock | 156.64 | 157.48 | 155.92 | 157.37 | 8840192.0 |
| 2022-09-01 10:00:00 | AAPL | Stock | 157.37 | 157.68 | 156.19 | 157.26 | 5724384.0 |
| 2022-09-01 10:30:00 | AAPL | Stock | 157.27 | 157.28 | 155.74 | 155.74 | 4261963.0 |
| 2022-09-01 11:00:00 | AAPL | Stock | 155.75 | 156.205 | 155.33 | 155.4212 | 4981966.0 |
| 2022-09-01 11:30:00 | AAPL | Stock | 155.43 | 156.41 | 155.16 | 155.5107 | 3898726.0 |
| 2022-09-01 12:00:00 | AAPL | Stock | 155.515 | 156.03 | 155.4 | 155.5 | 2965413.0 |
| 2022-09-01 12:30:00 | AAPL | Stock | 155.51 | 155.695 | 154.67 | 154.96 | 3622162.0 |
| 2022-09-01 13:00:00 | AAPL | Stock | 154.97 | 155.93 | 154.82 | 155.765 | 3424031.0 |
| 2022-09-01 13:30:00 | AAPL | Stock | 155.79 | 155.99 | 155.51 | 155.875 | 2690399.0 |
| 2022-09-01 14:00:00 | AAPL | Stock | 155.885 | 157.3 | 155.79 | 157.06 | 3859622.0 |
| 2022-09-01 14:30:00 | AAPL | Stock | 157.0615 | 157.42 | 156.5302 | 156.85 | 3578653.0 |
| 2022-09-01 15:00:00 | AAPL | Stock | 156.85 | 157.51 | 156.76 | 156.8 | 3247494.0 |
| 2022-09-01 15:30:00 | AAPL | Stock | 156.805 | 158.42 | 156.72 | 157.97 | 6843667.0 |
| 2022-09-01 16:00:00 | AAPL | Stock | 157.96 | 158.48 | 157.88 | 158.41 | 5760618.0 |
| 2022-09-01 16:30:00 | AAPL | Stock | 158.428 | 158.5 | 157.96 | 158.44 | 90872.0 |
| 2022-09-01 17:00:00 | AAPL | Stock | 158.39 | 158.54 | 158.34 | 158.47 | 39942.0 |
| 2022-09-01 17:30:00 | AAPL | Stock | 158.49 | 158.59 | 157.96 | 158.55 | 37963.0 |
| 2022-09-01 18:00:00 | AAPL | Stock | 158.55 | 158.7 | 158.42 | 158.42 | 31753.0 |
| 2022-09-01 18:30:00 | AAPL | Stock | 158.5 | 158.5 | 158.27 | 158.27 | 27965.0 |
| 2022-09-01 19:00:00 | AAPL | Stock | 158.27 | 158.38 | 158.24 | 158.32 | 13617.0 |
| 2022-09-01 19:30:00 | AAPL | Stock | 158.32 | 158.65 | 158.24 | 158.62 | 24481.0 |
| 2022-09-01 04:00:00 | MSFT | Stock | 258.89 | 259.67 | 258.83 | 259.02 | 1244.0 |
| 2022-09-01 04:30:00 | MSFT | Stock | 258.56 | 259.15 | 258.56 | 259.15 | 1811.0 |
| 2022-09-01 05:00:00 | MSFT | Stock | 259.14 | 259.25 | 258.11 | 258.11 | 2476.0 |
| 2022-09-01 05:30:00 | MSFT | Stock | 258.79 | 259.05 | 258.79 | 259.05 | 300.0 |
| 2022-09-01 06:00:00 | MSFT | Stock | 259.29 | 259.5 | 259.21 | 259.5 | 811.0 |
| 2022-09-01 06:30:00 | MSFT | Stock | 259.51 | 259.79 | 259.43 | 259.79 | 1487.0 |
| 2022-09-01 07:00:00 | MSFT | Stock | 259.55 | 260.05 | 259.52 | 259.6 | 5265.0 |
| 2022-09-01 07:30:00 | MSFT | Stock | 259.49 | 260.2 | 259.49 | 259.57 | 47261.0 |
| 2022-09-01 08:00:00 | MSFT | Stock | 259.5239 | 260.817 | 258.79 | 258.9999 | 28298.0 |
| 2022-09-01 08:30:00 | MSFT | Stock | 258.85 | 259.6 | 258.4 | 258.5 | 14028.0 |
| 2022-09-01 09:00:00 | MSFT | Stock | 258.51 | 259.09 | 258.0 | 258.98 | 40115.0 |
| 2022-09-01 09:30:00 | MSFT | Stock | 258.87 | 259.63 | 257.89 | 259.46 | 2020128.0 |
| 2022-09-01 10:00:00 | MSFT | Stock | 259.45 | 259.8295 | 257.52 | 258.46 | 1318188.0 |
| 2022-09-01 10:30:00 | MSFT | Stock | 258.48 | 258.49 | 255.68 | 255.7 | 1156737.0 |
| 2022-09-01 11:00:00 | MSFT | Stock | 255.7 | 256.96 | 255.67 | 256.03 | 996184.0 |
| 2022-09-01 11:30:00 | MSFT | Stock | 256.03 | 256.89 | 255.41 | 255.8 | 1023105.0 |
| 2022-09-01 12:00:00 | MSFT | Stock | 255.79 | 256.94 | 255.71 | 256.515 | 572776.0 |
| 2022-09-01 12:30:00 | MSFT | Stock | 256.53 | 256.6 | 255.52 | 255.84 | 526093.0 |
> showing 50 of 105,164 rows — these rows as CSV