PREVIEW / stock_30min / 2022-05-26
file: by_date/stock_30min/2022/2022-05-26.parquet size: 2.1 MB rows: 105,467 symbols: 2,402
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-26 04:00:00 | AAPL | Stock | 140.53 | 140.53 | 138.5 | 138.5 | 74421.0 |
| 2022-05-26 04:30:00 | AAPL | Stock | 138.5 | 138.8 | 138.25 | 138.28 | 43694.0 |
| 2022-05-26 05:00:00 | AAPL | Stock | 138.32 | 138.52 | 138.03 | 138.35 | 45971.0 |
| 2022-05-26 05:30:00 | AAPL | Stock | 138.39 | 138.62 | 138.39 | 138.43 | 32693.0 |
| 2022-05-26 06:00:00 | AAPL | Stock | 138.41 | 138.5 | 138.3 | 138.4 | 13779.0 |
| 2022-05-26 06:30:00 | AAPL | Stock | 138.44 | 139.09 | 138.44 | 138.9 | 28229.0 |
| 2022-05-26 07:00:00 | AAPL | Stock | 138.89 | 139.82 | 138.59 | 139.64 | 155788.0 |
| 2022-05-26 07:30:00 | AAPL | Stock | 139.6 | 139.64 | 138.85 | 138.92 | 84942.0 |
| 2022-05-26 08:00:00 | AAPL | Stock | 138.7501 | 140.94 | 138.5711 | 138.9099 | 508654.0 |
| 2022-05-26 08:30:00 | AAPL | Stock | 138.89 | 139.25 | 138.28 | 138.68 | 431332.0 |
| 2022-05-26 09:00:00 | AAPL | Stock | 138.65 | 138.7001 | 137.33 | 137.39 | 805175.0 |
| 2022-05-26 09:30:00 | AAPL | Stock | 137.39 | 140.97 | 137.14 | 140.615 | 10691578.0 |
| 2022-05-26 10:00:00 | AAPL | Stock | 140.64 | 141.7 | 140.36 | 141.15 | 6870110.0 |
| 2022-05-26 10:30:00 | AAPL | Stock | 141.17 | 141.97 | 140.84 | 141.8701 | 4652966.0 |
| 2022-05-26 11:00:00 | AAPL | Stock | 141.87 | 143.11 | 141.79 | 142.53 | 5566372.0 |
| 2022-05-26 11:30:00 | AAPL | Stock | 142.535 | 143.09 | 142.31 | 142.96 | 3998464.0 |
| 2022-05-26 12:00:00 | AAPL | Stock | 142.96 | 144.336 | 142.82 | 143.9842 | 5648561.0 |
| 2022-05-26 12:30:00 | AAPL | Stock | 143.985 | 144.1596 | 143.56 | 144.01 | 3366779.0 |
| 2022-05-26 13:00:00 | AAPL | Stock | 144.0 | 144.33 | 143.405 | 143.47 | 3342113.0 |
| 2022-05-26 13:30:00 | AAPL | Stock | 143.47 | 143.8599 | 143.38 | 143.78 | 3096903.0 |
| 2022-05-26 14:00:00 | AAPL | Stock | 143.77 | 144.06 | 143.44 | 143.825 | 3170615.0 |
| 2022-05-26 14:30:00 | AAPL | Stock | 143.83 | 143.95 | 143.55 | 143.9001 | 2813906.0 |
| 2022-05-26 15:00:00 | AAPL | Stock | 143.9099 | 143.98 | 143.06 | 143.2 | 4420388.0 |
| 2022-05-26 15:30:00 | AAPL | Stock | 143.19 | 144.34 | 143.12 | 143.75 | 9259603.0 |
| 2022-05-26 16:00:00 | AAPL | Stock | 143.74 | 143.82 | 143.51 | 143.5506 | 9903991.0 |
| 2022-05-26 16:30:00 | AAPL | Stock | 143.65 | 143.78 | 143.52 | 143.58 | 77881.0 |
| 2022-05-26 17:00:00 | AAPL | Stock | 143.63 | 143.69 | 143.55 | 143.64 | 14971.0 |
| 2022-05-26 17:30:00 | AAPL | Stock | 143.64 | 143.69 | 143.64 | 143.64 | 12204.0 |
| 2022-05-26 18:00:00 | AAPL | Stock | 143.62 | 143.97 | 143.6 | 143.8 | 23759.0 |
| 2022-05-26 18:30:00 | AAPL | Stock | 143.84 | 143.88 | 143.72 | 143.8 | 13424.0 |
| 2022-05-26 19:00:00 | AAPL | Stock | 143.83 | 143.88 | 143.76 | 143.82 | 16410.0 |
| 2022-05-26 19:30:00 | AAPL | Stock | 143.83 | 144.15 | 143.79 | 144.14 | 29237.0 |
| 2022-05-26 04:00:00 | MSFT | Stock | 263.31 | 263.31 | 262.29 | 262.3 | 961.0 |
| 2022-05-26 04:30:00 | MSFT | Stock | 261.99 | 262.0 | 261.38 | 261.38 | 3932.0 |
| 2022-05-26 05:00:00 | MSFT | Stock | 261.38 | 262.01 | 261.38 | 262.01 | 469.0 |
| 2022-05-26 05:30:00 | MSFT | Stock | 262.59 | 262.99 | 262.58 | 262.99 | 1119.0 |
| 2022-05-26 06:00:00 | MSFT | Stock | 262.75 | 263.39 | 262.75 | 262.84 | 1100.0 |
| 2022-05-26 06:30:00 | MSFT | Stock | 263.5 | 264.0 | 263.49 | 264.0 | 864.0 |
| 2022-05-26 07:00:00 | MSFT | Stock | 263.37 | 264.7 | 262.91 | 264.7 | 9798.0 |
| 2022-05-26 07:30:00 | MSFT | Stock | 264.7 | 264.7 | 263.4 | 263.4 | 8937.0 |
| 2022-05-26 08:00:00 | MSFT | Stock | 263.75 | 264.9 | 261.0 | 263.5986 | 21186.0 |
| 2022-05-26 08:30:00 | MSFT | Stock | 263.35 | 263.9 | 262.6 | 263.7 | 28481.0 |
| 2022-05-26 09:00:00 | MSFT | Stock | 263.7 | 263.7 | 262.26 | 262.26 | 10178.0 |
| 2022-05-26 09:30:00 | MSFT | Stock | 262.27 | 265.09 | 261.4294 | 264.545 | 2102664.0 |
| 2022-05-26 10:00:00 | MSFT | Stock | 264.5699 | 266.2 | 263.89 | 265.03 | 1380760.0 |
| 2022-05-26 10:30:00 | MSFT | Stock | 265.06 | 265.5134 | 264.6 | 265.13 | 1156354.0 |
| 2022-05-26 11:00:00 | MSFT | Stock | 265.15 | 266.19 | 264.68 | 264.7 | 957442.0 |
| 2022-05-26 11:30:00 | MSFT | Stock | 264.7 | 265.36 | 264.51 | 264.97 | 753344.0 |
| 2022-05-26 12:00:00 | MSFT | Stock | 264.94 | 265.96 | 264.57 | 265.95 | 884730.0 |
| 2022-05-26 12:30:00 | MSFT | Stock | 265.93 | 266.21 | 265.25 | 266.1 | 675979.0 |
> showing 50 of 105,467 rows — these rows as CSV