PREVIEW / stock_30min / 2022-02-24
file: by_date/stock_30min/2022/2022-02-24.parquet size: 2.4 MB rows: 120,400 symbols: 2,638
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-02-24 04:00:00 | AAPL | Stock | 158.1 | 158.1 | 155.0 | 156.4 | 89028.0 |
| 2022-02-24 04:30:00 | AAPL | Stock | 156.2 | 156.3 | 155.5 | 155.59 | 29600.0 |
| 2022-02-24 05:00:00 | AAPL | Stock | 155.51 | 156.06 | 154.75 | 155.05 | 53383.0 |
| 2022-02-24 05:30:00 | AAPL | Stock | 155.09 | 155.46 | 154.71 | 154.83 | 46484.0 |
| 2022-02-24 06:00:00 | AAPL | Stock | 155.0 | 155.02 | 154.13 | 154.6 | 80048.0 |
| 2022-02-24 06:30:00 | AAPL | Stock | 154.54 | 155.91 | 154.35 | 155.83 | 58911.0 |
| 2022-02-24 07:00:00 | AAPL | Stock | 155.83 | 155.98 | 154.0 | 154.03 | 311958.0 |
| 2022-02-24 07:30:00 | AAPL | Stock | 154.03 | 154.12 | 152.85 | 153.58 | 571078.0 |
| 2022-02-24 08:00:00 | AAPL | Stock | 155.1001 | 156.5 | 152.75 | 153.0 | 993662.0 |
| 2022-02-24 08:30:00 | AAPL | Stock | 153.0 | 154.33 | 152.99 | 153.8 | 854385.0 |
| 2022-02-24 09:00:00 | AAPL | Stock | 153.82 | 154.39 | 151.9 | 152.56 | 1119840.0 |
| 2022-02-24 09:30:00 | AAPL | Stock | 152.62 | 156.91 | 152.0 | 156.4829 | 23708324.0 |
| 2022-02-24 10:00:00 | AAPL | Stock | 156.48 | 157.8 | 155.385 | 155.85 | 10449420.0 |
| 2022-02-24 10:30:00 | AAPL | Stock | 155.86 | 157.2991 | 154.96 | 156.91 | 8944762.0 |
| 2022-02-24 11:00:00 | AAPL | Stock | 156.91 | 158.68 | 156.73 | 158.03 | 6975202.0 |
| 2022-02-24 11:30:00 | AAPL | Stock | 158.04 | 158.48 | 157.34 | 158.44 | 4922926.0 |
| 2022-02-24 12:00:00 | AAPL | Stock | 158.43 | 158.83 | 156.8 | 157.26 | 4947622.0 |
| 2022-02-24 12:30:00 | AAPL | Stock | 157.255 | 158.21 | 156.7 | 157.18 | 4604788.0 |
| 2022-02-24 13:00:00 | AAPL | Stock | 157.16 | 158.68 | 156.91 | 157.92 | 3790534.0 |
| 2022-02-24 13:30:00 | AAPL | Stock | 157.92 | 159.93 | 157.87 | 158.84 | 5083940.0 |
| 2022-02-24 14:00:00 | AAPL | Stock | 158.83 | 159.81 | 158.29 | 159.51 | 4478542.0 |
| 2022-02-24 14:30:00 | AAPL | Stock | 159.5 | 160.91 | 159.47 | 160.49 | 5752193.0 |
| 2022-02-24 15:00:00 | AAPL | Stock | 160.5 | 161.1319 | 160.27 | 160.35 | 5295482.0 |
| 2022-02-24 15:30:00 | AAPL | Stock | 160.35 | 162.85 | 160.3 | 162.77 | 11594538.0 |
| 2022-02-24 16:00:00 | AAPL | Stock | 162.74 | 162.74 | 161.52 | 161.63 | 12590942.0 |
| 2022-02-24 16:30:00 | AAPL | Stock | 161.64 | 162.74 | 161.25 | 162.17 | 207016.0 |
| 2022-02-24 17:00:00 | AAPL | Stock | 162.28 | 162.74 | 161.91 | 162.0 | 88111.0 |
| 2022-02-24 17:30:00 | AAPL | Stock | 162.0 | 162.2 | 161.92 | 162.16 | 18779.0 |
| 2022-02-24 18:00:00 | AAPL | Stock | 161.95 | 161.95 | 161.17 | 161.17 | 60910.0 |
| 2022-02-24 18:30:00 | AAPL | Stock | 161.16 | 161.3 | 160.75 | 160.98 | 52874.0 |
| 2022-02-24 19:00:00 | AAPL | Stock | 160.99 | 162.5 | 160.96 | 162.11 | 70901.0 |
| 2022-02-24 19:30:00 | AAPL | Stock | 162.14 | 162.15 | 161.0 | 161.25 | 46621.0 |
| 2022-02-24 04:00:00 | MSFT | Stock | 273.39 | 276.0 | 272.5 | 273.5 | 14050.0 |
| 2022-02-24 04:30:00 | MSFT | Stock | 273.7 | 273.99 | 272.35 | 272.69 | 8177.0 |
| 2022-02-24 05:00:00 | MSFT | Stock | 272.46 | 273.35 | 271.38 | 271.38 | 8347.0 |
| 2022-02-24 05:30:00 | MSFT | Stock | 272.0 | 272.61 | 271.65 | 271.65 | 4031.0 |
| 2022-02-24 06:00:00 | MSFT | Stock | 271.55 | 271.77 | 270.11 | 270.8 | 17863.0 |
| 2022-02-24 06:30:00 | MSFT | Stock | 270.7 | 272.54 | 270.0 | 272.54 | 21401.0 |
| 2022-02-24 07:00:00 | MSFT | Stock | 271.94 | 272.5 | 270.31 | 271.76 | 132671.0 |
| 2022-02-24 07:30:00 | MSFT | Stock | 271.23 | 271.74 | 270.53 | 271.2 | 61687.0 |
| 2022-02-24 08:00:00 | MSFT | Stock | 270.7823 | 280.97 | 270.0 | 270.33 | 145575.0 |
| 2022-02-24 08:30:00 | MSFT | Stock | 270.29 | 272.7 | 270.29 | 271.2 | 73562.0 |
| 2022-02-24 09:00:00 | MSFT | Stock | 271.0 | 280.27 | 271.0 | 272.54 | 191195.0 |
| 2022-02-24 09:30:00 | MSFT | Stock | 272.56 | 278.92 | 271.52 | 277.935 | 6463670.0 |
| 2022-02-24 10:00:00 | MSFT | Stock | 277.91 | 282.42 | 276.77 | 280.56 | 3267754.0 |
| 2022-02-24 10:30:00 | MSFT | Stock | 280.54 | 283.65 | 280.37 | 282.73 | 2422272.0 |
| 2022-02-24 11:00:00 | MSFT | Stock | 282.78 | 286.47 | 282.3906 | 285.4675 | 2672165.0 |
| 2022-02-24 11:30:00 | MSFT | Stock | 285.46 | 285.921 | 283.252 | 284.91 | 1895073.0 |
| 2022-02-24 12:00:00 | MSFT | Stock | 284.915 | 285.16 | 281.51 | 283.1154 | 1543899.0 |
| 2022-02-24 12:30:00 | MSFT | Stock | 283.06 | 284.64 | 282.25 | 283.16 | 1176351.0 |
> showing 50 of 120,400 rows — these rows as CSV