PREVIEW / stock_30min / 2022-10-13
file: by_date/stock_30min/2022/2022-10-13.parquet size: 2.1 MB rows: 104,291 symbols: 2,170
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-10-13 04:00:00 | AAPL | Stock | 138.8 | 138.8 | 138.36 | 138.64 | 10027.0 |
| 2022-10-13 04:30:00 | AAPL | Stock | 138.67 | 138.73 | 138.53 | 138.68 | 17482.0 |
| 2022-10-13 05:00:00 | AAPL | Stock | 138.67 | 139.0 | 138.67 | 138.8 | 20163.0 |
| 2022-10-13 05:30:00 | AAPL | Stock | 138.88 | 138.99 | 138.61 | 138.61 | 12496.0 |
| 2022-10-13 06:00:00 | AAPL | Stock | 138.62 | 138.79 | 138.62 | 138.79 | 1370.0 |
| 2022-10-13 06:30:00 | AAPL | Stock | 138.75 | 138.98 | 138.72 | 138.97 | 15439.0 |
| 2022-10-13 07:00:00 | AAPL | Stock | 138.82 | 139.0 | 138.75 | 138.85 | 49400.0 |
| 2022-10-13 07:30:00 | AAPL | Stock | 138.9 | 139.45 | 138.89 | 139.27 | 74323.0 |
| 2022-10-13 08:00:00 | AAPL | Stock | 138.8 | 140.0 | 137.995 | 139.38 | 222937.0 |
| 2022-10-13 08:30:00 | AAPL | Stock | 139.25 | 139.38 | 133.2 | 134.43 | 1223390.0 |
| 2022-10-13 09:00:00 | AAPL | Stock | 134.45 | 135.0 | 133.88 | 134.99 | 632971.0 |
| 2022-10-13 09:30:00 | AAPL | Stock | 134.99 | 136.395 | 134.37 | 136.26 | 12574570.0 |
| 2022-10-13 10:00:00 | AAPL | Stock | 136.25 | 136.89 | 135.73 | 135.7704 | 6784509.0 |
| 2022-10-13 10:30:00 | AAPL | Stock | 135.775 | 136.78 | 135.62 | 136.28 | 7053065.0 |
| 2022-10-13 11:00:00 | AAPL | Stock | 136.26 | 140.69 | 135.98 | 139.75 | 9589380.0 |
| 2022-10-13 11:30:00 | AAPL | Stock | 139.75 | 142.61 | 136.38 | 140.94 | 10495303.0 |
| 2022-10-13 12:00:00 | AAPL | Stock | 140.94 | 141.37 | 140.17 | 140.3 | 5260184.0 |
| 2022-10-13 12:30:00 | AAPL | Stock | 140.3 | 140.89 | 140.07 | 140.565 | 4202691.0 |
| 2022-10-13 13:00:00 | AAPL | Stock | 140.57 | 141.935 | 140.57 | 141.7 | 4103569.0 |
| 2022-10-13 13:30:00 | AAPL | Stock | 141.72 | 142.37 | 141.61 | 141.81 | 4165299.0 |
| 2022-10-13 14:00:00 | AAPL | Stock | 141.805 | 141.81 | 140.9 | 141.0 | 3267994.0 |
| 2022-10-13 14:30:00 | AAPL | Stock | 141.01 | 142.99 | 141.01 | 142.81 | 5053280.0 |
| 2022-10-13 15:00:00 | AAPL | Stock | 142.8199 | 143.4241 | 142.47 | 142.49 | 6621907.0 |
| 2022-10-13 15:30:00 | AAPL | Stock | 142.48 | 143.59 | 142.071 | 142.93 | 11147403.0 |
| 2022-10-13 16:00:00 | AAPL | Stock | 142.92 | 143.3 | 142.66 | 142.81 | 8355411.0 |
| 2022-10-13 16:30:00 | AAPL | Stock | 142.8 | 142.99 | 142.63 | 142.69 | 146505.0 |
| 2022-10-13 17:00:00 | AAPL | Stock | 142.68 | 142.7497 | 142.55 | 142.61 | 34181.0 |
| 2022-10-13 17:30:00 | AAPL | Stock | 142.6 | 142.7 | 142.57 | 142.6764 | 23165.0 |
| 2022-10-13 18:00:00 | AAPL | Stock | 142.63 | 142.81 | 142.29 | 142.4 | 42404.0 |
| 2022-10-13 18:30:00 | AAPL | Stock | 142.4201 | 142.72 | 142.4201 | 142.63 | 12838.0 |
| 2022-10-13 19:00:00 | AAPL | Stock | 142.65 | 142.73 | 142.53 | 142.7 | 13245.0 |
| 2022-10-13 19:30:00 | AAPL | Stock | 142.72 | 142.97 | 142.62 | 142.83 | 24608.0 |
| 2022-10-13 04:00:00 | MSFT | Stock | 225.22 | 225.4 | 225.22 | 225.4 | 215.0 |
| 2022-10-13 04:30:00 | MSFT | Stock | 225.5 | 225.8 | 225.5 | 225.8 | 859.0 |
| 2022-10-13 05:00:00 | MSFT | Stock | 226.01 | 226.01 | 226.01 | 226.01 | 100.0 |
| 2022-10-13 06:00:00 | MSFT | Stock | 225.76 | 225.98 | 225.57 | 225.98 | 2526.0 |
| 2022-10-13 06:30:00 | MSFT | Stock | 225.95 | 226.25 | 225.95 | 226.01 | 3407.0 |
| 2022-10-13 07:00:00 | MSFT | Stock | 226.02 | 226.45 | 226.0 | 226.45 | 4249.0 |
| 2022-10-13 07:30:00 | MSFT | Stock | 226.7 | 227.59 | 226.66 | 227.48 | 12646.0 |
| 2022-10-13 08:00:00 | MSFT | Stock | 225.8127 | 228.99 | 225.186 | 227.65 | 40904.0 |
| 2022-10-13 08:30:00 | MSFT | Stock | 227.3 | 227.3 | 218.98 | 219.9 | 339632.0 |
| 2022-10-13 09:00:00 | MSFT | Stock | 219.57 | 220.6 | 219.0 | 219.99 | 158660.0 |
| 2022-10-13 09:30:00 | MSFT | Stock | 219.99 | 223.18 | 219.13 | 223.05 | 3306149.0 |
| 2022-10-13 10:00:00 | MSFT | Stock | 223.07 | 226.08 | 222.79 | 224.3494 | 2766442.0 |
| 2022-10-13 10:30:00 | MSFT | Stock | 224.32 | 226.56 | 224.18 | 225.1187 | 2412187.0 |
| 2022-10-13 11:00:00 | MSFT | Stock | 225.11 | 232.0 | 224.74 | 229.92 | 3257083.0 |
| 2022-10-13 11:30:00 | MSFT | Stock | 229.92 | 234.52 | 229.5945 | 232.95 | 2981154.0 |
| 2022-10-13 12:00:00 | MSFT | Stock | 232.93 | 234.21 | 231.52 | 232.0 | 1799325.0 |
| 2022-10-13 12:30:00 | MSFT | Stock | 231.99 | 233.67 | 231.91 | 233.08 | 1533686.0 |
| 2022-10-13 13:00:00 | MSFT | Stock | 233.08 | 235.09 | 232.57 | 234.68 | 1446964.0 |
> showing 50 of 104,291 rows — these rows as CSV