PREVIEW / stock_30min / 2022-11-10
file: by_date/stock_30min/2022/2022-11-10.parquet size: 2.2 MB rows: 107,772 symbols: 2,161
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-11-10 04:00:00 | AAPL | Stock | 134.87 | 135.8 | 134.87 | 135.6 | 24911.0 |
| 2022-11-10 04:30:00 | AAPL | Stock | 135.65 | 135.75 | 135.51 | 135.52 | 7489.0 |
| 2022-11-10 05:00:00 | AAPL | Stock | 135.6 | 135.6 | 135.38 | 135.59 | 18081.0 |
| 2022-11-10 05:30:00 | AAPL | Stock | 135.56 | 135.98 | 135.55 | 135.98 | 7679.0 |
| 2022-11-10 06:00:00 | AAPL | Stock | 135.83 | 136.05 | 135.62 | 135.86 | 11967.0 |
| 2022-11-10 06:30:00 | AAPL | Stock | 135.98 | 136.19 | 135.95 | 136.0 | 6835.0 |
| 2022-11-10 07:00:00 | AAPL | Stock | 136.0 | 136.05 | 135.7 | 135.75 | 31683.0 |
| 2022-11-10 07:30:00 | AAPL | Stock | 135.78 | 135.8 | 135.55 | 135.74 | 21554.0 |
| 2022-11-10 08:00:00 | AAPL | Stock | 135.9216 | 136.0499 | 135.45 | 135.5 | 183927.0 |
| 2022-11-10 08:30:00 | AAPL | Stock | 135.4003 | 140.42 | 135.08 | 140.13 | 1695333.0 |
| 2022-11-10 09:00:00 | AAPL | Stock | 140.1299 | 141.46 | 139.64 | 141.31 | 771507.0 |
| 2022-11-10 09:30:00 | AAPL | Stock | 141.24 | 143.37 | 140.4 | 143.29 | 14777444.0 |
| 2022-11-10 10:00:00 | AAPL | Stock | 143.3 | 143.7 | 142.68 | 143.45 | 8566623.0 |
| 2022-11-10 10:30:00 | AAPL | Stock | 143.46 | 143.51 | 142.17 | 143.21 | 5456562.0 |
| 2022-11-10 11:00:00 | AAPL | Stock | 143.21 | 143.27 | 142.15 | 143.09 | 4315315.0 |
| 2022-11-10 11:30:00 | AAPL | Stock | 143.1 | 143.43 | 142.74 | 143.1175 | 3718386.0 |
| 2022-11-10 12:00:00 | AAPL | Stock | 143.12 | 143.65 | 142.9 | 143.23 | 3728027.0 |
| 2022-11-10 12:30:00 | AAPL | Stock | 143.22 | 143.22 | 142.7201 | 142.86 | 3205841.0 |
| 2022-11-10 13:00:00 | AAPL | Stock | 142.85 | 143.73 | 142.85 | 143.62 | 3463928.0 |
| 2022-11-10 13:30:00 | AAPL | Stock | 143.63 | 144.06 | 143.38 | 143.8685 | 3703150.0 |
| 2022-11-10 14:00:00 | AAPL | Stock | 143.865 | 144.23 | 143.83 | 144.182 | 3281433.0 |
| 2022-11-10 14:30:00 | AAPL | Stock | 144.185 | 144.6102 | 144.0 | 144.54 | 3476881.0 |
| 2022-11-10 15:00:00 | AAPL | Stock | 144.535 | 145.17 | 144.4199 | 145.1551 | 5831237.0 |
| 2022-11-10 15:30:00 | AAPL | Stock | 145.1599 | 146.87 | 145.05 | 146.8 | 16747586.0 |
| 2022-11-10 16:00:00 | AAPL | Stock | 146.78 | 147.25 | 146.66 | 147.11 | 21477733.0 |
| 2022-11-10 16:30:00 | AAPL | Stock | 147.1599 | 147.29 | 146.87 | 147.29 | 284828.0 |
| 2022-11-10 17:00:00 | AAPL | Stock | 147.29 | 147.59 | 147.0 | 147.4 | 146973.0 |
| 2022-11-10 17:30:00 | AAPL | Stock | 147.35 | 147.36 | 147.12 | 147.15 | 78860.0 |
| 2022-11-10 18:00:00 | AAPL | Stock | 147.1 | 147.15 | 146.91 | 146.98 | 66998.0 |
| 2022-11-10 18:30:00 | AAPL | Stock | 146.97 | 147.35 | 146.95 | 147.3 | 67681.0 |
| 2022-11-10 19:00:00 | AAPL | Stock | 147.3 | 147.3 | 146.8 | 146.91 | 50452.0 |
| 2022-11-10 19:30:00 | AAPL | Stock | 146.92 | 147.2 | 146.92 | 147.2 | 33188.0 |
| 2022-11-10 04:00:00 | MSFT | Stock | 224.67 | 224.77 | 224.4 | 224.4 | 515.0 |
| 2022-11-10 04:30:00 | MSFT | Stock | 224.73 | 224.74 | 224.73 | 224.74 | 593.0 |
| 2022-11-10 05:00:00 | MSFT | Stock | 224.43 | 224.54 | 224.02 | 224.02 | 1431.0 |
| 2022-11-10 05:30:00 | MSFT | Stock | 224.46 | 225.0 | 224.46 | 225.0 | 1118.0 |
| 2022-11-10 06:00:00 | MSFT | Stock | 224.72 | 225.62 | 224.71 | 225.62 | 725.0 |
| 2022-11-10 06:30:00 | MSFT | Stock | 225.64 | 225.65 | 225.64 | 225.65 | 590.0 |
| 2022-11-10 07:00:00 | MSFT | Stock | 225.7 | 225.79 | 225.15 | 225.15 | 13132.0 |
| 2022-11-10 07:30:00 | MSFT | Stock | 225.11 | 225.32 | 224.83 | 225.32 | 3810.0 |
| 2022-11-10 08:00:00 | MSFT | Stock | 224.8267 | 226.1 | 224.82 | 225.8999 | 21556.0 |
| 2022-11-10 08:30:00 | MSFT | Stock | 225.89 | 234.5 | 225.1 | 234.3 | 327794.0 |
| 2022-11-10 09:00:00 | MSFT | Stock | 234.1 | 235.61 | 233.21 | 235.49 | 166981.0 |
| 2022-11-10 09:30:00 | MSFT | Stock | 235.4 | 240.0 | 235.0 | 239.875 | 5333822.0 |
| 2022-11-10 10:00:00 | MSFT | Stock | 239.885 | 240.29 | 238.11 | 238.41 | 2563850.0 |
| 2022-11-10 10:30:00 | MSFT | Stock | 238.39 | 238.95 | 237.32 | 238.73 | 1850929.0 |
| 2022-11-10 11:00:00 | MSFT | Stock | 238.736 | 239.04 | 237.54 | 238.65 | 1328307.0 |
| 2022-11-10 11:30:00 | MSFT | Stock | 238.67 | 239.99 | 238.67 | 239.96 | 1582973.0 |
| 2022-11-10 12:00:00 | MSFT | Stock | 239.96 | 240.75 | 239.51 | 240.02 | 1358665.0 |
| 2022-11-10 12:30:00 | MSFT | Stock | 240.0049 | 240.19 | 238.9168 | 239.03 | 1224029.0 |
> showing 50 of 107,772 rows — these rows as CSV