PREVIEW / stock_30min / 2021-08-10
file: by_date/stock_30min/2021/2021-08-10.parquet size: 2.2 MB rows: 109,692 symbols: 2,805
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 |
|---|---|---|---|---|---|---|---|
| 2021-08-10 04:00:00 | AAPL | Stock | 146.22 | 146.23 | 146.09 | 146.15 | 3177.0 |
| 2021-08-10 04:30:00 | AAPL | Stock | 146.13 | 146.13 | 146.05 | 146.09 | 832.0 |
| 2021-08-10 05:00:00 | AAPL | Stock | 146.09 | 146.09 | 146.06 | 146.06 | 800.0 |
| 2021-08-10 05:30:00 | AAPL | Stock | 146.06 | 146.06 | 146.05 | 146.05 | 1458.0 |
| 2021-08-10 06:00:00 | AAPL | Stock | 146.08 | 146.09 | 146.0 | 146.02 | 2397.0 |
| 2021-08-10 06:30:00 | AAPL | Stock | 146.02 | 146.02 | 145.96 | 145.96 | 1064.0 |
| 2021-08-10 07:00:00 | AAPL | Stock | 146.01 | 149.0 | 146.0 | 146.45 | 196901.0 |
| 2021-08-10 07:30:00 | AAPL | Stock | 146.47 | 146.59 | 146.38 | 146.57 | 31219.0 |
| 2021-08-10 08:00:00 | AAPL | Stock | 146.5001 | 146.75 | 145.725 | 146.48 | 67820.0 |
| 2021-08-10 08:30:00 | AAPL | Stock | 146.48 | 146.58 | 146.3 | 146.37 | 42436.0 |
| 2021-08-10 09:00:00 | AAPL | Stock | 146.37 | 146.54 | 146.265 | 146.46 | 84298.0 |
| 2021-08-10 09:30:00 | AAPL | Stock | 146.46 | 147.71 | 146.18 | 147.425 | 9962788.0 |
| 2021-08-10 10:00:00 | AAPL | Stock | 147.425 | 147.6349 | 146.9 | 146.913 | 5318287.0 |
| 2021-08-10 10:30:00 | AAPL | Stock | 146.92 | 146.92 | 145.63 | 145.915 | 6439124.0 |
| 2021-08-10 11:00:00 | AAPL | Stock | 145.92 | 145.9586 | 145.395 | 145.63 | 4183071.0 |
| 2021-08-10 11:30:00 | AAPL | Stock | 145.62 | 145.78 | 145.46 | 145.62 | 3060870.0 |
| 2021-08-10 12:00:00 | AAPL | Stock | 145.625 | 146.0057 | 145.6101 | 145.8746 | 2189780.0 |
| 2021-08-10 12:30:00 | AAPL | Stock | 145.875 | 145.89 | 145.545 | 145.6 | 1540430.0 |
| 2021-08-10 13:00:00 | AAPL | Stock | 145.6 | 145.76 | 145.495 | 145.545 | 1570261.0 |
| 2021-08-10 13:30:00 | AAPL | Stock | 145.545 | 145.71 | 145.5 | 145.6587 | 1492325.0 |
| 2021-08-10 14:00:00 | AAPL | Stock | 145.655 | 145.67 | 145.3 | 145.52 | 1980073.0 |
| 2021-08-10 14:30:00 | AAPL | Stock | 145.53 | 145.715 | 145.5 | 145.7 | 1630778.0 |
| 2021-08-10 15:00:00 | AAPL | Stock | 145.7 | 145.73 | 145.53 | 145.6661 | 1874235.0 |
| 2021-08-10 15:30:00 | AAPL | Stock | 145.67 | 145.72 | 145.3 | 145.61 | 4884535.0 |
| 2021-08-10 16:00:00 | AAPL | Stock | 145.6 | 145.61 | 145.48 | 145.54 | 9245558.0 |
| 2021-08-10 16:30:00 | AAPL | Stock | 145.55 | 145.6 | 145.55 | 145.57 | 15657.0 |
| 2021-08-10 17:00:00 | AAPL | Stock | 145.58 | 145.67 | 145.57 | 145.65 | 37276.0 |
| 2021-08-10 17:30:00 | AAPL | Stock | 145.66 | 145.67 | 145.63 | 145.65 | 14530.0 |
| 2021-08-10 18:00:00 | AAPL | Stock | 145.63 | 145.67 | 145.59 | 145.59 | 9191.0 |
| 2021-08-10 18:30:00 | AAPL | Stock | 145.59 | 145.62 | 145.57 | 145.58 | 7684.0 |
| 2021-08-10 19:00:00 | AAPL | Stock | 145.59 | 145.59 | 145.52 | 145.55 | 8291.0 |
| 2021-08-10 19:30:00 | AAPL | Stock | 145.54 | 145.66 | 145.5 | 145.6 | 22269.0 |
| 2021-08-10 04:00:00 | MSFT | Stock | 288.3 | 288.9 | 288.3 | 288.74 | 2902.0 |
| 2021-08-10 04:30:00 | MSFT | Stock | 288.85 | 288.85 | 288.85 | 288.85 | 250.0 |
| 2021-08-10 05:00:00 | MSFT | Stock | 288.81 | 289.0 | 288.81 | 289.0 | 2299.0 |
| 2021-08-10 05:30:00 | MSFT | Stock | 289.0 | 289.3 | 289.0 | 289.3 | 2111.0 |
| 2021-08-10 06:00:00 | MSFT | Stock | 289.21 | 289.5 | 289.2 | 289.32 | 1130.0 |
| 2021-08-10 06:30:00 | MSFT | Stock | 289.25 | 289.25 | 289.2 | 289.2 | 200.0 |
| 2021-08-10 07:00:00 | MSFT | Stock | 289.2 | 289.35 | 288.92 | 288.92 | 7432.0 |
| 2021-08-10 07:30:00 | MSFT | Stock | 288.92 | 288.95 | 288.7 | 288.95 | 2098.0 |
| 2021-08-10 08:00:00 | MSFT | Stock | 289.3427 | 289.3427 | 288.8 | 288.93 | 5771.0 |
| 2021-08-10 08:30:00 | MSFT | Stock | 288.9 | 288.98 | 288.88 | 288.9 | 3378.0 |
| 2021-08-10 09:00:00 | MSFT | Stock | 288.86 | 288.9 | 288.69 | 288.77 | 7392.0 |
| 2021-08-10 09:30:00 | MSFT | Stock | 288.76 | 289.21 | 288.05 | 288.9 | 1307903.0 |
| 2021-08-10 10:00:00 | MSFT | Stock | 288.93 | 289.25 | 287.995 | 287.9987 | 847822.0 |
| 2021-08-10 10:30:00 | MSFT | Stock | 287.99 | 287.99 | 285.85 | 286.39 | 1016629.0 |
| 2021-08-10 11:00:00 | MSFT | Stock | 286.37 | 286.37 | 285.2 | 285.7435 | 868997.0 |
| 2021-08-10 11:30:00 | MSFT | Stock | 285.7284 | 286.145 | 285.63 | 285.8301 | 516553.0 |
| 2021-08-10 12:00:00 | MSFT | Stock | 285.83 | 286.5275 | 285.83 | 286.2 | 513838.0 |
| 2021-08-10 12:30:00 | MSFT | Stock | 286.2 | 286.36 | 285.905 | 285.95 | 357086.0 |
> showing 50 of 109,692 rows — these rows as CSV